2025-12-28 15:02:08.838 UTC postmaster[9772] LOG: starting PostgreSQL 19devel on x86_64-netbsd, compiled by gcc-10.5.0, 64-bit 2025-12-28 15:02:08.839 UTC postmaster[9772] LOG: listening on Unix socket "/tmp/GyqN4nrEcx/.s.PGSQL.26295" 2025-12-28 15:02:08.850 UTC startup[2916] LOG: database system was shut down at 2025-12-28 15:01:08 UTC 2025-12-28 15:02:08.863 UTC postmaster[9772] LOG: database system is ready to accept connections 2025-12-28 15:02:08.916 UTC unrecognized[9141] [unknown] LOG: connection received: host=[local] 2025-12-28 15:02:08.918 UTC walsender[9141] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/recovery/009_twophase/data/t_009_twophase_london_data/pgdata/pg_hba.conf:124) 2025-12-28 15:02:08.918 UTC walsender[9141] [unknown] LOG: replication connection authorized: user=postgres application_name=009_twophase.pl 2025-12-28 15:02:08.919 UTC walsender[9141] 009_twophase.pl LOG: connection ready: setup total=5.384 ms, fork=1.013 ms, authentication=0.648 ms 2025-12-28 15:02:08.920 UTC walsender[9141] 009_twophase.pl LOG: received replication command: SHOW data_directory_mode 2025-12-28 15:02:08.920 UTC walsender[9141] 009_twophase.pl STATEMENT: SHOW data_directory_mode 2025-12-28 15:02:08.920 UTC walsender[9141] 009_twophase.pl LOG: received replication command: SHOW wal_segment_size 2025-12-28 15:02:08.920 UTC walsender[9141] 009_twophase.pl STATEMENT: SHOW wal_segment_size 2025-12-28 15:02:08.920 UTC walsender[9141] 009_twophase.pl LOG: received replication command: IDENTIFY_SYSTEM 2025-12-28 15:02:08.920 UTC walsender[9141] 009_twophase.pl STATEMENT: IDENTIFY_SYSTEM 2025-12-28 15:02:08.920 UTC walsender[9141] 009_twophase.pl LOG: received replication command: BASE_BACKUP ( LABEL 'pg_basebackup base backup', PROGRESS, CHECKPOINT 'fast', WAIT 0, MANIFEST 'yes', TARGET 'client') 2025-12-28 15:02:08.920 UTC walsender[9141] 009_twophase.pl STATEMENT: BASE_BACKUP ( LABEL 'pg_basebackup base backup', PROGRESS, CHECKPOINT 'fast', WAIT 0, MANIFEST 'yes', TARGET 'client') 2025-12-28 15:02:08.925 UTC checkpointer[8574] LOG: checkpoint starting: fast force wait 2025-12-28 15:02:08.942 UTC checkpointer[8574] LOG: checkpoint complete: wrote 0 buffers (0.0%), wrote 3 SLRU buffers; 0 WAL file(s) added, 0 removed, 1 recycled; write=0.001 s, sync=0.001 s, total=0.017 s; sync files=0, longest=0.000 s, average=0.000 s; distance=8664 kB, estimate=8664 kB; lsn=0/02000080, redo lsn=0/02000028 2025-12-28 15:02:08.957 UTC unrecognized[9581] [unknown] LOG: connection received: host=[local] 2025-12-28 15:02:08.960 UTC walsender[9581] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/recovery/009_twophase/data/t_009_twophase_london_data/pgdata/pg_hba.conf:124) 2025-12-28 15:02:08.960 UTC walsender[9581] [unknown] LOG: replication connection authorized: user=postgres application_name=009_twophase.pl 2025-12-28 15:02:08.962 UTC walsender[9581] 009_twophase.pl LOG: connection ready: setup total=6.513 ms, fork=1.364 ms, authentication=0.654 ms 2025-12-28 15:02:08.962 UTC walsender[9581] 009_twophase.pl LOG: received replication command: SHOW data_directory_mode 2025-12-28 15:02:08.962 UTC walsender[9581] 009_twophase.pl STATEMENT: SHOW data_directory_mode 2025-12-28 15:02:08.962 UTC walsender[9581] 009_twophase.pl LOG: received replication command: CREATE_REPLICATION_SLOT "pg_basebackup_9581" TEMPORARY PHYSICAL ( RESERVE_WAL) 2025-12-28 15:02:08.962 UTC walsender[9581] 009_twophase.pl STATEMENT: CREATE_REPLICATION_SLOT "pg_basebackup_9581" TEMPORARY PHYSICAL ( RESERVE_WAL) 2025-12-28 15:02:08.962 UTC walsender[9581] 009_twophase.pl LOG: released physical replication slot "pg_basebackup_9581" 2025-12-28 15:02:08.962 UTC walsender[9581] 009_twophase.pl STATEMENT: CREATE_REPLICATION_SLOT "pg_basebackup_9581" TEMPORARY PHYSICAL ( RESERVE_WAL) 2025-12-28 15:02:08.977 UTC walsender[9581] 009_twophase.pl LOG: received replication command: IDENTIFY_SYSTEM 2025-12-28 15:02:08.977 UTC walsender[9581] 009_twophase.pl STATEMENT: IDENTIFY_SYSTEM 2025-12-28 15:02:08.980 UTC walsender[9581] 009_twophase.pl LOG: received replication command: START_REPLICATION SLOT "pg_basebackup_9581" 0/02000000 TIMELINE 1 2025-12-28 15:02:08.980 UTC walsender[9581] 009_twophase.pl STATEMENT: START_REPLICATION SLOT "pg_basebackup_9581" 0/02000000 TIMELINE 1 2025-12-28 15:02:08.980 UTC walsender[9581] 009_twophase.pl LOG: acquired physical replication slot "pg_basebackup_9581" 2025-12-28 15:02:08.980 UTC walsender[9581] 009_twophase.pl STATEMENT: START_REPLICATION SLOT "pg_basebackup_9581" 0/02000000 TIMELINE 1 2025-12-28 15:02:09.190 UTC walsender[9581] 009_twophase.pl LOG: released physical replication slot "pg_basebackup_9581" 2025-12-28 15:02:09.190 UTC walsender[9581] 009_twophase.pl STATEMENT: START_REPLICATION SLOT "pg_basebackup_9581" 0/02000000 TIMELINE 1 2025-12-28 15:02:09.191 UTC walsender[9141] 009_twophase.pl LOG: disconnection: session time: 0:00:00.275 user=postgres database= host=[local] 2025-12-28 15:02:09.194 UTC walsender[9581] 009_twophase.pl LOG: disconnection: session time: 0:00:00.237 user=postgres database= host=[local] 2025-12-28 15:02:09.537 UTC unrecognized[3024] [unknown] LOG: connection received: host=[local] 2025-12-28 15:02:09.540 UTC walsender[3024] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/recovery/009_twophase/data/t_009_twophase_london_data/pgdata/pg_hba.conf:124) 2025-12-28 15:02:09.540 UTC walsender[3024] [unknown] LOG: replication connection authorized: user=postgres application_name=paris 2025-12-28 15:02:09.541 UTC walsender[3024] paris LOG: connection ready: setup total=11.247 ms, fork=6.643 ms, authentication=0.550 ms 2025-12-28 15:02:09.541 UTC walsender[3024] paris LOG: received replication command: IDENTIFY_SYSTEM 2025-12-28 15:02:09.541 UTC walsender[3024] paris STATEMENT: IDENTIFY_SYSTEM 2025-12-28 15:02:09.542 UTC walsender[3024] paris LOG: received replication command: START_REPLICATION 0/03000000 TIMELINE 1 2025-12-28 15:02:09.542 UTC walsender[3024] paris STATEMENT: START_REPLICATION 0/03000000 TIMELINE 1 2025-12-28 15:02:09.579 UTC unrecognized[23113] [unknown] LOG: connection received: host=[local] 2025-12-28 15:02:09.581 UTC client backend[23113] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/recovery/009_twophase/data/t_009_twophase_london_data/pgdata/pg_hba.conf:117) 2025-12-28 15:02:09.581 UTC client backend[23113] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=009_twophase.pl 2025-12-28 15:02:09.597 UTC client backend[23113] 009_twophase.pl LOG: connection ready: setup total=19.766 ms, fork=1.069 ms, authentication=0.570 ms 2025-12-28 15:02:09.597 UTC client backend[23113] 009_twophase.pl LOG: statement: SELECT pg_reload_conf() 2025-12-28 15:02:09.598 UTC postmaster[9772] LOG: received SIGHUP, reloading configuration files 2025-12-28 15:02:09.600 UTC client backend[23113] 009_twophase.pl LOG: disconnection: session time: 0:00:00.021 user=postgres database=postgres host=[local] 2025-12-28 15:02:09.601 UTC postmaster[9772] LOG: parameter "synchronous_standby_names" changed to "paris" 2025-12-28 15:02:09.662 UTC walsender[3024] paris LOG: standby "paris" is now a synchronous standby with priority 1 2025-12-28 15:02:09.662 UTC walsender[3024] paris STATEMENT: START_REPLICATION 0/03000000 TIMELINE 1 2025-12-28 15:02:09.698 UTC unrecognized[20364] [unknown] LOG: connection received: host=[local] 2025-12-28 15:02:09.701 UTC client backend[20364] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/recovery/009_twophase/data/t_009_twophase_london_data/pgdata/pg_hba.conf:117) 2025-12-28 15:02:09.701 UTC client backend[20364] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=009_twophase.pl 2025-12-28 15:02:09.705 UTC client backend[20364] 009_twophase.pl LOG: connection ready: setup total=8.967 ms, fork=1.203 ms, authentication=0.970 ms 2025-12-28 15:02:09.706 UTC client backend[20364] 009_twophase.pl LOG: statement: CREATE TABLE t_009_tbl (id int, msg text) 2025-12-28 15:02:09.748 UTC client backend[20364] 009_twophase.pl LOG: disconnection: session time: 0:00:00.050 user=postgres database=postgres host=[local] 2025-12-28 15:02:09.779 UTC unrecognized[26450] [unknown] LOG: connection received: host=[local] 2025-12-28 15:02:09.782 UTC client backend[26450] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/recovery/009_twophase/data/t_009_twophase_london_data/pgdata/pg_hba.conf:117) 2025-12-28 15:02:09.782 UTC client backend[26450] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=009_twophase.pl 2025-12-28 15:02:09.786 UTC client backend[26450] 009_twophase.pl LOG: connection ready: setup total=8.713 ms, fork=1.220 ms, authentication=0.852 ms 2025-12-28 15:02:09.786 UTC client backend[26450] 009_twophase.pl LOG: statement: BEGIN; 2025-12-28 15:02:09.787 UTC client backend[26450] 009_twophase.pl LOG: statement: INSERT INTO t_009_tbl VALUES (1, 'issued to london'); 2025-12-28 15:02:09.788 UTC client backend[26450] 009_twophase.pl LOG: statement: SAVEPOINT s1; 2025-12-28 15:02:09.788 UTC client backend[26450] 009_twophase.pl LOG: statement: INSERT INTO t_009_tbl VALUES (2, 'issued to london'); 2025-12-28 15:02:09.788 UTC client backend[26450] 009_twophase.pl LOG: statement: PREPARE TRANSACTION 'xact_009_1'; 2025-12-28 15:02:09.789 UTC client backend[26450] 009_twophase.pl LOG: statement: BEGIN; 2025-12-28 15:02:09.789 UTC client backend[26450] 009_twophase.pl LOG: statement: INSERT INTO t_009_tbl VALUES (3, 'issued to london'); 2025-12-28 15:02:09.789 UTC client backend[26450] 009_twophase.pl LOG: statement: SAVEPOINT s1; 2025-12-28 15:02:09.790 UTC client backend[26450] 009_twophase.pl LOG: statement: INSERT INTO t_009_tbl VALUES (4, 'issued to london'); 2025-12-28 15:02:09.790 UTC client backend[26450] 009_twophase.pl LOG: statement: PREPARE TRANSACTION 'xact_009_2'; 2025-12-28 15:02:09.791 UTC client backend[26450] 009_twophase.pl LOG: disconnection: session time: 0:00:00.013 user=postgres database=postgres host=[local] 2025-12-28 15:02:09.806 UTC postmaster[9772] LOG: received fast shutdown request 2025-12-28 15:02:09.806 UTC postmaster[9772] LOG: aborting any active transactions 2025-12-28 15:02:09.812 UTC postmaster[9772] LOG: background worker "logical replication launcher" (PID 24047) exited with exit code 1 2025-12-28 15:02:09.812 UTC checkpointer[8574] LOG: shutting down 2025-12-28 15:02:09.812 UTC checkpointer[8574] LOG: checkpoint starting: shutdown fast 2025-12-28 15:02:09.814 UTC checkpointer[8574] LOG: 2 two-phase state files were written for long-running prepared transactions 2025-12-28 15:02:09.814 UTC checkpointer[8574] LOG: checkpoint complete: wrote 25 buffers (19.5%), wrote 2 SLRU buffers; 0 WAL file(s) added, 0 removed, 1 recycled; write=0.001 s, sync=0.001 s, total=0.002 s; sync files=0, longest=0.000 s, average=0.000 s; distance=16493 kB, estimate=16493 kB; lsn=0/0301B580, redo lsn=0/0301B580 2025-12-28 15:02:09.814 UTC walsender[3024] paris LOG: disconnection: session time: 0:00:00.278 user=postgres database= host=[local] 2025-12-28 15:02:09.839 UTC postmaster[9772] LOG: database system is shut down 2025-12-28 15:02:10.002 UTC postmaster[8549] LOG: starting PostgreSQL 19devel on x86_64-netbsd, compiled by gcc-10.5.0, 64-bit 2025-12-28 15:02:10.002 UTC postmaster[8549] LOG: listening on Unix socket "/tmp/GyqN4nrEcx/.s.PGSQL.26295" 2025-12-28 15:02:10.007 UTC startup[23702] LOG: database system was shut down at 2025-12-28 15:02:09 UTC 2025-12-28 15:02:10.011 UTC startup[23702] LOG: recovering prepared transaction 757 of epoch 0 from shared memory 2025-12-28 15:02:10.011 UTC startup[23702] LOG: recovering prepared transaction 759 of epoch 0 from shared memory 2025-12-28 15:02:10.016 UTC postmaster[8549] LOG: database system is ready to accept connections 2025-12-28 15:02:10.090 UTC unrecognized[21282] [unknown] LOG: connection received: host=[local] 2025-12-28 15:02:10.093 UTC client backend[21282] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/recovery/009_twophase/data/t_009_twophase_london_data/pgdata/pg_hba.conf:117) 2025-12-28 15:02:10.093 UTC client backend[21282] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=009_twophase.pl 2025-12-28 15:02:10.112 UTC client backend[21282] 009_twophase.pl LOG: connection ready: setup total=18.521 ms, fork=0.969 ms, authentication=0.704 ms 2025-12-28 15:02:10.112 UTC client backend[21282] 009_twophase.pl LOG: statement: COMMIT PREPARED 'xact_009_1' 2025-12-28 15:02:10.347 UTC unrecognized[7898] [unknown] LOG: connection received: host=[local] 2025-12-28 15:02:10.351 UTC walsender[7898] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/recovery/009_twophase/data/t_009_twophase_london_data/pgdata/pg_hba.conf:124) 2025-12-28 15:02:10.351 UTC walsender[7898] [unknown] LOG: replication connection authorized: user=postgres application_name=paris 2025-12-28 15:02:10.352 UTC walsender[7898] paris LOG: connection ready: setup total=6.719 ms, fork=1.032 ms, authentication=0.865 ms 2025-12-28 15:02:10.352 UTC walsender[7898] paris LOG: received replication command: IDENTIFY_SYSTEM 2025-12-28 15:02:10.352 UTC walsender[7898] paris STATEMENT: IDENTIFY_SYSTEM 2025-12-28 15:02:10.353 UTC walsender[7898] paris LOG: received replication command: START_REPLICATION 0/03000000 TIMELINE 1 2025-12-28 15:02:10.353 UTC walsender[7898] paris STATEMENT: START_REPLICATION 0/03000000 TIMELINE 1 2025-12-28 15:02:10.355 UTC walsender[7898] paris LOG: standby "paris" is now a synchronous standby with priority 1 2025-12-28 15:02:10.355 UTC walsender[7898] paris STATEMENT: START_REPLICATION 0/03000000 TIMELINE 1 2025-12-28 15:02:10.356 UTC client backend[21282] 009_twophase.pl LOG: disconnection: session time: 0:00:00.267 user=postgres database=postgres host=[local] 2025-12-28 15:02:10.386 UTC unrecognized[17640] [unknown] LOG: connection received: host=[local] 2025-12-28 15:02:10.389 UTC client backend[17640] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/recovery/009_twophase/data/t_009_twophase_london_data/pgdata/pg_hba.conf:117) 2025-12-28 15:02:10.389 UTC client backend[17640] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=009_twophase.pl 2025-12-28 15:02:10.393 UTC client backend[17640] 009_twophase.pl LOG: connection ready: setup total=8.400 ms, fork=1.143 ms, authentication=0.756 ms 2025-12-28 15:02:10.393 UTC client backend[17640] 009_twophase.pl LOG: statement: ROLLBACK PREPARED 'xact_009_2' 2025-12-28 15:02:10.394 UTC client backend[17640] 009_twophase.pl LOG: disconnection: session time: 0:00:00.008 user=postgres database=postgres host=[local] 2025-12-28 15:02:10.419 UTC unrecognized[22576] [unknown] LOG: connection received: host=[local] 2025-12-28 15:02:10.422 UTC client backend[22576] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/recovery/009_twophase/data/t_009_twophase_london_data/pgdata/pg_hba.conf:117) 2025-12-28 15:02:10.422 UTC client backend[22576] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=009_twophase.pl 2025-12-28 15:02:10.427 UTC client backend[22576] 009_twophase.pl LOG: connection ready: setup total=9.865 ms, fork=1.073 ms, authentication=0.574 ms 2025-12-28 15:02:10.428 UTC client backend[22576] 009_twophase.pl LOG: statement: CHECKPOINT; 2025-12-28 15:02:10.428 UTC checkpointer[2893] LOG: checkpoint starting: fast force wait 2025-12-28 15:02:10.430 UTC checkpointer[2893] LOG: checkpoint complete: wrote 3 buffers (2.3%), wrote 3 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.002 s; sync files=0, longest=0.000 s, average=0.000 s; distance=17 kB, estimate=17 kB; lsn=0/0301FB50, redo lsn=0/0301FAF8 2025-12-28 15:02:10.430 UTC client backend[22576] 009_twophase.pl LOG: statement: BEGIN; 2025-12-28 15:02:10.431 UTC client backend[22576] 009_twophase.pl LOG: statement: INSERT INTO t_009_tbl VALUES (5, 'issued to london'); 2025-12-28 15:02:10.437 UTC client backend[22576] 009_twophase.pl LOG: statement: SAVEPOINT s1; 2025-12-28 15:02:10.437 UTC client backend[22576] 009_twophase.pl LOG: statement: INSERT INTO t_009_tbl VALUES (6, 'issued to london'); 2025-12-28 15:02:10.437 UTC client backend[22576] 009_twophase.pl LOG: statement: PREPARE TRANSACTION 'xact_009_3'; 2025-12-28 15:02:10.438 UTC client backend[22576] 009_twophase.pl LOG: statement: BEGIN; 2025-12-28 15:02:10.438 UTC client backend[22576] 009_twophase.pl LOG: statement: INSERT INTO t_009_tbl VALUES (7, 'issued to london'); 2025-12-28 15:02:10.438 UTC client backend[22576] 009_twophase.pl LOG: statement: SAVEPOINT s1; 2025-12-28 15:02:10.438 UTC client backend[22576] 009_twophase.pl LOG: statement: INSERT INTO t_009_tbl VALUES (8, 'issued to london'); 2025-12-28 15:02:10.438 UTC client backend[22576] 009_twophase.pl LOG: statement: PREPARE TRANSACTION 'xact_009_4'; 2025-12-28 15:02:10.440 UTC client backend[22576] 009_twophase.pl LOG: disconnection: session time: 0:00:00.021 user=postgres database=postgres host=[local] 2025-12-28 15:02:10.453 UTC postmaster[8549] LOG: received immediate shutdown request 2025-12-28 15:02:10.464 UTC postmaster[8549] LOG: database system is shut down 2025-12-28 15:02:10.647 UTC postmaster[24039] LOG: starting PostgreSQL 19devel on x86_64-netbsd, compiled by gcc-10.5.0, 64-bit 2025-12-28 15:02:10.647 UTC postmaster[24039] LOG: listening on Unix socket "/tmp/GyqN4nrEcx/.s.PGSQL.26295" 2025-12-28 15:02:10.656 UTC startup[1100] LOG: database system was interrupted; last known up at 2025-12-28 15:02:10 UTC 2025-12-28 15:02:10.657 UTC startup[1100] LOG: database system was not properly shut down; automatic recovery in progress 2025-12-28 15:02:10.658 UTC startup[1100] LOG: redo starts at 0/0301FAF8 2025-12-28 15:02:10.659 UTC startup[1100] LOG: invalid record length at 0/03020040: expected at least 24, got 0 2025-12-28 15:02:10.659 UTC startup[1100] LOG: redo done at 0/0301FF20 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s TRAP: failed Assert("readOff == XLogSegmentOffset(pageBeginPtr, wal_segment_size)"), File: "../src/backend/access/transam/xlogrecovery.c", Line: 1588, PID: 1100 0x934e4f at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x56d4a6 at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x56427a at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x758d95 at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x753290 at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x7552cb at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x758815 at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0xab8c3c at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 2025-12-28 15:02:10.809 UTC postmaster[24039] LOG: startup process (PID 1100) was terminated by signal 6: Abort trap 2025-12-28 15:02:10.809 UTC postmaster[24039] LOG: terminating any other active server processes 2025-12-28 15:02:10.811 UTC postmaster[24039] LOG: shutting down due to startup process failure 2025-12-28 15:02:10.812 UTC postmaster[24039] LOG: database system is shut down