2026-05-06 15:08:04.336 GMT postmaster[1864] LOG:  starting PostgreSQL 19devel on x86_64-windows, compiled by msvc-19.29.30159, 64-bit
2026-05-06 15:08:04.337 GMT postmaster[1864] LOG:  listening on Unix socket "C:/Windows/TEMP/XaIyDbYwBk/.s.PGSQL.23775"
2026-05-06 15:08:04.387 GMT startup[3392] LOG:  database system was shut down at 2026-05-06 14:52:48 GMT
2026-05-06 15:08:04.449 GMT postmaster[1864] LOG:  database system is ready to accept connections
2026-05-06 15:08:08.572 GMT client backend[6904] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:08:08.574 GMT client backend[6904] [unknown] 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)
2026-05-06 15:08:08.574 GMT client backend[6904] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl
2026-05-06 15:08:08.595 GMT client backend[6904] 013_partition.pl LOG:  connection ready: setup total=61.795 ms, fork=31.343 ms, authentication=1.001 ms
2026-05-06 15:08:08.596 GMT client backend[6904] 013_partition.pl LOG:  statement: CREATE TABLE tab1 (c text, a int PRIMARY KEY, b text) PARTITION BY LIST (a)
2026-05-06 15:08:08.605 GMT client backend[6904] 013_partition.pl LOG:  disconnection: session time: 0:00:00.037 user=SYSTEM database=postgres host=[local]
2026-05-06 15:08:08.721 GMT client backend[8424] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:08:08.723 GMT client backend[8424] [unknown] 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)
2026-05-06 15:08:08.723 GMT client backend[8424] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl
2026-05-06 15:08:08.744 GMT client backend[8424] 013_partition.pl LOG:  connection ready: setup total=53.379 ms, fork=24.802 ms, authentication=0.388 ms
2026-05-06 15:08:08.744 GMT client backend[8424] 013_partition.pl LOG:  statement: CREATE INDEX tab1_c_brin_idx ON tab1 USING brin (c)
2026-05-06 15:08:08.762 GMT client backend[8424] 013_partition.pl LOG:  disconnection: session time: 0:00:00.044 user=SYSTEM database=postgres host=[local]
2026-05-06 15:08:08.928 GMT client backend[8480] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:08:08.930 GMT client backend[8480] [unknown] 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)
2026-05-06 15:08:08.930 GMT client backend[8480] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl
2026-05-06 15:08:08.972 GMT client backend[8480] 013_partition.pl LOG:  connection ready: setup total=107.494 ms, fork=56.893 ms, authentication=0.405 ms
2026-05-06 15:08:08.972 GMT client backend[8480] 013_partition.pl LOG:  statement: CREATE TABLE tab1_1 (b text, c text DEFAULT 'sub1_tab1', a int NOT NULL)
2026-05-06 15:08:09.006 GMT client backend[8480] 013_partition.pl LOG:  disconnection: session time: 0:00:00.081 user=SYSTEM database=postgres host=[local]
2026-05-06 15:08:09.218 GMT client backend[6524] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:08:09.219 GMT client backend[6524] [unknown] 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)
2026-05-06 15:08:09.219 GMT client backend[6524] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl
2026-05-06 15:08:09.223 GMT client backend[6524] 013_partition.pl LOG:  connection ready: setup total=64.746 ms, fork=27.795 ms, authentication=0.316 ms
2026-05-06 15:08:09.223 GMT client backend[6524] 013_partition.pl LOG:  statement: ALTER TABLE tab1 ATTACH PARTITION tab1_1 FOR VALUES IN (1, 2, 3)
2026-05-06 15:08:09.237 GMT client backend[6524] 013_partition.pl LOG:  disconnection: session time: 0:00:00.048 user=SYSTEM database=postgres host=[local]
2026-05-06 15:08:09.384 GMT client backend[9168] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:08:09.385 GMT client backend[9168] [unknown] 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)
2026-05-06 15:08:09.385 GMT client backend[9168] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl
2026-05-06 15:08:09.667 GMT client backend[9168] 013_partition.pl LOG:  connection ready: setup total=304.632 ms, fork=13.797 ms, authentication=0.271 ms
2026-05-06 15:08:09.669 GMT client backend[9168] 013_partition.pl LOG:  statement: CREATE TABLE tab1_2 PARTITION OF tab1 (c DEFAULT 'sub1_tab1') FOR VALUES IN (4, 5, 6) PARTITION BY LIST (a)
2026-05-06 15:08:09.680 GMT client backend[9168] 013_partition.pl LOG:  disconnection: session time: 0:00:00.301 user=SYSTEM database=postgres host=[local]
2026-05-06 15:08:10.123 GMT client backend[6948] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:08:10.124 GMT client backend[6948] [unknown] 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)
2026-05-06 15:08:10.124 GMT client backend[6948] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl
2026-05-06 15:08:10.127 GMT client backend[6948] 013_partition.pl LOG:  connection ready: setup total=46.147 ms, fork=25.517 ms, authentication=0.285 ms
2026-05-06 15:08:10.127 GMT client backend[6948] 013_partition.pl LOG:  statement: CREATE TABLE tab1_2_1 (c text, b text, a int NOT NULL)
2026-05-06 15:08:10.147 GMT client backend[6948] 013_partition.pl LOG:  disconnection: session time: 0:00:00.038 user=SYSTEM database=postgres host=[local]
2026-05-06 15:08:10.324 GMT client backend[1656] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:08:10.335 GMT client backend[1656] [unknown] 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)
2026-05-06 15:08:10.335 GMT client backend[1656] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl
2026-05-06 15:08:10.353 GMT client backend[1656] 013_partition.pl LOG:  connection ready: setup total=73.161 ms, fork=23.763 ms, authentication=0.592 ms
2026-05-06 15:08:10.353 GMT client backend[1656] 013_partition.pl LOG:  statement: ALTER TABLE tab1_2 ATTACH PARTITION tab1_2_1 FOR VALUES IN (5)
2026-05-06 15:08:10.369 GMT client backend[1656] 013_partition.pl LOG:  disconnection: session time: 0:00:00.058 user=SYSTEM database=postgres host=[local]
2026-05-06 15:08:10.525 GMT client backend[4956] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:08:10.526 GMT client backend[4956] [unknown] 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)
2026-05-06 15:08:10.527 GMT client backend[4956] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl
2026-05-06 15:08:10.529 GMT client backend[4956] 013_partition.pl LOG:  connection ready: setup total=43.776 ms, fork=32.303 ms, authentication=0.280 ms
2026-05-06 15:08:10.530 GMT client backend[4956] 013_partition.pl LOG:  statement: CREATE TABLE tab1_2_2 PARTITION OF tab1_2 FOR VALUES IN (4, 6)
2026-05-06 15:08:10.549 GMT client backend[4956] 013_partition.pl LOG:  disconnection: session time: 0:00:00.028 user=SYSTEM database=postgres host=[local]
2026-05-06 15:08:10.685 GMT client backend[7136] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:08:10.687 GMT client backend[7136] [unknown] 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)
2026-05-06 15:08:10.687 GMT client backend[7136] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl
2026-05-06 15:08:10.691 GMT client backend[7136] 013_partition.pl LOG:  connection ready: setup total=58.491 ms, fork=29.615 ms, authentication=0.406 ms
2026-05-06 15:08:10.692 GMT client backend[7136] 013_partition.pl LOG:  statement: CREATE TABLE tab1_def PARTITION OF tab1 (c DEFAULT 'sub1_tab1') DEFAULT
2026-05-06 15:08:10.708 GMT client backend[7136] 013_partition.pl LOG:  disconnection: session time: 0:00:00.038 user=SYSTEM database=postgres host=[local]
2026-05-06 15:08:10.786 GMT client backend[6432] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:08:10.788 GMT client backend[6432] [unknown] 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)
2026-05-06 15:08:10.788 GMT client backend[6432] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl
2026-05-06 15:08:10.814 GMT client backend[6432] 013_partition.pl LOG:  connection ready: setup total=49.714 ms, fork=16.108 ms, authentication=0.263 ms
2026-05-06 15:08:10.814 GMT client backend[6432] 013_partition.pl LOG:  statement: CREATE SUBSCRIPTION sub1 CONNECTION 'port=23774 host=C:/Windows/TEMP/XaIyDbYwBk dbname=postgres' PUBLICATION pub1
2026-05-06 15:08:10.899 GMT client backend[6432] 013_partition.pl LOG:  disconnection: session time: 0:00:00.116 user=SYSTEM database=postgres host=[local]
2026-05-06 15:08:10.949 GMT logical replication apply worker[6180] LOG:  logical replication apply worker for subscription "sub1" has started
2026-05-06 15:08:11.044 GMT logical replication tablesync worker[8480] LOG:  logical replication table synchronization worker for subscription "sub1", table "tab1_2" has started
2026-05-06 15:08:11.091 GMT client backend[7708] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:08:11.092 GMT client backend[7708] [unknown] 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)
2026-05-06 15:08:11.092 GMT client backend[7708] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl
2026-05-06 15:08:11.095 GMT client backend[7708] 013_partition.pl LOG:  connection ready: setup total=44.277 ms, fork=34.893 ms, authentication=0.223 ms
2026-05-06 15:08:11.095 GMT client backend[7708] 013_partition.pl LOG:  statement: CREATE TABLE sub1_trigger_activity (tgtab text, tgop text,
	  tgwhen text, tglevel text, olda int, newa int);
