2026-05-06 14:58:11.660 UTC postmaster[78327] LOG: starting PostgreSQL 19devel on x86_64-linux, compiled by gcc-14.2.0, 64-bit 2026-05-06 14:58:11.660 UTC postmaster[78327] LOG: listening on Unix socket "/tmp/0iFThosJ8U/.s.PGSQL.15440" 2026-05-06 14:58:11.667 UTC startup[78338] LOG: database system was shut down at 2026-05-06 14:58:11 UTC 2026-05-06 14:58:11.675 UTC postmaster[78327] LOG: database system is ready to accept connections 2026-05-06 14:58:11.794 UTC client backend[78385] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:11.801 UTC client backend[78385] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/029_on_error/data/t_029_on_error_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:58:11.801 UTC client backend[78385] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=029_on_error.pl 2026-05-06 14:58:11.811 UTC client backend[78385] 029_on_error.pl LOG: connection ready: setup total=18.500 ms, fork=0.837 ms, authentication=3.492 ms 2026-05-06 14:58:11.814 UTC client backend[78385] 029_on_error.pl LOG: statement: CREATE TABLE tbl (i INT PRIMARY KEY, t BYTEA); 2026-05-06 14:58:11.825 UTC client backend[78385] 029_on_error.pl LOG: statement: INSERT INTO tbl VALUES (1, NULL); 2026-05-06 14:58:11.829 UTC client backend[78385] 029_on_error.pl LOG: disconnection: session time: 0:00:00.035 user=postgres database=postgres host=[local] 2026-05-06 14:58:11.860 UTC client backend[78407] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:11.861 UTC client backend[78407] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/029_on_error/data/t_029_on_error_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:58:11.861 UTC client backend[78407] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=029_on_error.pl 2026-05-06 14:58:11.862 UTC client backend[78407] 029_on_error.pl LOG: connection ready: setup total=3.851 ms, fork=0.791 ms, authentication=0.414 ms 2026-05-06 14:58:11.862 UTC client backend[78407] 029_on_error.pl LOG: statement: CREATE SUBSCRIPTION sub CONNECTION 'port=15439 host=/tmp/0iFThosJ8U dbname=postgres' PUBLICATION pub WITH (disable_on_error = true, streaming = on, two_phase = on) 2026-05-06 14:58:11.888 UTC client backend[78407] 029_on_error.pl LOG: disconnection: session time: 0:00:00.028 user=postgres database=postgres host=[local] 2026-05-06 14:58:11.893 UTC logical replication apply worker[78416] LOG: logical replication apply worker for subscription "sub" has started 2026-05-06 14:58:11.929 UTC logical replication tablesync worker[78425] LOG: logical replication table synchronization worker for subscription "sub", table "tbl" has started 2026-05-06 14:58:11.929 UTC client backend[78428] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:11.930 UTC client backend[78428] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/029_on_error/data/t_029_on_error_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:58:11.930 UTC client backend[78428] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=029_on_error.pl 2026-05-06 14:58:11.932 UTC client backend[78428] 029_on_error.pl LOG: connection ready: setup total=6.240 ms, fork=1.922 ms, authentication=0.328 ms 2026-05-06 14:58:11.932 UTC client backend[78428] 029_on_error.pl LOG: statement: SELECT subenabled = false FROM pg_catalog.pg_subscription WHERE subname = 'sub' 2026-05-06 14:58:11.935 UTC client backend[78428] 029_on_error.pl LOG: disconnection: session time: 0:00:00.007 user=postgres database=postgres host=[local] 2026-05-06 14:58:11.955 UTC logical replication tablesync worker[78425] ERROR: duplicate key value violates unique constraint "tbl_pkey" 2026-05-06 14:58:11.955 UTC logical replication tablesync worker[78425] DETAIL: Key (i)=(1) already exists. 2026-05-06 14:58:11.955 UTC logical replication tablesync worker[78425] CONTEXT: COPY tbl, line 1 2026-05-06 14:58:11.955 UTC logical replication tablesync worker[78425] LOG: subscription "sub" has been disabled because of an error 2026-05-06 14:58:11.961 UTC logical replication apply worker[78416] LOG: logical replication worker for subscription "sub" will stop because the subscription was disabled 2026-05-06 14:58:12.055 UTC client backend[78455] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:12.056 UTC client backend[78455] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/029_on_error/data/t_029_on_error_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:58:12.056 UTC client backend[78455] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=029_on_error.pl 2026-05-06 14:58:12.057 UTC client backend[78455] 029_on_error.pl LOG: connection ready: setup total=3.519 ms, fork=0.734 ms, authentication=0.313 ms 2026-05-06 14:58:12.057 UTC client backend[78455] 029_on_error.pl LOG: statement: SELECT subenabled = false FROM pg_catalog.pg_subscription WHERE subname = 'sub' 2026-05-06 14:58:12.062 UTC client backend[78455] 029_on_error.pl LOG: disconnection: session time: 0:00:00.007 user=postgres database=postgres host=[local] 2026-05-06 14:58:12.078 UTC client backend[78460] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:12.079 UTC client backend[78460] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/029_on_error/data/t_029_on_error_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:58:12.079 UTC client backend[78460] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=029_on_error.pl 2026-05-06 14:58:12.080 UTC client backend[78460] 029_on_error.pl LOG: connection ready: setup total=4.732 ms, fork=2.169 ms, authentication=0.277 ms 2026-05-06 14:58:12.081 UTC client backend[78460] 029_on_error.pl LOG: statement: TRUNCATE tbl 2026-05-06 14:58:12.086 UTC client backend[78460] 029_on_error.pl LOG: disconnection: session time: 0:00:00.008 user=postgres database=postgres host=[local] 2026-05-06 14:58:12.100 UTC client backend[78464] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:12.101 UTC client backend[78464] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/029_on_error/data/t_029_on_error_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:58:12.101 UTC client backend[78464] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=029_on_error.pl 2026-05-06 14:58:12.102 UTC client backend[78464] 029_on_error.pl LOG: connection ready: setup total=3.778 ms, fork=0.717 ms, authentication=0.304 ms 2026-05-06 14:58:12.102 UTC client backend[78464] 029_on_error.pl LOG: statement: ALTER SUBSCRIPTION sub ENABLE 2026-05-06 14:58:12.103 UTC client backend[78464] 029_on_error.pl LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2026-05-06 14:58:12.114 UTC logical replication apply worker[78469] LOG: logical replication apply worker for subscription "sub" has started 2026-05-06 14:58:12.125 UTC client backend[78474] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:12.126 UTC client backend[78474] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/029_on_error/data/t_029_on_error_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:58:12.126 UTC client backend[78474] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=029_on_error.pl 2026-05-06 14:58:12.128 UTC client backend[78474] 029_on_error.pl LOG: connection ready: setup total=4.231 ms, fork=0.727 ms, authentication=0.289 ms 2026-05-06 14:58:12.130 UTC client backend[78474] 029_on_error.pl LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2026-05-06 14:58:12.133 UTC client backend[78474] 029_on_error.pl LOG: disconnection: session time: 0:00:00.008 user=postgres database=postgres host=[local] 2026-05-06 14:58:12.150 UTC logical replication tablesync worker[78479] LOG: logical replication table synchronization worker for subscription "sub", table "tbl" has started 2026-05-06 14:58:12.173 UTC logical replication tablesync worker[78479] LOG: logical replication table synchronization worker for subscription "sub", table "tbl" has finished 2026-05-06 14:58:12.177 UTC logical replication apply worker[78469] LOG: logical replication apply worker for subscription "sub" will restart so that two_phase can be enabled 2026-05-06 14:58:12.185 UTC logical replication apply worker[78486] LOG: logical replication apply worker for subscription "sub" has started 2026-05-06 14:58:12.251 UTC client backend[78513] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:12.253 UTC client backend[78513] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/029_on_error/data/t_029_on_error_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:58:12.253 UTC client backend[78513] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=029_on_error.pl 2026-05-06 14:58:12.261 UTC client backend[78513] 029_on_error.pl LOG: connection ready: setup total=12.096 ms, fork=2.445 ms, authentication=0.320 ms 2026-05-06 14:58:12.261 UTC client backend[78513] 029_on_error.pl LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2026-05-06 14:58:12.263 UTC client backend[78513] 029_on_error.pl LOG: disconnection: session time: 0:00:00.012 user=postgres database=postgres host=[local] 2026-05-06 14:58:12.329 UTC client backend[78537] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:12.330 UTC client backend[78537] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/029_on_error/data/t_029_on_error_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:58:12.330 UTC client backend[78537] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=029_on_error.pl 2026-05-06 14:58:12.332 UTC client backend[78537] 029_on_error.pl LOG: connection ready: setup total=3.204 ms, fork=0.688 ms, authentication=0.279 ms 2026-05-06 14:58:12.332 UTC client backend[78537] 029_on_error.pl LOG: statement: SELECT COUNT(*) FROM tbl 2026-05-06 14:58:12.333 UTC client backend[78537] 029_on_error.pl LOG: disconnection: session time: 0:00:00.003 user=postgres database=postgres host=[local] TRAP: failed Assert("conflictlogrel != NULL"), File: "../src/backend/replication/logical/conflict.c", Line: 195, PID: 78486 postgres: subscriber: logical replication apply worker for subscription 16392 (ExceptionalCondition+0x53) [0x55a40e7c4ed8] postgres: subscriber: logical replication apply worker for subscription 16392 (ReportApplyConflict+0x158) [0x55a40e416637] postgres: subscriber: logical replication apply worker for subscription 16392 (+0xcaedc4) [0x55a40e104dc4] postgres: subscriber: logical replication apply worker for subscription 16392 (ExecSimpleRelationInsert+0x3d5) [0x55a40e106fd0] postgres: subscriber: logical replication apply worker for subscription 16392 (+0xffff37) [0x55a40e455f37] postgres: subscriber: logical replication apply worker for subscription 16392 (+0x1003d6a) [0x55a40e459d6a] postgres: subscriber: logical replication apply worker for subscription 16392 (apply_dispatch+0x5f) [0x55a40e45c8d8] postgres: subscriber: logical replication apply worker for subscription 16392 (+0x100736c) [0x55a40e45d36c] postgres: subscriber: logical replication apply worker for subscription 16392 (start_apply+0x57) [0x55a40e45e8b9] postgres: subscriber: logical replication apply worker for subscription 16392 (+0x100934b) [0x55a40e45f34b] postgres: subscriber: logical replication apply worker for subscription 16392 (ApplyWorkerMain+0x18) [0x55a40e45f376] postgres: subscriber: logical replication apply worker for subscription 16392 (BackgroundWorkerMain+0x330) [0x55a40e3b5927] postgres: subscriber: logical replication apply worker for subscription 16392 (postmaster_child_launch+0x1d4) [0x55a40e3bde72] postgres: subscriber: logical replication apply worker for subscription 16392 (+0xf6ba6b) [0x55a40e3c1a6b] postgres: subscriber: logical replication apply worker for subscription 16392 (+0xf6bef6) [0x55a40e3c1ef6] postgres: subscriber: logical replication apply worker for subscription 16392 (+0xf6d934) [0x55a40e3c3934] postgres: subscriber: logical replication apply worker for subscription 16392 (+0xf6f6c8) [0x55a40e3c56c8] postgres: subscriber: logical replication apply worker for subscription 16392 (PostmasterMain+0x147c) [0x55a40e3c6fa1] postgres: subscriber: logical replication apply worker for subscription 16392 (main+0x293) [0x55a40e1db0bd] /lib/x86_64-linux-gnu/libc.so.6(+0x29ca8) [0x7feae4035ca8] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85) [0x7feae4035d65] postgres: subscriber: logical replication apply worker for subscription 16392 (_start+0x21) [0x55a40dd48321] 2026-05-06 14:58:12.362 UTC client backend[78544] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:12.363 UTC client backend[78544] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/029_on_error/data/t_029_on_error_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:58:12.363 UTC client backend[78544] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=029_on_error.pl 2026-05-06 14:58:12.365 UTC client backend[78544] 029_on_error.pl LOG: connection ready: setup total=3.424 ms, fork=0.743 ms, authentication=0.317 ms 2026-05-06 14:58:12.365 UTC client backend[78544] 029_on_error.pl LOG: statement: SELECT subenabled = FALSE FROM pg_subscription WHERE subname = 'sub' 2026-05-06 14:58:12.367 UTC client backend[78544] 029_on_error.pl LOG: disconnection: session time: 0:00:00.005 user=postgres database=postgres host=[local] 2026-05-06 14:58:12.484 UTC client backend[78573] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:12.485 UTC client backend[78573] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/029_on_error/data/t_029_on_error_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:58:12.485 UTC client backend[78573] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=029_on_error.pl 2026-05-06 14:58:12.490 UTC client backend[78573] 029_on_error.pl LOG: connection ready: setup total=8.626 ms, fork=0.771 ms, authentication=0.322 ms 2026-05-06 14:58:12.490 UTC client backend[78573] 029_on_error.pl LOG: statement: SELECT subenabled = FALSE FROM pg_subscription WHERE subname = 'sub' 2026-05-06 14:58:12.493 UTC client backend[78573] 029_on_error.pl LOG: disconnection: session time: 0:00:00.010 user=postgres database=postgres host=[local] 2026-05-06 14:58:12.601 UTC postmaster[78327] LOG: background worker "logical replication apply worker" (PID 78486) was terminated by signal 6: Aborted 2026-05-06 14:58:12.601 UTC postmaster[78327] LOG: terminating any other active server processes 2026-05-06 14:58:12.609 UTC dead-end client backend[78610] [unknown] LOG: connection received: host=[local] 2026-05-06 14:58:12.609 UTC dead-end client backend[78610] [unknown] FATAL: the database system is in recovery mode 2026-05-06 14:58:12.611 UTC postmaster[78327] LOG: shutting down because "restart_after_crash" is off 2026-05-06 14:58:12.657 UTC postmaster[78327] LOG: database system is shut down