2024-12-11 13:39:11.458 GMT [3772][postmaster] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30157, 64-bit 2024-12-11 13:39:11.460 GMT [3772][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/wgFot4cvoX/.s.PGSQL.24939" 2024-12-11 13:39:11.537 GMT [5800][startup] LOG: database system was shut down at 2024-12-11 13:29:36 GMT 2024-12-11 13:39:11.566 GMT [3772][postmaster] LOG: database system is ready to accept connections 2024-12-11 13:39:14.942 GMT [4200][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:14.946 GMT [4200][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) 2024-12-11 13:39:14.946 GMT [4200][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:14.988 GMT [4200][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) 2024-12-11 13:39:15.000 GMT [4200][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.061 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:15.204 GMT [3476][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:15.207 GMT [3476][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) 2024-12-11 13:39:15.207 GMT [3476][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:15.212 GMT [3476][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) 2024-12-11 13:39:15.225 GMT [3476][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.030 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:15.437 GMT [7088][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:15.438 GMT [7088][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) 2024-12-11 13:39:15.438 GMT [7088][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:15.442 GMT [7088][client backend] [013_partition.pl][2/2:0] LOG: statement: ALTER TABLE tab1 ATTACH PARTITION tab1_1 FOR VALUES IN (1, 2, 3) 2024-12-11 13:39:15.453 GMT [7088][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.031 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:15.623 GMT [4896][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:15.624 GMT [4896][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) 2024-12-11 13:39:15.624 GMT [4896][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:15.640 GMT [4896][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) 2024-12-11 13:39:15.649 GMT [4896][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.030 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:15.788 GMT [6904][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:15.790 GMT [6904][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) 2024-12-11 13:39:15.790 GMT [6904][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:15.794 GMT [6904][client backend] [013_partition.pl][4/2:0] LOG: statement: CREATE TABLE tab1_2_1 (c text, b text, a int NOT NULL) 2024-12-11 13:39:15.802 GMT [6904][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:15.972 GMT [6288][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:15.973 GMT [6288][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) 2024-12-11 13:39:15.974 GMT [6288][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:15.977 GMT [6288][client backend] [013_partition.pl][5/2:0] LOG: statement: ALTER TABLE tab1_2 ATTACH PARTITION tab1_2_1 FOR VALUES IN (5) 2024-12-11 13:39:15.986 GMT [6288][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.026 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:16.093 GMT [6444][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:16.094 GMT [6444][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) 2024-12-11 13:39:16.094 GMT [6444][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:16.098 GMT [6444][client backend] [013_partition.pl][6/2:0] LOG: statement: CREATE TABLE tab1_2_2 PARTITION OF tab1_2 FOR VALUES IN (4, 6) 2024-12-11 13:39:16.110 GMT [6444][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:16.226 GMT [4816][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:16.228 GMT [4816][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) 2024-12-11 13:39:16.228 GMT [4816][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:16.241 GMT [4816][client backend] [013_partition.pl][7/2:0] LOG: statement: CREATE TABLE tab1_def PARTITION OF tab1 (c DEFAULT 'sub1_tab1') DEFAULT 2024-12-11 13:39:16.254 GMT [4816][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.035 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:16.411 GMT [3648][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:16.416 GMT [3648][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) 2024-12-11 13:39:16.416 GMT [3648][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:16.422 GMT [3648][client backend] [013_partition.pl][8/2:0] LOG: statement: CREATE SUBSCRIPTION sub1 CONNECTION 'port=24938 host=C:/Windows/TEMP/wgFot4cvoX dbname=postgres' PUBLICATION pub1 2024-12-11 13:39:16.500 GMT [3648][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.097 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:16.548 GMT [5428][logical replication apply worker] LOG: logical replication apply worker for subscription "sub1" has started 2024-12-11 13:39:16.622 GMT [4952][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "sub1", table "tab1_def" has started 2024-12-11 13:39:16.697 GMT [6052][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:16.702 GMT [6052][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) 2024-12-11 13:39:16.702 GMT [6052][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:16.710 GMT [6052][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); 2024-12-11 13:39:16.722 GMT [6052][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; 2024-12-11 13:39:16.725 GMT [6052][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(); 2024-12-11 13:39:16.725 GMT [1968][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "sub1", table "tab1_2" has started 2024-12-11 13:39:16.730 GMT [6052][client backend] [013_partition.pl][9/5:0] LOG: statement: ALTER TABLE ONLY tab1 ENABLE REPLICA TRIGGER sub1_tab1_log_op_trigger; 2024-12-11 13:39:16.730 GMT [6052][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(); 2024-12-11 13:39:16.731 GMT [4952][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "sub1", table "tab1_def" has finished 2024-12-11 13:39:16.732 GMT [6052][client backend] [013_partition.pl][9/7:0] LOG: statement: ALTER TABLE ONLY tab1_2 ENABLE REPLICA TRIGGER sub1_tab1_2_log_op_trigger; 2024-12-11 13:39:16.733 GMT [6052][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(); 2024-12-11 13:39:16.733 GMT [6052][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; 2024-12-11 13:39:16.734 GMT [6052][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.048 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:16.832 GMT [4416][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "sub1", table "tab1_1" has started 2024-12-11 13:39:16.852 GMT [1968][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "sub1", table "tab1_2" has finished 2024-12-11 13:39:16.958 GMT [4416][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "sub1", table "tab1_1" has finished 2024-12-11 13:39:18.044 GMT [2868][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:18.046 GMT [2868][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) 2024-12-11 13:39:18.046 GMT [2868][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:18.049 GMT [2868][client backend] [013_partition.pl][10/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2024-12-11 13:39:18.289 GMT [2868][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.249 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:20.359 GMT [520][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:20.361 GMT [520][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) 2024-12-11 13:39:20.361 GMT [520][client backend] [[unknown]][11/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:20.368 GMT [520][client backend] [013_partition.pl][11/2:0] LOG: statement: SELECT c, a FROM tab1 ORDER BY 1, 2 2024-12-11 13:39:20.377 GMT [520][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.021 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:20.589 GMT [2920][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:20.591 GMT [2920][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) 2024-12-11 13:39:20.591 GMT [2920][client backend] [[unknown]][12/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:20.596 GMT [2920][client backend] [013_partition.pl][12/2:0] LOG: statement: SELECT a FROM tab1_2_1 ORDER BY 1 2024-12-11 13:39:20.601 GMT [2920][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.020 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:20.720 GMT [6552][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:20.722 GMT [6552][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) 2024-12-11 13:39:20.722 GMT [6552][client backend] [[unknown]][13/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:20.726 GMT [6552][client backend] [013_partition.pl][13/2:0] LOG: statement: SELECT a FROM tab1_2_2 ORDER BY 1 2024-12-11 13:39:20.728 GMT [6552][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:23.769 GMT [5936][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:23.780 GMT [5936][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) 2024-12-11 13:39:23.780 GMT [5936][client backend] [[unknown]][14/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:23.787 GMT [5936][client backend] [013_partition.pl][14/2:0] LOG: statement: SELECT c, a FROM tab1 ORDER BY 1, 2 2024-12-11 13:39:23.797 GMT [5936][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.056 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:24.000 GMT [6284][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:24.001 GMT [6284][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) 2024-12-11 13:39:24.001 GMT [6284][client backend] [[unknown]][15/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:24.029 GMT [6284][client backend] [013_partition.pl][15/2:0] LOG: statement: SELECT a FROM tab1_2_1 ORDER BY 1 2024-12-11 13:39:24.034 GMT [6284][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.039 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:24.210 GMT [6468][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:24.212 GMT [6468][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) 2024-12-11 13:39:24.212 GMT [6468][client backend] [[unknown]][16/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:24.215 GMT [6468][client backend] [013_partition.pl][16/2:0] LOG: statement: SELECT a FROM tab1_2_2 ORDER BY 1 2024-12-11 13:39:24.221 GMT [6468][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:24.426 GMT [4652][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:24.428 GMT [4652][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) 2024-12-11 13:39:24.428 GMT [4652][client backend] [[unknown]][17/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:24.431 GMT [4652][client backend] [013_partition.pl][17/2:0] LOG: statement: SELECT * FROM sub1_trigger_activity ORDER BY tgtab, tgop, tgwhen, olda, newa; 2024-12-11 13:39:24.438 GMT [4652][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.018 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:26.891 GMT [1680][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:26.893 GMT [1680][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) 2024-12-11 13:39:26.893 GMT [1680][client backend] [[unknown]][18/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:26.901 GMT [1680][client backend] [013_partition.pl][18/2:0] LOG: statement: SELECT c, a FROM tab1 ORDER BY 1, 2 2024-12-11 13:39:26.909 GMT [1680][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.021 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:27.080 GMT [2844][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:27.081 GMT [2844][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) 2024-12-11 13:39:27.081 GMT [2844][client backend] [[unknown]][19/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:27.084 GMT [2844][client backend] [013_partition.pl][19/2:0] LOG: statement: SELECT a FROM tab1_2_2 ORDER BY 1 2024-12-11 13:39:27.089 GMT [2844][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:29.073 GMT [6612][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:29.075 GMT [6612][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) 2024-12-11 13:39:29.076 GMT [6612][client backend] [[unknown]][20/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:29.079 GMT [6612][client backend] [013_partition.pl][20/2:0] LOG: statement: SELECT a FROM tab1 2024-12-11 13:39:29.083 GMT [6612][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:29.530 GMT [1776][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:29.532 GMT [1776][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) 2024-12-11 13:39:29.532 GMT [1776][client backend] [[unknown]][21/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:29.535 GMT [1776][client backend] [013_partition.pl][21/2:0] LOG: statement: INSERT INTO tab1 (a) VALUES (1), (2), (5) 2024-12-11 13:39:29.540 GMT [1776][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:31.531 GMT [488][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:31.533 GMT [488][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) 2024-12-11 13:39:31.533 GMT [488][client backend] [[unknown]][22/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:31.537 GMT [488][client backend] [013_partition.pl][22/2:0] LOG: statement: SELECT a FROM tab1 ORDER BY 1 2024-12-11 13:39:31.546 GMT [488][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.029 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:33.312 GMT [6520][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:33.313 GMT [6520][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) 2024-12-11 13:39:33.314 GMT [6520][client backend] [[unknown]][23/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:33.318 GMT [6520][client backend] [013_partition.pl][23/2:0] LOG: statement: SELECT a FROM tab1 ORDER BY 1 2024-12-11 13:39:33.323 GMT [6520][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.025 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:35.570 GMT [2876][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:35.572 GMT [2876][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) 2024-12-11 13:39:35.572 GMT [2876][client backend] [[unknown]][24/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:35.576 GMT [2876][client backend] [013_partition.pl][24/2:0] LOG: statement: DELETE FROM tab1 2024-12-11 13:39:35.581 GMT [2876][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:35.763 GMT [5428][logical replication apply worker] LOG: conflict detected on relation "public.tab1_2_2": conflict=update_missing 2024-12-11 13:39:35.763 GMT [5428][logical replication apply worker] DETAIL: Could not find the row to be updated. Remote tuple (null, 4, quux); replica identity (a)=(4). 2024-12-11 13:39:35.763 GMT [5428][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 769, finished at 0/17B3FF0 2024-12-11 13:39:35.903 GMT [5428][logical replication apply worker] LOG: conflict detected on relation "public.tab1_1": conflict=delete_missing 2024-12-11 13:39:35.903 GMT [5428][logical replication apply worker] DETAIL: Could not find the row to be deleted. Replica identity (a)=(1). 2024-12-11 13:39:35.903 GMT [5428][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 770, finished at 0/17B40F8 2024-12-11 13:39:35.903 GMT [5428][logical replication apply worker] LOG: conflict detected on relation "public.tab1_2_2": conflict=delete_missing 2024-12-11 13:39:35.903 GMT [5428][logical replication apply worker] DETAIL: Could not find the row to be deleted. Replica identity (a)=(4). 2024-12-11 13:39:35.903 GMT [5428][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 770, finished at 0/17B40F8 2024-12-11 13:39:35.903 GMT [5428][logical replication apply worker] LOG: conflict detected on relation "public.tab1_def": conflict=delete_missing 2024-12-11 13:39:35.903 GMT [5428][logical replication apply worker] DETAIL: Could not find the row to be deleted. Replica identity (a)=(10). 2024-12-11 13:39:35.903 GMT [5428][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 770, finished at 0/17B40F8 2024-12-11 13:39:39.531 GMT [5428][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/17E86F8 2024-12-11 13:39:39.615 GMT [6936][logical replication apply worker] LOG: logical replication apply worker for subscription "sub1" has started 2024-12-11 13:39:39.679 GMT [3772][postmaster] LOG: background worker "logical replication apply worker" (PID 5428) exited with exit code 1 2024-12-11 13:39:39.706 GMT [6936][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/17E86F8 2024-12-11 13:39:39.730 GMT [3772][postmaster] LOG: background worker "logical replication apply worker" (PID 6936) exited with exit code 1 2024-12-11 13:39:39.993 GMT [3684][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:39.995 GMT [3684][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) 2024-12-11 13:39:39.995 GMT [3684][client backend] [[unknown]][25/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:39.998 GMT [3684][client backend] [013_partition.pl][25/2:0] LOG: statement: DROP SUBSCRIPTION sub1 2024-12-11 13:39:40.086 GMT [3684][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.097 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:40.317 GMT [5520][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:40.318 GMT [5520][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) 2024-12-11 13:39:40.318 GMT [5520][client backend] [[unknown]][26/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:40.321 GMT [5520][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) 2024-12-11 13:39:40.327 GMT [5520][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:40.557 GMT [7160][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:40.559 GMT [7160][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) 2024-12-11 13:39:40.559 GMT [7160][client backend] [[unknown]][27/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:40.564 GMT [7160][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) 2024-12-11 13:39:40.574 GMT [7160][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.026 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:40.769 GMT [4992][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:40.770 GMT [4992][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) 2024-12-11 13:39:40.770 GMT [4992][client backend] [[unknown]][28/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:40.774 GMT [4992][client backend] [013_partition.pl][28/2:0] LOG: statement: ALTER TABLE tab2 ATTACH PARTITION tab2_1 FOR VALUES FROM (0) TO (10) 2024-12-11 13:39:40.781 GMT [4992][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:40.916 GMT [5376][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:40.918 GMT [5376][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) 2024-12-11 13:39:40.918 GMT [5376][client backend] [[unknown]][29/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:40.946 GMT [5376][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) 2024-12-11 13:39:40.957 GMT [5376][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.045 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:41.149 GMT [600][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:41.150 GMT [600][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) 2024-12-11 13:39:41.150 GMT [600][client backend] [[unknown]][30/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:41.154 GMT [600][client backend] [013_partition.pl][30/2:0] LOG: statement: CREATE SUBSCRIPTION sub_viaroot CONNECTION 'port=24938 host=C:/Windows/TEMP/wgFot4cvoX dbname=postgres' PUBLICATION pub_viaroot 2024-12-11 13:39:41.282 GMT [600][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.136 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:41.309 GMT [6796][logical replication apply worker] LOG: logical replication apply worker for subscription "sub_viaroot" has started 2024-12-11 13:39:41.442 GMT [2604][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "sub_viaroot", table "tab3_1" has started 2024-12-11 13:39:41.481 GMT [4632][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "sub_viaroot", table "tab2" has started 2024-12-11 13:39:41.574 GMT [2604][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "sub_viaroot", table "tab3_1" has finished 2024-12-11 13:39:41.590 GMT [4632][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "sub_viaroot", table "tab2" has finished 2024-12-11 13:39:43.409 GMT [2260][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:43.411 GMT [2260][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) 2024-12-11 13:39:43.411 GMT [2260][client backend] [[unknown]][31/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:43.414 GMT [2260][client backend] [013_partition.pl][31/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2024-12-11 13:39:43.420 GMT [2260][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:44.008 GMT [1260][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:44.011 GMT [1260][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) 2024-12-11 13:39:44.011 GMT [1260][client backend] [[unknown]][32/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:44.015 GMT [1260][client backend] [013_partition.pl][32/2:0] LOG: statement: SELECT c, a FROM tab2 2024-12-11 13:39:44.026 GMT [1260][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.031 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:46.131 GMT [6120][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:46.136 GMT [6120][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) 2024-12-11 13:39:46.136 GMT [6120][client backend] [[unknown]][33/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:46.149 GMT [6120][client backend] [013_partition.pl][33/2:0] LOG: statement: SELECT c, a FROM tab2 ORDER BY 1, 2 2024-12-11 13:39:46.158 GMT [6120][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.036 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:46.308 GMT [4740][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:46.310 GMT [4740][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) 2024-12-11 13:39:46.310 GMT [4740][client backend] [[unknown]][34/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:46.317 GMT [4740][client backend] [013_partition.pl][34/2:0] LOG: statement: SELECT c, a FROM tab3_1 ORDER BY 1, 2 2024-12-11 13:39:46.326 GMT [4740][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.033 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:49.884 GMT [6468][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:49.886 GMT [6468][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) 2024-12-11 13:39:49.886 GMT [6468][client backend] [[unknown]][35/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:49.889 GMT [6468][client backend] [013_partition.pl][35/2:0] LOG: statement: SELECT c, a FROM tab2 ORDER BY 1, 2 2024-12-11 13:39:49.897 GMT [6468][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.018 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:50.044 GMT [5668][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:50.045 GMT [5668][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) 2024-12-11 13:39:50.045 GMT [5668][client backend] [[unknown]][36/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:50.048 GMT [5668][client backend] [013_partition.pl][36/2:0] LOG: statement: SELECT c, a FROM tab3_1 ORDER BY 1, 2 2024-12-11 13:39:50.053 GMT [5668][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:52.015 GMT [5076][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:52.017 GMT [5076][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) 2024-12-11 13:39:52.017 GMT [5076][client backend] [[unknown]][37/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:52.024 GMT [5076][client backend] [013_partition.pl][37/2:0] LOG: statement: SELECT c, a FROM tab2 ORDER BY 1, 2 2024-12-11 13:39:52.043 GMT [5076][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.032 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:52.177 GMT [5468][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:52.179 GMT [5468][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) 2024-12-11 13:39:52.179 GMT [5468][client backend] [[unknown]][38/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:52.183 GMT [5468][client backend] [013_partition.pl][38/2:0] LOG: statement: SELECT c, a FROM tab3_1 ORDER BY 1, 2 2024-12-11 13:39:52.194 GMT [5468][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.023 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:55.129 GMT [4336][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:55.132 GMT [4336][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) 2024-12-11 13:39:55.132 GMT [4336][client backend] [[unknown]][39/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:55.137 GMT [4336][client backend] [013_partition.pl][39/2:0] LOG: statement: SELECT a FROM tab2 2024-12-11 13:39:55.140 GMT [4336][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:57.917 GMT [5708][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:57.921 GMT [5708][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) 2024-12-11 13:39:57.921 GMT [5708][client backend] [[unknown]][40/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:57.927 GMT [5708][client backend] [013_partition.pl][40/2:0] LOG: statement: SELECT a FROM tab2 ORDER BY 1 2024-12-11 13:39:57.934 GMT [5708][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.033 user=SYSTEM database=postgres host=[local] 2024-12-11 13:39:59.491 GMT [5708][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:39:59.493 GMT [5708][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) 2024-12-11 13:39:59.493 GMT [5708][client backend] [[unknown]][41/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:39:59.496 GMT [5708][client backend] [013_partition.pl][41/2:0] LOG: statement: SELECT a FROM tab2 2024-12-11 13:39:59.498 GMT [5708][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-12-11 13:40:01.710 GMT [4080][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:40:01.713 GMT [4080][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) 2024-12-11 13:40:01.713 GMT [4080][client backend] [[unknown]][42/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:40:01.723 GMT [4080][client backend] [013_partition.pl][42/2:0] LOG: statement: SELECT c, a, b FROM tab2 ORDER BY 1, 2 2024-12-11 13:40:01.732 GMT [4080][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.030 user=SYSTEM database=postgres host=[local] 2024-12-11 13:40:02.073 GMT [952][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-11 13:40:02.075 GMT [952][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) 2024-12-11 13:40:02.075 GMT [952][client backend] [[unknown]][43/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-12-11 13:40:02.082 GMT [952][client backend] [013_partition.pl][43/2:0] LOG: statement: DELETE FROM tab2 2024-12-11 13:40:02.086 GMT [952][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.020 user=SYSTEM database=postgres host=[local] 2024-12-11 13:40:02.223 GMT [6796][logical replication apply worker] LOG: conflict detected on relation "public.tab2_1": conflict=update_missing 2024-12-11 13:40:02.223 GMT [6796][logical replication apply worker] DETAIL: Could not find the row to be updated. Remote tuple (pub_tab2, quux, 5); replica identity (a)=(5). 2024-12-11 13:40:02.223 GMT [6796][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 809, finished at 0/17F9280 2024-12-11 13:40:02.397 GMT [6796][logical replication apply worker] LOG: conflict detected on relation "public.tab2_1": conflict=delete_missing 2024-12-11 13:40:02.397 GMT [6796][logical replication apply worker] DETAIL: Could not find the row to be deleted. Replica identity (a)=(1). 2024-12-11 13:40:02.397 GMT [6796][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 810, finished at 0/17F92F0 2024-12-11 13:40:03.822 GMT [3772][postmaster] LOG: received fast shutdown request 2024-12-11 13:40:03.826 GMT [3772][postmaster] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2899, PID: 3772 abort() has been called