-
Bug
-
Resolution: Fixed
-
Medium
-
5.6.4
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
- Change SEQ_JOURNAL_ENTRY_ID sequence to be ordered: ALTER SEQUENCE SEQ_JOURNAL_ENTRY_ID ORDER;
- Rebuild indexes.
- mentioned in
-
Page No Confluence page found with the given URL.
-
Page No Confluence page found with the given URL.
-
Page No Confluence page found with the given URL.
-
Page No Confluence page found with the given URL.
-
Page No Confluence page found with the given URL.
-
Page Loading...
-
Page Loading...
[CONFSERVER-35764] Index updates can get lost on Oracle RAC
Remote Link | Original: This issue links to "Page (Atlassian Documentation)" [ 87024 ] |
Workflow | Original: JAC Bug Workflow v3 [ 2895266 ] | New: CONFSERVER Bug Workflow v4 [ 2987657 ] |
Workflow | Original: JAC Bug Workflow v2 [ 2783906 ] | New: JAC Bug Workflow v3 [ 2895266 ] |
Status | Original: Resolved [ 5 ] | New: Closed [ 6 ] |
Workflow | Original: JAC Bug Workflow [ 2735900 ] | New: JAC Bug Workflow v2 [ 2783906 ] |
Workflow | Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2377567 ] | New: JAC Bug Workflow [ 2735900 ] |
Workflow | Original: Confluence Workflow - Public Facing - Restricted v5 [ 2266423 ] | New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2377567 ] |
Workflow | Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2214196 ] | New: Confluence Workflow - Public Facing - Restricted v5 [ 2266423 ] |
Workflow | Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2163962 ] | New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2214196 ] |
Workflow | Original: Confluence Workflow - Public Facing - Restricted v5 [ 1953197 ] | New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2163962 ] |
Workflow | Original: Confluence Workflow - Public Facing - Restricted v3 [ 1746126 ] | New: Confluence Workflow - Public Facing - Restricted v5 [ 1953197 ] |