2024-04-01 10:38:03.157 UTC [33046][postmaster] LOG: starting PostgreSQL 17devel on x86_64-linux, compiled by gcc-10.2.1, 64-bit 2024-04-01 10:38:03.157 UTC [33046][postmaster] LOG: listening on Unix socket "/tmp/fk8YH9NRQU/.s.PGSQL.57757" 2024-04-01 10:38:03.165 UTC [33061][startup] LOG: database system was interrupted; last known up at 2024-04-01 10:38:02 UTC 2024-04-01 10:38:03.165 UTC [33061][startup] LOG: starting backup recovery with redo LSN 0/2000028, checkpoint LSN 0/2000080, on timeline ID 1 2024-04-01 10:38:03.165 UTC [33061][startup] LOG: entering standby mode 2024-04-01 10:38:03.165 UTC [33061][startup] LOG: redo starts at 0/2000028 2024-04-01 10:38:03.165 UTC [33061][startup] LOG: completed backup recovery with redo LSN 0/2000028 and end LSN 0/2000120 2024-04-01 10:38:03.166 UTC [33061][startup] LOG: consistent recovery state reached at 0/2000120 2024-04-01 10:38:03.166 UTC [33046][postmaster] LOG: database system is ready to accept read-only connections 2024-04-01 10:38:03.195 UTC [33067][walreceiver] LOG: started streaming WAL from primary at 0/3000000 on timeline 1 2024-04-01 10:38:03.452 UTC [33165][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-01 10:38:03.457 UTC [33165][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/043_wal_replay_wait/data/t_043_wal_replay_wait_standby_data/pgdata/pg_hba.conf:117) 2024-04-01 10:38:03.457 UTC [33165][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=postgres application_name=043_wal_replay_wait.pl 2024-04-01 10:38:03.479 UTC [33165][client backend] [043_wal_replay_wait.pl][0/2:0] LOG: statement: CALL pg_wal_replay_wait('0/30022A8', 1000000); 2024-04-01 10:38:04.317 UTC [33165][client backend] [043_wal_replay_wait.pl][0/3:0] LOG: statement: SELECT pg_lsn_cmp(pg_last_wal_replay_lsn(), '0/30022A8'::pg_lsn); 2024-04-01 10:38:04.320 UTC [33165][client backend] [043_wal_replay_wait.pl][:0] LOG: disconnection: session time: 0:00:00.870 user=postgres database=postgres host=[local] 2024-04-01 10:38:04.593 UTC [33291][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-01 10:38:04.594 UTC [33291][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/043_wal_replay_wait/data/t_043_wal_replay_wait_standby_data/pgdata/pg_hba.conf:117) 2024-04-01 10:38:04.594 UTC [33291][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=postgres application_name=043_wal_replay_wait.pl 2024-04-01 10:38:04.606 UTC [33291][client backend] [043_wal_replay_wait.pl][1/2:0] LOG: statement: CALL pg_wal_replay_wait('0/3002550'); TRAP: failed Assert("MyProc->xmin == InvalidTransactionId"), File: "../src/backend/commands/waitlsn.c", Line: 342, PID: 33291 postgres: standby: postgres postgres [local] CALL(ExceptionalCondition+0x56)[0x55da090c326e] postgres: standby: postgres postgres [local] CALL(+0xc56c78)[0x55da089d3c78] postgres: standby: postgres postgres [local] CALL(ExecuteCallStmt+0x7cd)[0x55da08916cd9] postgres: standby: postgres postgres [local] CALL(standard_ProcessUtility+0xbb9)[0x55da08e21a95] postgres: standby: postgres postgres [local] CALL(ProcessUtility+0x152)[0x55da08e2221a] postgres: standby: postgres postgres [local] CALL(+0x10a0978)[0x55da08e1d978] postgres: standby: postgres postgres [local] CALL(+0x10a104e)[0x55da08e1e04e] postgres: standby: postgres postgres [local] CALL(PortalRun+0x24d)[0x55da08e1e6f3] postgres: standby: postgres postgres [local] CALL(+0x109a96c)[0x55da08e1796c] postgres: standby: postgres postgres [local] CALL(PostgresMain+0x8ee)[0x55da08e1a724] postgres: standby: postgres postgres [local] CALL(BackendMain+0x92)[0x55da08e10edb] postgres: standby: postgres postgres [local] CALL(postmaster_child_launch+0x188)[0x55da08cbb2eb] postgres: standby: postgres postgres [local] CALL(+0xf4446b)[0x55da08cc146b] postgres: standby: postgres postgres [local] CALL(+0xf44a19)[0x55da08cc1a19] postgres: standby: postgres postgres [local] CALL(BackgroundWorkerInitializeConnection+0x0)[0x55da08cc343b] postgres: standby: postgres postgres [local] CALL(main+0x393)[0x55da08aeb1f4] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xea)[0x7fa3fbf0ad0a] postgres: standby: postgres postgres [local] CALL(_start+0x2a)[0x55da0864921a] 2024-04-01 10:38:04.700 UTC [33046][postmaster] LOG: server process (PID 33291) was terminated by signal 6: Aborted 2024-04-01 10:38:04.700 UTC [33046][postmaster] DETAIL: Failed process was running: CALL pg_wal_replay_wait('0/3002550'); 2024-04-01 10:38:04.700 UTC [33046][postmaster] LOG: terminating any other active server processes 2024-04-01 10:38:04.703 UTC [33046][postmaster] LOG: shutting down because restart_after_crash is off 2024-04-01 10:38:04.703 UTC [33046][postmaster] LOG: database system is shut down