Hi, On February 12, 2022 3:57:28 PM PST, Thomas Munro <thomas.mu...@gmail.com> wrote: >Hi, > >I don't know what happened here, but I my little script that scrapes >for build farm assertion failures hasn't seen this one before now. >It's on a 15 year old macOS release and compiled with 15 year old GCC >version, for some added mystery. > >https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=locust&dt=2022-02-12%2022%3A07%3A21 > >2022-02-13 00:09:52.859 CET [92423:92] pg_regress/replorigin >STATEMENT: SELECT data FROM >pg_logical_slot_get_changes('regression_slot', NULL, NULL, >'include-xids', '0', 'skip-empty-xacts', '1', 'include-sequences', >'0'); >TRAP: FailedAssertion("prev_first_lsn < cur_txn->first_lsn", File: >"reorderbuffer.c", Line: 1173, PID: 92423) >0 postgres 0x00592dd0 ExceptionalCondition + >160\\0 >1 postgres 0x00391c40 >ReorderBufferGetRelids + 304\\0 >2 postgres 0x00394794 >ReorderBufferAllocate + 1044\\0 >3 postgres 0x003834dc heap_decode + 76\\0 >4 postgres 0x003829c8 >LogicalDecodingProcessRecord + 168\\0 >5 postgres 0x0038a1d4 >pg_logical_emit_message_text + 1876\\0 >6 postgres 0x00241810 >ExecMakeTableFunctionResult + 576\\0 >7 postgres 0x002576c4 >ExecInitFunctionScan + 1444\\0 >8 postgres 0x00242140 ExecScan + 896\\0 >9 postgres 0x002397cc standard_ExecutorRun + >540\\0 >10 postgres 0x00427940 >EnsurePortalSnapshotExists + 832\\0 >11 postgres 0x00428e84 PortalRun + 644\\0 >12 postgres 0x004252e0 pg_plan_queries + 3232\\0 >13 postgres 0x00426270 PostgresMain + 3424\\0 >14 postgres 0x0036b9ec PostmasterMain + 8060\\0 >15 postgres 0x0029f24c main + 1356\\0 >16 postgres 0x00002524 start + 68\\0
I think that may be the bug that Tomas fixed a short while ago. He said the skip empty xacts stuff didn't yet work for sequences. That's only likely to be hit in slower machines... Andres -- Sent from my Android device with K-9 Mail. Please excuse my brevity.
