2026-05-06 14:56:27.907 UTC postmaster[59520] LOG: starting PostgreSQL 19devel on x86_64-freebsd, compiled by clang-19.1.7, 64-bit 2026-05-06 14:56:27.907 UTC postmaster[59520] LOG: listening on Unix socket "/tmp/EeZTskFv6m/.s.PGSQL.10360" 2026-05-06 14:56:27.910 UTC startup[59532] LOG: database system was shut down at 2026-05-06 14:56:27 UTC 2026-05-06 14:56:27.912 UTC postmaster[59520] LOG: database system is ready to accept connections 2026-05-06 14:56:28.012 UTC client backend[59584] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:28.013 UTC client backend[59584] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:28.013 UTC client backend[59584] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:28.019 UTC client backend[59584] 026_stats.pl LOG: connection ready: setup total=10.815 ms, fork=3.698 ms, authentication=0.179 ms 2026-05-06 14:56:28.019 UTC client backend[59584] 026_stats.pl LOG: statement: SELECT count(1) FROM pg_stat_subscription_stats 2026-05-06 14:56:28.024 UTC client backend[59584] 026_stats.pl LOG: disconnection: session time: 0:00:00.012 user=postgres database=postgres host=[local] 2026-05-06 14:56:28.053 UTC client backend[59610] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:28.054 UTC client backend[59610] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:28.054 UTC client backend[59610] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:28.054 UTC client backend[59610] 026_stats.pl LOG: connection ready: setup total=1.690 ms, fork=0.402 ms, authentication=0.153 ms 2026-05-06 14:56:28.055 UTC client backend[59610] 026_stats.pl LOG: statement: BEGIN; 2026-05-06 14:56:28.055 UTC client backend[59610] 026_stats.pl LOG: statement: CREATE TABLE test_tab1(a int primary key); 2026-05-06 14:56:28.059 UTC client backend[59610] 026_stats.pl LOG: statement: INSERT INTO test_tab1 VALUES (1); 2026-05-06 14:56:28.059 UTC client backend[59610] 026_stats.pl LOG: statement: CREATE SEQUENCE test_seq1 INCREMENT BY 10; 2026-05-06 14:56:28.061 UTC client backend[59610] 026_stats.pl LOG: statement: COMMIT; 2026-05-06 14:56:28.062 UTC client backend[59610] 026_stats.pl LOG: disconnection: session time: 0:00:00.008 user=postgres database=postgres host=[local] 2026-05-06 14:56:28.088 UTC client backend[59630] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:28.088 UTC client backend[59630] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:28.088 UTC client backend[59630] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:28.089 UTC client backend[59630] 026_stats.pl LOG: connection ready: setup total=4.279 ms, fork=2.883 ms, authentication=0.118 ms 2026-05-06 14:56:28.089 UTC client backend[59630] 026_stats.pl LOG: statement: CREATE SUBSCRIPTION test_tab1_sub CONNECTION 'port=10359 host=/tmp/EeZTskFv6m dbname=postgres' PUBLICATION test_tab1_pub, test_seq1_pub 2026-05-06 14:56:28.089 UTC client backend[59630] 026_stats.pl WARNING: subscriptions created by regression test cases should have names starting with "regress_" 2026-05-06 14:56:28.127 UTC client backend[59630] 026_stats.pl LOG: disconnection: session time: 0:00:00.039 user=postgres database=postgres host=[local] 2026-05-06 14:56:28.131 UTC logical replication apply worker[59658] LOG: logical replication apply worker for subscription "test_tab1_sub" has started 2026-05-06 14:56:28.146 UTC logical replication tablesync worker[59667] LOG: logical replication table synchronization worker for subscription "test_tab1_sub", table "test_tab1" has started 2026-05-06 14:56:28.149 UTC logical replication sequencesync worker[59668] LOG: logical replication sequence synchronization worker for subscription "test_tab1_sub" has started 2026-05-06 14:56:28.171 UTC logical replication sequencesync worker[59668] WARNING: mismatched or renamed sequence on subscriber ("public.test_seq1") 2026-05-06 14:56:28.171 UTC logical replication sequencesync worker[59668] ERROR: logical replication sequence synchronization failed for subscription "test_tab1_sub" 2026-05-06 14:56:28.179 UTC postmaster[59520] LOG: background worker "logical replication sequencesync worker" (PID 59668) exited with exit code 1 2026-05-06 14:56:28.200 UTC client backend[59697] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:28.201 UTC client backend[59697] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:28.201 UTC client backend[59697] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:28.201 UTC logical replication tablesync worker[59667] ERROR: duplicate key value violates unique constraint "test_tab1_pkey" 2026-05-06 14:56:28.201 UTC logical replication tablesync worker[59667] DETAIL: Key (a)=(1) already exists. 2026-05-06 14:56:28.201 UTC logical replication tablesync worker[59667] CONTEXT: COPY test_tab1, line 1 2026-05-06 14:56:28.201 UTC client backend[59697] 026_stats.pl LOG: connection ready: setup total=3.673 ms, fork=2.270 ms, authentication=0.110 ms 2026-05-06 14:56:28.202 UTC client backend[59697] 026_stats.pl LOG: statement: SELECT count(1) = 1 FROM pg_stat_subscription_stats WHERE subname = 'test_tab1_sub' AND sync_seq_error_count > 0 AND sync_table_error_count > 0 2026-05-06 14:56:28.205 UTC client backend[59697] 026_stats.pl LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2026-05-06 14:56:28.206 UTC postmaster[59520] LOG: background worker "logical replication tablesync worker" (PID 59667) exited with exit code 1 2026-05-06 14:56:28.221 UTC client backend[59707] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:28.222 UTC client backend[59707] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:28.222 UTC client backend[59707] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:28.222 UTC client backend[59707] 026_stats.pl LOG: connection ready: setup total=2.003 ms, fork=0.609 ms, authentication=0.117 ms 2026-05-06 14:56:28.223 UTC client backend[59707] 026_stats.pl LOG: statement: ALTER SEQUENCE test_seq1 INCREMENT 1 2026-05-06 14:56:28.226 UTC client backend[59707] 026_stats.pl LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2026-05-06 14:56:28.234 UTC client backend[59712] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:28.234 UTC client backend[59712] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:28.234 UTC client backend[59712] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:28.235 UTC client backend[59712] 026_stats.pl LOG: connection ready: setup total=2.947 ms, fork=1.400 ms, authentication=0.106 ms 2026-05-06 14:56:28.235 UTC client backend[59712] 026_stats.pl LOG: statement: SELECT count(1) = 1 FROM pg_subscription_rel WHERE srrelid = 'test_seq1'::regclass AND srsubstate = 'r' 2026-05-06 14:56:28.253 UTC client backend[59712] 026_stats.pl LOG: disconnection: session time: 0:00:00.019 user=postgres database=postgres host=[local] 2026-05-06 14:56:28.369 UTC client backend[59779] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:28.369 UTC client backend[59779] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:28.369 UTC client backend[59779] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:28.370 UTC client backend[59779] 026_stats.pl LOG: connection ready: setup total=6.393 ms, fork=4.871 ms, authentication=0.106 ms 2026-05-06 14:56:28.370 UTC client backend[59779] 026_stats.pl LOG: statement: SELECT count(1) = 1 FROM pg_subscription_rel WHERE srrelid = 'test_seq1'::regclass AND srsubstate = 'r' 2026-05-06 14:56:28.380 UTC client backend[59779] 026_stats.pl LOG: disconnection: session time: 0:00:00.011 user=postgres database=postgres host=[local] 2026-05-06 14:56:28.511 UTC client backend[59848] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:28.511 UTC client backend[59848] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:28.511 UTC client backend[59848] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:28.512 UTC client backend[59848] 026_stats.pl LOG: connection ready: setup total=15.472 ms, fork=14.062 ms, authentication=0.107 ms 2026-05-06 14:56:28.512 UTC client backend[59848] 026_stats.pl LOG: statement: SELECT count(1) = 1 FROM pg_subscription_rel WHERE srrelid = 'test_seq1'::regclass AND srsubstate = 'r' 2026-05-06 14:56:28.522 UTC client backend[59848] 026_stats.pl LOG: disconnection: session time: 0:00:00.011 user=postgres database=postgres host=[local] 2026-05-06 14:56:28.631 UTC client backend[59926] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:28.632 UTC client backend[59926] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:28.632 UTC client backend[59926] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:28.632 UTC client backend[59926] 026_stats.pl LOG: connection ready: setup total=1.907 ms, fork=0.658 ms, authentication=0.096 ms 2026-05-06 14:56:28.632 UTC client backend[59926] 026_stats.pl LOG: statement: SELECT count(1) = 1 FROM pg_subscription_rel WHERE srrelid = 'test_seq1'::regclass AND srsubstate = 'r' 2026-05-06 14:56:28.639 UTC client backend[59926] 026_stats.pl LOG: disconnection: session time: 0:00:00.008 user=postgres database=postgres host=[local] 2026-05-06 14:56:28.750 UTC client backend[59981] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:28.750 UTC client backend[59981] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:28.750 UTC client backend[59981] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:28.751 UTC client backend[59981] 026_stats.pl LOG: connection ready: setup total=1.786 ms, fork=0.484 ms, authentication=0.100 ms 2026-05-06 14:56:28.751 UTC client backend[59981] 026_stats.pl LOG: statement: SELECT count(1) = 1 FROM pg_subscription_rel WHERE srrelid = 'test_seq1'::regclass AND srsubstate = 'r' 2026-05-06 14:56:28.761 UTC client backend[59981] 026_stats.pl LOG: disconnection: session time: 0:00:00.011 user=postgres database=postgres host=[local] 2026-05-06 14:56:28.868 UTC client backend[60050] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:28.869 UTC client backend[60050] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:28.869 UTC client backend[60050] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:28.869 UTC client backend[60050] 026_stats.pl LOG: connection ready: setup total=2.061 ms, fork=0.666 ms, authentication=0.109 ms 2026-05-06 14:56:28.870 UTC client backend[60050] 026_stats.pl LOG: statement: SELECT count(1) = 1 FROM pg_subscription_rel WHERE srrelid = 'test_seq1'::regclass AND srsubstate = 'r' 2026-05-06 14:56:28.878 UTC client backend[60050] 026_stats.pl LOG: disconnection: session time: 0:00:00.009 user=postgres database=postgres host=[local] 2026-05-06 14:56:28.986 UTC client backend[60121] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:28.987 UTC client backend[60121] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:28.987 UTC client backend[60121] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:28.988 UTC client backend[60121] 026_stats.pl LOG: connection ready: setup total=2.286 ms, fork=0.994 ms, authentication=0.103 ms 2026-05-06 14:56:28.989 UTC client backend[60121] 026_stats.pl LOG: statement: SELECT count(1) = 1 FROM pg_subscription_rel WHERE srrelid = 'test_seq1'::regclass AND srsubstate = 'r' 2026-05-06 14:56:28.998 UTC client backend[60121] 026_stats.pl LOG: disconnection: session time: 0:00:00.011 user=postgres database=postgres host=[local] 2026-05-06 14:56:29.107 UTC client backend[60181] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:29.107 UTC client backend[60181] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:29.107 UTC client backend[60181] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:29.108 UTC client backend[60181] 026_stats.pl LOG: connection ready: setup total=2.154 ms, fork=0.685 ms, authentication=0.115 ms 2026-05-06 14:56:29.108 UTC client backend[60181] 026_stats.pl LOG: statement: SELECT count(1) = 1 FROM pg_subscription_rel WHERE srrelid = 'test_seq1'::regclass AND srsubstate = 'r' 2026-05-06 14:56:29.118 UTC client backend[60181] 026_stats.pl LOG: disconnection: session time: 0:00:00.011 user=postgres database=postgres host=[local] 2026-05-06 14:56:29.221 UTC logical replication tablesync worker[60237] LOG: logical replication table synchronization worker for subscription "test_tab1_sub", table "test_tab1" has started 2026-05-06 14:56:29.233 UTC client backend[60246] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:29.233 UTC client backend[60246] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:29.233 UTC client backend[60246] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:29.234 UTC logical replication sequencesync worker[60244] LOG: logical replication sequence synchronization worker for subscription "test_tab1_sub" has started 2026-05-06 14:56:29.234 UTC client backend[60246] 026_stats.pl LOG: connection ready: setup total=2.993 ms, fork=1.600 ms, authentication=0.105 ms 2026-05-06 14:56:29.234 UTC client backend[60246] 026_stats.pl LOG: statement: SELECT count(1) = 1 FROM pg_subscription_rel WHERE srrelid = 'test_seq1'::regclass AND srsubstate = 'r' 2026-05-06 14:56:29.243 UTC client backend[60246] 026_stats.pl LOG: disconnection: session time: 0:00:00.009 user=postgres database=postgres host=[local] 2026-05-06 14:56:29.247 UTC logical replication sequencesync worker[60244] LOG: logical replication sequence synchronization worker for subscription "test_tab1_sub" has finished 2026-05-06 14:56:29.278 UTC logical replication tablesync worker[60237] ERROR: duplicate key value violates unique constraint "test_tab1_pkey" 2026-05-06 14:56:29.278 UTC logical replication tablesync worker[60237] DETAIL: Key (a)=(1) already exists. 2026-05-06 14:56:29.278 UTC logical replication tablesync worker[60237] CONTEXT: COPY test_tab1, line 1 2026-05-06 14:56:29.282 UTC postmaster[59520] LOG: background worker "logical replication tablesync worker" (PID 60237) exited with exit code 1 2026-05-06 14:56:29.357 UTC client backend[60318] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:29.359 UTC client backend[60318] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:29.359 UTC client backend[60318] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:29.360 UTC client backend[60318] 026_stats.pl LOG: connection ready: setup total=3.147 ms, fork=0.530 ms, authentication=0.110 ms 2026-05-06 14:56:29.360 UTC client backend[60318] 026_stats.pl LOG: statement: SELECT count(1) = 1 FROM pg_subscription_rel WHERE srrelid = 'test_seq1'::regclass AND srsubstate = 'r' 2026-05-06 14:56:29.373 UTC client backend[60318] 026_stats.pl LOG: disconnection: session time: 0:00:00.016 user=postgres database=postgres host=[local] 2026-05-06 14:56:29.383 UTC client backend[60331] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:29.384 UTC client backend[60331] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:29.384 UTC client backend[60331] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:29.384 UTC client backend[60331] 026_stats.pl LOG: connection ready: setup total=2.336 ms, fork=0.951 ms, authentication=0.115 ms 2026-05-06 14:56:29.384 UTC client backend[60331] 026_stats.pl LOG: statement: TRUNCATE test_tab1 2026-05-06 14:56:29.386 UTC client backend[60331] 026_stats.pl LOG: disconnection: session time: 0:00:00.003 user=postgres database=postgres host=[local] 2026-05-06 14:56:29.397 UTC client backend[60339] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:29.398 UTC client backend[60339] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:29.398 UTC client backend[60339] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:29.398 UTC client backend[60339] 026_stats.pl LOG: connection ready: setup total=4.146 ms, fork=2.711 ms, authentication=0.128 ms 2026-05-06 14:56:29.398 UTC client backend[60339] 026_stats.pl LOG: statement: SELECT count(1) = 1 FROM pg_subscription_rel WHERE srrelid = 'test_tab1'::regclass AND srsubstate in ('r', 's') 2026-05-06 14:56:29.414 UTC client backend[60339] 026_stats.pl LOG: disconnection: session time: 0:00:00.016 user=postgres database=postgres host=[local] 2026-05-06 14:56:29.526 UTC client backend[60403] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:29.527 UTC client backend[60403] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:29.527 UTC client backend[60403] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:29.527 UTC client backend[60403] 026_stats.pl LOG: connection ready: setup total=2.074 ms, fork=0.697 ms, authentication=0.138 ms 2026-05-06 14:56:29.528 UTC client backend[60403] 026_stats.pl LOG: statement: SELECT count(1) = 1 FROM pg_subscription_rel WHERE srrelid = 'test_tab1'::regclass AND srsubstate in ('r', 's') 2026-05-06 14:56:29.540 UTC client backend[60403] 026_stats.pl LOG: disconnection: session time: 0:00:00.013 user=postgres database=postgres host=[local] 2026-05-06 14:56:29.658 UTC client backend[60467] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:29.658 UTC client backend[60467] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:29.658 UTC client backend[60467] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:29.659 UTC client backend[60467] 026_stats.pl LOG: connection ready: setup total=4.516 ms, fork=3.064 ms, authentication=0.120 ms 2026-05-06 14:56:29.659 UTC client backend[60467] 026_stats.pl LOG: statement: SELECT count(1) = 1 FROM pg_subscription_rel WHERE srrelid = 'test_tab1'::regclass AND srsubstate in ('r', 's') 2026-05-06 14:56:29.668 UTC client backend[60467] 026_stats.pl LOG: disconnection: session time: 0:00:00.010 user=postgres database=postgres host=[local] 2026-05-06 14:56:29.782 UTC client backend[60532] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:29.783 UTC client backend[60532] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:29.783 UTC client backend[60532] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:29.784 UTC client backend[60532] 026_stats.pl LOG: connection ready: setup total=2.532 ms, fork=1.275 ms, authentication=0.101 ms 2026-05-06 14:56:29.784 UTC client backend[60532] 026_stats.pl LOG: statement: SELECT count(1) = 1 FROM pg_subscription_rel WHERE srrelid = 'test_tab1'::regclass AND srsubstate in ('r', 's') 2026-05-06 14:56:29.798 UTC client backend[60532] 026_stats.pl LOG: disconnection: session time: 0:00:00.015 user=postgres database=postgres host=[local] 2026-05-06 14:56:29.908 UTC client backend[60597] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:29.909 UTC client backend[60597] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:29.909 UTC client backend[60597] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:29.910 UTC client backend[60597] 026_stats.pl LOG: connection ready: setup total=3.257 ms, fork=1.933 ms, authentication=0.099 ms 2026-05-06 14:56:29.910 UTC client backend[60597] 026_stats.pl LOG: statement: SELECT count(1) = 1 FROM pg_subscription_rel WHERE srrelid = 'test_tab1'::regclass AND srsubstate in ('r', 's') 2026-05-06 14:56:29.920 UTC client backend[60597] 026_stats.pl LOG: disconnection: session time: 0:00:00.011 user=postgres database=postgres host=[local] 2026-05-06 14:56:30.057 UTC client backend[60656] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:30.057 UTC client backend[60656] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:30.057 UTC client backend[60656] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:30.058 UTC client backend[60656] 026_stats.pl LOG: connection ready: setup total=15.031 ms, fork=13.621 ms, authentication=0.105 ms 2026-05-06 14:56:30.058 UTC client backend[60656] 026_stats.pl LOG: statement: SELECT count(1) = 1 FROM pg_subscription_rel WHERE srrelid = 'test_tab1'::regclass AND srsubstate in ('r', 's') 2026-05-06 14:56:30.067 UTC client backend[60656] 026_stats.pl LOG: disconnection: session time: 0:00:00.011 user=postgres database=postgres host=[local] 2026-05-06 14:56:30.184 UTC client backend[60707] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:30.184 UTC client backend[60707] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:30.184 UTC client backend[60707] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:30.185 UTC client backend[60707] 026_stats.pl LOG: connection ready: setup total=1.986 ms, fork=0.596 ms, authentication=0.096 ms 2026-05-06 14:56:30.185 UTC client backend[60707] 026_stats.pl LOG: statement: SELECT count(1) = 1 FROM pg_subscription_rel WHERE srrelid = 'test_tab1'::regclass AND srsubstate in ('r', 's') 2026-05-06 14:56:30.194 UTC client backend[60707] 026_stats.pl LOG: disconnection: session time: 0:00:00.010 user=postgres database=postgres host=[local] 2026-05-06 14:56:30.297 UTC logical replication tablesync worker[60757] LOG: logical replication table synchronization worker for subscription "test_tab1_sub", table "test_tab1" has started 2026-05-06 14:56:30.311 UTC client backend[60766] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:30.312 UTC client backend[60766] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:30.312 UTC client backend[60766] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:30.312 UTC client backend[60766] 026_stats.pl LOG: connection ready: setup total=2.029 ms, fork=0.664 ms, authentication=0.103 ms 2026-05-06 14:56:30.313 UTC client backend[60766] 026_stats.pl LOG: statement: SELECT count(1) = 1 FROM pg_subscription_rel WHERE srrelid = 'test_tab1'::regclass AND srsubstate in ('r', 's') 2026-05-06 14:56:30.332 UTC client backend[60766] 026_stats.pl LOG: disconnection: session time: 0:00:00.020 user=postgres database=postgres host=[local] 2026-05-06 14:56:30.389 UTC logical replication tablesync worker[60757] LOG: logical replication table synchronization worker for subscription "test_tab1_sub", table "test_tab1" has finished 2026-05-06 14:56:30.446 UTC client backend[60825] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:30.447 UTC client backend[60825] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:30.447 UTC client backend[60825] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:30.447 UTC client backend[60825] 026_stats.pl LOG: connection ready: setup total=2.926 ms, fork=1.567 ms, authentication=0.103 ms 2026-05-06 14:56:30.448 UTC client backend[60825] 026_stats.pl LOG: statement: SELECT count(1) = 1 FROM pg_subscription_rel WHERE srrelid = 'test_tab1'::regclass AND srsubstate in ('r', 's') 2026-05-06 14:56:30.456 UTC client backend[60825] 026_stats.pl LOG: disconnection: session time: 0:00:00.009 user=postgres database=postgres host=[local] 2026-05-06 14:56:30.465 UTC client backend[60835] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:30.465 UTC client backend[60835] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:30.465 UTC client backend[60835] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:30.466 UTC client backend[60835] 026_stats.pl LOG: connection ready: setup total=1.790 ms, fork=0.615 ms, authentication=0.087 ms 2026-05-06 14:56:30.466 UTC client backend[60835] 026_stats.pl LOG: statement: SELECT a FROM test_tab1 2026-05-06 14:56:30.473 UTC client backend[60835] 026_stats.pl LOG: disconnection: session time: 0:00:00.008 user=postgres database=postgres host=[local] TRAP: failed Assert("conflictlogrel != NULL"), File: "../src/backend/replication/logical/conflict.c", Line: 195, PID: 59658 0xb3a472 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x9433b8 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x7d91fb at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x7d8b4b at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x96525b at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x966150 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x967010 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x966d6d at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x90ff0c at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x914a25 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x917b77 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x9198f5 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x917156 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x83c16d at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x82c272e34 <__libc_start1+0x124> at /lib/libc.so.7 2026-05-06 14:56:30.496 UTC client backend[60852] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:30.499 UTC client backend[60852] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:30.499 UTC client backend[60852] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:30.500 UTC client backend[60852] 026_stats.pl LOG: connection ready: setup total=5.724 ms, fork=0.963 ms, authentication=0.113 ms 2026-05-06 14:56:30.501 UTC client backend[60852] 026_stats.pl LOG: statement: SELECT apply_error_count > 0 AND confl_insert_exists > 0 FROM pg_stat_subscription_stats WHERE subname = 'test_tab1_sub' 2026-05-06 14:56:30.504 UTC client backend[60852] 026_stats.pl LOG: disconnection: session time: 0:00:00.008 user=postgres database=postgres host=[local] 2026-05-06 14:56:30.617 UTC client backend[60900] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:30.617 UTC client backend[60900] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:30.617 UTC client backend[60900] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:30.618 UTC client backend[60900] 026_stats.pl LOG: connection ready: setup total=2.790 ms, fork=1.403 ms, authentication=0.104 ms 2026-05-06 14:56:30.618 UTC client backend[60900] 026_stats.pl LOG: statement: SELECT apply_error_count > 0 AND confl_insert_exists > 0 FROM pg_stat_subscription_stats WHERE subname = 'test_tab1_sub' 2026-05-06 14:56:30.621 UTC client backend[60900] 026_stats.pl LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2026-05-06 14:56:30.742 UTC client backend[60951] [unknown] LOG: connection received: host=[local] 2026-05-06 14:56:30.742 UTC client backend[60951] [unknown] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2026-05-06 14:56:30.742 UTC client backend[60951] [unknown] LOG: connection authorized: user=postgres database=postgres application_name=026_stats.pl 2026-05-06 14:56:30.743 UTC client backend[60951] 026_stats.pl LOG: connection ready: setup total=2.664 ms, fork=1.299 ms, authentication=0.159 ms 2026-05-06 14:56:30.743 UTC client backend[60951] 026_stats.pl LOG: statement: SELECT apply_error_count > 0 AND confl_insert_exists > 0 FROM pg_stat_subscription_stats WHERE subname = 'test_tab1_sub' 2026-05-06 14:56:30.746 UTC client backend[60951] 026_stats.pl LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2026-05-06 14:56:30.857 UTC postmaster[59520] LOG: background worker "logical replication apply worker" (PID 59658) was terminated by signal 6: Abort trap 2026-05-06 14:56:30.857 UTC postmaster[59520] LOG: terminating any other active server processes 2026-05-06 14:56:30.862 UTC postmaster[59520] LOG: shutting down because "restart_after_crash" is off 2026-05-06 14:56:30.863 UTC postmaster[59520] LOG: database system is shut down