2024-05-04 13:41:16.519 GMT [7092][postmaster] LOG: starting PostgreSQL 17devel on x86_64-windows, compiled by msvc-19.29.30151, 64-bit 2024-05-04 13:41:16.520 GMT [7092][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/_buSd4jyb_/.s.PGSQL.58467" 2024-05-04 13:41:16.558 GMT [6148][startup] LOG: database system was shut down at 2024-05-04 13:32:34 GMT 2024-05-04 13:41:16.604 GMT [7092][postmaster] LOG: database system is ready to accept connections 2024-05-04 13:41:19.679 GMT [7796][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:19.682 GMT [7796][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:19.682 GMT [7796][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:19.711 GMT [7796][client backend] [010_truncate.pl][0/2:0] LOG: statement: CREATE TABLE tab1 (a int PRIMARY KEY) 2024-05-04 13:41:19.719 GMT [7796][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.043 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:20.168 GMT [2628][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:20.170 GMT [2628][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:20.170 GMT [2628][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:20.173 GMT [2628][client backend] [010_truncate.pl][1/2:0] LOG: statement: CREATE TABLE tab2 (a int PRIMARY KEY) 2024-05-04 13:41:20.182 GMT [2628][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:20.626 GMT [7952][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:20.628 GMT [7952][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:20.628 GMT [7952][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:20.631 GMT [7952][client backend] [010_truncate.pl][2/2:0] LOG: statement: CREATE TABLE tab3 (a int PRIMARY KEY) 2024-05-04 13:41:20.639 GMT [7952][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.040 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:20.977 GMT [3688][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:20.978 GMT [3688][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:20.978 GMT [3688][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:20.981 GMT [3688][client backend] [010_truncate.pl][3/2:0] LOG: statement: CREATE TABLE tab4 (x int PRIMARY KEY, y int REFERENCES tab3) 2024-05-04 13:41:20.995 GMT [3688][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:21.721 GMT [6928][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:21.722 GMT [6928][client backend] [[unknown]][4/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:21.722 GMT [6928][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:21.726 GMT [6928][client backend] [010_truncate.pl][4/2:0] LOG: statement: CREATE PUBLICATION pub1 FOR TABLE tab1 2024-05-04 13:41:21.737 GMT [6928][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.020 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:21.857 GMT [7480][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:21.859 GMT [7480][client backend] [[unknown]][5/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:21.859 GMT [7480][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:21.861 GMT [7480][client backend] [010_truncate.pl][5/2:0] LOG: statement: CREATE PUBLICATION pub2 FOR TABLE tab2 WITH (publish = insert) 2024-05-04 13:41:21.863 GMT [7480][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:21.999 GMT [6624][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:22.000 GMT [6624][client backend] [[unknown]][6/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:22.000 GMT [6624][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:22.003 GMT [6624][client backend] [010_truncate.pl][6/2:0] LOG: statement: CREATE PUBLICATION pub3 FOR TABLE tab3, tab4 2024-05-04 13:41:22.005 GMT [6624][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:22.383 GMT [6916][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:22.385 GMT [6916][walsender] [[unknown]][22/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:22.385 GMT [6916][walsender] [[unknown]][22/1:0] LOG: replication connection authorized: user=SYSTEM application_name=sub1 2024-05-04 13:41:22.387 GMT [6916][walsender] [sub1][22/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:22.388 GMT [6916][walsender] [sub1][22/3:0] LOG: statement: SELECT t.pubname FROM pg_catalog.pg_publication t WHERE t.pubname IN ('pub1') 2024-05-04 13:41:22.392 GMT [6916][walsender] [sub1][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 ( 'pub1' )) AS gpt ON gpt.relid = c.oid 2024-05-04 13:41:22.400 GMT [6916][walsender] [sub1][22/0:0] LOG: received replication command: CREATE_REPLICATION_SLOT "sub1" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-05-04 13:41:22.400 GMT [6916][walsender] [sub1][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub1" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-05-04 13:41:22.428 GMT [6916][walsender] [sub1][22/0:0] LOG: logical decoding found consistent point at 0/15323A0 2024-05-04 13:41:22.428 GMT [6916][walsender] [sub1][22/0:0] DETAIL: There are no running transactions. 2024-05-04 13:41:22.428 GMT [6916][walsender] [sub1][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub1" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-05-04 13:41:22.430 GMT [6916][walsender] [sub1][22/0:0] LOG: released logical replication slot "sub1" 2024-05-04 13:41:22.430 GMT [6916][walsender] [sub1][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub1" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-05-04 13:41:22.431 GMT [6916][walsender] [sub1][:0] LOG: disconnection: session time: 0:00:00.050 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:22.541 GMT [3704][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:22.542 GMT [3704][walsender] [[unknown]][23/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:22.542 GMT [3704][walsender] [[unknown]][23/1:0] LOG: replication connection authorized: user=SYSTEM application_name=sub1 2024-05-04 13:41:22.561 GMT [3704][walsender] [sub1][23/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:22.563 GMT [3704][walsender] [sub1][23/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-05-04 13:41:22.563 GMT [3704][walsender] [sub1][23/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-05-04 13:41:22.564 GMT [3704][walsender] [sub1][23/0:0] LOG: received replication command: START_REPLICATION SLOT "sub1" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub1"') 2024-05-04 13:41:22.564 GMT [3704][walsender] [sub1][23/0:0] STATEMENT: START_REPLICATION SLOT "sub1" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub1"') 2024-05-04 13:41:22.564 GMT [3704][walsender] [sub1][23/0:0] LOG: acquired logical replication slot "sub1" 2024-05-04 13:41:22.564 GMT [3704][walsender] [sub1][23/0:0] STATEMENT: START_REPLICATION SLOT "sub1" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub1"') 2024-05-04 13:41:22.566 GMT [3704][walsender] [sub1][23/0:0] LOG: starting logical decoding for slot "sub1" 2024-05-04 13:41:22.566 GMT [3704][walsender] [sub1][23/0:0] DETAIL: Streaming transactions committing after 0/15323D8, reading WAL from 0/15323A0. 2024-05-04 13:41:22.566 GMT [3704][walsender] [sub1][23/0:0] STATEMENT: START_REPLICATION SLOT "sub1" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub1"') 2024-05-04 13:41:22.566 GMT [3704][walsender] [sub1][23/0:0] LOG: logical decoding found consistent point at 0/15323A0 2024-05-04 13:41:22.566 GMT [3704][walsender] [sub1][23/0:0] DETAIL: There are no running transactions. 2024-05-04 13:41:22.566 GMT [3704][walsender] [sub1][23/0:0] STATEMENT: START_REPLICATION SLOT "sub1" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub1"') 2024-05-04 13:41:22.824 GMT [5768][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:22.825 GMT [5768][walsender] [[unknown]][24/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:22.825 GMT [5768][walsender] [[unknown]][24/1:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16411_sync_16384_7365136844452825596 2024-05-04 13:41:22.828 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:22.829 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/3:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-05-04 13:41:22.829 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/3:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16411_sync_16384_7365136844452825596" LOGICAL pgoutput (SNAPSHOT 'use') 2024-05-04 13:41:22.829 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16411_sync_16384_7365136844452825596" LOGICAL pgoutput (SNAPSHOT 'use') 2024-05-04 13:41:22.844 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/3:0] LOG: logical decoding found consistent point at 0/15323D8 2024-05-04 13:41:22.844 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/3:0] DETAIL: There are no running transactions. 2024-05-04 13:41:22.844 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16411_sync_16384_7365136844452825596" LOGICAL pgoutput (SNAPSHOT 'use') 2024-05-04 13:41:22.847 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/3:0] LOG: released logical replication slot "pg_16411_sync_16384_7365136844452825596" 2024-05-04 13:41:22.847 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16411_sync_16384_7365136844452825596" LOGICAL pgoutput (SNAPSHOT 'use') 2024-05-04 13:41:22.848 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][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 = 'tab1' 2024-05-04 13:41:22.853 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][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 ( 'pub1' ) 2024-05-04 13:41:22.858 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/3:0] LOG: statement: SELECT a.attnum, a.attname, a.atttypid, a.attnum = ANY(i.indkey) 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.attgenerated = '' AND a.attrelid = 16384 ORDER BY a.attnum 2024-05-04 13:41:22.861 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][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 ( 'pub1' ) 2024-05-04 13:41:22.862 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/3:0] LOG: statement: COPY public.tab1 (a) TO STDOUT 2024-05-04 13:41:22.863 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/3:0] LOG: statement: COMMIT 2024-05-04 13:41:22.863 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/0:0] LOG: received replication command: START_REPLICATION SLOT "pg_16411_sync_16384_7365136844452825596" LOGICAL 0/1532410 (proto_version '4', origin 'any', publication_names '"pub1"') 2024-05-04 13:41:22.863 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/0:0] STATEMENT: START_REPLICATION SLOT "pg_16411_sync_16384_7365136844452825596" LOGICAL 0/1532410 (proto_version '4', origin 'any', publication_names '"pub1"') 2024-05-04 13:41:22.863 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/0:0] LOG: acquired logical replication slot "pg_16411_sync_16384_7365136844452825596" 2024-05-04 13:41:22.863 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/0:0] STATEMENT: START_REPLICATION SLOT "pg_16411_sync_16384_7365136844452825596" LOGICAL 0/1532410 (proto_version '4', origin 'any', publication_names '"pub1"') 2024-05-04 13:41:22.864 GMT [1652][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:22.865 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/0:0] LOG: starting logical decoding for slot "pg_16411_sync_16384_7365136844452825596" 2024-05-04 13:41:22.865 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/0:0] DETAIL: Streaming transactions committing after 0/1532410, reading WAL from 0/15323D8. 2024-05-04 13:41:22.865 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/0:0] STATEMENT: START_REPLICATION SLOT "pg_16411_sync_16384_7365136844452825596" LOGICAL 0/1532410 (proto_version '4', origin 'any', publication_names '"pub1"') 2024-05-04 13:41:22.865 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/0:0] LOG: logical decoding found consistent point at 0/15323D8 2024-05-04 13:41:22.865 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/0:0] DETAIL: There are no running transactions. 2024-05-04 13:41:22.865 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/0:0] STATEMENT: START_REPLICATION SLOT "pg_16411_sync_16384_7365136844452825596" LOGICAL 0/1532410 (proto_version '4', origin 'any', publication_names '"pub1"') 2024-05-04 13:41:22.866 GMT [1652][walsender] [[unknown]][25/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:22.866 GMT [1652][walsender] [[unknown]][25/1:0] LOG: replication connection authorized: user=SYSTEM application_name=sub2 2024-05-04 13:41:22.866 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/0:0] LOG: released logical replication slot "pg_16411_sync_16384_7365136844452825596" 2024-05-04 13:41:22.866 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/0:0] STATEMENT: START_REPLICATION SLOT "pg_16411_sync_16384_7365136844452825596" LOGICAL 0/1532410 (proto_version '4', origin 'any', publication_names '"pub1"') 2024-05-04 13:41:22.866 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16411_sync_16384_7365136844452825596 WAIT 2024-05-04 13:41:22.866 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16411_sync_16384_7365136844452825596 WAIT 2024-05-04 13:41:22.866 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/0:0] LOG: acquired logical replication slot "pg_16411_sync_16384_7365136844452825596" 2024-05-04 13:41:22.866 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][24/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16411_sync_16384_7365136844452825596 WAIT 2024-05-04 13:41:22.868 GMT [5768][walsender] [pg_16411_sync_16384_7365136844452825596][:0] LOG: disconnection: session time: 0:00:00.048 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:22.919 GMT [1652][walsender] [sub2][25/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:22.919 GMT [1652][walsender] [sub2][25/3:0] LOG: statement: SELECT t.pubname FROM pg_catalog.pg_publication t WHERE t.pubname IN ('pub2') 2024-05-04 13:41:22.922 GMT [1652][walsender] [sub2][25/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 ( 'pub2' )) AS gpt ON gpt.relid = c.oid 2024-05-04 13:41:22.932 GMT [1652][walsender] [sub2][25/0:0] LOG: received replication command: CREATE_REPLICATION_SLOT "sub2" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-05-04 13:41:22.932 GMT [1652][walsender] [sub2][25/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub2" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-05-04 13:41:22.945 GMT [1652][walsender] [sub2][25/0:0] LOG: logical decoding found consistent point at 0/1532410 2024-05-04 13:41:22.945 GMT [1652][walsender] [sub2][25/0:0] DETAIL: There are no running transactions. 2024-05-04 13:41:22.945 GMT [1652][walsender] [sub2][25/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub2" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-05-04 13:41:22.946 GMT [1652][walsender] [sub2][25/0:0] LOG: released logical replication slot "sub2" 2024-05-04 13:41:22.946 GMT [1652][walsender] [sub2][25/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub2" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-05-04 13:41:22.947 GMT [1652][walsender] [sub2][:0] LOG: disconnection: session time: 0:00:00.086 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:23.091 GMT [8128][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:23.093 GMT [8128][walsender] [[unknown]][26/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:23.093 GMT [8128][walsender] [[unknown]][26/1:0] LOG: replication connection authorized: user=SYSTEM application_name=sub2 2024-05-04 13:41:23.116 GMT [8128][walsender] [sub2][26/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:23.117 GMT [8128][walsender] [sub2][26/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-05-04 13:41:23.117 GMT [8128][walsender] [sub2][26/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-05-04 13:41:23.117 GMT [8128][walsender] [sub2][26/0:0] LOG: received replication command: START_REPLICATION SLOT "sub2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub2"') 2024-05-04 13:41:23.117 GMT [8128][walsender] [sub2][26/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub2"') 2024-05-04 13:41:23.118 GMT [8128][walsender] [sub2][26/0:0] LOG: acquired logical replication slot "sub2" 2024-05-04 13:41:23.118 GMT [8128][walsender] [sub2][26/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub2"') 2024-05-04 13:41:23.120 GMT [8128][walsender] [sub2][26/0:0] LOG: starting logical decoding for slot "sub2" 2024-05-04 13:41:23.120 GMT [8128][walsender] [sub2][26/0:0] DETAIL: Streaming transactions committing after 0/1532448, reading WAL from 0/1532410. 2024-05-04 13:41:23.120 GMT [8128][walsender] [sub2][26/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub2"') 2024-05-04 13:41:23.120 GMT [8128][walsender] [sub2][26/0:0] LOG: logical decoding found consistent point at 0/1532410 2024-05-04 13:41:23.120 GMT [8128][walsender] [sub2][26/0:0] DETAIL: There are no running transactions. 2024-05-04 13:41:23.120 GMT [8128][walsender] [sub2][26/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub2"') 2024-05-04 13:41:23.208 GMT [7852][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:23.210 GMT [7852][walsender] [[unknown]][27/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:23.210 GMT [7852][walsender] [[unknown]][27/1:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16412_sync_16389_7365136844452825596 2024-05-04 13:41:23.213 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:23.214 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/3:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-05-04 13:41:23.214 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/3:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16412_sync_16389_7365136844452825596" LOGICAL pgoutput (SNAPSHOT 'use') 2024-05-04 13:41:23.214 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16412_sync_16389_7365136844452825596" LOGICAL pgoutput (SNAPSHOT 'use') 2024-05-04 13:41:23.223 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/3:0] LOG: logical decoding found consistent point at 0/1532448 2024-05-04 13:41:23.223 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/3:0] DETAIL: There are no running transactions. 2024-05-04 13:41:23.223 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16412_sync_16389_7365136844452825596" LOGICAL pgoutput (SNAPSHOT 'use') 2024-05-04 13:41:23.225 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/3:0] LOG: released logical replication slot "pg_16412_sync_16389_7365136844452825596" 2024-05-04 13:41:23.225 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16412_sync_16389_7365136844452825596" LOGICAL pgoutput (SNAPSHOT 'use') 2024-05-04 13:41:23.233 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/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 = 'tab2' 2024-05-04 13:41:23.237 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/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 ( 'pub2' ) 2024-05-04 13:41:23.243 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/3:0] LOG: statement: SELECT a.attnum, a.attname, a.atttypid, a.attnum = ANY(i.indkey) 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.attgenerated = '' AND a.attrelid = 16389 ORDER BY a.attnum 2024-05-04 13:41:23.245 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/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 ( 'pub2' ) 2024-05-04 13:41:23.248 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/3:0] LOG: statement: COPY public.tab2 (a) TO STDOUT 2024-05-04 13:41:23.248 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/3:0] LOG: statement: COMMIT 2024-05-04 13:41:23.249 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/0:0] LOG: received replication command: START_REPLICATION SLOT "pg_16412_sync_16389_7365136844452825596" LOGICAL 0/1532480 (proto_version '4', origin 'any', publication_names '"pub2"') 2024-05-04 13:41:23.249 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/0:0] STATEMENT: START_REPLICATION SLOT "pg_16412_sync_16389_7365136844452825596" LOGICAL 0/1532480 (proto_version '4', origin 'any', publication_names '"pub2"') 2024-05-04 13:41:23.249 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/0:0] LOG: acquired logical replication slot "pg_16412_sync_16389_7365136844452825596" 2024-05-04 13:41:23.249 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/0:0] STATEMENT: START_REPLICATION SLOT "pg_16412_sync_16389_7365136844452825596" LOGICAL 0/1532480 (proto_version '4', origin 'any', publication_names '"pub2"') 2024-05-04 13:41:23.251 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/0:0] LOG: starting logical decoding for slot "pg_16412_sync_16389_7365136844452825596" 2024-05-04 13:41:23.251 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/0:0] DETAIL: Streaming transactions committing after 0/1532480, reading WAL from 0/1532448. 2024-05-04 13:41:23.251 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/0:0] STATEMENT: START_REPLICATION SLOT "pg_16412_sync_16389_7365136844452825596" LOGICAL 0/1532480 (proto_version '4', origin 'any', publication_names '"pub2"') 2024-05-04 13:41:23.251 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/0:0] LOG: logical decoding found consistent point at 0/1532448 2024-05-04 13:41:23.251 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/0:0] DETAIL: There are no running transactions. 2024-05-04 13:41:23.251 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/0:0] STATEMENT: START_REPLICATION SLOT "pg_16412_sync_16389_7365136844452825596" LOGICAL 0/1532480 (proto_version '4', origin 'any', publication_names '"pub2"') 2024-05-04 13:41:23.252 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/0:0] LOG: released logical replication slot "pg_16412_sync_16389_7365136844452825596" 2024-05-04 13:41:23.252 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/0:0] STATEMENT: START_REPLICATION SLOT "pg_16412_sync_16389_7365136844452825596" LOGICAL 0/1532480 (proto_version '4', origin 'any', publication_names '"pub2"') 2024-05-04 13:41:23.252 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16412_sync_16389_7365136844452825596 WAIT 2024-05-04 13:41:23.252 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16412_sync_16389_7365136844452825596 WAIT 2024-05-04 13:41:23.252 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/0:0] LOG: acquired logical replication slot "pg_16412_sync_16389_7365136844452825596" 2024-05-04 13:41:23.252 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][27/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16412_sync_16389_7365136844452825596 WAIT 2024-05-04 13:41:23.261 GMT [7852][walsender] [pg_16412_sync_16389_7365136844452825596][:0] LOG: disconnection: session time: 0:00:00.056 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:23.279 GMT [4872][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:23.280 GMT [4872][walsender] [[unknown]][28/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:23.280 GMT [4872][walsender] [[unknown]][28/1:0] LOG: replication connection authorized: user=SYSTEM application_name=sub3 2024-05-04 13:41:23.284 GMT [4872][walsender] [sub3][28/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:23.285 GMT [4872][walsender] [sub3][28/3:0] LOG: statement: SELECT t.pubname FROM pg_catalog.pg_publication t WHERE t.pubname IN ('pub3') 2024-05-04 13:41:23.288 GMT [4872][walsender] [sub3][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 ( 'pub3' )) AS gpt ON gpt.relid = c.oid 2024-05-04 13:41:23.299 GMT [4872][walsender] [sub3][28/0:0] LOG: received replication command: CREATE_REPLICATION_SLOT "sub3" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-05-04 13:41:23.299 GMT [4872][walsender] [sub3][28/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub3" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-05-04 13:41:23.305 GMT [4872][walsender] [sub3][28/0:0] LOG: logical decoding found consistent point at 0/1532480 2024-05-04 13:41:23.305 GMT [4872][walsender] [sub3][28/0:0] DETAIL: There are no running transactions. 2024-05-04 13:41:23.305 GMT [4872][walsender] [sub3][28/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub3" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-05-04 13:41:23.307 GMT [4872][walsender] [sub3][28/0:0] LOG: released logical replication slot "sub3" 2024-05-04 13:41:23.307 GMT [4872][walsender] [sub3][28/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub3" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-05-04 13:41:23.307 GMT [4872][walsender] [sub3][:0] LOG: disconnection: session time: 0:00:00.031 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:23.394 GMT [6292][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:23.395 GMT [6292][walsender] [[unknown]][29/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:23.395 GMT [6292][walsender] [[unknown]][29/1:0] LOG: replication connection authorized: user=SYSTEM application_name=sub3 2024-05-04 13:41:23.414 GMT [6292][walsender] [sub3][29/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:23.416 GMT [6292][walsender] [sub3][29/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-05-04 13:41:23.416 GMT [6292][walsender] [sub3][29/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-05-04 13:41:23.416 GMT [6292][walsender] [sub3][29/0:0] LOG: received replication command: START_REPLICATION SLOT "sub3" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub3"') 2024-05-04 13:41:23.416 GMT [6292][walsender] [sub3][29/0:0] STATEMENT: START_REPLICATION SLOT "sub3" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub3"') 2024-05-04 13:41:23.416 GMT [6292][walsender] [sub3][29/0:0] LOG: acquired logical replication slot "sub3" 2024-05-04 13:41:23.416 GMT [6292][walsender] [sub3][29/0:0] STATEMENT: START_REPLICATION SLOT "sub3" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub3"') 2024-05-04 13:41:23.434 GMT [6292][walsender] [sub3][29/0:0] LOG: starting logical decoding for slot "sub3" 2024-05-04 13:41:23.434 GMT [6292][walsender] [sub3][29/0:0] DETAIL: Streaming transactions committing after 0/15324B8, reading WAL from 0/1532480. 2024-05-04 13:41:23.434 GMT [6292][walsender] [sub3][29/0:0] STATEMENT: START_REPLICATION SLOT "sub3" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub3"') 2024-05-04 13:41:23.434 GMT [6292][walsender] [sub3][29/0:0] LOG: logical decoding found consistent point at 0/1532480 2024-05-04 13:41:23.434 GMT [6292][walsender] [sub3][29/0:0] DETAIL: There are no running transactions. 2024-05-04 13:41:23.434 GMT [6292][walsender] [sub3][29/0:0] STATEMENT: START_REPLICATION SLOT "sub3" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub3"') 2024-05-04 13:41:23.517 GMT [4720][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:23.518 GMT [4720][walsender] [[unknown]][30/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:23.518 GMT [4720][walsender] [[unknown]][30/1:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16413_sync_16399_7365136844452825596 2024-05-04 13:41:23.521 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:23.522 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/3:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-05-04 13:41:23.523 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/3:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16413_sync_16399_7365136844452825596" LOGICAL pgoutput (SNAPSHOT 'use') 2024-05-04 13:41:23.523 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16413_sync_16399_7365136844452825596" LOGICAL pgoutput (SNAPSHOT 'use') 2024-05-04 13:41:23.588 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/3:0] LOG: logical decoding found consistent point at 0/15324B8 2024-05-04 13:41:23.588 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/3:0] DETAIL: There are no running transactions. 2024-05-04 13:41:23.588 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16413_sync_16399_7365136844452825596" LOGICAL pgoutput (SNAPSHOT 'use') 2024-05-04 13:41:23.591 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/3:0] LOG: released logical replication slot "pg_16413_sync_16399_7365136844452825596" 2024-05-04 13:41:23.591 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16413_sync_16399_7365136844452825596" LOGICAL pgoutput (SNAPSHOT 'use') 2024-05-04 13:41:23.592 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][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 = 'tab4' 2024-05-04 13:41:23.597 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][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 = 16399 AND c.oid = gpt.relid AND p.pubname IN ( 'pub3' ) 2024-05-04 13:41:23.604 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/3:0] LOG: statement: SELECT a.attnum, a.attname, a.atttypid, a.attnum = ANY(i.indkey) FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_index i ON (i.indexrelid = pg_get_replica_identity_index(16399)) WHERE a.attnum > 0::pg_catalog.int2 AND NOT a.attisdropped AND a.attgenerated = '' AND a.attrelid = 16399 ORDER BY a.attnum 2024-05-04 13:41:23.606 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][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 = 16399 AND p.pubname IN ( 'pub3' ) 2024-05-04 13:41:23.608 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/3:0] LOG: statement: COPY public.tab4 (x, y) TO STDOUT 2024-05-04 13:41:23.609 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/3:0] LOG: statement: COMMIT 2024-05-04 13:41:23.609 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/0:0] LOG: received replication command: START_REPLICATION SLOT "pg_16413_sync_16399_7365136844452825596" LOGICAL 0/15324F0 (proto_version '4', origin 'any', publication_names '"pub3"') 2024-05-04 13:41:23.609 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/0:0] STATEMENT: START_REPLICATION SLOT "pg_16413_sync_16399_7365136844452825596" LOGICAL 0/15324F0 (proto_version '4', origin 'any', publication_names '"pub3"') 2024-05-04 13:41:23.609 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/0:0] LOG: acquired logical replication slot "pg_16413_sync_16399_7365136844452825596" 2024-05-04 13:41:23.609 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/0:0] STATEMENT: START_REPLICATION SLOT "pg_16413_sync_16399_7365136844452825596" LOGICAL 0/15324F0 (proto_version '4', origin 'any', publication_names '"pub3"') 2024-05-04 13:41:23.611 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/0:0] LOG: starting logical decoding for slot "pg_16413_sync_16399_7365136844452825596" 2024-05-04 13:41:23.611 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/0:0] DETAIL: Streaming transactions committing after 0/15324F0, reading WAL from 0/15324B8. 2024-05-04 13:41:23.611 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/0:0] STATEMENT: START_REPLICATION SLOT "pg_16413_sync_16399_7365136844452825596" LOGICAL 0/15324F0 (proto_version '4', origin 'any', publication_names '"pub3"') 2024-05-04 13:41:23.611 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/0:0] LOG: logical decoding found consistent point at 0/15324B8 2024-05-04 13:41:23.611 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/0:0] DETAIL: There are no running transactions. 2024-05-04 13:41:23.611 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/0:0] STATEMENT: START_REPLICATION SLOT "pg_16413_sync_16399_7365136844452825596" LOGICAL 0/15324F0 (proto_version '4', origin 'any', publication_names '"pub3"') 2024-05-04 13:41:23.612 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/0:0] LOG: released logical replication slot "pg_16413_sync_16399_7365136844452825596" 2024-05-04 13:41:23.612 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/0:0] STATEMENT: START_REPLICATION SLOT "pg_16413_sync_16399_7365136844452825596" LOGICAL 0/15324F0 (proto_version '4', origin 'any', publication_names '"pub3"') 2024-05-04 13:41:23.612 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16413_sync_16399_7365136844452825596 WAIT 2024-05-04 13:41:23.612 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16413_sync_16399_7365136844452825596 WAIT 2024-05-04 13:41:23.612 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/0:0] LOG: acquired logical replication slot "pg_16413_sync_16399_7365136844452825596" 2024-05-04 13:41:23.612 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][30/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16413_sync_16399_7365136844452825596 WAIT 2024-05-04 13:41:23.614 GMT [4720][walsender] [pg_16413_sync_16399_7365136844452825596][:0] LOG: disconnection: session time: 0:00:00.100 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:23.655 GMT [6924][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:23.671 GMT [6924][walsender] [[unknown]][31/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:23.671 GMT [6924][walsender] [[unknown]][31/1:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16413_sync_16394_7365136844452825596 2024-05-04 13:41:23.676 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:23.677 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/3:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-05-04 13:41:23.677 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/3:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16413_sync_16394_7365136844452825596" LOGICAL pgoutput (SNAPSHOT 'use') 2024-05-04 13:41:23.677 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16413_sync_16394_7365136844452825596" LOGICAL pgoutput (SNAPSHOT 'use') 2024-05-04 13:41:23.683 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/3:0] LOG: logical decoding found consistent point at 0/15324F0 2024-05-04 13:41:23.683 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/3:0] DETAIL: There are no running transactions. 2024-05-04 13:41:23.683 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16413_sync_16394_7365136844452825596" LOGICAL pgoutput (SNAPSHOT 'use') 2024-05-04 13:41:23.685 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/3:0] LOG: released logical replication slot "pg_16413_sync_16394_7365136844452825596" 2024-05-04 13:41:23.685 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16413_sync_16394_7365136844452825596" LOGICAL pgoutput (SNAPSHOT 'use') 2024-05-04 13:41:23.686 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][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 = 'tab3' 2024-05-04 13:41:23.690 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][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 = 16394 AND c.oid = gpt.relid AND p.pubname IN ( 'pub3' ) 2024-05-04 13:41:23.695 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/3:0] LOG: statement: SELECT a.attnum, a.attname, a.atttypid, a.attnum = ANY(i.indkey) FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_index i ON (i.indexrelid = pg_get_replica_identity_index(16394)) WHERE a.attnum > 0::pg_catalog.int2 AND NOT a.attisdropped AND a.attgenerated = '' AND a.attrelid = 16394 ORDER BY a.attnum 2024-05-04 13:41:23.697 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][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 = 16394 AND p.pubname IN ( 'pub3' ) 2024-05-04 13:41:23.699 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/3:0] LOG: statement: COPY public.tab3 (a) TO STDOUT 2024-05-04 13:41:23.699 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/3:0] LOG: statement: COMMIT 2024-05-04 13:41:23.700 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/0:0] LOG: received replication command: START_REPLICATION SLOT "pg_16413_sync_16394_7365136844452825596" LOGICAL 0/1532528 (proto_version '4', origin 'any', publication_names '"pub3"') 2024-05-04 13:41:23.700 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16413_sync_16394_7365136844452825596" LOGICAL 0/1532528 (proto_version '4', origin 'any', publication_names '"pub3"') 2024-05-04 13:41:23.700 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/0:0] LOG: acquired logical replication slot "pg_16413_sync_16394_7365136844452825596" 2024-05-04 13:41:23.700 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16413_sync_16394_7365136844452825596" LOGICAL 0/1532528 (proto_version '4', origin 'any', publication_names '"pub3"') 2024-05-04 13:41:23.702 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/0:0] LOG: starting logical decoding for slot "pg_16413_sync_16394_7365136844452825596" 2024-05-04 13:41:23.702 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/0:0] DETAIL: Streaming transactions committing after 0/1532528, reading WAL from 0/15324F0. 2024-05-04 13:41:23.702 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16413_sync_16394_7365136844452825596" LOGICAL 0/1532528 (proto_version '4', origin 'any', publication_names '"pub3"') 2024-05-04 13:41:23.702 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/0:0] LOG: logical decoding found consistent point at 0/15324F0 2024-05-04 13:41:23.702 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/0:0] DETAIL: There are no running transactions. 2024-05-04 13:41:23.702 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16413_sync_16394_7365136844452825596" LOGICAL 0/1532528 (proto_version '4', origin 'any', publication_names '"pub3"') 2024-05-04 13:41:23.703 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/0:0] LOG: released logical replication slot "pg_16413_sync_16394_7365136844452825596" 2024-05-04 13:41:23.703 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16413_sync_16394_7365136844452825596" LOGICAL 0/1532528 (proto_version '4', origin 'any', publication_names '"pub3"') 2024-05-04 13:41:23.703 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16413_sync_16394_7365136844452825596 WAIT 2024-05-04 13:41:23.703 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16413_sync_16394_7365136844452825596 WAIT 2024-05-04 13:41:23.703 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/0:0] LOG: acquired logical replication slot "pg_16413_sync_16394_7365136844452825596" 2024-05-04 13:41:23.703 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][31/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16413_sync_16394_7365136844452825596 WAIT 2024-05-04 13:41:23.704 GMT [6924][walsender] [pg_16413_sync_16394_7365136844452825596][:0] LOG: disconnection: session time: 0:00:00.053 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:24.173 GMT [5156][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:24.174 GMT [5156][client backend] [[unknown]][7/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:24.174 GMT [5156][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:24.178 GMT [5156][client backend] [010_truncate.pl][7/2:0] LOG: statement: SELECT pg_is_in_recovery() 2024-05-04 13:41:24.239 GMT [5156][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.069 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:24.514 GMT [6656][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:24.515 GMT [6656][client backend] [[unknown]][8/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:24.515 GMT [6656][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:24.518 GMT [6656][client backend] [010_truncate.pl][8/2:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-05-04 13:41:24.521 GMT [6656][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:24.853 GMT [8012][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:24.854 GMT [8012][client backend] [[unknown]][9/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:24.854 GMT [8012][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:24.857 GMT [8012][client backend] [010_truncate.pl][9/2:0] LOG: statement: SELECT '0/1532528' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub1', 'walreceiver') 2024-05-04 13:41:24.866 GMT [8012][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:25.060 GMT [5580][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:25.062 GMT [5580][client backend] [[unknown]][0/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:25.062 GMT [5580][client backend] [[unknown]][0/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:25.064 GMT [5580][client backend] [010_truncate.pl][0/4:0] LOG: statement: TRUNCATE tab1 2024-05-04 13:41:25.067 GMT [5580][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:25.201 GMT [5976][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:25.203 GMT [5976][client backend] [[unknown]][1/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:25.203 GMT [5976][client backend] [[unknown]][1/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:25.205 GMT [5976][client backend] [010_truncate.pl][1/4:0] LOG: statement: SELECT pg_is_in_recovery() 2024-05-04 13:41:25.209 GMT [5976][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:25.392 GMT [8108][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:25.394 GMT [8108][client backend] [[unknown]][2/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:25.394 GMT [8108][client backend] [[unknown]][2/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:25.397 GMT [8108][client backend] [010_truncate.pl][2/4:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-05-04 13:41:25.400 GMT [8108][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.021 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:25.554 GMT [5720][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:25.556 GMT [5720][client backend] [[unknown]][3/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:25.556 GMT [5720][client backend] [[unknown]][3/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:25.558 GMT [5720][client backend] [010_truncate.pl][3/4:0] LOG: statement: SELECT '0/1532BC8' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub1', 'walreceiver') 2024-05-04 13:41:25.567 GMT [5720][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:26.091 GMT [1152][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:26.092 GMT [1152][client backend] [[unknown]][4/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:26.092 GMT [1152][client backend] [[unknown]][4/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:26.094 GMT [1152][client backend] [010_truncate.pl][4/4:0] LOG: statement: TRUNCATE tab1 RESTART IDENTITY 2024-05-04 13:41:26.099 GMT [1152][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:26.298 GMT [4984][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:26.299 GMT [4984][client backend] [[unknown]][5/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:26.299 GMT [4984][client backend] [[unknown]][5/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:26.316 GMT [4984][client backend] [010_truncate.pl][5/4:0] LOG: statement: SELECT pg_is_in_recovery() 2024-05-04 13:41:26.332 GMT [4984][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.037 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:26.556 GMT [1532][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:26.557 GMT [1532][client backend] [[unknown]][6/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:26.557 GMT [1532][client backend] [[unknown]][6/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:26.560 GMT [1532][client backend] [010_truncate.pl][6/4:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-05-04 13:41:26.563 GMT [1532][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:26.747 GMT [6516][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:26.749 GMT [6516][client backend] [[unknown]][7/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:26.749 GMT [6516][client backend] [[unknown]][7/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:26.752 GMT [6516][client backend] [010_truncate.pl][7/4:0] LOG: statement: SELECT '0/1533258' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub1', 'walreceiver') 2024-05-04 13:41:26.761 GMT [6516][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.033 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:27.314 GMT [4404][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:27.315 GMT [4404][client backend] [[unknown]][8/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:27.315 GMT [4404][client backend] [[unknown]][8/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:27.317 GMT [4404][client backend] [010_truncate.pl][8/4:0] LOG: statement: TRUNCATE tab2 2024-05-04 13:41:27.321 GMT [4404][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:27.539 GMT [3776][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:27.540 GMT [3776][client backend] [[unknown]][9/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:27.540 GMT [3776][client backend] [[unknown]][9/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:27.589 GMT [3776][client backend] [010_truncate.pl][9/4:0] LOG: statement: SELECT pg_is_in_recovery() 2024-05-04 13:41:27.592 GMT [3776][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.057 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:27.944 GMT [4316][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:27.945 GMT [4316][client backend] [[unknown]][0/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:27.945 GMT [4316][client backend] [[unknown]][0/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:27.948 GMT [4316][client backend] [010_truncate.pl][0/6:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-05-04 13:41:27.950 GMT [4316][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.039 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:28.257 GMT [5656][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:28.258 GMT [5656][client backend] [[unknown]][1/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:28.258 GMT [5656][client backend] [[unknown]][1/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:28.270 GMT [5656][client backend] [010_truncate.pl][1/6:0] LOG: statement: SELECT '0/15338F8' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub2', 'walreceiver') 2024-05-04 13:41:28.280 GMT [5656][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.026 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:28.638 GMT [6712][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:28.640 GMT [6712][client backend] [[unknown]][2/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:28.640 GMT [6712][client backend] [[unknown]][2/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:28.643 GMT [6712][client backend] [010_truncate.pl][2/6:0] LOG: statement: ALTER PUBLICATION pub2 SET (publish = 'insert, truncate') 2024-05-04 13:41:28.645 GMT [6712][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:28.824 GMT [1516][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:28.825 GMT [1516][client backend] [[unknown]][3/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:28.825 GMT [1516][client backend] [[unknown]][3/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:28.829 GMT [1516][client backend] [010_truncate.pl][3/6:0] LOG: statement: TRUNCATE tab2 2024-05-04 13:41:28.847 GMT [1516][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.027 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:28.987 GMT [7960][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:28.988 GMT [7960][client backend] [[unknown]][4/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:28.988 GMT [7960][client backend] [[unknown]][4/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:28.993 GMT [7960][client backend] [010_truncate.pl][4/6:0] LOG: statement: SELECT pg_is_in_recovery() 2024-05-04 13:41:28.996 GMT [7960][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:29.280 GMT [6948][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:29.281 GMT [6948][client backend] [[unknown]][5/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:29.281 GMT [6948][client backend] [[unknown]][5/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:29.284 GMT [6948][client backend] [010_truncate.pl][5/6:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-05-04 13:41:29.302 GMT [6948][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.025 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:29.523 GMT [3524][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:29.525 GMT [3524][client backend] [[unknown]][6/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:29.525 GMT [3524][client backend] [[unknown]][6/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:29.528 GMT [3524][client backend] [010_truncate.pl][6/6:0] LOG: statement: SELECT '0/1534140' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub2', 'walreceiver') 2024-05-04 13:41:29.667 GMT [3524][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.149 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:30.521 GMT [4316][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:30.522 GMT [4316][client backend] [[unknown]][7/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:30.522 GMT [4316][client backend] [[unknown]][7/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:30.526 GMT [4316][client backend] [010_truncate.pl][7/6:0] LOG: statement: TRUNCATE tab3, tab4 2024-05-04 13:41:30.533 GMT [4316][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:30.748 GMT [7516][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:30.750 GMT [7516][client backend] [[unknown]][8/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:30.750 GMT [7516][client backend] [[unknown]][8/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:30.753 GMT [7516][client backend] [010_truncate.pl][8/6:0] LOG: statement: SELECT pg_is_in_recovery() 2024-05-04 13:41:30.755 GMT [7516][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:30.974 GMT [8092][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:30.976 GMT [8092][client backend] [[unknown]][9/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:30.976 GMT [8092][client backend] [[unknown]][9/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:30.978 GMT [8092][client backend] [010_truncate.pl][9/6:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-05-04 13:41:30.982 GMT [8092][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.060 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:31.151 GMT [6780][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:31.153 GMT [6780][client backend] [[unknown]][0/7:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:31.153 GMT [6780][client backend] [[unknown]][0/7:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:31.165 GMT [6780][client backend] [010_truncate.pl][0/8:0] LOG: statement: SELECT '0/1534E20' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub3', 'walreceiver') 2024-05-04 13:41:31.191 GMT [6780][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.043 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:31.757 GMT [8128][walsender] [sub2][26/0:0] LOG: released logical replication slot "sub2" 2024-05-04 13:41:31.757 GMT [8128][walsender] [sub2][:0] LOG: disconnection: session time: 0:00:08.704 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:31.810 GMT [3876][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:31.811 GMT [3876][walsender] [[unknown]][22/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:31.811 GMT [3876][walsender] [[unknown]][22/5:0] LOG: replication connection authorized: user=SYSTEM application_name=sub2 2024-05-04 13:41:31.814 GMT [3876][walsender] [sub2][22/6:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:31.816 GMT [3876][walsender] [sub2][22/0:0] LOG: received replication command: DROP_REPLICATION_SLOT sub2 WAIT 2024-05-04 13:41:31.816 GMT [3876][walsender] [sub2][22/0:0] STATEMENT: DROP_REPLICATION_SLOT sub2 WAIT 2024-05-04 13:41:31.816 GMT [3876][walsender] [sub2][22/0:0] LOG: acquired logical replication slot "sub2" 2024-05-04 13:41:31.816 GMT [3876][walsender] [sub2][22/0:0] STATEMENT: DROP_REPLICATION_SLOT sub2 WAIT 2024-05-04 13:41:31.817 GMT [3876][walsender] [sub2][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:32.010 GMT [6240][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:32.011 GMT [6240][client backend] [[unknown]][1/7:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:32.011 GMT [6240][client backend] [[unknown]][1/7:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:32.033 GMT [6240][client backend] [010_truncate.pl][1/8:0] LOG: statement: DROP PUBLICATION pub2 2024-05-04 13:41:32.036 GMT [6240][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.053 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:32.374 GMT [7384][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:32.376 GMT [7384][client backend] [[unknown]][2/7:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:32.376 GMT [7384][client backend] [[unknown]][2/7:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:32.378 GMT [7384][client backend] [010_truncate.pl][2/8:0] LOG: statement: TRUNCATE tab1, tab2 2024-05-04 13:41:32.384 GMT [7384][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:32.506 GMT [4824][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:32.508 GMT [4824][client backend] [[unknown]][3/7:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:32.508 GMT [4824][client backend] [[unknown]][3/7:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:32.510 GMT [4824][client backend] [010_truncate.pl][3/8:0] LOG: statement: SELECT pg_is_in_recovery() 2024-05-04 13:41:32.514 GMT [4824][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:32.677 GMT [7244][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:32.678 GMT [7244][client backend] [[unknown]][4/7:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:32.678 GMT [7244][client backend] [[unknown]][4/7:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:32.693 GMT [7244][client backend] [010_truncate.pl][4/8:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-05-04 13:41:32.696 GMT [7244][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:32.931 GMT [4028][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:32.932 GMT [4028][client backend] [[unknown]][5/7:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:32.932 GMT [4028][client backend] [[unknown]][5/7:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:32.935 GMT [4028][client backend] [010_truncate.pl][5/8:0] LOG: statement: SELECT '0/1535E30' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub1', 'walreceiver') 2024-05-04 13:41:32.945 GMT [4028][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:33.485 GMT [3800][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:33.487 GMT [3800][client backend] [[unknown]][6/7:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:33.487 GMT [3800][client backend] [[unknown]][6/7:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:33.505 GMT [3800][client backend] [010_truncate.pl][6/8:0] LOG: statement: ALTER SYSTEM SET synchronous_standby_names TO 'sub1' 2024-05-04 13:41:33.516 GMT [3800][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.044 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:33.888 GMT [5564][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:33.890 GMT [5564][client backend] [[unknown]][7/7:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:33.890 GMT [5564][client backend] [[unknown]][7/7:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:33.893 GMT [5564][client backend] [010_truncate.pl][7/8:0] LOG: statement: SELECT pg_reload_conf() 2024-05-04 13:41:33.893 GMT [7092][postmaster] LOG: received SIGHUP, reloading configuration files 2024-05-04 13:41:33.896 GMT [7092][postmaster] LOG: parameter "synchronous_standby_names" changed to "sub1" 2024-05-04 13:41:33.896 GMT [5564][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:34.370 GMT [5480][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:34.372 GMT [5480][client backend] [[unknown]][8/7:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:34.372 GMT [5480][client backend] [[unknown]][8/7:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:34.374 GMT [5480][client backend] [010_truncate.pl][8/8:0] LOG: statement: INSERT INTO tab1 VALUES (1), (2), (3) 2024-05-04 13:41:34.377 GMT [3704][walsender] [sub1][23/0:0] LOG: standby "sub1" is now a synchronous standby with priority 1 2024-05-04 13:41:34.377 GMT [3704][walsender] [sub1][23/0:0] STATEMENT: START_REPLICATION SLOT "sub1" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub1"') 2024-05-04 13:41:34.567 GMT [5480][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.200 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:34.861 GMT [7144][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:34.862 GMT [7144][client backend] [[unknown]][9/7:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:34.862 GMT [7144][client backend] [[unknown]][9/7:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:34.872 GMT [7144][client backend] [010_truncate.pl][9/8:0] LOG: statement: SELECT pg_is_in_recovery() 2024-05-04 13:41:34.875 GMT [7144][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:35.109 GMT [4000][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:35.111 GMT [4000][client backend] [[unknown]][0/9:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:35.111 GMT [4000][client backend] [[unknown]][0/9:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:35.113 GMT [4000][client backend] [010_truncate.pl][0/10:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-05-04 13:41:35.117 GMT [4000][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:35.293 GMT [2072][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:35.295 GMT [2072][client backend] [[unknown]][1/9:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:35.295 GMT [2072][client backend] [[unknown]][1/9:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:35.323 GMT [2072][client backend] [010_truncate.pl][1/10:0] LOG: statement: SELECT '0/1536058' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub1', 'walreceiver') 2024-05-04 13:41:35.334 GMT [2072][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.050 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:35.841 GMT [8148][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:35.842 GMT [8148][client backend] [[unknown]][2/9:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:35.842 GMT [8148][client backend] [[unknown]][2/9:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:35.845 GMT [8148][client backend] [010_truncate.pl][2/10:0] LOG: statement: TRUNCATE tab1 2024-05-04 13:41:35.852 GMT [8148][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:36.185 GMT [6716][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:36.186 GMT [6716][client backend] [[unknown]][3/9:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:36.186 GMT [6716][client backend] [[unknown]][3/9:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:36.189 GMT [6716][client backend] [010_truncate.pl][3/10:0] LOG: statement: SELECT pg_is_in_recovery() 2024-05-04 13:41:36.194 GMT [6716][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:36.433 GMT [6696][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:36.434 GMT [6696][client backend] [[unknown]][4/9:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:36.435 GMT [6696][client backend] [[unknown]][4/9:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:36.445 GMT [6696][client backend] [010_truncate.pl][4/10:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-05-04 13:41:36.448 GMT [6696][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.041 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:36.632 GMT [7208][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:36.633 GMT [7208][client backend] [[unknown]][5/9:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:36.633 GMT [7208][client backend] [[unknown]][5/9:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:36.636 GMT [7208][client backend] [010_truncate.pl][5/10:0] LOG: statement: SELECT '0/15366E8' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub1', 'walreceiver') 2024-05-04 13:41:36.644 GMT [7208][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:36.954 GMT [7464][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:36.955 GMT [7464][client backend] [[unknown]][6/9:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:36.955 GMT [7464][client backend] [[unknown]][6/9:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:36.958 GMT [7464][client backend] [010_truncate.pl][6/10:0] LOG: statement: ALTER SYSTEM RESET synchronous_standby_names 2024-05-04 13:41:36.959 GMT [7464][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:37.280 GMT [8120][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:37.281 GMT [8120][client backend] [[unknown]][7/9:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:37.281 GMT [8120][client backend] [[unknown]][7/9:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:37.283 GMT [8120][client backend] [010_truncate.pl][7/10:0] LOG: statement: SELECT pg_reload_conf() 2024-05-04 13:41:37.284 GMT [7092][postmaster] LOG: received SIGHUP, reloading configuration files 2024-05-04 13:41:37.285 GMT [7092][postmaster] LOG: parameter "synchronous_standby_names" removed from configuration file, reset to default 2024-05-04 13:41:37.286 GMT [8120][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:37.542 GMT [8108][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:37.543 GMT [8108][client backend] [[unknown]][8/9:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:37.543 GMT [8108][client backend] [[unknown]][8/9:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:37.545 GMT [8108][client backend] [010_truncate.pl][8/10:0] LOG: statement: CREATE TABLE tab5 (a int) 2024-05-04 13:41:37.549 GMT [8108][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:37.852 GMT [6344][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:37.854 GMT [6344][client backend] [[unknown]][9/9:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:37.854 GMT [6344][client backend] [[unknown]][9/9:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:37.859 GMT [6344][client backend] [010_truncate.pl][9/10:0] LOG: statement: CREATE PUBLICATION pub5 FOR TABLE tab5 2024-05-04 13:41:37.862 GMT [6344][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:38.019 GMT [4028][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:38.021 GMT [4028][walsender] [[unknown]][24/4:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:38.021 GMT [4028][walsender] [[unknown]][24/4:0] LOG: replication connection authorized: user=SYSTEM application_name=sub5_1 2024-05-04 13:41:38.051 GMT [4028][walsender] [sub5_1][24/5:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:38.052 GMT [4028][walsender] [sub5_1][24/6:0] LOG: statement: SELECT t.pubname FROM pg_catalog.pg_publication t WHERE t.pubname IN ('pub5') 2024-05-04 13:41:38.054 GMT [4028][walsender] [sub5_1][24/7: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 ( 'pub5' )) AS gpt ON gpt.relid = c.oid 2024-05-04 13:41:38.063 GMT [4028][walsender] [sub5_1][24/0:0] LOG: received replication command: CREATE_REPLICATION_SLOT "sub5_1" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-05-04 13:41:38.063 GMT [4028][walsender] [sub5_1][24/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub5_1" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-05-04 13:41:38.070 GMT [4028][walsender] [sub5_1][24/0:0] LOG: logical decoding found consistent point at 0/1538258 2024-05-04 13:41:38.070 GMT [4028][walsender] [sub5_1][24/0:0] DETAIL: There are no running transactions. 2024-05-04 13:41:38.070 GMT [4028][walsender] [sub5_1][24/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub5_1" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-05-04 13:41:38.074 GMT [4028][walsender] [sub5_1][24/0:0] LOG: released logical replication slot "sub5_1" 2024-05-04 13:41:38.074 GMT [4028][walsender] [sub5_1][24/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub5_1" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-05-04 13:41:38.074 GMT [4028][walsender] [sub5_1][:0] LOG: disconnection: session time: 0:00:00.058 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:38.172 GMT [6240][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:38.173 GMT [6240][walsender] [[unknown]][25/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:38.173 GMT [6240][walsender] [[unknown]][25/5:0] LOG: replication connection authorized: user=SYSTEM application_name=sub5_1 2024-05-04 13:41:38.181 GMT [6240][walsender] [sub5_1][25/6:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:38.182 GMT [6240][walsender] [sub5_1][25/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-05-04 13:41:38.182 GMT [6240][walsender] [sub5_1][25/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-05-04 13:41:38.182 GMT [6240][walsender] [sub5_1][25/0:0] LOG: received replication command: START_REPLICATION SLOT "sub5_1" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:38.182 GMT [6240][walsender] [sub5_1][25/0:0] STATEMENT: START_REPLICATION SLOT "sub5_1" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:38.182 GMT [6240][walsender] [sub5_1][25/0:0] LOG: acquired logical replication slot "sub5_1" 2024-05-04 13:41:38.182 GMT [6240][walsender] [sub5_1][25/0:0] STATEMENT: START_REPLICATION SLOT "sub5_1" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:38.185 GMT [6240][walsender] [sub5_1][25/0:0] LOG: starting logical decoding for slot "sub5_1" 2024-05-04 13:41:38.185 GMT [6240][walsender] [sub5_1][25/0:0] DETAIL: Streaming transactions committing after 0/1538290, reading WAL from 0/1538258. 2024-05-04 13:41:38.185 GMT [6240][walsender] [sub5_1][25/0:0] STATEMENT: START_REPLICATION SLOT "sub5_1" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:38.185 GMT [6240][walsender] [sub5_1][25/0:0] LOG: logical decoding found consistent point at 0/1538258 2024-05-04 13:41:38.185 GMT [6240][walsender] [sub5_1][25/0:0] DETAIL: There are no running transactions. 2024-05-04 13:41:38.185 GMT [6240][walsender] [sub5_1][25/0:0] STATEMENT: START_REPLICATION SLOT "sub5_1" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:38.234 GMT [8028][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:38.235 GMT [8028][walsender] [[unknown]][27/4:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:38.235 GMT [8028][walsender] [[unknown]][27/4:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16432_sync_16429_7365136844452825596 2024-05-04 13:41:38.238 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/5:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:38.239 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/6:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-05-04 13:41:38.239 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/6:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16432_sync_16429_7365136844452825596" LOGICAL pgoutput (SNAPSHOT 'use') 2024-05-04 13:41:38.239 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/6:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16432_sync_16429_7365136844452825596" LOGICAL pgoutput (SNAPSHOT 'use') 2024-05-04 13:41:38.249 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/6:0] LOG: logical decoding found consistent point at 0/1538290 2024-05-04 13:41:38.249 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/6:0] DETAIL: There are no running transactions. 2024-05-04 13:41:38.249 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/6:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16432_sync_16429_7365136844452825596" LOGICAL pgoutput (SNAPSHOT 'use') 2024-05-04 13:41:38.251 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/6:0] LOG: released logical replication slot "pg_16432_sync_16429_7365136844452825596" 2024-05-04 13:41:38.251 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/6:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16432_sync_16429_7365136844452825596" LOGICAL pgoutput (SNAPSHOT 'use') 2024-05-04 13:41:38.252 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/6: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 = 'tab5' 2024-05-04 13:41:38.256 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/6: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 = 16434 AND c.oid = gpt.relid AND p.pubname IN ( 'pub5' ) 2024-05-04 13:41:38.261 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/6:0] LOG: statement: SELECT a.attnum, a.attname, a.atttypid, a.attnum = ANY(i.indkey) FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_index i ON (i.indexrelid = pg_get_replica_identity_index(16434)) WHERE a.attnum > 0::pg_catalog.int2 AND NOT a.attisdropped AND a.attgenerated = '' AND a.attrelid = 16434 ORDER BY a.attnum 2024-05-04 13:41:38.263 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/6: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 = 16434 AND p.pubname IN ( 'pub5' ) 2024-05-04 13:41:38.265 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/6:0] LOG: statement: COPY public.tab5 (a) TO STDOUT 2024-05-04 13:41:38.266 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/6:0] LOG: statement: COMMIT 2024-05-04 13:41:38.266 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/0:0] LOG: received replication command: START_REPLICATION SLOT "pg_16432_sync_16429_7365136844452825596" LOGICAL 0/15382C8 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:38.266 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/0:0] STATEMENT: START_REPLICATION SLOT "pg_16432_sync_16429_7365136844452825596" LOGICAL 0/15382C8 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:38.266 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/0:0] LOG: acquired logical replication slot "pg_16432_sync_16429_7365136844452825596" 2024-05-04 13:41:38.266 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/0:0] STATEMENT: START_REPLICATION SLOT "pg_16432_sync_16429_7365136844452825596" LOGICAL 0/15382C8 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:38.268 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/0:0] LOG: starting logical decoding for slot "pg_16432_sync_16429_7365136844452825596" 2024-05-04 13:41:38.268 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/0:0] DETAIL: Streaming transactions committing after 0/15382C8, reading WAL from 0/1538290. 2024-05-04 13:41:38.268 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/0:0] STATEMENT: START_REPLICATION SLOT "pg_16432_sync_16429_7365136844452825596" LOGICAL 0/15382C8 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:38.269 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/0:0] LOG: logical decoding found consistent point at 0/1538290 2024-05-04 13:41:38.269 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/0:0] DETAIL: There are no running transactions. 2024-05-04 13:41:38.269 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/0:0] STATEMENT: START_REPLICATION SLOT "pg_16432_sync_16429_7365136844452825596" LOGICAL 0/15382C8 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:38.269 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/0:0] LOG: released logical replication slot "pg_16432_sync_16429_7365136844452825596" 2024-05-04 13:41:38.269 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/0:0] STATEMENT: START_REPLICATION SLOT "pg_16432_sync_16429_7365136844452825596" LOGICAL 0/15382C8 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:38.270 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16432_sync_16429_7365136844452825596 WAIT 2024-05-04 13:41:38.270 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16432_sync_16429_7365136844452825596 WAIT 2024-05-04 13:41:38.270 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/0:0] LOG: acquired logical replication slot "pg_16432_sync_16429_7365136844452825596" 2024-05-04 13:41:38.270 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][27/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16432_sync_16429_7365136844452825596 WAIT 2024-05-04 13:41:38.271 GMT [8028][walsender] [pg_16432_sync_16429_7365136844452825596][:0] LOG: disconnection: session time: 0:00:00.042 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:38.295 GMT [1520][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:38.297 GMT [1520][walsender] [[unknown]][28/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:38.297 GMT [1520][walsender] [[unknown]][28/5:0] LOG: replication connection authorized: user=SYSTEM application_name=sub5_2 2024-05-04 13:41:38.301 GMT [1520][walsender] [sub5_2][28/6:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:38.302 GMT [1520][walsender] [sub5_2][28/7:0] LOG: statement: SELECT t.pubname FROM pg_catalog.pg_publication t WHERE t.pubname IN ('pub5') 2024-05-04 13:41:38.304 GMT [1520][walsender] [sub5_2][28/8: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 ( 'pub5' )) AS gpt ON gpt.relid = c.oid 2024-05-04 13:41:38.310 GMT [1520][walsender] [sub5_2][28/0:0] LOG: received replication command: CREATE_REPLICATION_SLOT "sub5_2" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-05-04 13:41:38.310 GMT [1520][walsender] [sub5_2][28/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub5_2" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-05-04 13:41:38.314 GMT [1520][walsender] [sub5_2][28/0:0] LOG: logical decoding found consistent point at 0/15382C8 2024-05-04 13:41:38.314 GMT [1520][walsender] [sub5_2][28/0:0] DETAIL: There are no running transactions. 2024-05-04 13:41:38.314 GMT [1520][walsender] [sub5_2][28/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub5_2" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-05-04 13:41:38.316 GMT [1520][walsender] [sub5_2][28/0:0] LOG: released logical replication slot "sub5_2" 2024-05-04 13:41:38.316 GMT [1520][walsender] [sub5_2][28/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub5_2" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-05-04 13:41:38.317 GMT [1520][walsender] [sub5_2][:0] LOG: disconnection: session time: 0:00:00.025 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:38.454 GMT [7924][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:38.456 GMT [7924][walsender] [[unknown]][30/4:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:38.456 GMT [7924][walsender] [[unknown]][30/4:0] LOG: replication connection authorized: user=SYSTEM application_name=sub5_2 2024-05-04 13:41:38.503 GMT [7924][walsender] [sub5_2][30/5:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:38.504 GMT [7924][walsender] [sub5_2][30/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-05-04 13:41:38.504 GMT [7924][walsender] [sub5_2][30/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-05-04 13:41:38.504 GMT [7924][walsender] [sub5_2][30/0:0] LOG: received replication command: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:38.504 GMT [7924][walsender] [sub5_2][30/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:38.504 GMT [7924][walsender] [sub5_2][30/0:0] LOG: acquired logical replication slot "sub5_2" 2024-05-04 13:41:38.504 GMT [7924][walsender] [sub5_2][30/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:38.519 GMT [7924][walsender] [sub5_2][30/0:0] LOG: starting logical decoding for slot "sub5_2" 2024-05-04 13:41:38.519 GMT [7924][walsender] [sub5_2][30/0:0] DETAIL: Streaming transactions committing after 0/1538300, reading WAL from 0/15382C8. 2024-05-04 13:41:38.519 GMT [7924][walsender] [sub5_2][30/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:38.519 GMT [7924][walsender] [sub5_2][30/0:0] LOG: logical decoding found consistent point at 0/15382C8 2024-05-04 13:41:38.519 GMT [7924][walsender] [sub5_2][30/0:0] DETAIL: There are no running transactions. 2024-05-04 13:41:38.519 GMT [7924][walsender] [sub5_2][30/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:38.695 GMT [3908][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:38.696 GMT [3908][walsender] [[unknown]][31/4:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:38.696 GMT [3908][walsender] [[unknown]][31/4:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16433_sync_16429_7365136844452825596 2024-05-04 13:41:38.699 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/5:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:38.700 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/6:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-05-04 13:41:38.700 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/6:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16433_sync_16429_7365136844452825596" LOGICAL pgoutput (SNAPSHOT 'use') 2024-05-04 13:41:38.700 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/6:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16433_sync_16429_7365136844452825596" LOGICAL pgoutput (SNAPSHOT 'use') 2024-05-04 13:41:38.713 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/6:0] LOG: logical decoding found consistent point at 0/1538300 2024-05-04 13:41:38.713 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/6:0] DETAIL: There are no running transactions. 2024-05-04 13:41:38.713 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/6:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16433_sync_16429_7365136844452825596" LOGICAL pgoutput (SNAPSHOT 'use') 2024-05-04 13:41:38.715 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/6:0] LOG: released logical replication slot "pg_16433_sync_16429_7365136844452825596" 2024-05-04 13:41:38.715 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/6:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16433_sync_16429_7365136844452825596" LOGICAL pgoutput (SNAPSHOT 'use') 2024-05-04 13:41:38.715 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/6: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 = 'tab5' 2024-05-04 13:41:38.720 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/6: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 = 16434 AND c.oid = gpt.relid AND p.pubname IN ( 'pub5' ) 2024-05-04 13:41:38.724 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/6:0] LOG: statement: SELECT a.attnum, a.attname, a.atttypid, a.attnum = ANY(i.indkey) FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_index i ON (i.indexrelid = pg_get_replica_identity_index(16434)) WHERE a.attnum > 0::pg_catalog.int2 AND NOT a.attisdropped AND a.attgenerated = '' AND a.attrelid = 16434 ORDER BY a.attnum 2024-05-04 13:41:38.727 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/6: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 = 16434 AND p.pubname IN ( 'pub5' ) 2024-05-04 13:41:38.728 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/6:0] LOG: statement: COPY public.tab5 (a) TO STDOUT 2024-05-04 13:41:38.729 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/6:0] LOG: statement: COMMIT 2024-05-04 13:41:38.729 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/0:0] LOG: received replication command: START_REPLICATION SLOT "pg_16433_sync_16429_7365136844452825596" LOGICAL 0/1538338 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:38.729 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16433_sync_16429_7365136844452825596" LOGICAL 0/1538338 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:38.729 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/0:0] LOG: acquired logical replication slot "pg_16433_sync_16429_7365136844452825596" 2024-05-04 13:41:38.729 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16433_sync_16429_7365136844452825596" LOGICAL 0/1538338 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:38.731 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/0:0] LOG: starting logical decoding for slot "pg_16433_sync_16429_7365136844452825596" 2024-05-04 13:41:38.731 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/0:0] DETAIL: Streaming transactions committing after 0/1538338, reading WAL from 0/1538300. 2024-05-04 13:41:38.731 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16433_sync_16429_7365136844452825596" LOGICAL 0/1538338 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:38.732 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/0:0] LOG: logical decoding found consistent point at 0/1538300 2024-05-04 13:41:38.732 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/0:0] DETAIL: There are no running transactions. 2024-05-04 13:41:38.732 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16433_sync_16429_7365136844452825596" LOGICAL 0/1538338 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:38.733 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/0:0] LOG: released logical replication slot "pg_16433_sync_16429_7365136844452825596" 2024-05-04 13:41:38.733 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16433_sync_16429_7365136844452825596" LOGICAL 0/1538338 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:38.733 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16433_sync_16429_7365136844452825596 WAIT 2024-05-04 13:41:38.733 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16433_sync_16429_7365136844452825596 WAIT 2024-05-04 13:41:38.733 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/0:0] LOG: acquired logical replication slot "pg_16433_sync_16429_7365136844452825596" 2024-05-04 13:41:38.733 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][31/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16433_sync_16429_7365136844452825596 WAIT 2024-05-04 13:41:38.734 GMT [3908][walsender] [pg_16433_sync_16429_7365136844452825596][:0] LOG: disconnection: session time: 0:00:00.043 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:39.058 GMT [7924][walsender] [sub5_2][30/0:0] PANIC: could not open file "pg_logical/snapshots/0-1538300.snap": Permission denied 2024-05-04 13:41:39.058 GMT [7924][walsender] [sub5_2][30/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') abort() has been called2024-05-04 13:41:39.189 GMT [7428][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:39.191 GMT [7428][walsender] [[unknown]][26/10:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:39.191 GMT [7428][walsender] [[unknown]][26/10:0] LOG: replication connection authorized: user=SYSTEM application_name=sub5_2 2024-05-04 13:41:39.195 GMT [7428][walsender] [sub5_2][26/11:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:39.195 GMT [7428][walsender] [sub5_2][26/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-05-04 13:41:39.195 GMT [7428][walsender] [sub5_2][26/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-05-04 13:41:39.195 GMT [7428][walsender] [sub5_2][26/0:0] LOG: received replication command: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:39.195 GMT [7428][walsender] [sub5_2][26/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:39.195 GMT [7428][walsender] [sub5_2][26/0:0] ERROR: replication slot "sub5_2" is active for PID 7924 2024-05-04 13:41:39.195 GMT [7428][walsender] [sub5_2][26/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:39.196 GMT [7428][walsender] [sub5_2][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:39.469 GMT [5456][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:39.470 GMT [5456][client backend] [[unknown]][0/11:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:39.470 GMT [5456][client backend] [[unknown]][0/11:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:39.473 GMT [5456][client backend] [010_truncate.pl][0/12:0] LOG: statement: INSERT INTO tab5 VALUES (1), (2), (3) 2024-05-04 13:41:39.474 GMT [5456][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:39.649 GMT [1812][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:39.650 GMT [1812][walsender] [[unknown]][22/7:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:39.650 GMT [1812][walsender] [[unknown]][22/7:0] LOG: replication connection authorized: user=SYSTEM application_name=sub5_2 2024-05-04 13:41:39.653 GMT [1812][walsender] [sub5_2][22/8:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:39.653 GMT [1812][walsender] [sub5_2][22/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-05-04 13:41:39.653 GMT [1812][walsender] [sub5_2][22/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-05-04 13:41:39.653 GMT [1812][walsender] [sub5_2][22/0:0] LOG: received replication command: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:39.653 GMT [1812][walsender] [sub5_2][22/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:39.654 GMT [1812][walsender] [sub5_2][22/0:0] ERROR: replication slot "sub5_2" is active for PID 7924 2024-05-04 13:41:39.654 GMT [1812][walsender] [sub5_2][22/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:39.654 GMT [1812][walsender] [sub5_2][:0] LOG: disconnection: session time: 0:00:00.024 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:39.671 GMT [3836][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:39.672 GMT [3836][client backend] [[unknown]][1/11:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:39.672 GMT [3836][client backend] [[unknown]][1/11:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:39.678 GMT [3836][client backend] [010_truncate.pl][1/12:0] LOG: statement: SELECT pg_is_in_recovery() 2024-05-04 13:41:39.682 GMT [3836][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:39.935 GMT [6572][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:39.936 GMT [6572][client backend] [[unknown]][2/11:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:39.936 GMT [6572][client backend] [[unknown]][2/11:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:39.938 GMT [6572][client backend] [010_truncate.pl][2/12:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-05-04 13:41:39.942 GMT [6572][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:40.144 GMT [4036][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:40.146 GMT [4036][client backend] [[unknown]][3/11:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:40.146 GMT [4036][client backend] [[unknown]][3/11:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:40.148 GMT [4036][client backend] [010_truncate.pl][3/12:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_1', 'walreceiver') 2024-05-04 13:41:40.158 GMT [4036][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.018 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:40.243 GMT [5544][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:40.244 GMT [5544][walsender] [[unknown]][24/8:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:40.244 GMT [5544][walsender] [[unknown]][24/8:0] LOG: replication connection authorized: user=SYSTEM application_name=sub5_2 2024-05-04 13:41:40.273 GMT [5544][walsender] [sub5_2][24/9:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:40.273 GMT [5544][walsender] [sub5_2][24/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-05-04 13:41:40.273 GMT [5544][walsender] [sub5_2][24/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-05-04 13:41:40.274 GMT [5544][walsender] [sub5_2][24/0:0] LOG: received replication command: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:40.274 GMT [5544][walsender] [sub5_2][24/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:40.274 GMT [5544][walsender] [sub5_2][24/0:0] ERROR: replication slot "sub5_2" is active for PID 7924 2024-05-04 13:41:40.274 GMT [5544][walsender] [sub5_2][24/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:40.274 GMT [5544][walsender] [sub5_2][:0] LOG: disconnection: session time: 0:00:00.034 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:40.347 GMT [4720][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:40.348 GMT [4720][client backend] [[unknown]][4/11:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:40.348 GMT [4720][client backend] [[unknown]][4/11:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:40.351 GMT [4720][client backend] [010_truncate.pl][4/12:0] LOG: statement: SELECT pg_is_in_recovery() 2024-05-04 13:41:40.355 GMT [4720][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:40.622 GMT [4852][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:40.623 GMT [4852][client backend] [[unknown]][5/11:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:40.623 GMT [4852][client backend] [[unknown]][5/11:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:40.626 GMT [4852][client backend] [010_truncate.pl][5/12:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-05-04 13:41:40.631 GMT [4852][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:40.817 GMT [6532][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:40.818 GMT [6532][walsender] [[unknown]][27/7:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:40.818 GMT [6532][walsender] [[unknown]][27/7:0] LOG: replication connection authorized: user=SYSTEM application_name=sub5_2 2024-05-04 13:41:40.821 GMT [6532][walsender] [sub5_2][27/8:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:40.821 GMT [6532][walsender] [sub5_2][27/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-05-04 13:41:40.821 GMT [6532][walsender] [sub5_2][27/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-05-04 13:41:40.822 GMT [6532][walsender] [sub5_2][27/0:0] LOG: received replication command: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:40.822 GMT [6532][walsender] [sub5_2][27/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:40.822 GMT [6532][walsender] [sub5_2][27/0:0] ERROR: replication slot "sub5_2" is active for PID 7924 2024-05-04 13:41:40.822 GMT [6532][walsender] [sub5_2][27/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:40.822 GMT [6532][walsender] [sub5_2][:0] LOG: disconnection: session time: 0:00:00.008 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:40.895 GMT [6280][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:40.897 GMT [6280][client backend] [[unknown]][6/11:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:40.897 GMT [6280][client backend] [[unknown]][6/11:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:40.900 GMT [6280][client backend] [010_truncate.pl][6/12:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:40.910 GMT [6280][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.018 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:41.190 GMT [4616][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:41.192 GMT [4616][client backend] [[unknown]][7/11:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:41.192 GMT [4616][client backend] [[unknown]][7/11:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:41.194 GMT [4616][client backend] [010_truncate.pl][7/12:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:41.215 GMT [4616][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.028 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:41.281 GMT [6904][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:41.282 GMT [6904][walsender] [[unknown]][28/9:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:41.282 GMT [6904][walsender] [[unknown]][28/9:0] LOG: replication connection authorized: user=SYSTEM application_name=sub5_2 2024-05-04 13:41:41.286 GMT [6904][walsender] [sub5_2][28/10:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:41.286 GMT [6904][walsender] [sub5_2][28/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-05-04 13:41:41.286 GMT [6904][walsender] [sub5_2][28/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-05-04 13:41:41.286 GMT [6904][walsender] [sub5_2][28/0:0] LOG: received replication command: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:41.286 GMT [6904][walsender] [sub5_2][28/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:41.286 GMT [6904][walsender] [sub5_2][28/0:0] ERROR: replication slot "sub5_2" is active for PID 7924 2024-05-04 13:41:41.286 GMT [6904][walsender] [sub5_2][28/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:41.287 GMT [6904][walsender] [sub5_2][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:41.567 GMT [6492][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:41.571 GMT [6492][client backend] [[unknown]][8/11:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:41.571 GMT [6492][client backend] [[unknown]][8/11:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:41.576 GMT [6492][client backend] [010_truncate.pl][8/12:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:41.584 GMT [6492][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.027 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:41.757 GMT [5996][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:41.758 GMT [5996][walsender] [[unknown]][31/7:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:41.758 GMT [5996][walsender] [[unknown]][31/7:0] LOG: replication connection authorized: user=SYSTEM application_name=sub5_2 2024-05-04 13:41:41.762 GMT [5996][walsender] [sub5_2][31/8:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:41.763 GMT [5996][walsender] [sub5_2][31/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-05-04 13:41:41.763 GMT [5996][walsender] [sub5_2][31/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-05-04 13:41:41.763 GMT [5996][walsender] [sub5_2][31/0:0] LOG: received replication command: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:41.763 GMT [5996][walsender] [sub5_2][31/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:41.763 GMT [5996][walsender] [sub5_2][31/0:0] ERROR: replication slot "sub5_2" is active for PID 7924 2024-05-04 13:41:41.763 GMT [5996][walsender] [sub5_2][31/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:41.763 GMT [5996][walsender] [sub5_2][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:41.852 GMT [7064][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:41.854 GMT [7064][client backend] [[unknown]][9/11:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:41.854 GMT [7064][client backend] [[unknown]][9/11:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:41.861 GMT [7064][client backend] [010_truncate.pl][9/12:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:41.911 GMT [7064][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.062 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:42.338 GMT [2596][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:42.339 GMT [2596][walsender] [[unknown]][26/13:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:42.339 GMT [2596][walsender] [[unknown]][26/13:0] LOG: replication connection authorized: user=SYSTEM application_name=sub5_2 2024-05-04 13:41:42.342 GMT [2596][walsender] [sub5_2][26/14:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:42.342 GMT [2596][walsender] [sub5_2][26/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-05-04 13:41:42.342 GMT [2596][walsender] [sub5_2][26/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-05-04 13:41:42.343 GMT [2596][walsender] [sub5_2][26/0:0] LOG: received replication command: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:42.343 GMT [2596][walsender] [sub5_2][26/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:42.343 GMT [2596][walsender] [sub5_2][26/0:0] ERROR: replication slot "sub5_2" is active for PID 7924 2024-05-04 13:41:42.343 GMT [2596][walsender] [sub5_2][26/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:42.343 GMT [2596][walsender] [sub5_2][:0] LOG: disconnection: session time: 0:00:00.008 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:42.482 GMT [6000][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:42.483 GMT [6000][client backend] [[unknown]][0/13:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:42.483 GMT [6000][client backend] [[unknown]][0/13:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:42.486 GMT [6000][client backend] [010_truncate.pl][0/14:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:42.495 GMT [6000][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:42.749 GMT [5800][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:42.750 GMT [5800][client backend] [[unknown]][1/13:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:42.750 GMT [5800][client backend] [[unknown]][1/13:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:42.753 GMT [5800][client backend] [010_truncate.pl][1/14:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:42.760 GMT [5800][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:42.763 GMT [2168][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:42.764 GMT [2168][walsender] [[unknown]][22/10:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:42.764 GMT [2168][walsender] [[unknown]][22/10:0] LOG: replication connection authorized: user=SYSTEM application_name=sub5_2 2024-05-04 13:41:42.784 GMT [2168][walsender] [sub5_2][22/11:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:42.785 GMT [2168][walsender] [sub5_2][22/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-05-04 13:41:42.785 GMT [2168][walsender] [sub5_2][22/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-05-04 13:41:42.785 GMT [2168][walsender] [sub5_2][22/0:0] LOG: received replication command: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:42.785 GMT [2168][walsender] [sub5_2][22/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:42.785 GMT [2168][walsender] [sub5_2][22/0:0] ERROR: replication slot "sub5_2" is active for PID 7924 2024-05-04 13:41:42.785 GMT [2168][walsender] [sub5_2][22/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:42.785 GMT [2168][walsender] [sub5_2][:0] LOG: disconnection: session time: 0:00:00.025 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:42.950 GMT [1280][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:42.951 GMT [1280][client backend] [[unknown]][2/13:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:42.951 GMT [1280][client backend] [[unknown]][2/13:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:42.954 GMT [1280][client backend] [010_truncate.pl][2/14:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:42.963 GMT [1280][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:43.202 GMT [7492][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:43.203 GMT [7492][client backend] [[unknown]][3/13:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:43.203 GMT [7492][client backend] [[unknown]][3/13:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:43.206 GMT [7492][client backend] [010_truncate.pl][3/14:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:43.216 GMT [7492][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.018 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:43.331 GMT [5604][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:43.333 GMT [5604][walsender] [[unknown]][24/11:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:43.333 GMT [5604][walsender] [[unknown]][24/11:0] LOG: replication connection authorized: user=SYSTEM application_name=sub5_2 2024-05-04 13:41:43.337 GMT [5604][walsender] [sub5_2][24/12:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:43.337 GMT [5604][walsender] [sub5_2][24/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-05-04 13:41:43.337 GMT [5604][walsender] [sub5_2][24/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-05-04 13:41:43.338 GMT [5604][walsender] [sub5_2][24/0:0] LOG: received replication command: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:43.338 GMT [5604][walsender] [sub5_2][24/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:43.338 GMT [5604][walsender] [sub5_2][24/0:0] ERROR: replication slot "sub5_2" is active for PID 7924 2024-05-04 13:41:43.338 GMT [5604][walsender] [sub5_2][24/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:43.340 GMT [5604][walsender] [sub5_2][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:43.522 GMT [5652][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:43.523 GMT [5652][client backend] [[unknown]][4/13:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:43.523 GMT [5652][client backend] [[unknown]][4/13:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:43.527 GMT [5652][client backend] [010_truncate.pl][4/14:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:43.536 GMT [5652][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:43.808 GMT [4176][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:43.809 GMT [4176][client backend] [[unknown]][5/13:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:43.809 GMT [4176][client backend] [[unknown]][5/13:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:43.812 GMT [4176][client backend] [010_truncate.pl][5/14:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:43.819 GMT [4176][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:43.868 GMT [3624][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:43.876 GMT [3624][walsender] [[unknown]][27/10:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:43.876 GMT [3624][walsender] [[unknown]][27/10:0] LOG: replication connection authorized: user=SYSTEM application_name=sub5_2 2024-05-04 13:41:43.883 GMT [3624][walsender] [sub5_2][27/11:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:43.883 GMT [3624][walsender] [sub5_2][27/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-05-04 13:41:43.883 GMT [3624][walsender] [sub5_2][27/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-05-04 13:41:43.883 GMT [3624][walsender] [sub5_2][27/0:0] LOG: received replication command: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:43.883 GMT [3624][walsender] [sub5_2][27/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:43.883 GMT [3624][walsender] [sub5_2][27/0:0] ERROR: replication slot "sub5_2" is active for PID 7924 2024-05-04 13:41:43.883 GMT [3624][walsender] [sub5_2][27/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:43.884 GMT [3624][walsender] [sub5_2][:0] LOG: disconnection: session time: 0:00:00.021 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:44.090 GMT [4792][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:44.092 GMT [4792][client backend] [[unknown]][6/13:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:44.092 GMT [4792][client backend] [[unknown]][6/13:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:44.105 GMT [4792][client backend] [010_truncate.pl][6/14:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:44.126 GMT [4792][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.039 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:44.468 GMT [4944][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:44.470 GMT [4944][walsender] [[unknown]][28/12:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:44.470 GMT [4944][walsender] [[unknown]][28/12:0] LOG: replication connection authorized: user=SYSTEM application_name=sub5_2 2024-05-04 13:41:44.472 GMT [4944][walsender] [sub5_2][28/13:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:44.473 GMT [4944][walsender] [sub5_2][28/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-05-04 13:41:44.473 GMT [4944][walsender] [sub5_2][28/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-05-04 13:41:44.473 GMT [4944][walsender] [sub5_2][28/0:0] LOG: received replication command: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:44.473 GMT [4944][walsender] [sub5_2][28/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:44.473 GMT [4944][walsender] [sub5_2][28/0:0] ERROR: replication slot "sub5_2" is active for PID 7924 2024-05-04 13:41:44.473 GMT [4944][walsender] [sub5_2][28/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:44.474 GMT [4944][walsender] [sub5_2][:0] LOG: disconnection: session time: 0:00:00.008 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:44.484 GMT [7944][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:44.486 GMT [7944][client backend] [[unknown]][7/13:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:44.486 GMT [7944][client backend] [[unknown]][7/13:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:44.488 GMT [7944][client backend] [010_truncate.pl][7/14:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:44.496 GMT [7944][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:44.746 GMT [1060][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:44.747 GMT [1060][client backend] [[unknown]][8/13:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:44.747 GMT [1060][client backend] [[unknown]][8/13:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:44.750 GMT [1060][client backend] [010_truncate.pl][8/14:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:44.758 GMT [1060][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:44.832 GMT [6708][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:44.833 GMT [6708][walsender] [[unknown]][31/10:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:44.833 GMT [6708][walsender] [[unknown]][31/10:0] LOG: replication connection authorized: user=SYSTEM application_name=sub5_2 2024-05-04 13:41:44.835 GMT [6708][walsender] [sub5_2][31/11:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:44.836 GMT [6708][walsender] [sub5_2][31/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-05-04 13:41:44.836 GMT [6708][walsender] [sub5_2][31/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-05-04 13:41:44.836 GMT [6708][walsender] [sub5_2][31/0:0] LOG: received replication command: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:44.836 GMT [6708][walsender] [sub5_2][31/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:44.836 GMT [6708][walsender] [sub5_2][31/0:0] ERROR: replication slot "sub5_2" is active for PID 7924 2024-05-04 13:41:44.836 GMT [6708][walsender] [sub5_2][31/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:44.837 GMT [6708][walsender] [sub5_2][:0] LOG: disconnection: session time: 0:00:00.008 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:45.035 GMT [6916][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:45.036 GMT [6916][client backend] [[unknown]][9/13:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:45.036 GMT [6916][client backend] [[unknown]][9/13:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:45.039 GMT [6916][client backend] [010_truncate.pl][9/14:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:45.047 GMT [6916][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:45.306 GMT [3952][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:45.307 GMT [3952][client backend] [[unknown]][0/15:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:45.307 GMT [3952][client backend] [[unknown]][0/15:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:45.310 GMT [3952][client backend] [010_truncate.pl][0/16:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:45.318 GMT [3952][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:45.401 GMT [7796][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:45.403 GMT [7796][walsender] [[unknown]][26/16:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:45.403 GMT [7796][walsender] [[unknown]][26/16:0] LOG: replication connection authorized: user=SYSTEM application_name=sub5_2 2024-05-04 13:41:45.405 GMT [7796][walsender] [sub5_2][26/17:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:45.406 GMT [7796][walsender] [sub5_2][26/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-05-04 13:41:45.406 GMT [7796][walsender] [sub5_2][26/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-05-04 13:41:45.406 GMT [7796][walsender] [sub5_2][26/0:0] LOG: received replication command: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:45.406 GMT [7796][walsender] [sub5_2][26/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:45.406 GMT [7796][walsender] [sub5_2][26/0:0] ERROR: replication slot "sub5_2" is active for PID 7924 2024-05-04 13:41:45.406 GMT [7796][walsender] [sub5_2][26/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:45.406 GMT [7796][walsender] [sub5_2][:0] LOG: disconnection: session time: 0:00:00.036 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:45.587 GMT [5124][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:45.589 GMT [5124][client backend] [[unknown]][1/15:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:45.589 GMT [5124][client backend] [[unknown]][1/15:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:45.592 GMT [5124][client backend] [010_truncate.pl][1/16:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:45.599 GMT [5124][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:45.809 GMT [6604][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:45.811 GMT [6604][client backend] [[unknown]][2/15:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:45.811 GMT [6604][client backend] [[unknown]][2/15:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:45.814 GMT [6604][client backend] [010_truncate.pl][2/16:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:45.821 GMT [6604][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:45.911 GMT [5660][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:45.913 GMT [5660][walsender] [[unknown]][22/13:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:45.913 GMT [5660][walsender] [[unknown]][22/13:0] LOG: replication connection authorized: user=SYSTEM application_name=sub5_2 2024-05-04 13:41:45.916 GMT [5660][walsender] [sub5_2][22/14:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:45.916 GMT [5660][walsender] [sub5_2][22/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-05-04 13:41:45.916 GMT [5660][walsender] [sub5_2][22/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-05-04 13:41:45.916 GMT [5660][walsender] [sub5_2][22/0:0] LOG: received replication command: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:45.916 GMT [5660][walsender] [sub5_2][22/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:45.917 GMT [5660][walsender] [sub5_2][22/0:0] ERROR: replication slot "sub5_2" is active for PID 7924 2024-05-04 13:41:45.917 GMT [5660][walsender] [sub5_2][22/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:45.917 GMT [5660][walsender] [sub5_2][:0] LOG: disconnection: session time: 0:00:00.037 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:46.059 GMT [2148][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:46.061 GMT [2148][client backend] [[unknown]][3/15:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:46.061 GMT [2148][client backend] [[unknown]][3/15:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:46.065 GMT [2148][client backend] [010_truncate.pl][3/16:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:46.077 GMT [2148][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:46.309 GMT [4300][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:46.310 GMT [4300][client backend] [[unknown]][4/15:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:46.310 GMT [4300][client backend] [[unknown]][4/15:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:46.313 GMT [4300][client backend] [010_truncate.pl][4/16:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:46.321 GMT [4300][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:46.379 GMT [3112][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:46.380 GMT [3112][walsender] [[unknown]][24/14:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:46.380 GMT [3112][walsender] [[unknown]][24/14:0] LOG: replication connection authorized: user=SYSTEM application_name=sub5_2 2024-05-04 13:41:46.383 GMT [3112][walsender] [sub5_2][24/15:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:46.384 GMT [3112][walsender] [sub5_2][24/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-05-04 13:41:46.384 GMT [3112][walsender] [sub5_2][24/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-05-04 13:41:46.384 GMT [3112][walsender] [sub5_2][24/0:0] LOG: received replication command: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:46.384 GMT [3112][walsender] [sub5_2][24/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:46.384 GMT [3112][walsender] [sub5_2][24/0:0] ERROR: replication slot "sub5_2" is active for PID 7924 2024-05-04 13:41:46.384 GMT [3112][walsender] [sub5_2][24/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:46.384 GMT [3112][walsender] [sub5_2][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:46.625 GMT [7944][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:46.627 GMT [7944][client backend] [[unknown]][5/15:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:46.627 GMT [7944][client backend] [[unknown]][5/15:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:46.631 GMT [7944][client backend] [010_truncate.pl][5/16:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:46.660 GMT [7944][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.038 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:46.881 GMT [6344][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:46.882 GMT [6344][walsender] [[unknown]][27/13:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:46.882 GMT [6344][walsender] [[unknown]][27/13:0] LOG: replication connection authorized: user=SYSTEM application_name=sub5_2 2024-05-04 13:41:46.900 GMT [6344][walsender] [sub5_2][27/14:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:46.900 GMT [6344][walsender] [sub5_2][27/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-05-04 13:41:46.900 GMT [6344][walsender] [sub5_2][27/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-05-04 13:41:46.901 GMT [6344][walsender] [sub5_2][27/0:0] LOG: received replication command: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:46.901 GMT [6344][walsender] [sub5_2][27/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:46.901 GMT [6344][walsender] [sub5_2][27/0:0] ERROR: replication slot "sub5_2" is active for PID 7924 2024-05-04 13:41:46.901 GMT [6344][walsender] [sub5_2][27/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:46.901 GMT [6344][walsender] [sub5_2][:0] LOG: disconnection: session time: 0:00:00.023 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:46.924 GMT [4188][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:46.925 GMT [4188][client backend] [[unknown]][6/15:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:46.925 GMT [4188][client backend] [[unknown]][6/15:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:46.928 GMT [4188][client backend] [010_truncate.pl][6/16:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:46.934 GMT [4188][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:47.191 GMT [2968][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:47.193 GMT [2968][client backend] [[unknown]][7/15:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:47.193 GMT [2968][client backend] [[unknown]][7/15:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:47.196 GMT [2968][client backend] [010_truncate.pl][7/16:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:47.206 GMT [2968][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:47.448 GMT [500][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:47.450 GMT [500][client backend] [[unknown]][8/15:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:47.450 GMT [500][client backend] [[unknown]][8/15:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:47.464 GMT [4704][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:47.465 GMT [4704][walsender] [[unknown]][28/15:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:47.465 GMT [4704][walsender] [[unknown]][28/15:0] LOG: replication connection authorized: user=SYSTEM application_name=sub5_2 2024-05-04 13:41:47.471 GMT [500][client backend] [010_truncate.pl][8/16:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:47.478 GMT [4704][walsender] [sub5_2][28/16:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:47.478 GMT [4704][walsender] [sub5_2][28/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-05-04 13:41:47.478 GMT [4704][walsender] [sub5_2][28/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-05-04 13:41:47.478 GMT [4704][walsender] [sub5_2][28/0:0] LOG: received replication command: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:47.478 GMT [4704][walsender] [sub5_2][28/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:47.478 GMT [4704][walsender] [sub5_2][28/0:0] ERROR: replication slot "sub5_2" is active for PID 7924 2024-05-04 13:41:47.478 GMT [4704][walsender] [sub5_2][28/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:47.479 GMT [4704][walsender] [sub5_2][:0] LOG: disconnection: session time: 0:00:00.018 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:47.481 GMT [500][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.035 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:48.070 GMT [7776][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:48.071 GMT [7776][walsender] [[unknown]][31/13:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:48.071 GMT [7776][walsender] [[unknown]][31/13:0] LOG: replication connection authorized: user=SYSTEM application_name=sub5_2 2024-05-04 13:41:48.075 GMT [7776][walsender] [sub5_2][31/14:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:48.075 GMT [7776][walsender] [sub5_2][31/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-05-04 13:41:48.075 GMT [7776][walsender] [sub5_2][31/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-05-04 13:41:48.075 GMT [7776][walsender] [sub5_2][31/0:0] LOG: received replication command: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:48.075 GMT [7776][walsender] [sub5_2][31/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:48.075 GMT [7776][walsender] [sub5_2][31/0:0] ERROR: replication slot "sub5_2" is active for PID 7924 2024-05-04 13:41:48.075 GMT [7776][walsender] [sub5_2][31/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:48.076 GMT [7776][walsender] [sub5_2][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:48.097 GMT [4112][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:48.099 GMT [4112][client backend] [[unknown]][9/15:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:48.099 GMT [4112][client backend] [[unknown]][9/15:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:48.126 GMT [4112][client backend] [010_truncate.pl][9/16:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:48.182 GMT [4112][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.087 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:48.548 GMT [4624][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:48.550 GMT [4624][walsender] [[unknown]][26/19:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:48.550 GMT [4624][walsender] [[unknown]][26/19:0] LOG: replication connection authorized: user=SYSTEM application_name=sub5_2 2024-05-04 13:41:48.553 GMT [4624][walsender] [sub5_2][26/20:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:48.553 GMT [4624][walsender] [sub5_2][26/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-05-04 13:41:48.553 GMT [4624][walsender] [sub5_2][26/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-05-04 13:41:48.554 GMT [4624][walsender] [sub5_2][26/0:0] LOG: received replication command: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:48.554 GMT [4624][walsender] [sub5_2][26/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:48.554 GMT [4624][walsender] [sub5_2][26/0:0] ERROR: replication slot "sub5_2" is active for PID 7924 2024-05-04 13:41:48.554 GMT [4624][walsender] [sub5_2][26/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:48.554 GMT [4624][walsender] [sub5_2][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:48.601 GMT [4188][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:48.603 GMT [4188][client backend] [[unknown]][0/17:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:48.603 GMT [4188][client backend] [[unknown]][0/17:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:48.606 GMT [4188][client backend] [010_truncate.pl][0/18:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:48.614 GMT [4188][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:48.851 GMT [7596][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:48.853 GMT [7596][client backend] [[unknown]][1/17:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:48.853 GMT [7596][client backend] [[unknown]][1/17:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:48.871 GMT [7596][client backend] [010_truncate.pl][1/18:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:48.877 GMT [7596][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.029 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:49.014 GMT [7356][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:49.016 GMT [7356][walsender] [[unknown]][22/16:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:49.016 GMT [7356][walsender] [[unknown]][22/16:0] LOG: replication connection authorized: user=SYSTEM application_name=sub5_2 2024-05-04 13:41:49.018 GMT [7356][walsender] [sub5_2][22/17:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-05-04 13:41:49.019 GMT [7356][walsender] [sub5_2][22/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-05-04 13:41:49.019 GMT [7356][walsender] [sub5_2][22/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-05-04 13:41:49.019 GMT [7356][walsender] [sub5_2][22/0:0] LOG: received replication command: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:49.019 GMT [7356][walsender] [sub5_2][22/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:49.019 GMT [7356][walsender] [sub5_2][22/0:0] ERROR: replication slot "sub5_2" is active for PID 7924 2024-05-04 13:41:49.019 GMT [7356][walsender] [sub5_2][22/0:0] STATEMENT: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:49.019 GMT [7356][walsender] [sub5_2][:0] LOG: disconnection: session time: 0:00:00.008 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:49.159 GMT [3140][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-04 13:41:49.160 GMT [3140][client backend] [[unknown]][2/17:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/010_truncate/data/t_010_truncate_publisher_data/pgdata/pg_hba.conf:117) 2024-05-04 13:41:49.161 GMT [3140][client backend] [[unknown]][2/17:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=010_truncate.pl 2024-05-04 13:41:49.163 GMT [3140][client backend] [010_truncate.pl][2/18:0] LOG: statement: SELECT '0/1538428' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub5_2', 'walreceiver') 2024-05-04 13:41:49.173 GMT [3140][client backend] [010_truncate.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2024-05-04 13:41:49.222 GMT [7092][postmaster] LOG: server process (PID 7924) was terminated by exception 0xC0000354 2024-05-04 13:41:49.222 GMT [7092][postmaster] DETAIL: Failed process was running: START_REPLICATION SLOT "sub5_2" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub5"') 2024-05-04 13:41:49.222 GMT [7092][postmaster] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2024-05-04 13:41:49.222 GMT [7092][postmaster] LOG: terminating any other active server processes 2024-05-04 13:41:49.323 GMT [7092][postmaster] LOG: shutting down because restart_after_crash is off 2024-05-04 13:41:49.324 GMT [7092][postmaster] LOG: database system is shut down