2025-01-18 18:42:14.320 GMT [7324][postmaster] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30158, 64-bit 2025-01-18 18:42:14.323 GMT [7324][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/CMtnmkEvC0/.s.PGSQL.25221" 2025-01-18 18:42:14.348 GMT [3960][startup] LOG: database system was shut down at 2025-01-18 18:33:55 GMT 2025-01-18 18:42:14.357 GMT [7324][postmaster] LOG: database system is ready to accept connections 2025-01-18 18:42:14.773 GMT [7180][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:42:14.775 GMT [7180][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) 2025-01-18 18:42:14.775 GMT [7180][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=021_twophase.pl 2025-01-18 18:42:14.792 GMT [7180][client backend] [021_twophase.pl][0/2:0] LOG: statement: CREATE TABLE tab_full (a int PRIMARY KEY) 2025-01-18 18:42:14.800 GMT [7180][client backend] [021_twophase.pl][:0] LOG: disconnection: session time: 0:00:00.031 user=SYSTEM database=postgres host=[local] 2025-01-18 18:42:15.023 GMT [1028][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:42:15.025 GMT [1028][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) 2025-01-18 18:42:15.025 GMT [1028][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=021_twophase.pl 2025-01-18 18:42:15.028 GMT [1028][client backend] [021_twophase.pl][1/2:0] LOG: statement: CREATE SUBSCRIPTION tap_sub CONNECTION 'port=25220 host=C:/Windows/TEMP/CMtnmkEvC0 dbname=postgres application_name=tap_sub' PUBLICATION tap_pub WITH (two_phase = on) 2025-01-18 18:42:15.096 GMT [1028][client backend] [021_twophase.pl][:0] LOG: disconnection: session time: 0:00:00.076 user=SYSTEM database=postgres host=[local] 2025-01-18 18:42:15.108 GMT [5624][logical replication apply worker] LOG: logical replication apply worker for subscription "tap_sub" has started 2025-01-18 18:42:15.172 GMT [6716][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tap_sub", table "tab_full" has started 2025-01-18 18:42:15.221 GMT [7432][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:42:15.223 GMT [7432][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) 2025-01-18 18:42:15.223 GMT [7432][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=021_twophase.pl 2025-01-18 18:42:15.226 GMT [7432][client backend] [021_twophase.pl][2/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2025-01-18 18:42:15.233 GMT [7432][client backend] [021_twophase.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2025-01-18 18:42:15.245 GMT [6716][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tap_sub", table "tab_full" has finished 2025-01-18 18:42:15.256 GMT [5624][logical replication apply worker] LOG: logical replication apply worker for subscription "tap_sub" will restart so that two_phase can be enabled 2025-01-18 18:42:15.280 GMT [1128][logical replication apply worker] LOG: logical replication apply worker for subscription "tap_sub" has started 2025-01-18 18:42:15.407 GMT [6356][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:42:15.409 GMT [6356][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) 2025-01-18 18:42:15.409 GMT [6356][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=021_twophase.pl 2025-01-18 18:42:15.412 GMT [6356][client backend] [021_twophase.pl][3/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2025-01-18 18:42:15.417 GMT [6356][client backend] [021_twophase.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2025-01-18 18:42:16.023 GMT [5172][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:42:16.024 GMT [5172][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) 2025-01-18 18:42:16.024 GMT [5172][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=021_twophase.pl 2025-01-18 18:42:16.027 GMT [5172][client backend] [021_twophase.pl][4/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription WHERE subtwophasestate NOT IN ('e'); 2025-01-18 18:42:16.031 GMT [5172][client backend] [021_twophase.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-18 18:42:16.131 GMT [1128][logical replication apply worker] ERROR: prepared transactions are disabled 2025-01-18 18:42:16.131 GMT [1128][logical replication apply worker] HINT: Set "max_prepared_transactions" to a nonzero value. 2025-01-18 18:42:16.131 GMT [1128][logical replication apply worker] CONTEXT: processing remote data for replication origin "pg_16390" during message type "PREPARE" in transaction 750, finished at 0/178A980 2025-01-18 18:42:16.140 GMT [7324][postmaster] LOG: background worker "logical replication apply worker" (PID 1128) exited with exit code 1 2025-01-18 18:42:16.157 GMT [7600][logical replication apply worker] LOG: logical replication apply worker for subscription "tap_sub" has started 2025-01-18 18:42:16.198 GMT [7600][logical replication apply worker] ERROR: prepared transactions are disabled 2025-01-18 18:42:16.198 GMT [7600][logical replication apply worker] HINT: Set "max_prepared_transactions" to a nonzero value. 2025-01-18 18:42:16.198 GMT [7600][logical replication apply worker] CONTEXT: processing remote data for replication origin "pg_16390" during message type "PREPARE" in transaction 750, finished at 0/178A980 2025-01-18 18:42:16.208 GMT [7324][postmaster] LOG: received fast shutdown request 2025-01-18 18:42:16.208 GMT [7324][postmaster] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2909, PID: 7324 abort() has been called