2024-12-18 07:10:07.450 UTC [9246][postmaster] LOG:  starting PostgreSQL 18devel on x86_64-freebsd, compiled by clang-17.0.6, 64-bit
2024-12-18 07:10:07.450 UTC [9246][postmaster] LOG:  listening on Unix socket "/tmp/lL1elAdWIt/.s.PGSQL.25386"
2024-12-18 07:10:07.452 UTC [9249][startup] LOG:  database system was shut down at 2024-12-18 07:10:07 UTC
2024-12-18 07:10:07.456 UTC [9246][postmaster] LOG:  database system is ready to accept connections
2024-12-18 07:10:07.577 UTC [9255][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-12-18 07:10:07.577 UTC [9255][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-18 07:10:07.577 UTC [9255][walsender] [[unknown]][22/1:0] LOG:  replication connection authorized: user=postgres application_name=012_subtransactions.pl
2024-12-18 07:10:07.618 UTC [9255][walsender] [012_subtransactions.pl][22/0:0] LOG:  received replication command: SHOW data_directory_mode
2024-12-18 07:10:07.618 UTC [9255][walsender] [012_subtransactions.pl][22/0:0] STATEMENT:  SHOW data_directory_mode
2024-12-18 07:10:07.622 UTC [9255][walsender] [012_subtransactions.pl][22/0:0] LOG:  received replication command: SHOW wal_segment_size
2024-12-18 07:10:07.622 UTC [9255][walsender] [012_subtransactions.pl][22/0:0] STATEMENT:  SHOW wal_segment_size
2024-12-18 07:10:07.622 UTC [9255][walsender] [012_subtransactions.pl][22/0:0] LOG:  received replication command: IDENTIFY_SYSTEM
2024-12-18 07:10:07.622 UTC [9255][walsender] [012_subtransactions.pl][22/0:0] STATEMENT:  IDENTIFY_SYSTEM
2024-12-18 07:10:07.622 UTC [9255][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-18 07:10:07.622 UTC [9255][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-18 07:10:07.627 UTC [9247][checkpointer] LOG:  checkpoint starting: immediate force wait
2024-12-18 07:10:07.635 UTC [9247][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.000 s, total=0.008 s; sync files=0, longest=0.000 s, average=0.000 s; distance=8731 kB, estimate=8731 kB; lsn=0/2000080, redo lsn=0/2000028
2024-12-18 07:10:07.638 UTC [9256][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-12-18 07:10:07.638 UTC [9256][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-18 07:10:07.638 UTC [9256][walsender] [[unknown]][23/1:0] LOG:  replication connection authorized: user=postgres application_name=012_subtransactions.pl
2024-12-18 07:10:07.638 UTC [9256][walsender] [012_subtransactions.pl][23/0:0] LOG:  received replication command: SHOW data_directory_mode
2024-12-18 07:10:07.638 UTC [9256][walsender] [012_subtransactions.pl][23/0:0] STATEMENT:  SHOW data_directory_mode
2024-12-18 07:10:07.638 UTC [9256][walsender] [012_subtransactions.pl][23/0:0] LOG:  received replication command: CREATE_REPLICATION_SLOT "pg_basebackup_9256" TEMPORARY PHYSICAL ( RESERVE_WAL)
2024-12-18 07:10:07.638 UTC [9256][walsender] [012_subtransactions.pl][23/0:0] STATEMENT:  CREATE_REPLICATION_SLOT "pg_basebackup_9256" TEMPORARY PHYSICAL ( RESERVE_WAL)
2024-12-18 07:10:07.638 UTC [9256][walsender] [012_subtransactions.pl][23/0:0] LOG:  released physical replication slot "pg_basebackup_9256"
2024-12-18 07:10:07.638 UTC [9256][walsender] [012_subtransactions.pl][23/0:0] STATEMENT:  CREATE_REPLICATION_SLOT "pg_basebackup_9256" TEMPORARY PHYSICAL ( RESERVE_WAL)
2024-12-18 07:10:07.639 UTC [9256][walsender] [012_subtransactions.pl][23/0:0] LOG:  received replication command: IDENTIFY_SYSTEM
2024-12-18 07:10:07.639 UTC [9256][walsender] [012_subtransactions.pl][23/0:0] STATEMENT:  IDENTIFY_SYSTEM
2024-12-18 07:10:07.639 UTC [9256][walsender] [012_subtransactions.pl][23/0:0] LOG:  received replication command: START_REPLICATION SLOT "pg_basebackup_9256" 0/2000000 TIMELINE 1
2024-12-18 07:10:07.639 UTC [9256][walsender] [012_subtransactions.pl][23/0:0] STATEMENT:  START_REPLICATION SLOT "pg_basebackup_9256" 0/2000000 TIMELINE 1
2024-12-18 07:10:07.639 UTC [9256][walsender] [012_subtransactions.pl][23/0:0] LOG:  acquired physical replication slot "pg_basebackup_9256"
2024-12-18 07:10:07.639 UTC [9256][walsender] [012_subtransactions.pl][23/0:0] STATEMENT:  START_REPLICATION SLOT "pg_basebackup_9256" 0/2000000 TIMELINE 1
2024-12-18 07:10:07.776 UTC [9256][walsender] [012_subtransactions.pl][23/0:0] LOG:  released physical replication slot "pg_basebackup_9256"
2024-12-18 07:10:07.776 UTC [9256][walsender] [012_subtransactions.pl][23/0:0] STATEMENT:  START_REPLICATION SLOT "pg_basebackup_9256" 0/2000000 TIMELINE 1
2024-12-18 07:10:07.776 UTC [9255][walsender] [012_subtransactions.pl][:0] LOG:  disconnection: session time: 0:00:00.203 user=postgres database= host=[local]
2024-12-18 07:10:07.779 UTC [9256][walsender] [012_subtransactions.pl][:0] LOG:  disconnection: session time: 0:00:00.141 user=postgres database= host=[local]
2024-12-18 07:10:07.784 UTC [9259][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-12-18 07:10:07.784 UTC [9259][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-18 07:10:07.784 UTC [9259][client backend] [[unknown]][0/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=012_subtransactions.pl
2024-12-18 07:10:07.789 UTC [9259][client backend] [012_subtransactions.pl][0/2:0] LOG:  statement: CREATE TABLE t_012_tbl (id int)
2024-12-18 07:10:07.791 UTC [9259][client backend] [012_subtransactions.pl][:0] LOG:  disconnection: session time: 0:00:00.007 user=postgres database=postgres host=[local]
2024-12-18 07:10:07.944 UTC [9270][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-12-18 07:10:07.944 UTC [9270][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-18 07:10:07.944 UTC [9270][walsender] [[unknown]][24/1:0] LOG:  replication connection authorized: user=postgres application_name=standby
2024-12-18 07:10:07.946 UTC [9270][walsender] [standby][24/0:0] LOG:  received replication command: IDENTIFY_SYSTEM
2024-12-18 07:10:07.946 UTC [9270][walsender] [standby][24/0:0] STATEMENT:  IDENTIFY_SYSTEM
2024-12-18 07:10:07.946 UTC [9270][walsender] [standby][24/0:0] LOG:  received replication command: START_REPLICATION 0/3000000 TIMELINE 1
2024-12-18 07:10:07.946 UTC [9270][walsender] [standby][24/0:0] STATEMENT:  START_REPLICATION 0/3000000 TIMELINE 1
2024-12-18 07:10:08.008 UTC [9272][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-12-18 07:10:08.008 UTC [9272][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-18 07:10:08.008 UTC [9272][client backend] [[unknown]][1/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=012_subtransactions.pl
2024-12-18 07:10:08.009 UTC [9272][client backend] [012_subtransactions.pl][1/2:0] LOG:  statement: SELECT pg_reload_conf()
2024-12-18 07:10:08.010 UTC [9246][postmaster] LOG:  received SIGHUP, reloading configuration files
2024-12-18 07:10:08.010 UTC [9246][postmaster] LOG:  parameter "synchronous_standby_names" changed to "*"
2024-12-18 07:10:08.012 UTC [9272][client backend] [012_subtransactions.pl][:0] LOG:  disconnection: session time: 0:00:00.003 user=postgres database=postgres host=[local]
2024-12-18 07:10:08.021 UTC [9274][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-12-18 07:10:08.021 UTC [9274][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-18 07:10:08.021 UTC [9274][client backend] [[unknown]][2/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=012_subtransactions.pl
2024-12-18 07:10:08.022 UTC [9274][client backend] [012_subtransactions.pl][2/2:0] LOG:  statement: BEGIN;
2024-12-18 07:10:08.022 UTC [9274][client backend] [012_subtransactions.pl][2/2:0] LOG:  statement: DELETE FROM t_012_tbl;
2024-12-18 07:10:08.023 UTC [9274][client backend] [012_subtransactions.pl][2/2:0] LOG:  statement: INSERT INTO t_012_tbl VALUES (43);
2024-12-18 07:10:08.023 UTC [9274][client backend] [012_subtransactions.pl][2/2:747] LOG:  statement: SAVEPOINT s1;
2024-12-18 07:10:08.023 UTC [9274][client backend] [012_subtransactions.pl][2/2:747] LOG:  statement: INSERT INTO t_012_tbl VALUES (43);
2024-12-18 07:10:08.023 UTC [9274][client backend] [012_subtransactions.pl][2/2:747] LOG:  statement: SAVEPOINT s2;
2024-12-18 07:10:08.023 UTC [9274][client backend] [012_subtransactions.pl][2/2:747] LOG:  statement: INSERT INTO t_012_tbl VALUES (43);
2024-12-18 07:10:08.024 UTC [9274][client backend] [012_subtransactions.pl][2/2:747] LOG:  statement: SAVEPOINT s3;
2024-12-18 07:10:08.024 UTC [9274][client backend] [012_subtransactions.pl][2/2:747] LOG:  statement: INSERT INTO t_012_tbl VALUES (43);
2024-12-18 07:10:08.024 UTC [9274][client backend] [012_subtransactions.pl][2/2:747] LOG:  statement: SAVEPOINT s4;
2024-12-18 07:10:08.024 UTC [9274][client backend] [012_subtransactions.pl][2/2:747] LOG:  statement: INSERT INTO t_012_tbl VALUES (43);
2024-12-18 07:10:08.024 UTC [9274][client backend] [012_subtransactions.pl][2/2:747] LOG:  statement: SAVEPOINT s5;
2024-12-18 07:10:08.024 UTC [9274][client backend] [012_subtransactions.pl][2/2:747] LOG:  statement: INSERT INTO t_012_tbl VALUES (43);
2024-12-18 07:10:08.024 UTC [9274][client backend] [012_subtransactions.pl][2/2:747] LOG:  statement: PREPARE TRANSACTION 'xact_012_1';
2024-12-18 07:10:08.026 UTC [9270][walsender] [standby][24/0:0] LOG:  standby "standby" is now a synchronous standby with priority 1
2024-12-18 07:10:08.026 UTC [9270][walsender] [standby][24/0:0] STATEMENT:  START_REPLICATION 0/3000000 TIMELINE 1
2024-12-18 07:10:08.028 UTC [9274][client backend] [012_subtransactions.pl][2/3:0] LOG:  statement: CHECKPOINT;
2024-12-18 07:10:08.028 UTC [9247][checkpointer] LOG:  checkpoint starting: immediate force wait
2024-12-18 07:10:08.037 UTC [9247][checkpointer] LOG:  1 two-phase state file was written for a long-running prepared transaction
2024-12-18 07:10:08.039 UTC [9247][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.012 s; sync files=0, longest=0.000 s, average=0.000 s; distance=16479 kB, estimate=16479 kB; lsn=0/3017F58, redo lsn=0/3017EE8
2024-12-18 07:10:08.039 UTC [9274][client backend] [012_subtransactions.pl][:0] LOG:  disconnection: session time: 0:00:00.018 user=postgres database=postgres host=[local]
2024-12-18 07:10:08.042 UTC [9246][postmaster] LOG:  received fast shutdown request
2024-12-18 07:10:08.042 UTC [9246][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: 9246
0xaa4ae2 <ExceptionalCondition+0x72> at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres
0x89fc67 <PostmasterStateMachine+0x3a7> at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres
0x89e169 <ServerLoop+0x419> at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres
0x89d544 <PostmasterMain+0x11c4> at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres
2024-12-18 07:10:08.484 UTC [9270][walsender] [standby][:0] LOG:  disconnection: session time: 0:00:00.540 user=postgres database= host=[local]