2026-05-06 14:58:27.607 UTC postmaster[82406] LOG: starting PostgreSQL 19devel on x86_64-linux, compiled by gcc-14.2.0, 64-bit 2026-05-06 14:58:27.607 UTC postmaster[82406] LOG: listening on Unix socket "/tmp/chagwFPDmx/.s.PGSQL.31475" 2026-05-06 14:58:27.611 UTC startup[82412] LOG: database system was shut down at 2026-05-06 14:58:27 UTC 2026-05-06 14:58:27.614 UTC postmaster[82406] LOG: database system is ready to accept connections 2026-05-06 14:58:27.762 UTC client backend[82452] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:27.762 UTC client backend[82452] [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:58:27.762 UTC client backend[82452] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:27.771 UTC client backend[82452] 035_conflicts.pl LOG: connection ready: setup total=10.556 ms, fork=0.678 ms, authentication=0.276 ms 2026-05-06 14:58:27.771 UTC client backend[82452] 035_conflicts.pl LOG: statement: CREATE TABLE conf_tab (a int PRIMARY key, b int UNIQUE, c int UNIQUE); 2026-05-06 14:58:27.796 UTC client backend[82452] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.034 user=postgres database=postgres host=[local] 2026-05-06 14:58:27.808 UTC client backend[82466] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:27.809 UTC client backend[82466] [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:58:27.809 UTC client backend[82466] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:27.811 UTC client backend[82466] 035_conflicts.pl LOG: connection ready: setup total=3.468 ms, fork=0.616 ms, authentication=0.386 ms 2026-05-06 14:58:27.811 UTC client backend[82466] 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:58:27.815 UTC client backend[82466] 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:58:27.821 UTC client backend[82466] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.013 user=postgres database=postgres host=[local] 2026-05-06 14:58:27.846 UTC client backend[82477] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:27.847 UTC client backend[82477] [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:58:27.847 UTC client backend[82477] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:27.849 UTC client backend[82477] 035_conflicts.pl LOG: connection ready: setup total=3.418 ms, fork=0.732 ms, authentication=0.286 ms 2026-05-06 14:58:27.849 UTC client backend[82477] 035_conflicts.pl LOG: statement: CREATE SUBSCRIPTION sub_tab CONNECTION 'port=31474 host=/tmp/chagwFPDmx dbname=postgres application_name=sub_tab' PUBLICATION pub_tab WITH (conflict_log_destination=all) 2026-05-06 14:58:27.872 UTC client backend[82477] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.025 user=postgres database=postgres host=[local] 2026-05-06 14:58:27.878 UTC logical replication apply worker[82483] LOG: logical replication apply worker for subscription "sub_tab" has started 2026-05-06 14:58:27.887 UTC client backend[82489] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:27.889 UTC logical replication tablesync worker[82487] LOG: logical replication table synchronization worker for subscription "sub_tab", table "conf_tab" has started 2026-05-06 14:58:27.891 UTC client backend[82489] [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:58:27.891 UTC client backend[82489] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:27.892 UTC client backend[82489] 035_conflicts.pl LOG: connection ready: setup total=5.536 ms, fork=0.618 ms, authentication=0.258 ms 2026-05-06 14:58:27.900 UTC client backend[82489] 035_conflicts.pl LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2026-05-06 14:58:27.904 UTC client backend[82489] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.016 user=postgres database=postgres host=[local] 2026-05-06 14:58:27.912 UTC logical replication tablesync worker[82497] LOG: logical replication table synchronization worker for subscription "sub_tab", table "conf_tab_2" has started 2026-05-06 14:58:27.918 UTC logical replication tablesync worker[82487] LOG: logical replication table synchronization worker for subscription "sub_tab", table "conf_tab" has finished 2026-05-06 14:58:27.961 UTC logical replication tablesync worker[82497] LOG: logical replication table synchronization worker for subscription "sub_tab", table "conf_tab_2" has finished 2026-05-06 14:58:28.014 UTC client backend[82529] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:28.015 UTC client backend[82529] [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:58:28.015 UTC client backend[82529] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:28.016 UTC client backend[82529] 035_conflicts.pl LOG: connection ready: setup total=3.523 ms, fork=0.805 ms, authentication=0.267 ms 2026-05-06 14:58:28.017 UTC client backend[82529] 035_conflicts.pl LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2026-05-06 14:58:28.019 UTC client backend[82529] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.005 user=postgres database=postgres host=[local] 2026-05-06 14:58:28.118 UTC client backend[82561] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:28.119 UTC client backend[82561] [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:58:28.119 UTC client backend[82561] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:28.120 UTC client backend[82561] 035_conflicts.pl LOG: connection ready: setup total=3.347 ms, fork=0.740 ms, authentication=0.284 ms 2026-05-06 14:58:28.121 UTC client backend[82561] 035_conflicts.pl LOG: statement: INSERT INTO conf_tab VALUES (2,2,2), (3,3,3), (4,4,4); 2026-05-06 14:58:28.122 UTC client backend[82561] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.003 user=postgres database=postgres host=[local] 2026-05-06 14:58:28.139 UTC logical replication apply worker[82483] ERROR: conflict detected on relation "public.conf_tab": conflict=multiple_unique_conflicts 2026-05-06 14:58:28.139 UTC logical replication apply worker[82483] 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:58:28.139 UTC logical replication apply worker[82483] 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/017F4D28 2026-05-06 14:58:28.142 UTC postmaster[82406] LOG: background worker "logical replication apply worker" (PID 82483) exited with exit code 1 2026-05-06 14:58:28.153 UTC client backend[82567] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:28.154 UTC client backend[82567] [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:58:28.154 UTC client backend[82567] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:28.155 UTC client backend[82567] 035_conflicts.pl LOG: connection ready: setup total=3.643 ms, fork=0.791 ms, authentication=0.287 ms 2026-05-06 14:58:28.156 UTC client backend[82567] 035_conflicts.pl LOG: statement: SELECT oid FROM pg_subscription WHERE subname = 'sub_tab'; 2026-05-06 14:58:28.160 UTC client backend[82567] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.007 user=postgres database=postgres host=[local] 2026-05-06 14:58:28.175 UTC client backend[82573] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:28.175 UTC client backend[82573] [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:58:28.176 UTC client backend[82573] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:28.177 UTC client backend[82573] 035_conflicts.pl LOG: connection ready: setup total=3.440 ms, fork=0.780 ms, authentication=0.276 ms 2026-05-06 14:58:28.178 UTC client backend[82573] 035_conflicts.pl LOG: statement: SELECT count(*) > 0 FROM pg_conflict.pg_conflict_log_16410; 2026-05-06 14:58:28.181 UTC client backend[82573] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.006 user=postgres database=postgres host=[local] 2026-05-06 14:58:28.192 UTC client backend[82578] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:28.193 UTC client backend[82578] [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:58:28.193 UTC client backend[82578] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:28.194 UTC client backend[82578] 035_conflicts.pl LOG: connection ready: setup total=3.398 ms, fork=0.684 ms, authentication=0.278 ms 2026-05-06 14:58:28.194 UTC client backend[82578] 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:58:28.200 UTC client backend[82578] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.008 user=postgres database=postgres host=[local] 2026-05-06 14:58:28.212 UTC client backend[82583] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:28.213 UTC client backend[82583] [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:58:28.213 UTC client backend[82583] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:28.214 UTC client backend[82583] 035_conflicts.pl LOG: connection ready: setup total=3.510 ms, fork=0.801 ms, authentication=0.390 ms 2026-05-06 14:58:28.215 UTC client backend[82583] 035_conflicts.pl LOG: statement: SELECT local_conflicts FROM pg_conflict.pg_conflict_log_16410; 2026-05-06 14:58:28.217 UTC client backend[82583] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2026-05-06 14:58:28.229 UTC client backend[82585] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:28.230 UTC client backend[82585] [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:58:28.230 UTC client backend[82585] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:28.231 UTC client backend[82585] 035_conflicts.pl LOG: connection ready: setup total=3.872 ms, fork=0.864 ms, authentication=0.310 ms 2026-05-06 14:58:28.233 UTC client backend[82585] 035_conflicts.pl LOG: statement: TRUNCATE conf_tab; 2026-05-06 14:58:28.235 UTC client backend[82585] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.007 user=postgres database=postgres host=[local] 2026-05-06 14:58:28.247 UTC client backend[82588] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:28.248 UTC client backend[82588] [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:58:28.248 UTC client backend[82588] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:28.250 UTC client backend[82588] 035_conflicts.pl LOG: connection ready: setup total=3.745 ms, fork=0.792 ms, authentication=0.345 ms 2026-05-06 14:58:28.250 UTC client backend[82588] 035_conflicts.pl LOG: statement: DELETE FROM pg_conflict.pg_conflict_log_16410 2026-05-06 14:58:28.251 UTC client backend[82588] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2026-05-06 14:58:28.281 UTC client backend[82594] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:28.282 UTC client backend[82594] [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:58:28.282 UTC client backend[82594] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:28.283 UTC client backend[82594] 035_conflicts.pl LOG: connection ready: setup total=3.470 ms, fork=0.728 ms, authentication=0.265 ms 2026-05-06 14:58:28.283 UTC client backend[82594] 035_conflicts.pl LOG: statement: INSERT INTO conf_tab VALUES (6,6,6), (7,7,7), (8,8,8); 2026-05-06 14:58:28.287 UTC client backend[82594] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.007 user=postgres database=postgres host=[local] 2026-05-06 14:58:28.375 UTC logical replication apply worker[82605] LOG: logical replication apply worker for subscription "sub_tab" has started 2026-05-06 14:58:28.383 UTC logical replication apply worker[82605] ERROR: conflict detected on relation "public.conf_tab": conflict=multiple_unique_conflicts 2026-05-06 14:58:28.383 UTC logical replication apply worker[82605] 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 713: key (a)=(6), local row (6, 6, 6). Key already exists in unique index "conf_tab_b_key", modified in transaction 713: key (b)=(7), local row (7, 7, 7). Key already exists in unique index "conf_tab_c_key", modified in transaction 713: key (c)=(8), local row (8, 8, 8). 2026-05-06 14:58:28.383 UTC logical replication apply worker[82605] 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/017F4FA8 2026-05-06 14:58:28.385 UTC postmaster[82406] LOG: background worker "logical replication apply worker" (PID 82605) exited with exit code 1 2026-05-06 14:58:28.425 UTC client backend[82614] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:28.426 UTC client backend[82614] [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:58:28.426 UTC client backend[82614] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:28.427 UTC client backend[82614] 035_conflicts.pl LOG: connection ready: setup total=3.306 ms, fork=0.674 ms, authentication=0.269 ms 2026-05-06 14:58:28.427 UTC client backend[82614] 035_conflicts.pl LOG: statement: SELECT count(*) > 0 FROM pg_conflict.pg_conflict_log_16410; 2026-05-06 14:58:28.429 UTC client backend[82614] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2026-05-06 14:58:28.442 UTC client backend[82617] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:28.443 UTC client backend[82617] [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:58:28.443 UTC client backend[82617] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:28.444 UTC client backend[82617] 035_conflicts.pl LOG: connection ready: setup total=3.290 ms, fork=0.827 ms, authentication=0.245 ms 2026-05-06 14:58:28.444 UTC client backend[82617] 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:58:28.446 UTC client backend[82617] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2026-05-06 14:58:28.458 UTC client backend[82620] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:28.459 UTC client backend[82620] [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:58:28.459 UTC client backend[82620] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:28.460 UTC client backend[82620] 035_conflicts.pl LOG: connection ready: setup total=3.379 ms, fork=0.722 ms, authentication=0.273 ms 2026-05-06 14:58:28.460 UTC client backend[82620] 035_conflicts.pl LOG: statement: SELECT local_conflicts FROM pg_conflict.pg_conflict_log_16410; 2026-05-06 14:58:28.461 UTC client backend[82620] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.003 user=postgres database=postgres host=[local] 2026-05-06 14:58:28.474 UTC client backend[82623] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:28.475 UTC client backend[82623] [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:58:28.475 UTC client backend[82623] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:28.476 UTC client backend[82623] 035_conflicts.pl LOG: connection ready: setup total=3.375 ms, fork=0.709 ms, authentication=0.273 ms 2026-05-06 14:58:28.476 UTC client backend[82623] 035_conflicts.pl LOG: statement: TRUNCATE conf_tab; 2026-05-06 14:58:28.479 UTC client backend[82623] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.005 user=postgres database=postgres host=[local] 2026-05-06 14:58:28.493 UTC client backend[82628] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:28.494 UTC client backend[82628] [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:58:28.494 UTC client backend[82628] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:28.495 UTC client backend[82628] 035_conflicts.pl LOG: connection ready: setup total=3.430 ms, fork=0.764 ms, authentication=0.280 ms 2026-05-06 14:58:28.496 UTC client backend[82628] 035_conflicts.pl LOG: statement: INSERT INTO conf_tab_2 VALUES (55,2,3); 2026-05-06 14:58:28.497 UTC client backend[82628] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2026-05-06 14:58:28.875 UTC logical replication apply worker[82670] LOG: logical replication apply worker for subscription "sub_tab" has started 2026-05-06 14:58:28.883 UTC logical replication apply worker[82670] LOG: conflict detected on relation "public.conf_tab": conflict=update_missing 2026-05-06 14:58:28.883 UTC logical replication apply worker[82670] DETAIL: Could not find the row to be updated: remote row (6, 7, 8), replica identity (a)=(5). 2026-05-06 14:58:28.883 UTC logical replication apply worker[82670] 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/017F4FA8 2026-05-06 14:58:28.884 UTC logical replication apply worker[82670] ERROR: conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts 2026-05-06 14:58:28.884 UTC logical replication apply worker[82670] 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:58:28.884 UTC logical replication apply worker[82670] 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/017F5200 2026-05-06 14:58:28.888 UTC postmaster[82406] LOG: background worker "logical replication apply worker" (PID 82670) exited with exit code 1 2026-05-06 14:58:29.138 UTC postmaster[82406] LOG: received fast shutdown request 2026-05-06 14:58:29.138 UTC postmaster[82406] LOG: aborting any active transactions 2026-05-06 14:58:29.142 UTC postmaster[82406] LOG: background worker "logical replication launcher" (PID 82416) exited with exit code 1 2026-05-06 14:58:29.149 UTC checkpointer[82410] LOG: shutting down 2026-05-06 14:58:29.149 UTC checkpointer[82410] LOG: checkpoint starting: shutdown fast 2026-05-06 14:58:29.150 UTC checkpointer[82410] LOG: checkpoint complete: shutdown fast: wrote 23 buffers (18.0%), 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/01801830, redo lsn=0/01801830 2026-05-06 14:58:29.154 UTC postmaster[82406] LOG: database system is shut down 2026-05-06 14:58:29.264 UTC postmaster[82713] LOG: starting PostgreSQL 19devel on x86_64-linux, compiled by gcc-14.2.0, 64-bit 2026-05-06 14:58:29.264 UTC postmaster[82713] LOG: listening on Unix socket "/tmp/chagwFPDmx/.s.PGSQL.31475" 2026-05-06 14:58:29.270 UTC startup[82719] LOG: database system was shut down at 2026-05-06 14:58:29 UTC 2026-05-06 14:58:29.271 UTC startup[82719] LOG: recovered replication state of node 1 to 0/017F4FD8 2026-05-06 14:58:29.276 UTC postmaster[82713] LOG: database system is ready to accept connections 2026-05-06 14:58:29.295 UTC logical replication apply worker[82726] LOG: logical replication apply worker for subscription "sub_tab" has started 2026-05-06 14:58:29.354 UTC logical replication apply worker[82726] ERROR: conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts 2026-05-06 14:58:29.354 UTC logical replication apply worker[82726] 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:58:29.354 UTC logical replication apply worker[82726] 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/017F5200 2026-05-06 14:58:29.361 UTC postmaster[82713] LOG: background worker "logical replication apply worker" (PID 82726) exited with exit code 1 2026-05-06 14:58:29.382 UTC client backend[82749] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:29.383 UTC client backend[82749] [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:58:29.383 UTC client backend[82749] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:29.384 UTC client backend[82749] 035_conflicts.pl LOG: connection ready: setup total=3.514 ms, fork=0.798 ms, authentication=0.283 ms 2026-05-06 14:58:29.384 UTC client backend[82749] 035_conflicts.pl LOG: statement: CREATE TABLE tab (a int PRIMARY KEY, b int) 2026-05-06 14:58:29.389 UTC client backend[82749] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.007 user=postgres database=postgres host=[local] 2026-05-06 14:58:29.418 UTC client backend[82758] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:29.419 UTC client backend[82758] [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:58:29.419 UTC client backend[82758] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:29.421 UTC client backend[82758] 035_conflicts.pl LOG: connection ready: setup total=3.511 ms, fork=0.742 ms, authentication=0.301 ms 2026-05-06 14:58:29.421 UTC client backend[82758] 035_conflicts.pl LOG: statement: CREATE SUBSCRIPTION tap_sub_b_a CONNECTION 'port=31474 host=/tmp/chagwFPDmx dbname=postgres application_name=tap_sub_b_a' PUBLICATION tap_pub_A WITH (origin = none, retain_dead_tuples = true) 2026-05-06 14:58:29.440 UTC logical replication launcher[82722] LOG: creating replication conflict detection slot 2026-05-06 14:58:29.442 UTC client backend[82758] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.024 user=postgres database=postgres host=[local] 2026-05-06 14:58:29.445 UTC logical replication apply worker[82764] LOG: logical replication apply worker for subscription "tap_sub_b_a" has started 2026-05-06 14:58:29.452 UTC client backend[82768] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:29.453 UTC client backend[82768] [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:58:29.453 UTC client backend[82768] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:29.454 UTC client backend[82768] 035_conflicts.pl LOG: connection ready: setup total=3.394 ms, fork=0.749 ms, authentication=0.259 ms 2026-05-06 14:58:29.455 UTC client backend[82768] 035_conflicts.pl LOG: statement: CREATE PUBLICATION tap_pub_B FOR TABLE tab 2026-05-06 14:58:29.457 UTC client backend[82768] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2026-05-06 14:58:29.482 UTC client backend[82779] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:29.483 UTC walsender[82779] [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:58:29.483 UTC walsender[82779] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 14:58:29.484 UTC walsender[82779] tap_sub_a_b LOG: connection ready: setup total=3.096 ms, fork=0.586 ms, authentication=0.226 ms 2026-05-06 14:58:29.484 UTC walsender[82779] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 14:58:29.485 UTC logical replication tablesync worker[82778] LOG: logical replication table synchronization worker for subscription "tap_sub_b_a", table "tab" has started 2026-05-06 14:58:29.485 UTC walsender[82779] 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:58:29.486 UTC walsender[82779] 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:58:29.494 UTC walsender[82779] tap_sub_a_b LOG: received replication command: CREATE_REPLICATION_SLOT "tap_sub_a_b" LOGICAL pgoutput (SNAPSHOT 'nothing') 2026-05-06 14:58:29.494 UTC walsender[82779] tap_sub_a_b STATEMENT: CREATE_REPLICATION_SLOT "tap_sub_a_b" LOGICAL pgoutput (SNAPSHOT 'nothing') 2026-05-06 14:58:29.494 UTC walsender[82779] tap_sub_a_b LOG: logical decoding found consistent point at 0/01826F50 2026-05-06 14:58:29.494 UTC walsender[82779] tap_sub_a_b DETAIL: There are no running transactions. 2026-05-06 14:58:29.494 UTC walsender[82779] tap_sub_a_b STATEMENT: CREATE_REPLICATION_SLOT "tap_sub_a_b" LOGICAL pgoutput (SNAPSHOT 'nothing') 2026-05-06 14:58:29.494 UTC walsender[82779] tap_sub_a_b LOG: released logical replication slot "tap_sub_a_b" 2026-05-06 14:58:29.494 UTC walsender[82779] tap_sub_a_b STATEMENT: CREATE_REPLICATION_SLOT "tap_sub_a_b" LOGICAL pgoutput (SNAPSHOT 'nothing') 2026-05-06 14:58:29.495 UTC walsender[82779] tap_sub_a_b LOG: disconnection: session time: 0:00:00.013 user=postgres database=postgres host=[local] 2026-05-06 14:58:29.513 UTC client backend[82787] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:29.517 UTC walsender[82787] [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:58:29.517 UTC walsender[82787] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 14:58:29.519 UTC walsender[82787] tap_sub_a_b LOG: connection ready: setup total=9.256 ms, fork=0.762 ms, authentication=3.111 ms 2026-05-06 14:58:29.519 UTC walsender[82787] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 14:58:29.524 UTC walsender[82787] tap_sub_a_b LOG: received replication command: IDENTIFY_SYSTEM 2026-05-06 14:58:29.524 UTC walsender[82787] tap_sub_a_b STATEMENT: IDENTIFY_SYSTEM 2026-05-06 14:58:29.524 UTC walsender[82787] 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:58:29.524 UTC walsender[82787] 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:58:29.524 UTC walsender[82787] tap_sub_a_b LOG: acquired logical replication slot "tap_sub_a_b" 2026-05-06 14:58:29.524 UTC walsender[82787] 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:58:29.525 UTC walsender[82787] tap_sub_a_b LOG: starting logical decoding for slot "tap_sub_a_b" 2026-05-06 14:58:29.525 UTC walsender[82787] tap_sub_a_b DETAIL: Streaming transactions committing after 0/01826F88, reading WAL from 0/01826F50. 2026-05-06 14:58:29.525 UTC walsender[82787] 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:58:29.525 UTC walsender[82787] tap_sub_a_b LOG: logical decoding found consistent point at 0/01826F50 2026-05-06 14:58:29.525 UTC walsender[82787] tap_sub_a_b DETAIL: There are no running transactions. 2026-05-06 14:58:29.525 UTC walsender[82787] 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:58:29.528 UTC logical replication tablesync worker[82778] LOG: logical replication table synchronization worker for subscription "tap_sub_b_a", table "tab" has finished 2026-05-06 14:58:29.539 UTC client backend[82796] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:29.540 UTC client backend[82796] [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:58:29.540 UTC client backend[82796] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:29.542 UTC client backend[82796] 035_conflicts.pl LOG: connection ready: setup total=3.691 ms, fork=0.719 ms, authentication=0.230 ms 2026-05-06 14:58:29.542 UTC client backend[82796] 035_conflicts.pl LOG: statement: SELECT pg_is_in_recovery() 2026-05-06 14:58:29.545 UTC client backend[82796] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.006 user=postgres database=postgres host=[local] 2026-05-06 14:58:29.555 UTC client backend[82801] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:29.556 UTC client backend[82801] [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:58:29.556 UTC client backend[82801] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:29.557 UTC client backend[82801] 035_conflicts.pl LOG: connection ready: setup total=3.157 ms, fork=0.713 ms, authentication=0.260 ms 2026-05-06 14:58:29.557 UTC client backend[82801] 035_conflicts.pl LOG: statement: SELECT pg_current_wal_lsn() 2026-05-06 14:58:29.558 UTC client backend[82801] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.003 user=postgres database=postgres host=[local] 2026-05-06 14:58:29.569 UTC client backend[82806] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:29.570 UTC client backend[82806] [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:58:29.570 UTC client backend[82806] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:29.571 UTC client backend[82806] 035_conflicts.pl LOG: connection ready: setup total=3.364 ms, fork=0.828 ms, authentication=0.233 ms 2026-05-06 14:58:29.571 UTC client backend[82806] 035_conflicts.pl LOG: statement: SELECT '0/01826F88' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('tap_sub_a_b', 'walreceiver') 2026-05-06 14:58:29.576 UTC client backend[82806] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.007 user=postgres database=postgres host=[local] 2026-05-06 14:58:29.595 UTC client backend[82815] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:29.595 UTC client backend[82815] [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:58:29.595 UTC client backend[82815] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:29.597 UTC client backend[82815] 035_conflicts.pl LOG: connection ready: setup total=4.497 ms, fork=0.784 ms, authentication=0.267 ms 2026-05-06 14:58:29.601 UTC client backend[82815] 035_conflicts.pl LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2026-05-06 14:58:29.605 UTC client backend[82815] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.012 user=postgres database=postgres host=[local] 2026-05-06 14:58:29.672 UTC client backend[82839] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:29.673 UTC client backend[82839] [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:58:29.673 UTC client backend[82839] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:29.674 UTC client backend[82839] 035_conflicts.pl LOG: connection ready: setup total=3.220 ms, fork=0.750 ms, authentication=0.223 ms 2026-05-06 14:58:29.674 UTC client backend[82839] 035_conflicts.pl LOG: statement: SELECT xmin IS NOT NULL from pg_replication_slots WHERE slot_name = 'pg_conflict_detection' 2026-05-06 14:58:29.677 UTC client backend[82839] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.005 user=postgres database=postgres host=[local] 2026-05-06 14:58:29.719 UTC walsender[82787] tap_sub_a_b LOG: released logical replication slot "tap_sub_a_b" 2026-05-06 14:58:29.719 UTC walsender[82787] tap_sub_a_b LOG: disconnection: session time: 0:00:00.209 user=postgres database=postgres host=[local] 2026-05-06 14:58:29.757 UTC client backend[82870] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:29.758 UTC walsender[82870] [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:58:29.758 UTC walsender[82870] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 14:58:29.759 UTC walsender[82870] tap_sub_a_b LOG: connection ready: setup total=3.322 ms, fork=0.744 ms, authentication=0.250 ms 2026-05-06 14:58:29.759 UTC walsender[82870] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 14:58:29.761 UTC walsender[82870] tap_sub_a_b LOG: statement: SELECT pg_is_in_recovery() 2026-05-06 14:58:29.761 UTC walsender[82870] tap_sub_a_b LOG: disconnection: session time: 0:00:00.005 user=postgres database=postgres host=[local] 2026-05-06 14:58:29.783 UTC client backend[82881] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:29.783 UTC walsender[82881] [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:58:29.783 UTC walsender[82881] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 14:58:29.785 UTC walsender[82881] tap_sub_a_b LOG: connection ready: setup total=3.195 ms, fork=0.708 ms, authentication=0.222 ms 2026-05-06 14:58:29.785 UTC walsender[82881] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 14:58:29.785 UTC walsender[82881] tap_sub_a_b LOG: statement: SELECT pg_is_in_recovery() 2026-05-06 14:58:29.786 UTC walsender[82881] tap_sub_a_b LOG: disconnection: session time: 0:00:00.003 user=postgres database=postgres host=[local] 2026-05-06 14:58:29.787 UTC logical replication apply worker[82882] LOG: logical replication apply worker for subscription "sub_tab" has started 2026-05-06 14:58:29.794 UTC client backend[82886] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:29.795 UTC walsender[82886] [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:58:29.795 UTC walsender[82886] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 14:58:29.796 UTC walsender[82886] tap_sub_a_b LOG: connection ready: setup total=3.290 ms, fork=0.801 ms, authentication=0.219 ms 2026-05-06 14:58:29.796 UTC walsender[82886] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 14:58:29.797 UTC walsender[82886] tap_sub_a_b LOG: received replication command: IDENTIFY_SYSTEM 2026-05-06 14:58:29.797 UTC walsender[82886] tap_sub_a_b STATEMENT: IDENTIFY_SYSTEM 2026-05-06 14:58:29.797 UTC walsender[82886] 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:58:29.797 UTC walsender[82886] 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:58:29.797 UTC walsender[82886] tap_sub_a_b LOG: acquired logical replication slot "tap_sub_a_b" 2026-05-06 14:58:29.797 UTC walsender[82886] 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:58:29.797 UTC walsender[82886] tap_sub_a_b LOG: starting logical decoding for slot "tap_sub_a_b" 2026-05-06 14:58:29.797 UTC walsender[82886] tap_sub_a_b DETAIL: Streaming transactions committing after 0/01827788, reading WAL from 0/01826F50. 2026-05-06 14:58:29.797 UTC walsender[82886] 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:58:29.797 UTC walsender[82886] tap_sub_a_b LOG: logical decoding found consistent point at 0/01826F50 2026-05-06 14:58:29.797 UTC walsender[82886] tap_sub_a_b DETAIL: There are no running transactions. 2026-05-06 14:58:29.797 UTC walsender[82886] 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:58:29.798 UTC logical replication apply worker[82882] ERROR: conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts 2026-05-06 14:58:29.798 UTC logical replication apply worker[82882] 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:58:29.798 UTC logical replication apply worker[82882] 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/017F5200 2026-05-06 14:58:29.801 UTC postmaster[82713] LOG: background worker "logical replication apply worker" (PID 82882) exited with exit code 1 2026-05-06 14:58:29.821 UTC client backend[82892] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:29.822 UTC walsender[82892] [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:58:29.822 UTC walsender[82892] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 14:58:29.824 UTC walsender[82892] tap_sub_a_b LOG: connection ready: setup total=3.708 ms, fork=0.862 ms, authentication=0.280 ms 2026-05-06 14:58:29.824 UTC walsender[82892] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 14:58:29.824 UTC walsender[82892] tap_sub_a_b LOG: statement: SELECT pg_is_in_recovery() 2026-05-06 14:58:29.825 UTC walsender[82892] 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:58:29.832 UTC walsender[82892] tap_sub_a_b LOG: disconnection: session time: 0:00:00.010 user=postgres database=postgres host=[local] 2026-05-06 14:58:29.834 UTC walsender[82886] tap_sub_a_b LOG: released logical replication slot "tap_sub_a_b" 2026-05-06 14:58:29.834 UTC walsender[82886] tap_sub_a_b LOG: disconnection: session time: 0:00:00.041 user=postgres database=postgres host=[local] 2026-05-06 14:58:29.848 UTC client backend[82903] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:29.851 UTC walsender[82903] [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:58:29.852 UTC walsender[82903] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 14:58:29.853 UTC walsender[82903] tap_sub_a_b LOG: connection ready: setup total=7.233 ms, fork=2.207 ms, authentication=2.504 ms 2026-05-06 14:58:29.855 UTC walsender[82903] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 14:58:29.857 UTC walsender[82903] tap_sub_a_b LOG: received replication command: IDENTIFY_SYSTEM 2026-05-06 14:58:29.857 UTC walsender[82903] tap_sub_a_b STATEMENT: IDENTIFY_SYSTEM 2026-05-06 14:58:29.857 UTC walsender[82903] 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:58:29.857 UTC walsender[82903] 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:58:29.857 UTC walsender[82903] tap_sub_a_b LOG: acquired logical replication slot "tap_sub_a_b" 2026-05-06 14:58:29.857 UTC walsender[82903] 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:58:29.858 UTC walsender[82903] tap_sub_a_b LOG: starting logical decoding for slot "tap_sub_a_b" 2026-05-06 14:58:29.858 UTC walsender[82903] tap_sub_a_b DETAIL: Streaming transactions committing after 0/01827A60, reading WAL from 0/01826F50. 2026-05-06 14:58:29.858 UTC walsender[82903] 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:58:29.858 UTC walsender[82903] tap_sub_a_b LOG: logical decoding found consistent point at 0/01826F50 2026-05-06 14:58:29.858 UTC walsender[82903] tap_sub_a_b DETAIL: There are no running transactions. 2026-05-06 14:58:29.858 UTC walsender[82903] 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:58:29.858 UTC walsender[82903] tap_sub_a_b LOG: released logical replication slot "tap_sub_a_b" 2026-05-06 14:58:29.858 UTC walsender[82903] tap_sub_a_b LOG: disconnection: session time: 0:00:00.010 user=postgres database=postgres host=[local] 2026-05-06 14:58:29.865 UTC client backend[82911] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:29.866 UTC walsender[82911] [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:58:29.866 UTC walsender[82911] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 14:58:29.868 UTC walsender[82911] tap_sub_a_b LOG: connection ready: setup total=3.883 ms, fork=0.814 ms, authentication=0.299 ms 2026-05-06 14:58:29.868 UTC walsender[82911] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 14:58:29.869 UTC walsender[82911] tap_sub_a_b LOG: received replication command: IDENTIFY_SYSTEM 2026-05-06 14:58:29.869 UTC walsender[82911] tap_sub_a_b STATEMENT: IDENTIFY_SYSTEM 2026-05-06 14:58:29.869 UTC walsender[82911] 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:58:29.869 UTC walsender[82911] 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:58:29.869 UTC walsender[82911] tap_sub_a_b LOG: acquired logical replication slot "tap_sub_a_b" 2026-05-06 14:58:29.869 UTC walsender[82911] 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:58:29.869 UTC walsender[82911] tap_sub_a_b LOG: starting logical decoding for slot "tap_sub_a_b" 2026-05-06 14:58:29.869 UTC walsender[82911] tap_sub_a_b DETAIL: Streaming transactions committing after 0/01827A60, reading WAL from 0/01826F50. 2026-05-06 14:58:29.869 UTC walsender[82911] 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:58:29.869 UTC walsender[82911] tap_sub_a_b LOG: logical decoding found consistent point at 0/01826F50 2026-05-06 14:58:29.869 UTC walsender[82911] tap_sub_a_b DETAIL: There are no running transactions. 2026-05-06 14:58:29.869 UTC walsender[82911] 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:58:29.939 UTC client backend[82937] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:29.941 UTC client backend[82937] [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:58:29.941 UTC client backend[82937] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:29.942 UTC client backend[82937] 035_conflicts.pl LOG: connection ready: setup total=3.571 ms, fork=0.744 ms, authentication=0.330 ms 2026-05-06 14:58:29.942 UTC client backend[82937] 035_conflicts.pl LOG: statement: SELECT * FROM tab; 2026-05-06 14:58:29.944 UTC client backend[82937] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2026-05-06 14:58:29.960 UTC walsender[82911] tap_sub_a_b LOG: released logical replication slot "tap_sub_a_b" 2026-05-06 14:58:29.960 UTC walsender[82911] tap_sub_a_b LOG: disconnection: session time: 0:00:00.095 user=postgres database=postgres host=[local] 2026-05-06 14:58:29.994 UTC client backend[82955] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:29.995 UTC client backend[82955] [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:58:29.995 UTC client backend[82955] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:58:29.996 UTC client backend[82955] 035_conflicts.pl LOG: connection ready: setup total=3.144 ms, fork=0.724 ms, authentication=0.265 ms 2026-05-06 14:58:29.996 UTC client backend[82955] 035_conflicts.pl LOG: statement: UPDATE tab SET b = 3 WHERE a = 1; 2026-05-06 14:58:29.998 UTC client backend[82955] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] TRAP: failed Assert("conflictlogrel != NULL"), File: "../src/backend/replication/logical/conflict.c", Line: 195, PID: 82764 postgres: subscriber: logical replication apply worker for subscription 16428 (ExceptionalCondition+0x53) [0x55a310e5fed8] postgres: subscriber: logical replication apply worker for subscription 16428 (ReportApplyConflict+0x158) [0x55a310ab1637] postgres: subscriber: logical replication apply worker for subscription 16428 (+0xfffe79) [0x55a310af0e79] postgres: subscriber: logical replication apply worker for subscription 16428 (+0x10048d9) [0x55a310af58d9] postgres: subscriber: logical replication apply worker for subscription 16428 (apply_dispatch+0x73) [0x55a310af78ec] postgres: subscriber: logical replication apply worker for subscription 16428 (+0x100736c) [0x55a310af836c] postgres: subscriber: logical replication apply worker for subscription 16428 (start_apply+0x57) [0x55a310af98b9] postgres: subscriber: logical replication apply worker for subscription 16428 (+0x100934b) [0x55a310afa34b] postgres: subscriber: logical replication apply worker for subscription 16428 (ApplyWorkerMain+0x18) [0x55a310afa376] postgres: subscriber: logical replication apply worker for subscription 16428 (BackgroundWorkerMain+0x330) [0x55a310a50927] postgres: subscriber: logical replication apply worker for subscription 16428 (postmaster_child_launch+0x1d4) [0x55a310a58e72] postgres: subscriber: logical replication apply worker for subscription 16428 (+0xf6ba6b) [0x55a310a5ca6b] postgres: subscriber: logical replication apply worker for subscription 16428 (+0xf6bef6) [0x55a310a5cef6] postgres: subscriber: logical replication apply worker for subscription 16428 (+0xf6d934) [0x55a310a5e934] postgres: subscriber: logical replication apply worker for subscription 16428 (+0xf6f6c8) [0x55a310a606c8] postgres: subscriber: logical replication apply worker for subscription 16428 (PostmasterMain+0x147c) [0x55a310a61fa1] postgres: subscriber: logical replication apply worker for subscription 16428 (main+0x293) [0x55a3108760bd] /lib/x86_64-linux-gnu/libc.so.6(+0x29ca8) [0x7f8813a35ca8] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85) [0x7f8813a35d65] postgres: subscriber: logical replication apply worker for subscription 16428 (_start+0x21) [0x55a3103e3321] 2026-05-06 14:58:30.034 UTC postmaster[82713] LOG: background worker "logical replication apply worker" (PID 82764) was terminated by signal 6: Aborted 2026-05-06 14:58:30.034 UTC postmaster[82713] LOG: terminating any other active server processes 2026-05-06 14:58:30.036 UTC postmaster[82713] LOG: shutting down because "restart_after_crash" is off 2026-05-06 14:58:30.038 UTC postmaster[82713] LOG: database system is shut down