2024-11-21 04:56:33.229 GMT [4368][postmaster] LOG:  starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30157, 64-bit
2024-11-21 04:56:33.233 GMT [4368][postmaster] LOG:  listening on Unix socket "C:/Windows/TEMP/cqH5KJ8YJX/.s.PGSQL.22967"
2024-11-21 04:56:33.279 GMT [8040][startup] LOG:  database system was shut down at 2024-11-21 04:49:12 GMT
2024-11-21 04:56:33.342 GMT [4368][postmaster] LOG:  database system is ready to accept connections
2024-11-21 04:56:33.889 GMT [5488][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:33.890 GMT [5488][client backend] [[unknown]][0/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:33.891 GMT [5488][client backend] [[unknown]][0/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:33.908 GMT [5488][client backend] [004_sync.pl][0/2:0] LOG:  statement: CREATE TABLE tab_rep (a int primary key)
2024-11-21 04:56:33.919 GMT [5488][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.033 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:34.153 GMT [6544][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:34.155 GMT [6544][client backend] [[unknown]][1/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:34.155 GMT [6544][client backend] [[unknown]][1/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:34.158 GMT [6544][client backend] [004_sync.pl][1/2:0] LOG:  statement: CREATE SUBSCRIPTION tap_sub CONNECTION 'port=22966 host=C:/Windows/TEMP/cqH5KJ8YJX dbname=postgres' PUBLICATION tap_pub
2024-11-21 04:56:34.227 GMT [6544][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.078 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:34.237 GMT [7728][logical replication apply worker] LOG:  logical replication apply worker for subscription "tap_sub" has started
2024-11-21 04:56:34.300 GMT [7196][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tap_sub", table "tab_rep" has started
2024-11-21 04:56:34.368 GMT [7196][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tap_sub", table "tab_rep" has finished
2024-11-21 04:56:34.400 GMT [8168][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:34.402 GMT [8168][client backend] [[unknown]][2/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:34.402 GMT [8168][client backend] [[unknown]][2/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:34.404 GMT [8168][client backend] [004_sync.pl][2/2:0] LOG:  statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's');
2024-11-21 04:56:34.409 GMT [8168][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:34.767 GMT [6048][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:34.768 GMT [6048][client backend] [[unknown]][3/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:34.768 GMT [6048][client backend] [[unknown]][3/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:34.771 GMT [6048][client backend] [004_sync.pl][3/2:0] LOG:  statement: SELECT count(*) FROM tab_rep
2024-11-21 04:56:34.775 GMT [6048][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:34.848 GMT [2704][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:34.850 GMT [2704][client backend] [[unknown]][4/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:34.850 GMT [2704][client backend] [[unknown]][4/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:34.852 GMT [2704][client backend] [004_sync.pl][4/2:0] LOG:  statement: DROP SUBSCRIPTION tap_sub
2024-11-21 04:56:34.853 GMT [7728][logical replication apply worker] FATAL:  terminating logical replication worker due to administrator command
2024-11-21 04:56:34.861 GMT [4368][postmaster] LOG:  background worker "logical replication apply worker" (PID 7728) exited with exit code 1
2024-11-21 04:56:34.919 GMT [2704][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.075 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:35.171 GMT [1120][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:35.174 GMT [1120][client backend] [[unknown]][5/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:35.174 GMT [1120][client backend] [[unknown]][5/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:35.178 GMT [1120][client backend] [004_sync.pl][5/2:0] LOG:  statement: CREATE SUBSCRIPTION tap_sub CONNECTION 'port=22966 host=C:/Windows/TEMP/cqH5KJ8YJX dbname=postgres' PUBLICATION tap_pub
2024-11-21 04:56:35.234 GMT [1120][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.066 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:35.253 GMT [4580][logical replication apply worker] LOG:  logical replication apply worker for subscription "tap_sub" has started
2024-11-21 04:56:35.331 GMT [948][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:35.332 GMT [7064][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tap_sub", table "tab_rep" has started
2024-11-21 04:56:35.333 GMT [948][client backend] [[unknown]][6/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:35.333 GMT [948][client backend] [[unknown]][6/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:35.336 GMT [948][client backend] [004_sync.pl][6/2:0] LOG:  statement: SELECT srsubstate = 'd' FROM pg_subscription_rel;
2024-11-21 04:56:35.339 GMT [948][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:35.385 GMT [7064][logical replication tablesync worker] ERROR:  duplicate key value violates unique constraint "tab_rep_pkey"
2024-11-21 04:56:35.385 GMT [7064][logical replication tablesync worker] DETAIL:  Key (a)=(1) already exists.
2024-11-21 04:56:35.385 GMT [7064][logical replication tablesync worker] CONTEXT:  COPY tab_rep, line 1
2024-11-21 04:56:35.392 GMT [4368][postmaster] LOG:  background worker "logical replication tablesync worker" (PID 7064) exited with exit code 1
2024-11-21 04:56:35.415 GMT [6040][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tap_sub", table "tab_rep" has started
2024-11-21 04:56:35.470 GMT [6040][logical replication tablesync worker] ERROR:  duplicate key value violates unique constraint "tab_rep_pkey"
2024-11-21 04:56:35.470 GMT [6040][logical replication tablesync worker] DETAIL:  Key (a)=(1) already exists.
2024-11-21 04:56:35.470 GMT [6040][logical replication tablesync worker] CONTEXT:  COPY tab_rep, line 1
2024-11-21 04:56:35.488 GMT [4368][postmaster] LOG:  background worker "logical replication tablesync worker" (PID 6040) exited with exit code 1
2024-11-21 04:56:35.500 GMT [6880][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tap_sub", table "tab_rep" has started
2024-11-21 04:56:35.537 GMT [5420][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:35.538 GMT [5420][client backend] [[unknown]][7/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:35.538 GMT [5420][client backend] [[unknown]][7/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:35.541 GMT [5420][client backend] [004_sync.pl][7/2:0] LOG:  statement: SELECT srsubstate = 'd' FROM pg_subscription_rel;
2024-11-21 04:56:35.545 GMT [5420][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:35.561 GMT [6880][logical replication tablesync worker] ERROR:  duplicate key value violates unique constraint "tab_rep_pkey"
2024-11-21 04:56:35.561 GMT [6880][logical replication tablesync worker] DETAIL:  Key (a)=(1) already exists.
2024-11-21 04:56:35.561 GMT [6880][logical replication tablesync worker] CONTEXT:  COPY tab_rep, line 1
2024-11-21 04:56:35.575 GMT [4368][postmaster] LOG:  background worker "logical replication tablesync worker" (PID 6880) exited with exit code 1
2024-11-21 04:56:35.594 GMT [5652][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tap_sub", table "tab_rep" has started
2024-11-21 04:56:35.612 GMT [5384][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:35.613 GMT [5384][client backend] [[unknown]][8/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:35.613 GMT [5384][client backend] [[unknown]][8/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:35.615 GMT [5384][client backend] [004_sync.pl][8/2:0] LOG:  statement: DELETE FROM tab_rep;
2024-11-21 04:56:35.617 GMT [5384][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.008 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:35.669 GMT [5652][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tap_sub", table "tab_rep" has finished
2024-11-21 04:56:35.734 GMT [3804][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:35.735 GMT [3804][client backend] [[unknown]][9/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:35.735 GMT [3804][client backend] [[unknown]][9/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:35.738 GMT [3804][client backend] [004_sync.pl][9/2:0] LOG:  statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's');
2024-11-21 04:56:35.743 GMT [3804][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:35.816 GMT [4040][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:35.817 GMT [4040][client backend] [[unknown]][10/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:35.817 GMT [4040][client backend] [[unknown]][10/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:35.819 GMT [4040][client backend] [004_sync.pl][10/2:0] LOG:  statement: SELECT count(*) FROM tab_rep
2024-11-21 04:56:35.823 GMT [4040][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:35.902 GMT [6128][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:35.904 GMT [6128][client backend] [[unknown]][11/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:35.904 GMT [6128][client backend] [[unknown]][11/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:35.906 GMT [6128][client backend] [004_sync.pl][11/2:0] LOG:  statement: CREATE SUBSCRIPTION tap_sub2 CONNECTION 'port=22966 host=C:/Windows/TEMP/cqH5KJ8YJX dbname=postgres' PUBLICATION tap_pub WITH (copy_data = false)
2024-11-21 04:56:35.965 GMT [6128][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.065 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:35.987 GMT [6752][logical replication apply worker] LOG:  logical replication apply worker for subscription "tap_sub2" has started
2024-11-21 04:56:36.064 GMT [5244][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:36.065 GMT [5244][client backend] [[unknown]][12/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:36.065 GMT [5244][client backend] [[unknown]][12/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:36.071 GMT [5244][client backend] [004_sync.pl][12/2:0] LOG:  statement: SELECT pid IS NOT NULL FROM pg_stat_subscription WHERE subname = 'tap_sub2' AND worker_type = 'apply'
2024-11-21 04:56:36.079 GMT [5244][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.025 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:36.195 GMT [5224][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:36.196 GMT [5224][client backend] [[unknown]][13/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:36.196 GMT [5224][client backend] [[unknown]][13/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:36.202 GMT [5224][client backend] [004_sync.pl][13/2:0] LOG:  statement: DROP SUBSCRIPTION tap_sub
2024-11-21 04:56:36.202 GMT [4580][logical replication apply worker] FATAL:  terminating logical replication worker due to administrator command
2024-11-21 04:56:36.219 GMT [4368][postmaster] LOG:  background worker "logical replication apply worker" (PID 4580) exited with exit code 1
2024-11-21 04:56:36.255 GMT [5224][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.063 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:36.324 GMT [3876][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:36.326 GMT [3876][client backend] [[unknown]][14/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:36.326 GMT [3876][client backend] [[unknown]][14/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:36.328 GMT [3876][client backend] [004_sync.pl][14/2:0] LOG:  statement: DROP SUBSCRIPTION tap_sub2
2024-11-21 04:56:36.328 GMT [6752][logical replication apply worker] FATAL:  terminating logical replication worker due to administrator command
2024-11-21 04:56:36.334 GMT [4368][postmaster] LOG:  background worker "logical replication apply worker" (PID 6752) exited with exit code 1
2024-11-21 04:56:36.373 GMT [3876][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.052 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:36.474 GMT [5780][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:36.475 GMT [5780][client backend] [[unknown]][15/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:36.475 GMT [5780][client backend] [[unknown]][15/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:36.478 GMT [5780][client backend] [004_sync.pl][15/2:0] LOG:  statement: SELECT count(*) FROM pg_subscription
2024-11-21 04:56:36.481 GMT [5780][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:36.547 GMT [5684][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:36.548 GMT [5684][client backend] [[unknown]][16/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:36.548 GMT [5684][client backend] [[unknown]][16/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:36.554 GMT [5684][client backend] [004_sync.pl][16/2:0] LOG:  statement: DELETE FROM tab_rep;
2024-11-21 04:56:36.556 GMT [5684][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:36.638 GMT [6624][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:36.640 GMT [6624][client backend] [[unknown]][17/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:36.640 GMT [6624][client backend] [[unknown]][17/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:36.642 GMT [6624][client backend] [004_sync.pl][17/2:0] LOG:  statement: CREATE SUBSCRIPTION tap_sub CONNECTION 'port=22966 host=C:/Windows/TEMP/cqH5KJ8YJX dbname=postgres' PUBLICATION tap_pub
2024-11-21 04:56:36.705 GMT [6624][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.069 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:36.738 GMT [7984][logical replication apply worker] LOG:  logical replication apply worker for subscription "tap_sub" has started
2024-11-21 04:56:36.869 GMT [7808][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:36.871 GMT [7808][client backend] [[unknown]][18/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:36.871 GMT [7808][client backend] [[unknown]][18/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:36.873 GMT [7808][client backend] [004_sync.pl][18/2:0] LOG:  statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's');
2024-11-21 04:56:36.878 GMT [7808][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:36.884 GMT [816][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tap_sub", table "tab_rep" has started
2024-11-21 04:56:36.952 GMT [816][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tap_sub", table "tab_rep" has finished
2024-11-21 04:56:37.083 GMT [4068][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:37.084 GMT [4068][client backend] [[unknown]][19/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:37.084 GMT [4068][client backend] [[unknown]][19/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:37.099 GMT [4068][client backend] [004_sync.pl][19/2:0] LOG:  statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's');
2024-11-21 04:56:37.103 GMT [4068][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.023 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:37.226 GMT [1124][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:37.228 GMT [1124][client backend] [[unknown]][20/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:37.228 GMT [1124][client backend] [[unknown]][20/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:37.231 GMT [1124][client backend] [004_sync.pl][20/2:0] LOG:  statement: SELECT count(*) FROM tab_rep
2024-11-21 04:56:37.236 GMT [1124][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:37.308 GMT [468][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:37.310 GMT [468][client backend] [[unknown]][21/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:37.310 GMT [468][client backend] [[unknown]][21/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:37.312 GMT [468][client backend] [004_sync.pl][21/2:0] LOG:  statement: CREATE TABLE tab_rep_next (a int)
2024-11-21 04:56:37.316 GMT [468][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:37.699 GMT [4884][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:37.701 GMT [4884][client backend] [[unknown]][22/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:37.701 GMT [4884][client backend] [[unknown]][22/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:37.704 GMT [4884][client backend] [004_sync.pl][22/2:0] LOG:  statement: SELECT count(*) FROM tab_rep_next
2024-11-21 04:56:37.708 GMT [4884][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:37.772 GMT [7108][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:37.773 GMT [7108][client backend] [[unknown]][23/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:37.773 GMT [7108][client backend] [[unknown]][23/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:37.776 GMT [7108][client backend] [004_sync.pl][23/2:0] LOG:  statement: ALTER SUBSCRIPTION tap_sub REFRESH PUBLICATION
2024-11-21 04:56:37.819 GMT [7108][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.050 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:37.844 GMT [7180][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tap_sub", table "tab_rep_next" has started
2024-11-21 04:56:37.908 GMT [7180][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tap_sub", table "tab_rep_next" has finished
2024-11-21 04:56:37.953 GMT [7620][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:37.954 GMT [7620][client backend] [[unknown]][24/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:37.954 GMT [7620][client backend] [[unknown]][24/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:37.957 GMT [7620][client backend] [004_sync.pl][24/2:0] LOG:  statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's');
2024-11-21 04:56:37.961 GMT [7620][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:38.065 GMT [3876][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:38.066 GMT [3876][client backend] [[unknown]][25/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:38.066 GMT [3876][client backend] [[unknown]][25/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:38.070 GMT [3876][client backend] [004_sync.pl][25/2:0] LOG:  statement: SELECT count(*) FROM tab_rep_next
2024-11-21 04:56:38.074 GMT [3876][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:38.445 GMT [5816][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:38.446 GMT [5816][client backend] [[unknown]][26/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:38.446 GMT [5816][client backend] [[unknown]][26/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:38.449 GMT [5816][client backend] [004_sync.pl][26/2:0] LOG:  statement: SELECT count(*) FROM tab_rep_next
2024-11-21 04:56:38.453 GMT [5816][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:38.607 GMT [6800][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:38.609 GMT [6800][client backend] [[unknown]][27/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:38.609 GMT [6800][client backend] [[unknown]][27/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:38.612 GMT [6800][client backend] [004_sync.pl][27/2:0] LOG:  statement: DROP TABLE tab_rep_next
2024-11-21 04:56:38.615 GMT [6800][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:38.678 GMT [404][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:38.679 GMT [404][client backend] [[unknown]][28/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:38.679 GMT [404][client backend] [[unknown]][28/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:38.682 GMT [404][client backend] [004_sync.pl][28/2:0] LOG:  statement: DROP SUBSCRIPTION tap_sub
2024-11-21 04:56:38.682 GMT [7984][logical replication apply worker] FATAL:  terminating logical replication worker due to administrator command
2024-11-21 04:56:38.701 GMT [4368][postmaster] LOG:  background worker "logical replication apply worker" (PID 7984) exited with exit code 1
2024-11-21 04:56:38.734 GMT [404][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.059 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:38.919 GMT [5156][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:38.921 GMT [5156][client backend] [[unknown]][29/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:38.921 GMT [5156][client backend] [[unknown]][29/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:38.926 GMT [5156][client backend] [004_sync.pl][29/2:0] LOG:  statement: CREATE SUBSCRIPTION tap_sub CONNECTION 'port=22966 host=C:/Windows/TEMP/cqH5KJ8YJX dbname=postgres' PUBLICATION tap_pub
2024-11-21 04:56:39.002 GMT [5156][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.088 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:39.014 GMT [3048][logical replication apply worker] LOG:  logical replication apply worker for subscription "tap_sub" has started
2024-11-21 04:56:39.071 GMT [7376][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tap_sub", table "tab_rep" has started
2024-11-21 04:56:39.125 GMT [7376][logical replication tablesync worker] ERROR:  duplicate key value violates unique constraint "tab_rep_pkey"
2024-11-21 04:56:39.125 GMT [7376][logical replication tablesync worker] DETAIL:  Key (a)=(1) already exists.
2024-11-21 04:56:39.125 GMT [7376][logical replication tablesync worker] CONTEXT:  COPY tab_rep, line 1
2024-11-21 04:56:39.184 GMT [4368][postmaster] LOG:  background worker "logical replication tablesync worker" (PID 7376) exited with exit code 1
2024-11-21 04:56:39.193 GMT [6392][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:39.194 GMT [6392][client backend] [[unknown]][30/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:39.194 GMT [6392][client backend] [[unknown]][30/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:39.200 GMT [6392][client backend] [004_sync.pl][30/2:0] LOG:  statement: SELECT srsubstate = 'd' FROM pg_subscription_rel;
2024-11-21 04:56:39.219 GMT [7536][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tap_sub", table "tab_rep" has started
2024-11-21 04:56:39.219 GMT [6392][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.029 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:39.272 GMT [7536][logical replication tablesync worker] ERROR:  duplicate key value violates unique constraint "tab_rep_pkey"
2024-11-21 04:56:39.272 GMT [7536][logical replication tablesync worker] DETAIL:  Key (a)=(1) already exists.
2024-11-21 04:56:39.272 GMT [7536][logical replication tablesync worker] CONTEXT:  COPY tab_rep, line 1
2024-11-21 04:56:39.282 GMT [4368][postmaster] LOG:  background worker "logical replication tablesync worker" (PID 7536) exited with exit code 1
2024-11-21 04:56:39.322 GMT [7764][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tap_sub", table "tab_rep" has started
2024-11-21 04:56:39.345 GMT [1392][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:39.346 GMT [1392][client backend] [[unknown]][31/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/004_sync/data/t_004_sync_subscriber_data/pgdata/pg_hba.conf:117)
2024-11-21 04:56:39.346 GMT [1392][client backend] [[unknown]][31/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=004_sync.pl
2024-11-21 04:56:39.349 GMT [1392][client backend] [004_sync.pl][31/2:0] LOG:  statement: DROP SUBSCRIPTION tap_sub
2024-11-21 04:56:39.350 GMT [3048][logical replication apply worker] FATAL:  terminating logical replication worker due to administrator command
2024-11-21 04:56:39.360 GMT [7764][logical replication tablesync worker] FATAL:  terminating logical replication worker due to administrator command
2024-11-21 04:56:39.363 GMT [4368][postmaster] LOG:  background worker "logical replication apply worker" (PID 3048) exited with exit code 1
2024-11-21 04:56:39.372 GMT [4368][postmaster] LOG:  background worker "logical replication tablesync worker" (PID 7764) exited with exit code 1
2024-11-21 04:56:39.456 GMT [1392][client backend] [004_sync.pl][:0] LOG:  disconnection: session time: 0:00:00.114 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:39.669 GMT [4368][postmaster] LOG:  received fast shutdown request
2024-11-21 04:56:39.669 GMT [4368][postmaster] LOG:  aborting any active transactions
TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2887, PID: 4368
abort() has been called