2026-05-06 15:08:11.103 GMT logical replication tablesync worker[7592] LOG:  logical replication table synchronization worker for subscription "sub1", table "tab1_1" has started
2026-05-06 15:08:11.116 GMT client backend[7708] 013_partition.pl 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;
2026-05-06 15:08:11.119 GMT client backend[7708] 013_partition.pl LOG:  statement: CREATE TRIGGER sub1_tab1_log_op_trigger
	  AFTER INSERT OR UPDATE ON tab1
	  FOR EACH ROW EXECUTE PROCEDURE sub1_trigger_activity_func();
2026-05-06 15:08:11.150 GMT logical replication tablesync worker[8480] LOG:  logical replication table synchronization worker for subscription "sub1", table "tab1_2" has finished
2026-05-06 15:08:11.153 GMT client backend[7708] 013_partition.pl LOG:  statement: ALTER TABLE ONLY tab1 ENABLE REPLICA TRIGGER sub1_tab1_log_op_trigger;
2026-05-06 15:08:11.154 GMT client backend[7708] 013_partition.pl 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();
2026-05-06 15:08:11.155 GMT client backend[7708] 013_partition.pl LOG:  statement: ALTER TABLE ONLY tab1_2 ENABLE REPLICA TRIGGER sub1_tab1_2_log_op_trigger;
2026-05-06 15:08:11.156 GMT client backend[7708] 013_partition.pl 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();
2026-05-06 15:08:11.156 GMT client backend[7708] 013_partition.pl LOG:  statement: ALTER TABLE ONLY tab1_2_2 ENABLE REPLICA TRIGGER sub1_tab1_2_2_log_op_trigger;
2026-05-06 15:08:11.157 GMT client backend[7708] 013_partition.pl LOG:  disconnection: session time: 0:00:00.069 user=SYSTEM database=postgres host=[local]
2026-05-06 15:08:11.205 GMT logical replication tablesync worker[7592] LOG:  logical replication table synchronization worker for subscription "sub1", table "tab1_1" has finished
2026-05-06 15:08:11.209 GMT logical replication tablesync worker[6116] LOG:  logical replication table synchronization worker for subscription "sub1", table "tab1_def" has started
2026-05-06 15:08:11.274 GMT logical replication tablesync worker[6116] LOG:  logical replication table synchronization worker for subscription "sub1", table "tab1_def" has finished
2026-05-06 15:08:12.556 GMT client backend[5764] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:08:12.557 GMT client backend[5764] [unknown] 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)
2026-05-06 15:08:12.557 GMT client backend[5764] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl
2026-05-06 15:08:12.561 GMT client backend[5764] 013_partition.pl LOG:  connection ready: setup total=33.530 ms, fork=21.836 ms, authentication=0.279 ms
2026-05-06 15:08:12.562 GMT client backend[5764] 013_partition.pl LOG:  statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's');
2026-05-06 15:08:12.567 GMT client backend[5764] 013_partition.pl LOG:  disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local]
2026-05-06 15:08:14.813 GMT client backend[8124] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:08:14.815 GMT client backend[8124] [unknown] 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)
2026-05-06 15:08:14.815 GMT client backend[8124] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl
2026-05-06 15:08:14.818 GMT client backend[8124] 013_partition.pl LOG:  connection ready: setup total=44.493 ms, fork=34.020 ms, authentication=0.248 ms
2026-05-06 15:08:14.818 GMT client backend[8124] 013_partition.pl LOG:  statement: SELECT c, a FROM tab1 ORDER BY 1, 2
2026-05-06 15:08:14.826 GMT client backend[8124] 013_partition.pl LOG:  disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local]
2026-05-06 15:08:14.990 GMT client backend[4876] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:08:14.992 GMT client backend[4876] [unknown] 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)
2026-05-06 15:08:14.992 GMT client backend[4876] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl
2026-05-06 15:08:14.995 GMT client backend[4876] 013_partition.pl LOG:  connection ready: setup total=44.900 ms, fork=34.003 ms, authentication=0.277 ms
2026-05-06 15:08:14.995 GMT client backend[4876] 013_partition.pl LOG:  statement: SELECT a FROM tab1_2_1 ORDER BY 1
2026-05-06 15:08:15.001 GMT client backend[4876] 013_partition.pl LOG:  disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local]
2026-05-06 15:08:15.099 GMT client backend[7776] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:08:15.101 GMT client backend[7776] [unknown] 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)
2026-05-06 15:08:15.101 GMT client backend[7776] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl
2026-05-06 15:08:15.103 GMT client backend[7776] 013_partition.pl LOG:  connection ready: setup total=27.451 ms, fork=17.056 ms, authentication=0.238 ms
2026-05-06 15:08:15.104 GMT client backend[7776] 013_partition.pl LOG:  statement: SELECT a FROM tab1_2_2 ORDER BY 1
2026-05-06 15:08:15.107 GMT client backend[7776] 013_partition.pl LOG:  disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local]
2026-05-06 15:08:16.250 GMT logical replication apply worker[6180] WARNING:  resource was not closed: relation "tab1_2_2"
2026-05-06 15:08:16.250 GMT logical replication apply worker[6180] CONTEXT:  processing remote data for replication origin "pg_16438" during message type "COMMIT" in transaction 706, finished at 0/017E8200
2026-05-06 15:08:16.459 GMT logical replication apply worker[6180] WARNING:  resource was not closed: relation "tab1_2_2"
2026-05-06 15:08:16.459 GMT logical replication apply worker[6180] CONTEXT:  processing remote data for replication origin "pg_16438" during message type "COMMIT" in transaction 707, finished at 0/017E82C0
2026-05-06 15:08:16.636 GMT logical replication apply worker[6180] WARNING:  resource was not closed: relation "tab1_2_2"
2026-05-06 15:08:16.636 GMT logical replication apply worker[6180] CONTEXT:  processing remote data for replication origin "pg_16438" during message type "COMMIT" in transaction 708, finished at 0/017E8380
2026-05-06 15:08:17.652 GMT client backend[7740] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:08:17.654 GMT client backend[7740] [unknown] 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)
2026-05-06 15:08:17.654 GMT client backend[7740] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl
2026-05-06 15:08:17.656 GMT client backend[7740] 013_partition.pl LOG:  connection ready: setup total=31.763 ms, fork=22.071 ms, authentication=0.222 ms
2026-05-06 15:08:17.656 GMT client backend[7740] 013_partition.pl LOG:  statement: SELECT c, a FROM tab1 ORDER BY 1, 2
2026-05-06 15:08:17.664 GMT client backend[7740] 013_partition.pl LOG:  disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local]
2026-05-06 15:08:17.776 GMT client backend[7916] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:08:17.778 GMT client backend[7916] [unknown] 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)
2026-05-06 15:08:17.778 GMT client backend[7916] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl
2026-05-06 15:08:17.781 GMT client backend[7916] 013_partition.pl LOG:  connection ready: setup total=36.901 ms, fork=24.750 ms, authentication=0.264 ms
2026-05-06 15:08:17.781 GMT client backend[7916] 013_partition.pl LOG:  statement: SELECT a FROM tab1_2_1 ORDER BY 1
2026-05-06 15:08:17.783 GMT client backend[7916] 013_partition.pl LOG:  disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local]
2026-05-06 15:08:17.897 GMT client backend[5264] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:08:17.899 GMT client backend[5264] [unknown] 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)
2026-05-06 15:08:17.899 GMT client backend[5264] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl
2026-05-06 15:08:17.902 GMT client backend[5264] 013_partition.pl LOG:  connection ready: setup total=25.327 ms, fork=14.166 ms, authentication=0.284 ms
2026-05-06 15:08:17.902 GMT client backend[5264] 013_partition.pl LOG:  statement: SELECT a FROM tab1_2_2 ORDER BY 1
2026-05-06 15:08:17.906 GMT client backend[5264] 013_partition.pl LOG:  disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local]
2026-05-06 15:08:18.018 GMT client backend[4124] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:08:18.020 GMT client backend[4124] [unknown] 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)
2026-05-06 15:08:18.020 GMT client backend[4124] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl
2026-05-06 15:08:18.023 GMT client backend[4124] 013_partition.pl LOG:  connection ready: setup total=37.885 ms, fork=26.468 ms, authentication=0.291 ms
2026-05-06 15:08:18.023 GMT client backend[4124] 013_partition.pl LOG:  statement: SELECT * FROM sub1_trigger_activity ORDER BY tgtab, tgop, tgwhen, olda, newa;
2026-05-06 15:08:18.028 GMT client backend[4124] 013_partition.pl LOG:  disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local]
2026-05-06 15:08:19.591 GMT logical replication apply worker[6180] WARNING:  resource was not closed: relation "tab1_2_2"
2026-05-06 15:08:19.591 GMT logical replication apply worker[6180] CONTEXT:  processing remote data for replication origin "pg_16438" during message type "COMMIT" in transaction 710, finished at 0/017E8598
2026-05-06 15:08:21.271 GMT client backend[4200] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:08:21.272 GMT client backend[4200] [unknown] 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)
2026-05-06 15:08:21.272 GMT client backend[4200] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl
2026-05-06 15:08:21.282 GMT client backend[4200] 013_partition.pl LOG:  connection ready: setup total=32.335 ms, fork=15.050 ms, authentication=0.220 ms
2026-05-06 15:08:21.283 GMT client backend[4200] 013_partition.pl LOG:  statement: SELECT c, a FROM tab1 ORDER BY 1, 2
2026-05-06 15:08:21.295 GMT client backend[4200] 013_partition.pl LOG:  disconnection: session time: 0:00:00.028 user=SYSTEM database=postgres host=[local]
2026-05-06 15:08:21.414 GMT client backend[2628] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:08:21.415 GMT client backend[2628] [unknown] 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)
2026-05-06 15:08:21.415 GMT client backend[2628] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl
2026-05-06 15:08:21.418 GMT client backend[2628] 013_partition.pl LOG:  connection ready: setup total=26.639 ms, fork=16.472 ms, authentication=0.264 ms
2026-05-06 15:08:21.419 GMT client backend[2628] 013_partition.pl LOG:  statement: SELECT a FROM tab1_2_2 ORDER BY 1
2026-05-06 15:08:21.424 GMT client backend[2628] 013_partition.pl LOG:  disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local]
2026-05-06 15:08:24.167 GMT client backend[9204] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:08:24.168 GMT client backend[9204] [unknown] 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)
2026-05-06 15:08:24.168 GMT client backend[9204] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl
2026-05-06 15:08:24.171 GMT client backend[9204] 013_partition.pl LOG:  connection ready: setup total=118.281 ms, fork=108.116 ms, authentication=0.245 ms
2026-05-06 15:08:24.171 GMT client backend[9204] 013_partition.pl LOG:  statement: SELECT a FROM tab1
2026-05-06 15:08:24.176 GMT client backend[9204] 013_partition.pl LOG:  disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local]
2026-05-06 15:08:24.667 GMT client backend[7136] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:08:24.668 GMT client backend[7136] [unknown] 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)
2026-05-06 15:08:24.668 GMT client backend[7136] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl
2026-05-06 15:08:24.692 GMT client backend[7136] 013_partition.pl LOG:  connection ready: setup total=45.449 ms, fork=10.849 ms, authentication=0.296 ms
2026-05-06 15:08:24.693 GMT client backend[7136] 013_partition.pl LOG:  statement: INSERT INTO tab1 (a) VALUES (1), (2), (5)
2026-05-06 15:08:24.699 GMT client backend[7136] 013_partition.pl LOG:  disconnection: session time: 0:00:00.038 user=SYSTEM database=postgres host=[local]
2026-05-06 15:08:26.520 GMT client backend[5736] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:08:26.521 GMT client backend[5736] [unknown] 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)
2026-05-06 15:08:26.521 GMT client backend[5736] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl
2026-05-06 15:08:26.525 GMT client backend[5736] 013_partition.pl LOG:  connection ready: setup total=82.312 ms, fork=71.283 ms, authentication=0.283 ms
2026-05-06 15:08:26.525 GMT client backend[5736] 013_partition.pl LOG:  statement: SELECT a FROM tab1 ORDER BY 1
2026-05-06 15:08:26.535 GMT client backend[5736] 013_partition.pl LOG:  disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local]
2026-05-06 15:08:28.336 GMT client backend[7364] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:08:28.338 GMT client backend[7364] [unknown] 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)
2026-05-06 15:08:28.338 GMT client backend[7364] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl
2026-05-06 15:08:28.342 GMT client backend[7364] 013_partition.pl LOG:  connection ready: setup total=31.807 ms, fork=15.641 ms, authentication=0.330 ms
2026-05-06 15:08:28.342 GMT client backend[7364] 013_partition.pl LOG:  statement: SELECT a FROM tab1 ORDER BY 1
2026-05-06 15:08:28.348 GMT client backend[7364] 013_partition.pl LOG:  disconnection: session time: 0:00:00.020 user=SYSTEM database=postgres host=[local]
2026-05-06 15:08:28.615 GMT logical replication apply worker[6180] WARNING:  resource was not closed: relation "tab1_2_2"
2026-05-06 15:08:28.615 GMT logical replication apply worker[6180] CONTEXT:  processing remote data for replication origin "pg_16438" during message type "COMMIT" in transaction 715, finished at 0/017EF218
2026-05-06 15:08:30.142 GMT client backend[8652] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:08:30.146 GMT client backend[8652] [unknown] 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)
2026-05-06 15:08:30.146 GMT client backend[8652] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl
2026-05-06 15:08:30.155 GMT client backend[8652] 013_partition.pl LOG:  connection ready: setup total=70.108 ms, fork=20.891 ms, authentication=2.422 ms
2026-05-06 15:08:30.156 GMT client backend[8652] 013_partition.pl LOG:  statement: DELETE FROM tab1
2026-05-06 15:08:30.162 GMT client backend[8652] 013_partition.pl LOG:  disconnection: session time: 0:00:00.039 user=SYSTEM database=postgres host=[local]
2026-05-06 15:08:30.481 GMT logical replication apply worker[6180] LOG:  conflict detected on relation "public.tab1_2_2": conflict=update_missing
2026-05-06 15:08:30.481 GMT logical replication apply worker[6180] DETAIL:  Could not find the row to be updated: remote row (null, 4, quux), replica identity (a)=(4).
2026-05-06 15:08:30.481 GMT logical replication apply worker[6180] CONTEXT:  processing remote data for replication origin "pg_16438" during message type "UPDATE" for replication target relation "public.tab1_2" in transaction 716, finished at 0/017EF298
TRAP: failed Assert("conflictlogrel != NULL"), File: "../src/backend/replication/logical/conflict.c", Line: 195, PID: 6180
abort() has been called2026-05-06 15:08:32.531 GMT postmaster[1864] LOG:  background worker "logical replication apply worker" (PID 6180) was terminated by exception 0xC0000354
2026-05-06 15:08:32.531 GMT postmaster[1864] HINT:  See C include file "ntstatus.h" for a description of the hexadecimal value.
2026-05-06 15:08:32.531 GMT postmaster[1864] LOG:  terminating any other active server processes
2026-05-06 15:08:32.587 GMT postmaster[1864] LOG:  shutting down because "restart_after_crash" is off
2026-05-06 15:08:32.589 GMT postmaster[1864] LOG:  database system is shut down