The catalogue text rebuild reads one snapshot
- github
- github/openchronology/timeline-app
- commit
- main
- github/athanclark
The rebuild ran oc_event_text under READ COMMITTED. oc_events is volatile, so each of its lookups took a new snapshot: a timeline deleted or saved during the walk (or, for a fork, the timeline it reads through to, whose rows move from live to retired between a fork's two lookups) left a node or moment the walk had already been pointed at missing, and the refresh logged "Broken timeline index". The rebuild now reads in a REPEATABLE READ, READ ONLY transaction, so it finishes on the index it started with; the optimistic update after it then finds a newer revision, or no row, as before. catalogue-text-postgres.mjs holds oc_moments locked so the rebuild stops after reading the root and nodes, deletes the timeline there, and checks nothing is logged. It fails every time without the change. Closes #261. Co-Authored-By: Claude Opus 5.5 Claude-Session: https://claude.ai/code/session_011fFY8eruEi1xAkkMBni13B https://github.com/openchronology/timeline-app/commit/90884cc3df1a9f88a1d94d7c5a17abd83e98332b
Related
Open The catalogue text rebuild reads one snapshot in the timeline