On 6/6/23 11:00, Alexander Lakhin wrote: > Hello, > ...> With the debug logging added inside AssertTXNLsnOrder() I see: > ctx->snapshot_builder->start_decoding_at: 209807224, > ctx->reader->EndRecPtr: 210043072, > SnapBuildXactNeedsSkip(ctx->snapshot_builder, ctx->reader->EndRecPtr): 0 > and inside the loop: > cur_txn->first_lsn: 209792872 > cur_txn->first_lsn: 209975744 > cur_txn->first_lsn: 210043008 > cur_txn->first_lsn: 210043008 > and it triggers the Assert. >
So what's the prev_first_lsn value for these first_lsn values? How does it change over time? Did you try looking at the pg_waldump for these positions? regards -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
