2024-12-14 21:09:14.461 GMT [3136][postmaster] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30157, 64-bit 2024-12-14 21:09:14.462 GMT [3136][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/DKUsD5iV3P/.s.PGSQL.30733" 2024-12-14 21:09:14.493 GMT [7924][startup] LOG: database system was shut down at 2024-12-14 21:01:09 GMT 2024-12-14 21:09:14.502 GMT [3136][postmaster] LOG: database system is ready to accept connections 2024-12-14 21:09:16.401 GMT [4300][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:16.402 GMT [4300][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-12-14 21:09:16.402 GMT [4300][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-12-14 21:09:16.423 GMT [4300][client backend] [026_stats.pl][0/2:0] LOG: statement: BEGIN; 2024-12-14 21:09:16.423 GMT [4300][client backend] [026_stats.pl][0/2:0] LOG: statement: CREATE TABLE test_tab1(a int); 2024-12-14 21:09:16.430 GMT [4300][client backend] [026_stats.pl][0/2:746] LOG: statement: ALTER TABLE test_tab1 REPLICA IDENTITY FULL; 2024-12-14 21:09:16.431 GMT [4300][client backend] [026_stats.pl][0/2:746] LOG: statement: INSERT INTO test_tab1 VALUES (1); 2024-12-14 21:09:16.431 GMT [4300][client backend] [026_stats.pl][0/2:746] LOG: statement: COMMIT; 2024-12-14 21:09:16.432 GMT [4300][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.034 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:16.562 GMT [7688][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:16.564 GMT [7688][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-12-14 21:09:16.564 GMT [7688][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-12-14 21:09:16.568 GMT [7688][client backend] [026_stats.pl][1/2:0] LOG: statement: CREATE PUBLICATION test_tab1_pub FOR TABLE test_tab1 2024-12-14 21:09:16.574 GMT [7688][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:16.674 GMT [4492][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:16.677 GMT [4492][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-12-14 21:09:16.677 GMT [4492][walsender] [[unknown]][22/1:0] LOG: replication connection authorized: user=SYSTEM application_name=test_tab1_sub 2024-12-14 21:09:16.682 GMT [4492][walsender] [test_tab1_sub][22/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-12-14 21:09:16.683 GMT [4492][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-12-14 21:09:16.691 GMT [4492][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-12-14 21:09:16.701 GMT [4492][walsender] [test_tab1_sub][22/0:0] LOG: received replication command: CREATE_REPLICATION_SLOT "test_tab1_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-12-14 21:09:16.701 GMT [4492][walsender] [test_tab1_sub][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "test_tab1_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-12-14 21:09:16.705 GMT [4492][walsender] [test_tab1_sub][22/0:0] LOG: logical decoding found consistent point at 0/177F370 2024-12-14 21:09:16.705 GMT [4492][walsender] [test_tab1_sub][22/0:0] DETAIL: There are no running transactions. 2024-12-14 21:09:16.705 GMT [4492][walsender] [test_tab1_sub][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "test_tab1_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-12-14 21:09:16.706 GMT [4492][walsender] [test_tab1_sub][22/0:0] LOG: released logical replication slot "test_tab1_sub" 2024-12-14 21:09:16.706 GMT [4492][walsender] [test_tab1_sub][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "test_tab1_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-12-14 21:09:16.706 GMT [4492][walsender] [test_tab1_sub][:0] LOG: disconnection: session time: 0:00:00.037 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:16.777 GMT [5468][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:16.778 GMT [5468][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-12-14 21:09:16.778 GMT [5468][walsender] [[unknown]][23/1:0] LOG: replication connection authorized: user=SYSTEM application_name=test_tab1_sub 2024-12-14 21:09:16.793 GMT [5468][walsender] [test_tab1_sub][23/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-12-14 21:09:16.793 GMT [5468][walsender] [test_tab1_sub][23/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-12-14 21:09:16.793 GMT [5468][walsender] [test_tab1_sub][23/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-12-14 21:09:16.794 GMT [5468][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-12-14 21:09:16.794 GMT [5468][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-12-14 21:09:16.794 GMT [5468][walsender] [test_tab1_sub][23/0:0] LOG: acquired logical replication slot "test_tab1_sub" 2024-12-14 21:09:16.794 GMT [5468][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-12-14 21:09:16.794 GMT [5468][walsender] [test_tab1_sub][23/0:0] LOG: starting logical decoding for slot "test_tab1_sub" 2024-12-14 21:09:16.794 GMT [5468][walsender] [test_tab1_sub][23/0:0] DETAIL: Streaming transactions committing after 0/177F3A8, reading WAL from 0/177F370. 2024-12-14 21:09:16.794 GMT [5468][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-12-14 21:09:16.794 GMT [5468][walsender] [test_tab1_sub][23/0:0] LOG: logical decoding found consistent point at 0/177F370 2024-12-14 21:09:16.794 GMT [5468][walsender] [test_tab1_sub][23/0:0] DETAIL: There are no running transactions. 2024-12-14 21:09:16.794 GMT [5468][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-12-14 21:09:16.837 GMT [6340][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:16.839 GMT [6340][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-12-14 21:09:16.839 GMT [6340][walsender] [[unknown]][24/1:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16390_sync_16384_7448375526863917688 2024-12-14 21:09:16.847 GMT [6340][walsender] [pg_16390_sync_16384_7448375526863917688][24/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-12-14 21:09:16.848 GMT [6340][walsender] [pg_16390_sync_16384_7448375526863917688][24/3:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-12-14 21:09:16.848 GMT [6340][walsender] [pg_16390_sync_16384_7448375526863917688][24/3:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16390_sync_16384_7448375526863917688" LOGICAL pgoutput (SNAPSHOT 'use') 2024-12-14 21:09:16.848 GMT [6340][walsender] [pg_16390_sync_16384_7448375526863917688][24/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16390_sync_16384_7448375526863917688" LOGICAL pgoutput (SNAPSHOT 'use') 2024-12-14 21:09:16.853 GMT [6340][walsender] [pg_16390_sync_16384_7448375526863917688][24/3:0] LOG: logical decoding found consistent point at 0/177F3A8 2024-12-14 21:09:16.853 GMT [6340][walsender] [pg_16390_sync_16384_7448375526863917688][24/3:0] DETAIL: There are no running transactions. 2024-12-14 21:09:16.853 GMT [6340][walsender] [pg_16390_sync_16384_7448375526863917688][24/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16390_sync_16384_7448375526863917688" LOGICAL pgoutput (SNAPSHOT 'use') 2024-12-14 21:09:16.854 GMT [6340][walsender] [pg_16390_sync_16384_7448375526863917688][24/3:0] LOG: released logical replication slot "pg_16390_sync_16384_7448375526863917688" 2024-12-14 21:09:16.854 GMT [6340][walsender] [pg_16390_sync_16384_7448375526863917688][24/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16390_sync_16384_7448375526863917688" LOGICAL pgoutput (SNAPSHOT 'use') 2024-12-14 21:09:16.854 GMT [6340][walsender] [pg_16390_sync_16384_7448375526863917688][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-12-14 21:09:16.859 GMT [6340][walsender] [pg_16390_sync_16384_7448375526863917688][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-12-14 21:09:16.866 GMT [6340][walsender] [pg_16390_sync_16384_7448375526863917688][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-12-14 21:09:16.868 GMT [6340][walsender] [pg_16390_sync_16384_7448375526863917688][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-12-14 21:09:16.870 GMT [6340][walsender] [pg_16390_sync_16384_7448375526863917688][24/3:0] LOG: statement: COPY public.test_tab1 (a) TO STDOUT 2024-12-14 21:09:16.870 GMT [6124][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:16.871 GMT [6340][walsender] [pg_16390_sync_16384_7448375526863917688][:0] LOG: disconnection: session time: 0:00:00.036 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:16.872 GMT [6124][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-12-14 21:09:16.872 GMT [6124][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-12-14 21:09:16.875 GMT [6124][client backend] [026_stats.pl][2/2:0] LOG: statement: SELECT pg_is_in_recovery() 2024-12-14 21:09:16.877 GMT [6124][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:16.945 GMT [7424][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:16.946 GMT [7424][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-12-14 21:09:16.947 GMT [7424][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-12-14 21:09:16.949 GMT [7424][client backend] [026_stats.pl][3/2:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-12-14 21:09:16.952 GMT [7424][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:17.042 GMT [6528][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:17.043 GMT [6528][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-12-14 21:09:17.043 GMT [6528][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-12-14 21:09:17.045 GMT [6528][client backend] [026_stats.pl][4/2:0] LOG: statement: SELECT '0/177F3E0' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('test_tab1_sub', 'walreceiver') 2024-12-14 21:09:17.054 GMT [6528][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:17.947 GMT [1332][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:17.948 GMT [1332][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-12-14 21:09:17.948 GMT [1332][walsender] [[unknown]][25/1:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16390_sync_16384_7448375526863917688 2024-12-14 21:09:17.951 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-12-14 21:09:17.951 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16390_sync_16384_7448375526863917688 WAIT 2024-12-14 21:09:17.951 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16390_sync_16384_7448375526863917688 WAIT 2024-12-14 21:09:17.951 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/0:0] LOG: acquired logical replication slot "pg_16390_sync_16384_7448375526863917688" 2024-12-14 21:09:17.951 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16390_sync_16384_7448375526863917688 WAIT 2024-12-14 21:09:17.953 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/3:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-12-14 21:09:17.953 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/3:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16390_sync_16384_7448375526863917688" LOGICAL pgoutput (SNAPSHOT 'use') 2024-12-14 21:09:17.953 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16390_sync_16384_7448375526863917688" LOGICAL pgoutput (SNAPSHOT 'use') 2024-12-14 21:09:17.964 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/3:0] LOG: logical decoding found consistent point at 0/177F3E0 2024-12-14 21:09:17.964 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/3:0] DETAIL: There are no running transactions. 2024-12-14 21:09:17.964 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16390_sync_16384_7448375526863917688" LOGICAL pgoutput (SNAPSHOT 'use') 2024-12-14 21:09:17.965 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/3:0] LOG: released logical replication slot "pg_16390_sync_16384_7448375526863917688" 2024-12-14 21:09:17.965 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16390_sync_16384_7448375526863917688" LOGICAL pgoutput (SNAPSHOT 'use') 2024-12-14 21:09:17.965 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][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-12-14 21:09:17.969 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][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-12-14 21:09:17.973 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][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-12-14 21:09:17.975 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][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-12-14 21:09:17.977 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/3:0] LOG: statement: COPY public.test_tab1 (a) TO STDOUT 2024-12-14 21:09:17.978 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/3:0] LOG: statement: COMMIT 2024-12-14 21:09:17.978 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/0:0] LOG: received replication command: START_REPLICATION SLOT "pg_16390_sync_16384_7448375526863917688" LOGICAL 0/177F418 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-12-14 21:09:17.978 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/0:0] STATEMENT: START_REPLICATION SLOT "pg_16390_sync_16384_7448375526863917688" LOGICAL 0/177F418 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-12-14 21:09:17.978 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/0:0] LOG: acquired logical replication slot "pg_16390_sync_16384_7448375526863917688" 2024-12-14 21:09:17.978 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/0:0] STATEMENT: START_REPLICATION SLOT "pg_16390_sync_16384_7448375526863917688" LOGICAL 0/177F418 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-12-14 21:09:17.978 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/0:0] LOG: starting logical decoding for slot "pg_16390_sync_16384_7448375526863917688" 2024-12-14 21:09:17.978 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/0:0] DETAIL: Streaming transactions committing after 0/177F418, reading WAL from 0/177F3E0. 2024-12-14 21:09:17.978 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/0:0] STATEMENT: START_REPLICATION SLOT "pg_16390_sync_16384_7448375526863917688" LOGICAL 0/177F418 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-12-14 21:09:17.978 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/0:0] LOG: logical decoding found consistent point at 0/177F3E0 2024-12-14 21:09:17.978 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/0:0] DETAIL: There are no running transactions. 2024-12-14 21:09:17.978 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/0:0] STATEMENT: START_REPLICATION SLOT "pg_16390_sync_16384_7448375526863917688" LOGICAL 0/177F418 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-12-14 21:09:17.979 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/0:0] LOG: released logical replication slot "pg_16390_sync_16384_7448375526863917688" 2024-12-14 21:09:17.979 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/0:0] STATEMENT: START_REPLICATION SLOT "pg_16390_sync_16384_7448375526863917688" LOGICAL 0/177F418 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab1_pub"') 2024-12-14 21:09:17.979 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16390_sync_16384_7448375526863917688 WAIT 2024-12-14 21:09:17.979 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16390_sync_16384_7448375526863917688 WAIT 2024-12-14 21:09:17.979 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/0:0] LOG: acquired logical replication slot "pg_16390_sync_16384_7448375526863917688" 2024-12-14 21:09:17.979 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][25/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16390_sync_16384_7448375526863917688 WAIT 2024-12-14 21:09:17.980 GMT [1332][walsender] [pg_16390_sync_16384_7448375526863917688][:0] LOG: disconnection: session time: 0:00:00.036 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:18.258 GMT [7548][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:18.260 GMT [7548][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-12-14 21:09:18.260 GMT [7548][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-12-14 21:09:18.265 GMT [7548][client backend] [026_stats.pl][5/2:0] LOG: statement: INSERT INTO test_tab1 VALUES (1) 2024-12-14 21:09:18.266 GMT [7548][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:18.268 GMT [5468][walsender] [test_tab1_sub][23/0:0] LOG: released logical replication slot "test_tab1_sub" 2024-12-14 21:09:18.268 GMT [5468][walsender] [test_tab1_sub][:0] LOG: disconnection: session time: 0:00:01.495 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:18.318 GMT [6480][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:18.319 GMT [6480][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-12-14 21:09:18.319 GMT [6480][walsender] [[unknown]][26/1:0] LOG: replication connection authorized: user=SYSTEM application_name=test_tab1_sub 2024-12-14 21:09:18.322 GMT [6480][walsender] [test_tab1_sub][26/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-12-14 21:09:18.322 GMT [6480][walsender] [test_tab1_sub][26/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-12-14 21:09:18.322 GMT [6480][walsender] [test_tab1_sub][26/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-12-14 21:09:18.323 GMT [6480][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-12-14 21:09:18.323 GMT [6480][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-12-14 21:09:18.323 GMT [6480][walsender] [test_tab1_sub][26/0:0] LOG: acquired logical replication slot "test_tab1_sub" 2024-12-14 21:09:18.323 GMT [6480][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-12-14 21:09:18.323 GMT [6480][walsender] [test_tab1_sub][26/0:0] LOG: starting logical decoding for slot "test_tab1_sub" 2024-12-14 21:09:18.323 GMT [6480][walsender] [test_tab1_sub][26/0:0] DETAIL: Streaming transactions committing after 0/177F418, reading WAL from 0/177F3E0. 2024-12-14 21:09:18.323 GMT [6480][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-12-14 21:09:18.323 GMT [6480][walsender] [test_tab1_sub][26/0:0] LOG: logical decoding found consistent point at 0/177F3E0 2024-12-14 21:09:18.323 GMT [6480][walsender] [test_tab1_sub][26/0:0] DETAIL: There are no running transactions. 2024-12-14 21:09:18.323 GMT [6480][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-12-14 21:09:18.325 GMT [6480][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-12-14 21:09:18.325 GMT [6480][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-12-14 21:09:18.325 GMT [6480][walsender] [test_tab1_sub][26/0:0] LOG: unexpected EOF on standby connection 2024-12-14 21:09:18.325 GMT [6480][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-12-14 21:09:18.325 GMT [6480][walsender] [test_tab1_sub][26/0:0] LOG: released logical replication slot "test_tab1_sub" 2024-12-14 21:09:18.325 GMT [6480][walsender] [test_tab1_sub][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:18.540 GMT [4332][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:18.541 GMT [4332][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-12-14 21:09:18.541 GMT [4332][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-12-14 21:09:18.544 GMT [4332][client backend] [026_stats.pl][6/2:0] LOG: statement: DELETE FROM test_tab1; 2024-12-14 21:09:18.546 GMT [4332][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:18.804 GMT [5404][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:18.805 GMT [5404][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-12-14 21:09:18.805 GMT [5404][walsender] [[unknown]][27/1:0] LOG: replication connection authorized: user=SYSTEM application_name=test_tab1_sub 2024-12-14 21:09:18.808 GMT [5404][walsender] [test_tab1_sub][27/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-12-14 21:09:18.808 GMT [5404][walsender] [test_tab1_sub][27/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-12-14 21:09:18.808 GMT [5404][walsender] [test_tab1_sub][27/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-12-14 21:09:18.808 GMT [5404][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-12-14 21:09:18.808 GMT [5404][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-12-14 21:09:18.809 GMT [5404][walsender] [test_tab1_sub][27/0:0] LOG: acquired logical replication slot "test_tab1_sub" 2024-12-14 21:09:18.809 GMT [5404][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-12-14 21:09:18.809 GMT [5404][walsender] [test_tab1_sub][27/0:0] LOG: starting logical decoding for slot "test_tab1_sub" 2024-12-14 21:09:18.809 GMT [5404][walsender] [test_tab1_sub][27/0:0] DETAIL: Streaming transactions committing after 0/177F418, reading WAL from 0/177F3E0. 2024-12-14 21:09:18.809 GMT [5404][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-12-14 21:09:18.809 GMT [5404][walsender] [test_tab1_sub][27/0:0] LOG: logical decoding found consistent point at 0/177F3E0 2024-12-14 21:09:18.809 GMT [5404][walsender] [test_tab1_sub][27/0:0] DETAIL: There are no running transactions. 2024-12-14 21:09:18.809 GMT [5404][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-12-14 21:09:20.006 GMT [5964][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:20.007 GMT [5964][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-12-14 21:09:20.007 GMT [5964][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-12-14 21:09:20.010 GMT [5964][client backend] [026_stats.pl][7/2:0] LOG: statement: BEGIN; 2024-12-14 21:09:20.010 GMT [5964][client backend] [026_stats.pl][7/2:0] LOG: statement: CREATE TABLE test_tab2(a int); 2024-12-14 21:09:20.014 GMT [5964][client backend] [026_stats.pl][7/2:750] LOG: statement: ALTER TABLE test_tab2 REPLICA IDENTITY FULL; 2024-12-14 21:09:20.015 GMT [5964][client backend] [026_stats.pl][7/2:750] LOG: statement: INSERT INTO test_tab2 VALUES (1); 2024-12-14 21:09:20.015 GMT [5964][client backend] [026_stats.pl][7/2:750] LOG: statement: COMMIT; 2024-12-14 21:09:20.016 GMT [5964][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:20.256 GMT [6524][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:20.257 GMT [6524][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-12-14 21:09:20.257 GMT [6524][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-12-14 21:09:20.259 GMT [6524][client backend] [026_stats.pl][8/2:0] LOG: statement: CREATE PUBLICATION test_tab2_pub FOR TABLE test_tab2 2024-12-14 21:09:20.262 GMT [6524][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:20.348 GMT [7096][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:20.350 GMT [7096][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-12-14 21:09:20.350 GMT [7096][walsender] [[unknown]][28/1:0] LOG: replication connection authorized: user=SYSTEM application_name=test_tab2_sub 2024-12-14 21:09:20.356 GMT [7096][walsender] [test_tab2_sub][28/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-12-14 21:09:20.356 GMT [7096][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-12-14 21:09:20.360 GMT [7096][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-12-14 21:09:20.368 GMT [7096][walsender] [test_tab2_sub][28/0:0] LOG: received replication command: CREATE_REPLICATION_SLOT "test_tab2_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-12-14 21:09:20.368 GMT [7096][walsender] [test_tab2_sub][28/0:0] STATEMENT: CREATE_REPLICATION_SLOT "test_tab2_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-12-14 21:09:20.373 GMT [7096][walsender] [test_tab2_sub][28/0:0] LOG: logical decoding found consistent point at 0/1781240 2024-12-14 21:09:20.373 GMT [7096][walsender] [test_tab2_sub][28/0:0] DETAIL: There are no running transactions. 2024-12-14 21:09:20.373 GMT [7096][walsender] [test_tab2_sub][28/0:0] STATEMENT: CREATE_REPLICATION_SLOT "test_tab2_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-12-14 21:09:20.374 GMT [7096][walsender] [test_tab2_sub][28/0:0] LOG: released logical replication slot "test_tab2_sub" 2024-12-14 21:09:20.374 GMT [7096][walsender] [test_tab2_sub][28/0:0] STATEMENT: CREATE_REPLICATION_SLOT "test_tab2_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-12-14 21:09:20.374 GMT [7096][walsender] [test_tab2_sub][:0] LOG: disconnection: session time: 0:00:00.029 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:20.415 GMT [7420][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:20.416 GMT [7420][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-12-14 21:09:20.416 GMT [7420][walsender] [[unknown]][29/1:0] LOG: replication connection authorized: user=SYSTEM application_name=test_tab2_sub 2024-12-14 21:09:20.420 GMT [7420][walsender] [test_tab2_sub][29/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-12-14 21:09:20.420 GMT [7420][walsender] [test_tab2_sub][29/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-12-14 21:09:20.420 GMT [7420][walsender] [test_tab2_sub][29/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-12-14 21:09:20.421 GMT [7420][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-12-14 21:09:20.421 GMT [7420][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-12-14 21:09:20.421 GMT [7420][walsender] [test_tab2_sub][29/0:0] LOG: acquired logical replication slot "test_tab2_sub" 2024-12-14 21:09:20.421 GMT [7420][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-12-14 21:09:20.421 GMT [7420][walsender] [test_tab2_sub][29/0:0] LOG: starting logical decoding for slot "test_tab2_sub" 2024-12-14 21:09:20.421 GMT [7420][walsender] [test_tab2_sub][29/0:0] DETAIL: Streaming transactions committing after 0/1781278, reading WAL from 0/1781240. 2024-12-14 21:09:20.421 GMT [7420][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-12-14 21:09:20.421 GMT [7420][walsender] [test_tab2_sub][29/0:0] LOG: logical decoding found consistent point at 0/1781240 2024-12-14 21:09:20.421 GMT [7420][walsender] [test_tab2_sub][29/0:0] DETAIL: There are no running transactions. 2024-12-14 21:09:20.421 GMT [7420][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-12-14 21:09:20.462 GMT [7856][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:20.465 GMT [7856][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-12-14 21:09:20.465 GMT [7856][walsender] [[unknown]][30/1:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16401_sync_16395_7448375526863917688 2024-12-14 21:09:20.467 GMT [5272][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:20.468 GMT [5272][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-12-14 21:09:20.468 GMT [5272][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-12-14 21:09:20.470 GMT [5272][client backend] [026_stats.pl][9/2:0] LOG: statement: SELECT pg_is_in_recovery() 2024-12-14 21:09:20.474 GMT [5272][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:20.475 GMT [7856][walsender] [pg_16401_sync_16395_7448375526863917688][30/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-12-14 21:09:20.476 GMT [7856][walsender] [pg_16401_sync_16395_7448375526863917688][30/3:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-12-14 21:09:20.476 GMT [7856][walsender] [pg_16401_sync_16395_7448375526863917688][30/3:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16401_sync_16395_7448375526863917688" LOGICAL pgoutput (SNAPSHOT 'use') 2024-12-14 21:09:20.476 GMT [7856][walsender] [pg_16401_sync_16395_7448375526863917688][30/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16401_sync_16395_7448375526863917688" LOGICAL pgoutput (SNAPSHOT 'use') 2024-12-14 21:09:20.483 GMT [7856][walsender] [pg_16401_sync_16395_7448375526863917688][30/3:0] LOG: logical decoding found consistent point at 0/1781278 2024-12-14 21:09:20.483 GMT [7856][walsender] [pg_16401_sync_16395_7448375526863917688][30/3:0] DETAIL: There are no running transactions. 2024-12-14 21:09:20.483 GMT [7856][walsender] [pg_16401_sync_16395_7448375526863917688][30/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16401_sync_16395_7448375526863917688" LOGICAL pgoutput (SNAPSHOT 'use') 2024-12-14 21:09:20.491 GMT [7856][walsender] [pg_16401_sync_16395_7448375526863917688][30/3:0] LOG: released logical replication slot "pg_16401_sync_16395_7448375526863917688" 2024-12-14 21:09:20.491 GMT [7856][walsender] [pg_16401_sync_16395_7448375526863917688][30/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16401_sync_16395_7448375526863917688" LOGICAL pgoutput (SNAPSHOT 'use') 2024-12-14 21:09:20.492 GMT [7856][walsender] [pg_16401_sync_16395_7448375526863917688][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-12-14 21:09:20.497 GMT [7856][walsender] [pg_16401_sync_16395_7448375526863917688][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-12-14 21:09:20.502 GMT [7856][walsender] [pg_16401_sync_16395_7448375526863917688][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-12-14 21:09:20.503 GMT [7856][walsender] [pg_16401_sync_16395_7448375526863917688][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-12-14 21:09:20.505 GMT [7856][walsender] [pg_16401_sync_16395_7448375526863917688][30/3:0] LOG: statement: COPY public.test_tab2 (a) TO STDOUT 2024-12-14 21:09:20.506 GMT [7856][walsender] [pg_16401_sync_16395_7448375526863917688][:0] LOG: disconnection: session time: 0:00:00.047 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:20.545 GMT [904][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:20.546 GMT [904][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-12-14 21:09:20.546 GMT [904][client backend] [[unknown]][0/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-12-14 21:09:20.550 GMT [904][client backend] [026_stats.pl][0/4:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-12-14 21:09:20.552 GMT [904][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:20.645 GMT [5160][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:20.647 GMT [5160][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-12-14 21:09:20.647 GMT [5160][client backend] [[unknown]][1/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-12-14 21:09:20.650 GMT [5160][client backend] [026_stats.pl][1/4:0] LOG: statement: SELECT '0/17812B0' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('test_tab2_sub', 'walreceiver') 2024-12-14 21:09:20.659 GMT [5160][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.020 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:21.563 GMT [3616][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:21.565 GMT [3616][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-12-14 21:09:21.565 GMT [3616][walsender] [[unknown]][31/1:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16401_sync_16395_7448375526863917688 2024-12-14 21:09:21.567 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-12-14 21:09:21.568 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16401_sync_16395_7448375526863917688 WAIT 2024-12-14 21:09:21.568 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16401_sync_16395_7448375526863917688 WAIT 2024-12-14 21:09:21.568 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/0:0] LOG: acquired logical replication slot "pg_16401_sync_16395_7448375526863917688" 2024-12-14 21:09:21.568 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16401_sync_16395_7448375526863917688 WAIT 2024-12-14 21:09:21.570 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/3:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-12-14 21:09:21.570 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/3:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16401_sync_16395_7448375526863917688" LOGICAL pgoutput (SNAPSHOT 'use') 2024-12-14 21:09:21.570 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16401_sync_16395_7448375526863917688" LOGICAL pgoutput (SNAPSHOT 'use') 2024-12-14 21:09:21.580 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/3:0] LOG: logical decoding found consistent point at 0/17812B0 2024-12-14 21:09:21.580 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/3:0] DETAIL: There are no running transactions. 2024-12-14 21:09:21.580 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16401_sync_16395_7448375526863917688" LOGICAL pgoutput (SNAPSHOT 'use') 2024-12-14 21:09:21.581 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/3:0] LOG: released logical replication slot "pg_16401_sync_16395_7448375526863917688" 2024-12-14 21:09:21.581 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16401_sync_16395_7448375526863917688" LOGICAL pgoutput (SNAPSHOT 'use') 2024-12-14 21:09:21.582 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][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-12-14 21:09:21.586 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][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-12-14 21:09:21.590 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][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-12-14 21:09:21.592 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][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-12-14 21:09:21.594 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/3:0] LOG: statement: COPY public.test_tab2 (a) TO STDOUT 2024-12-14 21:09:21.595 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/3:0] LOG: statement: COMMIT 2024-12-14 21:09:21.596 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/0:0] LOG: received replication command: START_REPLICATION SLOT "pg_16401_sync_16395_7448375526863917688" LOGICAL 0/17812E8 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-12-14 21:09:21.596 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16401_sync_16395_7448375526863917688" LOGICAL 0/17812E8 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-12-14 21:09:21.596 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/0:0] LOG: acquired logical replication slot "pg_16401_sync_16395_7448375526863917688" 2024-12-14 21:09:21.596 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16401_sync_16395_7448375526863917688" LOGICAL 0/17812E8 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-12-14 21:09:21.596 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/0:0] LOG: starting logical decoding for slot "pg_16401_sync_16395_7448375526863917688" 2024-12-14 21:09:21.596 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/0:0] DETAIL: Streaming transactions committing after 0/17812E8, reading WAL from 0/17812B0. 2024-12-14 21:09:21.596 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16401_sync_16395_7448375526863917688" LOGICAL 0/17812E8 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-12-14 21:09:21.596 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/0:0] LOG: logical decoding found consistent point at 0/17812B0 2024-12-14 21:09:21.596 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/0:0] DETAIL: There are no running transactions. 2024-12-14 21:09:21.596 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16401_sync_16395_7448375526863917688" LOGICAL 0/17812E8 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-12-14 21:09:21.596 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/0:0] LOG: released logical replication slot "pg_16401_sync_16395_7448375526863917688" 2024-12-14 21:09:21.596 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16401_sync_16395_7448375526863917688" LOGICAL 0/17812E8 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"test_tab2_pub"') 2024-12-14 21:09:21.597 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16401_sync_16395_7448375526863917688 WAIT 2024-12-14 21:09:21.597 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16401_sync_16395_7448375526863917688 WAIT 2024-12-14 21:09:21.597 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/0:0] LOG: acquired logical replication slot "pg_16401_sync_16395_7448375526863917688" 2024-12-14 21:09:21.597 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][31/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16401_sync_16395_7448375526863917688 WAIT 2024-12-14 21:09:21.598 GMT [3616][walsender] [pg_16401_sync_16395_7448375526863917688][:0] LOG: disconnection: session time: 0:00:00.037 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:22.074 GMT [7392][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:22.075 GMT [7392][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-12-14 21:09:22.075 GMT [7392][client backend] [[unknown]][2/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-12-14 21:09:22.084 GMT [7392][client backend] [026_stats.pl][2/4:0] LOG: statement: INSERT INTO test_tab2 VALUES (1) 2024-12-14 21:09:22.105 GMT [7420][walsender] [test_tab2_sub][29/0:0] LOG: released logical replication slot "test_tab2_sub" 2024-12-14 21:09:22.105 GMT [7420][walsender] [test_tab2_sub][:0] LOG: disconnection: session time: 0:00:01.694 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:22.109 GMT [7392][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.038 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:22.220 GMT [4456][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:22.224 GMT [4456][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-12-14 21:09:22.224 GMT [4456][walsender] [[unknown]][22/5:0] LOG: replication connection authorized: user=SYSTEM application_name=test_tab2_sub 2024-12-14 21:09:22.231 GMT [4456][walsender] [test_tab2_sub][22/6:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-12-14 21:09:22.232 GMT [4456][walsender] [test_tab2_sub][22/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-12-14 21:09:22.232 GMT [4456][walsender] [test_tab2_sub][22/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-12-14 21:09:22.232 GMT [4456][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-12-14 21:09:22.232 GMT [4456][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-12-14 21:09:22.232 GMT [4456][walsender] [test_tab2_sub][22/0:0] LOG: acquired logical replication slot "test_tab2_sub" 2024-12-14 21:09:22.232 GMT [4456][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-12-14 21:09:22.234 GMT [4456][walsender] [test_tab2_sub][22/0:0] LOG: starting logical decoding for slot "test_tab2_sub" 2024-12-14 21:09:22.234 GMT [4456][walsender] [test_tab2_sub][22/0:0] DETAIL: Streaming transactions committing after 0/17812E8, reading WAL from 0/17812B0. 2024-12-14 21:09:22.234 GMT [4456][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-12-14 21:09:22.234 GMT [4456][walsender] [test_tab2_sub][22/0:0] LOG: logical decoding found consistent point at 0/17812B0 2024-12-14 21:09:22.234 GMT [4456][walsender] [test_tab2_sub][22/0:0] DETAIL: There are no running transactions. 2024-12-14 21:09:22.234 GMT [4456][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-12-14 21:09:22.235 GMT [4456][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-12-14 21:09:22.235 GMT [4456][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-12-14 21:09:22.235 GMT [4456][walsender] [test_tab2_sub][22/0:0] LOG: unexpected EOF on standby connection 2024-12-14 21:09:22.235 GMT [4456][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-12-14 21:09:22.235 GMT [4456][walsender] [test_tab2_sub][22/0:0] LOG: released logical replication slot "test_tab2_sub" 2024-12-14 21:09:22.236 GMT [4456][walsender] [test_tab2_sub][:0] LOG: disconnection: session time: 0:00:00.018 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:22.466 GMT [1700][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:22.472 GMT [1700][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-12-14 21:09:22.472 GMT [1700][client backend] [[unknown]][3/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-12-14 21:09:22.478 GMT [1700][client backend] [026_stats.pl][3/4:0] LOG: statement: DELETE FROM test_tab2; 2024-12-14 21:09:22.480 GMT [1700][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:22.663 GMT [4916][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:22.665 GMT [4916][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-12-14 21:09:22.665 GMT [4916][walsender] [[unknown]][24/4:0] LOG: replication connection authorized: user=SYSTEM application_name=test_tab2_sub 2024-12-14 21:09:22.667 GMT [4916][walsender] [test_tab2_sub][24/5:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-12-14 21:09:22.668 GMT [4916][walsender] [test_tab2_sub][24/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-12-14 21:09:22.668 GMT [4916][walsender] [test_tab2_sub][24/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-12-14 21:09:22.668 GMT [4916][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-12-14 21:09:22.668 GMT [4916][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-12-14 21:09:22.668 GMT [4916][walsender] [test_tab2_sub][24/0:0] LOG: acquired logical replication slot "test_tab2_sub" 2024-12-14 21:09:22.668 GMT [4916][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-12-14 21:09:22.669 GMT [4916][walsender] [test_tab2_sub][24/0:0] LOG: starting logical decoding for slot "test_tab2_sub" 2024-12-14 21:09:22.669 GMT [4916][walsender] [test_tab2_sub][24/0:0] DETAIL: Streaming transactions committing after 0/17812E8, reading WAL from 0/17812B0. 2024-12-14 21:09:22.669 GMT [4916][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-12-14 21:09:22.669 GMT [4916][walsender] [test_tab2_sub][24/0:0] LOG: logical decoding found consistent point at 0/17812B0 2024-12-14 21:09:22.669 GMT [4916][walsender] [test_tab2_sub][24/0:0] DETAIL: There are no running transactions. 2024-12-14 21:09:22.669 GMT [4916][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-12-14 21:09:24.093 GMT [5404][walsender] [test_tab1_sub][27/0:0] LOG: released logical replication slot "test_tab1_sub" 2024-12-14 21:09:24.093 GMT [5404][walsender] [test_tab1_sub][:0] LOG: disconnection: session time: 0:00:05.292 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:24.129 GMT [7348][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:24.130 GMT [7348][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-12-14 21:09:24.130 GMT [7348][walsender] [[unknown]][25/4:0] LOG: replication connection authorized: user=SYSTEM application_name=test_tab1_sub 2024-12-14 21:09:24.133 GMT [7348][walsender] [test_tab1_sub][25/5:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-12-14 21:09:24.134 GMT [7348][walsender] [test_tab1_sub][25/0:0] LOG: received replication command: DROP_REPLICATION_SLOT test_tab1_sub WAIT 2024-12-14 21:09:24.134 GMT [7348][walsender] [test_tab1_sub][25/0:0] STATEMENT: DROP_REPLICATION_SLOT test_tab1_sub WAIT 2024-12-14 21:09:24.134 GMT [7348][walsender] [test_tab1_sub][25/0:0] LOG: acquired logical replication slot "test_tab1_sub" 2024-12-14 21:09:24.134 GMT [7348][walsender] [test_tab1_sub][25/0:0] STATEMENT: DROP_REPLICATION_SLOT test_tab1_sub WAIT 2024-12-14 21:09:24.135 GMT [7348][walsender] [test_tab1_sub][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:24.445 GMT [4916][walsender] [test_tab2_sub][24/0:0] LOG: released logical replication slot "test_tab2_sub" 2024-12-14 21:09:24.445 GMT [4916][walsender] [test_tab2_sub][:0] LOG: disconnection: session time: 0:00:01.785 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:24.677 GMT [8156][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:24.678 GMT [8156][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-12-14 21:09:24.678 GMT [8156][client backend] [[unknown]][4/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-12-14 21:09:24.687 GMT [8156][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-12-14 21:09:24.694 GMT [8156][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.020 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:24.770 GMT [6040][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:09:24.772 GMT [6040][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-12-14 21:09:24.772 GMT [6040][client backend] [[unknown]][5/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=026_stats.pl 2024-12-14 21:09:24.775 GMT [6040][client backend] [026_stats.pl][5/4:0] LOG: statement: SELECT pg_drop_replication_slot('test_tab2_sub') 2024-12-14 21:09:24.783 GMT [6040][client backend] [026_stats.pl][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2024-12-14 21:09:26.045 GMT [3136][postmaster] LOG: received immediate shutdown request TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2901, PID: 3136 abort() has been called