2024-11-27 10:12:09.594 GMT [7812][postmaster] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30157, 64-bit 2024-11-27 10:12:09.595 GMT [7812][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/AQZ6yTggtK/.s.PGSQL.16224" 2024-11-27 10:12:09.616 GMT [8180][startup] LOG: database system was shut down at 2024-11-27 10:04:17 GMT 2024-11-27 10:12:09.630 GMT [7812][postmaster] LOG: database system is ready to accept connections 2024-11-27 10:12:10.043 GMT [3496][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:10.045 GMT [3496][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:10.045 GMT [3496][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=021_twophase.pl 2024-11-27 10:12:10.061 GMT [3496][client backend] [021_twophase.pl][0/2:0] LOG: statement: CREATE TABLE tab_full (a int PRIMARY KEY) 2024-11-27 10:12:10.069 GMT [3496][client backend] [021_twophase.pl][:0] LOG: disconnection: session time: 0:00:00.033 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:10.285 GMT [3116][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:10.287 GMT [3116][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:10.287 GMT [3116][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=021_twophase.pl 2024-11-27 10:12:10.292 GMT [3116][client backend] [021_twophase.pl][1/2:0] LOG: statement: CREATE SUBSCRIPTION tap_sub CONNECTION 'port=16223 host=C:/Windows/TEMP/AQZ6yTggtK dbname=postgres application_name=tap_sub' PUBLICATION tap_pub WITH (two_phase = on) 2024-11-27 10:12:10.352 GMT [3116][client backend] [021_twophase.pl][:0] LOG: disconnection: session time: 0:00:00.069 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:10.363 GMT [5056][logical replication apply worker] LOG: logical replication apply worker for subscription "tap_sub" has started 2024-11-27 10:12:10.550 GMT [8136][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tap_sub", table "tab_full" has started 2024-11-27 10:12:10.587 GMT [5604][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:10.589 GMT [5604][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:10.589 GMT [5604][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=021_twophase.pl 2024-11-27 10:12:10.592 GMT [5604][client backend] [021_twophase.pl][2/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2024-11-27 10:12:10.599 GMT [5604][client backend] [021_twophase.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:10.616 GMT [8136][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tap_sub", table "tab_full" has finished 2024-11-27 10:12:10.623 GMT [5056][logical replication apply worker] LOG: logical replication apply worker for subscription "tap_sub" will restart so that two_phase can be enabled 2024-11-27 10:12:10.648 GMT [6112][logical replication apply worker] LOG: logical replication apply worker for subscription "tap_sub" has started 2024-11-27 10:12:10.808 GMT [4492][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:10.809 GMT [4492][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:10.810 GMT [4492][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=021_twophase.pl 2024-11-27 10:12:10.820 GMT [4492][client backend] [021_twophase.pl][3/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2024-11-27 10:12:10.824 GMT [4492][client backend] [021_twophase.pl][:0] LOG: disconnection: session time: 0:00:00.020 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:11.214 GMT [5008][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:11.215 GMT [5008][client backend] [[unknown]][4/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:11.215 GMT [5008][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=021_twophase.pl 2024-11-27 10:12:11.218 GMT [5008][client backend] [021_twophase.pl][4/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription WHERE subtwophasestate NOT IN ('e'); 2024-11-27 10:12:11.226 GMT [5008][client backend] [021_twophase.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:11.336 GMT [6112][logical replication apply worker] ERROR: prepared transactions are disabled 2024-11-27 10:12:11.336 GMT [6112][logical replication apply worker] HINT: Set "max_prepared_transactions" to a nonzero value. 2024-11-27 10:12:11.336 GMT [6112][logical replication apply worker] CONTEXT: processing remote data for replication origin "pg_16390" during message type "PREPARE" in transaction 749, finished at 0/178B528 2024-11-27 10:12:11.348 GMT [7812][postmaster] LOG: background worker "logical replication apply worker" (PID 6112) exited with exit code 1 2024-11-27 10:12:11.356 GMT [5272][logical replication apply worker] LOG: logical replication apply worker for subscription "tap_sub" has started 2024-11-27 10:12:11.381 GMT [5272][logical replication apply worker] ERROR: prepared transactions are disabled 2024-11-27 10:12:11.381 GMT [5272][logical replication apply worker] HINT: Set "max_prepared_transactions" to a nonzero value. 2024-11-27 10:12:11.381 GMT [5272][logical replication apply worker] CONTEXT: processing remote data for replication origin "pg_16390" during message type "PREPARE" in transaction 749, finished at 0/178B528 2024-11-27 10:12:11.385 GMT [7812][postmaster] LOG: background worker "logical replication apply worker" (PID 5272) exited with exit code 1 2024-11-27 10:12:11.403 GMT [7812][postmaster] LOG: received fast shutdown request 2024-11-27 10:12:11.403 GMT [7812][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: 7812 abort() has been called