2026-05-06 14:54:16.148 UTC postmaster[272] LOG: starting PostgreSQL 19devel on x86_64-netbsd, compiled by gcc-10.5.0, 64-bit 2026-05-06 14:54:16.148 UTC postmaster[272] LOG: listening on Unix socket "/tmp/JOZDN4LKnp/.s.PGSQL.20613" 2026-05-06 14:54:16.152 UTC startup[8620] LOG: database system was shut down at 2026-05-06 14:50:16 UTC 2026-05-06 14:54:16.156 UTC postmaster[272] LOG: database system is ready to accept connections 2026-05-06 14:54:16.284 UTC client backend[25001] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:16.286 UTC client backend[25001] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:16.286 UTC client backend[25001] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:16.293 UTC client backend[25001] 035_conflicts.pl LOG: connection ready: setup total=9.716 ms, fork=0.466 ms, authentication=0.411 ms 2026-05-06 14:54:16.294 UTC client backend[25001] 035_conflicts.pl LOG: statement: CREATE TABLE conf_tab (a int PRIMARY key, b int UNIQUE, c int UNIQUE); 2026-05-06 14:54:16.298 UTC client backend[25001] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.014 user=postgres database=postgres host=[local] 2026-05-06 14:54:16.309 UTC client backend[4360] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:16.310 UTC client backend[4360] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:16.310 UTC client backend[4360] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:16.312 UTC client backend[4360] 035_conflicts.pl LOG: connection ready: setup total=3.811 ms, fork=0.553 ms, authentication=0.384 ms 2026-05-06 14:54:16.312 UTC client backend[4360] 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:54:16.315 UTC client backend[4360] 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:54:16.318 UTC client backend[4360] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.009 user=postgres database=postgres host=[local] 2026-05-06 14:54:16.352 UTC client backend[5001] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:16.353 UTC client backend[5001] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:16.353 UTC client backend[5001] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:16.355 UTC client backend[5001] 035_conflicts.pl LOG: connection ready: setup total=3.544 ms, fork=0.475 ms, authentication=0.354 ms 2026-05-06 14:54:16.355 UTC client backend[5001] 035_conflicts.pl LOG: statement: CREATE SUBSCRIPTION sub_tab CONNECTION 'port=20612 host=/tmp/JOZDN4LKnp dbname=postgres application_name=sub_tab' PUBLICATION pub_tab WITH (conflict_log_destination=all) 2026-05-06 14:54:16.376 UTC client backend[5001] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.024 user=postgres database=postgres host=[local] 2026-05-06 14:54:16.382 UTC logical replication apply worker[21876] LOG: logical replication apply worker for subscription "sub_tab" has started 2026-05-06 14:54:16.387 UTC client backend[24877] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:16.389 UTC client backend[24877] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:16.389 UTC client backend[24877] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:16.391 UTC client backend[24877] 035_conflicts.pl LOG: connection ready: setup total=4.236 ms, fork=0.632 ms, authentication=0.298 ms 2026-05-06 14:54:16.391 UTC client backend[24877] 035_conflicts.pl LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2026-05-06 14:54:16.393 UTC client backend[24877] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.006 user=postgres database=postgres host=[local] 2026-05-06 14:54:16.395 UTC logical replication tablesync worker[19811] LOG: logical replication table synchronization worker for subscription "sub_tab", table "conf_tab" has started 2026-05-06 14:54:16.407 UTC logical replication tablesync worker[19811] LOG: logical replication table synchronization worker for subscription "sub_tab", table "conf_tab" has finished 2026-05-06 14:54:16.411 UTC logical replication tablesync worker[16522] LOG: logical replication table synchronization worker for subscription "sub_tab", table "conf_tab_2" has started 2026-05-06 14:54:16.426 UTC logical replication tablesync worker[16522] LOG: logical replication table synchronization worker for subscription "sub_tab", table "conf_tab_2" has finished 2026-05-06 14:54:16.509 UTC client backend[19595] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:16.510 UTC client backend[19595] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:16.510 UTC client backend[19595] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:16.514 UTC client backend[19595] 035_conflicts.pl LOG: connection ready: setup total=6.248 ms, fork=0.633 ms, authentication=0.274 ms 2026-05-06 14:54:16.515 UTC client backend[19595] 035_conflicts.pl LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2026-05-06 14:54:16.517 UTC client backend[19595] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.008 user=postgres database=postgres host=[local] 2026-05-06 14:54:16.592 UTC client backend[21312] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:16.593 UTC client backend[21312] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:16.593 UTC client backend[21312] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:16.595 UTC client backend[21312] 035_conflicts.pl LOG: connection ready: setup total=4.339 ms, fork=0.540 ms, authentication=0.463 ms 2026-05-06 14:54:16.596 UTC client backend[21312] 035_conflicts.pl LOG: statement: INSERT INTO conf_tab VALUES (2,2,2), (3,3,3), (4,4,4); 2026-05-06 14:54:16.597 UTC client backend[21312] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.005 user=postgres database=postgres host=[local] 2026-05-06 14:54:16.616 UTC logical replication apply worker[21876] ERROR: conflict detected on relation "public.conf_tab": conflict=multiple_unique_conflicts 2026-05-06 14:54:16.616 UTC logical replication apply worker[21876] 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:54:16.616 UTC logical replication apply worker[21876] 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/017DAD08 2026-05-06 14:54:16.618 UTC postmaster[272] LOG: background worker "logical replication apply worker" (PID 21876) exited with exit code 1 2026-05-06 14:54:16.629 UTC client backend[236] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:16.630 UTC client backend[236] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:16.630 UTC client backend[236] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:16.632 UTC client backend[236] 035_conflicts.pl LOG: connection ready: setup total=4.217 ms, fork=0.717 ms, authentication=0.308 ms 2026-05-06 14:54:16.633 UTC client backend[236] 035_conflicts.pl LOG: statement: SELECT oid FROM pg_subscription WHERE subname = 'sub_tab'; 2026-05-06 14:54:16.634 UTC client backend[236] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.005 user=postgres database=postgres host=[local] 2026-05-06 14:54:16.649 UTC client backend[25589] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:16.650 UTC client backend[25589] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:16.650 UTC client backend[25589] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:16.651 UTC client backend[25589] 035_conflicts.pl LOG: connection ready: setup total=3.484 ms, fork=0.524 ms, authentication=0.352 ms 2026-05-06 14:54:16.651 UTC client backend[25589] 035_conflicts.pl LOG: statement: SELECT count(*) > 0 FROM pg_conflict.pg_conflict_log_16410; 2026-05-06 14:54:16.653 UTC client backend[25589] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2026-05-06 14:54:16.664 UTC client backend[15961] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:16.666 UTC client backend[15961] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:16.666 UTC client backend[15961] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:16.667 UTC client backend[15961] 035_conflicts.pl LOG: connection ready: setup total=3.941 ms, fork=0.519 ms, authentication=0.276 ms 2026-05-06 14:54:16.667 UTC client backend[15961] 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:54:16.669 UTC client backend[15961] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.005 user=postgres database=postgres host=[local] 2026-05-06 14:54:16.681 UTC client backend[18076] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:16.682 UTC client backend[18076] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:16.682 UTC client backend[18076] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:16.683 UTC client backend[18076] 035_conflicts.pl LOG: connection ready: setup total=3.380 ms, fork=0.539 ms, authentication=0.244 ms 2026-05-06 14:54:16.684 UTC client backend[18076] 035_conflicts.pl LOG: statement: SELECT local_conflicts FROM pg_conflict.pg_conflict_log_16410; 2026-05-06 14:54:16.685 UTC client backend[18076] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2026-05-06 14:54:16.699 UTC client backend[18720] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:16.700 UTC client backend[18720] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:16.700 UTC client backend[18720] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:16.701 UTC client backend[18720] 035_conflicts.pl LOG: connection ready: setup total=4.099 ms, fork=0.580 ms, authentication=0.250 ms 2026-05-06 14:54:16.702 UTC client backend[18720] 035_conflicts.pl LOG: statement: TRUNCATE conf_tab; 2026-05-06 14:54:16.705 UTC client backend[18720] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.006 user=postgres database=postgres host=[local] 2026-05-06 14:54:16.716 UTC client backend[1483] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:16.717 UTC client backend[1483] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:16.717 UTC client backend[1483] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:16.718 UTC client backend[1483] 035_conflicts.pl LOG: connection ready: setup total=3.435 ms, fork=0.554 ms, authentication=0.251 ms 2026-05-06 14:54:16.719 UTC client backend[1483] 035_conflicts.pl LOG: statement: DELETE FROM pg_conflict.pg_conflict_log_16410 2026-05-06 14:54:16.720 UTC client backend[1483] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2026-05-06 14:54:16.754 UTC client backend[11352] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:16.755 UTC client backend[11352] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:16.755 UTC client backend[11352] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:16.756 UTC client backend[11352] 035_conflicts.pl LOG: connection ready: setup total=3.344 ms, fork=0.520 ms, authentication=0.270 ms 2026-05-06 14:54:16.756 UTC client backend[11352] 035_conflicts.pl LOG: statement: INSERT INTO conf_tab VALUES (6,6,6), (7,7,7), (8,8,8); 2026-05-06 14:54:16.758 UTC client backend[11352] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2026-05-06 14:54:16.888 UTC logical replication apply worker[6419] LOG: logical replication apply worker for subscription "sub_tab" has started 2026-05-06 14:54:16.898 UTC logical replication apply worker[6419] ERROR: conflict detected on relation "public.conf_tab": conflict=multiple_unique_conflicts 2026-05-06 14:54:16.898 UTC logical replication apply worker[6419] 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:54:16.898 UTC logical replication apply worker[6419] 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/017DAF88 2026-05-06 14:54:16.900 UTC postmaster[272] LOG: background worker "logical replication apply worker" (PID 6419) exited with exit code 1 2026-05-06 14:54:17.004 UTC client backend[2936] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:17.006 UTC client backend[2936] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:17.006 UTC client backend[2936] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:17.007 UTC client backend[2936] 035_conflicts.pl LOG: connection ready: setup total=3.540 ms, fork=0.526 ms, authentication=0.357 ms 2026-05-06 14:54:17.008 UTC client backend[2936] 035_conflicts.pl LOG: statement: SELECT count(*) > 0 FROM pg_conflict.pg_conflict_log_16410; 2026-05-06 14:54:17.009 UTC client backend[2936] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2026-05-06 14:54:17.020 UTC client backend[17480] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:17.021 UTC client backend[17480] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:17.021 UTC client backend[17480] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:17.023 UTC client backend[17480] 035_conflicts.pl LOG: connection ready: setup total=3.925 ms, fork=0.975 ms, authentication=0.273 ms 2026-05-06 14:54:17.023 UTC client backend[17480] 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:54:17.026 UTC client backend[17480] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.006 user=postgres database=postgres host=[local] 2026-05-06 14:54:17.039 UTC client backend[14077] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:17.041 UTC client backend[14077] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:17.041 UTC client backend[14077] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:17.042 UTC client backend[14077] 035_conflicts.pl LOG: connection ready: setup total=3.431 ms, fork=0.442 ms, authentication=0.253 ms 2026-05-06 14:54:17.042 UTC client backend[14077] 035_conflicts.pl LOG: statement: SELECT local_conflicts FROM pg_conflict.pg_conflict_log_16410; 2026-05-06 14:54:17.044 UTC client backend[14077] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2026-05-06 14:54:17.057 UTC client backend[20772] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:17.058 UTC client backend[20772] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:17.058 UTC client backend[20772] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:17.060 UTC client backend[20772] 035_conflicts.pl LOG: connection ready: setup total=3.715 ms, fork=0.523 ms, authentication=0.299 ms 2026-05-06 14:54:17.060 UTC client backend[20772] 035_conflicts.pl LOG: statement: TRUNCATE conf_tab; 2026-05-06 14:54:17.063 UTC client backend[20772] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.006 user=postgres database=postgres host=[local] 2026-05-06 14:54:17.075 UTC client backend[13971] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:17.076 UTC client backend[13971] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:17.076 UTC client backend[13971] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:17.077 UTC client backend[13971] 035_conflicts.pl LOG: connection ready: setup total=3.201 ms, fork=0.446 ms, authentication=0.275 ms 2026-05-06 14:54:17.077 UTC client backend[13971] 035_conflicts.pl LOG: statement: INSERT INTO conf_tab_2 VALUES (55,2,3); 2026-05-06 14:54:17.079 UTC client backend[13971] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2026-05-06 14:54:17.401 UTC logical replication apply worker[23316] LOG: logical replication apply worker for subscription "sub_tab" has started 2026-05-06 14:54:17.409 UTC logical replication apply worker[23316] LOG: conflict detected on relation "public.conf_tab": conflict=update_missing 2026-05-06 14:54:17.409 UTC logical replication apply worker[23316] DETAIL: Could not find the row to be updated: remote row (6, 7, 8), replica identity (a)=(5). 2026-05-06 14:54:17.409 UTC logical replication apply worker[23316] 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/017DAF88 2026-05-06 14:54:17.410 UTC logical replication apply worker[23316] ERROR: conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts 2026-05-06 14:54:17.410 UTC logical replication apply worker[23316] 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:54:17.410 UTC logical replication apply worker[23316] 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/017DB1E0 2026-05-06 14:54:17.413 UTC postmaster[272] LOG: background worker "logical replication apply worker" (PID 23316) exited with exit code 1 2026-05-06 14:54:17.645 UTC postmaster[272] LOG: received fast shutdown request 2026-05-06 14:54:17.645 UTC postmaster[272] LOG: aborting any active transactions 2026-05-06 14:54:17.648 UTC postmaster[272] LOG: background worker "logical replication launcher" (PID 24277) exited with exit code 1 2026-05-06 14:54:17.650 UTC checkpointer[7107] LOG: shutting down 2026-05-06 14:54:17.650 UTC checkpointer[7107] LOG: checkpoint starting: shutdown fast 2026-05-06 14:54:17.651 UTC checkpointer[7107] 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/017E7810, redo lsn=0/017E7810 2026-05-06 14:54:17.656 UTC postmaster[272] LOG: database system is shut down 2026-05-06 14:54:17.782 UTC postmaster[4750] LOG: starting PostgreSQL 19devel on x86_64-netbsd, compiled by gcc-10.5.0, 64-bit 2026-05-06 14:54:17.782 UTC postmaster[4750] LOG: listening on Unix socket "/tmp/JOZDN4LKnp/.s.PGSQL.20613" 2026-05-06 14:54:17.786 UTC startup[7039] LOG: database system was shut down at 2026-05-06 14:54:17 UTC 2026-05-06 14:54:17.787 UTC startup[7039] LOG: recovered replication state of node 1 to 0/017DAFB8 2026-05-06 14:54:17.795 UTC postmaster[4750] LOG: database system is ready to accept connections 2026-05-06 14:54:17.814 UTC logical replication apply worker[674] LOG: logical replication apply worker for subscription "sub_tab" has started 2026-05-06 14:54:17.861 UTC logical replication apply worker[674] ERROR: conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts 2026-05-06 14:54:17.861 UTC logical replication apply worker[674] 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:54:17.861 UTC logical replication apply worker[674] 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/017DB1E0 2026-05-06 14:54:17.867 UTC postmaster[4750] LOG: background worker "logical replication apply worker" (PID 674) exited with exit code 1 2026-05-06 14:54:17.896 UTC client backend[17443] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:17.897 UTC client backend[17443] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:17.897 UTC client backend[17443] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:17.899 UTC client backend[17443] 035_conflicts.pl LOG: connection ready: setup total=3.328 ms, fork=0.469 ms, authentication=0.341 ms 2026-05-06 14:54:17.899 UTC client backend[17443] 035_conflicts.pl LOG: statement: CREATE TABLE tab (a int PRIMARY KEY, b int) 2026-05-06 14:54:17.902 UTC client backend[17443] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.005 user=postgres database=postgres host=[local] 2026-05-06 14:54:17.934 UTC client backend[15233] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:17.936 UTC client backend[15233] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:17.936 UTC client backend[15233] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:17.938 UTC client backend[15233] 035_conflicts.pl LOG: connection ready: setup total=4.392 ms, fork=0.606 ms, authentication=0.433 ms 2026-05-06 14:54:17.938 UTC client backend[15233] 035_conflicts.pl LOG: statement: CREATE SUBSCRIPTION tap_sub_b_a CONNECTION 'port=20612 host=/tmp/JOZDN4LKnp dbname=postgres application_name=tap_sub_b_a' PUBLICATION tap_pub_A WITH (origin = none, retain_dead_tuples = true) 2026-05-06 14:54:17.958 UTC client backend[15233] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.024 user=postgres database=postgres host=[local] 2026-05-06 14:54:17.965 UTC logical replication launcher[13211] LOG: creating replication conflict detection slot 2026-05-06 14:54:17.973 UTC client backend[13625] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:17.974 UTC logical replication apply worker[27122] LOG: logical replication apply worker for subscription "tap_sub_b_a" has started 2026-05-06 14:54:17.974 UTC client backend[13625] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:17.974 UTC client backend[13625] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:17.976 UTC client backend[13625] 035_conflicts.pl LOG: connection ready: setup total=3.977 ms, fork=0.529 ms, authentication=0.334 ms 2026-05-06 14:54:17.976 UTC client backend[13625] 035_conflicts.pl LOG: statement: CREATE PUBLICATION tap_pub_B FOR TABLE tab 2026-05-06 14:54:17.978 UTC client backend[13625] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.005 user=postgres database=postgres host=[local] 2026-05-06 14:54:18.002 UTC logical replication tablesync worker[9472] LOG: logical replication table synchronization worker for subscription "tap_sub_b_a", table "tab" has started 2026-05-06 14:54:18.009 UTC client backend[3917] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:18.012 UTC walsender[3917] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:18.012 UTC walsender[3917] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 14:54:18.013 UTC walsender[3917] tap_sub_a_b LOG: connection ready: setup total=5.329 ms, fork=0.517 ms, authentication=1.726 ms 2026-05-06 14:54:18.014 UTC walsender[3917] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 14:54:18.030 UTC walsender[3917] 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:54:18.032 UTC walsender[3917] 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:54:18.037 UTC walsender[3917] tap_sub_a_b LOG: received replication command: CREATE_REPLICATION_SLOT "tap_sub_a_b" LOGICAL pgoutput (SNAPSHOT 'nothing') 2026-05-06 14:54:18.037 UTC walsender[3917] tap_sub_a_b STATEMENT: CREATE_REPLICATION_SLOT "tap_sub_a_b" LOGICAL pgoutput (SNAPSHOT 'nothing') 2026-05-06 14:54:18.038 UTC walsender[3917] tap_sub_a_b LOG: logical decoding found consistent point at 0/0180D1C8 2026-05-06 14:54:18.038 UTC walsender[3917] tap_sub_a_b DETAIL: There are no running transactions. 2026-05-06 14:54:18.038 UTC walsender[3917] tap_sub_a_b STATEMENT: CREATE_REPLICATION_SLOT "tap_sub_a_b" LOGICAL pgoutput (SNAPSHOT 'nothing') 2026-05-06 14:54:18.038 UTC walsender[3917] tap_sub_a_b LOG: released logical replication slot "tap_sub_a_b" 2026-05-06 14:54:18.038 UTC walsender[3917] tap_sub_a_b STATEMENT: CREATE_REPLICATION_SLOT "tap_sub_a_b" LOGICAL pgoutput (SNAPSHOT 'nothing') 2026-05-06 14:54:18.038 UTC walsender[3917] tap_sub_a_b LOG: disconnection: session time: 0:00:00.029 user=postgres database=postgres host=[local] 2026-05-06 14:54:18.068 UTC client backend[19805] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:18.069 UTC walsender[19805] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:18.069 UTC walsender[19805] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 14:54:18.070 UTC walsender[19805] tap_sub_a_b LOG: connection ready: setup total=3.475 ms, fork=0.541 ms, authentication=0.314 ms 2026-05-06 14:54:18.070 UTC walsender[19805] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 14:54:18.071 UTC walsender[19805] tap_sub_a_b LOG: received replication command: IDENTIFY_SYSTEM 2026-05-06 14:54:18.071 UTC walsender[19805] tap_sub_a_b STATEMENT: IDENTIFY_SYSTEM 2026-05-06 14:54:18.071 UTC walsender[19805] 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:54:18.071 UTC walsender[19805] 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:54:18.071 UTC walsender[19805] tap_sub_a_b LOG: acquired logical replication slot "tap_sub_a_b" 2026-05-06 14:54:18.071 UTC walsender[19805] 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:54:18.071 UTC walsender[19805] tap_sub_a_b LOG: starting logical decoding for slot "tap_sub_a_b" 2026-05-06 14:54:18.071 UTC walsender[19805] tap_sub_a_b DETAIL: Streaming transactions committing after 0/0180D200, reading WAL from 0/0180D1C8. 2026-05-06 14:54:18.071 UTC walsender[19805] 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:54:18.072 UTC walsender[19805] tap_sub_a_b LOG: logical decoding found consistent point at 0/0180D1C8 2026-05-06 14:54:18.072 UTC walsender[19805] tap_sub_a_b DETAIL: There are no running transactions. 2026-05-06 14:54:18.072 UTC walsender[19805] 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:54:18.084 UTC client backend[19948] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:18.094 UTC client backend[19948] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:18.095 UTC client backend[19948] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:18.098 UTC client backend[19948] 035_conflicts.pl LOG: connection ready: setup total=15.561 ms, fork=0.608 ms, authentication=0.279 ms 2026-05-06 14:54:18.099 UTC client backend[19948] 035_conflicts.pl LOG: statement: SELECT pg_is_in_recovery() 2026-05-06 14:54:18.100 UTC client backend[19948] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.016 user=postgres database=postgres host=[local] 2026-05-06 14:54:18.113 UTC client backend[27935] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:18.115 UTC client backend[27935] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:18.115 UTC client backend[27935] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:18.116 UTC client backend[27935] 035_conflicts.pl LOG: connection ready: setup total=3.771 ms, fork=0.438 ms, authentication=0.277 ms 2026-05-06 14:54:18.116 UTC client backend[27935] 035_conflicts.pl LOG: statement: SELECT pg_current_wal_lsn() 2026-05-06 14:54:18.117 UTC client backend[27935] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2026-05-06 14:54:18.130 UTC client backend[25512] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:18.131 UTC client backend[25512] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:18.131 UTC client backend[25512] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:18.132 UTC client backend[25512] 035_conflicts.pl LOG: connection ready: setup total=3.195 ms, fork=0.434 ms, authentication=0.258 ms 2026-05-06 14:54:18.132 UTC client backend[25512] 035_conflicts.pl LOG: statement: SELECT '0/0180D200' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('tap_sub_a_b', 'walreceiver') 2026-05-06 14:54:18.136 UTC client backend[25512] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.006 user=postgres database=postgres host=[local] 2026-05-06 14:54:18.168 UTC client backend[4369] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:18.169 UTC client backend[4369] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:18.169 UTC client backend[4369] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:18.171 UTC client backend[4369] 035_conflicts.pl LOG: connection ready: setup total=15.725 ms, fork=11.799 ms, authentication=0.392 ms 2026-05-06 14:54:18.172 UTC client backend[4369] 035_conflicts.pl LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2026-05-06 14:54:18.180 UTC client backend[4369] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.012 user=postgres database=postgres host=[local] 2026-05-06 14:54:18.210 UTC logical replication tablesync worker[9472] LOG: logical replication table synchronization worker for subscription "tap_sub_b_a", table "tab" has finished 2026-05-06 14:54:18.295 UTC client backend[19696] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:18.296 UTC client backend[19696] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:18.296 UTC client backend[19696] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:18.300 UTC client backend[19696] 035_conflicts.pl LOG: connection ready: setup total=5.577 ms, fork=0.519 ms, authentication=0.250 ms 2026-05-06 14:54:18.300 UTC client backend[19696] 035_conflicts.pl LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2026-05-06 14:54:18.302 UTC client backend[19696] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.007 user=postgres database=postgres host=[local] 2026-05-06 14:54:18.327 UTC logical replication apply worker[19015] LOG: logical replication apply worker for subscription "sub_tab" has started 2026-05-06 14:54:18.342 UTC logical replication apply worker[19015] ERROR: conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts 2026-05-06 14:54:18.342 UTC logical replication apply worker[19015] 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:54:18.342 UTC logical replication apply worker[19015] 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/017DB1E0 2026-05-06 14:54:18.345 UTC postmaster[4750] LOG: background worker "logical replication apply worker" (PID 19015) exited with exit code 1 2026-05-06 14:54:18.417 UTC client backend[20526] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:18.419 UTC client backend[20526] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:18.419 UTC client backend[20526] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:18.420 UTC client backend[20526] 035_conflicts.pl LOG: connection ready: setup total=9.157 ms, fork=6.063 ms, authentication=0.284 ms 2026-05-06 14:54:18.421 UTC client backend[20526] 035_conflicts.pl LOG: statement: SELECT xmin IS NOT NULL from pg_replication_slots WHERE slot_name = 'pg_conflict_detection' 2026-05-06 14:54:18.423 UTC client backend[20526] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.005 user=postgres database=postgres host=[local] 2026-05-06 14:54:18.471 UTC walsender[19805] tap_sub_a_b LOG: released logical replication slot "tap_sub_a_b" 2026-05-06 14:54:18.471 UTC walsender[19805] tap_sub_a_b LOG: disconnection: session time: 0:00:00.403 user=postgres database=postgres host=[local] 2026-05-06 14:54:18.518 UTC client backend[5995] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:18.519 UTC walsender[5995] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:18.519 UTC walsender[5995] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 14:54:18.521 UTC walsender[5995] tap_sub_a_b LOG: connection ready: setup total=3.681 ms, fork=0.507 ms, authentication=0.278 ms 2026-05-06 14:54:18.521 UTC walsender[5995] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 14:54:18.522 UTC walsender[5995] tap_sub_a_b LOG: statement: SELECT pg_is_in_recovery() 2026-05-06 14:54:18.522 UTC walsender[5995] tap_sub_a_b LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2026-05-06 14:54:18.549 UTC client backend[24789] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:18.550 UTC walsender[24789] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:18.550 UTC walsender[24789] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 14:54:18.552 UTC walsender[24789] tap_sub_a_b LOG: connection ready: setup total=3.731 ms, fork=0.553 ms, authentication=0.317 ms 2026-05-06 14:54:18.552 UTC walsender[24789] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 14:54:18.553 UTC walsender[24789] tap_sub_a_b LOG: statement: SELECT pg_is_in_recovery() 2026-05-06 14:54:18.553 UTC walsender[24789] tap_sub_a_b LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2026-05-06 14:54:18.564 UTC client backend[784] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:18.565 UTC walsender[784] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:18.565 UTC walsender[784] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 14:54:18.567 UTC walsender[784] tap_sub_a_b LOG: connection ready: setup total=4.014 ms, fork=0.555 ms, authentication=0.323 ms 2026-05-06 14:54:18.567 UTC walsender[784] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 14:54:18.568 UTC walsender[784] tap_sub_a_b LOG: received replication command: IDENTIFY_SYSTEM 2026-05-06 14:54:18.568 UTC walsender[784] tap_sub_a_b STATEMENT: IDENTIFY_SYSTEM 2026-05-06 14:54:18.568 UTC walsender[784] 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:54:18.568 UTC walsender[784] 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:54:18.568 UTC walsender[784] tap_sub_a_b LOG: acquired logical replication slot "tap_sub_a_b" 2026-05-06 14:54:18.568 UTC walsender[784] 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:54:18.568 UTC walsender[784] tap_sub_a_b LOG: starting logical decoding for slot "tap_sub_a_b" 2026-05-06 14:54:18.568 UTC walsender[784] tap_sub_a_b DETAIL: Streaming transactions committing after 0/0180DA40, reading WAL from 0/0180D1C8. 2026-05-06 14:54:18.568 UTC walsender[784] 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:54:18.568 UTC walsender[784] tap_sub_a_b LOG: logical decoding found consistent point at 0/0180D1C8 2026-05-06 14:54:18.568 UTC walsender[784] tap_sub_a_b DETAIL: There are no running transactions. 2026-05-06 14:54:18.568 UTC walsender[784] 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:54:18.604 UTC client backend[24409] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:18.606 UTC walsender[24409] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:18.606 UTC walsender[24409] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 14:54:18.608 UTC walsender[24409] tap_sub_a_b LOG: connection ready: setup total=4.070 ms, fork=0.562 ms, authentication=0.305 ms 2026-05-06 14:54:18.608 UTC walsender[24409] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 14:54:18.608 UTC walsender[24409] tap_sub_a_b LOG: statement: SELECT pg_is_in_recovery() 2026-05-06 14:54:18.609 UTC walsender[24409] 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:54:18.613 UTC walsender[784] tap_sub_a_b LOG: released logical replication slot "tap_sub_a_b" 2026-05-06 14:54:18.613 UTC walsender[24409] tap_sub_a_b LOG: disconnection: session time: 0:00:00.009 user=postgres database=postgres host=[local] 2026-05-06 14:54:18.614 UTC walsender[784] tap_sub_a_b LOG: disconnection: session time: 0:00:00.050 user=postgres database=postgres host=[local] 2026-05-06 14:54:18.627 UTC client backend[18775] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:18.629 UTC walsender[18775] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:18.629 UTC walsender[18775] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 14:54:18.632 UTC walsender[18775] tap_sub_a_b LOG: connection ready: setup total=5.074 ms, fork=0.479 ms, authentication=0.383 ms 2026-05-06 14:54:18.633 UTC walsender[18775] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 14:54:18.634 UTC walsender[18775] tap_sub_a_b LOG: received replication command: IDENTIFY_SYSTEM 2026-05-06 14:54:18.634 UTC walsender[18775] tap_sub_a_b STATEMENT: IDENTIFY_SYSTEM 2026-05-06 14:54:18.634 UTC walsender[18775] 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:54:18.634 UTC walsender[18775] 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:54:18.634 UTC walsender[18775] tap_sub_a_b LOG: acquired logical replication slot "tap_sub_a_b" 2026-05-06 14:54:18.634 UTC walsender[18775] 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:54:18.634 UTC walsender[18775] tap_sub_a_b LOG: starting logical decoding for slot "tap_sub_a_b" 2026-05-06 14:54:18.634 UTC walsender[18775] tap_sub_a_b DETAIL: Streaming transactions committing after 0/0180DA40, reading WAL from 0/0180D1C8. 2026-05-06 14:54:18.634 UTC walsender[18775] 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:54:18.634 UTC walsender[18775] tap_sub_a_b LOG: logical decoding found consistent point at 0/0180D1C8 2026-05-06 14:54:18.634 UTC walsender[18775] tap_sub_a_b DETAIL: There are no running transactions. 2026-05-06 14:54:18.634 UTC walsender[18775] 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:54:18.648 UTC walsender[18775] tap_sub_a_b LOG: released logical replication slot "tap_sub_a_b" 2026-05-06 14:54:18.649 UTC walsender[18775] tap_sub_a_b LOG: disconnection: session time: 0:00:00.021 user=postgres database=postgres host=[local] 2026-05-06 14:54:18.668 UTC client backend[20665] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:18.670 UTC walsender[20665] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:18.670 UTC walsender[20665] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 14:54:18.671 UTC walsender[20665] tap_sub_a_b LOG: connection ready: setup total=4.193 ms, fork=0.649 ms, authentication=0.302 ms 2026-05-06 14:54:18.672 UTC walsender[20665] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 14:54:18.672 UTC walsender[20665] tap_sub_a_b LOG: received replication command: IDENTIFY_SYSTEM 2026-05-06 14:54:18.672 UTC walsender[20665] tap_sub_a_b STATEMENT: IDENTIFY_SYSTEM 2026-05-06 14:54:18.672 UTC walsender[20665] 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:54:18.672 UTC walsender[20665] 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:54:18.672 UTC walsender[20665] tap_sub_a_b LOG: acquired logical replication slot "tap_sub_a_b" 2026-05-06 14:54:18.672 UTC walsender[20665] 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:54:18.673 UTC walsender[20665] tap_sub_a_b LOG: starting logical decoding for slot "tap_sub_a_b" 2026-05-06 14:54:18.673 UTC walsender[20665] tap_sub_a_b DETAIL: Streaming transactions committing after 0/0180DA40, reading WAL from 0/0180D1C8. 2026-05-06 14:54:18.673 UTC walsender[20665] 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:54:18.673 UTC walsender[20665] tap_sub_a_b LOG: logical decoding found consistent point at 0/0180D1C8 2026-05-06 14:54:18.673 UTC walsender[20665] tap_sub_a_b DETAIL: There are no running transactions. 2026-05-06 14:54:18.673 UTC walsender[20665] 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:54:18.739 UTC client backend[22782] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:18.740 UTC client backend[22782] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:18.740 UTC client backend[22782] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:18.741 UTC client backend[22782] 035_conflicts.pl LOG: connection ready: setup total=3.175 ms, fork=0.452 ms, authentication=0.272 ms 2026-05-06 14:54:18.741 UTC client backend[22782] 035_conflicts.pl LOG: statement: SELECT * FROM tab; 2026-05-06 14:54:18.743 UTC client backend[22782] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2026-05-06 14:54:18.758 UTC walsender[20665] tap_sub_a_b LOG: released logical replication slot "tap_sub_a_b" 2026-05-06 14:54:18.758 UTC walsender[20665] tap_sub_a_b LOG: disconnection: session time: 0:00:00.090 user=postgres database=postgres host=[local] 2026-05-06 14:54:18.804 UTC client backend[4429] [unknown] LOG: connection received: host=[local] 2026-05-06 14:54:18.805 UTC client backend[4429] [unknown] LOG: connection authenticated: user="postgres" method=trust (/home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:54:18.805 UTC client backend[4429] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 14:54:18.807 UTC client backend[4429] 035_conflicts.pl LOG: connection ready: setup total=3.971 ms, fork=0.551 ms, authentication=0.342 ms 2026-05-06 14:54:18.807 UTC client backend[4429] 035_conflicts.pl LOG: statement: UPDATE tab SET b = 3 WHERE a = 1; 2026-05-06 14:54:18.809 UTC client backend[4429] 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: 27122 2026-05-06 14:54:18.842 UTC logical replication apply worker[29102] LOG: logical replication apply worker for subscription "sub_tab" has started 0x964414 at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x79c115 at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x7b8132 at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x7bbf19 at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x7be898 at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x7beede at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x76c02f at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x770342 at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x771ba0 at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x77315b at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x775845 at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0xaf2af4 at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 2026-05-06 14:54:18.854 UTC logical replication apply worker[29102] ERROR: conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts 2026-05-06 14:54:18.854 UTC logical replication apply worker[29102] 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:54:18.854 UTC logical replication apply worker[29102] 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/017DB1E0 2026-05-06 14:54:18.855 UTC postmaster[4750] LOG: background worker "logical replication apply worker" (PID 27122) was terminated by signal 6: Abort trap 2026-05-06 14:54:18.855 UTC postmaster[4750] LOG: terminating any other active server processes 2026-05-06 14:54:18.867 UTC postmaster[4750] LOG: shutting down because "restart_after_crash" is off 2026-05-06 14:54:18.868 UTC postmaster[4750] LOG: database system is shut down