Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-21720

Automatic indexing doesn't work if the creationdate column on the INDEXQUEUEENTRIES table has values in the future

      This problem only happened in a recently installed instance after restoring a database dump that had (possibly) a different timezone from the running server, so that the table contents got created with a future timestamp, that led to a unexpected behavior on the com.atlassian.confluence.search.lucene.queue.DatabaseIndexTaskQueue where the '<CONF_HOME>/index/.timestamp' file was created with a date in the future. The consequence was that every time the indexing job ran it couldn't retrieve the new items on the queue to be indexed, resulting in a instance where no content was automatically indexed.
      A workaround was re-indexing manually, a definitive solution was correcting the timestamps on the table, removing the '.timestamp' file and restaring the instance.

      Some debug info available at: https://studio.atlassian.com/browse/JST-3712

      Workaround

      http://confluence.atlassian.com/display/CONFKB/Confluence+Fails+to+Process+Index+Queue+Automatically

            [CONFSERVER-21720] Automatic indexing doesn't work if the creationdate column on the INDEXQUEUEENTRIES table has values in the future

            George Varghese made changes -
            QA Demo Status New: Not Needed [ 14332 ]
            QA Kickoff Status New: Not Needed [ 14236 ]
            Resolution New: Low Engagement [ 10300 ]
            Status Original: Gathering Impact [ 12072 ] New: Closed [ 6 ]
            George Varghese made changes -
            Labels Original: affects-server ondemand searching/indexing New: affects-server cleanup-seos-fy25 ondemand searching/indexing
            Renata Dornelas made changes -
            Remote Link Original: This issue links to "Page (Atlassian Documentation)" [ 139465 ]
            SET Analytics Bot made changes -
            UIS Original: 1 New: 2
            SET Analytics Bot made changes -
            UIS Original: 2 New: 1
            SET Analytics Bot made changes -
            UIS Original: 1 New: 2
            SET Analytics Bot made changes -
            UIS Original: 2 New: 1
            Bugfix Automation Bot made changes -
            Support reference count Original: 8 New: 13
            Bugfix Automation Bot made changes -
            Support reference count Original: 13 New: 8
            Tony D. made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 479204 ]

              Unassigned Unassigned
              fcuozzo Felipe Cuozzo (Inactive)
              Affected customers:
              10 This affects my team
              Watchers:
              16 Start watching this issue

                Created:
                Updated:
                Resolved: