2026-05-06 15:09:39.373 GMT postmaster[8408] LOG:  starting PostgreSQL 19devel on x86_64-windows, compiled by msvc-19.29.30159, 64-bit
2026-05-06 15:09:39.376 GMT postmaster[8408] LOG:  listening on Unix socket "C:/Windows/TEMP/hTFoG2pePt/.s.PGSQL.23305"
2026-05-06 15:09:39.435 GMT startup[8280] LOG:  database system was shut down at 2026-05-06 14:52:48 GMT
2026-05-06 15:09:39.451 GMT postmaster[8408] LOG:  database system is ready to accept connections
2026-05-06 15:09:39.828 GMT client backend[3824] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:39.829 GMT client backend[3824] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:39.830 GMT client backend[3824] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:39.855 GMT client backend[3824] 035_conflicts.pl LOG:  connection ready: setup total=56.746 ms, fork=21.294 ms, authentication=1.503 ms
2026-05-06 15:09:39.856 GMT client backend[3824] 035_conflicts.pl LOG:  statement: CREATE TABLE conf_tab (a int PRIMARY key, b int UNIQUE, c int UNIQUE);
2026-05-06 15:09:39.875 GMT client backend[3824] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.051 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:39.985 GMT client backend[4092] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:39.987 GMT client backend[4092] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:39.987 GMT client backend[4092] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:39.992 GMT client backend[4092] 035_conflicts.pl LOG:  connection ready: setup total=37.678 ms, fork=22.305 ms, authentication=0.543 ms
2026-05-06 15:09:39.993 GMT client backend[4092] 035_conflicts.pl LOG:  statement: CREATE TABLE conf_tab_2 (a int PRIMARY KEY, b int, c int, unique(a,b)) PARTITION BY RANGE (a);
2026-05-06 15:09:40.004 GMT client backend[4092] 035_conflicts.pl LOG:  statement: CREATE TABLE conf_tab_2_p1 PARTITION OF conf_tab_2 FOR VALUES FROM (MINVALUE) TO (100);
2026-05-06 15:09:40.016 GMT client backend[4092] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.036 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:40.203 GMT client backend[4052] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:40.204 GMT client backend[4052] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:40.204 GMT client backend[4052] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:40.209 GMT client backend[4052] 035_conflicts.pl LOG:  connection ready: setup total=31.426 ms, fork=17.140 ms, authentication=0.390 ms
2026-05-06 15:09:40.210 GMT client backend[4052] 035_conflicts.pl LOG:  statement: CREATE SUBSCRIPTION sub_tab
		 CONNECTION 'port=23304 host=C:/Windows/TEMP/hTFoG2pePt dbname=postgres application_name=sub_tab'
		 PUBLICATION pub_tab WITH (conflict_log_destination=all)
2026-05-06 15:09:40.287 GMT client backend[4052] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.089 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:40.304 GMT logical replication apply worker[7628] LOG:  logical replication apply worker for subscription "sub_tab" has started
2026-05-06 15:09:40.370 GMT client backend[6624] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:40.392 GMT client backend[6624] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:40.392 GMT client backend[6624] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:40.392 GMT logical replication tablesync worker[1304] LOG:  logical replication table synchronization worker for subscription "sub_tab", table "conf_tab" has started
2026-05-06 15:09:40.396 GMT client backend[6624] 035_conflicts.pl LOG:  connection ready: setup total=49.227 ms, fork=17.089 ms, authentication=0.291 ms
2026-05-06 15:09:40.396 GMT client backend[6624] 035_conflicts.pl LOG:  statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's');
2026-05-06 15:09:40.407 GMT client backend[6624] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.040 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:40.424 GMT logical replication tablesync worker[1900] LOG:  logical replication table synchronization worker for subscription "sub_tab", table "conf_tab_2" has started
2026-05-06 15:09:40.462 GMT logical replication tablesync worker[1304] LOG:  logical replication table synchronization worker for subscription "sub_tab", table "conf_tab" has finished
2026-05-06 15:09:40.500 GMT logical replication tablesync worker[1900] LOG:  logical replication table synchronization worker for subscription "sub_tab", table "conf_tab_2" has finished
2026-05-06 15:09:40.649 GMT client backend[2420] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:40.652 GMT client backend[2420] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:40.652 GMT client backend[2420] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:40.657 GMT client backend[2420] 035_conflicts.pl LOG:  connection ready: setup total=34.497 ms, fork=18.389 ms, authentication=0.501 ms
2026-05-06 15:09:40.658 GMT client backend[2420] 035_conflicts.pl LOG:  statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's');
2026-05-06 15:09:40.669 GMT client backend[2420] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.025 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:41.342 GMT client backend[2300] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:41.344 GMT client backend[2300] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:41.344 GMT client backend[2300] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:41.347 GMT client backend[2300] 035_conflicts.pl LOG:  connection ready: setup total=24.190 ms, fork=12.218 ms, authentication=0.215 ms
2026-05-06 15:09:41.348 GMT client backend[2300] 035_conflicts.pl LOG:  statement: INSERT INTO conf_tab VALUES (2,2,2), (3,3,3), (4,4,4);
2026-05-06 15:09:41.349 GMT client backend[2300] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:41.432 GMT logical replication apply worker[7628] ERROR:  conflict detected on relation "public.conf_tab": conflict=multiple_unique_conflicts
2026-05-06 15:09:41.432 GMT logical replication apply worker[7628] DETAIL:  Could not apply remote change: remote row (2, 3, 4).
	Key already exists in unique index "conf_tab_pkey", modified in transaction 708: key (a)=(2), local row (2, 2, 2).
	Key already exists in unique index "conf_tab_b_key", modified in transaction 708: key (b)=(3), local row (3, 3, 3).
	Key already exists in unique index "conf_tab_c_key", modified in transaction 708: key (c)=(4), local row (4, 4, 4).
2026-05-06 15:09:41.432 GMT logical replication apply worker[7628] CONTEXT:  processing remote data for replication origin "pg_16410" during message type "INSERT" for replication target relation "public.conf_tab" in transaction 697, finished at 0/017D8BC0
2026-05-06 15:09:41.465 GMT postmaster[8408] LOG:  background worker "logical replication apply worker" (PID 7628) exited with exit code 1
2026-05-06 15:09:41.479 GMT logical replication apply worker[8980] LOG:  logical replication apply worker for subscription "sub_tab" has started
2026-05-06 15:09:41.528 GMT logical replication apply worker[8980] ERROR:  conflict detected on relation "public.conf_tab": conflict=multiple_unique_conflicts
2026-05-06 15:09:41.528 GMT logical replication apply worker[8980] DETAIL:  Could not apply remote change: remote row (2, 3, 4).
	Key already exists in unique index "conf_tab_pkey", modified in transaction 708: key (a)=(2), local row (2, 2, 2).
	Key already exists in unique index "conf_tab_b_key", modified in transaction 708: key (b)=(3), local row (3, 3, 3).
	Key already exists in unique index "conf_tab_c_key", modified in transaction 708: key (c)=(4), local row (4, 4, 4).
