OI10 - Indexing Issue (OpenInsight 64-bit)
At 19 NOV 2021 10:48:13AM Hank Huizinga wrote:
I am having an indexing issue in OI10 (10.0.8.1) and Universal Driver 5.2r1 and I am looking for troubleshooting advice.
Occasionally, after a new record is added,
The indexing table 0 record is correctly updated but the first field is set to 2.
I have confirmed that only the 0 record exists (there is no 1 or 2 record)
The result is that when the indexes update, the pending index updates are not processed. The 0 record is unchanged.
Manually changing the 2 to a 0 allows the indexes to be processed correctly.
I have also opened the system in the morning and found the 0 record blank except field 1 is set to 2.
Very confused, any advice on where to start troubleshooting is appreciated.
At 19 NOV 2021 11:16AM bob carten wrote:
Hi Hank,
We expect to issue another 10.1 beta in the next few days.
I fixed a few index update issues, including the one you are seeing.
In the meantime you should rebuild the indexes in that table.
run UPDATE_INDEX tablename, '', 1
It should rebuild all the indexes for the table in one pass
More detail:
I've changed the index update process so that it moves whatever was in the 0 to the next node, updates the 0 to point to the last record used, then releases the lock on the 0.The idea is that workstations which are writing records will not wait on a long running index update. I had a bug which could cause dropped transactions. There were some other issues which appeared when there was a large backlog of null valued index items too. The latest release will change to the index server ( revengineHoste.exe /I APPNAME ) so that it only locks the 0 if there are transactions, and it processes all of the index backlog in one go instead of a few transactions at a time. I also set it to that if there are more than 100 rows backed up in the indexing ques for an index it will rebalance the index rather than posting the transactions one at a time.