2025-01-30 12:30:53.916 GMT [5788][postmaster] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30158, 64-bit 2025-01-30 12:30:53.924 GMT [5788][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/qxrD6k6G7k/.s.PGSQL.29463" 2025-01-30 12:30:53.972 GMT [4568][startup] LOG: database system was shut down at 2025-01-30 12:23:06 GMT 2025-01-30 12:30:53.978 GMT [5788][postmaster] LOG: database system is ready to accept connections 2025-01-30 12:30:56.995 GMT [5756][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-30 12:30:56.997 GMT [5756][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-30 12:30:56.997 GMT [5756][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-30 12:30:57.020 GMT [5756][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-30 12:30:57.037 GMT [5756][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.045 user=SYSTEM database=postgres host=[local] 2025-01-30 12:30:57.132 GMT [5204][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-30 12:30:57.133 GMT [5204][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-30 12:30:57.133 GMT [5204][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-30 12:30:57.137 GMT [5204][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-30 12:30:57.148 GMT [5204][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.020 user=SYSTEM database=postgres host=[local] 2025-01-30 12:30:57.208 GMT [1208][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-30 12:30:57.210 GMT [1208][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-30 12:30:57.210 GMT [1208][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-30 12:30:57.214 GMT [1208][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-30 12:30:57.224 GMT [1208][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.021 user=SYSTEM database=postgres host=[local] 2025-01-30 12:30:57.291 GMT [2720][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-30 12:30:57.292 GMT [2720][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-30 12:30:57.292 GMT [2720][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-30 12:30:57.295 GMT [2720][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-30 12:30:57.301 GMT [2720][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2025-01-30 12:30:57.369 GMT [3908][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-30 12:30:57.373 GMT [3908][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-30 12:30:57.373 GMT [3908][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-30 12:30:57.376 GMT [3908][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-30 12:30:57.384 GMT [3908][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2025-01-30 12:30:57.447 GMT [5024][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-30 12:30:57.449 GMT [5024][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-30 12:30:57.449 GMT [5024][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-30 12:30:57.452 GMT [5024][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-30 12:30:57.462 GMT [5024][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2025-01-30 12:30:57.517 GMT [2044][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-30 12:30:57.518 GMT [2044][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-30 12:30:57.518 GMT [2044][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-30 12:30:57.521 GMT [2044][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-30 12:30:57.539 GMT [2044][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.025 user=SYSTEM database=postgres host=[local] 2025-01-30 12:30:57.593 GMT [4868][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-30 12:30:57.594 GMT [4868][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-30 12:30:57.594 GMT [4868][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-30 12:30:57.597 GMT [4868][client backend] [013_partition.pl][7/2:0] LOG: statement: CREATE TABLE tab1_def PARTITION OF tab1 (c DEFAULT 'sub1_tab1') DEFAULT 2025-01-30 12:30:57.608 GMT [4868][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2025-01-30 12:30:57.795 GMT [5624][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-30 12:30:57.796 GMT [5624][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-30 12:30:57.796 GMT [5624][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-30 12:30:57.812 GMT [5624][client backend] [013_partition.pl][8/2:0] LOG: statement: CREATE SUBSCRIPTION sub1 CONNECTION 'port=29462 host=C:/Windows/TEMP/qxrD6k6G7k dbname=postgres' PUBLICATION pub1 2025-01-30 12:30:57.875 GMT [5624][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.084 user=SYSTEM database=postgres host=[local] 2025-01-30 12:30:57.895 GMT [1208][logical replication apply worker] LOG: logical replication apply worker for subscription "sub1" has started 2025-01-30 12:30:58.059 GMT [3892][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "sub1", table "tab1_def" has started 2025-01-30 12:30:58.084 GMT [5216][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-30 12:30:58.086 GMT [5216][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-30 12:30:58.086 GMT [5216][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-30 12:30:58.089 GMT [5216][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-30 12:30:58.095 GMT [5216][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-30 12:30:58.105 GMT [4644][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "sub1", table "tab1_2" has started 2025-01-30 12:30:58.110 GMT [5216][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-30 12:30:58.115 GMT [3892][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "sub1", table "tab1_def" has finished 2025-01-30 12:30:58.116 GMT [5216][client backend] [013_partition.pl][9/5:0] LOG: statement: ALTER TABLE ONLY tab1 ENABLE REPLICA TRIGGER sub1_tab1_log_op_trigger; 2025-01-30 12:30:58.117 GMT [5216][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-30 12:30:58.118 GMT [5216][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-30 12:30:58.118 GMT [5216][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-30 12:30:58.119 GMT [5216][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-30 12:30:58.119 GMT [5216][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.039 user=SYSTEM database=postgres host=[local] 2025-01-30 12:30:58.169 GMT [4644][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "sub1", table "tab1_2" has finished 2025-01-30 12:30:58.191 GMT [4132][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "sub1", table "tab1_1" has started 2025-01-30 12:30:58.254 GMT [4132][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "sub1", table "tab1_1" has finished 2025-01-30 12:30:59.011 GMT [4696][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-30 12:30:59.012 GMT [4696][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-30 12:30:59.012 GMT [4696][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-30 12:30:59.015 GMT [4696][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-30 12:30:59.020 GMT [4696][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2025-01-30 12:31:00.319 GMT [6424][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-30 12:31:00.320 GMT [6424][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-30 12:31:00.320 GMT [6424][client backend] [[unknown]][11/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-30 12:31:00.324 GMT [6424][client backend] [013_partition.pl][11/2:0] LOG: statement: SELECT c, a FROM tab1 ORDER BY 1, 2 2025-01-30 12:31:00.331 GMT [6424][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2025-01-30 12:31:00.445 GMT [5756][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-30 12:31:00.447 GMT [5756][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-30 12:31:00.447 GMT [5756][client backend] [[unknown]][12/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-30 12:31:00.451 GMT [5756][client backend] [013_partition.pl][12/2:0] LOG: statement: SELECT a FROM tab1_2_1 ORDER BY 1 2025-01-30 12:31:00.455 GMT [5756][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2025-01-30 12:31:00.512 GMT [1640][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-30 12:31:00.513 GMT [1640][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-30 12:31:00.513 GMT [1640][client backend] [[unknown]][13/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-30 12:31:00.516 GMT [1640][client backend] [013_partition.pl][13/2:0] LOG: statement: SELECT a FROM tab1_2_2 ORDER BY 1 2025-01-30 12:31:00.518 GMT [1640][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2025-01-30 12:31:01.875 GMT [3812][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-30 12:31:01.876 GMT [3812][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-30 12:31:01.876 GMT [3812][client backend] [[unknown]][14/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-30 12:31:01.880 GMT [3812][client backend] [013_partition.pl][14/2:0] LOG: statement: SELECT c, a FROM tab1 ORDER BY 1, 2 2025-01-30 12:31:01.886 GMT [3812][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2025-01-30 12:31:01.988 GMT [4148][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-30 12:31:01.989 GMT [4148][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-30 12:31:01.989 GMT [4148][client backend] [[unknown]][15/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-30 12:31:01.992 GMT [4148][client backend] [013_partition.pl][15/2:0] LOG: statement: SELECT a FROM tab1_2_1 ORDER BY 1 2025-01-30 12:31:01.994 GMT [4148][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2025-01-30 12:31:02.070 GMT [6736][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-30 12:31:02.072 GMT [6736][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-30 12:31:02.072 GMT [6736][client backend] [[unknown]][16/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-30 12:31:02.076 GMT [6736][client backend] [013_partition.pl][16/2:0] LOG: statement: SELECT a FROM tab1_2_2 ORDER BY 1 2025-01-30 12:31:02.083 GMT [6736][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2025-01-30 12:31:02.179 GMT [2180][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-30 12:31:02.180 GMT [2180][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-30 12:31:02.180 GMT [2180][client backend] [[unknown]][17/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-30 12:31:02.183 GMT [2180][client backend] [013_partition.pl][17/2:0] LOG: statement: SELECT * FROM sub1_trigger_activity ORDER BY tgtab, tgop, tgwhen, olda, newa; 2025-01-30 12:31:02.186 GMT [2180][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-30 12:31:03.894 GMT [6284][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-30 12:31:03.895 GMT [6284][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-30 12:31:03.895 GMT [6284][client backend] [[unknown]][18/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-30 12:31:03.904 GMT [6284][client backend] [013_partition.pl][18/2:0] LOG: statement: SELECT c, a FROM tab1 ORDER BY 1, 2 2025-01-30 12:31:03.910 GMT [6284][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.020 user=SYSTEM database=postgres host=[local] 2025-01-30 12:31:03.982 GMT [5268][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-30 12:31:03.983 GMT [5268][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-30 12:31:03.984 GMT [5268][client backend] [[unknown]][19/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-30 12:31:03.986 GMT [5268][client backend] [013_partition.pl][19/2:0] LOG: statement: SELECT a FROM tab1_2_2 ORDER BY 1 2025-01-30 12:31:03.991 GMT [5268][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-30 12:31:05.357 GMT [3860][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-30 12:31:05.359 GMT [3860][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-30 12:31:05.359 GMT [3860][client backend] [[unknown]][20/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-30 12:31:05.366 GMT [3860][client backend] [013_partition.pl][20/2:0] LOG: statement: SELECT a FROM tab1 2025-01-30 12:31:05.380 GMT [3860][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.025 user=SYSTEM database=postgres host=[local] 2025-01-30 12:31:05.779 GMT [6748][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-30 12:31:05.781 GMT [6748][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-30 12:31:05.781 GMT [6748][client backend] [[unknown]][21/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-30 12:31:05.783 GMT [6748][client backend] [013_partition.pl][21/2:0] LOG: statement: INSERT INTO tab1 (a) VALUES (1), (2), (5) 2025-01-30 12:31:05.788 GMT [6748][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-30 12:31:06.693 GMT [1908][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-30 12:31:06.695 GMT [1908][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-30 12:31:06.695 GMT [1908][client backend] [[unknown]][22/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-30 12:31:06.698 GMT [1908][client backend] [013_partition.pl][22/2:0] LOG: statement: SELECT a FROM tab1 ORDER BY 1 2025-01-30 12:31:06.704 GMT [1908][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2025-01-30 12:31:07.747 GMT [4048][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-30 12:31:07.748 GMT [4048][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-30 12:31:07.748 GMT [4048][client backend] [[unknown]][23/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-30 12:31:07.759 GMT [4048][client backend] [013_partition.pl][23/2:0] LOG: statement: SELECT a FROM tab1 ORDER BY 1 2025-01-30 12:31:07.763 GMT [4048][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2025-01-30 12:31:08.758 GMT [3752][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-30 12:31:08.760 GMT [3752][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-30 12:31:08.760 GMT [3752][client backend] [[unknown]][24/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2025-01-30 12:31:08.762 GMT [3752][client backend] [013_partition.pl][24/2:0] LOG: statement: DELETE FROM tab1 2025-01-30 12:31:08.766 GMT [3752][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2025-01-30 12:31:08.855 GMT [1208][logical replication apply worker] LOG: conflict detected on relation "public.tab1_2_2": conflict=update_missing 2025-01-30 12:31:08.855 GMT [1208][logical replication apply worker] DETAIL: Could not find the row to be updated. Remote tuple (null, 4, quux); replica identity (a)=(4). 2025-01-30 12:31:08.855 GMT [1208][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/17B7E08 2025-01-30 12:31:08.934 GMT [1208][logical replication apply worker] LOG: conflict detected on relation "public.tab1_1": conflict=delete_missing 2025-01-30 12:31:08.934 GMT [1208][logical replication apply worker] DETAIL: Could not find the row to be deleted. Replica identity (a)=(1). 2025-01-30 12:31:08.934 GMT [1208][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/17B7EF8 2025-01-30 12:31:08.935 GMT [1208][logical replication apply worker] LOG: conflict detected on relation "public.tab1_2_2": conflict=delete_missing 2025-01-30 12:31:08.935 GMT [1208][logical replication apply worker] DETAIL: Could not find the row to be deleted. Replica identity (a)=(4). 2025-01-30 12:31:08.935 GMT [1208][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/17B7EF8 2025-01-30 12:31:08.935 GMT [1208][logical replication apply worker] LOG: conflict detected on relation "public.tab1_def": conflict=delete_missing 2025-01-30 12:31:08.935 GMT [1208][logical replication apply worker] DETAIL: Could not find the row to be deleted. Replica identity (a)=(10). 2025-01-30 12:31:08.935 GMT [1208][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/17B7EF8 2025-01-30 12:31:09.453 GMT [5788][postmaster] LOG: WAL writer process (PID 5496) exited with exit code 2 2025-01-30 12:31:09.453 GMT [5788][postmaster] LOG: terminating any other active server processes TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2951, PID: 5788 abort() has been called