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

Index updates can get lost on Oracle RAC

XMLWordPrintable

      Some index updates get lost when using Oracle Database with Real Application Clusters (RAC):

      enqueue Newly enqueued entry in journal [main_index] has an ID [423954] that should have been higher than the journal state store's most-recent-id [423965]. it is likely that this node's journal state store is corrupt.

      The reason for this error is that sequences in Oracle RAC are not sequential by default.

      Workaround

      1. Change SEQ_JOURNAL_ENTRY_ID sequence to be ordered: ALTER SEQUENCE SEQ_JOURNAL_ENTRY_ID ORDER;
      2. Rebuild indexes.

            [CONFSERVER-35764] Index updates can get lost on Oracle RAC

              drizzuto David Rizzuto
              onevalainen Olli Nevalainen
              Affected customers:
              0 This affects my team
              Watchers:
              7 Start watching this issue

                Created:
                Updated:
                Resolved: