2024-12-27 05:12:57.539 UTC [9153][postmaster] LOG:  starting PostgreSQL 18devel on x86_64-freebsd, compiled by clang-17.0.6, 64-bit
2024-12-27 05:12:57.539 UTC [9153][postmaster] LOG:  listening on Unix socket "/tmp/hjW1kPejk_/.s.PGSQL.17744"
2024-12-27 05:12:57.540 UTC [9156][startup] LOG:  database system was shut down at 2024-12-27 05:12:57 UTC
2024-12-27 05:12:57.546 UTC [9153][postmaster] LOG:  database system is ready to accept connections
2024-12-27 05:12:57.660 UTC [9164][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-12-27 05:12:57.660 UTC [9164][walsender] [[unknown]][22/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/012_subtransactions/data/t_012_subtransactions_primary_data/pgdata/pg_hba.conf:124)
2024-12-27 05:12:57.660 UTC [9164][walsender] [[unknown]][22/1:0] LOG:  replication connection authorized: user=postgres application_name=012_subtransactions.pl
2024-12-27 05:12:57.661 UTC [9164][walsender] [012_subtransactions.pl][22/0:0] LOG:  received replication command: SHOW data_directory_mode
2024-12-27 05:12:57.661 UTC [9164][walsender] [012_subtransactions.pl][22/0:0] STATEMENT:  SHOW data_directory_mode
2024-12-27 05:12:57.661 UTC [9164][walsender] [012_subtransactions.pl][22/0:0] LOG:  received replication command: SHOW wal_segment_size
2024-12-27 05:12:57.661 UTC [9164][walsender] [012_subtransactions.pl][22/0:0] STATEMENT:  SHOW wal_segment_size
2024-12-27 05:12:57.661 UTC [9164][walsender] [012_subtransactions.pl][22/0:0] LOG:  received replication command: IDENTIFY_SYSTEM
2024-12-27 05:12:57.661 UTC [9164][walsender] [012_subtransactions.pl][22/0:0] STATEMENT:  IDENTIFY_SYSTEM
2024-12-27 05:12:57.661 UTC [9164][walsender] [012_subtransactions.pl][22/0:0] LOG:  received replication command: BASE_BACKUP ( LABEL 'pg_basebackup base backup',  PROGRESS,  CHECKPOINT 'fast',  WAIT 0,  MANIFEST 'yes',  TARGET 'client')
2024-12-27 05:12:57.661 UTC [9164][walsender] [012_subtransactions.pl][22/0:0] STATEMENT:  BASE_BACKUP ( LABEL 'pg_basebackup base backup',  PROGRESS,  CHECKPOINT 'fast',  WAIT 0,  MANIFEST 'yes',  TARGET 'client')
2024-12-27 05:12:57.664 UTC [9154][checkpointer] LOG:  checkpoint starting: immediate force wait
2024-12-27 05:12:57.720 UTC [9154][checkpointer] 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.056 s; sync files=0, longest=0.000 s, average=0.000 s; distance=8735 kB, estimate=8735 kB; lsn=0/2000080, redo lsn=0/2000028
2024-12-27 05:12:57.723 UTC [9166][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-12-27 05:12:57.724 UTC [9166][walsender] [[unknown]][23/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/012_subtransactions/data/t_012_subtransactions_primary_data/pgdata/pg_hba.conf:124)
2024-12-27 05:12:57.724 UTC [9166][walsender] [[unknown]][23/1:0] LOG:  replication connection authorized: user=postgres application_name=012_subtransactions.pl
2024-12-27 05:12:57.726 UTC [9166][walsender] [012_subtransactions.pl][23/0:0] LOG:  received replication command: SHOW data_directory_mode
2024-12-27 05:12:57.726 UTC [9166][walsender] [012_subtransactions.pl][23/0:0] STATEMENT:  SHOW data_directory_mode
2024-12-27 05:12:57.726 UTC [9166][walsender] [012_subtransactions.pl][23/0:0] LOG:  received replication command: CREATE_REPLICATION_SLOT "pg_basebackup_9166" TEMPORARY PHYSICAL ( RESERVE_WAL)
2024-12-27 05:12:57.726 UTC [9166][walsender] [012_subtransactions.pl][23/0:0] STATEMENT:  CREATE_REPLICATION_SLOT "pg_basebackup_9166" TEMPORARY PHYSICAL ( RESERVE_WAL)
2024-12-27 05:12:57.728 UTC [9166][walsender] [012_subtransactions.pl][23/0:0] LOG:  released physical replication slot "pg_basebackup_9166"
2024-12-27 05:12:57.728 UTC [9166][walsender] [012_subtransactions.pl][23/0:0] STATEMENT:  CREATE_REPLICATION_SLOT "pg_basebackup_9166" TEMPORARY PHYSICAL ( RESERVE_WAL)
2024-12-27 05:12:57.730 UTC [9166][walsender] [012_subtransactions.pl][23/0:0] LOG:  received replication command: IDENTIFY_SYSTEM
2024-12-27 05:12:57.730 UTC [9166][walsender] [012_subtransactions.pl][23/0:0] STATEMENT:  IDENTIFY_SYSTEM
2024-12-27 05:12:57.731 UTC [9166][walsender] [012_subtransactions.pl][23/0:0] LOG:  received replication command: START_REPLICATION SLOT "pg_basebackup_9166" 0/2000000 TIMELINE 1
2024-12-27 05:12:57.731 UTC [9166][walsender] [012_subtransactions.pl][23/0:0] STATEMENT:  START_REPLICATION SLOT "pg_basebackup_9166" 0/2000000 TIMELINE 1
2024-12-27 05:12:57.731 UTC [9166][walsender] [012_subtransactions.pl][23/0:0] LOG:  acquired physical replication slot "pg_basebackup_9166"
2024-12-27 05:12:57.731 UTC [9166][walsender] [012_subtransactions.pl][23/0:0] STATEMENT:  START_REPLICATION SLOT "pg_basebackup_9166" 0/2000000 TIMELINE 1
2024-12-27 05:12:57.913 UTC [9166][walsender] [012_subtransactions.pl][23/0:0] LOG:  released physical replication slot "pg_basebackup_9166"
2024-12-27 05:12:57.913 UTC [9166][walsender] [012_subtransactions.pl][23/0:0] STATEMENT:  START_REPLICATION SLOT "pg_basebackup_9166" 0/2000000 TIMELINE 1
2024-12-27 05:12:57.915 UTC [9164][walsender] [012_subtransactions.pl][:0] LOG:  disconnection: session time: 0:00:00.263 user=postgres database= host=[local]
2024-12-27 05:12:57.918 UTC [9166][walsender] [012_subtransactions.pl][:0] LOG:  disconnection: session time: 0:00:00.195 user=postgres database= host=[local]
2024-12-27 05:12:57.934 UTC [9174][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-12-27 05:12:57.935 UTC [9174][client backend] [[unknown]][0/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/012_subtransactions/data/t_012_subtransactions_primary_data/pgdata/pg_hba.conf:117)
2024-12-27 05:12:57.935 UTC [9174][client backend] [[unknown]][0/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=012_subtransactions.pl
2024-12-27 05:12:57.942 UTC [9174][client backend] [012_subtransactions.pl][0/2:0] LOG:  statement: CREATE TABLE t_012_tbl (id int)
2024-12-27 05:12:57.944 UTC [9174][client backend] [012_subtransactions.pl][:0] LOG:  disconnection: session time: 0:00:00.017 user=postgres database=postgres host=[local]
2024-12-27 05:12:58.114 UTC [9196][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-12-27 05:12:58.115 UTC [9196][walsender] [[unknown]][24/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/012_subtransactions/data/t_012_subtransactions_primary_data/pgdata/pg_hba.conf:124)
2024-12-27 05:12:58.115 UTC [9196][walsender] [[unknown]][24/1:0] LOG:  replication connection authorized: user=postgres application_name=standby
2024-12-27 05:12:58.115 UTC [9196][walsender] [standby][24/0:0] LOG:  received replication command: IDENTIFY_SYSTEM
2024-12-27 05:12:58.115 UTC [9196][walsender] [standby][24/0:0] STATEMENT:  IDENTIFY_SYSTEM
2024-12-27 05:12:58.115 UTC [9196][walsender] [standby][24/0:0] LOG:  received replication command: START_REPLICATION 0/3000000 TIMELINE 1
2024-12-27 05:12:58.115 UTC [9196][walsender] [standby][24/0:0] STATEMENT:  START_REPLICATION 0/3000000 TIMELINE 1
2024-12-27 05:12:58.203 UTC [9198][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-12-27 05:12:58.203 UTC [9198][client backend] [[unknown]][1/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/012_subtransactions/data/t_012_subtransactions_primary_data/pgdata/pg_hba.conf:117)
2024-12-27 05:12:58.203 UTC [9198][client backend] [[unknown]][1/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=012_subtransactions.pl
2024-12-27 05:12:58.206 UTC [9198][client backend] [012_subtransactions.pl][1/2:0] LOG:  statement: SELECT pg_reload_conf()
2024-12-27 05:12:58.207 UTC [9153][postmaster] LOG:  received SIGHUP, reloading configuration files
2024-12-27 05:12:58.207 UTC [9153][postmaster] LOG:  parameter "synchronous_standby_names" changed to "*"
2024-12-27 05:12:58.209 UTC [9198][client backend] [012_subtransactions.pl][:0] LOG:  disconnection: session time: 0:00:00.006 user=postgres database=postgres host=[local]
2024-12-27 05:12:58.225 UTC [9201][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-12-27 05:12:58.225 UTC [9201][client backend] [[unknown]][2/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/012_subtransactions/data/t_012_subtransactions_primary_data/pgdata/pg_hba.conf:117)
2024-12-27 05:12:58.225 UTC [9201][client backend] [[unknown]][2/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=012_subtransactions.pl
2024-12-27 05:12:58.226 UTC [9201][client backend] [012_subtransactions.pl][2/2:0] LOG:  statement: BEGIN;
2024-12-27 05:12:58.227 UTC [9201][client backend] [012_subtransactions.pl][2/2:0] LOG:  statement: DELETE FROM t_012_tbl;
2024-12-27 05:12:58.227 UTC [9201][client backend] [012_subtransactions.pl][2/2:0] LOG:  statement: INSERT INTO t_012_tbl VALUES (43);
2024-12-27 05:12:58.228 UTC [9201][client backend] [012_subtransactions.pl][2/2:748] LOG:  statement: SAVEPOINT s1;
2024-12-27 05:12:58.228 UTC [9201][client backend] [012_subtransactions.pl][2/2:748] LOG:  statement: INSERT INTO t_012_tbl VALUES (43);
2024-12-27 05:12:58.228 UTC [9201][client backend] [012_subtransactions.pl][2/2:748] LOG:  statement: SAVEPOINT s2;
2024-12-27 05:12:58.229 UTC [9201][client backend] [012_subtransactions.pl][2/2:748] LOG:  statement: INSERT INTO t_012_tbl VALUES (43);
2024-12-27 05:12:58.229 UTC [9201][client backend] [012_subtransactions.pl][2/2:748] LOG:  statement: SAVEPOINT s3;
2024-12-27 05:12:58.229 UTC [9201][client backend] [012_subtransactions.pl][2/2:748] LOG:  statement: INSERT INTO t_012_tbl VALUES (43);
2024-12-27 05:12:58.229 UTC [9201][client backend] [012_subtransactions.pl][2/2:748] LOG:  statement: SAVEPOINT s4;
2024-12-27 05:12:58.229 UTC [9201][client backend] [012_subtransactions.pl][2/2:748] LOG:  statement: INSERT INTO t_012_tbl VALUES (43);
2024-12-27 05:12:58.229 UTC [9201][client backend] [012_subtransactions.pl][2/2:748] LOG:  statement: SAVEPOINT s5;
2024-12-27 05:12:58.229 UTC [9201][client backend] [012_subtransactions.pl][2/2:748] LOG:  statement: INSERT INTO t_012_tbl VALUES (43);
2024-12-27 05:12:58.229 UTC [9201][client backend] [012_subtransactions.pl][2/2:748] LOG:  statement: PREPARE TRANSACTION 'xact_012_1';
2024-12-27 05:12:58.230 UTC [9196][walsender] [standby][24/0:0] LOG:  standby "standby" is now a synchronous standby with priority 1
2024-12-27 05:12:58.230 UTC [9196][walsender] [standby][24/0:0] STATEMENT:  START_REPLICATION 0/3000000 TIMELINE 1
2024-12-27 05:12:58.230 UTC [9201][client backend] [012_subtransactions.pl][2/3:0] LOG:  statement: CHECKPOINT;
2024-12-27 05:12:58.230 UTC [9154][checkpointer] LOG:  checkpoint starting: immediate force wait
2024-12-27 05:12:58.231 UTC [9154][checkpointer] LOG:  1 two-phase state file was written for a long-running prepared transaction
2024-12-27 05:12:58.276 UTC [9154][checkpointer] LOG:  checkpoint complete: wrote 12 buffers (9.4%), wrote 2 SLRU buffers; 0 WAL file(s) added, 0 removed, 1 recycled; write=0.001 s, sync=0.001 s, total=0.046 s; sync files=0, longest=0.000 s, average=0.000 s; distance=16479 kB, estimate=16479 kB; lsn=0/3017F40, redo lsn=0/3017ED0
2024-12-27 05:12:58.276 UTC [9201][client backend] [012_subtransactions.pl][:0] LOG:  disconnection: session time: 0:00:00.051 user=postgres database=postgres host=[local]
2024-12-27 05:12:58.278 UTC [9153][postmaster] LOG:  received fast shutdown request
2024-12-27 05:12:58.278 UTC [9153][postmaster] LOG:  aborting any active transactions
TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2896, PID: 9153
0xaa80a2 <ExceptionalCondition+0x72> at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres
0x8a22c7 <PostmasterStateMachine+0x3a7> at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres
0x8a07c9 <ServerLoop+0x419> at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres
0x89fba4 <PostmasterMain+0x11c4> at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres
2024-12-27 05:12:59.062 UTC [9196][walsender] [standby][:0] LOG:  disconnection: session time: 0:00:00.947 user=postgres database= host=[local]