2026-05-06 15:09:41.528 GMT logical replication apply worker[8980] CONTEXT:  processing remote data for replication origin "pg_16410" during message type "INSERT" for replication target relation "public.conf_tab" in transaction 697, finished at 0/017D8BC0
2026-05-06 15:09:41.542 GMT postmaster[8408] LOG:  background worker "logical replication apply worker" (PID 8980) exited with exit code 1
2026-05-06 15:09:41.561 GMT client backend[4104] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:41.562 GMT client backend[4104] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:41.562 GMT client backend[4104] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:41.565 GMT client backend[4104] 035_conflicts.pl LOG:  connection ready: setup total=24.533 ms, fork=13.600 ms, authentication=0.245 ms
2026-05-06 15:09:41.565 GMT client backend[4104] 035_conflicts.pl LOG:  statement: SELECT oid FROM pg_subscription WHERE subname = 'sub_tab';
2026-05-06 15:09:41.572 GMT client backend[4104] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:41.674 GMT client backend[7608] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:41.676 GMT client backend[7608] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:41.676 GMT client backend[7608] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:41.679 GMT client backend[7608] 035_conflicts.pl LOG:  connection ready: setup total=29.764 ms, fork=19.204 ms, authentication=0.290 ms
2026-05-06 15:09:41.679 GMT client backend[7608] 035_conflicts.pl LOG:  statement: SELECT count(*) > 0 FROM pg_conflict.pg_conflict_log_16410;
2026-05-06 15:09:41.684 GMT client backend[7608] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:41.763 GMT client backend[8984] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:41.764 GMT client backend[8984] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:41.764 GMT client backend[8984] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:41.767 GMT client backend[8984] 035_conflicts.pl LOG:  connection ready: setup total=23.105 ms, fork=11.631 ms, authentication=0.329 ms
2026-05-06 15:09:41.768 GMT client backend[8984] 035_conflicts.pl LOG:  statement: SELECT count(*) >= 1 FROM pg_conflict.pg_conflict_log_16410 WHERE conflict_type = 'multiple_unique_conflicts';
2026-05-06 15:09:41.772 GMT client backend[8984] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:41.835 GMT client backend[9116] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:41.838 GMT client backend[9116] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:41.838 GMT client backend[9116] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:41.841 GMT client backend[9116] 035_conflicts.pl LOG:  connection ready: setup total=26.515 ms, fork=11.861 ms, authentication=0.298 ms
2026-05-06 15:09:41.842 GMT client backend[9116] 035_conflicts.pl LOG:  statement: SELECT local_conflicts FROM pg_conflict.pg_conflict_log_16410;
2026-05-06 15:09:41.845 GMT client backend[9116] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:41.964 GMT logical replication apply worker[6848] LOG:  logical replication apply worker for subscription "sub_tab" has started
2026-05-06 15:09:41.978 GMT client backend[2248] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:41.980 GMT client backend[2248] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:41.980 GMT client backend[2248] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:41.982 GMT client backend[2248] 035_conflicts.pl LOG:  connection ready: setup total=30.470 ms, fork=18.713 ms, authentication=0.249 ms
2026-05-06 15:09:41.983 GMT client backend[2248] 035_conflicts.pl LOG:  statement: TRUNCATE conf_tab;
2026-05-06 15:09:41.992 GMT client backend[2248] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.018 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:42.153 GMT client backend[1336] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:42.155 GMT client backend[1336] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:42.155 GMT client backend[1336] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:42.158 GMT client backend[1336] 035_conflicts.pl LOG:  connection ready: setup total=28.991 ms, fork=17.100 ms, authentication=0.317 ms
2026-05-06 15:09:42.159 GMT client backend[1336] 035_conflicts.pl LOG:  statement: DELETE FROM pg_conflict.pg_conflict_log_16410
2026-05-06 15:09:42.160 GMT client backend[1336] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:42.313 GMT client backend[6720] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:42.315 GMT client backend[6720] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:42.315 GMT client backend[6720] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:42.317 GMT client backend[6720] 035_conflicts.pl LOG:  connection ready: setup total=23.967 ms, fork=13.428 ms, authentication=0.222 ms
2026-05-06 15:09:42.318 GMT client backend[6720] 035_conflicts.pl LOG:  statement: INSERT INTO conf_tab VALUES (6,6,6), (7,7,7), (8,8,8);
2026-05-06 15:09:42.319 GMT client backend[6720] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:42.426 GMT logical replication apply worker[6848] ERROR:  conflict detected on relation "public.conf_tab": conflict=multiple_unique_conflicts
2026-05-06 15:09:42.426 GMT logical replication apply worker[6848] DETAIL:  Could not apply remote change: remote row (6, 7, 8), replica identity (a)=(5).
	Key already exists in unique index "conf_tab_pkey", modified in transaction 717: key (a)=(6), local row (6, 6, 6).
	Key already exists in unique index "conf_tab_b_key", modified in transaction 717: key (b)=(7), local row (7, 7, 7).
	Key already exists in unique index "conf_tab_c_key", modified in transaction 717: key (c)=(8), local row (8, 8, 8).
2026-05-06 15:09:42.426 GMT logical replication apply worker[6848] CONTEXT:  processing remote data for replication origin "pg_16410" during message type "UPDATE" for replication target relation "public.conf_tab" in transaction 699, finished at 0/017D8E40
2026-05-06 15:09:42.442 GMT postmaster[8408] LOG:  background worker "logical replication apply worker" (PID 6848) exited with exit code 1
2026-05-06 15:09:42.476 GMT logical replication apply worker[9120] LOG:  logical replication apply worker for subscription "sub_tab" has started
2026-05-06 15:09:42.505 GMT client backend[4656] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:42.507 GMT client backend[4656] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:42.507 GMT client backend[4656] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:42.510 GMT client backend[4656] 035_conflicts.pl LOG:  connection ready: setup total=27.575 ms, fork=14.271 ms, authentication=0.216 ms
2026-05-06 15:09:42.510 GMT client backend[4656] 035_conflicts.pl LOG:  statement: SELECT count(*) > 0 FROM pg_conflict.pg_conflict_log_16410;
2026-05-06 15:09:42.515 GMT logical replication apply worker[9120] ERROR:  conflict detected on relation "public.conf_tab": conflict=multiple_unique_conflicts
2026-05-06 15:09:42.515 GMT logical replication apply worker[9120] DETAIL:  Could not apply remote change: remote row (6, 7, 8), replica identity (a)=(5).
	Key already exists in unique index "conf_tab_pkey", modified in transaction 717: key (a)=(6), local row (6, 6, 6).
	Key already exists in unique index "conf_tab_b_key", modified in transaction 717: key (b)=(7), local row (7, 7, 7).
	Key already exists in unique index "conf_tab_c_key", modified in transaction 717: key (c)=(8), local row (8, 8, 8).
2026-05-06 15:09:42.515 GMT logical replication apply worker[9120] CONTEXT:  processing remote data for replication origin "pg_16410" during message type "UPDATE" for replication target relation "public.conf_tab" in transaction 699, finished at 0/017D8E40
2026-05-06 15:09:42.516 GMT client backend[4656] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:42.530 GMT postmaster[8408] LOG:  background worker "logical replication apply worker" (PID 9120) exited with exit code 1
2026-05-06 15:09:42.644 GMT client backend[828] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:42.646 GMT client backend[828] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:42.646 GMT client backend[828] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:42.649 GMT client backend[828] 035_conflicts.pl LOG:  connection ready: setup total=33.881 ms, fork=18.927 ms, authentication=0.259 ms
2026-05-06 15:09:42.649 GMT client backend[828] 035_conflicts.pl LOG:  statement: SELECT count(*) >= 1 FROM pg_conflict.pg_conflict_log_16410 WHERE conflict_type = 'multiple_unique_conflicts';
2026-05-06 15:09:42.658 GMT client backend[828] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.020 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:42.738 GMT client backend[3944] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:42.740 GMT client backend[3944] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:42.740 GMT client backend[3944] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:42.743 GMT client backend[3944] 035_conflicts.pl LOG:  connection ready: setup total=26.580 ms, fork=13.367 ms, authentication=0.232 ms
2026-05-06 15:09:42.744 GMT client backend[3944] 035_conflicts.pl LOG:  statement: SELECT local_conflicts FROM pg_conflict.pg_conflict_log_16410;
2026-05-06 15:09:42.747 GMT client backend[3944] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:42.865 GMT client backend[9008] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:42.867 GMT client backend[9008] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:42.867 GMT client backend[9008] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:42.869 GMT client backend[9008] 035_conflicts.pl LOG:  connection ready: setup total=23.852 ms, fork=12.979 ms, authentication=0.224 ms
2026-05-06 15:09:42.870 GMT client backend[9008] 035_conflicts.pl LOG:  statement: TRUNCATE conf_tab;
2026-05-06 15:09:42.877 GMT client backend[9008] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:42.981 GMT client backend[4076] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:42.983 GMT client backend[4076] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:42.983 GMT client backend[4076] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:42.985 GMT client backend[4076] 035_conflicts.pl LOG:  connection ready: setup total=28.977 ms, fork=16.839 ms, authentication=0.226 ms
2026-05-06 15:09:42.986 GMT client backend[4076] 035_conflicts.pl LOG:  statement: INSERT INTO conf_tab_2 VALUES (55,2,3);
2026-05-06 15:09:42.990 GMT client backend[4076] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:43.006 GMT logical replication apply worker[6268] LOG:  logical replication apply worker for subscription "sub_tab" has started
2026-05-06 15:09:43.046 GMT logical replication apply worker[6268] LOG:  conflict detected on relation "public.conf_tab": conflict=update_missing
2026-05-06 15:09:43.046 GMT logical replication apply worker[6268] DETAIL:  Could not find the row to be updated: remote row (6, 7, 8), replica identity (a)=(5).
2026-05-06 15:09:43.046 GMT logical replication apply worker[6268] CONTEXT:  processing remote data for replication origin "pg_16410" during message type "UPDATE" for replication target relation "public.conf_tab" in transaction 699, finished at 0/017D8E40
2026-05-06 15:09:43.103 GMT logical replication apply worker[6268] ERROR:  conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts
2026-05-06 15:09:43.103 GMT logical replication apply worker[6268] DETAIL:  Could not apply remote change: remote row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_pkey", modified in transaction 723: key (a)=(55), local row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_a_b_key", modified in transaction 723: key (a, b)=(55, 2), local row (55, 2, 3).
2026-05-06 15:09:43.103 GMT logical replication apply worker[6268] CONTEXT:  processing remote data for replication origin "pg_16410" during message type "INSERT" for replication target relation "public.conf_tab_2" in transaction 700, finished at 0/017D9098
2026-05-06 15:09:43.111 GMT postmaster[8408] LOG:  background worker "logical replication apply worker" (PID 6268) exited with exit code 1
2026-05-06 15:09:43.515 GMT logical replication apply worker[6964] LOG:  logical replication apply worker for subscription "sub_tab" has started
2026-05-06 15:09:43.532 GMT postmaster[8408] LOG:  received fast shutdown request
2026-05-06 15:09:43.533 GMT postmaster[8408] LOG:  aborting any active transactions
2026-05-06 15:09:43.533 GMT logical replication apply worker[6964] FATAL:  terminating logical replication worker due to administrator command
2026-05-06 15:09:43.545 GMT postmaster[8408] LOG:  background worker "logical replication launcher" (PID 1296) exited with exit code 1
2026-05-06 15:09:43.545 GMT postmaster[8408] LOG:  background worker "logical replication apply worker" (PID 6964) exited with exit code 1
2026-05-06 15:09:43.551 GMT checkpointer[7580] LOG:  shutting down
2026-05-06 15:09:43.551 GMT checkpointer[7580] LOG:  checkpoint starting: shutdown fast
2026-05-06 15:09:43.557 GMT checkpointer[7580] LOG:  checkpoint complete: shutdown fast: wrote 21 buffers (16.4%), wrote 3 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.003 s, sync=0.001 s, total=0.006 s; sync files=0, longest=0.000 s, average=0.000 s; distance=278 kB, estimate=278 kB; lsn=0/017E5F28, redo lsn=0/017E5F28
2026-05-06 15:09:43.570 GMT postmaster[8408] LOG:  database system is shut down
2026-05-06 15:09:43.755 GMT postmaster[5856] LOG:  starting PostgreSQL 19devel on x86_64-windows, compiled by msvc-19.29.30159, 64-bit
2026-05-06 15:09:43.756 GMT postmaster[5856] LOG:  listening on Unix socket "C:/Windows/TEMP/hTFoG2pePt/.s.PGSQL.23305"
2026-05-06 15:09:43.807 GMT startup[5924] LOG:  database system was shut down at 2026-05-06 15:09:43 GMT
2026-05-06 15:09:43.808 GMT startup[5924] LOG:  recovered replication state of node 1 to 0/017D8E70
2026-05-06 15:09:43.816 GMT postmaster[5856] LOG:  database system is ready to accept connections
2026-05-06 15:09:43.886 GMT logical replication apply worker[4376] LOG:  logical replication apply worker for subscription "sub_tab" has started
2026-05-06 15:09:43.946 GMT logical replication apply worker[4376] ERROR:  conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts
2026-05-06 15:09:43.946 GMT logical replication apply worker[4376] DETAIL:  Could not apply remote change: remote row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_pkey", modified in transaction 723: key (a)=(55), local row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_a_b_key", modified in transaction 723: key (a, b)=(55, 2), local row (55, 2, 3).
2026-05-06 15:09:43.946 GMT logical replication apply worker[4376] CONTEXT:  processing remote data for replication origin "pg_16410" during message type "INSERT" for replication target relation "public.conf_tab_2" in transaction 700, finished at 0/017D9098
2026-05-06 15:09:43.987 GMT postmaster[5856] LOG:  background worker "logical replication apply worker" (PID 4376) exited with exit code 1
2026-05-06 15:09:44.089 GMT client backend[6016] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:44.092 GMT client backend[6016] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:44.092 GMT client backend[6016] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:44.097 GMT client backend[6016] 035_conflicts.pl LOG:  connection ready: setup total=31.832 ms, fork=16.513 ms, authentication=1.435 ms
2026-05-06 15:09:44.098 GMT client backend[6016] 035_conflicts.pl LOG:  statement: CREATE TABLE tab (a int PRIMARY KEY, b int)
2026-05-06 15:09:44.109 GMT client backend[6016] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.024 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:44.371 GMT logical replication apply worker[3464] LOG:  logical replication apply worker for subscription "sub_tab" has started
2026-05-06 15:09:44.372 GMT client backend[8964] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:44.374 GMT client backend[8964] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:44.374 GMT client backend[8964] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:44.377 GMT client backend[8964] 035_conflicts.pl LOG:  connection ready: setup total=26.679 ms, fork=14.660 ms, authentication=0.280 ms
2026-05-06 15:09:44.377 GMT client backend[8964] 035_conflicts.pl LOG:  statement: CREATE SUBSCRIPTION tap_sub_b_a
		CONNECTION 'port=23304 host=C:/Windows/TEMP/hTFoG2pePt dbname=postgres application_name=tap_sub_b_a'
		PUBLICATION tap_pub_A
		WITH (origin = none, retain_dead_tuples = true)
2026-05-06 15:09:44.413 GMT logical replication apply worker[3464] ERROR:  conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts
2026-05-06 15:09:44.413 GMT logical replication apply worker[3464] DETAIL:  Could not apply remote change: remote row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_pkey", modified in transaction 723: key (a)=(55), local row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_a_b_key", modified in transaction 723: key (a, b)=(55, 2), local row (55, 2, 3).
2026-05-06 15:09:44.413 GMT logical replication apply worker[3464] CONTEXT:  processing remote data for replication origin "pg_16410" during message type "INSERT" for replication target relation "public.conf_tab_2" in transaction 700, finished at 0/017D9098
2026-05-06 15:09:44.430 GMT postmaster[5856] LOG:  background worker "logical replication apply worker" (PID 3464) exited with exit code 1
2026-05-06 15:09:44.471 GMT logical replication launcher[5556] LOG:  creating replication conflict detection slot
2026-05-06 15:09:44.479 GMT client backend[8964] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.111 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:44.508 GMT logical replication apply worker[7796] LOG:  logical replication apply worker for subscription "tap_sub_b_a" has started
2026-05-06 15:09:44.585 GMT logical replication tablesync worker[3948] LOG:  logical replication table synchronization worker for subscription "tap_sub_b_a", table "tab" has started
2026-05-06 15:09:44.629 GMT client backend[3328] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:44.631 GMT client backend[3328] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:44.631 GMT client backend[3328] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:44.642 GMT client backend[3328] 035_conflicts.pl LOG:  connection ready: setup total=35.206 ms, fork=14.706 ms, authentication=0.216 ms
2026-05-06 15:09:44.642 GMT client backend[3328] 035_conflicts.pl LOG:  statement: CREATE PUBLICATION tap_pub_B FOR TABLE tab
2026-05-06 15:09:44.649 GMT client backend[3328] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.024 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:44.658 GMT logical replication tablesync worker[3948] LOG:  logical replication table synchronization worker for subscription "tap_sub_b_a", table "tab" has finished
2026-05-06 15:09:44.808 GMT client backend[7868] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:44.810 GMT walsender[7868] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:44.810 GMT walsender[7868] [unknown] LOG:  replication connection authorized: user=SYSTEM application_name=tap_sub_a_b
2026-05-06 15:09:44.814 GMT walsender[7868] tap_sub_a_b LOG:  connection ready: setup total=43.311 ms, fork=29.041 ms, authentication=1.178 ms
2026-05-06 15:09:44.815 GMT walsender[7868] tap_sub_a_b LOG:  statement: SELECT pg_catalog.set_config('search_path', '', false);
2026-05-06 15:09:44.817 GMT walsender[7868] tap_sub_a_b LOG:  statement: SELECT t.pubname FROM
	 pg_catalog.pg_publication t WHERE
	 t.pubname IN ('tap_pub_b')
2026-05-06 15:09:44.825 GMT walsender[7868] tap_sub_a_b LOG:  statement: SELECT DISTINCT n.nspname, c.relname, c.relkind, gpt.attrs
	   FROM pg_class c
	         JOIN pg_namespace n ON n.oid = c.relnamespace
	         JOIN ( SELECT (pg_get_publication_tables(VARIADIC array_agg(pubname::text))).*
	                FROM pg_publication
	                WHERE pubname IN ( 'tap_pub_b' )) AS gpt
	             ON gpt.relid = c.oid
	UNION ALL
	  SELECT DISTINCT s.schemaname, s.sequencename, 'S'::"char" AS relkind, NULL::int2vector AS attrs
	  FROM pg_catalog.pg_publication_sequences s
	  WHERE s.pubname IN ( 'tap_pub_b' )
2026-05-06 15:09:44.840 GMT walsender[7868] tap_sub_a_b LOG:  received replication command: CREATE_REPLICATION_SLOT "tap_sub_a_b" LOGICAL pgoutput (SNAPSHOT 'nothing')
2026-05-06 15:09:44.840 GMT walsender[7868] tap_sub_a_b STATEMENT:  CREATE_REPLICATION_SLOT "tap_sub_a_b" LOGICAL pgoutput (SNAPSHOT 'nothing')
2026-05-06 15:09:44.847 GMT walsender[7868] tap_sub_a_b LOG:  logical decoding found consistent point at 0/0180C4C0
2026-05-06 15:09:44.847 GMT walsender[7868] tap_sub_a_b DETAIL:  There are no running transactions.
2026-05-06 15:09:44.847 GMT walsender[7868] tap_sub_a_b STATEMENT:  CREATE_REPLICATION_SLOT "tap_sub_a_b" LOGICAL pgoutput (SNAPSHOT 'nothing')
2026-05-06 15:09:44.848 GMT walsender[7868] tap_sub_a_b LOG:  released logical replication slot "tap_sub_a_b"
2026-05-06 15:09:44.848 GMT walsender[7868] tap_sub_a_b STATEMENT:  CREATE_REPLICATION_SLOT "tap_sub_a_b" LOGICAL pgoutput (SNAPSHOT 'nothing')
2026-05-06 15:09:44.849 GMT walsender[7868] tap_sub_a_b LOG:  disconnection: session time: 0:00:00.045 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:44.885 GMT logical replication apply worker[5536] LOG:  logical replication apply worker for subscription "sub_tab" has started
2026-05-06 15:09:44.915 GMT client backend[8428] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:44.917 GMT walsender[8428] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:44.917 GMT walsender[8428] [unknown] LOG:  replication connection authorized: user=SYSTEM application_name=tap_sub_a_b
2026-05-06 15:09:44.922 GMT walsender[8428] tap_sub_a_b LOG:  connection ready: setup total=36.155 ms, fork=15.415 ms, authentication=0.221 ms
2026-05-06 15:09:44.923 GMT walsender[8428] tap_sub_a_b LOG:  statement: SELECT pg_catalog.set_config('search_path', '', false);
2026-05-06 15:09:44.924 GMT walsender[8428] tap_sub_a_b LOG:  received replication command: IDENTIFY_SYSTEM
2026-05-06 15:09:44.924 GMT walsender[8428] tap_sub_a_b STATEMENT:  IDENTIFY_SYSTEM
2026-05-06 15:09:44.925 GMT walsender[8428] tap_sub_a_b LOG:  received replication command: START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"')
2026-05-06 15:09:44.925 GMT walsender[8428] tap_sub_a_b STATEMENT:  START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"')
2026-05-06 15:09:44.925 GMT walsender[8428] tap_sub_a_b LOG:  acquired logical replication slot "tap_sub_a_b"
2026-05-06 15:09:44.925 GMT walsender[8428] tap_sub_a_b STATEMENT:  START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"')
2026-05-06 15:09:44.930 GMT logical replication apply worker[5536] ERROR:  conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts
2026-05-06 15:09:44.930 GMT logical replication apply worker[5536] DETAIL:  Could not apply remote change: remote row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_pkey", modified in transaction 723: key (a)=(55), local row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_a_b_key", modified in transaction 723: key (a, b)=(55, 2), local row (55, 2, 3).
2026-05-06 15:09:44.930 GMT logical replication apply worker[5536] CONTEXT:  processing remote data for replication origin "pg_16410" during message type "INSERT" for replication target relation "public.conf_tab_2" in transaction 700, finished at 0/017D9098
2026-05-06 15:09:44.933 GMT walsender[8428] tap_sub_a_b LOG:  starting logical decoding for slot "tap_sub_a_b"
2026-05-06 15:09:44.933 GMT walsender[8428] tap_sub_a_b DETAIL:  Streaming transactions committing after 0/0180C4F8, reading WAL from 0/0180C4C0.
2026-05-06 15:09:44.933 GMT walsender[8428] tap_sub_a_b STATEMENT:  START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"')
2026-05-06 15:09:44.933 GMT walsender[8428] tap_sub_a_b LOG:  logical decoding found consistent point at 0/0180C4C0
2026-05-06 15:09:44.933 GMT walsender[8428] tap_sub_a_b DETAIL:  There are no running transactions.
2026-05-06 15:09:44.933 GMT walsender[8428] tap_sub_a_b STATEMENT:  START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"')
2026-05-06 15:09:44.972 GMT postmaster[5856] LOG:  background worker "logical replication apply worker" (PID 5536) exited with exit code 1
2026-05-06 15:09:45.138 GMT client backend[5940] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:45.141 GMT client backend[5940] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:45.141 GMT client backend[5940] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:45.148 GMT client backend[5940] 035_conflicts.pl LOG:  connection ready: setup total=39.486 ms, fork=16.390 ms, authentication=0.636 ms
2026-05-06 15:09:45.149 GMT client backend[5940] 035_conflicts.pl LOG:  statement: SELECT pg_is_in_recovery()
2026-05-06 15:09:45.153 GMT client backend[5940] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.022 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:45.247 GMT client backend[5644] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:45.248 GMT client backend[5644] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:45.248 GMT client backend[5644] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:45.251 GMT client backend[5644] 035_conflicts.pl LOG:  connection ready: setup total=20.946 ms, fork=10.802 ms, authentication=0.198 ms
2026-05-06 15:09:45.251 GMT client backend[5644] 035_conflicts.pl LOG:  statement: SELECT pg_current_wal_lsn()
2026-05-06 15:09:45.254 GMT client backend[5644] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:45.321 GMT client backend[5868] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:45.322 GMT client backend[5868] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:45.322 GMT client backend[5868] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:45.325 GMT client backend[5868] 035_conflicts.pl LOG:  connection ready: setup total=25.629 ms, fork=16.505 ms, authentication=0.187 ms
2026-05-06 15:09:45.325 GMT client backend[5868] 035_conflicts.pl LOG:  statement: SELECT '0/0180C7D0' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('tap_sub_a_b', 'walreceiver')
2026-05-06 15:09:45.337 GMT client backend[5868] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:45.384 GMT logical replication apply worker[7576] LOG:  logical replication apply worker for subscription "sub_tab" has started
2026-05-06 15:09:45.428 GMT logical replication apply worker[7576] ERROR:  conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts
2026-05-06 15:09:45.428 GMT logical replication apply worker[7576] DETAIL:  Could not apply remote change: remote row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_pkey", modified in transaction 723: key (a)=(55), local row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_a_b_key", modified in transaction 723: key (a, b)=(55, 2), local row (55, 2, 3).
2026-05-06 15:09:45.428 GMT logical replication apply worker[7576] CONTEXT:  processing remote data for replication origin "pg_16410" during message type "INSERT" for replication target relation "public.conf_tab_2" in transaction 700, finished at 0/017D9098
2026-05-06 15:09:45.438 GMT postmaster[5856] LOG:  background worker "logical replication apply worker" (PID 7576) exited with exit code 1
2026-05-06 15:09:45.452 GMT client backend[2580] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:45.453 GMT client backend[2580] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:45.453 GMT client backend[2580] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:45.456 GMT client backend[2580] 035_conflicts.pl LOG:  connection ready: setup total=26.953 ms, fork=16.368 ms, authentication=0.224 ms
2026-05-06 15:09:45.456 GMT client backend[2580] 035_conflicts.pl LOG:  statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's');
2026-05-06 15:09:45.463 GMT client backend[2580] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:45.899 GMT logical replication apply worker[1304] LOG:  logical replication apply worker for subscription "sub_tab" has started
2026-05-06 15:09:45.946 GMT logical replication apply worker[1304] ERROR:  conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts
2026-05-06 15:09:45.946 GMT logical replication apply worker[1304] DETAIL:  Could not apply remote change: remote row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_pkey", modified in transaction 723: key (a)=(55), local row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_a_b_key", modified in transaction 723: key (a, b)=(55, 2), local row (55, 2, 3).
2026-05-06 15:09:45.946 GMT logical replication apply worker[1304] CONTEXT:  processing remote data for replication origin "pg_16410" during message type "INSERT" for replication target relation "public.conf_tab_2" in transaction 700, finished at 0/017D9098
2026-05-06 15:09:45.980 GMT postmaster[5856] LOG:  background worker "logical replication apply worker" (PID 1304) exited with exit code 1
2026-05-06 15:09:45.981 GMT client backend[7516] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:45.983 GMT client backend[7516] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:45.983 GMT client backend[7516] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:45.987 GMT client backend[7516] 035_conflicts.pl LOG:  connection ready: setup total=44.445 ms, fork=22.845 ms, authentication=0.407 ms
2026-05-06 15:09:45.987 GMT client backend[7516] 035_conflicts.pl LOG:  statement: SELECT xmin IS NOT NULL from pg_replication_slots WHERE slot_name = 'pg_conflict_detection'
2026-05-06 15:09:45.995 GMT client backend[7516] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.027 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:46.216 GMT walsender[8428] tap_sub_a_b LOG:  released logical replication slot "tap_sub_a_b"
2026-05-06 15:09:46.216 GMT walsender[8428] tap_sub_a_b LOG:  disconnection: session time: 0:00:01.312 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:46.405 GMT logical replication apply worker[4436] LOG:  logical replication apply worker for subscription "sub_tab" has started
2026-05-06 15:09:46.453 GMT logical replication apply worker[4436] ERROR:  conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts
2026-05-06 15:09:46.453 GMT logical replication apply worker[4436] DETAIL:  Could not apply remote change: remote row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_pkey", modified in transaction 723: key (a)=(55), local row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_a_b_key", modified in transaction 723: key (a, b)=(55, 2), local row (55, 2, 3).
2026-05-06 15:09:46.453 GMT logical replication apply worker[4436] CONTEXT:  processing remote data for replication origin "pg_16410" during message type "INSERT" for replication target relation "public.conf_tab_2" in transaction 700, finished at 0/017D9098
2026-05-06 15:09:46.466 GMT client backend[2828] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:46.468 GMT walsender[2828] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:46.468 GMT walsender[2828] [unknown] LOG:  replication connection authorized: user=SYSTEM application_name=tap_sub_a_b
2026-05-06 15:09:46.471 GMT walsender[2828] tap_sub_a_b LOG:  connection ready: setup total=26.259 ms, fork=14.085 ms, authentication=0.376 ms
2026-05-06 15:09:46.472 GMT walsender[2828] tap_sub_a_b LOG:  statement: SELECT pg_catalog.set_config('search_path', '', false);
2026-05-06 15:09:46.473 GMT walsender[2828] tap_sub_a_b LOG:  statement: SELECT pg_is_in_recovery()
2026-05-06 15:09:46.473 GMT walsender[2828] tap_sub_a_b LOG:  disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:46.484 GMT postmaster[5856] LOG:  background worker "logical replication apply worker" (PID 4436) exited with exit code 1
2026-05-06 15:09:46.571 GMT client backend[6404] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:46.572 GMT walsender[6404] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:46.572 GMT walsender[6404] [unknown] LOG:  replication connection authorized: user=SYSTEM application_name=tap_sub_a_b
2026-05-06 15:09:46.575 GMT walsender[6404] tap_sub_a_b LOG:  connection ready: setup total=21.526 ms, fork=10.619 ms, authentication=0.229 ms
2026-05-06 15:09:46.575 GMT walsender[6404] tap_sub_a_b LOG:  statement: SELECT pg_catalog.set_config('search_path', '', false);
2026-05-06 15:09:46.576 GMT walsender[6404] tap_sub_a_b LOG:  statement: SELECT pg_is_in_recovery()
2026-05-06 15:09:46.577 GMT walsender[6404] tap_sub_a_b LOG:  disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:46.634 GMT client backend[1204] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:46.636 GMT walsender[1204] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:46.636 GMT walsender[1204] [unknown] LOG:  replication connection authorized: user=SYSTEM application_name=tap_sub_a_b
2026-05-06 15:09:46.639 GMT walsender[1204] tap_sub_a_b LOG:  connection ready: setup total=28.876 ms, fork=13.709 ms, authentication=0.356 ms
2026-05-06 15:09:46.639 GMT walsender[1204] tap_sub_a_b LOG:  statement: SELECT pg_catalog.set_config('search_path', '', false);
2026-05-06 15:09:46.640 GMT walsender[1204] tap_sub_a_b LOG:  received replication command: IDENTIFY_SYSTEM
2026-05-06 15:09:46.640 GMT walsender[1204] tap_sub_a_b STATEMENT:  IDENTIFY_SYSTEM
2026-05-06 15:09:46.640 GMT walsender[1204] tap_sub_a_b LOG:  received replication command: START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"')
2026-05-06 15:09:46.640 GMT walsender[1204] tap_sub_a_b STATEMENT:  START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"')
2026-05-06 15:09:46.640 GMT walsender[1204] tap_sub_a_b LOG:  acquired logical replication slot "tap_sub_a_b"
2026-05-06 15:09:46.640 GMT walsender[1204] tap_sub_a_b STATEMENT:  START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"')
2026-05-06 15:09:46.641 GMT walsender[1204] tap_sub_a_b LOG:  starting logical decoding for slot "tap_sub_a_b"
2026-05-06 15:09:46.641 GMT walsender[1204] tap_sub_a_b DETAIL:  Streaming transactions committing after 0/0180CD80, reading WAL from 0/0180C4C0.
2026-05-06 15:09:46.641 GMT walsender[1204] tap_sub_a_b STATEMENT:  START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"')
2026-05-06 15:09:46.642 GMT walsender[1204] tap_sub_a_b LOG:  logical decoding found consistent point at 0/0180C4C0
2026-05-06 15:09:46.642 GMT walsender[1204] tap_sub_a_b DETAIL:  There are no running transactions.
2026-05-06 15:09:46.642 GMT walsender[1204] tap_sub_a_b STATEMENT:  START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"')
2026-05-06 15:09:46.779 GMT client backend[5968] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:46.781 GMT walsender[5968] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:46.781 GMT walsender[5968] [unknown] LOG:  replication connection authorized: user=SYSTEM application_name=tap_sub_a_b
2026-05-06 15:09:46.784 GMT walsender[5968] tap_sub_a_b LOG:  connection ready: setup total=24.153 ms, fork=12.882 ms, authentication=0.259 ms
2026-05-06 15:09:46.784 GMT walsender[5968] tap_sub_a_b LOG:  statement: SELECT pg_catalog.set_config('search_path', '', false);
2026-05-06 15:09:46.785 GMT walsender[5968] tap_sub_a_b LOG:  statement: SELECT pg_is_in_recovery()
2026-05-06 15:09:46.786 GMT walsender[5968] tap_sub_a_b LOG:  statement: SELECT DISTINCT P.pubname AS pubname
	FROM pg_publication P,
	     LATERAL pg_get_publication_tables(P.pubname) GPT
	     JOIN pg_subscription_rel PS ON (GPT.relid = PS.srrelid OR     GPT.relid IN (SELECT relid FROM pg_partition_ancestors(PS.srrelid) UNION                   SELECT relid FROM pg_partition_tree(PS.srrelid))),
	     pg_class C JOIN pg_namespace N ON (N.oid = C.relnamespace)
	WHERE C.oid = GPT.relid AND P.pubname IN ('tap_pub_b')
	
2026-05-06 15:09:46.803 GMT walsender[5968] tap_sub_a_b LOG:  disconnection: session time: 0:00:00.027 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:46.804 GMT walsender[1204] tap_sub_a_b LOG:  released logical replication slot "tap_sub_a_b"
2026-05-06 15:09:46.805 GMT walsender[1204] tap_sub_a_b LOG:  disconnection: session time: 0:00:00.178 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:46.857 GMT client backend[7576] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:46.859 GMT walsender[7576] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:46.859 GMT walsender[7576] [unknown] LOG:  replication connection authorized: user=SYSTEM application_name=tap_sub_a_b
2026-05-06 15:09:46.863 GMT walsender[7576] tap_sub_a_b LOG:  connection ready: setup total=25.320 ms, fork=12.738 ms, authentication=0.432 ms
2026-05-06 15:09:46.863 GMT walsender[7576] tap_sub_a_b LOG:  statement: SELECT pg_catalog.set_config('search_path', '', false);
2026-05-06 15:09:46.866 GMT walsender[7576] tap_sub_a_b LOG:  received replication command: IDENTIFY_SYSTEM
2026-05-06 15:09:46.866 GMT walsender[7576] tap_sub_a_b STATEMENT:  IDENTIFY_SYSTEM
2026-05-06 15:09:46.867 GMT walsender[7576] tap_sub_a_b LOG:  received replication command: START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"tap_pub_b"')
2026-05-06 15:09:46.867 GMT walsender[7576] tap_sub_a_b STATEMENT:  START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"tap_pub_b"')
2026-05-06 15:09:46.867 GMT walsender[7576] tap_sub_a_b LOG:  acquired logical replication slot "tap_sub_a_b"
2026-05-06 15:09:46.867 GMT walsender[7576] tap_sub_a_b STATEMENT:  START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"tap_pub_b"')
2026-05-06 15:09:46.868 GMT walsender[7576] tap_sub_a_b LOG:  starting logical decoding for slot "tap_sub_a_b"
2026-05-06 15:09:46.868 GMT walsender[7576] tap_sub_a_b DETAIL:  Streaming transactions committing after 0/0180D058, reading WAL from 0/0180C4C0.
2026-05-06 15:09:46.868 GMT walsender[7576] tap_sub_a_b STATEMENT:  START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"tap_pub_b"')
2026-05-06 15:09:46.868 GMT walsender[7576] tap_sub_a_b LOG:  logical decoding found consistent point at 0/0180C4C0
2026-05-06 15:09:46.868 GMT walsender[7576] tap_sub_a_b DETAIL:  There are no running transactions.
2026-05-06 15:09:46.868 GMT walsender[7576] tap_sub_a_b STATEMENT:  START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"tap_pub_b"')
2026-05-06 15:09:46.918 GMT logical replication apply worker[1372] LOG:  logical replication apply worker for subscription "sub_tab" has started
2026-05-06 15:09:46.935 GMT walsender[7576] tap_sub_a_b LOG:  released logical replication slot "tap_sub_a_b"
2026-05-06 15:09:46.935 GMT walsender[7576] tap_sub_a_b LOG:  disconnection: session time: 0:00:00.082 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:46.977 GMT logical replication apply worker[1372] ERROR:  conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts
2026-05-06 15:09:46.977 GMT logical replication apply worker[1372] DETAIL:  Could not apply remote change: remote row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_pkey", modified in transaction 723: key (a)=(55), local row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_a_b_key", modified in transaction 723: key (a, b)=(55, 2), local row (55, 2, 3).
2026-05-06 15:09:46.977 GMT logical replication apply worker[1372] CONTEXT:  processing remote data for replication origin "pg_16410" during message type "INSERT" for replication target relation "public.conf_tab_2" in transaction 700, finished at 0/017D9098
2026-05-06 15:09:46.989 GMT postmaster[5856] LOG:  background worker "logical replication apply worker" (PID 1372) exited with exit code 1
2026-05-06 15:09:47.008 GMT client backend[4752] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:47.009 GMT walsender[4752] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:47.009 GMT walsender[4752] [unknown] LOG:  replication connection authorized: user=SYSTEM application_name=tap_sub_a_b
2026-05-06 15:09:47.013 GMT walsender[4752] tap_sub_a_b LOG:  connection ready: setup total=23.728 ms, fork=11.746 ms, authentication=0.250 ms
2026-05-06 15:09:47.014 GMT walsender[4752] tap_sub_a_b LOG:  statement: SELECT pg_catalog.set_config('search_path', '', false);
2026-05-06 15:09:47.015 GMT walsender[4752] tap_sub_a_b LOG:  received replication command: IDENTIFY_SYSTEM
2026-05-06 15:09:47.015 GMT walsender[4752] tap_sub_a_b STATEMENT:  IDENTIFY_SYSTEM
2026-05-06 15:09:47.015 GMT walsender[4752] tap_sub_a_b LOG:  received replication command: START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"')
2026-05-06 15:09:47.015 GMT walsender[4752] tap_sub_a_b STATEMENT:  START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"')
2026-05-06 15:09:47.015 GMT walsender[4752] tap_sub_a_b LOG:  acquired logical replication slot "tap_sub_a_b"
2026-05-06 15:09:47.015 GMT walsender[4752] tap_sub_a_b STATEMENT:  START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"')
2026-05-06 15:09:47.016 GMT walsender[4752] tap_sub_a_b LOG:  starting logical decoding for slot "tap_sub_a_b"
2026-05-06 15:09:47.016 GMT walsender[4752] tap_sub_a_b DETAIL:  Streaming transactions committing after 0/0180D058, reading WAL from 0/0180C4C0.
2026-05-06 15:09:47.016 GMT walsender[4752] tap_sub_a_b STATEMENT:  START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"')
2026-05-06 15:09:47.016 GMT walsender[4752] tap_sub_a_b LOG:  logical decoding found consistent point at 0/0180C4C0
2026-05-06 15:09:47.016 GMT walsender[4752] tap_sub_a_b DETAIL:  There are no running transactions.
2026-05-06 15:09:47.016 GMT walsender[4752] tap_sub_a_b STATEMENT:  START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"')
2026-05-06 15:09:47.412 GMT logical replication apply worker[3744] LOG:  logical replication apply worker for subscription "sub_tab" has started
2026-05-06 15:09:47.450 GMT logical replication apply worker[3744] ERROR:  conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts
2026-05-06 15:09:47.450 GMT logical replication apply worker[3744] DETAIL:  Could not apply remote change: remote row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_pkey", modified in transaction 723: key (a)=(55), local row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_a_b_key", modified in transaction 723: key (a, b)=(55, 2), local row (55, 2, 3).
2026-05-06 15:09:47.450 GMT logical replication apply worker[3744] CONTEXT:  processing remote data for replication origin "pg_16410" during message type "INSERT" for replication target relation "public.conf_tab_2" in transaction 700, finished at 0/017D9098
2026-05-06 15:09:47.477 GMT postmaster[5856] LOG:  background worker "logical replication apply worker" (PID 3744) exited with exit code 1
2026-05-06 15:09:47.558 GMT client backend[8588] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:47.560 GMT client backend[8588] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:47.560 GMT client backend[8588] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:47.563 GMT client backend[8588] 035_conflicts.pl LOG:  connection ready: setup total=21.747 ms, fork=11.613 ms, authentication=0.243 ms
2026-05-06 15:09:47.563 GMT client backend[8588] 035_conflicts.pl LOG:  statement: SELECT * FROM tab;
2026-05-06 15:09:47.567 GMT client backend[8588] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:47.639 GMT walsender[4752] tap_sub_a_b LOG:  released logical replication slot "tap_sub_a_b"
2026-05-06 15:09:47.639 GMT walsender[4752] tap_sub_a_b LOG:  disconnection: session time: 0:00:00.635 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:47.848 GMT client backend[7220] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:47.850 GMT client backend[7220] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:47.850 GMT client backend[7220] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:47.852 GMT client backend[7220] 035_conflicts.pl LOG:  connection ready: setup total=22.929 ms, fork=13.033 ms, authentication=0.241 ms
2026-05-06 15:09:47.853 GMT client backend[7220] 035_conflicts.pl LOG:  statement: UPDATE tab SET b = 3 WHERE a = 1;
2026-05-06 15:09:47.859 GMT client backend[7220] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:47.918 GMT logical replication apply worker[3984] LOG:  logical replication apply worker for subscription "sub_tab" has started
2026-05-06 15:09:47.960 GMT logical replication apply worker[3984] ERROR:  conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts
2026-05-06 15:09:47.960 GMT logical replication apply worker[3984] DETAIL:  Could not apply remote change: remote row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_pkey", modified in transaction 723: key (a)=(55), local row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_a_b_key", modified in transaction 723: key (a, b)=(55, 2), local row (55, 2, 3).
2026-05-06 15:09:47.960 GMT logical replication apply worker[3984] CONTEXT:  processing remote data for replication origin "pg_16410" during message type "INSERT" for replication target relation "public.conf_tab_2" in transaction 700, finished at 0/017D9098
2026-05-06 15:09:47.975 GMT postmaster[5856] LOG:  background worker "logical replication apply worker" (PID 3984) exited with exit code 1
2026-05-06 15:09:47.985 GMT logical replication apply worker[7796] LOG:  conflict detected on relation "public.tab": conflict=delete_origin_differs
2026-05-06 15:09:47.985 GMT logical replication apply worker[7796] DETAIL:  Deleting the row that was modified locally in transaction 752 at 2026-05-06 15:09:47.85756+00: local row (1, 3), replica identity (a)=(1).
2026-05-06 15:09:47.985 GMT logical replication apply worker[7796] CONTEXT:  processing remote data for replication origin "pg_16428" during message type "DELETE" for replication target relation "public.tab" in transaction 711, finished at 0/01801318
2026-05-06 15:09:48.431 GMT logical replication apply worker[3460] LOG:  logical replication apply worker for subscription "sub_tab" has started
2026-05-06 15:09:48.473 GMT logical replication apply worker[3460] ERROR:  conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts
2026-05-06 15:09:48.473 GMT logical replication apply worker[3460] DETAIL:  Could not apply remote change: remote row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_pkey", modified in transaction 723: key (a)=(55), local row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_a_b_key", modified in transaction 723: key (a, b)=(55, 2), local row (55, 2, 3).
2026-05-06 15:09:48.473 GMT logical replication apply worker[3460] CONTEXT:  processing remote data for replication origin "pg_16410" during message type "INSERT" for replication target relation "public.conf_tab_2" in transaction 700, finished at 0/017D9098
2026-05-06 15:09:48.487 GMT postmaster[5856] LOG:  background worker "logical replication apply worker" (PID 3460) exited with exit code 1
2026-05-06 15:09:48.555 GMT client backend[5360] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:48.557 GMT walsender[5360] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:48.557 GMT walsender[5360] [unknown] LOG:  replication connection authorized: user=SYSTEM application_name=tap_sub_a_b
2026-05-06 15:09:48.563 GMT walsender[5360] tap_sub_a_b LOG:  connection ready: setup total=44.093 ms, fork=30.501 ms, authentication=0.243 ms
2026-05-06 15:09:48.563 GMT walsender[5360] tap_sub_a_b LOG:  statement: SELECT pg_catalog.set_config('search_path', '', false);
2026-05-06 15:09:48.564 GMT walsender[5360] tap_sub_a_b LOG:  statement: SELECT pg_is_in_recovery()
2026-05-06 15:09:48.565 GMT walsender[5360] tap_sub_a_b LOG:  disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:48.627 GMT client backend[8388] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:48.631 GMT walsender[8388] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:48.631 GMT walsender[8388] [unknown] LOG:  replication connection authorized: user=SYSTEM application_name=tap_sub_a_b
2026-05-06 15:09:48.640 GMT walsender[8388] tap_sub_a_b LOG:  connection ready: setup total=36.990 ms, fork=17.406 ms, authentication=0.755 ms
2026-05-06 15:09:48.640 GMT walsender[8388] tap_sub_a_b LOG:  statement: SELECT pg_catalog.set_config('search_path', '', false);
2026-05-06 15:09:48.641 GMT walsender[8388] tap_sub_a_b LOG:  received replication command: IDENTIFY_SYSTEM
2026-05-06 15:09:48.641 GMT walsender[8388] tap_sub_a_b STATEMENT:  IDENTIFY_SYSTEM
2026-05-06 15:09:48.641 GMT walsender[8388] tap_sub_a_b LOG:  received replication command: START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"')
2026-05-06 15:09:48.641 GMT walsender[8388] tap_sub_a_b STATEMENT:  START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"')
2026-05-06 15:09:48.642 GMT walsender[8388] tap_sub_a_b LOG:  acquired logical replication slot "tap_sub_a_b"
2026-05-06 15:09:48.642 GMT walsender[8388] tap_sub_a_b STATEMENT:  START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"')
2026-05-06 15:09:48.642 GMT walsender[8388] tap_sub_a_b LOG:  starting logical decoding for slot "tap_sub_a_b"
2026-05-06 15:09:48.642 GMT walsender[8388] tap_sub_a_b DETAIL:  Streaming transactions committing after 0/0180D7C0, reading WAL from 0/0180C4C0.
2026-05-06 15:09:48.642 GMT walsender[8388] tap_sub_a_b STATEMENT:  START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"')
2026-05-06 15:09:48.642 GMT walsender[8388] tap_sub_a_b LOG:  logical decoding found consistent point at 0/0180C4C0
2026-05-06 15:09:48.642 GMT walsender[8388] tap_sub_a_b DETAIL:  There are no running transactions.
2026-05-06 15:09:48.642 GMT walsender[8388] tap_sub_a_b STATEMENT:  START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"')
2026-05-06 15:09:48.696 GMT client backend[1692] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:48.701 GMT client backend[1692] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:48.701 GMT client backend[1692] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:48.705 GMT client backend[1692] 035_conflicts.pl LOG:  connection ready: setup total=37.708 ms, fork=21.164 ms, authentication=3.957 ms
2026-05-06 15:09:48.705 GMT client backend[1692] 035_conflicts.pl LOG:  statement: SELECT pg_is_in_recovery()
2026-05-06 15:09:48.708 GMT client backend[1692] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:48.797 GMT client backend[1420] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:48.799 GMT client backend[1420] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:48.799 GMT client backend[1420] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:48.803 GMT client backend[1420] 035_conflicts.pl LOG:  connection ready: setup total=33.725 ms, fork=19.656 ms, authentication=0.256 ms
2026-05-06 15:09:48.804 GMT client backend[1420] 035_conflicts.pl LOG:  statement: SELECT pg_current_wal_lsn()
2026-05-06 15:09:48.809 GMT client backend[1420] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:48.899 GMT client backend[7380] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:48.901 GMT client backend[7380] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:48.901 GMT client backend[7380] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:48.904 GMT client backend[7380] 035_conflicts.pl LOG:  connection ready: setup total=35.053 ms, fork=24.057 ms, authentication=0.229 ms
2026-05-06 15:09:48.904 GMT client backend[7380] 035_conflicts.pl LOG:  statement: SELECT '0/0180DEB8' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('tap_sub_a_b', 'walreceiver')
2026-05-06 15:09:48.916 GMT client backend[7380] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.020 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:48.935 GMT logical replication apply worker[6176] LOG:  logical replication apply worker for subscription "sub_tab" has started
2026-05-06 15:09:48.969 GMT logical replication apply worker[6176] ERROR:  conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts
2026-05-06 15:09:48.969 GMT logical replication apply worker[6176] DETAIL:  Could not apply remote change: remote row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_pkey", modified in transaction 723: key (a)=(55), local row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_a_b_key", modified in transaction 723: key (a, b)=(55, 2), local row (55, 2, 3).
2026-05-06 15:09:48.969 GMT logical replication apply worker[6176] CONTEXT:  processing remote data for replication origin "pg_16410" during message type "INSERT" for replication target relation "public.conf_tab_2" in transaction 700, finished at 0/017D9098
2026-05-06 15:09:48.983 GMT postmaster[5856] LOG:  background worker "logical replication apply worker" (PID 6176) exited with exit code 1
2026-05-06 15:09:49.437 GMT logical replication apply worker[3276] LOG:  logical replication apply worker for subscription "sub_tab" has started
2026-05-06 15:09:49.468 GMT logical replication apply worker[3276] ERROR:  conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts
2026-05-06 15:09:49.468 GMT logical replication apply worker[3276] DETAIL:  Could not apply remote change: remote row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_pkey", modified in transaction 723: key (a)=(55), local row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_a_b_key", modified in transaction 723: key (a, b)=(55, 2), local row (55, 2, 3).
2026-05-06 15:09:49.468 GMT logical replication apply worker[3276] CONTEXT:  processing remote data for replication origin "pg_16410" during message type "INSERT" for replication target relation "public.conf_tab_2" in transaction 700, finished at 0/017D9098
2026-05-06 15:09:49.474 GMT postmaster[5856] LOG:  background worker "logical replication apply worker" (PID 3276) exited with exit code 1
2026-05-06 15:09:49.837 GMT client backend[5304] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:49.839 GMT client backend[5304] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:49.839 GMT client backend[5304] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:49.842 GMT client backend[5304] 035_conflicts.pl LOG:  connection ready: setup total=28.086 ms, fork=16.920 ms, authentication=0.190 ms
2026-05-06 15:09:49.843 GMT client backend[5304] 035_conflicts.pl LOG:  statement: ALTER TABLE tab REPLICA IDENTITY FULL
2026-05-06 15:09:49.844 GMT client backend[5304] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:49.945 GMT logical replication apply worker[6284] LOG:  logical replication apply worker for subscription "sub_tab" has started
2026-05-06 15:09:49.992 GMT logical replication apply worker[6284] ERROR:  conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts
2026-05-06 15:09:49.992 GMT logical replication apply worker[6284] DETAIL:  Could not apply remote change: remote row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_pkey", modified in transaction 723: key (a)=(55), local row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_a_b_key", modified in transaction 723: key (a, b)=(55, 2), local row (55, 2, 3).
2026-05-06 15:09:49.992 GMT logical replication apply worker[6284] CONTEXT:  processing remote data for replication origin "pg_16410" during message type "INSERT" for replication target relation "public.conf_tab_2" in transaction 700, finished at 0/017D9098
2026-05-06 15:09:50.044 GMT postmaster[5856] LOG:  background worker "logical replication apply worker" (PID 6284) exited with exit code 1
2026-05-06 15:09:50.082 GMT walsender[8388] tap_sub_a_b LOG:  released logical replication slot "tap_sub_a_b"
2026-05-06 15:09:50.082 GMT walsender[8388] tap_sub_a_b LOG:  disconnection: session time: 0:00:01.460 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:50.337 GMT client backend[1320] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:50.338 GMT client backend[1320] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:50.338 GMT client backend[1320] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:50.342 GMT client backend[1320] 035_conflicts.pl LOG:  connection ready: setup total=31.954 ms, fork=18.190 ms, authentication=0.258 ms
2026-05-06 15:09:50.343 GMT client backend[1320] 035_conflicts.pl LOG:  statement: UPDATE tab SET b = 4 WHERE a = 2;
2026-05-06 15:09:50.347 GMT client backend[1320] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local]
TRAP: failed Assert("conflictlogrel != NULL"), File: "../src/backend/replication/logical/conflict.c", Line: 195, PID: 7796
abort() has been called2026-05-06 15:09:50.443 GMT logical replication apply worker[5204] LOG:  logical replication apply worker for subscription "sub_tab" has started
2026-05-06 15:09:50.496 GMT logical replication apply worker[5204] ERROR:  conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts
2026-05-06 15:09:50.496 GMT logical replication apply worker[5204] DETAIL:  Could not apply remote change: remote row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_pkey", modified in transaction 723: key (a)=(55), local row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_a_b_key", modified in transaction 723: key (a, b)=(55, 2), local row (55, 2, 3).
2026-05-06 15:09:50.496 GMT logical replication apply worker[5204] CONTEXT:  processing remote data for replication origin "pg_16410" during message type "INSERT" for replication target relation "public.conf_tab_2" in transaction 700, finished at 0/017D9098
2026-05-06 15:09:50.523 GMT postmaster[5856] LOG:  background worker "logical replication apply worker" (PID 5204) exited with exit code 1
2026-05-06 15:09:50.639 GMT client backend[8888] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:50.640 GMT walsender[8888] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:50.640 GMT walsender[8888] [unknown] LOG:  replication connection authorized: user=SYSTEM application_name=tap_sub_a_b
2026-05-06 15:09:50.644 GMT walsender[8888] tap_sub_a_b LOG:  connection ready: setup total=25.998 ms, fork=15.214 ms, authentication=0.295 ms
2026-05-06 15:09:50.644 GMT walsender[8888] tap_sub_a_b LOG:  statement: SELECT pg_catalog.set_config('search_path', '', false);
2026-05-06 15:09:50.645 GMT walsender[8888] tap_sub_a_b LOG:  statement: SELECT pg_is_in_recovery()
2026-05-06 15:09:50.646 GMT walsender[8888] tap_sub_a_b LOG:  disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:50.709 GMT client backend[6852] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:50.710 GMT walsender[6852] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:50.710 GMT walsender[6852] [unknown] LOG:  replication connection authorized: user=SYSTEM application_name=tap_sub_a_b
2026-05-06 15:09:50.714 GMT walsender[6852] tap_sub_a_b LOG:  connection ready: setup total=34.618 ms, fork=17.083 ms, authentication=0.285 ms
2026-05-06 15:09:50.714 GMT walsender[6852] tap_sub_a_b LOG:  statement: SELECT pg_catalog.set_config('search_path', '', false);
2026-05-06 15:09:50.715 GMT walsender[6852] tap_sub_a_b LOG:  received replication command: IDENTIFY_SYSTEM
2026-05-06 15:09:50.715 GMT walsender[6852] tap_sub_a_b STATEMENT:  IDENTIFY_SYSTEM
2026-05-06 15:09:50.715 GMT walsender[6852] tap_sub_a_b LOG:  received replication command: START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"')
2026-05-06 15:09:50.715 GMT walsender[6852] tap_sub_a_b STATEMENT:  START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"')
2026-05-06 15:09:50.715 GMT walsender[6852] tap_sub_a_b LOG:  acquired logical replication slot "tap_sub_a_b"
2026-05-06 15:09:50.715 GMT walsender[6852] tap_sub_a_b STATEMENT:  START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"')
2026-05-06 15:09:50.716 GMT walsender[6852] tap_sub_a_b LOG:  starting logical decoding for slot "tap_sub_a_b"
2026-05-06 15:09:50.716 GMT walsender[6852] tap_sub_a_b DETAIL:  Streaming transactions committing after 0/0180E910, reading WAL from 0/0180C4C0.
2026-05-06 15:09:50.716 GMT walsender[6852] tap_sub_a_b STATEMENT:  START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"')
2026-05-06 15:09:50.716 GMT walsender[6852] tap_sub_a_b LOG:  logical decoding found consistent point at 0/0180C4C0
2026-05-06 15:09:50.716 GMT walsender[6852] tap_sub_a_b DETAIL:  There are no running transactions.
2026-05-06 15:09:50.716 GMT walsender[6852] tap_sub_a_b STATEMENT:  START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"')
2026-05-06 15:09:50.759 GMT client backend[5268] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:50.761 GMT client backend[5268] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:50.761 GMT client backend[5268] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:50.764 GMT client backend[5268] 035_conflicts.pl LOG:  connection ready: setup total=28.237 ms, fork=16.960 ms, authentication=0.234 ms
2026-05-06 15:09:50.764 GMT client backend[5268] 035_conflicts.pl LOG:  statement: SELECT pg_is_in_recovery()
2026-05-06 15:09:50.767 GMT client backend[5268] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:50.875 GMT client backend[7864] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:50.876 GMT client backend[7864] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:50.876 GMT client backend[7864] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:50.879 GMT client backend[7864] 035_conflicts.pl LOG:  connection ready: setup total=24.727 ms, fork=13.345 ms, authentication=0.251 ms
2026-05-06 15:09:50.879 GMT client backend[7864] 035_conflicts.pl LOG:  statement: SELECT pg_current_wal_lsn()
2026-05-06 15:09:50.883 GMT client backend[7864] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:50.955 GMT logical replication apply worker[4916] LOG:  logical replication apply worker for subscription "sub_tab" has started
2026-05-06 15:09:50.957 GMT client backend[5512] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:50.958 GMT client backend[5512] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:50.958 GMT client backend[5512] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:50.961 GMT client backend[5512] 035_conflicts.pl LOG:  connection ready: setup total=32.535 ms, fork=20.692 ms, authentication=0.232 ms
2026-05-06 15:09:50.961 GMT client backend[5512] 035_conflicts.pl LOG:  statement: SELECT '0/0180ECA8' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('tap_sub_a_b', 'walreceiver')
2026-05-06 15:09:50.973 GMT client backend[5512] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.021 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:51.005 GMT logical replication apply worker[4916] ERROR:  conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts
2026-05-06 15:09:51.005 GMT logical replication apply worker[4916] DETAIL:  Could not apply remote change: remote row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_pkey", modified in transaction 723: key (a)=(55), local row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_a_b_key", modified in transaction 723: key (a, b)=(55, 2), local row (55, 2, 3).
2026-05-06 15:09:51.005 GMT logical replication apply worker[4916] CONTEXT:  processing remote data for replication origin "pg_16410" during message type "INSERT" for replication target relation "public.conf_tab_2" in transaction 700, finished at 0/017D9098
2026-05-06 15:09:51.021 GMT postmaster[5856] LOG:  background worker "logical replication apply worker" (PID 4916) exited with exit code 1
2026-05-06 15:09:51.082 GMT client backend[7516] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:51.083 GMT client backend[7516] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:51.083 GMT client backend[7516] [unknown] LOG:  connection authorized: user=SYSTEM database=postgres application_name=035_conflicts.pl
2026-05-06 15:09:51.086 GMT client backend[7516] 035_conflicts.pl LOG:  connection ready: setup total=23.102 ms, fork=11.697 ms, authentication=0.230 ms
2026-05-06 15:09:51.086 GMT client backend[7516] 035_conflicts.pl LOG:  statement: ALTER PUBLICATION tap_pub_B DROP TABLE tab
2026-05-06 15:09:51.090 GMT client backend[7516] 035_conflicts.pl LOG:  disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:51.196 GMT client backend[1840] [unknown] LOG:  connection received: host=[local]
2026-05-06 15:09:51.198 GMT walsender[1840] [unknown] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117)
2026-05-06 15:09:51.198 GMT walsender[1840] [unknown] LOG:  replication connection authorized: user=SYSTEM application_name=tap_sub_a_b
2026-05-06 15:09:51.202 GMT walsender[1840] tap_sub_a_b LOG:  connection ready: setup total=34.168 ms, fork=17.641 ms, authentication=0.363 ms
2026-05-06 15:09:51.202 GMT walsender[1840] tap_sub_a_b LOG:  statement: SELECT pg_catalog.set_config('search_path', '', false);
2026-05-06 15:09:51.205 GMT walsender[1840] tap_sub_a_b LOG:  statement: SELECT DISTINCT n.nspname, c.relname, c.relkind, gpt.attrs
	   FROM pg_class c
	         JOIN pg_namespace n ON n.oid = c.relnamespace
	         JOIN ( SELECT (pg_get_publication_tables(VARIADIC array_agg(pubname::text))).*
	                FROM pg_publication
	                WHERE pubname IN ( 'tap_pub_b' )) AS gpt
	             ON gpt.relid = c.oid
	UNION ALL
	  SELECT DISTINCT s.schemaname, s.sequencename, 'S'::"char" AS relkind, NULL::int2vector AS attrs
	  FROM pg_catalog.pg_publication_sequences s
	  WHERE s.pubname IN ( 'tap_pub_b' )
2026-05-06 15:09:51.235 GMT walsender[1840] tap_sub_a_b LOG:  statement: SELECT DISTINCT P.pubname AS pubname
	FROM pg_publication P,
	     LATERAL pg_get_publication_tables(P.pubname) GPT
	     JOIN pg_subscription_rel PS ON (GPT.relid = PS.srrelid OR     GPT.relid IN (SELECT relid FROM pg_partition_ancestors(PS.srrelid) UNION                   SELECT relid FROM pg_partition_tree(PS.srrelid))),
	     pg_class C JOIN pg_namespace N ON (N.oid = C.relnamespace)
	WHERE C.oid = GPT.relid AND P.pubname IN ('tap_pub_b')
	AND NOT (N.nspname = 'public' AND C.relname = 'tab')
	
2026-05-06 15:09:51.240 GMT walsender[1840] tap_sub_a_b LOG:  statement: SELECT DISTINCT P.pubname AS pubname
	FROM pg_publication P,
	     LATERAL pg_get_publication_sequences(P.pubname) GPS
	     JOIN pg_subscription_rel PS ON (GPS.relid = PS.srrelid),
	     pg_class C JOIN pg_namespace N ON (N.oid = C.relnamespace)
	WHERE C.oid = GPS.relid AND P.pubname IN ('tap_pub_b')
	
2026-05-06 15:09:51.243 GMT walsender[1840] tap_sub_a_b LOG:  disconnection: session time: 0:00:00.055 user=SYSTEM database=postgres host=[local]
2026-05-06 15:09:51.453 GMT logical replication apply worker[1676] LOG:  logical replication apply worker for subscription "sub_tab" has started
2026-05-06 15:09:51.494 GMT logical replication apply worker[1676] ERROR:  conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts
2026-05-06 15:09:51.494 GMT logical replication apply worker[1676] DETAIL:  Could not apply remote change: remote row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_pkey", modified in transaction 723: key (a)=(55), local row (55, 2, 3).
	Key already exists in unique index "conf_tab_2_p1_a_b_key", modified in transaction 723: key (a, b)=(55, 2), local row (55, 2, 3).
2026-05-06 15:09:51.494 GMT logical replication apply worker[1676] CONTEXT:  processing remote data for replication origin "pg_16410" during message type "INSERT" for replication target relation "public.conf_tab_2" in transaction 700, finished at 0/017D9098
2026-05-06 15:09:51.557 GMT postmaster[5856] LOG:  background worker "logical replication apply worker" (PID 1676) exited with exit code 1
2026-05-06 15:09:51.724 GMT postmaster[5856] LOG:  background worker "logical replication apply worker" (PID 7796) was terminated by exception 0xC0000354
2026-05-06 15:09:51.724 GMT postmaster[5856] HINT:  See C include file "ntstatus.h" for a description of the hexadecimal value.
2026-05-06 15:09:51.724 GMT postmaster[5856] LOG:  terminating any other active server processes
2026-05-06 15:09:51.743 GMT postmaster[5856] LOG:  shutting down because "restart_after_crash" is off
2026-05-06 15:09:51.745 GMT postmaster[5856] LOG:  database system is shut down