2025-01-15 10:14:08.063 GMT [1540][postmaster] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30157, 64-bit 2025-01-15 10:14:08.064 GMT [1540][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/mqeiFc_HB8/.s.PGSQL.22651" 2025-01-15 10:14:08.108 GMT [6912][startup] LOG: database system was shut down at 2025-01-15 10:06:17 GMT 2025-01-15 10:14:08.121 GMT [1540][postmaster] LOG: database system is ready to accept connections 2025-01-15 10:14:08.410 GMT [5692][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:08.411 GMT [5692][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-15 10:14:08.412 GMT [5692][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=007_ddl.pl 2025-01-15 10:14:08.427 GMT [5692][client backend] [007_ddl.pl][0/2:0] LOG: statement: CREATE TABLE test1 (a int, b text); 2025-01-15 10:14:08.435 GMT [5692][client backend] [007_ddl.pl][:0] LOG: disconnection: session time: 0:00:00.028 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:08.622 GMT [3812][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:08.623 GMT [3812][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-15 10:14:08.623 GMT [3812][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=007_ddl.pl 2025-01-15 10:14:08.628 GMT [3812][client backend] [007_ddl.pl][1/2:0] LOG: statement: CREATE SUBSCRIPTION mysub CONNECTION 'port=22650 host=C:/Windows/TEMP/mqeiFc_HB8 dbname=postgres' PUBLICATION mypub; 2025-01-15 10:14:08.755 GMT [828][logical replication apply worker] LOG: logical replication apply worker for subscription "mysub" has started 2025-01-15 10:14:08.769 GMT [3812][client backend] [007_ddl.pl][:0] LOG: disconnection: session time: 0:00:00.150 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:08.833 GMT [584][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "mysub", table "test1" has started 2025-01-15 10:14:08.955 GMT [584][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "mysub", table "test1" has finished 2025-01-15 10:14:09.224 GMT [5808][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:09.226 GMT [5808][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-15 10:14:09.226 GMT [5808][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=007_ddl.pl 2025-01-15 10:14:09.229 GMT [5808][client backend] [007_ddl.pl][2/2:0] LOG: statement: BEGIN; 2025-01-15 10:14:09.229 GMT [5808][client backend] [007_ddl.pl][2/2:0] LOG: statement: ALTER SUBSCRIPTION mysub DISABLE; 2025-01-15 10:14:09.230 GMT [5808][client backend] [007_ddl.pl][2/2:754] LOG: statement: ALTER SUBSCRIPTION mysub SET (slot_name = NONE); 2025-01-15 10:14:09.230 GMT [5808][client backend] [007_ddl.pl][2/2:754] LOG: statement: DROP SUBSCRIPTION mysub; 2025-01-15 10:14:09.230 GMT [828][logical replication apply worker] FATAL: terminating logical replication worker due to administrator command 2025-01-15 10:14:09.245 GMT [1540][postmaster] LOG: background worker "logical replication apply worker" (PID 828) exited with exit code 1 2025-01-15 10:14:09.247 GMT [5808][client backend] [007_ddl.pl][2/2:754] LOG: statement: COMMIT; 2025-01-15 10:14:09.247 GMT [5808][client backend] [007_ddl.pl][:0] LOG: disconnection: session time: 0:00:00.025 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:09.321 GMT [1912][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:09.322 GMT [1912][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-15 10:14:09.322 GMT [1912][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=007_ddl.pl 2025-01-15 10:14:09.325 GMT [1912][client backend] [007_ddl.pl][3/2:0] LOG: statement: CREATE SUBSCRIPTION mysub1 CONNECTION 'port=22650 host=C:/Windows/TEMP/mqeiFc_HB8 dbname=postgres' PUBLICATION mypub, non_existent_pub 2025-01-15 10:14:09.359 GMT [1912][client backend] [007_ddl.pl][3/2:755] WARNING: publication "non_existent_pub" does not exist on the publisher 2025-01-15 10:14:09.389 GMT [1912][client backend] [007_ddl.pl][:0] LOG: disconnection: session time: 0:00:00.071 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:09.403 GMT [540][logical replication apply worker] LOG: logical replication apply worker for subscription "mysub1" has started 2025-01-15 10:14:09.469 GMT [4536][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:09.481 GMT [7568][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "mysub1", table "test1" has started 2025-01-15 10:14:09.482 GMT [4536][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-15 10:14:09.482 GMT [4536][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=007_ddl.pl 2025-01-15 10:14:09.488 GMT [4536][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-15 10:14:09.495 GMT [4536][client backend] [007_ddl.pl][:0] LOG: disconnection: session time: 0:00:00.029 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:09.533 GMT [7568][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "mysub1", table "test1" has finished 2025-01-15 10:14:09.666 GMT [4112][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:09.668 GMT [4112][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-15 10:14:09.668 GMT [4112][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=007_ddl.pl 2025-01-15 10:14:09.670 GMT [4112][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-15 10:14:09.675 GMT [4112][client backend] [007_ddl.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:10.027 GMT [6092][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:10.030 GMT [6092][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-15 10:14:10.030 GMT [6092][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=007_ddl.pl 2025-01-15 10:14:10.035 GMT [6092][client backend] [007_ddl.pl][6/2:0] LOG: statement: ALTER SUBSCRIPTION mysub1 ADD PUBLICATION non_existent_pub1, non_existent_pub2 2025-01-15 10:14:10.079 GMT [6092][client backend] [007_ddl.pl][6/2:0] WARNING: publications "non_existent_pub1", "non_existent_pub2" do not exist on the publisher 2025-01-15 10:14:10.086 GMT [540][logical replication apply worker] LOG: logical replication worker for subscription "mysub1" will restart because of a parameter change 2025-01-15 10:14:10.086 GMT [6092][client backend] [007_ddl.pl][:0] LOG: disconnection: session time: 0:00:00.064 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:10.121 GMT [7548][logical replication apply worker] LOG: logical replication apply worker for subscription "mysub1" has started 2025-01-15 10:14:10.181 GMT [1784][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:10.183 GMT [1784][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-15 10:14:10.183 GMT [1784][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=007_ddl.pl 2025-01-15 10:14:10.187 GMT [1784][client backend] [007_ddl.pl][7/2:0] LOG: statement: ALTER SUBSCRIPTION mysub1 SET PUBLICATION non_existent_pub 2025-01-15 10:14:10.224 GMT [1784][client backend] [007_ddl.pl][7/2:0] WARNING: publication "non_existent_pub" does not exist on the publisher 2025-01-15 10:14:10.234 GMT [7548][logical replication apply worker] LOG: logical replication worker for subscription "mysub1" will restart because of a parameter change 2025-01-15 10:14:10.247 GMT [1784][client backend] [007_ddl.pl][:0] LOG: disconnection: session time: 0:00:00.070 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:10.266 GMT [7924][logical replication apply worker] LOG: logical replication apply worker for subscription "mysub1" has started 2025-01-15 10:14:10.288 GMT [1540][postmaster] LOG: received fast shutdown request 2025-01-15 10:14:10.289 GMT [1540][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: 1540 abort() has been called