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

Index updates can get lost on Oracle RAC

    XMLWordPrintable

Details

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

              drizzuto David Rizzuto
              onevalainen Olli Nevalainen
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: