2025-01-15 10:14:18.686 GMT [4908][postmaster] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30157, 64-bit 2025-01-15 10:14:18.688 GMT [4908][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/GuQLEc3nrA/.s.PGSQL.16424" 2025-01-15 10:14:18.726 GMT [7144][startup] LOG: database system was shut down at 2025-01-15 10:06:17 GMT 2025-01-15 10:14:18.762 GMT [4908][postmaster] LOG: database system is ready to accept connections 2025-01-15 10:14:21.304 GMT [2788][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:21.307 GMT [2788][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:21.307 GMT [2788][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:21.330 GMT [2788][client backend] [013_partition.pl][0/2:0] LOG: statement: CREATE TABLE tab1 (c text, a int PRIMARY KEY, b text) PARTITION BY LIST (a) 2025-01-15 10:14:21.344 GMT [2788][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.045 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:21.423 GMT [5296][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:21.425 GMT [5296][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:21.425 GMT [5296][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:21.428 GMT [5296][client backend] [013_partition.pl][1/2:0] LOG: statement: CREATE TABLE tab1_1 (b text, c text DEFAULT 'sub1_tab1', a int NOT NULL) 2025-01-15 10:14:21.436 GMT [5296][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:21.526 GMT [5324][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:21.527 GMT [5324][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:21.527 GMT [5324][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:21.530 GMT [5324][client backend] [013_partition.pl][2/2:0] LOG: statement: ALTER TABLE tab1 ATTACH PARTITION tab1_1 FOR VALUES IN (1, 2, 3) 2025-01-15 10:14:21.539 GMT [5324][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:21.653 GMT [7280][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:21.654 GMT [7280][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:21.654 GMT [7280][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:21.657 GMT [7280][client backend] [013_partition.pl][3/2:0] LOG: statement: CREATE TABLE tab1_2 PARTITION OF tab1 (c DEFAULT 'sub1_tab1') FOR VALUES IN (4, 5, 6) PARTITION BY LIST (a) 2025-01-15 10:14:21.662 GMT [7280][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:21.910 GMT [4764][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:21.912 GMT [4764][client backend] [[unknown]][4/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:21.912 GMT [4764][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:21.915 GMT [4764][client backend] [013_partition.pl][4/2:0] LOG: statement: CREATE TABLE tab1_2_1 (c text, b text, a int NOT NULL) 2025-01-15 10:14:21.923 GMT [4764][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:22.132 GMT [4916][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:22.133 GMT [4916][client backend] [[unknown]][5/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:22.133 GMT [4916][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:22.136 GMT [4916][client backend] [013_partition.pl][5/2:0] LOG: statement: ALTER TABLE tab1_2 ATTACH PARTITION tab1_2_1 FOR VALUES IN (5) 2025-01-15 10:14:22.144 GMT [4916][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:22.207 GMT [6800][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:22.209 GMT [6800][client backend] [[unknown]][6/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:22.209 GMT [6800][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:22.211 GMT [6800][client backend] [013_partition.pl][6/2:0] LOG: statement: CREATE TABLE tab1_2_2 PARTITION OF tab1_2 FOR VALUES IN (4, 6) 2025-01-15 10:14:22.224 GMT [6800][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.020 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:22.287 GMT [2716][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:22.289 GMT [2716][client backend] [[unknown]][7/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:22.289 GMT [2716][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:22.291 GMT [2716][client backend] [013_partition.pl][7/2:0] LOG: statement: CREATE TABLE tab1_def PARTITION OF tab1 (c DEFAULT 'sub1_tab1') DEFAULT 2025-01-15 10:14:22.301 GMT [2716][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:22.401 GMT [3664][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:22.402 GMT [3664][client backend] [[unknown]][8/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:22.402 GMT [3664][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:22.405 GMT [3664][client backend] [013_partition.pl][8/2:0] LOG: statement: CREATE SUBSCRIPTION sub1 CONNECTION 'port=16423 host=C:/Windows/TEMP/GuQLEc3nrA dbname=postgres' PUBLICATION pub1 2025-01-15 10:14:22.466 GMT [3664][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.068 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:22.495 GMT [7248][logical replication apply worker] LOG: logical replication apply worker for subscription "sub1" has started 2025-01-15 10:14:22.564 GMT [7108][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "sub1", table "tab1_def" has started 2025-01-15 10:14:22.610 GMT [1460][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "sub1", table "tab1_2" has started 2025-01-15 10:14:22.645 GMT [7108][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "sub1", table "tab1_def" has finished 2025-01-15 10:14:22.694 GMT [6168][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "sub1", table "tab1_1" has started 2025-01-15 10:14:22.699 GMT [7412][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:22.701 GMT [7412][client backend] [[unknown]][9/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:22.701 GMT [7412][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:22.706 GMT [7412][client backend] [013_partition.pl][9/2:0] LOG: statement: CREATE TABLE sub1_trigger_activity (tgtab text, tgop text, tgwhen text, tglevel text, olda int, newa int); 2025-01-15 10:14:22.706 GMT [1460][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "sub1", table "tab1_2" has finished 2025-01-15 10:14:22.712 GMT [7412][client backend] [013_partition.pl][9/3:0] LOG: statement: CREATE FUNCTION sub1_trigger_activity_func() RETURNS TRIGGER AS $$ BEGIN IF (TG_OP = 'INSERT') THEN INSERT INTO public.sub1_trigger_activity SELECT TG_RELNAME, TG_OP, TG_WHEN, TG_LEVEL, NULL, NEW.a; ELSIF (TG_OP = 'UPDATE') THEN INSERT INTO public.sub1_trigger_activity SELECT TG_RELNAME, TG_OP, TG_WHEN, TG_LEVEL, OLD.a, NEW.a; END IF; RETURN NULL; END; $$ LANGUAGE plpgsql; 2025-01-15 10:14:22.717 GMT [7412][client backend] [013_partition.pl][9/4:0] LOG: statement: CREATE TRIGGER sub1_tab1_log_op_trigger AFTER INSERT OR UPDATE ON tab1 FOR EACH ROW EXECUTE PROCEDURE sub1_trigger_activity_func(); 2025-01-15 10:14:22.722 GMT [7412][client backend] [013_partition.pl][9/5:0] LOG: statement: ALTER TABLE ONLY tab1 ENABLE REPLICA TRIGGER sub1_tab1_log_op_trigger; 2025-01-15 10:14:22.723 GMT [7412][client backend] [013_partition.pl][9/6:0] LOG: statement: CREATE TRIGGER sub1_tab1_2_log_op_trigger AFTER INSERT OR UPDATE ON tab1_2 FOR EACH ROW EXECUTE PROCEDURE sub1_trigger_activity_func(); 2025-01-15 10:14:22.723 GMT [7412][client backend] [013_partition.pl][9/7:0] LOG: statement: ALTER TABLE ONLY tab1_2 ENABLE REPLICA TRIGGER sub1_tab1_2_log_op_trigger; 2025-01-15 10:14:22.724 GMT [7412][client backend] [013_partition.pl][9/8:0] LOG: statement: CREATE TRIGGER sub1_tab1_2_2_log_op_trigger AFTER INSERT OR UPDATE ON tab1_2_2 FOR EACH ROW EXECUTE PROCEDURE sub1_trigger_activity_func(); 2025-01-15 10:14:22.724 GMT [7412][client backend] [013_partition.pl][9/9:0] LOG: statement: ALTER TABLE ONLY tab1_2_2 ENABLE REPLICA TRIGGER sub1_tab1_2_2_log_op_trigger; 2025-01-15 10:14:22.725 GMT [7412][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.028 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:22.771 GMT [6168][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "sub1", table "tab1_1" has finished 2025-01-15 10:14:23.875 GMT [2368][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:23.877 GMT [2368][client backend] [[unknown]][10/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:23.877 GMT [2368][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:23.881 GMT [2368][client backend] [013_partition.pl][10/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2025-01-15 10:14:23.890 GMT [2368][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.020 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:25.220 GMT [1460][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:25.222 GMT [1460][client backend] [[unknown]][11/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:25.222 GMT [1460][client backend] [[unknown]][11/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:25.227 GMT [1460][client backend] [013_partition.pl][11/2:0] LOG: statement: SELECT c, a FROM tab1 ORDER BY 1, 2 2025-01-15 10:14:25.240 GMT [1460][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.033 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:25.348 GMT [5336][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:25.350 GMT [5336][client backend] [[unknown]][12/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:25.350 GMT [5336][client backend] [[unknown]][12/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:25.354 GMT [5336][client backend] [013_partition.pl][12/2:0] LOG: statement: SELECT a FROM tab1_2_1 ORDER BY 1 2025-01-15 10:14:25.358 GMT [5336][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:25.438 GMT [432][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:25.440 GMT [432][client backend] [[unknown]][13/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:25.440 GMT [432][client backend] [[unknown]][13/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:25.442 GMT [432][client backend] [013_partition.pl][13/2:0] LOG: statement: SELECT a FROM tab1_2_2 ORDER BY 1 2025-01-15 10:14:25.445 GMT [432][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:26.977 GMT [7412][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:26.979 GMT [7412][client backend] [[unknown]][14/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:26.979 GMT [7412][client backend] [[unknown]][14/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:26.982 GMT [7412][client backend] [013_partition.pl][14/2:0] LOG: statement: SELECT c, a FROM tab1 ORDER BY 1, 2 2025-01-15 10:14:26.991 GMT [7412][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:27.067 GMT [3244][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:27.068 GMT [3244][client backend] [[unknown]][15/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:27.068 GMT [3244][client backend] [[unknown]][15/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:27.071 GMT [3244][client backend] [013_partition.pl][15/2:0] LOG: statement: SELECT a FROM tab1_2_1 ORDER BY 1 2025-01-15 10:14:27.073 GMT [3244][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:27.151 GMT [7908][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:27.152 GMT [7908][client backend] [[unknown]][16/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:27.152 GMT [7908][client backend] [[unknown]][16/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:27.155 GMT [7908][client backend] [013_partition.pl][16/2:0] LOG: statement: SELECT a FROM tab1_2_2 ORDER BY 1 2025-01-15 10:14:27.159 GMT [7908][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:27.242 GMT [6520][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:27.243 GMT [6520][client backend] [[unknown]][17/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:27.243 GMT [6520][client backend] [[unknown]][17/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:27.250 GMT [6520][client backend] [013_partition.pl][17/2:0] LOG: statement: SELECT * FROM sub1_trigger_activity ORDER BY tgtab, tgop, tgwhen, olda, newa; 2025-01-15 10:14:27.254 GMT [6520][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:28.951 GMT [788][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:28.953 GMT [788][client backend] [[unknown]][18/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:28.953 GMT [788][client backend] [[unknown]][18/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:28.961 GMT [788][client backend] [013_partition.pl][18/2:0] LOG: statement: SELECT c, a FROM tab1 ORDER BY 1, 2 2025-01-15 10:14:28.967 GMT [788][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:29.055 GMT [6416][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:29.056 GMT [6416][client backend] [[unknown]][19/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:29.056 GMT [6416][client backend] [[unknown]][19/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:29.064 GMT [6416][client backend] [013_partition.pl][19/2:0] LOG: statement: SELECT a FROM tab1_2_2 ORDER BY 1 2025-01-15 10:14:29.068 GMT [6416][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:30.518 GMT [7040][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:30.519 GMT [7040][client backend] [[unknown]][20/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:30.519 GMT [7040][client backend] [[unknown]][20/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:30.522 GMT [7040][client backend] [013_partition.pl][20/2:0] LOG: statement: SELECT a FROM tab1 2025-01-15 10:14:30.526 GMT [7040][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.029 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:30.824 GMT [6336][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:30.826 GMT [6336][client backend] [[unknown]][21/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:30.826 GMT [6336][client backend] [[unknown]][21/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:30.828 GMT [6336][client backend] [013_partition.pl][21/2:0] LOG: statement: INSERT INTO tab1 (a) VALUES (1), (2), (5) 2025-01-15 10:14:30.833 GMT [6336][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:31.556 GMT [4664][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:31.557 GMT [4664][client backend] [[unknown]][22/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:31.557 GMT [4664][client backend] [[unknown]][22/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:31.560 GMT [4664][client backend] [013_partition.pl][22/2:0] LOG: statement: SELECT a FROM tab1 ORDER BY 1 2025-01-15 10:14:31.566 GMT [4664][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:33.296 GMT [5872][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:33.298 GMT [5872][client backend] [[unknown]][23/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:33.298 GMT [5872][client backend] [[unknown]][23/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:33.300 GMT [5872][client backend] [013_partition.pl][23/2:0] LOG: statement: SELECT a FROM tab1 ORDER BY 1 2025-01-15 10:14:33.304 GMT [5872][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:34.958 GMT [4208][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:34.959 GMT [4208][client backend] [[unknown]][24/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:34.959 GMT [4208][client backend] [[unknown]][24/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:34.962 GMT [4208][client backend] [013_partition.pl][24/2:0] LOG: statement: DELETE FROM tab1 2025-01-15 10:14:34.965 GMT [4208][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:35.070 GMT [7248][logical replication apply worker] LOG: conflict detected on relation "public.tab1_2_2": conflict=update_missing 2025-01-15 10:14:35.070 GMT [7248][logical replication apply worker] DETAIL: Could not find the row to be updated. Remote tuple (null, 4, quux); replica identity (a)=(4). 2025-01-15 10:14:35.070 GMT [7248][logical replication apply worker] CONTEXT: processing remote data for replication origin "pg_16432" during message type "UPDATE" for replication target relation "public.tab1_2" in transaction 770, finished at 0/17B09A8 2025-01-15 10:14:35.172 GMT [7248][logical replication apply worker] LOG: conflict detected on relation "public.tab1_1": conflict=delete_missing 2025-01-15 10:14:35.172 GMT [7248][logical replication apply worker] DETAIL: Could not find the row to be deleted. Replica identity (a)=(1). 2025-01-15 10:14:35.172 GMT [7248][logical replication apply worker] CONTEXT: processing remote data for replication origin "pg_16432" during message type "DELETE" for replication target relation "public.tab1_1" in transaction 771, finished at 0/17B0A98 2025-01-15 10:14:35.172 GMT [7248][logical replication apply worker] LOG: conflict detected on relation "public.tab1_2_2": conflict=delete_missing 2025-01-15 10:14:35.172 GMT [7248][logical replication apply worker] DETAIL: Could not find the row to be deleted. Replica identity (a)=(4). 2025-01-15 10:14:35.172 GMT [7248][logical replication apply worker] CONTEXT: processing remote data for replication origin "pg_16432" during message type "DELETE" for replication target relation "public.tab1_2" in transaction 771, finished at 0/17B0A98 2025-01-15 10:14:35.172 GMT [7248][logical replication apply worker] LOG: conflict detected on relation "public.tab1_def": conflict=delete_missing 2025-01-15 10:14:35.172 GMT [7248][logical replication apply worker] DETAIL: Could not find the row to be deleted. Replica identity (a)=(10). 2025-01-15 10:14:35.172 GMT [7248][logical replication apply worker] CONTEXT: processing remote data for replication origin "pg_16432" during message type "DELETE" for replication target relation "public.tab1_def" in transaction 771, finished at 0/17B0A98 2025-01-15 10:14:37.988 GMT [7248][logical replication apply worker] ERROR: could not receive data from WAL stream: ERROR: publication "pub1" does not exist CONTEXT: slot "sub1", output plugin "pgoutput", in the change callback, associated LSN 0/17E4DC0 2025-01-15 10:14:38.011 GMT [4908][postmaster] LOG: background worker "logical replication apply worker" (PID 7248) exited with exit code 1 2025-01-15 10:14:38.048 GMT [436][logical replication apply worker] LOG: logical replication apply worker for subscription "sub1" has started 2025-01-15 10:14:38.101 GMT [436][logical replication apply worker] ERROR: could not receive data from WAL stream: ERROR: publication "pub1" does not exist CONTEXT: slot "sub1", output plugin "pgoutput", in the change callback, associated LSN 0/17E4DC0 2025-01-15 10:14:38.125 GMT [4908][postmaster] LOG: background worker "logical replication apply worker" (PID 436) exited with exit code 1 2025-01-15 10:14:38.239 GMT [3660][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:38.242 GMT [3660][client backend] [[unknown]][25/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:38.242 GMT [3660][client backend] [[unknown]][25/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:38.249 GMT [3660][client backend] [013_partition.pl][25/2:0] LOG: statement: DROP SUBSCRIPTION sub1 2025-01-15 10:14:38.303 GMT [3660][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.075 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:38.459 GMT [4640][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:38.460 GMT [4640][client backend] [[unknown]][26/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:38.460 GMT [4640][client backend] [[unknown]][26/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:38.462 GMT [4640][client backend] [013_partition.pl][26/2:0] LOG: statement: CREATE TABLE tab2 (a int PRIMARY KEY, c text DEFAULT 'sub1_tab2', b text) PARTITION BY RANGE (a) 2025-01-15 10:14:38.468 GMT [4640][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:38.616 GMT [7572][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:38.617 GMT [7572][client backend] [[unknown]][27/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:38.617 GMT [7572][client backend] [[unknown]][27/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:38.620 GMT [7572][client backend] [013_partition.pl][27/2:0] LOG: statement: CREATE TABLE tab2_1 (c text DEFAULT 'sub1_tab2', b text, a int NOT NULL) 2025-01-15 10:14:38.627 GMT [7572][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:38.728 GMT [4988][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:38.729 GMT [4988][client backend] [[unknown]][28/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:38.730 GMT [4988][client backend] [[unknown]][28/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:38.733 GMT [4988][client backend] [013_partition.pl][28/2:0] LOG: statement: ALTER TABLE tab2 ATTACH PARTITION tab2_1 FOR VALUES FROM (0) TO (10) 2025-01-15 10:14:38.740 GMT [4988][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:38.858 GMT [1596][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:38.859 GMT [1596][client backend] [[unknown]][29/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:38.859 GMT [1596][client backend] [[unknown]][29/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:38.862 GMT [1596][client backend] [013_partition.pl][29/2:0] LOG: statement: CREATE TABLE tab3_1 (c text DEFAULT 'sub1_tab3_1', b text, a int NOT NULL PRIMARY KEY) 2025-01-15 10:14:38.874 GMT [1596][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:38.975 GMT [3380][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:38.976 GMT [3380][client backend] [[unknown]][30/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:38.976 GMT [3380][client backend] [[unknown]][30/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:38.979 GMT [3380][client backend] [013_partition.pl][30/2:0] LOG: statement: CREATE SUBSCRIPTION sub_viaroot CONNECTION 'port=16423 host=C:/Windows/TEMP/GuQLEc3nrA dbname=postgres' PUBLICATION pub_viaroot 2025-01-15 10:14:39.053 GMT [3380][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.081 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:39.069 GMT [7888][logical replication apply worker] LOG: logical replication apply worker for subscription "sub_viaroot" has started 2025-01-15 10:14:39.160 GMT [2296][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "sub_viaroot", table "tab3_1" has started 2025-01-15 10:14:39.231 GMT [2296][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "sub_viaroot", table "tab3_1" has finished 2025-01-15 10:14:39.234 GMT [4436][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "sub_viaroot", table "tab2" has started 2025-01-15 10:14:39.346 GMT [4436][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "sub_viaroot", table "tab2" has finished 2025-01-15 10:14:41.096 GMT [1456][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:41.099 GMT [1456][client backend] [[unknown]][31/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:41.099 GMT [1456][client backend] [[unknown]][31/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:41.102 GMT [1456][client backend] [013_partition.pl][31/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2025-01-15 10:14:41.106 GMT [1456][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:41.618 GMT [8184][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:41.619 GMT [8184][client backend] [[unknown]][32/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:41.619 GMT [8184][client backend] [[unknown]][32/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:41.622 GMT [8184][client backend] [013_partition.pl][32/2:0] LOG: statement: SELECT c, a FROM tab2 2025-01-15 10:14:41.625 GMT [8184][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:42.972 GMT [3464][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:42.974 GMT [3464][client backend] [[unknown]][33/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:42.974 GMT [3464][client backend] [[unknown]][33/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:42.977 GMT [3464][client backend] [013_partition.pl][33/2:0] LOG: statement: SELECT c, a FROM tab2 ORDER BY 1, 2 2025-01-15 10:14:42.983 GMT [3464][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:43.123 GMT [2468][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:43.125 GMT [2468][client backend] [[unknown]][34/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:43.125 GMT [2468][client backend] [[unknown]][34/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:43.128 GMT [2468][client backend] [013_partition.pl][34/2:0] LOG: statement: SELECT c, a FROM tab3_1 ORDER BY 1, 2 2025-01-15 10:14:43.135 GMT [2468][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:45.995 GMT [1756][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:45.996 GMT [1756][client backend] [[unknown]][35/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:45.996 GMT [1756][client backend] [[unknown]][35/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:46.001 GMT [1756][client backend] [013_partition.pl][35/2:0] LOG: statement: SELECT c, a FROM tab2 ORDER BY 1, 2 2025-01-15 10:14:46.005 GMT [1756][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:46.101 GMT [4228][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:46.102 GMT [4228][client backend] [[unknown]][36/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:46.102 GMT [4228][client backend] [[unknown]][36/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:46.105 GMT [4228][client backend] [013_partition.pl][36/2:0] LOG: statement: SELECT c, a FROM tab3_1 ORDER BY 1, 2 2025-01-15 10:14:46.110 GMT [4228][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:47.437 GMT [5888][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:47.438 GMT [5888][client backend] [[unknown]][37/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:47.438 GMT [5888][client backend] [[unknown]][37/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:47.441 GMT [5888][client backend] [013_partition.pl][37/2:0] LOG: statement: SELECT c, a FROM tab2 ORDER BY 1, 2 2025-01-15 10:14:47.446 GMT [5888][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:47.564 GMT [5816][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:47.568 GMT [5816][client backend] [[unknown]][38/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:47.568 GMT [5816][client backend] [[unknown]][38/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:47.578 GMT [5816][client backend] [013_partition.pl][38/2:0] LOG: statement: SELECT c, a FROM tab3_1 ORDER BY 1, 2 2025-01-15 10:14:47.583 GMT [5816][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.036 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:49.032 GMT [2092][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:49.033 GMT [2092][client backend] [[unknown]][39/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:49.033 GMT [2092][client backend] [[unknown]][39/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:49.036 GMT [2092][client backend] [013_partition.pl][39/2:0] LOG: statement: SELECT a FROM tab2 2025-01-15 10:14:49.038 GMT [2092][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:50.805 GMT [4228][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:50.807 GMT [4228][client backend] [[unknown]][40/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:50.807 GMT [4228][client backend] [[unknown]][40/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:50.810 GMT [4228][client backend] [013_partition.pl][40/2:0] LOG: statement: SELECT a FROM tab2 ORDER BY 1 2025-01-15 10:14:50.814 GMT [4228][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:51.851 GMT [8168][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:51.853 GMT [8168][client backend] [[unknown]][41/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:51.853 GMT [8168][client backend] [[unknown]][41/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:51.856 GMT [8168][client backend] [013_partition.pl][41/2:0] LOG: statement: SELECT a FROM tab2 2025-01-15 10:14:51.858 GMT [8168][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:53.351 GMT [4816][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:53.352 GMT [4816][client backend] [[unknown]][42/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:53.352 GMT [4816][client backend] [[unknown]][42/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:53.355 GMT [4816][client backend] [013_partition.pl][42/2:0] LOG: statement: SELECT c, a, b FROM tab2 ORDER BY 1, 2 2025-01-15 10:14:53.367 GMT [4816][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:53.646 GMT [6196][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-15 10:14:53.647 GMT [6196][client backend] [[unknown]][43/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata/pg_hba.conf:117) 2025-01-15 10:14:53.647 GMT [6196][client backend] [[unknown]][43/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-15 10:14:53.650 GMT [6196][client backend] [013_partition.pl][43/2:0] LOG: statement: DELETE FROM tab2 2025-01-15 10:14:53.652 GMT [6196][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2025-01-15 10:14:53.747 GMT [7888][logical replication apply worker] LOG: conflict detected on relation "public.tab2_1": conflict=update_missing 2025-01-15 10:14:53.747 GMT [7888][logical replication apply worker] DETAIL: Could not find the row to be updated. Remote tuple (pub_tab2, quux, 5); replica identity (a)=(5). 2025-01-15 10:14:53.747 GMT [7888][logical replication apply worker] CONTEXT: processing remote data for replication origin "pg_16498" during message type "UPDATE" for replication target relation "public.tab2" in transaction 810, finished at 0/17F59F0 2025-01-15 10:14:53.874 GMT [7888][logical replication apply worker] LOG: conflict detected on relation "public.tab2_1": conflict=delete_missing 2025-01-15 10:14:53.874 GMT [7888][logical replication apply worker] DETAIL: Could not find the row to be deleted. Replica identity (a)=(1). 2025-01-15 10:14:53.874 GMT [7888][logical replication apply worker] CONTEXT: processing remote data for replication origin "pg_16498" during message type "DELETE" for replication target relation "public.tab2" in transaction 811, finished at 0/17F5A60 2025-01-15 10:14:54.572 GMT [4908][postmaster] LOG: received fast shutdown request 2025-01-15 10:14:54.572 GMT [4908][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: 4908 abort() has been called