INDEXQUEUEENTRIES table not being cleaned despite the index queue clean job being running at 2am every day with no errors

XMLWordPrintable

      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.

              Assignee:
              RyanA
              Reporter:
              Partha
              Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: