2024-11-27 10:12:16.022 GMT [1552][postmaster] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30157, 64-bit 2024-11-27 10:12:16.025 GMT [1552][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/GgGT0GmwEv/.s.PGSQL.11076" 2024-11-27 10:12:16.056 GMT [7100][startup] LOG: database system was shut down at 2024-11-27 10:04:17 GMT 2024-11-27 10:12:16.067 GMT [1552][postmaster] LOG: database system is ready to accept connections 2024-11-27 10:12:17.472 GMT [5036][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:17.473 GMT [5036][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:17.474 GMT [5036][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-11-27 10:12:17.488 GMT [5036][client backend] [026_stats.pl][0/2:0] LOG: statement: BEGIN; 2024-11-27 10:12:17.488 GMT [5036][client backend] [026_stats.pl][0/2:0] LOG: statement: CREATE TABLE test_tab1(a int); 2024-11-27 10:12:17.492 GMT [5036][client backend] [026_stats.pl][0/2:746] LOG: statement: ALTER TABLE test_tab1 REPLICA IDENTITY FULL; 2024-11-27 10:12:17.493 GMT [5036][client backend] [026_stats.pl][0/2:746] LOG: statement: INSERT INTO test_tab1 VALUES (1); 2024-11-27 10:12:17.493 GMT [5036][client backend] [026_stats.pl][0/2:746] LOG: statement: COMMIT; 2024-11-27 10:12:17.493 GMT [5036][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.025 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:17.669 GMT [5200][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:17.671 GMT [5200][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:17.671 GMT [5200][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-11-27 10:12:17.674 GMT [5200][client backend] [026_stats.pl][1/2:0] LOG: statement: CREATE PUBLICATION test_tab1_pub FOR TABLE test_tab1 2024-11-27 10:12:17.677 GMT [5200][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:17.766 GMT [7140][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:17.768 GMT [7140][walsender] [[unknown]][22/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:17.768 GMT [7140][walsender] [[unknown]][22/1:0] LOG: replication connection authorized: user=SYSTEM application_name=test_tab1_sub 2024-11-27 10:12:17.770 GMT [7140][walsender] [test_tab1_sub][22/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-27 10:12:17.771 GMT [7140][walsender] [test_tab1_sub][22/3:0] LOG: statement: SELECT t.pubname FROM pg_catalog.pg_publication t WHERE t.pubname IN ('test_tab1_pub') 2024-11-27 10:12:17.774 GMT [7140][walsender] [test_tab1_sub][22/4:0] LOG: statement: SELECT DISTINCT n.nspname, c.relname, gpt.attrs FROM pg_class c JOIN pg_namespace n ON n.oid = c.relnamespace JOIN ( SELECT (pg_get_publication_tables(VARIADIC array_agg(pubname::text))).* FROM pg_publication WHERE pubname IN ( 'test_tab1_pub' )) AS gpt ON gpt.relid = c.oid 2024-11-27 10:12:17.782 GMT [7140][walsender] [test_tab1_sub][22/0:0] LOG: received replication command: CREATE_REPLICATION_SLOT "test_tab1_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-27 10:12:17.782 GMT [7140][walsender] [test_tab1_sub][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "test_tab1_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-27 10:12:17.789 GMT [7140][walsender] [test_tab1_sub][22/0:0] LOG: logical decoding found consistent point at 0/177E748 2024-11-27 10:12:17.789 GMT [7140][walsender] [test_tab1_sub][22/0:0] DETAIL: There are no running transactions. 2024-11-27 10:12:17.789 GMT [7140][walsender] [test_tab1_sub][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "test_tab1_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-27 10:12:17.792 GMT [7140][walsender] [test_tab1_sub][22/0:0] LOG: released logical replication slot "test_tab1_sub" 2024-11-27 10:12:17.792 GMT [7140][walsender] [test_tab1_sub][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "test_tab1_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-27 10:12:17.792 GMT [7140][walsender] [test_tab1_sub][:0] LOG: disconnection: session time: 0:00:00.029 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:17.858 GMT [5740][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:17.860 GMT [5740][walsender] [[unknown]][23/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:17.860 GMT [5740][walsender] [[unknown]][23/1:0] LOG: replication connection authorized: user=SYSTEM application_name=test_tab1_sub 2024-11-27 10:12:17.866 GMT [5740][walsender] [test_tab1_sub][23/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-27 10:12:17.867 GMT [5740][walsender] [test_tab1_sub][23/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-27 10:12:17.867 GMT [5740][walsender] [test_tab1_sub][23/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-27 10:12:17.867 GMT [5740][walsender] [test_tab1_sub][23/0:0] LOG: received replication command: START_REPLICATION SLOT "test_tab1_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-11-27 10:12:17.867 GMT [5740][walsender] [test_tab1_sub][23/0:0] STATEMENT: START_REPLICATION SLOT "test_tab1_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-11-27 10:12:17.867 GMT [5740][walsender] [test_tab1_sub][23/0:0] LOG: acquired logical replication slot "test_tab1_sub" 2024-11-27 10:12:17.867 GMT [5740][walsender] [test_tab1_sub][23/0:0] STATEMENT: START_REPLICATION SLOT "test_tab1_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-11-27 10:12:17.868 GMT [5740][walsender] [test_tab1_sub][23/0:0] LOG: starting logical decoding for slot "test_tab1_sub" 2024-11-27 10:12:17.868 GMT [5740][walsender] [test_tab1_sub][23/0:0] DETAIL: Streaming transactions committing after 0/177E780, reading WAL from 0/177E748. 2024-11-27 10:12:17.868 GMT [5740][walsender] [test_tab1_sub][23/0:0] STATEMENT: START_REPLICATION SLOT "test_tab1_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-11-27 10:12:17.869 GMT [5740][walsender] [test_tab1_sub][23/0:0] LOG: logical decoding found consistent point at 0/177E748 2024-11-27 10:12:17.869 GMT [5740][walsender] [test_tab1_sub][23/0:0] DETAIL: There are no running transactions. 2024-11-27 10:12:17.869 GMT [5740][walsender] [test_tab1_sub][23/0:0] STATEMENT: START_REPLICATION SLOT "test_tab1_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-11-27 10:12:17.970 GMT [2292][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:17.972 GMT [2292][walsender] [[unknown]][24/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:17.972 GMT [2292][walsender] [[unknown]][24/1:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16390_sync_16384_7441897805488095464 2024-11-27 10:12:17.974 GMT [2292][walsender] [pg_16390_sync_16384_7441897805488095464][24/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-27 10:12:17.978 GMT [4724][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:17.989 GMT [2292][walsender] [pg_16390_sync_16384_7441897805488095464][24/3:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-11-27 10:12:17.989 GMT [2292][walsender] [pg_16390_sync_16384_7441897805488095464][24/3:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16390_sync_16384_7441897805488095464" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-27 10:12:17.989 GMT [2292][walsender] [pg_16390_sync_16384_7441897805488095464][24/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16390_sync_16384_7441897805488095464" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-27 10:12:17.989 GMT [4724][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:17.989 GMT [4724][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-11-27 10:12:17.997 GMT [4724][client backend] [026_stats.pl][2/2:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-27 10:12:17.999 GMT [2292][walsender] [pg_16390_sync_16384_7441897805488095464][24/3:0] LOG: logical decoding found consistent point at 0/177E780 2024-11-27 10:12:17.999 GMT [2292][walsender] [pg_16390_sync_16384_7441897805488095464][24/3:0] DETAIL: There are no running transactions. 2024-11-27 10:12:17.999 GMT [2292][walsender] [pg_16390_sync_16384_7441897805488095464][24/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16390_sync_16384_7441897805488095464" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-27 10:12:18.000 GMT [4724][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.038 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:18.000 GMT [2292][walsender] [pg_16390_sync_16384_7441897805488095464][24/3:0] LOG: released logical replication slot "pg_16390_sync_16384_7441897805488095464" 2024-11-27 10:12:18.000 GMT [2292][walsender] [pg_16390_sync_16384_7441897805488095464][24/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16390_sync_16384_7441897805488095464" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-27 10:12:18.001 GMT [2292][walsender] [pg_16390_sync_16384_7441897805488095464][24/3:0] LOG: statement: SELECT c.oid, c.relreplident, c.relkind FROM pg_catalog.pg_class c INNER JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) WHERE n.nspname = 'public' AND c.relname = 'test_tab1' 2024-11-27 10:12:18.005 GMT [2292][walsender] [pg_16390_sync_16384_7441897805488095464][24/3:0] LOG: statement: SELECT DISTINCT (CASE WHEN (array_length(gpt.attrs, 1) = c.relnatts) THEN NULL ELSE gpt.attrs END) FROM pg_publication p, LATERAL pg_get_publication_tables(p.pubname) gpt, pg_class c WHERE gpt.relid = 16384 AND c.oid = gpt.relid AND p.pubname IN ( 'test_tab1_pub' ) 2024-11-27 10:12:18.009 GMT [2292][walsender] [pg_16390_sync_16384_7441897805488095464][24/3:0] LOG: statement: SELECT a.attnum, a.attname, a.atttypid, a.attnum = ANY(i.indkey), a.attgenerated != '' FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_index i ON (i.indexrelid = pg_get_replica_identity_index(16384)) WHERE a.attnum > 0::pg_catalog.int2 AND NOT a.attisdropped AND a.attrelid = 16384 ORDER BY a.attnum 2024-11-27 10:12:18.011 GMT [2292][walsender] [pg_16390_sync_16384_7441897805488095464][24/3:0] LOG: statement: SELECT DISTINCT pg_get_expr(gpt.qual, gpt.relid) FROM pg_publication p, LATERAL pg_get_publication_tables(p.pubname) gpt WHERE gpt.relid = 16384 AND p.pubname IN ( 'test_tab1_pub' ) 2024-11-27 10:12:18.013 GMT [2292][walsender] [pg_16390_sync_16384_7441897805488095464][24/3:0] LOG: statement: COPY public.test_tab1 (a) TO STDOUT 2024-11-27 10:12:18.014 GMT [2292][walsender] [pg_16390_sync_16384_7441897805488095464][:0] LOG: disconnection: session time: 0:00:00.046 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:18.089 GMT [7696][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:18.090 GMT [7696][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:18.090 GMT [7696][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-11-27 10:12:18.099 GMT [7696][client backend] [026_stats.pl][3/2:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-27 10:12:18.102 GMT [7696][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:18.223 GMT [4636][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:18.225 GMT [4636][client backend] [[unknown]][4/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:18.225 GMT [4636][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-11-27 10:12:18.228 GMT [4636][client backend] [026_stats.pl][4/2:0] LOG: statement: SELECT '0/177E7B8' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('test_tab1_sub', 'walreceiver') 2024-11-27 10:12:18.238 GMT [4636][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:19.093 GMT [3384][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:19.094 GMT [3384][walsender] [[unknown]][25/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:19.094 GMT [3384][walsender] [[unknown]][25/1:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16390_sync_16384_7441897805488095464 2024-11-27 10:12:19.097 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-27 10:12:19.098 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16390_sync_16384_7441897805488095464 WAIT 2024-11-27 10:12:19.098 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16390_sync_16384_7441897805488095464 WAIT 2024-11-27 10:12:19.098 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/0:0] LOG: acquired logical replication slot "pg_16390_sync_16384_7441897805488095464" 2024-11-27 10:12:19.098 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16390_sync_16384_7441897805488095464 WAIT 2024-11-27 10:12:19.099 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/3:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-11-27 10:12:19.099 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/3:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16390_sync_16384_7441897805488095464" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-27 10:12:19.099 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16390_sync_16384_7441897805488095464" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-27 10:12:19.107 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/3:0] LOG: logical decoding found consistent point at 0/177E7B8 2024-11-27 10:12:19.107 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/3:0] DETAIL: There are no running transactions. 2024-11-27 10:12:19.107 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16390_sync_16384_7441897805488095464" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-27 10:12:19.109 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/3:0] LOG: released logical replication slot "pg_16390_sync_16384_7441897805488095464" 2024-11-27 10:12:19.109 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16390_sync_16384_7441897805488095464" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-27 10:12:19.109 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/3:0] LOG: statement: SELECT c.oid, c.relreplident, c.relkind FROM pg_catalog.pg_class c INNER JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) WHERE n.nspname = 'public' AND c.relname = 'test_tab1' 2024-11-27 10:12:19.113 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/3:0] LOG: statement: SELECT DISTINCT (CASE WHEN (array_length(gpt.attrs, 1) = c.relnatts) THEN NULL ELSE gpt.attrs END) FROM pg_publication p, LATERAL pg_get_publication_tables(p.pubname) gpt, pg_class c WHERE gpt.relid = 16384 AND c.oid = gpt.relid AND p.pubname IN ( 'test_tab1_pub' ) 2024-11-27 10:12:19.117 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/3:0] LOG: statement: SELECT a.attnum, a.attname, a.atttypid, a.attnum = ANY(i.indkey), a.attgenerated != '' FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_index i ON (i.indexrelid = pg_get_replica_identity_index(16384)) WHERE a.attnum > 0::pg_catalog.int2 AND NOT a.attisdropped AND a.attrelid = 16384 ORDER BY a.attnum 2024-11-27 10:12:19.128 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/3:0] LOG: statement: SELECT DISTINCT pg_get_expr(gpt.qual, gpt.relid) FROM pg_publication p, LATERAL pg_get_publication_tables(p.pubname) gpt WHERE gpt.relid = 16384 AND p.pubname IN ( 'test_tab1_pub' ) 2024-11-27 10:12:19.129 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/3:0] LOG: statement: COPY public.test_tab1 (a) TO STDOUT 2024-11-27 10:12:19.132 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/3:0] LOG: statement: COMMIT 2024-11-27 10:12:19.132 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/0:0] LOG: received replication command: START_REPLICATION SLOT "pg_16390_sync_16384_7441897805488095464" LOGICAL 0/177E7F0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-11-27 10:12:19.132 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/0:0] STATEMENT: START_REPLICATION SLOT "pg_16390_sync_16384_7441897805488095464" LOGICAL 0/177E7F0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-11-27 10:12:19.132 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/0:0] LOG: acquired logical replication slot "pg_16390_sync_16384_7441897805488095464" 2024-11-27 10:12:19.132 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/0:0] STATEMENT: START_REPLICATION SLOT "pg_16390_sync_16384_7441897805488095464" LOGICAL 0/177E7F0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-11-27 10:12:19.133 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/0:0] LOG: starting logical decoding for slot "pg_16390_sync_16384_7441897805488095464" 2024-11-27 10:12:19.133 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/0:0] DETAIL: Streaming transactions committing after 0/177E7F0, reading WAL from 0/177E7B8. 2024-11-27 10:12:19.133 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/0:0] STATEMENT: START_REPLICATION SLOT "pg_16390_sync_16384_7441897805488095464" LOGICAL 0/177E7F0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-11-27 10:12:19.133 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/0:0] LOG: logical decoding found consistent point at 0/177E7B8 2024-11-27 10:12:19.133 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/0:0] DETAIL: There are no running transactions. 2024-11-27 10:12:19.133 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/0:0] STATEMENT: START_REPLICATION SLOT "pg_16390_sync_16384_7441897805488095464" LOGICAL 0/177E7F0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-11-27 10:12:19.133 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/0:0] LOG: released logical replication slot "pg_16390_sync_16384_7441897805488095464" 2024-11-27 10:12:19.133 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/0:0] STATEMENT: START_REPLICATION SLOT "pg_16390_sync_16384_7441897805488095464" LOGICAL 0/177E7F0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-11-27 10:12:19.133 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16390_sync_16384_7441897805488095464 WAIT 2024-11-27 10:12:19.133 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16390_sync_16384_7441897805488095464 WAIT 2024-11-27 10:12:19.133 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/0:0] LOG: acquired logical replication slot "pg_16390_sync_16384_7441897805488095464" 2024-11-27 10:12:19.133 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][25/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16390_sync_16384_7441897805488095464 WAIT 2024-11-27 10:12:19.138 GMT [3384][walsender] [pg_16390_sync_16384_7441897805488095464][:0] LOG: disconnection: session time: 0:00:00.048 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:19.558 GMT [6644][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:19.559 GMT [6644][client backend] [[unknown]][5/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:19.559 GMT [6644][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-11-27 10:12:19.563 GMT [6644][client backend] [026_stats.pl][5/2:0] LOG: statement: INSERT INTO test_tab1 VALUES (1) 2024-11-27 10:12:19.564 GMT [6644][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:19.567 GMT [5740][walsender] [test_tab1_sub][23/0:0] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2024-11-27 10:12:19.567 GMT [5740][walsender] [test_tab1_sub][23/0:0] STATEMENT: START_REPLICATION SLOT "test_tab1_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-11-27 10:12:19.567 GMT [5740][walsender] [test_tab1_sub][23/0:0] LOG: unexpected EOF on standby connection 2024-11-27 10:12:19.567 GMT [5740][walsender] [test_tab1_sub][23/0:0] STATEMENT: START_REPLICATION SLOT "test_tab1_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-11-27 10:12:19.567 GMT [5740][walsender] [test_tab1_sub][23/0:0] LOG: released logical replication slot "test_tab1_sub" 2024-11-27 10:12:19.567 GMT [5740][walsender] [test_tab1_sub][:0] LOG: disconnection: session time: 0:00:01.714 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:19.615 GMT [2464][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:19.616 GMT [2464][walsender] [[unknown]][26/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:19.616 GMT [2464][walsender] [[unknown]][26/1:0] LOG: replication connection authorized: user=SYSTEM application_name=test_tab1_sub 2024-11-27 10:12:19.621 GMT [2464][walsender] [test_tab1_sub][26/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-27 10:12:19.621 GMT [2464][walsender] [test_tab1_sub][26/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-27 10:12:19.621 GMT [2464][walsender] [test_tab1_sub][26/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-27 10:12:19.621 GMT [2464][walsender] [test_tab1_sub][26/0:0] LOG: received replication command: START_REPLICATION SLOT "test_tab1_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-11-27 10:12:19.621 GMT [2464][walsender] [test_tab1_sub][26/0:0] STATEMENT: START_REPLICATION SLOT "test_tab1_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-11-27 10:12:19.621 GMT [2464][walsender] [test_tab1_sub][26/0:0] LOG: acquired logical replication slot "test_tab1_sub" 2024-11-27 10:12:19.621 GMT [2464][walsender] [test_tab1_sub][26/0:0] STATEMENT: START_REPLICATION SLOT "test_tab1_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-11-27 10:12:19.622 GMT [2464][walsender] [test_tab1_sub][26/0:0] LOG: starting logical decoding for slot "test_tab1_sub" 2024-11-27 10:12:19.622 GMT [2464][walsender] [test_tab1_sub][26/0:0] DETAIL: Streaming transactions committing after 0/177E7F0, reading WAL from 0/177E7B8. 2024-11-27 10:12:19.622 GMT [2464][walsender] [test_tab1_sub][26/0:0] STATEMENT: START_REPLICATION SLOT "test_tab1_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-11-27 10:12:19.622 GMT [2464][walsender] [test_tab1_sub][26/0:0] LOG: logical decoding found consistent point at 0/177E7B8 2024-11-27 10:12:19.622 GMT [2464][walsender] [test_tab1_sub][26/0:0] DETAIL: There are no running transactions. 2024-11-27 10:12:19.622 GMT [2464][walsender] [test_tab1_sub][26/0:0] STATEMENT: START_REPLICATION SLOT "test_tab1_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-11-27 10:12:19.624 GMT [2464][walsender] [test_tab1_sub][26/0:0] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2024-11-27 10:12:19.624 GMT [2464][walsender] [test_tab1_sub][26/0:0] STATEMENT: START_REPLICATION SLOT "test_tab1_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-11-27 10:12:19.624 GMT [2464][walsender] [test_tab1_sub][26/0:0] LOG: unexpected EOF on standby connection 2024-11-27 10:12:19.624 GMT [2464][walsender] [test_tab1_sub][26/0:0] STATEMENT: START_REPLICATION SLOT "test_tab1_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-11-27 10:12:19.624 GMT [2464][walsender] [test_tab1_sub][26/0:0] LOG: released logical replication slot "test_tab1_sub" 2024-11-27 10:12:19.624 GMT [2464][walsender] [test_tab1_sub][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:19.838 GMT [6516][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:19.839 GMT [6516][client backend] [[unknown]][6/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:19.839 GMT [6516][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-11-27 10:12:19.842 GMT [6516][client backend] [026_stats.pl][6/2:0] LOG: statement: DELETE FROM test_tab1; 2024-11-27 10:12:19.846 GMT [6516][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:20.117 GMT [5044][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:20.118 GMT [5044][walsender] [[unknown]][27/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:20.118 GMT [5044][walsender] [[unknown]][27/1:0] LOG: replication connection authorized: user=SYSTEM application_name=test_tab1_sub 2024-11-27 10:12:20.121 GMT [5044][walsender] [test_tab1_sub][27/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-27 10:12:20.121 GMT [5044][walsender] [test_tab1_sub][27/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-27 10:12:20.121 GMT [5044][walsender] [test_tab1_sub][27/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-27 10:12:20.121 GMT [5044][walsender] [test_tab1_sub][27/0:0] LOG: received replication command: START_REPLICATION SLOT "test_tab1_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-11-27 10:12:20.121 GMT [5044][walsender] [test_tab1_sub][27/0:0] STATEMENT: START_REPLICATION SLOT "test_tab1_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-11-27 10:12:20.121 GMT [5044][walsender] [test_tab1_sub][27/0:0] LOG: acquired logical replication slot "test_tab1_sub" 2024-11-27 10:12:20.121 GMT [5044][walsender] [test_tab1_sub][27/0:0] STATEMENT: START_REPLICATION SLOT "test_tab1_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-11-27 10:12:20.122 GMT [5044][walsender] [test_tab1_sub][27/0:0] LOG: starting logical decoding for slot "test_tab1_sub" 2024-11-27 10:12:20.122 GMT [5044][walsender] [test_tab1_sub][27/0:0] DETAIL: Streaming transactions committing after 0/177E7F0, reading WAL from 0/177E7B8. 2024-11-27 10:12:20.122 GMT [5044][walsender] [test_tab1_sub][27/0:0] STATEMENT: START_REPLICATION SLOT "test_tab1_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-11-27 10:12:20.122 GMT [5044][walsender] [test_tab1_sub][27/0:0] LOG: logical decoding found consistent point at 0/177E7B8 2024-11-27 10:12:20.122 GMT [5044][walsender] [test_tab1_sub][27/0:0] DETAIL: There are no running transactions. 2024-11-27 10:12:20.122 GMT [5044][walsender] [test_tab1_sub][27/0:0] STATEMENT: START_REPLICATION SLOT "test_tab1_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-11-27 10:12:21.230 GMT [6280][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:21.231 GMT [6280][client backend] [[unknown]][7/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:21.231 GMT [6280][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-11-27 10:12:21.234 GMT [6280][client backend] [026_stats.pl][7/2:0] LOG: statement: BEGIN; 2024-11-27 10:12:21.234 GMT [6280][client backend] [026_stats.pl][7/2:0] LOG: statement: CREATE TABLE test_tab2(a int); 2024-11-27 10:12:21.237 GMT [6280][client backend] [026_stats.pl][7/2:750] LOG: statement: ALTER TABLE test_tab2 REPLICA IDENTITY FULL; 2024-11-27 10:12:21.238 GMT [6280][client backend] [026_stats.pl][7/2:750] LOG: statement: INSERT INTO test_tab2 VALUES (1); 2024-11-27 10:12:21.238 GMT [6280][client backend] [026_stats.pl][7/2:750] LOG: statement: COMMIT; 2024-11-27 10:12:21.239 GMT [6280][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:21.431 GMT [7880][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:21.432 GMT [7880][client backend] [[unknown]][8/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:21.432 GMT [7880][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-11-27 10:12:21.434 GMT [7880][client backend] [026_stats.pl][8/2:0] LOG: statement: CREATE PUBLICATION test_tab2_pub FOR TABLE test_tab2 2024-11-27 10:12:21.436 GMT [7880][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:21.557 GMT [4616][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:21.559 GMT [4616][walsender] [[unknown]][28/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:21.559 GMT [4616][walsender] [[unknown]][28/1:0] LOG: replication connection authorized: user=SYSTEM application_name=test_tab2_sub 2024-11-27 10:12:21.562 GMT [4616][walsender] [test_tab2_sub][28/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-27 10:12:21.563 GMT [4616][walsender] [test_tab2_sub][28/3:0] LOG: statement: SELECT t.pubname FROM pg_catalog.pg_publication t WHERE t.pubname IN ('test_tab2_pub') 2024-11-27 10:12:21.566 GMT [4616][walsender] [test_tab2_sub][28/4:0] LOG: statement: SELECT DISTINCT n.nspname, c.relname, gpt.attrs FROM pg_class c JOIN pg_namespace n ON n.oid = c.relnamespace JOIN ( SELECT (pg_get_publication_tables(VARIADIC array_agg(pubname::text))).* FROM pg_publication WHERE pubname IN ( 'test_tab2_pub' )) AS gpt ON gpt.relid = c.oid 2024-11-27 10:12:21.575 GMT [4616][walsender] [test_tab2_sub][28/0:0] LOG: received replication command: CREATE_REPLICATION_SLOT "test_tab2_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-27 10:12:21.575 GMT [4616][walsender] [test_tab2_sub][28/0:0] STATEMENT: CREATE_REPLICATION_SLOT "test_tab2_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-27 10:12:21.578 GMT [4616][walsender] [test_tab2_sub][28/0:0] LOG: logical decoding found consistent point at 0/1780618 2024-11-27 10:12:21.578 GMT [4616][walsender] [test_tab2_sub][28/0:0] DETAIL: There are no running transactions. 2024-11-27 10:12:21.578 GMT [4616][walsender] [test_tab2_sub][28/0:0] STATEMENT: CREATE_REPLICATION_SLOT "test_tab2_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-27 10:12:21.578 GMT [4616][walsender] [test_tab2_sub][28/0:0] LOG: released logical replication slot "test_tab2_sub" 2024-11-27 10:12:21.578 GMT [4616][walsender] [test_tab2_sub][28/0:0] STATEMENT: CREATE_REPLICATION_SLOT "test_tab2_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-27 10:12:21.579 GMT [4616][walsender] [test_tab2_sub][:0] LOG: disconnection: session time: 0:00:00.025 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:21.760 GMT [7172][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:21.761 GMT [7172][walsender] [[unknown]][29/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:21.761 GMT [7172][walsender] [[unknown]][29/1:0] LOG: replication connection authorized: user=SYSTEM application_name=test_tab2_sub 2024-11-27 10:12:21.765 GMT [7172][walsender] [test_tab2_sub][29/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-27 10:12:21.765 GMT [7172][walsender] [test_tab2_sub][29/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-27 10:12:21.765 GMT [7172][walsender] [test_tab2_sub][29/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-27 10:12:21.766 GMT [7172][walsender] [test_tab2_sub][29/0:0] LOG: received replication command: START_REPLICATION SLOT "test_tab2_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-11-27 10:12:21.766 GMT [7172][walsender] [test_tab2_sub][29/0:0] STATEMENT: START_REPLICATION SLOT "test_tab2_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-11-27 10:12:21.766 GMT [7172][walsender] [test_tab2_sub][29/0:0] LOG: acquired logical replication slot "test_tab2_sub" 2024-11-27 10:12:21.766 GMT [7172][walsender] [test_tab2_sub][29/0:0] STATEMENT: START_REPLICATION SLOT "test_tab2_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-11-27 10:12:21.766 GMT [7172][walsender] [test_tab2_sub][29/0:0] LOG: starting logical decoding for slot "test_tab2_sub" 2024-11-27 10:12:21.766 GMT [7172][walsender] [test_tab2_sub][29/0:0] DETAIL: Streaming transactions committing after 0/1780650, reading WAL from 0/1780618. 2024-11-27 10:12:21.766 GMT [7172][walsender] [test_tab2_sub][29/0:0] STATEMENT: START_REPLICATION SLOT "test_tab2_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-11-27 10:12:21.766 GMT [7172][walsender] [test_tab2_sub][29/0:0] LOG: logical decoding found consistent point at 0/1780618 2024-11-27 10:12:21.766 GMT [7172][walsender] [test_tab2_sub][29/0:0] DETAIL: There are no running transactions. 2024-11-27 10:12:21.766 GMT [7172][walsender] [test_tab2_sub][29/0:0] STATEMENT: START_REPLICATION SLOT "test_tab2_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-11-27 10:12:21.809 GMT [4672][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:21.810 GMT [4672][client backend] [[unknown]][9/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:21.810 GMT [4672][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-11-27 10:12:21.813 GMT [4672][client backend] [026_stats.pl][9/2:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-27 10:12:21.816 GMT [4672][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:21.834 GMT [1728][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:21.835 GMT [1728][walsender] [[unknown]][30/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:21.835 GMT [1728][walsender] [[unknown]][30/1:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16401_sync_16395_7441897805488095464 2024-11-27 10:12:21.838 GMT [1728][walsender] [pg_16401_sync_16395_7441897805488095464][30/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-27 10:12:21.839 GMT [1728][walsender] [pg_16401_sync_16395_7441897805488095464][30/3:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-11-27 10:12:21.839 GMT [1728][walsender] [pg_16401_sync_16395_7441897805488095464][30/3:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16401_sync_16395_7441897805488095464" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-27 10:12:21.839 GMT [1728][walsender] [pg_16401_sync_16395_7441897805488095464][30/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16401_sync_16395_7441897805488095464" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-27 10:12:21.843 GMT [1728][walsender] [pg_16401_sync_16395_7441897805488095464][30/3:0] LOG: logical decoding found consistent point at 0/1780650 2024-11-27 10:12:21.843 GMT [1728][walsender] [pg_16401_sync_16395_7441897805488095464][30/3:0] DETAIL: There are no running transactions. 2024-11-27 10:12:21.843 GMT [1728][walsender] [pg_16401_sync_16395_7441897805488095464][30/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16401_sync_16395_7441897805488095464" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-27 10:12:21.844 GMT [1728][walsender] [pg_16401_sync_16395_7441897805488095464][30/3:0] LOG: released logical replication slot "pg_16401_sync_16395_7441897805488095464" 2024-11-27 10:12:21.844 GMT [1728][walsender] [pg_16401_sync_16395_7441897805488095464][30/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16401_sync_16395_7441897805488095464" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-27 10:12:21.844 GMT [1728][walsender] [pg_16401_sync_16395_7441897805488095464][30/3:0] LOG: statement: SELECT c.oid, c.relreplident, c.relkind FROM pg_catalog.pg_class c INNER JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) WHERE n.nspname = 'public' AND c.relname = 'test_tab2' 2024-11-27 10:12:21.849 GMT [1728][walsender] [pg_16401_sync_16395_7441897805488095464][30/3:0] LOG: statement: SELECT DISTINCT (CASE WHEN (array_length(gpt.attrs, 1) = c.relnatts) THEN NULL ELSE gpt.attrs END) FROM pg_publication p, LATERAL pg_get_publication_tables(p.pubname) gpt, pg_class c WHERE gpt.relid = 16389 AND c.oid = gpt.relid AND p.pubname IN ( 'test_tab2_pub' ) 2024-11-27 10:12:21.855 GMT [1728][walsender] [pg_16401_sync_16395_7441897805488095464][30/3:0] LOG: statement: SELECT a.attnum, a.attname, a.atttypid, a.attnum = ANY(i.indkey), a.attgenerated != '' FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_index i ON (i.indexrelid = pg_get_replica_identity_index(16389)) WHERE a.attnum > 0::pg_catalog.int2 AND NOT a.attisdropped AND a.attrelid = 16389 ORDER BY a.attnum 2024-11-27 10:12:21.858 GMT [1728][walsender] [pg_16401_sync_16395_7441897805488095464][30/3:0] LOG: statement: SELECT DISTINCT pg_get_expr(gpt.qual, gpt.relid) FROM pg_publication p, LATERAL pg_get_publication_tables(p.pubname) gpt WHERE gpt.relid = 16389 AND p.pubname IN ( 'test_tab2_pub' ) 2024-11-27 10:12:21.860 GMT [1728][walsender] [pg_16401_sync_16395_7441897805488095464][30/3:0] LOG: statement: COPY public.test_tab2 (a) TO STDOUT 2024-11-27 10:12:21.862 GMT [1728][walsender] [pg_16401_sync_16395_7441897805488095464][:0] LOG: disconnection: session time: 0:00:00.031 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:21.947 GMT [8092][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:21.949 GMT [8092][client backend] [[unknown]][0/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:21.949 GMT [8092][client backend] [[unknown]][0/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-11-27 10:12:21.961 GMT [8092][client backend] [026_stats.pl][0/4:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-27 10:12:21.964 GMT [8092][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.021 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:22.071 GMT [5172][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:22.073 GMT [5172][client backend] [[unknown]][1/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:22.073 GMT [5172][client backend] [[unknown]][1/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-11-27 10:12:22.075 GMT [5172][client backend] [026_stats.pl][1/4:0] LOG: statement: SELECT '0/1780688' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('test_tab2_sub', 'walreceiver') 2024-11-27 10:12:22.085 GMT [5172][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:22.954 GMT [6160][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:22.956 GMT [6160][walsender] [[unknown]][31/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:22.956 GMT [6160][walsender] [[unknown]][31/1:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16401_sync_16395_7441897805488095464 2024-11-27 10:12:22.958 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-27 10:12:22.959 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16401_sync_16395_7441897805488095464 WAIT 2024-11-27 10:12:22.959 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16401_sync_16395_7441897805488095464 WAIT 2024-11-27 10:12:22.959 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/0:0] LOG: acquired logical replication slot "pg_16401_sync_16395_7441897805488095464" 2024-11-27 10:12:22.959 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16401_sync_16395_7441897805488095464 WAIT 2024-11-27 10:12:22.961 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/3:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-11-27 10:12:22.961 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/3:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16401_sync_16395_7441897805488095464" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-27 10:12:22.961 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16401_sync_16395_7441897805488095464" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-27 10:12:22.963 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/3:0] LOG: logical decoding found consistent point at 0/1780688 2024-11-27 10:12:22.963 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/3:0] DETAIL: There are no running transactions. 2024-11-27 10:12:22.963 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16401_sync_16395_7441897805488095464" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-27 10:12:22.965 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/3:0] LOG: released logical replication slot "pg_16401_sync_16395_7441897805488095464" 2024-11-27 10:12:22.965 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16401_sync_16395_7441897805488095464" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-27 10:12:22.965 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/3:0] LOG: statement: SELECT c.oid, c.relreplident, c.relkind FROM pg_catalog.pg_class c INNER JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) WHERE n.nspname = 'public' AND c.relname = 'test_tab2' 2024-11-27 10:12:22.969 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/3:0] LOG: statement: SELECT DISTINCT (CASE WHEN (array_length(gpt.attrs, 1) = c.relnatts) THEN NULL ELSE gpt.attrs END) FROM pg_publication p, LATERAL pg_get_publication_tables(p.pubname) gpt, pg_class c WHERE gpt.relid = 16389 AND c.oid = gpt.relid AND p.pubname IN ( 'test_tab2_pub' ) 2024-11-27 10:12:22.973 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/3:0] LOG: statement: SELECT a.attnum, a.attname, a.atttypid, a.attnum = ANY(i.indkey), a.attgenerated != '' FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_index i ON (i.indexrelid = pg_get_replica_identity_index(16389)) WHERE a.attnum > 0::pg_catalog.int2 AND NOT a.attisdropped AND a.attrelid = 16389 ORDER BY a.attnum 2024-11-27 10:12:22.975 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/3:0] LOG: statement: SELECT DISTINCT pg_get_expr(gpt.qual, gpt.relid) FROM pg_publication p, LATERAL pg_get_publication_tables(p.pubname) gpt WHERE gpt.relid = 16389 AND p.pubname IN ( 'test_tab2_pub' ) 2024-11-27 10:12:22.976 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/3:0] LOG: statement: COPY public.test_tab2 (a) TO STDOUT 2024-11-27 10:12:22.979 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/3:0] LOG: statement: COMMIT 2024-11-27 10:12:22.979 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/0:0] LOG: received replication command: START_REPLICATION SLOT "pg_16401_sync_16395_7441897805488095464" LOGICAL 0/17806C0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-11-27 10:12:22.979 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16401_sync_16395_7441897805488095464" LOGICAL 0/17806C0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-11-27 10:12:22.979 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/0:0] LOG: acquired logical replication slot "pg_16401_sync_16395_7441897805488095464" 2024-11-27 10:12:22.979 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16401_sync_16395_7441897805488095464" LOGICAL 0/17806C0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-11-27 10:12:22.980 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/0:0] LOG: starting logical decoding for slot "pg_16401_sync_16395_7441897805488095464" 2024-11-27 10:12:22.980 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/0:0] DETAIL: Streaming transactions committing after 0/17806C0, reading WAL from 0/1780688. 2024-11-27 10:12:22.980 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16401_sync_16395_7441897805488095464" LOGICAL 0/17806C0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-11-27 10:12:22.980 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/0:0] LOG: logical decoding found consistent point at 0/1780688 2024-11-27 10:12:22.980 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/0:0] DETAIL: There are no running transactions. 2024-11-27 10:12:22.980 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16401_sync_16395_7441897805488095464" LOGICAL 0/17806C0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-11-27 10:12:22.980 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/0:0] LOG: released logical replication slot "pg_16401_sync_16395_7441897805488095464" 2024-11-27 10:12:22.980 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16401_sync_16395_7441897805488095464" LOGICAL 0/17806C0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-11-27 10:12:22.980 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16401_sync_16395_7441897805488095464 WAIT 2024-11-27 10:12:22.980 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16401_sync_16395_7441897805488095464 WAIT 2024-11-27 10:12:22.980 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/0:0] LOG: acquired logical replication slot "pg_16401_sync_16395_7441897805488095464" 2024-11-27 10:12:22.980 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][31/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16401_sync_16395_7441897805488095464 WAIT 2024-11-27 10:12:22.983 GMT [6160][walsender] [pg_16401_sync_16395_7441897805488095464][:0] LOG: disconnection: session time: 0:00:00.031 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:23.289 GMT [5208][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:23.291 GMT [5208][client backend] [[unknown]][2/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:23.291 GMT [5208][client backend] [[unknown]][2/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-11-27 10:12:23.294 GMT [5208][client backend] [026_stats.pl][2/4:0] LOG: statement: INSERT INTO test_tab2 VALUES (1) 2024-11-27 10:12:23.295 GMT [5208][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:23.297 GMT [7172][walsender] [test_tab2_sub][29/0:0] LOG: released logical replication slot "test_tab2_sub" 2024-11-27 10:12:23.297 GMT [7172][walsender] [test_tab2_sub][:0] LOG: disconnection: session time: 0:00:01.540 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:23.366 GMT [1692][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:23.375 GMT [1692][walsender] [[unknown]][22/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:23.375 GMT [1692][walsender] [[unknown]][22/5:0] LOG: replication connection authorized: user=SYSTEM application_name=test_tab2_sub 2024-11-27 10:12:23.380 GMT [1692][walsender] [test_tab2_sub][22/6:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-27 10:12:23.381 GMT [1692][walsender] [test_tab2_sub][22/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-27 10:12:23.381 GMT [1692][walsender] [test_tab2_sub][22/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-27 10:12:23.381 GMT [1692][walsender] [test_tab2_sub][22/0:0] LOG: received replication command: START_REPLICATION SLOT "test_tab2_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-11-27 10:12:23.381 GMT [1692][walsender] [test_tab2_sub][22/0:0] STATEMENT: START_REPLICATION SLOT "test_tab2_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-11-27 10:12:23.381 GMT [1692][walsender] [test_tab2_sub][22/0:0] LOG: acquired logical replication slot "test_tab2_sub" 2024-11-27 10:12:23.381 GMT [1692][walsender] [test_tab2_sub][22/0:0] STATEMENT: START_REPLICATION SLOT "test_tab2_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-11-27 10:12:23.382 GMT [1692][walsender] [test_tab2_sub][22/0:0] LOG: starting logical decoding for slot "test_tab2_sub" 2024-11-27 10:12:23.382 GMT [1692][walsender] [test_tab2_sub][22/0:0] DETAIL: Streaming transactions committing after 0/17806C0, reading WAL from 0/1780688. 2024-11-27 10:12:23.382 GMT [1692][walsender] [test_tab2_sub][22/0:0] STATEMENT: START_REPLICATION SLOT "test_tab2_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-11-27 10:12:23.382 GMT [1692][walsender] [test_tab2_sub][22/0:0] LOG: logical decoding found consistent point at 0/1780688 2024-11-27 10:12:23.382 GMT [1692][walsender] [test_tab2_sub][22/0:0] DETAIL: There are no running transactions. 2024-11-27 10:12:23.382 GMT [1692][walsender] [test_tab2_sub][22/0:0] STATEMENT: START_REPLICATION SLOT "test_tab2_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-11-27 10:12:23.383 GMT [1692][walsender] [test_tab2_sub][22/0:0] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2024-11-27 10:12:23.383 GMT [1692][walsender] [test_tab2_sub][22/0:0] STATEMENT: START_REPLICATION SLOT "test_tab2_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-11-27 10:12:23.383 GMT [1692][walsender] [test_tab2_sub][22/0:0] LOG: unexpected EOF on standby connection 2024-11-27 10:12:23.383 GMT [1692][walsender] [test_tab2_sub][22/0:0] STATEMENT: START_REPLICATION SLOT "test_tab2_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-11-27 10:12:23.383 GMT [1692][walsender] [test_tab2_sub][22/0:0] LOG: released logical replication slot "test_tab2_sub" 2024-11-27 10:12:23.383 GMT [1692][walsender] [test_tab2_sub][:0] LOG: disconnection: session time: 0:00:00.028 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:23.621 GMT [8036][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:23.623 GMT [8036][client backend] [[unknown]][3/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:23.623 GMT [8036][client backend] [[unknown]][3/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-11-27 10:12:23.626 GMT [8036][client backend] [026_stats.pl][3/4:0] LOG: statement: DELETE FROM test_tab2; 2024-11-27 10:12:23.627 GMT [8036][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:23.835 GMT [3196][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:23.836 GMT [3196][walsender] [[unknown]][24/4:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:23.836 GMT [3196][walsender] [[unknown]][24/4:0] LOG: replication connection authorized: user=SYSTEM application_name=test_tab2_sub 2024-11-27 10:12:23.839 GMT [3196][walsender] [test_tab2_sub][24/5:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-27 10:12:23.839 GMT [3196][walsender] [test_tab2_sub][24/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-27 10:12:23.839 GMT [3196][walsender] [test_tab2_sub][24/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-27 10:12:23.839 GMT [3196][walsender] [test_tab2_sub][24/0:0] LOG: received replication command: START_REPLICATION SLOT "test_tab2_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-11-27 10:12:23.839 GMT [3196][walsender] [test_tab2_sub][24/0:0] STATEMENT: START_REPLICATION SLOT "test_tab2_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-11-27 10:12:23.839 GMT [3196][walsender] [test_tab2_sub][24/0:0] LOG: acquired logical replication slot "test_tab2_sub" 2024-11-27 10:12:23.839 GMT [3196][walsender] [test_tab2_sub][24/0:0] STATEMENT: START_REPLICATION SLOT "test_tab2_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-11-27 10:12:23.840 GMT [3196][walsender] [test_tab2_sub][24/0:0] LOG: starting logical decoding for slot "test_tab2_sub" 2024-11-27 10:12:23.840 GMT [3196][walsender] [test_tab2_sub][24/0:0] DETAIL: Streaming transactions committing after 0/17806C0, reading WAL from 0/1780688. 2024-11-27 10:12:23.840 GMT [3196][walsender] [test_tab2_sub][24/0:0] STATEMENT: START_REPLICATION SLOT "test_tab2_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-11-27 10:12:23.840 GMT [3196][walsender] [test_tab2_sub][24/0:0] LOG: logical decoding found consistent point at 0/1780688 2024-11-27 10:12:23.840 GMT [3196][walsender] [test_tab2_sub][24/0:0] DETAIL: There are no running transactions. 2024-11-27 10:12:23.840 GMT [3196][walsender] [test_tab2_sub][24/0:0] STATEMENT: START_REPLICATION SLOT "test_tab2_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-11-27 10:12:25.273 GMT [5044][walsender] [test_tab1_sub][27/0:0] LOG: released logical replication slot "test_tab1_sub" 2024-11-27 10:12:25.273 GMT [5044][walsender] [test_tab1_sub][:0] LOG: disconnection: session time: 0:00:05.159 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:25.310 GMT [4868][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:25.316 GMT [4868][walsender] [[unknown]][25/4:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:25.316 GMT [4868][walsender] [[unknown]][25/4:0] LOG: replication connection authorized: user=SYSTEM application_name=test_tab1_sub 2024-11-27 10:12:25.319 GMT [4868][walsender] [test_tab1_sub][25/5:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-27 10:12:25.320 GMT [4868][walsender] [test_tab1_sub][25/0:0] LOG: received replication command: DROP_REPLICATION_SLOT test_tab1_sub WAIT 2024-11-27 10:12:25.320 GMT [4868][walsender] [test_tab1_sub][25/0:0] STATEMENT: DROP_REPLICATION_SLOT test_tab1_sub WAIT 2024-11-27 10:12:25.320 GMT [4868][walsender] [test_tab1_sub][25/0:0] LOG: acquired logical replication slot "test_tab1_sub" 2024-11-27 10:12:25.320 GMT [4868][walsender] [test_tab1_sub][25/0:0] STATEMENT: DROP_REPLICATION_SLOT test_tab1_sub WAIT 2024-11-27 10:12:25.325 GMT [4868][walsender] [test_tab1_sub][:0] LOG: disconnection: session time: 0:00:00.020 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:25.558 GMT [3196][walsender] [test_tab2_sub][24/0:0] LOG: released logical replication slot "test_tab2_sub" 2024-11-27 10:12:25.558 GMT [3196][walsender] [test_tab2_sub][:0] LOG: disconnection: session time: 0:00:01.726 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:25.719 GMT [4964][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:25.720 GMT [4964][client backend] [[unknown]][4/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:25.720 GMT [4964][client backend] [[unknown]][4/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-11-27 10:12:25.723 GMT [4964][client backend] [026_stats.pl][4/4:0] LOG: statement: SELECT EXISTS (SELECT 1 FROM pg_replication_slots WHERE slot_name = 'test_tab2_sub' AND active_pid IS NULL) 2024-11-27 10:12:25.730 GMT [4964][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:25.810 GMT [6992][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 10:12:25.811 GMT [6992][client backend] [[unknown]][5/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata/pg_hba.conf:117) 2024-11-27 10:12:25.811 GMT [6992][client backend] [[unknown]][5/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-11-27 10:12:25.815 GMT [6992][client backend] [026_stats.pl][5/4:0] LOG: statement: SELECT pg_drop_replication_slot('test_tab2_sub') 2024-11-27 10:12:25.819 GMT [6992][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2024-11-27 10:12:27.121 GMT [1552][postmaster] LOG: received immediate shutdown request TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2887, PID: 1552 abort() has been called