We have the following problem with our Confluence installation: Since we changed the database from MySQL to PostgreSQL using pg_loader and updated to Confluence 8.8.0, everything is no longer displayed under "All updates". A reindex fixes the problem, but is not a permanent solution. We see the following entry in the logs:
2024-02-22 14:36:19,896 WARN [http-nio-8090-exec-21] [confluence.impl.journal.DefaultJournalManager] enqueue Newly enqueued entry in journal [change_index] has an ID [26472] that should have been higher than the journal state store's most-recent-id [1326766]. it is likely that this node's journal state store is corrupt.
-- url: /rest/api/content/162824698 | userName: user | referer: https://confluence.example.com/pages/resumedraft.action?draftId=162824699&draftShareId=0429b105-4c38-45e6-89af-1bdd1d161c85& | traceId: 6c703bac34d296d3
According to the documentation, rebuilding the index from scratch should solve the problem, but it doesn't in our case. We have also checked the data in the PostgreSQL database (especially the data in the documentation sequence), but cannot find any errors there.
Is there anything else we can do apart from the documentation?