2025-01-31 22:26:46.395 GMT [6544][postmaster] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30158, 64-bit 2025-01-31 22:26:46.398 GMT [6544][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/VOjLOUpJPA/.s.PGSQL.12477" 2025-01-31 22:26:46.435 GMT [1192][startup] LOG: database system was shut down at 2025-01-31 22:18:04 GMT 2025-01-31 22:26:46.442 GMT [6544][postmaster] LOG: database system is ready to accept connections 2025-01-31 22:26:46.602 GMT [912][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:46.604 GMT [912][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:46.604 GMT [912][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:46.620 GMT [912][client backend] [026_stats.pl][0/2:0] LOG: statement: SELECT count(1) FROM pg_stat_subscription_stats 2025-01-31 22:26:46.625 GMT [912][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.030 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:46.931 GMT [6488][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:46.933 GMT [6488][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:46.933 GMT [6488][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:46.936 GMT [6488][client backend] [026_stats.pl][1/2:0] LOG: statement: BEGIN; 2025-01-31 22:26:46.937 GMT [6488][client backend] [026_stats.pl][1/2:0] LOG: statement: CREATE TABLE test_tab1(a int primary key); 2025-01-31 22:26:46.945 GMT [6488][client backend] [026_stats.pl][1/2:747] LOG: statement: INSERT INTO test_tab1 VALUES (1); 2025-01-31 22:26:46.946 GMT [6488][client backend] [026_stats.pl][1/2:747] LOG: statement: COMMIT; 2025-01-31 22:26:46.947 GMT [6488][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.018 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:47.149 GMT [6732][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:47.150 GMT [6732][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:47.150 GMT [6732][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:47.153 GMT [6732][client backend] [026_stats.pl][2/2:0] LOG: statement: CREATE SUBSCRIPTION test_tab1_sub CONNECTION 'port=12476 host=C:/Windows/TEMP/VOjLOUpJPA dbname=postgres' PUBLICATION test_tab1_pub 2025-01-31 22:26:47.225 GMT [6732][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.080 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:47.238 GMT [3836][logical replication apply worker] LOG: logical replication apply worker for subscription "test_tab1_sub" has started 2025-01-31 22:26:47.289 GMT [5452][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "test_tab1_sub", table "test_tab1" has started 2025-01-31 22:26:47.344 GMT [5452][logical replication tablesync worker] ERROR: duplicate key value violates unique constraint "test_tab1_pkey" 2025-01-31 22:26:47.344 GMT [5452][logical replication tablesync worker] DETAIL: Key (a)=(1) already exists. 2025-01-31 22:26:47.344 GMT [5452][logical replication tablesync worker] CONTEXT: COPY test_tab1, line 1 2025-01-31 22:26:47.353 GMT [6544][postmaster] LOG: background worker "logical replication tablesync worker" (PID 5452) exited with exit code 1 2025-01-31 22:26:47.685 GMT [4728][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:47.687 GMT [4728][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:47.687 GMT [4728][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:47.690 GMT [4728][client backend] [026_stats.pl][3/2:0] LOG: statement: SELECT sync_error_count > 0 FROM pg_stat_subscription_stats WHERE subname = 'test_tab1_sub' 2025-01-31 22:26:47.694 GMT [4728][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:47.843 GMT [7748][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:47.844 GMT [7748][client backend] [[unknown]][4/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:47.844 GMT [7748][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:47.847 GMT [7748][client backend] [026_stats.pl][4/2:0] LOG: statement: TRUNCATE test_tab1 2025-01-31 22:26:47.852 GMT [7748][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:47.945 GMT [7356][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:47.947 GMT [7356][client backend] [[unknown]][5/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:47.947 GMT [7356][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:47.951 GMT [7356][client backend] [026_stats.pl][5/2:0] LOG: statement: SELECT count(1) = 1 FROM pg_subscription_rel WHERE srrelid = 'test_tab1'::regclass AND srsubstate in ('r', 's') 2025-01-31 22:26:47.958 GMT [7356][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:48.240 GMT [6412][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:48.242 GMT [6412][client backend] [[unknown]][6/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:48.242 GMT [6412][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:48.246 GMT [6412][client backend] [026_stats.pl][6/2:0] LOG: statement: SELECT count(1) = 1 FROM pg_subscription_rel WHERE srrelid = 'test_tab1'::regclass AND srsubstate in ('r', 's') 2025-01-31 22:26:48.253 GMT [6412][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:48.413 GMT [2352][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "test_tab1_sub", table "test_tab1" has started 2025-01-31 22:26:48.472 GMT [2352][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "test_tab1_sub", table "test_tab1" has finished 2025-01-31 22:26:48.515 GMT [5456][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:48.517 GMT [5456][client backend] [[unknown]][7/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:48.517 GMT [5456][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:48.520 GMT [5456][client backend] [026_stats.pl][7/2:0] LOG: statement: SELECT count(1) = 1 FROM pg_subscription_rel WHERE srrelid = 'test_tab1'::regclass AND srsubstate in ('r', 's') 2025-01-31 22:26:48.524 GMT [5456][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:48.631 GMT [5072][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:48.632 GMT [5072][client backend] [[unknown]][8/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:48.633 GMT [5072][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:48.636 GMT [5072][client backend] [026_stats.pl][8/2:0] LOG: statement: SELECT a FROM test_tab1 2025-01-31 22:26:48.640 GMT [5072][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:48.782 GMT [3836][logical replication apply worker] ERROR: conflict detected on relation "public.test_tab1": conflict=insert_exists 2025-01-31 22:26:48.782 GMT [3836][logical replication apply worker] DETAIL: Key already exists in unique index "test_tab1_pkey", modified in transaction 753. Key (a)=(1); existing local tuple (1); remote tuple (1). 2025-01-31 22:26:48.782 GMT [3836][logical replication apply worker] CONTEXT: processing remote data for replication origin "pg_16390" during message type "INSERT" for replication target relation "public.test_tab1" in transaction 749, finished at 0/177E1A0 2025-01-31 22:26:48.795 GMT [6544][postmaster] LOG: background worker "logical replication apply worker" (PID 3836) exited with exit code 1 2025-01-31 22:26:48.803 GMT [6736][logical replication apply worker] LOG: logical replication apply worker for subscription "test_tab1_sub" has started 2025-01-31 22:26:48.847 GMT [6736][logical replication apply worker] ERROR: conflict detected on relation "public.test_tab1": conflict=insert_exists 2025-01-31 22:26:48.847 GMT [6736][logical replication apply worker] DETAIL: Key already exists in unique index "test_tab1_pkey", modified in transaction 753. Key (a)=(1); existing local tuple (1); remote tuple (1). 2025-01-31 22:26:48.847 GMT [6736][logical replication apply worker] CONTEXT: processing remote data for replication origin "pg_16390" during message type "INSERT" for replication target relation "public.test_tab1" in transaction 749, finished at 0/177E1A0 2025-01-31 22:26:48.855 GMT [6544][postmaster] LOG: background worker "logical replication apply worker" (PID 6736) exited with exit code 1 2025-01-31 22:26:48.879 GMT [5168][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:48.885 GMT [5168][client backend] [[unknown]][9/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:48.885 GMT [5168][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:48.889 GMT [5168][client backend] [026_stats.pl][9/2:0] LOG: statement: SELECT apply_error_count > 0 AND confl_insert_exists > 0 FROM pg_stat_subscription_stats WHERE subname = 'test_tab1_sub' 2025-01-31 22:26:48.894 GMT [5168][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.026 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:48.990 GMT [8136][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:48.992 GMT [8136][client backend] [[unknown]][10/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:48.992 GMT [8136][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:48.995 GMT [8136][client backend] [026_stats.pl][10/2:0] LOG: statement: TRUNCATE test_tab1 2025-01-31 22:26:49.001 GMT [8136][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:49.203 GMT [6436][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:49.204 GMT [6436][client backend] [[unknown]][11/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:49.204 GMT [6436][client backend] [[unknown]][11/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:49.210 GMT [6436][client backend] [026_stats.pl][11/2:0] LOG: statement: SELECT confl_delete_missing > 0 FROM pg_stat_subscription_stats WHERE subname = 'test_tab1_sub' 2025-01-31 22:26:49.214 GMT [6436][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:49.315 GMT [7872][logical replication apply worker] LOG: logical replication apply worker for subscription "test_tab1_sub" has started 2025-01-31 22:26:49.345 GMT [7872][logical replication apply worker] LOG: conflict detected on relation "public.test_tab1": conflict=delete_missing 2025-01-31 22:26:49.345 GMT [7872][logical replication apply worker] DETAIL: Could not find the row to be deleted. Replica identity (a)=(1). 2025-01-31 22:26:49.345 GMT [7872][logical replication apply worker] CONTEXT: processing remote data for replication origin "pg_16390" during message type "DELETE" for replication target relation "public.test_tab1" in transaction 750, finished at 0/177E250 2025-01-31 22:26:49.383 GMT [2516][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:49.390 GMT [2516][client backend] [[unknown]][12/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:49.390 GMT [2516][client backend] [[unknown]][12/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:49.401 GMT [2516][client backend] [026_stats.pl][12/2:0] LOG: statement: SELECT confl_delete_missing > 0 FROM pg_stat_subscription_stats WHERE subname = 'test_tab1_sub' 2025-01-31 22:26:49.406 GMT [2516][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.029 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:49.698 GMT [3564][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:49.700 GMT [3564][client backend] [[unknown]][13/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:49.700 GMT [3564][client backend] [[unknown]][13/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:49.707 GMT [3564][client backend] [026_stats.pl][13/2:0] LOG: statement: SELECT confl_delete_missing > 0 FROM pg_stat_subscription_stats WHERE subname = 'test_tab1_sub' 2025-01-31 22:26:49.713 GMT [3564][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.020 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:49.778 GMT [5928][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:49.780 GMT [5928][client backend] [[unknown]][14/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:49.780 GMT [5928][client backend] [[unknown]][14/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:49.783 GMT [5928][client backend] [026_stats.pl][14/2:0] LOG: statement: SELECT apply_error_count > 0, sync_error_count > 0, confl_insert_exists > 0, confl_delete_missing > 0, stats_reset IS NULL FROM pg_stat_subscription_stats WHERE subname = 'test_tab1_sub' 2025-01-31 22:26:49.788 GMT [5928][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:49.855 GMT [4956][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:49.856 GMT [4956][client backend] [[unknown]][15/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:49.856 GMT [4956][client backend] [[unknown]][15/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:49.859 GMT [4956][client backend] [026_stats.pl][15/2:0] LOG: statement: SELECT pg_stat_reset_subscription_stats((SELECT subid FROM pg_stat_subscription_stats WHERE subname = 'test_tab1_sub')) 2025-01-31 22:26:49.865 GMT [4956][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:49.928 GMT [4156][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:49.930 GMT [4156][client backend] [[unknown]][16/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:49.930 GMT [4156][client backend] [[unknown]][16/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:49.933 GMT [4156][client backend] [026_stats.pl][16/2:0] LOG: statement: SELECT apply_error_count = 0, sync_error_count = 0, confl_insert_exists = 0, confl_delete_missing = 0, stats_reset IS NOT NULL FROM pg_stat_subscription_stats WHERE subname = 'test_tab1_sub' 2025-01-31 22:26:49.937 GMT [4156][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:50.005 GMT [6980][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:50.006 GMT [6980][client backend] [[unknown]][17/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:50.006 GMT [6980][client backend] [[unknown]][17/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:50.009 GMT [6980][client backend] [026_stats.pl][17/2:0] LOG: statement: SELECT stats_reset FROM pg_stat_subscription_stats WHERE subname = 'test_tab1_sub' 2025-01-31 22:26:50.014 GMT [6980][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:50.076 GMT [6724][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:50.077 GMT [6724][client backend] [[unknown]][18/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:50.077 GMT [6724][client backend] [[unknown]][18/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:50.080 GMT [6724][client backend] [026_stats.pl][18/2:0] LOG: statement: SELECT pg_stat_reset_subscription_stats((SELECT subid FROM pg_stat_subscription_stats WHERE subname = 'test_tab1_sub')) 2025-01-31 22:26:50.085 GMT [6724][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:50.180 GMT [6024][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:50.182 GMT [6024][client backend] [[unknown]][19/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:50.182 GMT [6024][client backend] [[unknown]][19/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:50.185 GMT [6024][client backend] [026_stats.pl][19/2:0] LOG: statement: SELECT stats_reset > '2025-01-31 22:26:49.861552+00'::timestamptz FROM pg_stat_subscription_stats WHERE subname = 'test_tab1_sub' 2025-01-31 22:26:50.189 GMT [6024][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:50.392 GMT [5772][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:50.393 GMT [5772][client backend] [[unknown]][20/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:50.393 GMT [5772][client backend] [[unknown]][20/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:50.396 GMT [5772][client backend] [026_stats.pl][20/2:0] LOG: statement: BEGIN; 2025-01-31 22:26:50.396 GMT [5772][client backend] [026_stats.pl][20/2:0] LOG: statement: CREATE TABLE test_tab2(a int primary key); 2025-01-31 22:26:50.402 GMT [5772][client backend] [026_stats.pl][20/2:762] LOG: statement: INSERT INTO test_tab2 VALUES (1); 2025-01-31 22:26:50.403 GMT [5772][client backend] [026_stats.pl][20/2:762] LOG: statement: COMMIT; 2025-01-31 22:26:50.404 GMT [5772][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:50.617 GMT [5844][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:50.620 GMT [5844][client backend] [[unknown]][21/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:50.620 GMT [5844][client backend] [[unknown]][21/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:50.624 GMT [5844][client backend] [026_stats.pl][21/2:0] LOG: statement: CREATE SUBSCRIPTION test_tab2_sub CONNECTION 'port=12476 host=C:/Windows/TEMP/VOjLOUpJPA dbname=postgres' PUBLICATION test_tab2_pub 2025-01-31 22:26:50.682 GMT [5844][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.079 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:50.699 GMT [5108][logical replication apply worker] LOG: logical replication apply worker for subscription "test_tab2_sub" has started 2025-01-31 22:26:50.788 GMT [5888][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "test_tab2_sub", table "test_tab2" has started 2025-01-31 22:26:50.932 GMT [5888][logical replication tablesync worker] ERROR: duplicate key value violates unique constraint "test_tab2_pkey" 2025-01-31 22:26:50.932 GMT [5888][logical replication tablesync worker] DETAIL: Key (a)=(1) already exists. 2025-01-31 22:26:50.932 GMT [5888][logical replication tablesync worker] CONTEXT: COPY test_tab2, line 1 2025-01-31 22:26:50.985 GMT [6544][postmaster] LOG: background worker "logical replication tablesync worker" (PID 5888) exited with exit code 1 2025-01-31 22:26:51.258 GMT [6328][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:51.259 GMT [6328][client backend] [[unknown]][22/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:51.259 GMT [6328][client backend] [[unknown]][22/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:51.263 GMT [6328][client backend] [026_stats.pl][22/2:0] LOG: statement: SELECT sync_error_count > 0 FROM pg_stat_subscription_stats WHERE subname = 'test_tab2_sub' 2025-01-31 22:26:51.268 GMT [6328][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:51.330 GMT [8152][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:51.332 GMT [8152][client backend] [[unknown]][23/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:51.332 GMT [8152][client backend] [[unknown]][23/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:51.337 GMT [8152][client backend] [026_stats.pl][23/2:0] LOG: statement: TRUNCATE test_tab2 2025-01-31 22:26:51.365 GMT [8152][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.039 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:51.468 GMT [3232][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:51.470 GMT [3232][client backend] [[unknown]][24/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:51.470 GMT [3232][client backend] [[unknown]][24/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:51.474 GMT [3232][client backend] [026_stats.pl][24/2:0] LOG: statement: SELECT count(1) = 1 FROM pg_subscription_rel WHERE srrelid = 'test_tab2'::regclass AND srsubstate in ('r', 's') 2025-01-31 22:26:51.480 GMT [3232][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:51.665 GMT [5692][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:51.667 GMT [5692][client backend] [[unknown]][25/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:51.667 GMT [5692][client backend] [[unknown]][25/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:51.670 GMT [5692][client backend] [026_stats.pl][25/2:0] LOG: statement: SELECT count(1) = 1 FROM pg_subscription_rel WHERE srrelid = 'test_tab2'::regclass AND srsubstate in ('r', 's') 2025-01-31 22:26:51.675 GMT [5692][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.024 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:51.877 GMT [3688][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:51.878 GMT [3688][client backend] [[unknown]][26/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:51.878 GMT [3688][client backend] [[unknown]][26/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:51.881 GMT [3688][client backend] [026_stats.pl][26/2:0] LOG: statement: SELECT count(1) = 1 FROM pg_subscription_rel WHERE srrelid = 'test_tab2'::regclass AND srsubstate in ('r', 's') 2025-01-31 22:26:51.886 GMT [3688][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:52.010 GMT [1220][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "test_tab2_sub", table "test_tab2" has started 2025-01-31 22:26:52.060 GMT [1220][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "test_tab2_sub", table "test_tab2" has finished 2025-01-31 22:26:52.120 GMT [5708][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:52.121 GMT [5708][client backend] [[unknown]][27/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:52.121 GMT [5708][client backend] [[unknown]][27/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:52.124 GMT [5708][client backend] [026_stats.pl][27/2:0] LOG: statement: SELECT count(1) = 1 FROM pg_subscription_rel WHERE srrelid = 'test_tab2'::regclass AND srsubstate in ('r', 's') 2025-01-31 22:26:52.129 GMT [5708][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:52.229 GMT [4948][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:52.230 GMT [4948][client backend] [[unknown]][28/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:52.230 GMT [4948][client backend] [[unknown]][28/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:52.233 GMT [4948][client backend] [026_stats.pl][28/2:0] LOG: statement: SELECT a FROM test_tab2 2025-01-31 22:26:52.286 GMT [4948][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.060 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:52.398 GMT [5108][logical replication apply worker] ERROR: conflict detected on relation "public.test_tab2": conflict=insert_exists 2025-01-31 22:26:52.398 GMT [5108][logical replication apply worker] DETAIL: Key already exists in unique index "test_tab2_pkey", modified in transaction 768. Key (a)=(1); existing local tuple (1); remote tuple (1). 2025-01-31 22:26:52.398 GMT [5108][logical replication apply worker] CONTEXT: processing remote data for replication origin "pg_16401" during message type "INSERT" for replication target relation "public.test_tab2" in transaction 753, finished at 0/1781B80 2025-01-31 22:26:52.409 GMT [6544][postmaster] LOG: background worker "logical replication apply worker" (PID 5108) exited with exit code 1 2025-01-31 22:26:52.421 GMT [2712][logical replication apply worker] LOG: logical replication apply worker for subscription "test_tab2_sub" has started 2025-01-31 22:26:52.446 GMT [2712][logical replication apply worker] ERROR: conflict detected on relation "public.test_tab2": conflict=insert_exists 2025-01-31 22:26:52.446 GMT [2712][logical replication apply worker] DETAIL: Key already exists in unique index "test_tab2_pkey", modified in transaction 768. Key (a)=(1); existing local tuple (1); remote tuple (1). 2025-01-31 22:26:52.446 GMT [2712][logical replication apply worker] CONTEXT: processing remote data for replication origin "pg_16401" during message type "INSERT" for replication target relation "public.test_tab2" in transaction 753, finished at 0/1781B80 2025-01-31 22:26:52.449 GMT [6544][postmaster] LOG: background worker "logical replication apply worker" (PID 2712) exited with exit code 1 2025-01-31 22:26:52.528 GMT [3192][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:52.529 GMT [3192][client backend] [[unknown]][29/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:52.529 GMT [3192][client backend] [[unknown]][29/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:52.532 GMT [3192][client backend] [026_stats.pl][29/2:0] LOG: statement: SELECT apply_error_count > 0 AND confl_insert_exists > 0 FROM pg_stat_subscription_stats WHERE subname = 'test_tab2_sub' 2025-01-31 22:26:52.536 GMT [3192][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:52.630 GMT [5128][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:52.631 GMT [5128][client backend] [[unknown]][30/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:52.631 GMT [5128][client backend] [[unknown]][30/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:52.634 GMT [5128][client backend] [026_stats.pl][30/2:0] LOG: statement: TRUNCATE test_tab2 2025-01-31 22:26:52.642 GMT [5128][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:52.838 GMT [780][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:52.839 GMT [780][client backend] [[unknown]][31/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:52.839 GMT [780][client backend] [[unknown]][31/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:52.842 GMT [780][client backend] [026_stats.pl][31/2:0] LOG: statement: SELECT confl_delete_missing > 0 FROM pg_stat_subscription_stats WHERE subname = 'test_tab2_sub' 2025-01-31 22:26:52.847 GMT [780][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:52.930 GMT [6680][logical replication apply worker] LOG: logical replication apply worker for subscription "test_tab2_sub" has started 2025-01-31 22:26:52.965 GMT [6680][logical replication apply worker] LOG: conflict detected on relation "public.test_tab2": conflict=delete_missing 2025-01-31 22:26:52.965 GMT [6680][logical replication apply worker] DETAIL: Could not find the row to be deleted. Replica identity (a)=(1). 2025-01-31 22:26:52.965 GMT [6680][logical replication apply worker] CONTEXT: processing remote data for replication origin "pg_16401" during message type "DELETE" for replication target relation "public.test_tab2" in transaction 754, finished at 0/1781C30 2025-01-31 22:26:53.062 GMT [5456][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:53.064 GMT [5456][client backend] [[unknown]][32/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:53.064 GMT [5456][client backend] [[unknown]][32/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:53.072 GMT [5456][client backend] [026_stats.pl][32/2:0] LOG: statement: SELECT confl_delete_missing > 0 FROM pg_stat_subscription_stats WHERE subname = 'test_tab2_sub' 2025-01-31 22:26:53.076 GMT [5456][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:53.267 GMT [6808][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:53.269 GMT [6808][client backend] [[unknown]][33/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:53.269 GMT [6808][client backend] [[unknown]][33/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:53.282 GMT [6808][client backend] [026_stats.pl][33/2:0] LOG: statement: SELECT confl_delete_missing > 0 FROM pg_stat_subscription_stats WHERE subname = 'test_tab2_sub' 2025-01-31 22:26:53.286 GMT [6808][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:53.365 GMT [7964][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:53.367 GMT [7964][client backend] [[unknown]][34/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:53.367 GMT [7964][client backend] [[unknown]][34/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:53.370 GMT [7964][client backend] [026_stats.pl][34/2:0] LOG: statement: SELECT apply_error_count > 0, sync_error_count > 0, confl_insert_exists > 0, confl_delete_missing > 0, stats_reset IS NULL FROM pg_stat_subscription_stats WHERE subname = 'test_tab2_sub' 2025-01-31 22:26:53.375 GMT [7964][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:53.442 GMT [7744][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:53.443 GMT [7744][client backend] [[unknown]][35/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:53.443 GMT [7744][client backend] [[unknown]][35/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:53.446 GMT [7744][client backend] [026_stats.pl][35/2:0] LOG: statement: SELECT pg_stat_reset_subscription_stats(NULL) 2025-01-31 22:26:53.450 GMT [7744][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:53.595 GMT [3732][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:53.597 GMT [3732][client backend] [[unknown]][36/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:53.597 GMT [3732][client backend] [[unknown]][36/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:53.601 GMT [3732][client backend] [026_stats.pl][36/2:0] LOG: statement: SELECT apply_error_count = 0, sync_error_count = 0, confl_insert_exists = 0, confl_delete_missing = 0, stats_reset IS NOT NULL FROM pg_stat_subscription_stats WHERE subname = 'test_tab1_sub' 2025-01-31 22:26:53.610 GMT [3732][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:53.722 GMT [7816][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:53.724 GMT [7816][client backend] [[unknown]][37/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:53.724 GMT [7816][client backend] [[unknown]][37/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:53.727 GMT [7816][client backend] [026_stats.pl][37/2:0] LOG: statement: SELECT apply_error_count = 0, sync_error_count = 0, confl_insert_exists = 0, confl_delete_missing = 0, stats_reset IS NOT NULL FROM pg_stat_subscription_stats WHERE subname = 'test_tab2_sub' 2025-01-31 22:26:53.732 GMT [7816][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:53.812 GMT [2132][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:53.814 GMT [2132][client backend] [[unknown]][38/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:53.814 GMT [2132][client backend] [[unknown]][38/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:53.817 GMT [2132][client backend] [026_stats.pl][38/2:0] LOG: statement: SELECT stats_reset FROM pg_stat_subscription_stats WHERE subname = 'test_tab1_sub' 2025-01-31 22:26:53.822 GMT [2132][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:53.914 GMT [5724][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:53.916 GMT [5724][client backend] [[unknown]][39/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:53.916 GMT [5724][client backend] [[unknown]][39/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:53.919 GMT [5724][client backend] [026_stats.pl][39/2:0] LOG: statement: SELECT stats_reset FROM pg_stat_subscription_stats WHERE subname = 'test_tab2_sub' 2025-01-31 22:26:53.923 GMT [5724][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:54.140 GMT [3880][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:54.141 GMT [3880][client backend] [[unknown]][40/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:54.141 GMT [3880][client backend] [[unknown]][40/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:54.144 GMT [3880][client backend] [026_stats.pl][40/2:0] LOG: statement: SELECT pg_stat_reset_subscription_stats(NULL) 2025-01-31 22:26:54.147 GMT [3880][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:54.252 GMT [7112][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:54.254 GMT [7112][client backend] [[unknown]][41/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:54.254 GMT [7112][client backend] [[unknown]][41/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:54.257 GMT [7112][client backend] [026_stats.pl][41/2:0] LOG: statement: SELECT stats_reset > '2025-01-31 22:26:53.447194+00'::timestamptz FROM pg_stat_subscription_stats WHERE subname = 'test_tab1_sub' 2025-01-31 22:26:54.261 GMT [7112][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:54.374 GMT [6308][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:54.376 GMT [6308][client backend] [[unknown]][42/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:54.376 GMT [6308][client backend] [[unknown]][42/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:54.381 GMT [6308][client backend] [026_stats.pl][42/2:0] LOG: statement: SELECT stats_reset > '2025-01-31 22:26:53.447194+00'::timestamptz FROM pg_stat_subscription_stats WHERE subname = 'test_tab2_sub' 2025-01-31 22:26:54.387 GMT [6308][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:54.459 GMT [2580][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:54.460 GMT [2580][client backend] [[unknown]][43/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:54.460 GMT [2580][client backend] [[unknown]][43/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:54.463 GMT [2580][client backend] [026_stats.pl][43/2:0] LOG: statement: SELECT oid FROM pg_subscription WHERE subname = 'test_tab1_sub' 2025-01-31 22:26:54.467 GMT [2580][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:54.559 GMT [2628][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:54.561 GMT [2628][client backend] [[unknown]][44/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:54.561 GMT [2628][client backend] [[unknown]][44/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:54.563 GMT [2628][client backend] [026_stats.pl][44/2:0] LOG: statement: DROP SUBSCRIPTION test_tab1_sub 2025-01-31 22:26:54.564 GMT [7872][logical replication apply worker] FATAL: terminating logical replication worker due to administrator command 2025-01-31 22:26:54.568 GMT [6544][postmaster] LOG: background worker "logical replication apply worker" (PID 7872) exited with exit code 1 2025-01-31 22:26:54.636 GMT [2628][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.079 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:54.829 GMT [1528][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:54.830 GMT [1528][client backend] [[unknown]][45/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:54.830 GMT [1528][client backend] [[unknown]][45/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:54.837 GMT [1528][client backend] [026_stats.pl][45/2:0] LOG: statement: SELECT pg_stat_have_stats('subscription', 0, 16390) 2025-01-31 22:26:54.841 GMT [1528][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.030 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:54.944 GMT [524][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:54.946 GMT [524][client backend] [[unknown]][46/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:54.946 GMT [524][client backend] [[unknown]][46/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:54.948 GMT [524][client backend] [026_stats.pl][46/2:0] LOG: statement: SELECT oid FROM pg_subscription WHERE subname = 'test_tab2_sub' 2025-01-31 22:26:55.004 GMT [524][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.063 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:55.148 GMT [7132][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:55.149 GMT [7132][client backend] [[unknown]][47/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:55.149 GMT [7132][client backend] [[unknown]][47/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:55.152 GMT [7132][client backend] [026_stats.pl][47/2:0] LOG: statement: ALTER SUBSCRIPTION test_tab2_sub DISABLE; 2025-01-31 22:26:55.153 GMT [6680][logical replication apply worker] LOG: logical replication worker for subscription "test_tab2_sub" will stop because the subscription was disabled 2025-01-31 22:26:55.153 GMT [7132][client backend] [026_stats.pl][47/3:0] LOG: statement: ALTER SUBSCRIPTION test_tab2_sub SET (slot_name = NONE); 2025-01-31 22:26:55.153 GMT [7132][client backend] [026_stats.pl][47/4:0] LOG: statement: DROP SUBSCRIPTION test_tab2_sub; 2025-01-31 22:26:55.155 GMT [7132][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:55.265 GMT [6468][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 22:26:55.266 GMT [6468][client backend] [[unknown]][48/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata/pg_hba.conf:117) 2025-01-31 22:26:55.266 GMT [6468][client backend] [[unknown]][48/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2025-01-31 22:26:55.270 GMT [6468][client backend] [026_stats.pl][48/2:0] LOG: statement: SELECT pg_stat_have_stats('subscription', 0, 16401) 2025-01-31 22:26:55.272 GMT [6468][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-31 22:26:55.557 GMT [6544][postmaster] LOG: received fast shutdown request 2025-01-31 22:26:55.557 GMT [6544][postmaster] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2951, PID: 6544 abort() has been called