EV8 - Deleted items waiting to be deleted from indexes
Need some help here from folks that might know more about indexing than i do ;)
We recently upgraded our EV site servers from 7.5 sp4 to 8.0 sp5. The upgrade went very smoothly, and nearly everything is working without issue. However, we started seeing a Critical Alert in the console that corresponded to event 41022 in the event logs on one of our servers. Simply put, the system is seeing deleted items that have no been deleted from indexes.
Originally, there were 22 user's archives with uncommitted deletes as noted in the JournalDelete table of the Vault Store DB. A total of 245195 records. Just a few days ago, one of the archives apparently processed the data, because now there are 21 archives and 244805 records.
I have seen the record count in the JournalDelete table go up and come back to the same amount throughout the day as various operations take place, but the base number of records and associated archives have not changed, with the exception of that 1 archive that processed.
Most of those users had multiple index volumes with ranges of 1-0 and 1 - not set. I rebuilt those index volumes to correct any corruption on them.
The odd thing is that I can update or rebuild these user's indexes, and each time the process completes, it states that xxx items were deleted - which matches the count of items for that user in the JournalDelete table. If I run the update or rebuild again some time later, it says it again says the same number of items have been deleted.
I am currently working with support to try to isolate the cause of the matter, but we are not having any luck identifying the problem.
We have tried changing the SQL compatability down to SQL200 and back up to SQL 2005 (no SQL upgrade had occured, but they suggested trying it) with no luck.
I have also verified that the system is not in backup mode.
Any insights or suggestions would be greatly appreciated.