2026-05-06 15:01:06.194 UTC postmaster[65550] LOG: starting PostgreSQL 19devel on x86_64-openbsd, compiled by clang-16.0.6, 64-bit 2026-05-06 15:01:06.197 UTC postmaster[65550] LOG: listening on Unix socket "/tmp/Z4qaA9XL9a/.s.PGSQL.27306" 2026-05-06 15:01:06.204 UTC startup[52653] LOG: database system was shut down at 2026-05-06 14:51:52 UTC 2026-05-06 15:01:06.214 UTC postmaster[65550] LOG: database system is ready to accept connections 2026-05-06 15:01:06.509 UTC client backend[21720] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:06.513 UTC client backend[21720] [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 15:01:06.513 UTC client backend[21720] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:06.545 UTC client backend[21720] 035_conflicts.pl LOG: connection ready: setup total=37.879 ms, fork=0.771 ms, authentication=1.280 ms 2026-05-06 15:01:06.548 UTC client backend[21720] 035_conflicts.pl LOG: statement: CREATE TABLE conf_tab (a int PRIMARY key, b int UNIQUE, c int UNIQUE); 2026-05-06 15:01:06.558 UTC client backend[21720] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.050 user=postgres database=postgres host=[local] 2026-05-06 15:01:06.590 UTC client backend[96845] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:06.593 UTC client backend[96845] [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 15:01:06.593 UTC client backend[96845] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:06.595 UTC client backend[96845] 035_conflicts.pl LOG: connection ready: setup total=7.583 ms, fork=0.863 ms, authentication=0.993 ms 2026-05-06 15:01:06.596 UTC client backend[96845] 035_conflicts.pl LOG: statement: CREATE TABLE conf_tab_2 (a int PRIMARY KEY, b int, c int, unique(a,b)) PARTITION BY RANGE (a); 2026-05-06 15:01:06.602 UTC client backend[96845] 035_conflicts.pl LOG: statement: CREATE TABLE conf_tab_2_p1 PARTITION OF conf_tab_2 FOR VALUES FROM (MINVALUE) TO (100); 2026-05-06 15:01:06.624 UTC client backend[96845] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.035 user=postgres database=postgres host=[local] 2026-05-06 15:01:06.724 UTC client backend[3520] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:06.727 UTC client backend[3520] [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 15:01:06.727 UTC client backend[3520] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:06.729 UTC client backend[3520] 035_conflicts.pl LOG: connection ready: setup total=7.813 ms, fork=1.280 ms, authentication=1.155 ms 2026-05-06 15:01:06.731 UTC client backend[3520] 035_conflicts.pl LOG: statement: CREATE SUBSCRIPTION sub_tab CONNECTION 'port=27305 host=/tmp/Z4qaA9XL9a dbname=postgres application_name=sub_tab' PUBLICATION pub_tab WITH (conflict_log_destination=all) 2026-05-06 15:01:06.771 UTC client backend[3520] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.048 user=postgres database=postgres host=[local] 2026-05-06 15:01:06.794 UTC logical replication apply worker[89493] LOG: logical replication apply worker for subscription "sub_tab" has started 2026-05-06 15:01:06.812 UTC client backend[20227] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:06.814 UTC client backend[20227] [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 15:01:06.814 UTC client backend[20227] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:06.819 UTC client backend[20227] 035_conflicts.pl LOG: connection ready: setup total=18.304 ms, fork=8.648 ms, authentication=0.590 ms 2026-05-06 15:01:06.824 UTC client backend[20227] 035_conflicts.pl LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2026-05-06 15:01:06.828 UTC client backend[20227] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.018 user=postgres database=postgres host=[local] 2026-05-06 15:01:06.837 UTC logical replication tablesync worker[31352] LOG: logical replication table synchronization worker for subscription "sub_tab", table "conf_tab" has started 2026-05-06 15:01:06.857 UTC logical replication tablesync worker[33355] LOG: logical replication table synchronization worker for subscription "sub_tab", table "conf_tab_2" has started 2026-05-06 15:01:06.878 UTC logical replication tablesync worker[31352] LOG: logical replication table synchronization worker for subscription "sub_tab", table "conf_tab" has finished 2026-05-06 15:01:06.896 UTC logical replication tablesync worker[33355] LOG: logical replication table synchronization worker for subscription "sub_tab", table "conf_tab_2" has finished 2026-05-06 15:01:06.969 UTC client backend[94703] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:06.971 UTC client backend[94703] [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 15:01:06.971 UTC client backend[94703] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:06.973 UTC client backend[94703] 035_conflicts.pl LOG: connection ready: setup total=10.170 ms, fork=4.603 ms, authentication=0.676 ms 2026-05-06 15:01:06.981 UTC client backend[94703] 035_conflicts.pl LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2026-05-06 15:01:06.987 UTC client backend[94703] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.019 user=postgres database=postgres host=[local] 2026-05-06 15:01:07.218 UTC client backend[49834] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:07.220 UTC client backend[49834] [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 15:01:07.220 UTC client backend[49834] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:07.222 UTC client backend[49834] 035_conflicts.pl LOG: connection ready: setup total=6.141 ms, fork=0.728 ms, authentication=0.977 ms 2026-05-06 15:01:07.223 UTC client backend[49834] 035_conflicts.pl LOG: statement: INSERT INTO conf_tab VALUES (2,2,2), (3,3,3), (4,4,4); 2026-05-06 15:01:07.225 UTC client backend[49834] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.008 user=postgres database=postgres host=[local] 2026-05-06 15:01:07.281 UTC logical replication apply worker[89493] ERROR: conflict detected on relation "public.conf_tab": conflict=multiple_unique_conflicts 2026-05-06 15:01:07.281 UTC logical replication apply worker[89493] DETAIL: Could not apply remote change: remote row (2, 3, 4). Key already exists in unique index "conf_tab_pkey", modified in transaction 708: key (a)=(2), local row (2, 2, 2). Key already exists in unique index "conf_tab_b_key", modified in transaction 708: key (b)=(3), local row (3, 3, 3). Key already exists in unique index "conf_tab_c_key", modified in transaction 708: key (c)=(4), local row (4, 4, 4). 2026-05-06 15:01:07.281 UTC logical replication apply worker[89493] 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/017C4930 2026-05-06 15:01:07.288 UTC postmaster[65550] LOG: background worker "logical replication apply worker" (PID 89493) exited with exit code 1 2026-05-06 15:01:07.288 UTC logical replication apply worker[54269] LOG: logical replication apply worker for subscription "sub_tab" has started 2026-05-06 15:01:07.346 UTC logical replication apply worker[54269] ERROR: conflict detected on relation "public.conf_tab": conflict=multiple_unique_conflicts 2026-05-06 15:01:07.346 UTC logical replication apply worker[54269] DETAIL: Could not apply remote change: remote row (2, 3, 4). Key already exists in unique index "conf_tab_pkey", modified in transaction 708: key (a)=(2), local row (2, 2, 2). Key already exists in unique index "conf_tab_b_key", modified in transaction 708: key (b)=(3), local row (3, 3, 3). Key already exists in unique index "conf_tab_c_key", modified in transaction 708: key (c)=(4), local row (4, 4, 4). 2026-05-06 15:01:07.346 UTC logical replication apply worker[54269] 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/017C4930 2026-05-06 15:01:07.368 UTC client backend[9250] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:07.370 UTC client backend[9250] [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 15:01:07.370 UTC client backend[9250] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:07.375 UTC client backend[9250] 035_conflicts.pl LOG: connection ready: setup total=13.881 ms, fork=5.651 ms, authentication=0.525 ms 2026-05-06 15:01:07.387 UTC client backend[9250] 035_conflicts.pl LOG: statement: SELECT oid FROM pg_subscription WHERE subname = 'sub_tab'; 2026-05-06 15:01:07.390 UTC client backend[9250] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.023 user=postgres database=postgres host=[local] 2026-05-06 15:01:07.393 UTC postmaster[65550] LOG: background worker "logical replication apply worker" (PID 54269) exited with exit code 1 2026-05-06 15:01:07.436 UTC client backend[92745] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:07.438 UTC client backend[92745] [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 15:01:07.438 UTC client backend[92745] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:07.440 UTC client backend[92745] 035_conflicts.pl LOG: connection ready: setup total=5.546 ms, fork=0.664 ms, authentication=0.794 ms 2026-05-06 15:01:07.441 UTC client backend[92745] 035_conflicts.pl LOG: statement: SELECT count(*) > 0 FROM pg_conflict.pg_conflict_log_16410; 2026-05-06 15:01:07.444 UTC client backend[92745] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.008 user=postgres database=postgres host=[local] 2026-05-06 15:01:07.465 UTC client backend[95238] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:07.470 UTC client backend[95238] [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 15:01:07.470 UTC client backend[95238] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:07.474 UTC client backend[95238] 035_conflicts.pl LOG: connection ready: setup total=10.026 ms, fork=0.610 ms, authentication=0.551 ms 2026-05-06 15:01:07.475 UTC client backend[95238] 035_conflicts.pl LOG: statement: SELECT count(*) >= 1 FROM pg_conflict.pg_conflict_log_16410 WHERE conflict_type = 'multiple_unique_conflicts'; 2026-05-06 15:01:07.480 UTC client backend[95238] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.015 user=postgres database=postgres host=[local] 2026-05-06 15:01:07.537 UTC client backend[70863] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:07.539 UTC client backend[70863] [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 15:01:07.539 UTC client backend[70863] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:07.542 UTC client backend[70863] 035_conflicts.pl LOG: connection ready: setup total=7.246 ms, fork=0.655 ms, authentication=0.609 ms 2026-05-06 15:01:07.546 UTC client backend[70863] 035_conflicts.pl LOG: statement: SELECT local_conflicts FROM pg_conflict.pg_conflict_log_16410; 2026-05-06 15:01:07.553 UTC client backend[70863] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.016 user=postgres database=postgres host=[local] 2026-05-06 15:01:07.586 UTC client backend[48556] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:07.589 UTC client backend[48556] [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 15:01:07.591 UTC client backend[48556] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:07.593 UTC client backend[48556] 035_conflicts.pl LOG: connection ready: setup total=11.245 ms, fork=2.873 ms, authentication=2.792 ms 2026-05-06 15:01:07.594 UTC client backend[48556] 035_conflicts.pl LOG: statement: TRUNCATE conf_tab; 2026-05-06 15:01:07.598 UTC client backend[48556] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.013 user=postgres database=postgres host=[local] 2026-05-06 15:01:07.633 UTC client backend[23810] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:07.638 UTC client backend[23810] [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 15:01:07.638 UTC client backend[23810] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:07.640 UTC client backend[23810] 035_conflicts.pl LOG: connection ready: setup total=8.701 ms, fork=0.626 ms, authentication=0.700 ms 2026-05-06 15:01:07.642 UTC client backend[23810] 035_conflicts.pl LOG: statement: DELETE FROM pg_conflict.pg_conflict_log_16410 2026-05-06 15:01:07.644 UTC client backend[23810] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.011 user=postgres database=postgres host=[local] 2026-05-06 15:01:07.732 UTC client backend[99717] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:07.734 UTC client backend[99717] [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 15:01:07.734 UTC client backend[99717] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:07.737 UTC client backend[99717] 035_conflicts.pl LOG: connection ready: setup total=11.180 ms, fork=0.601 ms, authentication=0.457 ms 2026-05-06 15:01:07.738 UTC client backend[99717] 035_conflicts.pl LOG: statement: INSERT INTO conf_tab VALUES (6,6,6), (7,7,7), (8,8,8); 2026-05-06 15:01:07.740 UTC client backend[99717] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.013 user=postgres database=postgres host=[local] 2026-05-06 15:01:07.811 UTC logical replication apply worker[50289] LOG: logical replication apply worker for subscription "sub_tab" has started 2026-05-06 15:01:07.840 UTC logical replication apply worker[50289] ERROR: conflict detected on relation "public.conf_tab": conflict=multiple_unique_conflicts 2026-05-06 15:01:07.840 UTC logical replication apply worker[50289] DETAIL: Could not apply remote change: remote row (6, 7, 8), replica identity (a)=(5). Key already exists in unique index "conf_tab_pkey", modified in transaction 715: key (a)=(6), local row (6, 6, 6). Key already exists in unique index "conf_tab_b_key", modified in transaction 715: key (b)=(7), local row (7, 7, 7). Key already exists in unique index "conf_tab_c_key", modified in transaction 715: key (c)=(8), local row (8, 8, 8). 2026-05-06 15:01:07.840 UTC logical replication apply worker[50289] 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/017C4BB0 2026-05-06 15:01:07.848 UTC postmaster[65550] LOG: background worker "logical replication apply worker" (PID 50289) exited with exit code 1 2026-05-06 15:01:07.917 UTC client backend[742] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:07.919 UTC client backend[742] [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 15:01:07.919 UTC client backend[742] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:07.922 UTC client backend[742] 035_conflicts.pl LOG: connection ready: setup total=5.964 ms, fork=0.766 ms, authentication=0.492 ms 2026-05-06 15:01:07.924 UTC client backend[742] 035_conflicts.pl LOG: statement: SELECT count(*) > 0 FROM pg_conflict.pg_conflict_log_16410; 2026-05-06 15:01:07.938 UTC client backend[742] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.020 user=postgres database=postgres host=[local] 2026-05-06 15:01:07.975 UTC client backend[95452] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:07.976 UTC client backend[95452] [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 15:01:07.976 UTC client backend[95452] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:07.984 UTC client backend[95452] 035_conflicts.pl LOG: connection ready: setup total=15.502 ms, fork=3.575 ms, authentication=0.463 ms 2026-05-06 15:01:07.985 UTC client backend[95452] 035_conflicts.pl LOG: statement: SELECT count(*) >= 1 FROM pg_conflict.pg_conflict_log_16410 WHERE conflict_type = 'multiple_unique_conflicts'; 2026-05-06 15:01:07.995 UTC client backend[95452] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.022 user=postgres database=postgres host=[local] 2026-05-06 15:01:08.018 UTC client backend[810] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:08.020 UTC client backend[810] [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 15:01:08.020 UTC client backend[810] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:08.024 UTC client backend[810] 035_conflicts.pl LOG: connection ready: setup total=7.831 ms, fork=0.607 ms, authentication=0.639 ms 2026-05-06 15:01:08.034 UTC client backend[810] 035_conflicts.pl LOG: statement: SELECT local_conflicts FROM pg_conflict.pg_conflict_log_16410; 2026-05-06 15:01:08.036 UTC client backend[810] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.019 user=postgres database=postgres host=[local] 2026-05-06 15:01:08.068 UTC client backend[41839] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:08.070 UTC client backend[41839] [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 15:01:08.070 UTC client backend[41839] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:08.072 UTC client backend[41839] 035_conflicts.pl LOG: connection ready: setup total=6.665 ms, fork=0.967 ms, authentication=0.769 ms 2026-05-06 15:01:08.073 UTC client backend[41839] 035_conflicts.pl LOG: statement: TRUNCATE conf_tab; 2026-05-06 15:01:08.076 UTC client backend[41839] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.010 user=postgres database=postgres host=[local] 2026-05-06 15:01:08.101 UTC client backend[82423] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:08.104 UTC client backend[82423] [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 15:01:08.104 UTC client backend[82423] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:08.106 UTC client backend[82423] 035_conflicts.pl LOG: connection ready: setup total=6.210 ms, fork=0.732 ms, authentication=0.641 ms 2026-05-06 15:01:08.107 UTC client backend[82423] 035_conflicts.pl LOG: statement: INSERT INTO conf_tab_2 VALUES (55,2,3); 2026-05-06 15:01:08.114 UTC client backend[82423] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.013 user=postgres database=postgres host=[local] 2026-05-06 15:01:08.325 UTC logical replication apply worker[65882] LOG: logical replication apply worker for subscription "sub_tab" has started 2026-05-06 15:01:08.352 UTC logical replication apply worker[65882] LOG: conflict detected on relation "public.conf_tab": conflict=update_missing 2026-05-06 15:01:08.352 UTC logical replication apply worker[65882] DETAIL: Could not find the row to be updated: remote row (6, 7, 8), replica identity (a)=(5). 2026-05-06 15:01:08.352 UTC logical replication apply worker[65882] 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/017C4BB0 2026-05-06 15:01:08.354 UTC logical replication apply worker[65882] ERROR: conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts 2026-05-06 15:01:08.354 UTC logical replication apply worker[65882] 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 721: key (a)=(55), local row (55, 2, 3). Key already exists in unique index "conf_tab_2_p1_a_b_key", modified in transaction 721: key (a, b)=(55, 2), local row (55, 2, 3). 2026-05-06 15:01:08.354 UTC logical replication apply worker[65882] 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/017C4E08 2026-05-06 15:01:08.363 UTC postmaster[65550] LOG: background worker "logical replication apply worker" (PID 65882) exited with exit code 1 2026-05-06 15:01:08.625 UTC postmaster[65550] LOG: received fast shutdown request 2026-05-06 15:01:08.625 UTC postmaster[65550] LOG: aborting any active transactions 2026-05-06 15:01:08.638 UTC postmaster[65550] LOG: background worker "logical replication launcher" (PID 6815) exited with exit code 1 2026-05-06 15:01:08.639 UTC checkpointer[53215] LOG: shutting down 2026-05-06 15:01:08.639 UTC checkpointer[53215] LOG: checkpoint starting: shutdown fast 2026-05-06 15:01:08.642 UTC checkpointer[53215] 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.002 s; sync files=0, longest=0.000 s, average=0.000 s; distance=277 kB, estimate=277 kB; lsn=0/017D1850, redo lsn=0/017D1850 2026-05-06 15:01:08.674 UTC postmaster[65550] LOG: database system is shut down 2026-05-06 15:01:08.773 UTC postmaster[90168] LOG: starting PostgreSQL 19devel on x86_64-openbsd, compiled by clang-16.0.6, 64-bit 2026-05-06 15:01:08.778 UTC postmaster[90168] LOG: listening on Unix socket "/tmp/Z4qaA9XL9a/.s.PGSQL.27306" 2026-05-06 15:01:08.789 UTC startup[91491] LOG: database system was shut down at 2026-05-06 15:01:08 UTC 2026-05-06 15:01:08.791 UTC startup[91491] LOG: recovered replication state of node 1 to 0/017C4BE0 2026-05-06 15:01:08.802 UTC postmaster[90168] LOG: database system is ready to accept connections 2026-05-06 15:01:08.837 UTC logical replication apply worker[24290] LOG: logical replication apply worker for subscription "sub_tab" has started 2026-05-06 15:01:08.869 UTC logical replication apply worker[24290] ERROR: conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts 2026-05-06 15:01:08.869 UTC logical replication apply worker[24290] 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 721: key (a)=(55), local row (55, 2, 3). Key already exists in unique index "conf_tab_2_p1_a_b_key", modified in transaction 721: key (a, b)=(55, 2), local row (55, 2, 3). 2026-05-06 15:01:08.869 UTC logical replication apply worker[24290] 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/017C4E08 2026-05-06 15:01:08.879 UTC postmaster[90168] LOG: background worker "logical replication apply worker" (PID 24290) exited with exit code 1 2026-05-06 15:01:08.921 UTC client backend[98028] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:08.927 UTC client backend[98028] [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 15:01:08.927 UTC client backend[98028] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:08.929 UTC client backend[98028] 035_conflicts.pl LOG: connection ready: setup total=9.139 ms, fork=0.668 ms, authentication=0.683 ms 2026-05-06 15:01:08.930 UTC client backend[98028] 035_conflicts.pl LOG: statement: CREATE TABLE tab (a int PRIMARY KEY, b int) 2026-05-06 15:01:08.940 UTC client backend[98028] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.018 user=postgres database=postgres host=[local] 2026-05-06 15:01:08.999 UTC client backend[31481] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:09.002 UTC client backend[31481] [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 15:01:09.002 UTC client backend[31481] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:09.004 UTC client backend[31481] 035_conflicts.pl LOG: connection ready: setup total=6.817 ms, fork=0.804 ms, authentication=0.892 ms 2026-05-06 15:01:09.006 UTC client backend[31481] 035_conflicts.pl LOG: statement: CREATE SUBSCRIPTION tap_sub_b_a CONNECTION 'port=27305 host=/tmp/Z4qaA9XL9a dbname=postgres application_name=tap_sub_b_a' PUBLICATION tap_pub_A WITH (origin = none, retain_dead_tuples = true) 2026-05-06 15:01:09.045 UTC logical replication launcher[49378] LOG: creating replication conflict detection slot 2026-05-06 15:01:09.046 UTC client backend[31481] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.048 user=postgres database=postgres host=[local] 2026-05-06 15:01:09.064 UTC logical replication apply worker[36974] LOG: logical replication apply worker for subscription "tap_sub_b_a" has started 2026-05-06 15:01:09.106 UTC client backend[96424] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:09.108 UTC client backend[96424] [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 15:01:09.108 UTC client backend[96424] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:09.112 UTC client backend[96424] 035_conflicts.pl LOG: connection ready: setup total=8.718 ms, fork=0.977 ms, authentication=0.525 ms 2026-05-06 15:01:09.115 UTC client backend[96424] 035_conflicts.pl LOG: statement: CREATE PUBLICATION tap_pub_B FOR TABLE tab 2026-05-06 15:01:09.118 UTC logical replication tablesync worker[81740] LOG: logical replication table synchronization worker for subscription "tap_sub_b_a", table "tab" has started 2026-05-06 15:01:09.120 UTC client backend[96424] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.015 user=postgres database=postgres host=[local] 2026-05-06 15:01:09.156 UTC logical replication tablesync worker[81740] LOG: logical replication table synchronization worker for subscription "tap_sub_b_a", table "tab" has finished 2026-05-06 15:01:09.159 UTC client backend[18051] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:09.161 UTC walsender[18051] [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 15:01:09.161 UTC walsender[18051] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 15:01:09.163 UTC walsender[18051] tap_sub_a_b LOG: connection ready: setup total=5.462 ms, fork=0.567 ms, authentication=0.537 ms 2026-05-06 15:01:09.163 UTC walsender[18051] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 15:01:09.164 UTC walsender[18051] tap_sub_a_b LOG: statement: SELECT t.pubname FROM pg_catalog.pg_publication t WHERE t.pubname IN ('tap_pub_b') 2026-05-06 15:01:09.167 UTC walsender[18051] tap_sub_a_b LOG: statement: SELECT DISTINCT n.nspname, c.relname, c.relkind, gpt.attrs FROM pg_class c JOIN pg_namespace n ON n.oid = c.relnamespace JOIN ( SELECT (pg_get_publication_tables(VARIADIC array_agg(pubname::text))).* FROM pg_publication WHERE pubname IN ( 'tap_pub_b' )) AS gpt ON gpt.relid = c.oid UNION ALL SELECT DISTINCT s.schemaname, s.sequencename, 'S'::"char" AS relkind, NULL::int2vector AS attrs FROM pg_catalog.pg_publication_sequences s WHERE s.pubname IN ( 'tap_pub_b' ) 2026-05-06 15:01:09.180 UTC walsender[18051] tap_sub_a_b LOG: received replication command: CREATE_REPLICATION_SLOT "tap_sub_a_b" LOGICAL pgoutput (SNAPSHOT 'nothing') 2026-05-06 15:01:09.180 UTC walsender[18051] tap_sub_a_b STATEMENT: CREATE_REPLICATION_SLOT "tap_sub_a_b" LOGICAL pgoutput (SNAPSHOT 'nothing') 2026-05-06 15:01:09.181 UTC walsender[18051] tap_sub_a_b LOG: logical decoding found consistent point at 0/017F7928 2026-05-06 15:01:09.181 UTC walsender[18051] tap_sub_a_b DETAIL: There are no running transactions. 2026-05-06 15:01:09.181 UTC walsender[18051] tap_sub_a_b STATEMENT: CREATE_REPLICATION_SLOT "tap_sub_a_b" LOGICAL pgoutput (SNAPSHOT 'nothing') 2026-05-06 15:01:09.181 UTC walsender[18051] tap_sub_a_b LOG: released logical replication slot "tap_sub_a_b" 2026-05-06 15:01:09.181 UTC walsender[18051] tap_sub_a_b STATEMENT: CREATE_REPLICATION_SLOT "tap_sub_a_b" LOGICAL pgoutput (SNAPSHOT 'nothing') 2026-05-06 15:01:09.181 UTC walsender[18051] tap_sub_a_b LOG: disconnection: session time: 0:00:00.023 user=postgres database=postgres host=[local] 2026-05-06 15:01:09.202 UTC client backend[33506] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:09.205 UTC walsender[33506] [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 15:01:09.205 UTC walsender[33506] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 15:01:09.211 UTC walsender[33506] tap_sub_a_b LOG: connection ready: setup total=11.157 ms, fork=0.782 ms, authentication=0.879 ms 2026-05-06 15:01:09.212 UTC walsender[33506] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 15:01:09.213 UTC walsender[33506] tap_sub_a_b LOG: received replication command: IDENTIFY_SYSTEM 2026-05-06 15:01:09.213 UTC walsender[33506] tap_sub_a_b STATEMENT: IDENTIFY_SYSTEM 2026-05-06 15:01:09.213 UTC walsender[33506] tap_sub_a_b LOG: received replication command: START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"') 2026-05-06 15:01:09.213 UTC walsender[33506] tap_sub_a_b STATEMENT: START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"') 2026-05-06 15:01:09.213 UTC walsender[33506] tap_sub_a_b LOG: acquired logical replication slot "tap_sub_a_b" 2026-05-06 15:01:09.213 UTC walsender[33506] tap_sub_a_b STATEMENT: START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"') 2026-05-06 15:01:09.216 UTC walsender[33506] tap_sub_a_b LOG: starting logical decoding for slot "tap_sub_a_b" 2026-05-06 15:01:09.216 UTC walsender[33506] tap_sub_a_b DETAIL: Streaming transactions committing after 0/017F7960, reading WAL from 0/017F7928. 2026-05-06 15:01:09.216 UTC walsender[33506] tap_sub_a_b STATEMENT: START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"') 2026-05-06 15:01:09.216 UTC walsender[33506] tap_sub_a_b LOG: logical decoding found consistent point at 0/017F7928 2026-05-06 15:01:09.216 UTC walsender[33506] tap_sub_a_b DETAIL: There are no running transactions. 2026-05-06 15:01:09.216 UTC walsender[33506] tap_sub_a_b STATEMENT: START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"') 2026-05-06 15:01:09.257 UTC client backend[23947] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:09.260 UTC client backend[23947] [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 15:01:09.260 UTC client backend[23947] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:09.263 UTC client backend[23947] 035_conflicts.pl LOG: connection ready: setup total=7.811 ms, fork=0.731 ms, authentication=0.659 ms 2026-05-06 15:01:09.264 UTC client backend[23947] 035_conflicts.pl LOG: statement: SELECT pg_is_in_recovery() 2026-05-06 15:01:09.266 UTC client backend[23947] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.010 user=postgres database=postgres host=[local] 2026-05-06 15:01:09.296 UTC client backend[13092] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:09.298 UTC client backend[13092] [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 15:01:09.298 UTC client backend[13092] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:09.300 UTC client backend[13092] 035_conflicts.pl LOG: connection ready: setup total=6.345 ms, fork=0.701 ms, authentication=0.615 ms 2026-05-06 15:01:09.302 UTC client backend[13092] 035_conflicts.pl LOG: statement: SELECT pg_current_wal_lsn() 2026-05-06 15:01:09.304 UTC client backend[13092] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.009 user=postgres database=postgres host=[local] 2026-05-06 15:01:09.330 UTC client backend[8114] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:09.333 UTC client backend[8114] [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 15:01:09.333 UTC client backend[8114] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:09.336 UTC client backend[8114] 035_conflicts.pl LOG: connection ready: setup total=8.039 ms, fork=0.814 ms, authentication=1.176 ms 2026-05-06 15:01:09.339 UTC client backend[8114] 035_conflicts.pl LOG: statement: SELECT '0/017F7960' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('tap_sub_a_b', 'walreceiver') 2026-05-06 15:01:09.340 UTC logical replication apply worker[37614] LOG: logical replication apply worker for subscription "sub_tab" has started 2026-05-06 15:01:09.362 UTC client backend[8114] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.033 user=postgres database=postgres host=[local] 2026-05-06 15:01:09.376 UTC logical replication apply worker[37614] ERROR: conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts 2026-05-06 15:01:09.376 UTC logical replication apply worker[37614] 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 721: key (a)=(55), local row (55, 2, 3). Key already exists in unique index "conf_tab_2_p1_a_b_key", modified in transaction 721: key (a, b)=(55, 2), local row (55, 2, 3). 2026-05-06 15:01:09.376 UTC logical replication apply worker[37614] 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/017C4E08 2026-05-06 15:01:09.386 UTC postmaster[90168] LOG: background worker "logical replication apply worker" (PID 37614) exited with exit code 1 2026-05-06 15:01:09.393 UTC client backend[79554] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:09.396 UTC client backend[79554] [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 15:01:09.396 UTC client backend[79554] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:09.400 UTC client backend[79554] 035_conflicts.pl LOG: connection ready: setup total=7.981 ms, fork=0.977 ms, authentication=0.680 ms 2026-05-06 15:01:09.403 UTC client backend[79554] 035_conflicts.pl LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2026-05-06 15:01:09.412 UTC client backend[79554] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.019 user=postgres database=postgres host=[local] 2026-05-06 15:01:09.624 UTC client backend[84759] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:09.625 UTC client backend[84759] [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 15:01:09.625 UTC client backend[84759] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:09.627 UTC client backend[84759] 035_conflicts.pl LOG: connection ready: setup total=4.504 ms, fork=0.560 ms, authentication=0.369 ms 2026-05-06 15:01:09.628 UTC client backend[84759] 035_conflicts.pl LOG: statement: SELECT xmin IS NOT NULL from pg_replication_slots WHERE slot_name = 'pg_conflict_detection' 2026-05-06 15:01:09.634 UTC client backend[84759] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.011 user=postgres database=postgres host=[local] 2026-05-06 15:01:09.711 UTC walsender[33506] tap_sub_a_b LOG: released logical replication slot "tap_sub_a_b" 2026-05-06 15:01:09.711 UTC walsender[33506] tap_sub_a_b LOG: disconnection: session time: 0:00:00.510 user=postgres database=postgres host=[local] 2026-05-06 15:01:09.804 UTC client backend[84516] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:09.806 UTC walsender[84516] [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 15:01:09.806 UTC walsender[84516] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 15:01:09.807 UTC walsender[84516] tap_sub_a_b LOG: connection ready: setup total=4.892 ms, fork=0.638 ms, authentication=0.394 ms 2026-05-06 15:01:09.808 UTC walsender[84516] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 15:01:09.811 UTC walsender[84516] tap_sub_a_b LOG: statement: SELECT pg_is_in_recovery() 2026-05-06 15:01:09.811 UTC walsender[84516] tap_sub_a_b LOG: disconnection: session time: 0:00:00.008 user=postgres database=postgres host=[local] 2026-05-06 15:01:09.849 UTC logical replication apply worker[23030] LOG: logical replication apply worker for subscription "sub_tab" has started 2026-05-06 15:01:09.849 UTC client backend[66383] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:09.852 UTC walsender[66383] [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 15:01:09.852 UTC walsender[66383] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 15:01:09.857 UTC walsender[66383] tap_sub_a_b LOG: connection ready: setup total=10.290 ms, fork=0.679 ms, authentication=0.857 ms 2026-05-06 15:01:09.858 UTC walsender[66383] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 15:01:09.859 UTC walsender[66383] tap_sub_a_b LOG: statement: SELECT pg_is_in_recovery() 2026-05-06 15:01:09.860 UTC walsender[66383] tap_sub_a_b LOG: disconnection: session time: 0:00:00.011 user=postgres database=postgres host=[local] 2026-05-06 15:01:09.867 UTC logical replication apply worker[23030] ERROR: conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts 2026-05-06 15:01:09.867 UTC logical replication apply worker[23030] 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 721: key (a)=(55), local row (55, 2, 3). Key already exists in unique index "conf_tab_2_p1_a_b_key", modified in transaction 721: key (a, b)=(55, 2), local row (55, 2, 3). 2026-05-06 15:01:09.867 UTC logical replication apply worker[23030] 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/017C4E08 2026-05-06 15:01:09.871 UTC client backend[76074] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:09.875 UTC walsender[76074] [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 15:01:09.875 UTC walsender[76074] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 15:01:09.876 UTC walsender[76074] tap_sub_a_b LOG: connection ready: setup total=8.867 ms, fork=2.660 ms, authentication=0.433 ms 2026-05-06 15:01:09.877 UTC walsender[76074] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 15:01:09.878 UTC walsender[76074] tap_sub_a_b LOG: received replication command: IDENTIFY_SYSTEM 2026-05-06 15:01:09.878 UTC walsender[76074] tap_sub_a_b STATEMENT: IDENTIFY_SYSTEM 2026-05-06 15:01:09.878 UTC walsender[76074] tap_sub_a_b LOG: received replication command: START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"') 2026-05-06 15:01:09.878 UTC walsender[76074] tap_sub_a_b STATEMENT: START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"') 2026-05-06 15:01:09.878 UTC walsender[76074] tap_sub_a_b LOG: acquired logical replication slot "tap_sub_a_b" 2026-05-06 15:01:09.878 UTC walsender[76074] tap_sub_a_b STATEMENT: START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"') 2026-05-06 15:01:09.878 UTC postmaster[90168] LOG: background worker "logical replication apply worker" (PID 23030) exited with exit code 1 2026-05-06 15:01:09.881 UTC walsender[76074] tap_sub_a_b LOG: starting logical decoding for slot "tap_sub_a_b" 2026-05-06 15:01:09.881 UTC walsender[76074] tap_sub_a_b DETAIL: Streaming transactions committing after 0/017F7C38, reading WAL from 0/017F7928. 2026-05-06 15:01:09.881 UTC walsender[76074] tap_sub_a_b STATEMENT: START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"') 2026-05-06 15:01:09.883 UTC walsender[76074] tap_sub_a_b LOG: logical decoding found consistent point at 0/017F7928 2026-05-06 15:01:09.883 UTC walsender[76074] tap_sub_a_b DETAIL: There are no running transactions. 2026-05-06 15:01:09.883 UTC walsender[76074] tap_sub_a_b STATEMENT: START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"') 2026-05-06 15:01:09.991 UTC client backend[28516] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:09.993 UTC walsender[28516] [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 15:01:09.993 UTC walsender[28516] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 15:01:09.995 UTC walsender[28516] tap_sub_a_b LOG: connection ready: setup total=4.512 ms, fork=0.523 ms, authentication=0.502 ms 2026-05-06 15:01:09.995 UTC walsender[28516] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 15:01:09.996 UTC walsender[28516] tap_sub_a_b LOG: statement: SELECT pg_is_in_recovery() 2026-05-06 15:01:09.996 UTC walsender[28516] tap_sub_a_b LOG: statement: SELECT DISTINCT P.pubname AS pubname FROM pg_publication P, LATERAL pg_get_publication_tables(P.pubname) GPT JOIN pg_subscription_rel PS ON (GPT.relid = PS.srrelid OR GPT.relid IN (SELECT relid FROM pg_partition_ancestors(PS.srrelid) UNION SELECT relid FROM pg_partition_tree(PS.srrelid))), pg_class C JOIN pg_namespace N ON (N.oid = C.relnamespace) WHERE C.oid = GPT.relid AND P.pubname IN ('tap_pub_b') 2026-05-06 15:01:10.004 UTC walsender[28516] tap_sub_a_b LOG: disconnection: session time: 0:00:00.013 user=postgres database=postgres host=[local] 2026-05-06 15:01:10.005 UTC walsender[76074] tap_sub_a_b LOG: released logical replication slot "tap_sub_a_b" 2026-05-06 15:01:10.005 UTC walsender[76074] tap_sub_a_b LOG: disconnection: session time: 0:00:00.134 user=postgres database=postgres host=[local] 2026-05-06 15:01:10.016 UTC client backend[77206] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:10.020 UTC walsender[77206] [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 15:01:10.020 UTC walsender[77206] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 15:01:10.022 UTC walsender[77206] tap_sub_a_b LOG: connection ready: setup total=6.810 ms, fork=0.589 ms, authentication=0.610 ms 2026-05-06 15:01:10.022 UTC walsender[77206] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 15:01:10.027 UTC walsender[77206] tap_sub_a_b LOG: received replication command: IDENTIFY_SYSTEM 2026-05-06 15:01:10.027 UTC walsender[77206] tap_sub_a_b STATEMENT: IDENTIFY_SYSTEM 2026-05-06 15:01:10.027 UTC walsender[77206] tap_sub_a_b LOG: received replication command: START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"tap_pub_b"') 2026-05-06 15:01:10.027 UTC walsender[77206] tap_sub_a_b STATEMENT: START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"tap_pub_b"') 2026-05-06 15:01:10.027 UTC walsender[77206] tap_sub_a_b LOG: acquired logical replication slot "tap_sub_a_b" 2026-05-06 15:01:10.027 UTC walsender[77206] tap_sub_a_b STATEMENT: START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"tap_pub_b"') 2026-05-06 15:01:10.030 UTC walsender[77206] tap_sub_a_b LOG: starting logical decoding for slot "tap_sub_a_b" 2026-05-06 15:01:10.030 UTC walsender[77206] tap_sub_a_b DETAIL: Streaming transactions committing after 0/017F7F10, reading WAL from 0/017F7928. 2026-05-06 15:01:10.030 UTC walsender[77206] tap_sub_a_b STATEMENT: START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"tap_pub_b"') 2026-05-06 15:01:10.049 UTC walsender[77206] tap_sub_a_b LOG: logical decoding found consistent point at 0/017F7928 2026-05-06 15:01:10.049 UTC walsender[77206] tap_sub_a_b DETAIL: There are no running transactions. 2026-05-06 15:01:10.049 UTC walsender[77206] tap_sub_a_b STATEMENT: START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"tap_pub_b"') 2026-05-06 15:01:10.075 UTC walsender[77206] tap_sub_a_b LOG: released logical replication slot "tap_sub_a_b" 2026-05-06 15:01:10.075 UTC walsender[77206] tap_sub_a_b LOG: disconnection: session time: 0:00:00.059 user=postgres database=postgres host=[local] 2026-05-06 15:01:10.088 UTC client backend[50728] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:10.091 UTC walsender[50728] [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 15:01:10.091 UTC walsender[50728] [unknown] LOG: replication connection authorized: user=postgres application_name=tap_sub_a_b 2026-05-06 15:01:10.094 UTC walsender[50728] tap_sub_a_b LOG: connection ready: setup total=7.733 ms, fork=0.625 ms, authentication=0.366 ms 2026-05-06 15:01:10.095 UTC walsender[50728] tap_sub_a_b LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2026-05-06 15:01:10.097 UTC walsender[50728] tap_sub_a_b LOG: received replication command: IDENTIFY_SYSTEM 2026-05-06 15:01:10.097 UTC walsender[50728] tap_sub_a_b STATEMENT: IDENTIFY_SYSTEM 2026-05-06 15:01:10.098 UTC walsender[50728] tap_sub_a_b LOG: received replication command: START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"') 2026-05-06 15:01:10.098 UTC walsender[50728] tap_sub_a_b STATEMENT: START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"') 2026-05-06 15:01:10.098 UTC walsender[50728] tap_sub_a_b LOG: acquired logical replication slot "tap_sub_a_b" 2026-05-06 15:01:10.098 UTC walsender[50728] tap_sub_a_b STATEMENT: START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"') 2026-05-06 15:01:10.098 UTC walsender[50728] tap_sub_a_b LOG: starting logical decoding for slot "tap_sub_a_b" 2026-05-06 15:01:10.098 UTC walsender[50728] tap_sub_a_b DETAIL: Streaming transactions committing after 0/017F7F10, reading WAL from 0/017F7928. 2026-05-06 15:01:10.098 UTC walsender[50728] tap_sub_a_b STATEMENT: START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"') 2026-05-06 15:01:10.099 UTC walsender[50728] tap_sub_a_b LOG: logical decoding found consistent point at 0/017F7928 2026-05-06 15:01:10.099 UTC walsender[50728] tap_sub_a_b DETAIL: There are no running transactions. 2026-05-06 15:01:10.099 UTC walsender[50728] tap_sub_a_b STATEMENT: START_REPLICATION SLOT "tap_sub_a_b" LOGICAL 0/00000000 (proto_version '4', streaming 'parallel', origin 'none', publication_names '"tap_pub_b"') 2026-05-06 15:01:10.329 UTC client backend[6523] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:10.331 UTC client backend[6523] [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 15:01:10.331 UTC client backend[6523] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:10.333 UTC client backend[6523] 035_conflicts.pl LOG: connection ready: setup total=8.148 ms, fork=0.727 ms, authentication=0.513 ms 2026-05-06 15:01:10.336 UTC client backend[6523] 035_conflicts.pl LOG: statement: SELECT * FROM tab; 2026-05-06 15:01:10.339 UTC client backend[6523] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.013 user=postgres database=postgres host=[local] 2026-05-06 15:01:10.357 UTC logical replication apply worker[25094] LOG: logical replication apply worker for subscription "sub_tab" has started 2026-05-06 15:01:10.377 UTC walsender[50728] tap_sub_a_b LOG: released logical replication slot "tap_sub_a_b" 2026-05-06 15:01:10.377 UTC walsender[50728] tap_sub_a_b LOG: disconnection: session time: 0:00:00.289 user=postgres database=postgres host=[local] 2026-05-06 15:01:10.405 UTC logical replication apply worker[25094] ERROR: conflict detected on relation "public.conf_tab_2_p1": conflict=multiple_unique_conflicts 2026-05-06 15:01:10.405 UTC logical replication apply worker[25094] 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 721: key (a)=(55), local row (55, 2, 3). Key already exists in unique index "conf_tab_2_p1_a_b_key", modified in transaction 721: key (a, b)=(55, 2), local row (55, 2, 3). 2026-05-06 15:01:10.405 UTC logical replication apply worker[25094] 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/017C4E08 2026-05-06 15:01:10.436 UTC postmaster[90168] LOG: background worker "logical replication apply worker" (PID 25094) exited with exit code 1 2026-05-06 15:01:10.438 UTC client backend[11331] [unknown] LOG: connection received: host=[local] 2026-05-06 15:01:10.440 UTC client backend[11331] [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 15:01:10.442 UTC client backend[11331] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=035_conflicts.pl 2026-05-06 15:01:10.447 UTC client backend[11331] 035_conflicts.pl LOG: connection ready: setup total=8.667 ms, fork=0.718 ms, authentication=2.680 ms 2026-05-06 15:01:10.448 UTC client backend[11331] 035_conflicts.pl LOG: statement: UPDATE tab SET b = 3 WHERE a = 1; 2026-05-06 15:01:10.457 UTC client backend[11331] 035_conflicts.pl LOG: disconnection: session time: 0:00:00.019 user=postgres database=postgres host=[local] TRAP: failed Assert("conflictlogrel != NULL"), File: "../src/backend/replication/logical/conflict.c", Line: 195, PID: 36974 0x796b7a7e59f at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x796b783f37a at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x796b78681d6 at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x796b7863b01 at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x796b7865469 at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x796b786628f at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x796b7865fc4 at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x796b78072bb at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x796b780c39f at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x796b780fcb3 at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x796b78117d5 at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x796b780ee5e at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 0x796b7724ee5 at /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/postgres 2026-05-06 15:01:10.621 UTC postmaster[90168] LOG: background worker "logical replication apply worker" (PID 36974) was terminated by signal 6: Abort trap 2026-05-06 15:01:10.621 UTC postmaster[90168] LOG: terminating any other active server processes 2026-05-06 15:01:10.646 UTC postmaster[90168] LOG: shutting down because "restart_after_crash" is off 2026-05-06 15:01:10.662 UTC postmaster[90168] LOG: database system is shut down