2024-12-11 13:30:17.603 GMT [3296][postmaster] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30157, 64-bit 2024-12-11 13:30:17.612 GMT [3296][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/4YEgPHim62/.s.PGSQL.31473" 2024-12-11 13:30:17.701 GMT [4248][startup] LOG: database system was shut down at 2024-12-11 13:29:36 GMT 2024-12-11 13:30:17.776 GMT [3296][postmaster] LOG: database system is ready to accept connections 2024-12-11 13:30:18.042 GMT [5044][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:30:18.043 GMT [5044][walsender] [[unknown]][22/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/009_twophase/data/t_009_twophase_london_data/pgdata/pg_hba.conf:124) 2024-12-11 13:30:18.044 GMT [5044][walsender] [[unknown]][22/1:0] LOG: replication connection authorized: user=SYSTEM application_name=009_twophase.pl 2024-12-11 13:30:18.045 GMT [5044][walsender] [009_twophase.pl][22/0:0] LOG: received replication command: SHOW data_directory_mode 2024-12-11 13:30:18.045 GMT [5044][walsender] [009_twophase.pl][22/0:0] STATEMENT: SHOW data_directory_mode 2024-12-11 13:30:18.046 GMT [5044][walsender] [009_twophase.pl][22/0:0] LOG: received replication command: SHOW wal_segment_size 2024-12-11 13:30:18.046 GMT [5044][walsender] [009_twophase.pl][22/0:0] STATEMENT: SHOW wal_segment_size 2024-12-11 13:30:18.046 GMT [5044][walsender] [009_twophase.pl][22/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-12-11 13:30:18.046 GMT [5044][walsender] [009_twophase.pl][22/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-12-11 13:30:18.046 GMT [5044][walsender] [009_twophase.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-11 13:30:18.046 GMT [5044][walsender] [009_twophase.pl][22/0:0] STATEMENT: BASE_BACKUP ( LABEL 'pg_basebackup base backup', PROGRESS, CHECKPOINT 'fast', WAIT 0, MANIFEST 'yes', TARGET 'client') 2024-12-11 13:30:18.053 GMT [6064][checkpointer] LOG: checkpoint starting: immediate force wait 2024-12-11 13:30:18.072 GMT [6064][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.019 s; sync files=0, longest=0.000 s, average=0.000 s; distance=8823 kB, estimate=8823 kB; lsn=0/2000080, redo lsn=0/2000028 2024-12-11 13:30:18.161 GMT [6276][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:30:18.162 GMT [6276][walsender] [[unknown]][23/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/009_twophase/data/t_009_twophase_london_data/pgdata/pg_hba.conf:124) 2024-12-11 13:30:18.162 GMT [6276][walsender] [[unknown]][23/1:0] LOG: replication connection authorized: user=SYSTEM application_name=009_twophase.pl 2024-12-11 13:30:18.163 GMT [6276][walsender] [009_twophase.pl][23/0:0] LOG: received replication command: SHOW data_directory_mode 2024-12-11 13:30:18.163 GMT [6276][walsender] [009_twophase.pl][23/0:0] STATEMENT: SHOW data_directory_mode 2024-12-11 13:30:18.163 GMT [6276][walsender] [009_twophase.pl][23/0:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_basebackup_6276" TEMPORARY PHYSICAL ( RESERVE_WAL) 2024-12-11 13:30:18.163 GMT [6276][walsender] [009_twophase.pl][23/0:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_basebackup_6276" TEMPORARY PHYSICAL ( RESERVE_WAL) 2024-12-11 13:30:18.164 GMT [6276][walsender] [009_twophase.pl][23/0:0] LOG: released physical replication slot "pg_basebackup_6276" 2024-12-11 13:30:18.164 GMT [6276][walsender] [009_twophase.pl][23/0:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_basebackup_6276" TEMPORARY PHYSICAL ( RESERVE_WAL) 2024-12-11 13:30:18.234 GMT [6276][walsender] [009_twophase.pl][23/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-12-11 13:30:18.234 GMT [6276][walsender] [009_twophase.pl][23/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-12-11 13:30:18.236 GMT [6276][walsender] [009_twophase.pl][23/0:0] LOG: received replication command: START_REPLICATION SLOT "pg_basebackup_6276" 0/2000000 TIMELINE 1 2024-12-11 13:30:18.236 GMT [6276][walsender] [009_twophase.pl][23/0:0] STATEMENT: START_REPLICATION SLOT "pg_basebackup_6276" 0/2000000 TIMELINE 1 2024-12-11 13:30:18.236 GMT [6276][walsender] [009_twophase.pl][23/0:0] LOG: acquired physical replication slot "pg_basebackup_6276" 2024-12-11 13:30:18.236 GMT [6276][walsender] [009_twophase.pl][23/0:0] STATEMENT: START_REPLICATION SLOT "pg_basebackup_6276" 0/2000000 TIMELINE 1 2024-12-11 13:30:28.237 GMT [6276][walsender] [009_twophase.pl][23/0:0] LOG: released physical replication slot "pg_basebackup_6276" 2024-12-11 13:30:28.237 GMT [6276][walsender] [009_twophase.pl][23/0:0] STATEMENT: START_REPLICATION SLOT "pg_basebackup_6276" 0/2000000 TIMELINE 1 2024-12-11 13:30:28.238 GMT [6276][walsender] [009_twophase.pl][:0] LOG: disconnection: session time: 0:00:10.081 user=SYSTEM database= host=[local] 2024-12-11 13:30:28.390 GMT [5044][walsender] [009_twophase.pl][:0] LOG: disconnection: session time: 0:00:10.351 user=SYSTEM database= host=[local] 2024-12-11 13:30:31.253 GMT [4816][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:30:31.255 GMT [4816][walsender] [[unknown]][24/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/009_twophase/data/t_009_twophase_london_data/pgdata/pg_hba.conf:124) 2024-12-11 13:30:31.255 GMT [4816][walsender] [[unknown]][24/1:0] LOG: replication connection authorized: user=SYSTEM application_name=paris 2024-12-11 13:30:31.255 GMT [4816][walsender] [paris][24/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-12-11 13:30:31.255 GMT [4816][walsender] [paris][24/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-12-11 13:30:31.255 GMT [4816][walsender] [paris][24/0:0] LOG: received replication command: START_REPLICATION 0/3000000 TIMELINE 1 2024-12-11 13:30:31.255 GMT [4816][walsender] [paris][24/0:0] STATEMENT: START_REPLICATION 0/3000000 TIMELINE 1 2024-12-11 13:30:31.434 GMT [6296][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:30:31.435 GMT [6296][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/009_twophase/data/t_009_twophase_london_data/pgdata/pg_hba.conf:117) 2024-12-11 13:30:31.435 GMT [6296][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=009_twophase.pl 2024-12-11 13:30:31.461 GMT [6296][client backend] [009_twophase.pl][0/2:0] LOG: statement: SELECT pg_reload_conf() 2024-12-11 13:30:31.462 GMT [3296][postmaster] LOG: received SIGHUP, reloading configuration files 2024-12-11 13:30:31.465 GMT [3296][postmaster] LOG: parameter "synchronous_standby_names" changed to "paris" 2024-12-11 13:30:31.469 GMT [6296][client backend] [009_twophase.pl][:0] LOG: disconnection: session time: 0:00:00.037 user=SYSTEM database=postgres host=[local] 2024-12-11 13:30:31.649 GMT [4816][walsender] [paris][24/0:0] LOG: standby "paris" is now a synchronous standby with priority 1 2024-12-11 13:30:31.649 GMT [4816][walsender] [paris][24/0:0] STATEMENT: START_REPLICATION 0/3000000 TIMELINE 1 2024-12-11 13:30:31.786 GMT [4384][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:30:31.789 GMT [4384][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/009_twophase/data/t_009_twophase_london_data/pgdata/pg_hba.conf:117) 2024-12-11 13:30:31.789 GMT [4384][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=009_twophase.pl 2024-12-11 13:30:31.792 GMT [4384][client backend] [009_twophase.pl][1/2:0] LOG: statement: CREATE TABLE t_009_tbl (id int, msg text) 2024-12-11 13:30:31.826 GMT [4384][client backend] [009_twophase.pl][:0] LOG: disconnection: session time: 0:00:00.043 user=SYSTEM database=postgres host=[local] 2024-12-11 13:30:31.959 GMT [7080][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:30:31.961 GMT [7080][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/009_twophase/data/t_009_twophase_london_data/pgdata/pg_hba.conf:117) 2024-12-11 13:30:31.961 GMT [7080][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=009_twophase.pl 2024-12-11 13:30:31.965 GMT [7080][client backend] [009_twophase.pl][2/2:0] LOG: statement: BEGIN; 2024-12-11 13:30:31.966 GMT [7080][client backend] [009_twophase.pl][2/2:0] LOG: statement: INSERT INTO t_009_tbl VALUES (1, 'issued to london'); 2024-12-11 13:30:31.967 GMT [7080][client backend] [009_twophase.pl][2/2:747] LOG: statement: SAVEPOINT s1; 2024-12-11 13:30:31.967 GMT [7080][client backend] [009_twophase.pl][2/2:747] LOG: statement: INSERT INTO t_009_tbl VALUES (2, 'issued to london'); 2024-12-11 13:30:31.967 GMT [7080][client backend] [009_twophase.pl][2/2:747] LOG: statement: PREPARE TRANSACTION 'xact_009_1'; 2024-12-11 13:30:31.968 GMT [7080][client backend] [009_twophase.pl][2/3:0] LOG: statement: BEGIN; 2024-12-11 13:30:31.968 GMT [7080][client backend] [009_twophase.pl][2/3:0] LOG: statement: INSERT INTO t_009_tbl VALUES (3, 'issued to london'); 2024-12-11 13:30:31.968 GMT [7080][client backend] [009_twophase.pl][2/3:749] LOG: statement: SAVEPOINT s1; 2024-12-11 13:30:31.969 GMT [7080][client backend] [009_twophase.pl][2/3:749] LOG: statement: INSERT INTO t_009_tbl VALUES (4, 'issued to london'); 2024-12-11 13:30:31.969 GMT [7080][client backend] [009_twophase.pl][2/3:749] LOG: statement: PREPARE TRANSACTION 'xact_009_2'; 2024-12-11 13:30:31.970 GMT [7080][client backend] [009_twophase.pl][:0] LOG: disconnection: session time: 0:00:00.036 user=SYSTEM database=postgres host=[local] 2024-12-11 13:30:32.059 GMT [3296][postmaster] LOG: received fast shutdown request 2024-12-11 13:30:32.059 GMT [3296][postmaster] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2899, PID: 3296 abort() has been called2024-12-11 13:30:33.638 GMT [4816][walsender] [paris][:0] LOG: disconnection: session time: 0:00:02.393 user=SYSTEM database= host=[local]