2024-11-14 22:05:05.045 GMT [7320][postmaster] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30157, 64-bit 2024-11-14 22:05:05.048 GMT [7320][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/OmSVWaOMfW/.s.PGSQL.13450" 2024-11-14 22:05:05.066 GMT [7868][startup] LOG: database system was shut down at 2024-11-14 21:57:22 GMT 2024-11-14 22:05:05.073 GMT [7320][postmaster] LOG: database system is ready to accept connections 2024-11-14 22:05:05.309 GMT [7028][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-14 22:05:05.311 GMT [7028][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) 2024-11-14 22:05:05.312 GMT [7028][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=007_ddl.pl 2024-11-14 22:05:05.327 GMT [7028][client backend] [007_ddl.pl][0/2:0] LOG: statement: CREATE TABLE test1 (a int, b text); 2024-11-14 22:05:05.336 GMT [7028][client backend] [007_ddl.pl][:0] LOG: disconnection: session time: 0:00:00.030 user=SYSTEM database=postgres host=[local] 2024-11-14 22:05:05.597 GMT [5600][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-14 22:05:05.599 GMT [5600][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) 2024-11-14 22:05:05.599 GMT [5600][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=007_ddl.pl 2024-11-14 22:05:05.602 GMT [5600][client backend] [007_ddl.pl][1/2:0] LOG: statement: CREATE SUBSCRIPTION mysub CONNECTION 'port=13449 host=C:/Windows/TEMP/OmSVWaOMfW dbname=postgres' PUBLICATION mypub; 2024-11-14 22:05:05.695 GMT [5600][client backend] [007_ddl.pl][:0] LOG: disconnection: session time: 0:00:00.100 user=SYSTEM database=postgres host=[local] 2024-11-14 22:05:05.737 GMT [3204][logical replication apply worker] LOG: logical replication apply worker for subscription "mysub" has started 2024-11-14 22:05:05.791 GMT [7780][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "mysub", table "test1" has started 2024-11-14 22:05:05.853 GMT [7780][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "mysub", table "test1" has finished 2024-11-14 22:05:06.106 GMT [7272][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-14 22:05:06.108 GMT [7272][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) 2024-11-14 22:05:06.108 GMT [7272][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=007_ddl.pl 2024-11-14 22:05:06.111 GMT [7272][client backend] [007_ddl.pl][2/2:0] LOG: statement: BEGIN; 2024-11-14 22:05:06.111 GMT [7272][client backend] [007_ddl.pl][2/2:0] LOG: statement: ALTER SUBSCRIPTION mysub DISABLE; 2024-11-14 22:05:06.112 GMT [7272][client backend] [007_ddl.pl][2/2:753] LOG: statement: ALTER SUBSCRIPTION mysub SET (slot_name = NONE); 2024-11-14 22:05:06.112 GMT [7272][client backend] [007_ddl.pl][2/2:753] LOG: statement: DROP SUBSCRIPTION mysub; 2024-11-14 22:05:06.112 GMT [3204][logical replication apply worker] FATAL: terminating logical replication worker due to administrator command 2024-11-14 22:05:06.120 GMT [7272][client backend] [007_ddl.pl][2/2:753] LOG: statement: COMMIT; 2024-11-14 22:05:06.120 GMT [7272][client backend] [007_ddl.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2024-11-14 22:05:06.126 GMT [7320][postmaster] LOG: background worker "logical replication apply worker" (PID 3204) exited with exit code 1 2024-11-14 22:05:06.225 GMT [5988][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-14 22:05:06.227 GMT [5988][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) 2024-11-14 22:05:06.227 GMT [5988][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=007_ddl.pl 2024-11-14 22:05:06.230 GMT [5988][client backend] [007_ddl.pl][3/2:0] LOG: statement: CREATE SUBSCRIPTION mysub1 CONNECTION 'port=13449 host=C:/Windows/TEMP/OmSVWaOMfW dbname=postgres' PUBLICATION mypub, non_existent_pub 2024-11-14 22:05:06.270 GMT [5988][client backend] [007_ddl.pl][3/2:754] WARNING: publication "non_existent_pub" does not exist on the publisher 2024-11-14 22:05:06.296 GMT [5988][client backend] [007_ddl.pl][:0] LOG: disconnection: session time: 0:00:00.075 user=SYSTEM database=postgres host=[local] 2024-11-14 22:05:06.323 GMT [396][logical replication apply worker] LOG: logical replication apply worker for subscription "mysub1" has started 2024-11-14 22:05:06.397 GMT [1604][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "mysub1", table "test1" has started 2024-11-14 22:05:06.399 GMT [5452][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-14 22:05:06.400 GMT [5452][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) 2024-11-14 22:05:06.400 GMT [5452][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=007_ddl.pl 2024-11-14 22:05:06.403 GMT [5452][client backend] [007_ddl.pl][4/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2024-11-14 22:05:06.471 GMT [5452][client backend] [007_ddl.pl][:0] LOG: disconnection: session time: 0:00:00.076 user=SYSTEM database=postgres host=[local] 2024-11-14 22:05:06.498 GMT [1604][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "mysub1", table "test1" has finished 2024-11-14 22:05:06.715 GMT [4048][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-14 22:05:06.716 GMT [4048][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) 2024-11-14 22:05:06.716 GMT [4048][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=007_ddl.pl 2024-11-14 22:05:06.720 GMT [4048][client backend] [007_ddl.pl][5/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2024-11-14 22:05:06.724 GMT [4048][client backend] [007_ddl.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2024-11-14 22:05:07.215 GMT [7644][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-14 22:05:07.216 GMT [7644][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) 2024-11-14 22:05:07.216 GMT [7644][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=007_ddl.pl 2024-11-14 22:05:07.219 GMT [7644][client backend] [007_ddl.pl][6/2:0] LOG: statement: ALTER SUBSCRIPTION mysub1 ADD PUBLICATION non_existent_pub1, non_existent_pub2 2024-11-14 22:05:07.250 GMT [7644][client backend] [007_ddl.pl][6/2:0] WARNING: publications "non_existent_pub1", "non_existent_pub2" do not exist on the publisher 2024-11-14 22:05:07.257 GMT [396][logical replication apply worker] LOG: logical replication worker for subscription "mysub1" will restart because of a parameter change 2024-11-14 22:05:07.261 GMT [7644][client backend] [007_ddl.pl][:0] LOG: disconnection: session time: 0:00:00.056 user=SYSTEM database=postgres host=[local] 2024-11-14 22:05:07.296 GMT [4428][logical replication apply worker] LOG: logical replication apply worker for subscription "mysub1" has started 2024-11-14 22:05:07.419 GMT [4484][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-14 22:05:07.420 GMT [4484][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) 2024-11-14 22:05:07.420 GMT [4484][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=007_ddl.pl 2024-11-14 22:05:07.423 GMT [4484][client backend] [007_ddl.pl][7/2:0] LOG: statement: ALTER SUBSCRIPTION mysub1 SET PUBLICATION non_existent_pub 2024-11-14 22:05:07.461 GMT [4484][client backend] [007_ddl.pl][7/2:0] WARNING: publication "non_existent_pub" does not exist on the publisher 2024-11-14 22:05:07.467 GMT [4428][logical replication apply worker] LOG: logical replication worker for subscription "mysub1" will restart because of a parameter change 2024-11-14 22:05:07.469 GMT [4484][client backend] [007_ddl.pl][:0] LOG: disconnection: session time: 0:00:00.053 user=SYSTEM database=postgres host=[local] 2024-11-14 22:05:07.505 GMT [5820][logical replication apply worker] LOG: logical replication apply worker for subscription "mysub1" has started 2024-11-14 22:05:07.507 GMT [7320][postmaster] LOG: received fast shutdown request 2024-11-14 22:05:07.507 GMT [7320][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: 7320 abort() has been called