2025-01-28 23:39:36.099 GMT [5256][postmaster] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30158, 64-bit 2025-01-28 23:39:36.103 GMT [5256][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/O8O4dnCYhD/.s.PGSQL.29854" 2025-01-28 23:39:36.143 GMT [5972][startup] LOG: database system was shut down at 2025-01-28 23:31:56 GMT 2025-01-28 23:39:36.151 GMT [5256][postmaster] LOG: database system is ready to accept connections 2025-01-28 23:39:36.427 GMT [5548][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-28 23:39:36.428 GMT [5548][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/007_ddl/data/t_007_ddl_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-28 23:39:36.429 GMT [5548][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=007_ddl.pl 2025-01-28 23:39:36.448 GMT [5548][client backend] [007_ddl.pl][0/2:0] LOG: statement: CREATE TABLE test1 (a int, b text); 2025-01-28 23:39:36.459 GMT [5548][client backend] [007_ddl.pl][:0] LOG: disconnection: session time: 0:00:00.036 user=SYSTEM database=postgres host=[local] 2025-01-28 23:39:36.605 GMT [6600][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-28 23:39:36.606 GMT [6600][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/007_ddl/data/t_007_ddl_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-28 23:39:36.606 GMT [6600][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=007_ddl.pl 2025-01-28 23:39:36.610 GMT [6600][client backend] [007_ddl.pl][1/2:0] LOG: statement: CREATE SUBSCRIPTION mysub CONNECTION 'port=29853 host=C:/Windows/TEMP/O8O4dnCYhD dbname=postgres' PUBLICATION mypub; 2025-01-28 23:39:36.710 GMT [6600][client backend] [007_ddl.pl][:0] LOG: disconnection: session time: 0:00:00.108 user=SYSTEM database=postgres host=[local] 2025-01-28 23:39:36.720 GMT [2320][logical replication apply worker] LOG: logical replication apply worker for subscription "mysub" has started 2025-01-28 23:39:36.776 GMT [1184][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "mysub", table "test1" has started 2025-01-28 23:39:36.836 GMT [1184][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "mysub", table "test1" has finished 2025-01-28 23:39:37.209 GMT [6820][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-28 23:39:37.211 GMT [6820][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/007_ddl/data/t_007_ddl_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-28 23:39:37.211 GMT [6820][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=007_ddl.pl 2025-01-28 23:39:37.214 GMT [6820][client backend] [007_ddl.pl][2/2:0] LOG: statement: BEGIN; 2025-01-28 23:39:37.214 GMT [6820][client backend] [007_ddl.pl][2/2:0] LOG: statement: ALTER SUBSCRIPTION mysub DISABLE; 2025-01-28 23:39:37.215 GMT [6820][client backend] [007_ddl.pl][2/2:754] LOG: statement: ALTER SUBSCRIPTION mysub SET (slot_name = NONE); 2025-01-28 23:39:37.216 GMT [6820][client backend] [007_ddl.pl][2/2:754] LOG: statement: DROP SUBSCRIPTION mysub; 2025-01-28 23:39:37.216 GMT [2320][logical replication apply worker] FATAL: terminating logical replication worker due to administrator command 2025-01-28 23:39:37.224 GMT [5256][postmaster] LOG: background worker "logical replication apply worker" (PID 2320) exited with exit code 1 2025-01-28 23:39:37.232 GMT [6820][client backend] [007_ddl.pl][2/2:754] LOG: statement: COMMIT; 2025-01-28 23:39:37.233 GMT [6820][client backend] [007_ddl.pl][:0] LOG: disconnection: session time: 0:00:00.027 user=SYSTEM database=postgres host=[local] 2025-01-28 23:39:37.319 GMT [5460][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-28 23:39:37.321 GMT [5460][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/007_ddl/data/t_007_ddl_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-28 23:39:37.321 GMT [5460][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=007_ddl.pl 2025-01-28 23:39:37.325 GMT [5460][client backend] [007_ddl.pl][3/2:0] LOG: statement: CREATE SUBSCRIPTION mysub1 CONNECTION 'port=29853 host=C:/Windows/TEMP/O8O4dnCYhD dbname=postgres' PUBLICATION mypub, non_existent_pub 2025-01-28 23:39:37.358 GMT [5460][client backend] [007_ddl.pl][3/2:755] WARNING: publication "non_existent_pub" does not exist on the publisher 2025-01-28 23:39:37.384 GMT [5460][client backend] [007_ddl.pl][:0] LOG: disconnection: session time: 0:00:00.071 user=SYSTEM database=postgres host=[local] 2025-01-28 23:39:37.403 GMT [6732][logical replication apply worker] LOG: logical replication apply worker for subscription "mysub1" has started 2025-01-28 23:39:37.470 GMT [712][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "mysub1", table "test1" has started 2025-01-28 23:39:37.486 GMT [4280][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-28 23:39:37.488 GMT [4280][client backend] [[unknown]][4/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/007_ddl/data/t_007_ddl_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-28 23:39:37.488 GMT [4280][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=007_ddl.pl 2025-01-28 23:39:37.497 GMT [4280][client backend] [007_ddl.pl][4/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2025-01-28 23:39:37.514 GMT [4280][client backend] [007_ddl.pl][:0] LOG: disconnection: session time: 0:00:00.039 user=SYSTEM database=postgres host=[local] 2025-01-28 23:39:37.530 GMT [712][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "mysub1", table "test1" has finished 2025-01-28 23:39:37.753 GMT [4868][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-28 23:39:37.755 GMT [4868][client backend] [[unknown]][5/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/007_ddl/data/t_007_ddl_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-28 23:39:37.755 GMT [4868][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=007_ddl.pl 2025-01-28 23:39:37.758 GMT [4868][client backend] [007_ddl.pl][5/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2025-01-28 23:39:37.764 GMT [4868][client backend] [007_ddl.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2025-01-28 23:39:38.062 GMT [4256][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-28 23:39:38.063 GMT [4256][client backend] [[unknown]][6/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/007_ddl/data/t_007_ddl_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-28 23:39:38.063 GMT [4256][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=007_ddl.pl 2025-01-28 23:39:38.066 GMT [4256][client backend] [007_ddl.pl][6/2:0] LOG: statement: ALTER SUBSCRIPTION mysub1 ADD PUBLICATION non_existent_pub1, non_existent_pub2 2025-01-28 23:39:38.096 GMT [4256][client backend] [007_ddl.pl][6/2:0] WARNING: publications "non_existent_pub1", "non_existent_pub2" do not exist on the publisher 2025-01-28 23:39:38.104 GMT [6732][logical replication apply worker] LOG: logical replication worker for subscription "mysub1" will restart because of a parameter change 2025-01-28 23:39:38.108 GMT [4256][client backend] [007_ddl.pl][:0] LOG: disconnection: session time: 0:00:00.049 user=SYSTEM database=postgres host=[local] 2025-01-28 23:39:38.130 GMT [5924][logical replication apply worker] LOG: logical replication apply worker for subscription "mysub1" has started 2025-01-28 23:39:38.200 GMT [5052][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-28 23:39:38.201 GMT [5052][client backend] [[unknown]][7/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/007_ddl/data/t_007_ddl_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-28 23:39:38.201 GMT [5052][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=007_ddl.pl 2025-01-28 23:39:38.204 GMT [5052][client backend] [007_ddl.pl][7/2:0] LOG: statement: ALTER SUBSCRIPTION mysub1 SET PUBLICATION non_existent_pub 2025-01-28 23:39:38.248 GMT [5052][client backend] [007_ddl.pl][7/2:0] WARNING: publication "non_existent_pub" does not exist on the publisher 2025-01-28 23:39:38.255 GMT [5924][logical replication apply worker] LOG: logical replication worker for subscription "mysub1" will restart because of a parameter change 2025-01-28 23:39:38.259 GMT [5052][client backend] [007_ddl.pl][:0] LOG: disconnection: session time: 0:00:00.064 user=SYSTEM database=postgres host=[local] 2025-01-28 23:39:38.281 GMT [7912][logical replication apply worker] LOG: logical replication apply worker for subscription "mysub1" has started 2025-01-28 23:39:38.315 GMT [5256][postmaster] LOG: received fast shutdown request 2025-01-28 23:39:38.315 GMT [5256][postmaster] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2951, PID: 5256 abort() has been called