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

            Renata Dornelas made changes -
            Remote Link Original: This issue links to "Page (Atlassian Documentation)" [ 87024 ]
            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2895266 ] New: CONFSERVER Bug Workflow v4 [ 2987657 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2783906 ] New: JAC Bug Workflow v3 [ 2895266 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2735900 ] New: JAC Bug Workflow v2 [ 2783906 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2377567 ] New: JAC Bug Workflow [ 2735900 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2266423 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2377567 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2214196 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2266423 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2163962 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2214196 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 1953197 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2163962 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v3 [ 1746126 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 1953197 ]

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

                Created:
                Updated:
                Resolved: