2026-05-06 14:56:46.628 UTC postmaster[67514] LOG: starting PostgreSQL 19devel on x86_64-freebsd, compiled by clang-19.1.7, 64-bit 2026-05-06 14:56:46.628 UTC postmaster[67514] LOG: listening on Unix socket "/tmp/kD87SeIw7n/.s.PGSQL.24927" 2026-05-06 14:56:46.630 UTC startup[67525] LOG: database system was shut down at 2026-05-06 14:56:46 UTC 2026-05-06 14:56:46.632 UTC postmaster[67514] LOG: database system is ready to accept connections 2026-05-06 14:56:46.760 UTC client backend[67579] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:46.760 UTC client backend[67579] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:46.760 UTC client backend[67579] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:46.766 UTC client backend[67579] 035_conflicts.pl LOG: connection ready: setup total=7.078 ms, fork=1.062 ms, authentication=0.135 ms 2026-05-06 14:56:46.766 UTC client backend[67579] 035_conflicts.pl LOG: statement: CREATE TABLE conf_tab (a int PRIMARY key, b int UNIQUE, c int UNIQUE); 2026-05-06 14:56:46.776 UTC client backend[67579] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.016 user=postgres database=postgres host=[local] 2026-05-06 14:56:46.790 UTC client backend[67592] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:46.791 UTC client backend[67592] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:46.791 UTC client backend[67592] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:46.791 UTC client backend[67592] 035_conflicts.pl LOG: connection ready: setup total=1.834 ms, fork=0.420 ms, authentication=0.196 ms 2026-05-06 14:56:46.792 UTC client backend[67592] 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 14:56:46.796 UTC client backend[67592] 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 14:56:46.803 UTC client backend[67592] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.012 user=postgres database=postgres host=[local] 2026-05-06 14:56:46.834 UTC client backend[67606] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:46.835 UTC client backend[67606] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:46.835 UTC client backend[67606] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:46.836 UTC client backend[67606] 035_conflicts.pl LOG: connection ready: setup total=3.800 ms, fork=2.195 ms, authentication=0.183 ms 2026-05-06 14:56:46.836 UTC client backend[67606] 035_conflicts.pl LOG: statement: CREATE SUBSCRIPTION sub_tab CONNECTION 'port=24926 host=/tmp/kD87SeIw7n dbname=postgres application_name=sub_tab' PUBLICATION pub_tab WITH (conflict_log_destination=all) 2026-05-06 14:56:46.836 UTC client backend[67606] 035_conflicts.pl WARNING: subscriptions created by regression test cases should have names starting with "regress_" 2026-05-06 14:56:46.909 UTC client backend[67606] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.074 user=postgres database=postgres host=[local] 2026-05-06 14:56:46.917 UTC client backend[67637] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:46.918 UTC client backend[67637] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:46.918 UTC client backend[67637] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:46.918 UTC client backend[67637] 035_conflicts.pl LOG: connection ready: setup total=1.979 ms, fork=0.590 ms, authentication=0.176 ms 2026-05-06 14:56:46.920 UTC client backend[67637] 035_conflicts.pl LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2026-05-06 14:56:46.921 UTC logical replication apply worker[67631] LOG: logical replication apply worker for subscription "sub_tab" has started 2026-05-06 14:56:46.927 UTC client backend[67637] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.010 user=postgres database=postgres host=[local] 2026-05-06 14:56:46.945 UTC logical replication tablesync worker[67647] LOG: logical replication table synchronization worker for subscription "sub_tab", table "conf_tab" has started 2026-05-06 14:56:46.950 UTC logical replication tablesync worker[67657] LOG: logical replication table synchronization worker for subscription "sub_tab", table "conf_tab_2" has started 2026-05-06 14:56:46.993 UTC logical replication tablesync worker[67647] LOG: logical replication table synchronization worker for subscription "sub_tab", table "conf_tab" has finished 2026-05-06 14:56:46.998 UTC logical replication tablesync worker[67657] LOG: logical replication table synchronization worker for subscription "sub_tab", table "conf_tab_2" has finished 2026-05-06 14:56:47.043 UTC client backend[67705] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:47.043 UTC client backend[67705] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:47.043 UTC client backend[67705] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:47.044 UTC client backend[67705] 035_conflicts.pl LOG: connection ready: setup total=2.892 ms, fork=0.753 ms, authentication=0.109 ms 2026-05-06 14:56:47.045 UTC client backend[67705] 035_conflicts.pl LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2026-05-06 14:56:47.077 UTC client backend[67705] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.034 user=postgres database=postgres host=[local] 2026-05-06 14:56:47.165 UTC client backend[67763] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:47.166 UTC client backend[67763] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:47.166 UTC client backend[67763] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:47.166 UTC client backend[67763] 035_conflicts.pl LOG: connection ready: setup total=1.892 ms, fork=0.582 ms, authentication=0.159 ms 2026-05-06 14:56:47.166 UTC client backend[67763] 035_conflicts.pl LOG: statement: INSERT INTO conf_tab VALUES (2,2,2), (3,3,3), (4,4,4); 2026-05-06 14:56:47.169 UTC client backend[67763] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2026-05-06 14:56:47.187 UTC logical replication apply worker[67631] ERROR: conflict detected on relation "public.conf_tab": conflict=multiple_unique_conflicts 2026-05-06 14:56:47.187 UTC logical replication apply worker[67631] 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 14:56:47.187 UTC logical replication apply worker[67631] 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/017DB7D8 2026-05-06 14:56:47.191 UTC postmaster[67514] LOG: background worker "logical replication apply worker" (PID 67631) exited with exit code 1 2026-05-06 14:56:47.294 UTC client backend[67817] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:47.294 UTC client backend[67817] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:47.294 UTC client backend[67817] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:47.295 UTC client backend[67817] 035_conflicts.pl LOG: connection ready: setup total=1.826 ms, fork=0.544 ms, authentication=0.111 ms 2026-05-06 14:56:47.295 UTC client backend[67817] 035_conflicts.pl LOG: statement: SELECT oid FROM pg_subscription WHERE subname = 'sub_tab'; 2026-05-06 14:56:47.301 UTC client backend[67817] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.007 user=postgres database=postgres host=[local] 2026-05-06 14:56:47.309 UTC client backend[67826] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:47.309 UTC client backend[67826] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:47.309 UTC client backend[67826] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:47.310 UTC client backend[67826] 035_conflicts.pl LOG: connection ready: setup total=2.061 ms, fork=0.639 ms, authentication=0.122 ms 2026-05-06 14:56:47.310 UTC client backend[67826] 035_conflicts.pl LOG: statement: SELECT count(*) > 0 FROM pg_conflict.pg_conflict_log_16410; 2026-05-06 14:56:47.318 UTC client backend[67826] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.009 user=postgres database=postgres host=[local] 2026-05-06 14:56:47.334 UTC client backend[67838] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:47.334 UTC client backend[67838] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:47.334 UTC client backend[67838] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:47.335 UTC client backend[67838] 035_conflicts.pl LOG: connection ready: setup total=1.947 ms, fork=0.566 ms, authentication=0.168 ms 2026-05-06 14:56:47.335 UTC client backend[67838] 035_conflicts.pl LOG: statement: SELECT count(*) >= 1 FROM pg_conflict.pg_conflict_log_16410 WHERE conflict_type = 'multiple_unique_conflicts'; 2026-05-06 14:56:47.351 UTC client backend[67838] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.017 user=postgres database=postgres host=[local] 2026-05-06 14:56:47.364 UTC client backend[67853] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:47.365 UTC client backend[67853] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:47.365 UTC client backend[67853] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:47.365 UTC client backend[67853] 035_conflicts.pl LOG: connection ready: setup total=5.474 ms, fork=4.088 ms, authentication=0.158 ms 2026-05-06 14:56:47.366 UTC client backend[67853] 035_conflicts.pl LOG: statement: SELECT local_conflicts FROM pg_conflict.pg_conflict_log_16410; 2026-05-06 14:56:47.391 UTC client backend[67853] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.027 user=postgres database=postgres host=[local] 2026-05-06 14:56:47.406 UTC client backend[67874] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:47.406 UTC client backend[67874] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:47.406 UTC client backend[67874] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:47.407 UTC client backend[67874] 035_conflicts.pl LOG: connection ready: setup total=2.291 ms, fork=0.950 ms, authentication=0.116 ms 2026-05-06 14:56:47.407 UTC client backend[67874] 035_conflicts.pl LOG: statement: TRUNCATE conf_tab; 2026-05-06 14:56:47.416 UTC client backend[67874] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.010 user=postgres database=postgres host=[local] 2026-05-06 14:56:47.420 UTC client backend[67880] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:47.421 UTC client backend[67880] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:47.421 UTC client backend[67880] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:47.421 UTC client backend[67880] 035_conflicts.pl LOG: connection ready: setup total=2.270 ms, fork=0.991 ms, authentication=0.107 ms 2026-05-06 14:56:47.422 UTC client backend[67880] 035_conflicts.pl LOG: statement: DELETE FROM pg_conflict.pg_conflict_log_16410 2026-05-06 14:56:47.425 UTC client backend[67880] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.005 user=postgres database=postgres host=[local] 2026-05-06 14:56:47.431 UTC logical replication apply worker[67881] LOG: logical replication apply worker for subscription "sub_tab" has started 2026-05-06 14:56:47.454 UTC client backend[67898] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:47.454 UTC client backend[67898] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:47.454 UTC client backend[67898] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:47.455 UTC client backend[67898] 035_conflicts.pl LOG: connection ready: setup total=1.747 ms, fork=0.500 ms, authentication=0.113 ms 2026-05-06 14:56:47.455 UTC client backend[67898] 035_conflicts.pl LOG: statement: INSERT INTO conf_tab VALUES (6,6,6), (7,7,7), (8,8,8); 2026-05-06 14:56:47.458 UTC client backend[67898] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2026-05-06 14:56:47.470 UTC logical replication apply worker[67881] ERROR: conflict detected on relation "public.conf_tab": conflict=multiple_unique_conflicts 2026-05-06 14:56:47.470 UTC logical replication apply worker[67881] 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 715: key (a)=(6), local row (6, 6, 6). Key already exists in unique index "conf_tab_b_key", modified in transaction 715: key (b)=(7), local row (7, 7, 7). Key already exists in unique index "conf_tab_c_key", modified in transaction 715: key (c)=(8), local row (8, 8, 8). 2026-05-06 14:56:47.470 UTC logical replication apply worker[67881] 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/017DBA58 2026-05-06 14:56:47.473 UTC postmaster[67514] LOG: background worker "logical replication apply worker" (PID 67881) exited with exit code 1 2026-05-06 14:56:47.577 UTC client backend[67968] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:47.577 UTC client backend[67968] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:47.577 UTC client backend[67968] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:47.578 UTC client backend[67968] 035_conflicts.pl LOG: connection ready: setup total=1.905 ms, fork=0.539 ms, authentication=0.114 ms 2026-05-06 14:56:47.578 UTC client backend[67968] 035_conflicts.pl LOG: statement: SELECT count(*) > 0 FROM pg_conflict.pg_conflict_log_16410; 2026-05-06 14:56:47.585 UTC client backend[67968] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.008 user=postgres database=postgres host=[local] 2026-05-06 14:56:47.593 UTC client backend[67975] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:47.593 UTC client backend[67975] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:47.593 UTC client backend[67975] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:47.594 UTC client backend[67975] 035_conflicts.pl LOG: connection ready: setup total=2.005 ms, fork=0.592 ms, authentication=0.121 ms 2026-05-06 14:56:47.594 UTC client backend[67975] 035_conflicts.pl LOG: statement: SELECT count(*) >= 1 FROM pg_conflict.pg_conflict_log_16410 WHERE conflict_type = 'multiple_unique_conflicts'; 2026-05-06 14:56:47.601 UTC client backend[67975] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.008 user=postgres database=postgres host=[local] 2026-05-06 14:56:47.609 UTC client backend[67989] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:47.610 UTC client backend[67989] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:47.610 UTC client backend[67989] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:47.611 UTC client backend[67989] 035_conflicts.pl LOG: connection ready: setup total=1.815 ms, fork=0.517 ms, authentication=0.103 ms 2026-05-06 14:56:47.611 UTC client backend[67989] 035_conflicts.pl LOG: statement: SELECT local_conflicts FROM pg_conflict.pg_conflict_log_16410; 2026-05-06 14:56:47.617 UTC client backend[67989] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.008 user=postgres database=postgres host=[local] 2026-05-06 14:56:47.628 UTC client backend[68003] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:47.637 UTC client backend[68003] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:47.637 UTC client backend[68003] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:47.637 UTC client backend[68003] 035_conflicts.pl LOG: connection ready: setup total=10.700 ms, fork=0.751 ms, authentication=0.118 ms 2026-05-06 14:56:47.639 UTC client backend[68003] 035_conflicts.pl LOG: statement: TRUNCATE conf_tab; 2026-05-06 14:56:47.641 UTC client backend[68003] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.013 user=postgres database=postgres host=[local] 2026-05-06 14:56:47.649 UTC client backend[68015] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:47.649 UTC client backend[68015] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:47.649 UTC client backend[68015] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:47.650 UTC client backend[68015] 035_conflicts.pl LOG: connection ready: setup total=1.723 ms, fork=0.591 ms, authentication=0.099 ms 2026-05-06 14:56:47.650 UTC client backend[68015] 035_conflicts.pl LOG: statement: INSERT INTO conf_tab_2 VALUES (55,2,3); 2026-05-06 14:56:47.652 UTC client backend[68015] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.003 user=postgres database=postgres host=[local] 2026-05-06 14:56:47.933 UTC logical replication apply worker[68185] LOG: logical replication apply worker for subscription "sub_tab" has started 2026-05-06 14:56:47.940 UTC logical replication apply worker[68185] LOG: conflict detected on relation "public.conf_tab": conflict=update_missing 2026-05-06 14:56:47.940 UTC logical replication apply worker[68185] DETAIL: Could not find the row to be updated: remote row (6, 7, 8), replica identity (a)=(5). 2026-05-06 14:56:47.940 UTC logical replication apply worker[68185] 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/017DBA58 2026-05-06 14:56:47.942 UTC logical replication apply worker[68185] ERROR: conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts 2026-05-06 14:56:47.942 UTC logical replication apply worker[68185] 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 719: key (a)=(55), local row (55, 2, 3). Key already exists in unique index "conf_tab_2_p1_a_b_key", modified in transaction 719: key (a, b)=(55, 2), local row (55, 2, 3). 2026-05-06 14:56:47.942 UTC logical replication apply worker[68185] 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/017DBCB0 2026-05-06 14:56:47.944 UTC postmaster[67514] LOG: background worker "logical replication apply worker" (PID 68185) exited with exit code 1 2026-05-06 14:56:48.190 UTC postmaster[67514] LOG: received fast shutdown request 2026-05-06 14:56:48.191 UTC postmaster[67514] LOG: aborting any active transactions 2026-05-06 14:56:48.194 UTC postmaster[67514] LOG: background worker "logical replication launcher" (PID 67529) exited with exit code 1 2026-05-06 14:56:48.194 UTC checkpointer[67523] LOG: shutting down 2026-05-06 14:56:48.194 UTC checkpointer[67523] LOG: checkpoint starting: shutdown fast 2026-05-06 14:56:48.195 UTC checkpointer[67523] LOG: checkpoint complete: shutdown fast: wrote 16 buffers (12.5%), wrote 3 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.001 s; sync files=0, longest=0.000 s, average=0.000 s; distance=276 kB, estimate=276 kB; lsn=0/017E82F8, redo lsn=0/017E82F8 2026-05-06 14:56:48.198 UTC postmaster[67514] LOG: database system is shut down 2026-05-06 14:56:48.305 UTC postmaster[68406] LOG: starting PostgreSQL 19devel on x86_64-freebsd, compiled by clang-19.1.7, 64-bit 2026-05-06 14:56:48.305 UTC postmaster[68406] LOG: listening on Unix socket "/tmp/kD87SeIw7n/.s.PGSQL.24927" 2026-05-06 14:56:48.310 UTC startup[68416] LOG: database system was shut down at 2026-05-06 14:56:48 UTC 2026-05-06 14:56:48.310 UTC startup[68416] LOG: recovered replication state of node 1 to 0/017DBA88 2026-05-06 14:56:48.312 UTC postmaster[68406] LOG: database system is ready to accept connections 2026-05-06 14:56:48.327 UTC logical replication apply worker[68428] LOG: logical replication apply worker for subscription "sub_tab" has started 2026-05-06 14:56:48.342 UTC logical replication apply worker[68428] ERROR: conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts 2026-05-06 14:56:48.342 UTC logical replication apply worker[68428] 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 719: key (a)=(55), local row (55, 2, 3). Key already exists in unique index "conf_tab_2_p1_a_b_key", modified in transaction 719: key (a, b)=(55, 2), local row (55, 2, 3). 2026-05-06 14:56:48.342 UTC logical replication apply worker[68428] 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/017DBCB0 2026-05-06 14:56:48.353 UTC postmaster[68406] LOG: background worker "logical replication apply worker" (PID 68428) exited with exit code 1 2026-05-06 14:56:48.417 UTC client backend[68478] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:48.417 UTC client backend[68478] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:48.417 UTC client backend[68478] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:48.418 UTC client backend[68478] 035_conflicts.pl LOG: connection ready: setup total=1.854 ms, fork=0.466 ms, authentication=0.190 ms 2026-05-06 14:56:48.418 UTC client backend[68478] 035_conflicts.pl LOG: statement: CREATE TABLE tab (a int PRIMARY KEY, b int) 2026-05-06 14:56:48.422 UTC client backend[68478] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.005 user=postgres database=postgres host=[local] 2026-05-06 14:56:48.443 UTC client backend[68495] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:48.444 UTC client backend[68495] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:48.444 UTC client backend[68495] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:48.444 UTC client backend[68495] 035_conflicts.pl LOG: connection ready: setup total=4.337 ms, fork=2.842 ms, authentication=0.226 ms 2026-05-06 14:56:48.444 UTC client backend[68495] 035_conflicts.pl LOG: statement: CREATE SUBSCRIPTION tap_sub_b_a CONNECTION 'port=24926 host=/tmp/kD87SeIw7n dbname=postgres application_name=tap_sub_b_a' PUBLICATION tap_pub_A WITH (origin = none, retain_dead_tuples = true) 2026-05-06 14:56:48.445 UTC client backend[68495] 035_conflicts.pl WARNING: subscriptions created by regression test cases should have names starting with "regress_" 2026-05-06 14:56:48.499 UTC logical replication launcher[68425] LOG: creating replication conflict detection slot 2026-05-06 14:56:48.501 UTC logical replication apply worker[68534] LOG: logical replication apply worker for subscription "tap_sub_b_a" has started 2026-05-06 14:56:48.502 UTC client backend[68495] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.058 user=postgres database=postgres host=[local] 2026-05-06 14:56:48.507 UTC logical replication tablesync worker[68540] LOG: logical replication table synchronization worker for subscription "tap_sub_b_a", table "tab" has started 2026-05-06 14:56:48.508 UTC client backend[68541] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:48.508 UTC client backend[68541] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:48.508 UTC client backend[68541] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:48.509 UTC client backend[68541] 035_conflicts.pl LOG: connection ready: setup total=1.863 ms, fork=0.566 ms, authentication=0.128 ms 2026-05-06 14:56:48.509 UTC client backend[68541] 035_conflicts.pl LOG: statement: CREATE PUBLICATION tap_pub_B FOR TABLE tab 2026-05-06 14:56:48.511 UTC client backend[68541] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.003 user=postgres database=postgres host=[local] 2026-05-06 14:56:48.523 UTC client backend[68551] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:48.524 UTC walsender[68551] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:48.524 UTC walsender[68551] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 14:56:48.525 UTC walsender[68551] tap_sub_a_b LOG: connection ready: setup total=2.384 ms, fork=0.880 ms, authentication=0.129 ms 2026-05-06 14:56:48.525 UTC walsender[68551] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 14:56:48.525 UTC walsender[68551] 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 14:56:48.532 UTC walsender[68551] 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 14:56:48.549 UTC walsender[68551] tap_sub_a_b LOG: received replication command: CREATE_REPLICATION_SLOT "tap_sub_a_b" LOGICAL pgoutput (SNAPSHOT 'nothing') 2026-05-06 14:56:48.549 UTC walsender[68551] tap_sub_a_b STATEMENT: CREATE_REPLICATION_SLOT "tap_sub_a_b" LOGICAL pgoutput (SNAPSHOT 'nothing') 2026-05-06 14:56:48.549 UTC walsender[68551] tap_sub_a_b LOG: logical decoding found consistent point at 0/0180DCC8 2026-05-06 14:56:48.549 UTC walsender[68551] tap_sub_a_b DETAIL: There are no running transactions. 2026-05-06 14:56:48.549 UTC walsender[68551] tap_sub_a_b STATEMENT: CREATE_REPLICATION_SLOT "tap_sub_a_b" LOGICAL pgoutput (SNAPSHOT 'nothing') 2026-05-06 14:56:48.549 UTC walsender[68551] tap_sub_a_b LOG: released logical replication slot "tap_sub_a_b" 2026-05-06 14:56:48.549 UTC walsender[68551] tap_sub_a_b STATEMENT: CREATE_REPLICATION_SLOT "tap_sub_a_b" LOGICAL pgoutput (SNAPSHOT 'nothing') 2026-05-06 14:56:48.550 UTC walsender[68551] tap_sub_a_b LOG: disconnection: session time: 0:00:00.027 user=postgres database=postgres host=[local] 2026-05-06 14:56:48.561 UTC logical replication tablesync worker[68540] LOG: logical replication table synchronization worker for subscription "tap_sub_b_a", table "tab" has finished 2026-05-06 14:56:48.563 UTC client backend[68576] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:48.563 UTC walsender[68576] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:48.563 UTC walsender[68576] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 14:56:48.566 UTC walsender[68576] tap_sub_a_b LOG: connection ready: setup total=5.219 ms, fork=1.242 ms, authentication=0.232 ms 2026-05-06 14:56:48.570 UTC walsender[68576] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 14:56:48.571 UTC walsender[68576] tap_sub_a_b LOG: received replication command: IDENTIFY_SYSTEM 2026-05-06 14:56:48.571 UTC walsender[68576] tap_sub_a_b STATEMENT: IDENTIFY_SYSTEM 2026-05-06 14:56:48.571 UTC walsender[68576] 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 14:56:48.571 UTC walsender[68576] 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 14:56:48.571 UTC walsender[68576] tap_sub_a_b LOG: acquired logical replication slot "tap_sub_a_b" 2026-05-06 14:56:48.571 UTC walsender[68576] 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 14:56:48.571 UTC walsender[68576] tap_sub_a_b LOG: starting logical decoding for slot "tap_sub_a_b" 2026-05-06 14:56:48.571 UTC walsender[68576] tap_sub_a_b DETAIL: Streaming transactions committing after 0/0180DD00, reading WAL from 0/0180DCC8. 2026-05-06 14:56:48.571 UTC walsender[68576] 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 14:56:48.571 UTC walsender[68576] tap_sub_a_b LOG: logical decoding found consistent point at 0/0180DCC8 2026-05-06 14:56:48.571 UTC walsender[68576] tap_sub_a_b DETAIL: There are no running transactions. 2026-05-06 14:56:48.571 UTC walsender[68576] 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 14:56:48.593 UTC client backend[68593] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:48.593 UTC client backend[68593] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:48.593 UTC client backend[68593] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:48.594 UTC client backend[68593] 035_conflicts.pl LOG: connection ready: setup total=2.713 ms, fork=1.384 ms, authentication=0.131 ms 2026-05-06 14:56:48.594 UTC client backend[68593] 035_conflicts.pl LOG: statement: SELECT pg_is_in_recovery() 2026-05-06 14:56:48.599 UTC client backend[68593] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.006 user=postgres database=postgres host=[local] 2026-05-06 14:56:48.612 UTC client backend[68605] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:48.612 UTC client backend[68605] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:48.612 UTC client backend[68605] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:48.613 UTC client backend[68605] 035_conflicts.pl LOG: connection ready: setup total=1.820 ms, fork=0.535 ms, authentication=0.133 ms 2026-05-06 14:56:48.613 UTC client backend[68605] 035_conflicts.pl LOG: statement: SELECT pg_current_wal_lsn() 2026-05-06 14:56:48.618 UTC client backend[68605] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.006 user=postgres database=postgres host=[local] 2026-05-06 14:56:48.626 UTC client backend[68613] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:48.627 UTC client backend[68613] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:48.627 UTC client backend[68613] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:48.628 UTC client backend[68613] 035_conflicts.pl LOG: connection ready: setup total=3.705 ms, fork=2.246 ms, authentication=0.153 ms 2026-05-06 14:56:48.628 UTC client backend[68613] 035_conflicts.pl LOG: statement: SELECT '0/0180DD00' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('tap_sub_a_b', 'walreceiver') 2026-05-06 14:56:48.634 UTC client backend[68613] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.007 user=postgres database=postgres host=[local] 2026-05-06 14:56:48.642 UTC client backend[68620] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:48.642 UTC client backend[68620] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:48.642 UTC client backend[68620] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:48.643 UTC client backend[68620] 035_conflicts.pl LOG: connection ready: setup total=2.005 ms, fork=0.520 ms, authentication=0.162 ms 2026-05-06 14:56:48.643 UTC client backend[68620] 035_conflicts.pl LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2026-05-06 14:56:48.650 UTC client backend[68620] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.008 user=postgres database=postgres host=[local] 2026-05-06 14:56:48.713 UTC client backend[68666] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:48.713 UTC client backend[68666] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:48.713 UTC client backend[68666] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:48.714 UTC client backend[68666] 035_conflicts.pl LOG: connection ready: setup total=1.728 ms, fork=0.448 ms, authentication=0.159 ms 2026-05-06 14:56:48.714 UTC client backend[68666] 035_conflicts.pl LOG: statement: SELECT xmin IS NOT NULL from pg_replication_slots WHERE slot_name = 'pg_conflict_detection' 2026-05-06 14:56:48.722 UTC client backend[68666] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.009 user=postgres database=postgres host=[local] 2026-05-06 14:56:48.745 UTC walsender[68576] tap_sub_a_b LOG: released logical replication slot "tap_sub_a_b" 2026-05-06 14:56:48.745 UTC walsender[68576] tap_sub_a_b LOG: disconnection: session time: 0:00:00.183 user=postgres database=postgres host=[local] 2026-05-06 14:56:48.770 UTC client backend[68700] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:48.770 UTC walsender[68700] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:48.770 UTC walsender[68700] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 14:56:48.771 UTC walsender[68700] tap_sub_a_b LOG: connection ready: setup total=1.909 ms, fork=0.525 ms, authentication=0.180 ms 2026-05-06 14:56:48.771 UTC walsender[68700] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 14:56:48.772 UTC walsender[68700] tap_sub_a_b LOG: statement: SELECT pg_is_in_recovery() 2026-05-06 14:56:48.776 UTC walsender[68700] tap_sub_a_b LOG: disconnection: session time: 0:00:00.006 user=postgres database=postgres host=[local] 2026-05-06 14:56:48.788 UTC client backend[68711] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:48.789 UTC walsender[68711] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:48.789 UTC walsender[68711] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 14:56:48.789 UTC walsender[68711] tap_sub_a_b LOG: connection ready: setup total=2.027 ms, fork=0.529 ms, authentication=0.184 ms 2026-05-06 14:56:48.790 UTC walsender[68711] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 14:56:48.790 UTC walsender[68711] tap_sub_a_b LOG: statement: SELECT pg_is_in_recovery() 2026-05-06 14:56:48.795 UTC walsender[68711] tap_sub_a_b LOG: disconnection: session time: 0:00:00.006 user=postgres database=postgres host=[local] 2026-05-06 14:56:48.800 UTC client backend[68720] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:48.801 UTC walsender[68720] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:48.801 UTC walsender[68720] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 14:56:48.802 UTC walsender[68720] tap_sub_a_b LOG: connection ready: setup total=1.922 ms, fork=0.567 ms, authentication=0.132 ms 2026-05-06 14:56:48.802 UTC walsender[68720] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 14:56:48.802 UTC walsender[68720] tap_sub_a_b LOG: received replication command: IDENTIFY_SYSTEM 2026-05-06 14:56:48.802 UTC walsender[68720] tap_sub_a_b STATEMENT: IDENTIFY_SYSTEM 2026-05-06 14:56:48.802 UTC walsender[68720] 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 14:56:48.802 UTC walsender[68720] 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 14:56:48.802 UTC walsender[68720] tap_sub_a_b LOG: acquired logical replication slot "tap_sub_a_b" 2026-05-06 14:56:48.802 UTC walsender[68720] 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 14:56:48.803 UTC walsender[68720] tap_sub_a_b LOG: starting logical decoding for slot "tap_sub_a_b" 2026-05-06 14:56:48.803 UTC walsender[68720] tap_sub_a_b DETAIL: Streaming transactions committing after 0/0180E250, reading WAL from 0/0180DCC8. 2026-05-06 14:56:48.803 UTC walsender[68720] 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 14:56:48.803 UTC walsender[68720] tap_sub_a_b LOG: logical decoding found consistent point at 0/0180DCC8 2026-05-06 14:56:48.803 UTC walsender[68720] tap_sub_a_b DETAIL: There are no running transactions. 2026-05-06 14:56:48.803 UTC walsender[68720] 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 14:56:48.822 UTC logical replication apply worker[68731] LOG: logical replication apply worker for subscription "sub_tab" has started 2026-05-06 14:56:48.830 UTC logical replication apply worker[68731] ERROR: conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts 2026-05-06 14:56:48.830 UTC logical replication apply worker[68731] 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 719: key (a)=(55), local row (55, 2, 3). Key already exists in unique index "conf_tab_2_p1_a_b_key", modified in transaction 719: key (a, b)=(55, 2), local row (55, 2, 3). 2026-05-06 14:56:48.830 UTC logical replication apply worker[68731] 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/017DBCB0 2026-05-06 14:56:48.833 UTC postmaster[68406] LOG: background worker "logical replication apply worker" (PID 68731) exited with exit code 1 2026-05-06 14:56:48.836 UTC client backend[68743] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:48.836 UTC walsender[68743] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:48.836 UTC walsender[68743] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 14:56:48.837 UTC walsender[68743] tap_sub_a_b LOG: connection ready: setup total=2.249 ms, fork=0.558 ms, authentication=0.133 ms 2026-05-06 14:56:48.838 UTC walsender[68743] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 14:56:48.839 UTC walsender[68743] tap_sub_a_b LOG: statement: SELECT pg_is_in_recovery() 2026-05-06 14:56:48.845 UTC walsender[68743] 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 14:56:48.854 UTC walsender[68743] tap_sub_a_b LOG: disconnection: session time: 0:00:00.018 user=postgres database=postgres host=[local] 2026-05-06 14:56:48.856 UTC walsender[68720] tap_sub_a_b LOG: released logical replication slot "tap_sub_a_b" 2026-05-06 14:56:48.856 UTC walsender[68720] tap_sub_a_b LOG: disconnection: session time: 0:00:00.055 user=postgres database=postgres host=[local] 2026-05-06 14:56:48.864 UTC client backend[68760] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:48.865 UTC walsender[68760] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:48.865 UTC walsender[68760] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 14:56:48.866 UTC walsender[68760] tap_sub_a_b LOG: connection ready: setup total=2.389 ms, fork=0.609 ms, authentication=0.235 ms 2026-05-06 14:56:48.868 UTC walsender[68760] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 14:56:48.869 UTC walsender[68760] tap_sub_a_b LOG: received replication command: IDENTIFY_SYSTEM 2026-05-06 14:56:48.869 UTC walsender[68760] tap_sub_a_b STATEMENT: IDENTIFY_SYSTEM 2026-05-06 14:56:48.869 UTC walsender[68760] 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 14:56:48.869 UTC walsender[68760] 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 14:56:48.869 UTC walsender[68760] tap_sub_a_b LOG: acquired logical replication slot "tap_sub_a_b" 2026-05-06 14:56:48.869 UTC walsender[68760] 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 14:56:48.869 UTC walsender[68760] tap_sub_a_b LOG: starting logical decoding for slot "tap_sub_a_b" 2026-05-06 14:56:48.869 UTC walsender[68760] tap_sub_a_b DETAIL: Streaming transactions committing after 0/0180E528, reading WAL from 0/0180DCC8. 2026-05-06 14:56:48.869 UTC walsender[68760] 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 14:56:48.869 UTC walsender[68760] tap_sub_a_b LOG: logical decoding found consistent point at 0/0180DCC8 2026-05-06 14:56:48.869 UTC walsender[68760] tap_sub_a_b DETAIL: There are no running transactions. 2026-05-06 14:56:48.869 UTC walsender[68760] 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 14:56:48.869 UTC walsender[68760] tap_sub_a_b LOG: released logical replication slot "tap_sub_a_b" 2026-05-06 14:56:48.869 UTC walsender[68760] tap_sub_a_b LOG: disconnection: session time: 0:00:00.005 user=postgres database=postgres host=[local] 2026-05-06 14:56:48.879 UTC client backend[68769] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:48.879 UTC walsender[68769] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:48.879 UTC walsender[68769] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 14:56:48.880 UTC walsender[68769] tap_sub_a_b LOG: connection ready: setup total=6.030 ms, fork=4.291 ms, authentication=0.129 ms 2026-05-06 14:56:48.880 UTC walsender[68769] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 14:56:48.881 UTC walsender[68769] tap_sub_a_b LOG: received replication command: IDENTIFY_SYSTEM 2026-05-06 14:56:48.881 UTC walsender[68769] tap_sub_a_b STATEMENT: IDENTIFY_SYSTEM 2026-05-06 14:56:48.882 UTC walsender[68769] 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 14:56:48.882 UTC walsender[68769] 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 14:56:48.882 UTC walsender[68769] tap_sub_a_b LOG: acquired logical replication slot "tap_sub_a_b" 2026-05-06 14:56:48.882 UTC walsender[68769] 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 14:56:48.883 UTC walsender[68769] tap_sub_a_b LOG: starting logical decoding for slot "tap_sub_a_b" 2026-05-06 14:56:48.883 UTC walsender[68769] tap_sub_a_b DETAIL: Streaming transactions committing after 0/0180E528, reading WAL from 0/0180DCC8. 2026-05-06 14:56:48.883 UTC walsender[68769] 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 14:56:48.884 UTC walsender[68769] tap_sub_a_b LOG: logical decoding found consistent point at 0/0180DCC8 2026-05-06 14:56:48.884 UTC walsender[68769] tap_sub_a_b DETAIL: There are no running transactions. 2026-05-06 14:56:48.884 UTC walsender[68769] 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 14:56:48.938 UTC client backend[68813] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:48.938 UTC client backend[68813] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:48.938 UTC client backend[68813] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:48.939 UTC client backend[68813] 035_conflicts.pl LOG: connection ready: setup total=1.808 ms, fork=0.520 ms, authentication=0.124 ms 2026-05-06 14:56:48.939 UTC client backend[68813] 035_conflicts.pl LOG: statement: SELECT * FROM tab; 2026-05-06 14:56:48.948 UTC client backend[68813] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.010 user=postgres database=postgres host=[local] 2026-05-06 14:56:48.961 UTC walsender[68769] tap_sub_a_b LOG: released logical replication slot "tap_sub_a_b" 2026-05-06 14:56:48.961 UTC walsender[68769] tap_sub_a_b LOG: disconnection: session time: 0:00:00.082 user=postgres database=postgres host=[local] 2026-05-06 14:56:48.984 UTC client backend[68845] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:48.985 UTC client backend[68845] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:48.985 UTC client backend[68845] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:56:48.985 UTC client backend[68845] 035_conflicts.pl LOG: connection ready: setup total=1.966 ms, fork=0.605 ms, authentication=0.149 ms 2026-05-06 14:56:48.986 UTC client backend[68845] 035_conflicts.pl LOG: statement: UPDATE tab SET b = 3 WHERE a = 1; 2026-05-06 14:56:48.989 UTC client backend[68845] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.005 user=postgres database=postgres host=[local] TRAP: failed Assert("conflictlogrel != NULL"), File: "../src/backend/replication/logical/conflict.c", Line: 195, PID: 68534 0xb3a472 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x9433b8 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x968ba9 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x964911 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x966150 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x967010 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x966d6d at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x90ff0c at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x914a25 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x917b77 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x9198f5 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x917156 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x83c16d at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x82d376e34 <__libc_start1+0x124> at /lib/libc.so.7 2026-05-06 14:56:49.329 UTC logical replication apply worker[69060] LOG: logical replication apply worker for subscription "sub_tab" has started 2026-05-06 14:56:49.336 UTC logical replication apply worker[69060] ERROR: conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts 2026-05-06 14:56:49.336 UTC logical replication apply worker[69060] 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 719: key (a)=(55), local row (55, 2, 3). Key already exists in unique index "conf_tab_2_p1_a_b_key", modified in transaction 719: key (a, b)=(55, 2), local row (55, 2, 3). 2026-05-06 14:56:49.336 UTC logical replication apply worker[69060] 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/017DBCB0 2026-05-06 14:56:49.339 UTC postmaster[68406] LOG: background worker "logical replication apply worker" (PID 69060) exited with exit code 1 2026-05-06 14:56:49.404 UTC postmaster[68406] LOG: background worker "logical replication apply worker" (PID 68534) was terminated by signal 6: Abort trap 2026-05-06 14:56:49.404 UTC postmaster[68406] LOG: terminating any other active server processes 2026-05-06 14:56:49.407 UTC postmaster[68406] LOG: shutting down because "restart_after_crash" is off 2026-05-06 14:56:49.407 UTC postmaster[68406] LOG: database system is shut down