-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Low
-
Affects Version/s: 2.10
-
Component/s: None
The INDEXQUEUEENTRIES should be cleaned at 2am every day, when the index queue clean job runs.
The job basically runs the query
delete from INDEXQUEUEENTRIES where CREATIONDATE < ?"
Where ? is a date which is 2 days earlier (essentially remove all enteries more than 2 days old).
However while this runs, the transaction is not committed immediately and in some customer cases it never gets committed and hence the table is never cleaned.