Index updates can get lost on Oracle RAC

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.