2025-03-05 13:40:41.905 UTC [35985][postmaster] LOG:  starting PostgreSQL 18devel on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-03-05 13:40:41.905 UTC [35985][postmaster] LOG:  listening on Unix socket "/tmp/cTqa5GNorI/.s.PGSQL.11021"
2025-03-05 13:40:41.913 UTC [35996][startup] LOG:  database system was shut down at 2025-03-05 13:38:14 UTC
2025-03-05 13:40:41.922 UTC [35985][postmaster] LOG:  database system is ready to accept connections
2025-03-05 13:40:42.118 UTC [36024][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:42.119 UTC [36024][client backend] [[unknown]][0/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:42.119 UTC [36024][client backend] [[unknown]][0/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:42.157 UTC [36024][client backend] [004_sync.pl][0/2:0] LOG:  statement: CREATE TABLE tab_rep (a int primary key)
2025-03-05 13:40:42.178 UTC [36024][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.067 user=postgres database=postgres host=[local]
2025-03-05 13:40:42.246 UTC [36048][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:42.247 UTC [36048][client backend] [[unknown]][1/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:42.247 UTC [36048][client backend] [[unknown]][1/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:42.250 UTC [36048][client backend] [004_sync.pl][1/2:0] LOG:  statement: CREATE SUBSCRIPTION tap_sub CONNECTION 'port=11020 host=/tmp/cTqa5GNorI dbname=postgres' PUBLICATION tap_pub
2025-03-05 13:40:42.425 UTC [36048][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.179 user=postgres database=postgres host=[local]
2025-03-05 13:40:42.471 UTC [36069][logical replication apply worker] LOG:  logical replication apply worker for subscription "tap_sub" has started
2025-03-05 13:40:42.482 UTC [36074][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:42.484 UTC [36074][client backend] [[unknown]][2/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:42.484 UTC [36074][client backend] [[unknown]][2/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:42.491 UTC [36074][client backend] [004_sync.pl][2/2:0] LOG:  statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's');
2025-03-05 13:40:42.497 UTC [36074][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.016 user=postgres database=postgres host=[local]
2025-03-05 13:40:42.528 UTC [36078][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tap_sub", table "tab_rep" has started
2025-03-05 13:40:42.647 UTC [36078][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tap_sub", table "tab_rep" has finished
2025-03-05 13:40:42.677 UTC [36093][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:42.678 UTC [36093][client backend] [[unknown]][3/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:42.678 UTC [36093][client backend] [[unknown]][3/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:42.680 UTC [36093][client backend] [004_sync.pl][3/2:0] LOG:  statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's');
2025-03-05 13:40:42.683 UTC [36093][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.018 user=postgres database=postgres host=[local]
2025-03-05 13:40:42.977 UTC [36144][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:42.978 UTC [36144][client backend] [[unknown]][4/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:42.978 UTC [36144][client backend] [[unknown]][4/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:42.981 UTC [36144][client backend] [004_sync.pl][4/2:0] LOG:  statement: SELECT count(*) FROM tab_rep
2025-03-05 13:40:42.986 UTC [36144][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.017 user=postgres database=postgres host=[local]
2025-03-05 13:40:43.012 UTC [36158][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:43.013 UTC [36158][client backend] [[unknown]][5/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:43.013 UTC [36158][client backend] [[unknown]][5/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:43.015 UTC [36158][client backend] [004_sync.pl][5/2:0] LOG:  statement: DROP SUBSCRIPTION tap_sub
2025-03-05 13:40:43.016 UTC [36069][logical replication apply worker] FATAL:  terminating logical replication worker due to administrator command
2025-03-05 13:40:43.033 UTC [35985][postmaster] LOG:  background worker "logical replication apply worker" (PID 36069) exited with exit code 1
2025-03-05 13:40:43.045 UTC [36158][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.033 user=postgres database=postgres host=[local]
2025-03-05 13:40:43.164 UTC [36185][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:43.166 UTC [36185][client backend] [[unknown]][6/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:43.166 UTC [36185][client backend] [[unknown]][6/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:43.170 UTC [36185][client backend] [004_sync.pl][6/2:0] LOG:  statement: CREATE SUBSCRIPTION tap_sub CONNECTION 'port=11020 host=/tmp/cTqa5GNorI dbname=postgres' PUBLICATION tap_pub
2025-03-05 13:40:43.217 UTC [36185][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.053 user=postgres database=postgres host=[local]
2025-03-05 13:40:43.243 UTC [36193][logical replication apply worker] LOG:  logical replication apply worker for subscription "tap_sub" has started
2025-03-05 13:40:43.250 UTC [36198][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:43.254 UTC [36198][client backend] [[unknown]][7/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:43.254 UTC [36198][client backend] [[unknown]][7/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:43.256 UTC [36198][client backend] [004_sync.pl][7/2:0] LOG:  statement: SELECT srsubstate = 'd' FROM pg_subscription_rel;
2025-03-05 13:40:43.264 UTC [36198][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.014 user=postgres database=postgres host=[local]
2025-03-05 13:40:43.291 UTC [36200][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tap_sub", table "tab_rep" has started
2025-03-05 13:40:43.360 UTC [36200][logical replication tablesync worker] ERROR:  duplicate key value violates unique constraint "tab_rep_pkey"
2025-03-05 13:40:43.360 UTC [36200][logical replication tablesync worker] DETAIL:  Key (a)=(1) already exists.
2025-03-05 13:40:43.360 UTC [36200][logical replication tablesync worker] CONTEXT:  COPY tab_rep, line 1
2025-03-05 13:40:43.371 UTC [35985][postmaster] LOG:  background worker "logical replication tablesync worker" (PID 36200) exited with exit code 1
2025-03-05 13:40:43.395 UTC [36211][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tap_sub", table "tab_rep" has started
2025-03-05 13:40:43.420 UTC [36219][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:43.421 UTC [36219][client backend] [[unknown]][8/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:43.421 UTC [36219][client backend] [[unknown]][8/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:43.425 UTC [36219][client backend] [004_sync.pl][8/2:0] LOG:  statement: SELECT srsubstate = 'd' FROM pg_subscription_rel;
2025-03-05 13:40:43.430 UTC [36219][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.011 user=postgres database=postgres host=[local]
2025-03-05 13:40:43.458 UTC [36211][logical replication tablesync worker] ERROR:  duplicate key value violates unique constraint "tab_rep_pkey"
2025-03-05 13:40:43.458 UTC [36211][logical replication tablesync worker] DETAIL:  Key (a)=(1) already exists.
2025-03-05 13:40:43.458 UTC [36211][logical replication tablesync worker] CONTEXT:  COPY tab_rep, line 1
2025-03-05 13:40:43.469 UTC [35985][postmaster] LOG:  background worker "logical replication tablesync worker" (PID 36211) exited with exit code 1
2025-03-05 13:40:43.478 UTC [36225][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:43.480 UTC [36225][client backend] [[unknown]][9/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:43.480 UTC [36225][client backend] [[unknown]][9/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:43.483 UTC [36227][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tap_sub", table "tab_rep" has started
2025-03-05 13:40:43.485 UTC [36225][client backend] [004_sync.pl][9/2:0] LOG:  statement: DELETE FROM tab_rep;
2025-03-05 13:40:43.489 UTC [36225][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.020 user=postgres database=postgres host=[local]
2025-03-05 13:40:43.530 UTC [36234][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:43.538 UTC [36234][client backend] [[unknown]][10/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:43.538 UTC [36234][client backend] [[unknown]][10/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:43.541 UTC [36234][client backend] [004_sync.pl][10/2:0] LOG:  statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's');
2025-03-05 13:40:43.550 UTC [36234][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.020 user=postgres database=postgres host=[local]
2025-03-05 13:40:43.586 UTC [36227][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tap_sub", table "tab_rep" has finished
2025-03-05 13:40:43.708 UTC [36250][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:43.710 UTC [36250][client backend] [[unknown]][11/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:43.710 UTC [36250][client backend] [[unknown]][11/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:43.712 UTC [36250][client backend] [004_sync.pl][11/2:0] LOG:  statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's');
2025-03-05 13:40:43.720 UTC [36250][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.023 user=postgres database=postgres host=[local]
2025-03-05 13:40:43.768 UTC [36259][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:43.769 UTC [36259][client backend] [[unknown]][12/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:43.769 UTC [36259][client backend] [[unknown]][12/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:43.778 UTC [36259][client backend] [004_sync.pl][12/2:0] LOG:  statement: SELECT count(*) FROM tab_rep
2025-03-05 13:40:43.787 UTC [36259][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.022 user=postgres database=postgres host=[local]
2025-03-05 13:40:43.847 UTC [36269][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:43.849 UTC [36269][client backend] [[unknown]][13/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:43.849 UTC [36269][client backend] [[unknown]][13/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:43.854 UTC [36269][client backend] [004_sync.pl][13/2:0] LOG:  statement: CREATE SUBSCRIPTION tap_sub2 CONNECTION 'port=11020 host=/tmp/cTqa5GNorI dbname=postgres' PUBLICATION tap_pub WITH (copy_data = false)
2025-03-05 13:40:43.961 UTC [36269][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.114 user=postgres database=postgres host=[local]
2025-03-05 13:40:43.968 UTC [36293][logical replication apply worker] LOG:  logical replication apply worker for subscription "tap_sub2" has started
2025-03-05 13:40:43.994 UTC [36299][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:43.995 UTC [36299][client backend] [[unknown]][14/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:43.995 UTC [36299][client backend] [[unknown]][14/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:43.998 UTC [36299][client backend] [004_sync.pl][14/2:0] LOG:  statement: SELECT pid IS NOT NULL FROM pg_stat_subscription WHERE subname = 'tap_sub2' AND worker_type = 'apply'
2025-03-05 13:40:44.007 UTC [36299][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.013 user=postgres database=postgres host=[local]
2025-03-05 13:40:44.033 UTC [36306][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:44.034 UTC [36306][client backend] [[unknown]][15/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:44.034 UTC [36306][client backend] [[unknown]][15/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:44.036 UTC [36306][client backend] [004_sync.pl][15/2:0] LOG:  statement: DROP SUBSCRIPTION tap_sub
2025-03-05 13:40:44.036 UTC [36193][logical replication apply worker] FATAL:  terminating logical replication worker due to administrator command
2025-03-05 13:40:44.050 UTC [35985][postmaster] LOG:  background worker "logical replication apply worker" (PID 36193) exited with exit code 1
2025-03-05 13:40:44.067 UTC [36306][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.034 user=postgres database=postgres host=[local]
2025-03-05 13:40:44.129 UTC [36316][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:44.130 UTC [36316][client backend] [[unknown]][16/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:44.130 UTC [36316][client backend] [[unknown]][16/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:44.137 UTC [36316][client backend] [004_sync.pl][16/2:0] LOG:  statement: DROP SUBSCRIPTION tap_sub2
2025-03-05 13:40:44.137 UTC [36293][logical replication apply worker] FATAL:  terminating logical replication worker due to administrator command
2025-03-05 13:40:44.154 UTC [35985][postmaster] LOG:  background worker "logical replication apply worker" (PID 36293) exited with exit code 1
2025-03-05 13:40:44.162 UTC [36316][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.036 user=postgres database=postgres host=[local]
2025-03-05 13:40:44.206 UTC [36327][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:44.208 UTC [36327][client backend] [[unknown]][17/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:44.208 UTC [36327][client backend] [[unknown]][17/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:44.210 UTC [36327][client backend] [004_sync.pl][17/2:0] LOG:  statement: SELECT count(*) FROM pg_subscription
2025-03-05 13:40:44.219 UTC [36327][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.013 user=postgres database=postgres host=[local]
2025-03-05 13:40:44.276 UTC [36332][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:44.277 UTC [36332][client backend] [[unknown]][18/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:44.277 UTC [36332][client backend] [[unknown]][18/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:44.288 UTC [36332][client backend] [004_sync.pl][18/2:0] LOG:  statement: DELETE FROM tab_rep;
2025-03-05 13:40:44.295 UTC [36332][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.021 user=postgres database=postgres host=[local]
2025-03-05 13:40:44.325 UTC [36338][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:44.326 UTC [36338][client backend] [[unknown]][19/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:44.326 UTC [36338][client backend] [[unknown]][19/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:44.329 UTC [36338][client backend] [004_sync.pl][19/2:0] LOG:  statement: CREATE SUBSCRIPTION tap_sub CONNECTION 'port=11020 host=/tmp/cTqa5GNorI dbname=postgres' PUBLICATION tap_pub
2025-03-05 13:40:44.440 UTC [36338][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.118 user=postgres database=postgres host=[local]
2025-03-05 13:40:44.452 UTC [36350][logical replication apply worker] LOG:  logical replication apply worker for subscription "tap_sub" has started
2025-03-05 13:40:44.488 UTC [36357][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:44.491 UTC [36357][client backend] [[unknown]][20/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:44.491 UTC [36357][client backend] [[unknown]][20/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:44.496 UTC [36357][client backend] [004_sync.pl][20/2:0] LOG:  statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's');
2025-03-05 13:40:44.507 UTC [36357][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.020 user=postgres database=postgres host=[local]
2025-03-05 13:40:44.521 UTC [36359][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tap_sub", table "tab_rep" has started
2025-03-05 13:40:44.617 UTC [36359][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tap_sub", table "tab_rep" has finished
2025-03-05 13:40:44.671 UTC [36382][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:44.673 UTC [36382][client backend] [[unknown]][21/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:44.673 UTC [36382][client backend] [[unknown]][21/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:44.675 UTC [36382][client backend] [004_sync.pl][21/2:0] LOG:  statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's');
2025-03-05 13:40:44.683 UTC [36382][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.012 user=postgres database=postgres host=[local]
2025-03-05 13:40:44.761 UTC [36392][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:44.762 UTC [36392][client backend] [[unknown]][22/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:44.762 UTC [36392][client backend] [[unknown]][22/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:44.772 UTC [36392][client backend] [004_sync.pl][22/2:0] LOG:  statement: SELECT count(*) FROM tab_rep
2025-03-05 13:40:44.778 UTC [36392][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.026 user=postgres database=postgres host=[local]
2025-03-05 13:40:44.813 UTC [36397][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:44.814 UTC [36397][client backend] [[unknown]][23/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:44.814 UTC [36397][client backend] [[unknown]][23/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:44.821 UTC [36397][client backend] [004_sync.pl][23/2:0] LOG:  statement: CREATE TABLE tab_rep_next (a int)
2025-03-05 13:40:44.833 UTC [36397][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.020 user=postgres database=postgres host=[local]
2025-03-05 13:40:45.164 UTC [36442][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:45.165 UTC [36442][client backend] [[unknown]][24/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:45.165 UTC [36442][client backend] [[unknown]][24/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:45.176 UTC [36442][client backend] [004_sync.pl][24/2:0] LOG:  statement: SELECT count(*) FROM tab_rep_next
2025-03-05 13:40:45.178 UTC [36442][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.019 user=postgres database=postgres host=[local]
2025-03-05 13:40:45.217 UTC [36448][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:45.218 UTC [36448][client backend] [[unknown]][25/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:45.218 UTC [36448][client backend] [[unknown]][25/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:45.220 UTC [36448][client backend] [004_sync.pl][25/2:0] LOG:  statement: ALTER SUBSCRIPTION tap_sub REFRESH PUBLICATION
2025-03-05 13:40:45.264 UTC [36448][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.050 user=postgres database=postgres host=[local]
2025-03-05 13:40:45.291 UTC [36455][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tap_sub", table "tab_rep_next" has started
2025-03-05 13:40:45.308 UTC [36461][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:45.329 UTC [36461][client backend] [[unknown]][26/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:45.329 UTC [36461][client backend] [[unknown]][26/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:45.331 UTC [36461][client backend] [004_sync.pl][26/2:0] LOG:  statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's');
2025-03-05 13:40:45.338 UTC [36461][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.031 user=postgres database=postgres host=[local]
2025-03-05 13:40:45.428 UTC [36455][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tap_sub", table "tab_rep_next" has finished
2025-03-05 13:40:45.521 UTC [36482][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:45.522 UTC [36482][client backend] [[unknown]][27/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:45.522 UTC [36482][client backend] [[unknown]][27/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:45.525 UTC [36482][client backend] [004_sync.pl][27/2:0] LOG:  statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's');
2025-03-05 13:40:45.533 UTC [36482][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.023 user=postgres database=postgres host=[local]
2025-03-05 13:40:45.564 UTC [36490][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:45.565 UTC [36490][client backend] [[unknown]][28/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:45.565 UTC [36490][client backend] [[unknown]][28/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:45.567 UTC [36490][client backend] [004_sync.pl][28/2:0] LOG:  statement: SELECT count(*) FROM tab_rep_next
2025-03-05 13:40:45.572 UTC [36490][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.008 user=postgres database=postgres host=[local]
2025-03-05 13:40:45.835 UTC [36519][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:45.837 UTC [36519][client backend] [[unknown]][29/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:45.837 UTC [36519][client backend] [[unknown]][29/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:45.841 UTC [36519][client backend] [004_sync.pl][29/2:0] LOG:  statement: SELECT count(*) FROM tab_rep_next
2025-03-05 13:40:45.847 UTC [36519][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.012 user=postgres database=postgres host=[local]
2025-03-05 13:40:45.956 UTC [36541][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:45.958 UTC [36541][client backend] [[unknown]][30/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:45.958 UTC [36541][client backend] [[unknown]][30/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:45.960 UTC [36541][client backend] [004_sync.pl][30/2:0] LOG:  statement: DROP TABLE tab_rep_next
2025-03-05 13:40:45.975 UTC [36541][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.019 user=postgres database=postgres host=[local]
2025-03-05 13:40:46.021 UTC [36551][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:46.022 UTC [36551][client backend] [[unknown]][31/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:46.022 UTC [36551][client backend] [[unknown]][31/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:46.028 UTC [36551][client backend] [004_sync.pl][31/2:0] LOG:  statement: DROP SUBSCRIPTION tap_sub
2025-03-05 13:40:46.029 UTC [36350][logical replication apply worker] FATAL:  terminating logical replication worker due to administrator command
2025-03-05 13:40:46.045 UTC [35985][postmaster] LOG:  background worker "logical replication apply worker" (PID 36350) exited with exit code 1
2025-03-05 13:40:46.056 UTC [36551][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.037 user=postgres database=postgres host=[local]
2025-03-05 13:40:46.120 UTC [36561][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:46.129 UTC [36561][client backend] [[unknown]][32/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:46.129 UTC [36561][client backend] [[unknown]][32/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:46.131 UTC [36561][client backend] [004_sync.pl][32/2:0] LOG:  statement: CREATE SUBSCRIPTION tap_sub CONNECTION 'port=11020 host=/tmp/cTqa5GNorI dbname=postgres' PUBLICATION tap_pub
2025-03-05 13:40:46.245 UTC [36561][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.126 user=postgres database=postgres host=[local]
2025-03-05 13:40:46.272 UTC [36578][logical replication apply worker] LOG:  logical replication apply worker for subscription "tap_sub" has started
2025-03-05 13:40:46.295 UTC [36582][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:46.297 UTC [36582][client backend] [[unknown]][33/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:46.297 UTC [36582][client backend] [[unknown]][33/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:46.299 UTC [36582][client backend] [004_sync.pl][33/2:0] LOG:  statement: SELECT srsubstate = 'd' FROM pg_subscription_rel;
2025-03-05 13:40:46.304 UTC [36582][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.010 user=postgres database=postgres host=[local]
2025-03-05 13:40:46.333 UTC [36583][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tap_sub", table "tab_rep" has started
2025-03-05 13:40:46.441 UTC [36626][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:46.444 UTC [36626][client backend] [[unknown]][34/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:46.444 UTC [36626][client backend] [[unknown]][34/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:46.445 UTC [36583][logical replication tablesync worker] ERROR:  duplicate key value violates unique constraint "tab_rep_pkey"
2025-03-05 13:40:46.445 UTC [36583][logical replication tablesync worker] DETAIL:  Key (a)=(1) already exists.
2025-03-05 13:40:46.445 UTC [36583][logical replication tablesync worker] CONTEXT:  COPY tab_rep, line 1
2025-03-05 13:40:46.446 UTC [36626][client backend] [004_sync.pl][34/2:0] LOG:  statement: SELECT srsubstate = 'd' FROM pg_subscription_rel;
2025-03-05 13:40:46.448 UTC [36626][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.007 user=postgres database=postgres host=[local]
2025-03-05 13:40:46.461 UTC [35985][postmaster] LOG:  background worker "logical replication tablesync worker" (PID 36583) exited with exit code 1
2025-03-05 13:40:46.512 UTC [36634][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tap_sub", table "tab_rep" has started
2025-03-05 13:40:46.545 UTC [36640][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-03-05 13:40:46.546 UTC [36640][client backend] [[unknown]][35/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2025-03-05 13:40:46.546 UTC [36640][client backend] [[unknown]][35/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=004_sync.pl
2025-03-05 13:40:46.549 UTC [36640][client backend] [004_sync.pl][35/2:0] LOG:  statement: DROP SUBSCRIPTION tap_sub
2025-03-05 13:40:46.550 UTC [36578][logical replication apply worker] FATAL:  terminating logical replication worker due to administrator command
2025-03-05 13:40:46.560 UTC [36634][logical replication tablesync worker] FATAL:  terminating logical replication worker due to administrator command
2025-03-05 13:40:46.560 UTC [35985][postmaster] LOG:  background worker "logical replication apply worker" (PID 36578) exited with exit code 1
2025-03-05 13:40:46.576 UTC [35985][postmaster] LOG:  background worker "logical replication tablesync worker" (PID 36634) exited with exit code 1
2025-03-05 13:40:46.590 UTC [36640][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.047 user=postgres database=postgres host=[local]
2025-03-05 13:40:46.694 UTC [35985][postmaster] LOG:  received fast shutdown request
2025-03-05 13:40:46.695 UTC [35985][postmaster] LOG:  aborting any active transactions
2025-03-05 13:40:46.710 UTC [35985][postmaster] LOG:  background worker "logical replication launcher" (PID 36000) exited with exit code 1
2025-03-05 13:40:46.710 UTC [35994][checkpointer] LOG:  shutting down
2025-03-05 13:40:46.710 UTC [35994][checkpointer] LOG:  checkpoint starting: shutdown immediate
2025-03-05 13:40:46.712 UTC [35994][checkpointer] LOG:  checkpoint complete: wrote 50 buffers (0.3%), wrote 3 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.003 s; sync files=0, longest=0.000 s, average=0.000 s; distance=163 kB, estimate=163 kB; lsn=0/17B3370, redo lsn=0/17B3370
TRAP: failed Assert("!pgStatLocal.shmem->is_shutdown"), File: "pgstat.c", Line: 746, PID: 35994
/lib/x86_64-linux-gnu/libasan.so.8(+0x51f31)[0x7fa8ffe51f31]
postgres: subscriber: checkpointer (ExceptionalCondition+0xe6)[0x55936bbf1ac5]
postgres: subscriber: checkpointer (pgstat_report_stat+0x17e)[0x55936b910c2c]
postgres: subscriber: checkpointer (+0xe96ed6)[0x55936b910ed6]
postgres: subscriber: checkpointer (shmem_exit+0x6b)[0x55936b85ea89]
postgres: subscriber: checkpointer (+0xde4d27)[0x55936b85ed27]
postgres: subscriber: checkpointer (proc_exit+0x3d)[0x55936b85ee53]
postgres: subscriber: checkpointer (CheckpointWriteDelay+0x0)[0x55936b722196]
postgres: subscriber: checkpointer (postmaster_child_launch+0x1f1)[0x55936b722a53]
postgres: subscriber: checkpointer (+0xcaed1d)[0x55936b728d1d]
postgres: subscriber: checkpointer (PostmasterMain+0x1e36)[0x55936b72d87f]
postgres: subscriber: checkpointer (main+0x2a2)[0x55936b4c90be]
/lib/x86_64-linux-gnu/libc.so.6(+0x2724a)[0x7fa8fed7824a]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85)[0x7fa8fed78305]
postgres: subscriber: checkpointer (_start+0x21)[0x55936ae9e3a1]
2025-03-05 13:40:49.031 UTC [35985][postmaster] LOG:  checkpointer process (PID 35994) was terminated by signal 6: Aborted
2025-03-05 13:40:49.031 UTC [35985][postmaster] LOG:  terminating any other active server processes
2025-03-05 13:40:49.031 UTC [35985][postmaster] LOG:  abnormal database system shutdown
2025-03-05 13:40:49.105 UTC [35985][postmaster] LOG:  database system is shut down