The Problem

Occasionally, when using Venio, you may find that an indexing task becomes stuck. When this happens, the status might remain as 'Merging to main index' without showing any progress.

When an indexing task becomes stuck and the system reports that "Index at the <given location> is locked" and "Temporary index does not belong to the current index does not belong to the current job," the issue could be caused by a few things:

1. Concurrent processes: The indexing task could be clashing with other processes running concurrently that are also trying to access or modify the same index. This might lead to the index becoming 'locked,' preventing further progress.
2. Interrupted tasks: If a previous indexing task was interrupted or didn't complete successfully, it might leave the index in a state that prevents new tasks from completing. For example, the 'temporary index' message suggests that a previous task may have created a temporary index that wasn't cleaned up correctly.
3. Hardware or System Failure: In rare cases, a hardware issue (such as disk read/write errors) or a system failure (unexpected shutdown or system crash) could potentially interfere with the indexing process, causing it to become stuck.

You may see the following messages in your SQL project database when running the query below:

Use Project DB
Select *
from tbl_ lg_genericlog
Order by Logid desc

⦁ Index at the <given location> is locked.
⦁ Temporary index does not belong to the current index does not belongs to the current job

Resolution or Workaround

If you encounter this issue, follow these steps. This suggested workaround involves renaming the index folder and running a manual index. This effectively resets the index, which would likely clear up any issues caused by interrupted tasks or temporary indexes left over from previous tasks.

1. Navigate to the index location specified in the error message.
2. Rename the folder at this location.
3. Run the manual index. This will recreate the indexing folder for that media.

You can find the index path for all media in your project using the following SQL query:

Select * 
from tbl_ex_Media

As always, for any persistent or recurring issues, it would be wise to reach out to Venio's support team for further assistance.