Isolation and actual transaction modes¶
v4.2.5 supports RC (Read Committed) and SI (Snapshot Isolation). Pessimistic mode defaults to RC, optimistic to SI, subject to runtime configuration. The compatible REPEATABLE-READ string in transaction_isolation/tx_isolation does not independently change actual isolation.
Read versions¶
RC uses the required statement snapshot; SI retains a transaction snapshot. Transaction ID identifies work, SnapshotTS bounds visibility, and PrepareTS/CommitTS order preparation/commit. They are different values. Reads combine visible objects, Logtail state, deletions and workspace.
Commit and errors¶
WAL establishes small-write durability; object flush may follow later. Distinguish statement errors, transaction aborts and unknown commit outcomes instead of inferring rollback from every error.
See two-session and cross-CN labs, and visibility/errors.