2024-11-17 21:29:58.995 UTC [9169][postmaster] LOG:  starting PostgreSQL 18devel on x86_64-freebsd, compiled by clang-17.0.6, 64-bit
2024-11-17 21:29:58.995 UTC [9169][postmaster] LOG:  listening on Unix socket "/tmp/mjmxoVgMz7/.s.PGSQL.12636"
2024-11-17 21:29:59.001 UTC [9172][startup] LOG:  database system was shut down at 2024-11-17 21:29:58 UTC
2024-11-17 21:29:59.048 UTC [9169][postmaster] LOG:  database system is ready to accept connections
2024-11-17 21:29:59.094 UTC [9177][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-17 21:29:59.094 UTC [9177][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-11-17 21:29:59.094 UTC [9177][walsender] [[unknown]][22/1:0] LOG:  replication connection authorized: user=postgres application_name=012_subtransactions.pl
2024-11-17 21:29:59.094 UTC [9177][walsender] [012_subtransactions.pl][22/0:0] LOG:  received replication command: SHOW data_directory_mode
2024-11-17 21:29:59.094 UTC [9177][walsender] [012_subtransactions.pl][22/0:0] STATEMENT:  SHOW data_directory_mode
2024-11-17 21:29:59.094 UTC [9177][walsender] [012_subtransactions.pl][22/0:0] LOG:  received replication command: SHOW wal_segment_size
2024-11-17 21:29:59.094 UTC [9177][walsender] [012_subtransactions.pl][22/0:0] STATEMENT:  SHOW wal_segment_size
2024-11-17 21:29:59.094 UTC [9177][walsender] [012_subtransactions.pl][22/0:0] LOG:  received replication command: IDENTIFY_SYSTEM
2024-11-17 21:29:59.094 UTC [9177][walsender] [012_subtransactions.pl][22/0:0] STATEMENT:  IDENTIFY_SYSTEM
2024-11-17 21:29:59.094 UTC [9177][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-11-17 21:29:59.094 UTC [9177][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-11-17 21:29:59.098 UTC [9170][checkpointer] LOG:  checkpoint starting: immediate force wait
2024-11-17 21:29:59.108 UTC [9170][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.010 s; sync files=0, longest=0.000 s, average=0.000 s; distance=8734 kB, estimate=8734 kB; lsn=0/2000080, redo lsn=0/2000028
2024-11-17 21:29:59.111 UTC [9178][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-17 21:29:59.112 UTC [9178][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-11-17 21:29:59.112 UTC [9178][walsender] [[unknown]][23/1:0] LOG:  replication connection authorized: user=postgres application_name=012_subtransactions.pl
2024-11-17 21:29:59.112 UTC [9178][walsender] [012_subtransactions.pl][23/0:0] LOG:  received replication command: SHOW data_directory_mode
2024-11-17 21:29:59.112 UTC [9178][walsender] [012_subtransactions.pl][23/0:0] STATEMENT:  SHOW data_directory_mode
2024-11-17 21:29:59.112 UTC [9178][walsender] [012_subtransactions.pl][23/0:0] LOG:  received replication command: CREATE_REPLICATION_SLOT "pg_basebackup_9178" TEMPORARY PHYSICAL ( RESERVE_WAL)
2024-11-17 21:29:59.112 UTC [9178][walsender] [012_subtransactions.pl][23/0:0] STATEMENT:  CREATE_REPLICATION_SLOT "pg_basebackup_9178" TEMPORARY PHYSICAL ( RESERVE_WAL)
2024-11-17 21:29:59.112 UTC [9178][walsender] [012_subtransactions.pl][23/0:0] LOG:  released physical replication slot "pg_basebackup_9178"
2024-11-17 21:29:59.112 UTC [9178][walsender] [012_subtransactions.pl][23/0:0] STATEMENT:  CREATE_REPLICATION_SLOT "pg_basebackup_9178" TEMPORARY PHYSICAL ( RESERVE_WAL)
2024-11-17 21:29:59.113 UTC [9178][walsender] [012_subtransactions.pl][23/0:0] LOG:  received replication command: IDENTIFY_SYSTEM
2024-11-17 21:29:59.113 UTC [9178][walsender] [012_subtransactions.pl][23/0:0] STATEMENT:  IDENTIFY_SYSTEM
2024-11-17 21:29:59.114 UTC [9178][walsender] [012_subtransactions.pl][23/0:0] LOG:  received replication command: START_REPLICATION SLOT "pg_basebackup_9178" 0/2000000 TIMELINE 1
2024-11-17 21:29:59.114 UTC [9178][walsender] [012_subtransactions.pl][23/0:0] STATEMENT:  START_REPLICATION SLOT "pg_basebackup_9178" 0/2000000 TIMELINE 1
2024-11-17 21:29:59.114 UTC [9178][walsender] [012_subtransactions.pl][23/0:0] LOG:  acquired physical replication slot "pg_basebackup_9178"
2024-11-17 21:29:59.114 UTC [9178][walsender] [012_subtransactions.pl][23/0:0] STATEMENT:  START_REPLICATION SLOT "pg_basebackup_9178" 0/2000000 TIMELINE 1
2024-11-17 21:29:59.283 UTC [9178][walsender] [012_subtransactions.pl][23/0:0] LOG:  released physical replication slot "pg_basebackup_9178"
2024-11-17 21:29:59.283 UTC [9178][walsender] [012_subtransactions.pl][23/0:0] STATEMENT:  START_REPLICATION SLOT "pg_basebackup_9178" 0/2000000 TIMELINE 1
2024-11-17 21:29:59.283 UTC [9177][walsender] [012_subtransactions.pl][:0] LOG:  disconnection: session time: 0:00:00.189 user=postgres database= host=[local]
2024-11-17 21:29:59.284 UTC [9178][walsender] [012_subtransactions.pl][:0] LOG:  disconnection: session time: 0:00:00.172 user=postgres database= host=[local]
2024-11-17 21:29:59.304 UTC [9187][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-17 21:29:59.305 UTC [9187][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-11-17 21:29:59.305 UTC [9187][client backend] [[unknown]][0/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=012_subtransactions.pl
2024-11-17 21:29:59.314 UTC [9187][client backend] [012_subtransactions.pl][0/2:0] LOG:  statement: CREATE TABLE t_012_tbl (id int)
2024-11-17 21:29:59.315 UTC [9187][client backend] [012_subtransactions.pl][:0] LOG:  disconnection: session time: 0:00:00.013 user=postgres database=postgres host=[local]
2024-11-17 21:29:59.463 UTC [9207][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-17 21:29:59.464 UTC [9207][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-11-17 21:29:59.464 UTC [9207][walsender] [[unknown]][24/1:0] LOG:  replication connection authorized: user=postgres application_name=standby
2024-11-17 21:29:59.464 UTC [9207][walsender] [standby][24/0:0] LOG:  received replication command: IDENTIFY_SYSTEM
2024-11-17 21:29:59.464 UTC [9207][walsender] [standby][24/0:0] STATEMENT:  IDENTIFY_SYSTEM
2024-11-17 21:29:59.464 UTC [9207][walsender] [standby][24/0:0] LOG:  received replication command: START_REPLICATION 0/3000000 TIMELINE 1
2024-11-17 21:29:59.464 UTC [9207][walsender] [standby][24/0:0] STATEMENT:  START_REPLICATION 0/3000000 TIMELINE 1
2024-11-17 21:29:59.594 UTC [9216][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-17 21:29:59.594 UTC [9216][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-11-17 21:29:59.594 UTC [9216][client backend] [[unknown]][1/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=012_subtransactions.pl
2024-11-17 21:29:59.596 UTC [9216][client backend] [012_subtransactions.pl][1/2:0] LOG:  statement: SELECT pg_reload_conf()
2024-11-17 21:29:59.596 UTC [9169][postmaster] LOG:  received SIGHUP, reloading configuration files
2024-11-17 21:29:59.597 UTC [9169][postmaster] LOG:  parameter "synchronous_standby_names" changed to "*"
2024-11-17 21:29:59.600 UTC [9216][client backend] [012_subtransactions.pl][:0] LOG:  disconnection: session time: 0:00:00.011 user=postgres database=postgres host=[local]
2024-11-17 21:29:59.627 UTC [9219][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-17 21:29:59.627 UTC [9219][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-11-17 21:29:59.627 UTC [9219][client backend] [[unknown]][2/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=012_subtransactions.pl
2024-11-17 21:29:59.628 UTC [9219][client backend] [012_subtransactions.pl][2/2:0] LOG:  statement: BEGIN;
2024-11-17 21:29:59.628 UTC [9219][client backend] [012_subtransactions.pl][2/2:0] LOG:  statement: DELETE FROM t_012_tbl;
2024-11-17 21:29:59.629 UTC [9219][client backend] [012_subtransactions.pl][2/2:0] LOG:  statement: INSERT INTO t_012_tbl VALUES (43);
2024-11-17 21:29:59.630 UTC [9219][client backend] [012_subtransactions.pl][2/2:747] LOG:  statement: SAVEPOINT s1;
2024-11-17 21:29:59.630 UTC [9219][client backend] [012_subtransactions.pl][2/2:747] LOG:  statement: INSERT INTO t_012_tbl VALUES (43);
2024-11-17 21:29:59.630 UTC [9219][client backend] [012_subtransactions.pl][2/2:747] LOG:  statement: SAVEPOINT s2;
2024-11-17 21:29:59.630 UTC [9219][client backend] [012_subtransactions.pl][2/2:747] LOG:  statement: INSERT INTO t_012_tbl VALUES (43);
2024-11-17 21:29:59.630 UTC [9219][client backend] [012_subtransactions.pl][2/2:747] LOG:  statement: SAVEPOINT s3;
2024-11-17 21:29:59.630 UTC [9219][client backend] [012_subtransactions.pl][2/2:747] LOG:  statement: INSERT INTO t_012_tbl VALUES (43);
2024-11-17 21:29:59.630 UTC [9219][client backend] [012_subtransactions.pl][2/2:747] LOG:  statement: SAVEPOINT s4;
2024-11-17 21:29:59.630 UTC [9219][client backend] [012_subtransactions.pl][2/2:747] LOG:  statement: INSERT INTO t_012_tbl VALUES (43);
2024-11-17 21:29:59.631 UTC [9219][client backend] [012_subtransactions.pl][2/2:747] LOG:  statement: SAVEPOINT s5;
2024-11-17 21:29:59.631 UTC [9219][client backend] [012_subtransactions.pl][2/2:747] LOG:  statement: INSERT INTO t_012_tbl VALUES (43);
2024-11-17 21:29:59.631 UTC [9219][client backend] [012_subtransactions.pl][2/2:747] LOG:  statement: PREPARE TRANSACTION 'xact_012_1';
2024-11-17 21:29:59.634 UTC [9207][walsender] [standby][24/0:0] LOG:  standby "standby" is now a synchronous standby with priority 1
2024-11-17 21:29:59.634 UTC [9207][walsender] [standby][24/0:0] STATEMENT:  START_REPLICATION 0/3000000 TIMELINE 1
2024-11-17 21:29:59.635 UTC [9219][client backend] [012_subtransactions.pl][2/3:0] LOG:  statement: CHECKPOINT;
2024-11-17 21:29:59.637 UTC [9170][checkpointer] LOG:  checkpoint starting: immediate force wait
2024-11-17 21:29:59.643 UTC [9170][checkpointer] LOG:  1 two-phase state file was written for a long-running prepared transaction
2024-11-17 21:29:59.647 UTC [9170][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.010 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-11-17 21:29:59.649 UTC [9219][client backend] [012_subtransactions.pl][:0] LOG:  disconnection: session time: 0:00:00.021 user=postgres database=postgres host=[local]
2024-11-17 21:29:59.660 UTC [9169][postmaster] LOG:  received fast shutdown request
2024-11-17 21:29:59.660 UTC [9169][postmaster] LOG:  aborting any active transactions
TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2887, PID: 9169
0xa9f9d2 <ExceptionalCondition+0x72> at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres
0x89cdb7 <PostmasterStateMachine+0x3a7> at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres
0x89b2b9 <ServerLoop+0x419> at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres
0x89a68b <PostmasterMain+0x11cb> at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres
2024-11-17 21:30:00.232 UTC [9207][walsender] [standby][:0] LOG:  disconnection: session time: 0:00:00.769 user=postgres database= host=[local]