2024-11-25 11:06:27.325 GMT [4328][postmaster] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30157, 64-bit 2024-11-25 11:06:27.326 GMT [4328][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/5ARE7R3B5J/.s.PGSQL.24445" 2024-11-25 11:06:27.357 GMT [6364][startup] LOG: database system was shut down at 2024-11-25 10:57:48 GMT 2024-11-25 11:06:27.385 GMT [4328][postmaster] LOG: database system is ready to accept connections 2024-11-25 11:06:31.385 GMT [5208][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:31.387 GMT [5208][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:31.387 GMT [5208][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:31.402 GMT [5208][client backend] [013_partition.pl][0/2:0] LOG: statement: CREATE PUBLICATION pub1 2024-11-25 11:06:31.405 GMT [5208][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.023 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:31.538 GMT [6636][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:31.540 GMT [6636][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:31.540 GMT [6636][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:31.543 GMT [6636][client backend] [013_partition.pl][1/2:0] LOG: statement: CREATE PUBLICATION pub_all FOR ALL TABLES 2024-11-25 11:06:31.545 GMT [6636][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:31.687 GMT [4828][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:31.688 GMT [4828][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:31.688 GMT [4828][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:31.701 GMT [4828][client backend] [013_partition.pl][2/2:0] LOG: statement: CREATE TABLE tab1 (a int PRIMARY KEY, b text) PARTITION BY LIST (a) 2024-11-25 11:06:31.711 GMT [4828][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.027 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:31.844 GMT [5520][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:31.846 GMT [5520][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:31.846 GMT [5520][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:31.850 GMT [5520][client backend] [013_partition.pl][3/2:0] LOG: statement: CREATE TABLE tab1_1 (b text, a int NOT NULL) 2024-11-25 11:06:31.859 GMT [5520][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.018 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:31.980 GMT [4200][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:31.982 GMT [4200][client backend] [[unknown]][4/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:31.982 GMT [4200][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:32.002 GMT [4200][client backend] [013_partition.pl][4/2:0] LOG: statement: ALTER TABLE tab1 ATTACH PARTITION tab1_1 FOR VALUES IN (1, 2, 3) 2024-11-25 11:06:32.023 GMT [4200][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.057 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:32.141 GMT [6076][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:32.143 GMT [6076][client backend] [[unknown]][5/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:32.143 GMT [6076][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:32.148 GMT [6076][client backend] [013_partition.pl][5/2:0] LOG: statement: CREATE TABLE tab1_2 PARTITION OF tab1 FOR VALUES IN (4, 5, 6) 2024-11-25 11:06:32.164 GMT [6076][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.032 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:32.271 GMT [1324][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:32.272 GMT [1324][client backend] [[unknown]][6/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:32.272 GMT [1324][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:32.276 GMT [1324][client backend] [013_partition.pl][6/2:0] LOG: statement: CREATE TABLE tab1_def PARTITION OF tab1 DEFAULT 2024-11-25 11:06:32.288 GMT [1324][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.020 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:32.375 GMT [4464][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:32.381 GMT [4464][client backend] [[unknown]][7/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:32.381 GMT [4464][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:32.392 GMT [4464][client backend] [013_partition.pl][7/2:0] LOG: statement: ALTER PUBLICATION pub1 ADD TABLE tab1, tab1_1 2024-11-25 11:06:32.413 GMT [4464][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.041 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:33.582 GMT [4648][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:33.583 GMT [4648][walsender] [[unknown]][22/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:33.583 GMT [4648][walsender] [[unknown]][22/1:0] LOG: replication connection authorized: user=SYSTEM application_name=sub1 2024-11-25 11:06:33.586 GMT [4648][walsender] [sub1][22/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:33.587 GMT [4648][walsender] [sub1][22/3:0] LOG: statement: SELECT t.pubname FROM pg_catalog.pg_publication t WHERE t.pubname IN ('pub1') 2024-11-25 11:06:33.590 GMT [4648][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-11-25 11:06:33.600 GMT [4648][walsender] [sub1][22/0:0] LOG: received replication command: CREATE_REPLICATION_SLOT "sub1" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-25 11:06:33.600 GMT [4648][walsender] [sub1][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub1" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-25 11:06:33.603 GMT [4648][walsender] [sub1][22/0:0] LOG: logical decoding found consistent point at 0/17A7A78 2024-11-25 11:06:33.603 GMT [4648][walsender] [sub1][22/0:0] DETAIL: There are no running transactions. 2024-11-25 11:06:33.603 GMT [4648][walsender] [sub1][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub1" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-25 11:06:33.603 GMT [4648][walsender] [sub1][22/0:0] LOG: released logical replication slot "sub1" 2024-11-25 11:06:33.603 GMT [4648][walsender] [sub1][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub1" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-25 11:06:33.604 GMT [4648][walsender] [sub1][:0] LOG: disconnection: session time: 0:00:00.025 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:33.653 GMT [7124][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:33.657 GMT [7124][walsender] [[unknown]][23/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:33.657 GMT [7124][walsender] [[unknown]][23/1:0] LOG: replication connection authorized: user=SYSTEM application_name=sub1 2024-11-25 11:06:33.662 GMT [7124][walsender] [sub1][23/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:33.663 GMT [7124][walsender] [sub1][23/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-25 11:06:33.663 GMT [7124][walsender] [sub1][23/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-25 11:06:33.663 GMT [7124][walsender] [sub1][23/0:0] LOG: received replication command: START_REPLICATION SLOT "sub1" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:33.663 GMT [7124][walsender] [sub1][23/0:0] STATEMENT: START_REPLICATION SLOT "sub1" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:33.663 GMT [7124][walsender] [sub1][23/0:0] LOG: acquired logical replication slot "sub1" 2024-11-25 11:06:33.663 GMT [7124][walsender] [sub1][23/0:0] STATEMENT: START_REPLICATION SLOT "sub1" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:33.664 GMT [7124][walsender] [sub1][23/0:0] LOG: starting logical decoding for slot "sub1" 2024-11-25 11:06:33.664 GMT [7124][walsender] [sub1][23/0:0] DETAIL: Streaming transactions committing after 0/17A7AB0, reading WAL from 0/17A7A78. 2024-11-25 11:06:33.664 GMT [7124][walsender] [sub1][23/0:0] STATEMENT: START_REPLICATION SLOT "sub1" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:33.664 GMT [7124][walsender] [sub1][23/0:0] LOG: logical decoding found consistent point at 0/17A7A78 2024-11-25 11:06:33.664 GMT [7124][walsender] [sub1][23/0:0] DETAIL: There are no running transactions. 2024-11-25 11:06:33.664 GMT [7124][walsender] [sub1][23/0:0] STATEMENT: START_REPLICATION SLOT "sub1" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:33.719 GMT [5264][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:33.720 GMT [5264][walsender] [[unknown]][24/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:33.720 GMT [5264][walsender] [[unknown]][24/1:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16432_sync_16423_7441169425071779680 2024-11-25 11:06:33.723 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:33.724 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/3:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-11-25 11:06:33.724 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/3:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16432_sync_16423_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:33.724 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16432_sync_16423_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:33.727 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/3:0] LOG: logical decoding found consistent point at 0/17A7AB0 2024-11-25 11:06:33.727 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/3:0] DETAIL: There are no running transactions. 2024-11-25 11:06:33.727 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16432_sync_16423_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:33.728 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/3:0] LOG: released logical replication slot "pg_16432_sync_16423_7441169425071779680" 2024-11-25 11:06:33.728 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16432_sync_16423_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:33.729 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][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_def' 2024-11-25 11:06:33.734 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][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 = 16408 AND c.oid = gpt.relid AND p.pubname IN ( 'pub1' ) 2024-11-25 11:06:33.739 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/3:0] LOG: statement: SELECT a.attnum, a.attname, a.atttypid, a.attnum = ANY(i.indkey), a.attgenerated != '' FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_index i ON (i.indexrelid = pg_get_replica_identity_index(16408)) WHERE a.attnum > 0::pg_catalog.int2 AND NOT a.attisdropped AND a.attrelid = 16408 ORDER BY a.attnum 2024-11-25 11:06:33.741 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][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 = 16408 AND p.pubname IN ( 'pub1' ) 2024-11-25 11:06:33.743 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/3:0] LOG: statement: COPY public.tab1_def (a, b) TO STDOUT 2024-11-25 11:06:33.743 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/3:0] LOG: statement: COMMIT 2024-11-25 11:06:33.782 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/0:0] LOG: received replication command: START_REPLICATION SLOT "pg_16432_sync_16423_7441169425071779680" LOGICAL 0/17A7AE8 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:33.782 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/0:0] STATEMENT: START_REPLICATION SLOT "pg_16432_sync_16423_7441169425071779680" LOGICAL 0/17A7AE8 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:33.782 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/0:0] LOG: acquired logical replication slot "pg_16432_sync_16423_7441169425071779680" 2024-11-25 11:06:33.782 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/0:0] STATEMENT: START_REPLICATION SLOT "pg_16432_sync_16423_7441169425071779680" LOGICAL 0/17A7AE8 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:33.782 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/0:0] LOG: starting logical decoding for slot "pg_16432_sync_16423_7441169425071779680" 2024-11-25 11:06:33.782 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/0:0] DETAIL: Streaming transactions committing after 0/17A7AE8, reading WAL from 0/17A7AB0. 2024-11-25 11:06:33.782 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/0:0] STATEMENT: START_REPLICATION SLOT "pg_16432_sync_16423_7441169425071779680" LOGICAL 0/17A7AE8 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:33.782 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/0:0] LOG: logical decoding found consistent point at 0/17A7AB0 2024-11-25 11:06:33.782 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/0:0] DETAIL: There are no running transactions. 2024-11-25 11:06:33.782 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/0:0] STATEMENT: START_REPLICATION SLOT "pg_16432_sync_16423_7441169425071779680" LOGICAL 0/17A7AE8 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:33.783 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/0:0] LOG: released logical replication slot "pg_16432_sync_16423_7441169425071779680" 2024-11-25 11:06:33.783 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/0:0] STATEMENT: START_REPLICATION SLOT "pg_16432_sync_16423_7441169425071779680" LOGICAL 0/17A7AE8 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:33.783 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16432_sync_16423_7441169425071779680 WAIT 2024-11-25 11:06:33.783 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16432_sync_16423_7441169425071779680 WAIT 2024-11-25 11:06:33.783 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/0:0] LOG: acquired logical replication slot "pg_16432_sync_16423_7441169425071779680" 2024-11-25 11:06:33.783 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][24/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16432_sync_16423_7441169425071779680 WAIT 2024-11-25 11:06:33.784 GMT [5264][walsender] [pg_16432_sync_16423_7441169425071779680][:0] LOG: disconnection: session time: 0:00:00.068 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:33.810 GMT [4324][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:33.815 GMT [4324][walsender] [[unknown]][25/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:33.815 GMT [4324][walsender] [[unknown]][25/1:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16432_sync_16399_7441169425071779680 2024-11-25 11:06:33.822 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:33.835 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/3:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-11-25 11:06:33.836 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/3:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16432_sync_16399_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:33.836 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16432_sync_16399_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:33.880 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/3:0] LOG: logical decoding found consistent point at 0/17A7AE8 2024-11-25 11:06:33.880 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/3:0] DETAIL: There are no running transactions. 2024-11-25 11:06:33.880 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16432_sync_16399_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:33.885 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/3:0] LOG: released logical replication slot "pg_16432_sync_16399_7441169425071779680" 2024-11-25 11:06:33.885 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16432_sync_16399_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:33.886 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/3:0] LOG: statement: SELECT c.oid, c.relreplident, c.relkind FROM pg_catalog.pg_class c INNER JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) WHERE n.nspname = 'public' AND c.relname = 'tab1_2' 2024-11-25 11:06:33.891 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/3:0] LOG: statement: SELECT DISTINCT (CASE WHEN (array_length(gpt.attrs, 1) = c.relnatts) THEN NULL ELSE gpt.attrs END) FROM pg_publication p, LATERAL pg_get_publication_tables(p.pubname) gpt, pg_class c WHERE gpt.relid = 16400 AND c.oid = gpt.relid AND p.pubname IN ( 'pub1' ) 2024-11-25 11:06:33.914 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/3:0] LOG: statement: SELECT a.attnum, a.attname, a.atttypid, a.attnum = ANY(i.indkey), a.attgenerated != '' FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_index i ON (i.indexrelid = pg_get_replica_identity_index(16400)) WHERE a.attnum > 0::pg_catalog.int2 AND NOT a.attisdropped AND a.attrelid = 16400 ORDER BY a.attnum 2024-11-25 11:06:33.916 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/3:0] LOG: statement: SELECT DISTINCT pg_get_expr(gpt.qual, gpt.relid) FROM pg_publication p, LATERAL pg_get_publication_tables(p.pubname) gpt WHERE gpt.relid = 16400 AND p.pubname IN ( 'pub1' ) 2024-11-25 11:06:33.918 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/3:0] LOG: statement: COPY public.tab1_2 (a, b) TO STDOUT 2024-11-25 11:06:33.919 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/3:0] LOG: statement: COMMIT 2024-11-25 11:06:33.919 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/0:0] LOG: received replication command: START_REPLICATION SLOT "pg_16432_sync_16399_7441169425071779680" LOGICAL 0/17A7B20 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:33.919 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/0:0] STATEMENT: START_REPLICATION SLOT "pg_16432_sync_16399_7441169425071779680" LOGICAL 0/17A7B20 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:33.919 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/0:0] LOG: acquired logical replication slot "pg_16432_sync_16399_7441169425071779680" 2024-11-25 11:06:33.919 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/0:0] STATEMENT: START_REPLICATION SLOT "pg_16432_sync_16399_7441169425071779680" LOGICAL 0/17A7B20 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:33.919 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/0:0] LOG: starting logical decoding for slot "pg_16432_sync_16399_7441169425071779680" 2024-11-25 11:06:33.919 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/0:0] DETAIL: Streaming transactions committing after 0/17A7B20, reading WAL from 0/17A7AE8. 2024-11-25 11:06:33.919 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/0:0] STATEMENT: START_REPLICATION SLOT "pg_16432_sync_16399_7441169425071779680" LOGICAL 0/17A7B20 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:33.920 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/0:0] LOG: released logical replication slot "pg_16432_sync_16399_7441169425071779680" 2024-11-25 11:06:33.920 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/0:0] STATEMENT: START_REPLICATION SLOT "pg_16432_sync_16399_7441169425071779680" LOGICAL 0/17A7B20 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:33.920 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16432_sync_16399_7441169425071779680 WAIT 2024-11-25 11:06:33.920 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16432_sync_16399_7441169425071779680 WAIT 2024-11-25 11:06:33.920 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/0:0] LOG: acquired logical replication slot "pg_16432_sync_16399_7441169425071779680" 2024-11-25 11:06:33.920 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][25/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16432_sync_16399_7441169425071779680 WAIT 2024-11-25 11:06:33.922 GMT [4324][walsender] [pg_16432_sync_16399_7441169425071779680][:0] LOG: disconnection: session time: 0:00:00.114 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:33.929 GMT [2168][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:33.930 GMT [2168][walsender] [[unknown]][26/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:33.930 GMT [2168][walsender] [[unknown]][26/1:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16432_sync_16390_7441169425071779680 2024-11-25 11:06:33.934 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:33.935 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/3:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-11-25 11:06:33.935 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/3:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16432_sync_16390_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:33.935 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16432_sync_16390_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:33.964 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/3:0] LOG: logical decoding found consistent point at 0/17A7B20 2024-11-25 11:06:33.964 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/3:0] DETAIL: There are no running transactions. 2024-11-25 11:06:33.964 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16432_sync_16390_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:33.968 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/3:0] LOG: released logical replication slot "pg_16432_sync_16390_7441169425071779680" 2024-11-25 11:06:33.968 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16432_sync_16390_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:33.969 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/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_1' 2024-11-25 11:06:33.973 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/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 = 16392 AND c.oid = gpt.relid AND p.pubname IN ( 'pub1' ) 2024-11-25 11:06:33.986 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/3:0] LOG: statement: SELECT a.attnum, a.attname, a.atttypid, a.attnum = ANY(i.indkey), a.attgenerated != '' FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_index i ON (i.indexrelid = pg_get_replica_identity_index(16392)) WHERE a.attnum > 0::pg_catalog.int2 AND NOT a.attisdropped AND a.attrelid = 16392 ORDER BY a.attnum 2024-11-25 11:06:33.990 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/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 = 16392 AND p.pubname IN ( 'pub1' ) 2024-11-25 11:06:33.992 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/3:0] LOG: statement: COPY public.tab1_1 (b, a) TO STDOUT 2024-11-25 11:06:33.992 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/3:0] LOG: statement: COMMIT 2024-11-25 11:06:33.993 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/0:0] LOG: received replication command: START_REPLICATION SLOT "pg_16432_sync_16390_7441169425071779680" LOGICAL 0/17A7B58 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:33.993 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/0:0] STATEMENT: START_REPLICATION SLOT "pg_16432_sync_16390_7441169425071779680" LOGICAL 0/17A7B58 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:33.993 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/0:0] LOG: acquired logical replication slot "pg_16432_sync_16390_7441169425071779680" 2024-11-25 11:06:33.993 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/0:0] STATEMENT: START_REPLICATION SLOT "pg_16432_sync_16390_7441169425071779680" LOGICAL 0/17A7B58 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:33.993 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/0:0] LOG: starting logical decoding for slot "pg_16432_sync_16390_7441169425071779680" 2024-11-25 11:06:33.993 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/0:0] DETAIL: Streaming transactions committing after 0/17A7B58, reading WAL from 0/17A7B20. 2024-11-25 11:06:33.993 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/0:0] STATEMENT: START_REPLICATION SLOT "pg_16432_sync_16390_7441169425071779680" LOGICAL 0/17A7B58 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:33.993 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/0:0] LOG: logical decoding found consistent point at 0/17A7B20 2024-11-25 11:06:33.993 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/0:0] DETAIL: There are no running transactions. 2024-11-25 11:06:33.993 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/0:0] STATEMENT: START_REPLICATION SLOT "pg_16432_sync_16390_7441169425071779680" LOGICAL 0/17A7B58 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:33.994 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/0:0] LOG: released logical replication slot "pg_16432_sync_16390_7441169425071779680" 2024-11-25 11:06:33.994 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/0:0] STATEMENT: START_REPLICATION SLOT "pg_16432_sync_16390_7441169425071779680" LOGICAL 0/17A7B58 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:33.994 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16432_sync_16390_7441169425071779680 WAIT 2024-11-25 11:06:33.994 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16432_sync_16390_7441169425071779680 WAIT 2024-11-25 11:06:33.994 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/0:0] LOG: acquired logical replication slot "pg_16432_sync_16390_7441169425071779680" 2024-11-25 11:06:33.994 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][26/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16432_sync_16390_7441169425071779680 WAIT 2024-11-25 11:06:33.995 GMT [2168][walsender] [pg_16432_sync_16390_7441169425071779680][:0] LOG: disconnection: session time: 0:00:00.069 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:34.598 GMT [3424][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:34.601 GMT [3424][walsender] [[unknown]][27/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:34.601 GMT [3424][walsender] [[unknown]][27/1:0] LOG: replication connection authorized: user=SYSTEM application_name=sub2 2024-11-25 11:06:34.605 GMT [3424][walsender] [sub2][27/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:34.606 GMT [3424][walsender] [sub2][27/3:0] LOG: statement: SELECT t.pubname FROM pg_catalog.pg_publication t WHERE t.pubname IN ('pub_all') 2024-11-25 11:06:34.608 GMT [3424][walsender] [sub2][27/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 ( 'pub_all' )) AS gpt ON gpt.relid = c.oid 2024-11-25 11:06:34.616 GMT [3424][walsender] [sub2][27/0:0] LOG: received replication command: CREATE_REPLICATION_SLOT "sub2" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-25 11:06:34.616 GMT [3424][walsender] [sub2][27/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub2" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-25 11:06:34.619 GMT [3424][walsender] [sub2][27/0:0] LOG: logical decoding found consistent point at 0/17A7B58 2024-11-25 11:06:34.619 GMT [3424][walsender] [sub2][27/0:0] DETAIL: There are no running transactions. 2024-11-25 11:06:34.619 GMT [3424][walsender] [sub2][27/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub2" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-25 11:06:34.620 GMT [3424][walsender] [sub2][27/0:0] LOG: released logical replication slot "sub2" 2024-11-25 11:06:34.620 GMT [3424][walsender] [sub2][27/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub2" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-25 11:06:34.620 GMT [3424][walsender] [sub2][:0] LOG: disconnection: session time: 0:00:00.026 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:34.696 GMT [2380][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:34.697 GMT [2380][walsender] [[unknown]][28/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:34.697 GMT [2380][walsender] [[unknown]][28/1:0] LOG: replication connection authorized: user=SYSTEM application_name=sub2 2024-11-25 11:06:34.701 GMT [2380][walsender] [sub2][28/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:34.702 GMT [2380][walsender] [sub2][28/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-25 11:06:34.702 GMT [2380][walsender] [sub2][28/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-25 11:06:34.702 GMT [2380][walsender] [sub2][28/0:0] LOG: received replication command: START_REPLICATION SLOT "sub2" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:34.702 GMT [2380][walsender] [sub2][28/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:34.702 GMT [2380][walsender] [sub2][28/0:0] LOG: acquired logical replication slot "sub2" 2024-11-25 11:06:34.702 GMT [2380][walsender] [sub2][28/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:34.707 GMT [2380][walsender] [sub2][28/0:0] LOG: starting logical decoding for slot "sub2" 2024-11-25 11:06:34.707 GMT [2380][walsender] [sub2][28/0:0] DETAIL: Streaming transactions committing after 0/17A7B90, reading WAL from 0/17A7B58. 2024-11-25 11:06:34.707 GMT [2380][walsender] [sub2][28/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:34.707 GMT [2380][walsender] [sub2][28/0:0] LOG: logical decoding found consistent point at 0/17A7B58 2024-11-25 11:06:34.707 GMT [2380][walsender] [sub2][28/0:0] DETAIL: There are no running transactions. 2024-11-25 11:06:34.707 GMT [2380][walsender] [sub2][28/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:34.767 GMT [5756][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:34.768 GMT [5756][walsender] [[unknown]][29/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:34.768 GMT [5756][walsender] [[unknown]][29/1:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16420_sync_16411_7441169425071779680 2024-11-25 11:06:34.771 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:34.772 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/3:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-11-25 11:06:34.772 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/3:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16420_sync_16411_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:34.772 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16420_sync_16411_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:34.775 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/3:0] LOG: logical decoding found consistent point at 0/17A7B90 2024-11-25 11:06:34.775 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/3:0] DETAIL: There are no running transactions. 2024-11-25 11:06:34.775 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16420_sync_16411_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:34.776 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/3:0] LOG: released logical replication slot "pg_16420_sync_16411_7441169425071779680" 2024-11-25 11:06:34.776 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16420_sync_16411_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:34.776 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/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_def' 2024-11-25 11:06:34.780 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/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 = 16408 AND c.oid = gpt.relid AND p.pubname IN ( 'pub_all' ) 2024-11-25 11:06:34.784 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/3:0] LOG: statement: SELECT a.attnum, a.attname, a.atttypid, a.attnum = ANY(i.indkey), a.attgenerated != '' FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_index i ON (i.indexrelid = pg_get_replica_identity_index(16408)) WHERE a.attnum > 0::pg_catalog.int2 AND NOT a.attisdropped AND a.attrelid = 16408 ORDER BY a.attnum 2024-11-25 11:06:34.786 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/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 = 16408 AND p.pubname IN ( 'pub_all' ) 2024-11-25 11:06:34.788 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/3:0] LOG: statement: COPY public.tab1_def (a, b) TO STDOUT 2024-11-25 11:06:34.788 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/3:0] LOG: statement: COMMIT 2024-11-25 11:06:34.788 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/0:0] LOG: received replication command: START_REPLICATION SLOT "pg_16420_sync_16411_7441169425071779680" LOGICAL 0/17A7BC8 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:34.788 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16411_7441169425071779680" LOGICAL 0/17A7BC8 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:34.788 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/0:0] LOG: acquired logical replication slot "pg_16420_sync_16411_7441169425071779680" 2024-11-25 11:06:34.788 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16411_7441169425071779680" LOGICAL 0/17A7BC8 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:34.789 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/0:0] LOG: starting logical decoding for slot "pg_16420_sync_16411_7441169425071779680" 2024-11-25 11:06:34.789 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/0:0] DETAIL: Streaming transactions committing after 0/17A7BC8, reading WAL from 0/17A7B90. 2024-11-25 11:06:34.789 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16411_7441169425071779680" LOGICAL 0/17A7BC8 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:34.789 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/0:0] LOG: logical decoding found consistent point at 0/17A7B90 2024-11-25 11:06:34.789 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/0:0] DETAIL: There are no running transactions. 2024-11-25 11:06:34.789 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16411_7441169425071779680" LOGICAL 0/17A7BC8 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:34.789 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/0:0] LOG: released logical replication slot "pg_16420_sync_16411_7441169425071779680" 2024-11-25 11:06:34.789 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16411_7441169425071779680" LOGICAL 0/17A7BC8 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:34.789 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16420_sync_16411_7441169425071779680 WAIT 2024-11-25 11:06:34.789 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16420_sync_16411_7441169425071779680 WAIT 2024-11-25 11:06:34.789 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/0:0] LOG: acquired logical replication slot "pg_16420_sync_16411_7441169425071779680" 2024-11-25 11:06:34.789 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][29/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16420_sync_16411_7441169425071779680 WAIT 2024-11-25 11:06:34.790 GMT [5756][walsender] [pg_16420_sync_16411_7441169425071779680][:0] LOG: disconnection: session time: 0:00:00.026 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:34.795 GMT [3740][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:34.797 GMT [3740][walsender] [[unknown]][30/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:34.797 GMT [3740][walsender] [[unknown]][30/1:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16420_sync_16402_7441169425071779680 2024-11-25 11:06:34.800 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:34.801 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/3:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-11-25 11:06:34.802 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/3:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16420_sync_16402_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:34.802 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16420_sync_16402_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:34.804 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/3:0] LOG: logical decoding found consistent point at 0/17A7BC8 2024-11-25 11:06:34.804 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/3:0] DETAIL: There are no running transactions. 2024-11-25 11:06:34.804 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16420_sync_16402_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:34.805 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/3:0] LOG: released logical replication slot "pg_16420_sync_16402_7441169425071779680" 2024-11-25 11:06:34.805 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16420_sync_16402_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:34.806 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][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 = 'tab1_2' 2024-11-25 11:06:34.809 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][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 = 16400 AND c.oid = gpt.relid AND p.pubname IN ( 'pub_all' ) 2024-11-25 11:06:34.813 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/3:0] LOG: statement: SELECT a.attnum, a.attname, a.atttypid, a.attnum = ANY(i.indkey), a.attgenerated != '' FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_index i ON (i.indexrelid = pg_get_replica_identity_index(16400)) WHERE a.attnum > 0::pg_catalog.int2 AND NOT a.attisdropped AND a.attrelid = 16400 ORDER BY a.attnum 2024-11-25 11:06:34.815 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][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 = 16400 AND p.pubname IN ( 'pub_all' ) 2024-11-25 11:06:34.816 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/3:0] LOG: statement: COPY public.tab1_2 (a, b) TO STDOUT 2024-11-25 11:06:34.817 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/3:0] LOG: statement: COMMIT 2024-11-25 11:06:34.844 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/0:0] LOG: received replication command: START_REPLICATION SLOT "pg_16420_sync_16402_7441169425071779680" LOGICAL 0/17A7C00 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:34.844 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16402_7441169425071779680" LOGICAL 0/17A7C00 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:34.844 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/0:0] LOG: acquired logical replication slot "pg_16420_sync_16402_7441169425071779680" 2024-11-25 11:06:34.844 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16402_7441169425071779680" LOGICAL 0/17A7C00 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:34.844 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/0:0] LOG: starting logical decoding for slot "pg_16420_sync_16402_7441169425071779680" 2024-11-25 11:06:34.844 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/0:0] DETAIL: Streaming transactions committing after 0/17A7C00, reading WAL from 0/17A7BC8. 2024-11-25 11:06:34.844 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16402_7441169425071779680" LOGICAL 0/17A7C00 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:34.845 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/0:0] LOG: logical decoding found consistent point at 0/17A7BC8 2024-11-25 11:06:34.845 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/0:0] DETAIL: There are no running transactions. 2024-11-25 11:06:34.845 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16402_7441169425071779680" LOGICAL 0/17A7C00 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:34.845 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/0:0] LOG: released logical replication slot "pg_16420_sync_16402_7441169425071779680" 2024-11-25 11:06:34.845 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16402_7441169425071779680" LOGICAL 0/17A7C00 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:34.845 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16420_sync_16402_7441169425071779680 WAIT 2024-11-25 11:06:34.845 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16420_sync_16402_7441169425071779680 WAIT 2024-11-25 11:06:34.845 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/0:0] LOG: acquired logical replication slot "pg_16420_sync_16402_7441169425071779680" 2024-11-25 11:06:34.845 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][30/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16420_sync_16402_7441169425071779680 WAIT 2024-11-25 11:06:34.847 GMT [3740][walsender] [pg_16420_sync_16402_7441169425071779680][:0] LOG: disconnection: session time: 0:00:00.054 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:34.877 GMT [1232][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:34.879 GMT [1232][walsender] [[unknown]][31/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:34.879 GMT [1232][walsender] [[unknown]][31/1:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16420_sync_16393_7441169425071779680 2024-11-25 11:06:34.884 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:34.885 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/3:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-11-25 11:06:34.885 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/3:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16420_sync_16393_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:34.885 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16420_sync_16393_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:34.888 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/3:0] LOG: logical decoding found consistent point at 0/17A7C00 2024-11-25 11:06:34.888 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/3:0] DETAIL: There are no running transactions. 2024-11-25 11:06:34.888 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16420_sync_16393_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:34.889 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/3:0] LOG: released logical replication slot "pg_16420_sync_16393_7441169425071779680" 2024-11-25 11:06:34.889 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16420_sync_16393_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:34.890 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][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 = 'tab1_1' 2024-11-25 11:06:34.893 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][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 = 16392 AND c.oid = gpt.relid AND p.pubname IN ( 'pub_all' ) 2024-11-25 11:06:34.897 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/3:0] LOG: statement: SELECT a.attnum, a.attname, a.atttypid, a.attnum = ANY(i.indkey), a.attgenerated != '' FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_index i ON (i.indexrelid = pg_get_replica_identity_index(16392)) WHERE a.attnum > 0::pg_catalog.int2 AND NOT a.attisdropped AND a.attrelid = 16392 ORDER BY a.attnum 2024-11-25 11:06:34.899 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][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 = 16392 AND p.pubname IN ( 'pub_all' ) 2024-11-25 11:06:34.900 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/3:0] LOG: statement: COPY public.tab1_1 (b, a) TO STDOUT 2024-11-25 11:06:34.901 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/3:0] LOG: statement: COMMIT 2024-11-25 11:06:34.901 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/0:0] LOG: received replication command: START_REPLICATION SLOT "pg_16420_sync_16393_7441169425071779680" LOGICAL 0/17A7C38 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:34.901 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16393_7441169425071779680" LOGICAL 0/17A7C38 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:34.901 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/0:0] LOG: acquired logical replication slot "pg_16420_sync_16393_7441169425071779680" 2024-11-25 11:06:34.901 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16393_7441169425071779680" LOGICAL 0/17A7C38 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:34.901 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/0:0] LOG: starting logical decoding for slot "pg_16420_sync_16393_7441169425071779680" 2024-11-25 11:06:34.901 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/0:0] DETAIL: Streaming transactions committing after 0/17A7C38, reading WAL from 0/17A7C00. 2024-11-25 11:06:34.901 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16393_7441169425071779680" LOGICAL 0/17A7C38 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:34.901 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/0:0] LOG: logical decoding found consistent point at 0/17A7C00 2024-11-25 11:06:34.901 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/0:0] DETAIL: There are no running transactions. 2024-11-25 11:06:34.901 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16393_7441169425071779680" LOGICAL 0/17A7C38 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:34.902 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/0:0] LOG: released logical replication slot "pg_16420_sync_16393_7441169425071779680" 2024-11-25 11:06:34.902 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16393_7441169425071779680" LOGICAL 0/17A7C38 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:34.902 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16420_sync_16393_7441169425071779680 WAIT 2024-11-25 11:06:34.902 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16420_sync_16393_7441169425071779680 WAIT 2024-11-25 11:06:34.902 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/0:0] LOG: acquired logical replication slot "pg_16420_sync_16393_7441169425071779680" 2024-11-25 11:06:34.902 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][31/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16420_sync_16393_7441169425071779680 WAIT 2024-11-25 11:06:34.903 GMT [1232][walsender] [pg_16420_sync_16393_7441169425071779680][:0] LOG: disconnection: session time: 0:00:00.028 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:35.168 GMT [6568][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:35.169 GMT [6568][client backend] [[unknown]][8/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:35.169 GMT [6568][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:35.183 GMT [6568][client backend] [013_partition.pl][8/2:0] LOG: statement: INSERT INTO tab1 VALUES (1) 2024-11-25 11:06:35.186 GMT [6568][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.032 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:35.324 GMT [6272][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:35.325 GMT [6272][client backend] [[unknown]][9/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:35.325 GMT [6272][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:35.330 GMT [6272][client backend] [013_partition.pl][9/2:0] LOG: statement: INSERT INTO tab1_1 (a) VALUES (3) 2024-11-25 11:06:35.333 GMT [6272][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:35.493 GMT [4036][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:35.494 GMT [4036][client backend] [[unknown]][0/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:35.494 GMT [4036][client backend] [[unknown]][0/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:35.497 GMT [4036][client backend] [013_partition.pl][0/4:0] LOG: statement: INSERT INTO tab1_2 VALUES (5) 2024-11-25 11:06:35.499 GMT [4036][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:35.643 GMT [684][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:35.644 GMT [684][client backend] [[unknown]][1/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:35.644 GMT [684][client backend] [[unknown]][1/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:35.647 GMT [684][client backend] [013_partition.pl][1/4:0] LOG: statement: INSERT INTO tab1 VALUES (0) 2024-11-25 11:06:35.649 GMT [684][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:35.801 GMT [4492][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:35.803 GMT [4492][client backend] [[unknown]][2/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:35.803 GMT [4492][client backend] [[unknown]][2/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:35.831 GMT [4492][client backend] [013_partition.pl][2/4:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-25 11:06:35.836 GMT [4492][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.047 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:35.967 GMT [8][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:35.968 GMT [8][client backend] [[unknown]][3/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:35.968 GMT [8][client backend] [[unknown]][3/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:35.971 GMT [8][client backend] [013_partition.pl][3/4:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-25 11:06:35.972 GMT [8][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:36.042 GMT [6704][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:36.044 GMT [6704][client backend] [[unknown]][4/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:36.044 GMT [6704][client backend] [[unknown]][4/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:36.058 GMT [6704][client backend] [013_partition.pl][4/4:0] LOG: statement: SELECT '0/17A8030' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub1', 'walreceiver') 2024-11-25 11:06:36.067 GMT [6704][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.031 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:36.201 GMT [1512][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:36.202 GMT [1512][client backend] [[unknown]][5/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:36.202 GMT [1512][client backend] [[unknown]][5/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:36.206 GMT [1512][client backend] [013_partition.pl][5/4:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-25 11:06:36.208 GMT [1512][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.023 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:36.368 GMT [4488][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:36.378 GMT [4488][client backend] [[unknown]][6/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:36.378 GMT [4488][client backend] [[unknown]][6/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:36.384 GMT [4488][client backend] [013_partition.pl][6/4:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-25 11:06:36.387 GMT [4488][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.024 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:36.550 GMT [5812][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:36.551 GMT [5812][client backend] [[unknown]][7/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:36.551 GMT [5812][client backend] [[unknown]][7/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:36.554 GMT [5812][client backend] [013_partition.pl][7/4:0] LOG: statement: SELECT '0/17A8030' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub2', 'walreceiver') 2024-11-25 11:06:36.561 GMT [5812][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:37.582 GMT [5312][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:37.584 GMT [5312][client backend] [[unknown]][8/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:37.584 GMT [5312][client backend] [[unknown]][8/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:37.586 GMT [5312][client backend] [013_partition.pl][8/4:0] LOG: statement: UPDATE tab1 SET a = 2 WHERE a = 1 2024-11-25 11:06:37.590 GMT [5312][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.025 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:37.672 GMT [936][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:37.673 GMT [936][client backend] [[unknown]][9/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:37.673 GMT [936][client backend] [[unknown]][9/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:37.676 GMT [936][client backend] [013_partition.pl][9/4:0] LOG: statement: UPDATE tab1 SET a = 6 WHERE a = 5 2024-11-25 11:06:37.684 GMT [936][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:37.743 GMT [6044][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:37.744 GMT [6044][client backend] [[unknown]][0/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:37.744 GMT [6044][client backend] [[unknown]][0/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:37.757 GMT [6044][client backend] [013_partition.pl][0/6:0] LOG: statement: UPDATE tab1 SET a = 4 WHERE a = 6 2024-11-25 11:06:37.760 GMT [6044][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.024 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:37.853 GMT [1700][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:37.854 GMT [1700][client backend] [[unknown]][1/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:37.854 GMT [1700][client backend] [[unknown]][1/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:37.880 GMT [1700][client backend] [013_partition.pl][1/6:0] LOG: statement: UPDATE tab1 SET a = 6 WHERE a = 4 2024-11-25 11:06:37.884 GMT [1700][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.035 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:38.076 GMT [5400][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:38.078 GMT [5400][client backend] [[unknown]][2/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:38.078 GMT [5400][client backend] [[unknown]][2/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:38.082 GMT [5400][client backend] [013_partition.pl][2/6:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-25 11:06:38.089 GMT [5400][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:38.205 GMT [4196][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:38.206 GMT [4196][client backend] [[unknown]][3/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:38.206 GMT [4196][client backend] [[unknown]][3/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:38.208 GMT [4196][client backend] [013_partition.pl][3/6:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-25 11:06:38.210 GMT [4196][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:38.299 GMT [412][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:38.301 GMT [412][client backend] [[unknown]][4/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:38.301 GMT [412][client backend] [[unknown]][4/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:38.305 GMT [412][client backend] [013_partition.pl][4/6:0] LOG: statement: SELECT '0/17A8330' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub1', 'walreceiver') 2024-11-25 11:06:38.316 GMT [412][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.031 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:38.449 GMT [1644][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:38.450 GMT [1644][client backend] [[unknown]][5/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:38.450 GMT [1644][client backend] [[unknown]][5/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:38.466 GMT [1644][client backend] [013_partition.pl][5/6:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-25 11:06:38.468 GMT [1644][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.023 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:38.592 GMT [4248][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:38.594 GMT [4248][client backend] [[unknown]][6/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:38.594 GMT [4248][client backend] [[unknown]][6/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:38.596 GMT [4248][client backend] [013_partition.pl][6/6:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-25 11:06:38.598 GMT [4248][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:38.755 GMT [6940][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:38.756 GMT [6940][client backend] [[unknown]][7/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:38.756 GMT [6940][client backend] [[unknown]][7/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:38.759 GMT [6940][client backend] [013_partition.pl][7/6:0] LOG: statement: SELECT '0/17A8330' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub2', 'walreceiver') 2024-11-25 11:06:38.768 GMT [6940][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:40.063 GMT [1056][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:40.064 GMT [1056][client backend] [[unknown]][8/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:40.064 GMT [1056][client backend] [[unknown]][8/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:40.066 GMT [1056][client backend] [013_partition.pl][8/6:0] LOG: statement: UPDATE tab1 SET a = 1 WHERE a = 0 2024-11-25 11:06:40.070 GMT [1056][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:40.208 GMT [6996][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:40.209 GMT [6996][client backend] [[unknown]][9/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:40.209 GMT [6996][client backend] [[unknown]][9/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:40.234 GMT [6996][client backend] [013_partition.pl][9/6:0] LOG: statement: UPDATE tab1 SET a = 4 WHERE a = 1 2024-11-25 11:06:40.238 GMT [6996][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.033 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:40.452 GMT [5672][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:40.453 GMT [5672][client backend] [[unknown]][0/7:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:40.453 GMT [5672][client backend] [[unknown]][0/7:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:40.456 GMT [5672][client backend] [013_partition.pl][0/8:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-25 11:06:40.460 GMT [5672][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:40.629 GMT [1208][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:40.630 GMT [1208][client backend] [[unknown]][1/7:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:40.630 GMT [1208][client backend] [[unknown]][1/7:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:40.632 GMT [1208][client backend] [013_partition.pl][1/8:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-25 11:06:40.637 GMT [1208][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:40.792 GMT [1056][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:40.793 GMT [1056][client backend] [[unknown]][2/7:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:40.793 GMT [1056][client backend] [[unknown]][2/7:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:40.796 GMT [1056][client backend] [013_partition.pl][2/8:0] LOG: statement: SELECT '0/17A8510' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub1', 'walreceiver') 2024-11-25 11:06:40.807 GMT [1056][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.018 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:40.962 GMT [1400][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:40.963 GMT [1400][client backend] [[unknown]][3/7:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:40.963 GMT [1400][client backend] [[unknown]][3/7:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:40.966 GMT [1400][client backend] [013_partition.pl][3/8:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-25 11:06:40.969 GMT [1400][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:41.077 GMT [500][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:41.078 GMT [500][client backend] [[unknown]][4/7:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:41.078 GMT [500][client backend] [[unknown]][4/7:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:41.084 GMT [500][client backend] [013_partition.pl][4/8:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-25 11:06:41.087 GMT [500][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:41.256 GMT [3336][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:41.262 GMT [3336][client backend] [[unknown]][5/7:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:41.262 GMT [3336][client backend] [[unknown]][5/7:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:41.288 GMT [3336][client backend] [013_partition.pl][5/8:0] LOG: statement: SELECT '0/17A8510' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub2', 'walreceiver') 2024-11-25 11:06:41.298 GMT [3336][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.054 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:43.055 GMT [3488][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:43.057 GMT [3488][client backend] [[unknown]][6/7:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:43.057 GMT [3488][client backend] [[unknown]][6/7:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:43.065 GMT [3488][client backend] [013_partition.pl][6/8:0] LOG: statement: DELETE FROM tab1 WHERE a IN (2, 3, 5) 2024-11-25 11:06:43.070 GMT [3488][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.030 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:43.175 GMT [5696][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:43.178 GMT [5696][client backend] [[unknown]][7/7:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:43.178 GMT [5696][client backend] [[unknown]][7/7:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:43.251 GMT [5696][client backend] [013_partition.pl][7/8:0] LOG: statement: DELETE FROM tab1_2 2024-11-25 11:06:43.265 GMT [5696][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.105 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:43.470 GMT [3132][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:43.471 GMT [3132][client backend] [[unknown]][8/7:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:43.471 GMT [3132][client backend] [[unknown]][8/7:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:43.474 GMT [3132][client backend] [013_partition.pl][8/8:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-25 11:06:43.479 GMT [3132][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:43.670 GMT [1052][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:43.672 GMT [1052][client backend] [[unknown]][9/7:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:43.672 GMT [1052][client backend] [[unknown]][9/7:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:43.675 GMT [1052][client backend] [013_partition.pl][9/8:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-25 11:06:43.681 GMT [1052][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:43.815 GMT [4304][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:43.823 GMT [4304][client backend] [[unknown]][0/9:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:43.823 GMT [4304][client backend] [[unknown]][0/9:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:43.827 GMT [4304][client backend] [013_partition.pl][0/10:0] LOG: statement: SELECT '0/17A86A8' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub1', 'walreceiver') 2024-11-25 11:06:43.843 GMT [4304][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.058 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:43.934 GMT [3440][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:43.935 GMT [3440][client backend] [[unknown]][1/9:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:43.935 GMT [3440][client backend] [[unknown]][1/9:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:43.938 GMT [3440][client backend] [013_partition.pl][1/10:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-25 11:06:43.941 GMT [3440][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:44.050 GMT [5524][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:44.052 GMT [5524][client backend] [[unknown]][2/9:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:44.052 GMT [5524][client backend] [[unknown]][2/9:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:44.055 GMT [5524][client backend] [013_partition.pl][2/10:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-25 11:06:44.058 GMT [5524][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:44.195 GMT [2752][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:44.214 GMT [2752][client backend] [[unknown]][3/9:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:44.214 GMT [2752][client backend] [[unknown]][3/9:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:44.218 GMT [2752][client backend] [013_partition.pl][3/10:0] LOG: statement: SELECT '0/17A86A8' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub2', 'walreceiver') 2024-11-25 11:06:44.226 GMT [2752][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.082 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:45.370 GMT [1140][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:45.372 GMT [1140][client backend] [[unknown]][4/9:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:45.372 GMT [1140][client backend] [[unknown]][4/9:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:45.378 GMT [1140][client backend] [013_partition.pl][4/10:0] LOG: statement: TRUNCATE tab1_2 2024-11-25 11:06:45.384 GMT [1140][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:45.509 GMT [8][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:45.510 GMT [8][client backend] [[unknown]][5/9:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:45.510 GMT [8][client backend] [[unknown]][5/9:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:45.512 GMT [8][client backend] [013_partition.pl][5/10:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-25 11:06:45.515 GMT [8][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:45.636 GMT [5408][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:45.638 GMT [5408][client backend] [[unknown]][6/9:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:45.638 GMT [5408][client backend] [[unknown]][6/9:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:45.640 GMT [5408][client backend] [013_partition.pl][6/10:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-25 11:06:45.643 GMT [5408][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:45.762 GMT [4532][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:45.763 GMT [4532][client backend] [[unknown]][7/9:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:45.763 GMT [4532][client backend] [[unknown]][7/9:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:45.767 GMT [4532][client backend] [013_partition.pl][7/10:0] LOG: statement: SELECT '0/17A93F8' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub1', 'walreceiver') 2024-11-25 11:06:45.802 GMT [4532][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.042 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:45.961 GMT [3144][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:45.962 GMT [3144][client backend] [[unknown]][8/9:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:45.962 GMT [3144][client backend] [[unknown]][8/9:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:45.965 GMT [3144][client backend] [013_partition.pl][8/10:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-25 11:06:45.969 GMT [3144][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:46.096 GMT [700][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:46.098 GMT [700][client backend] [[unknown]][9/9:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:46.098 GMT [700][client backend] [[unknown]][9/9:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:46.100 GMT [700][client backend] [013_partition.pl][9/10:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-25 11:06:46.105 GMT [700][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:46.258 GMT [6832][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:46.260 GMT [6832][client backend] [[unknown]][0/11:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:46.260 GMT [6832][client backend] [[unknown]][0/11:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:46.269 GMT [6832][client backend] [013_partition.pl][0/12:0] LOG: statement: SELECT '0/17A93F8' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub2', 'walreceiver') 2024-11-25 11:06:46.278 GMT [6832][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:46.681 GMT [6008][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:46.683 GMT [6008][client backend] [[unknown]][1/11:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:46.683 GMT [6008][client backend] [[unknown]][1/11:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:46.685 GMT [6008][client backend] [013_partition.pl][1/12:0] LOG: statement: TRUNCATE tab1 2024-11-25 11:06:46.703 GMT [6008][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.024 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:46.823 GMT [2132][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:46.824 GMT [2132][client backend] [[unknown]][2/11:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:46.824 GMT [2132][client backend] [[unknown]][2/11:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:46.845 GMT [2132][client backend] [013_partition.pl][2/12:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-25 11:06:46.851 GMT [2132][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.031 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:46.953 GMT [6932][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:46.954 GMT [6932][client backend] [[unknown]][3/11:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:46.954 GMT [6932][client backend] [[unknown]][3/11:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:46.957 GMT [6932][client backend] [013_partition.pl][3/12:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-25 11:06:46.961 GMT [6932][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:47.101 GMT [5760][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:47.103 GMT [5760][client backend] [[unknown]][4/11:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:47.103 GMT [5760][client backend] [[unknown]][4/11:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:47.106 GMT [5760][client backend] [013_partition.pl][4/12:0] LOG: statement: SELECT '0/17AF248' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub1', 'walreceiver') 2024-11-25 11:06:47.117 GMT [5760][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.030 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:47.224 GMT [5132][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:47.226 GMT [5132][client backend] [[unknown]][5/11:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:47.226 GMT [5132][client backend] [[unknown]][5/11:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:47.239 GMT [5132][client backend] [013_partition.pl][5/12:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-25 11:06:47.245 GMT [5132][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.023 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:47.355 GMT [6976][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:47.356 GMT [6976][client backend] [[unknown]][6/11:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:47.356 GMT [6976][client backend] [[unknown]][6/11:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:47.359 GMT [6976][client backend] [013_partition.pl][6/12:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-25 11:06:47.362 GMT [6976][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:47.428 GMT [1492][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:47.429 GMT [1492][client backend] [[unknown]][7/11:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:47.430 GMT [1492][client backend] [[unknown]][7/11:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:47.432 GMT [1492][client backend] [013_partition.pl][7/12:0] LOG: statement: SELECT '0/17AF248' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub2', 'walreceiver') 2024-11-25 11:06:47.441 GMT [1492][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:47.863 GMT [5592][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:47.864 GMT [5592][client backend] [[unknown]][8/11:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:47.864 GMT [5592][client backend] [[unknown]][8/11:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:47.867 GMT [5592][client backend] [013_partition.pl][8/12:0] LOG: statement: INSERT INTO tab1 VALUES (1, 'foo'), (4, 'bar'), (10, 'baz') 2024-11-25 11:06:47.871 GMT [5592][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:47.958 GMT [4336][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:47.959 GMT [4336][client backend] [[unknown]][9/11:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:47.959 GMT [4336][client backend] [[unknown]][9/11:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:47.962 GMT [4336][client backend] [013_partition.pl][9/12:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-25 11:06:47.965 GMT [4336][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:48.079 GMT [5108][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:48.080 GMT [5108][client backend] [[unknown]][0/13:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:48.080 GMT [5108][client backend] [[unknown]][0/13:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:48.082 GMT [5108][client backend] [013_partition.pl][0/14:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-25 11:06:48.086 GMT [5108][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:48.178 GMT [5812][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:48.179 GMT [5812][client backend] [[unknown]][1/13:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:48.179 GMT [5812][client backend] [[unknown]][1/13:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:48.181 GMT [5812][client backend] [013_partition.pl][1/14:0] LOG: statement: SELECT '0/17AF518' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub1', 'walreceiver') 2024-11-25 11:06:48.193 GMT [5812][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.018 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:48.340 GMT [6584][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:48.341 GMT [6584][client backend] [[unknown]][2/13:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:48.341 GMT [6584][client backend] [[unknown]][2/13:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:48.344 GMT [6584][client backend] [013_partition.pl][2/14:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-25 11:06:48.346 GMT [6584][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:48.510 GMT [2344][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:48.512 GMT [2344][client backend] [[unknown]][3/13:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:48.512 GMT [2344][client backend] [[unknown]][3/13:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:48.514 GMT [2344][client backend] [013_partition.pl][3/14:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-25 11:06:48.518 GMT [2344][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:48.605 GMT [5628][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:48.606 GMT [5628][client backend] [[unknown]][4/13:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:48.606 GMT [5628][client backend] [[unknown]][4/13:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:48.610 GMT [5628][client backend] [013_partition.pl][4/14:0] LOG: statement: SELECT '0/17AF518' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub2', 'walreceiver') 2024-11-25 11:06:48.618 GMT [5628][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:48.780 GMT [6852][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:48.781 GMT [6852][client backend] [[unknown]][5/13:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:48.781 GMT [6852][client backend] [[unknown]][5/13:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:48.808 GMT [6852][client backend] [013_partition.pl][5/14:0] LOG: statement: UPDATE tab1 SET b = 'quux' WHERE a = 4 2024-11-25 11:06:48.823 GMT [6852][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.046 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:48.950 GMT [6784][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:48.953 GMT [6784][client backend] [[unknown]][6/13:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:48.953 GMT [6784][client backend] [[unknown]][6/13:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:48.972 GMT [6784][client backend] [013_partition.pl][6/14:0] LOG: statement: DELETE FROM tab1 2024-11-25 11:06:48.975 GMT [6784][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.029 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:49.121 GMT [2176][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:49.123 GMT [2176][client backend] [[unknown]][7/13:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:49.123 GMT [2176][client backend] [[unknown]][7/13:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:49.126 GMT [2176][client backend] [013_partition.pl][7/14:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-25 11:06:49.130 GMT [2176][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:49.198 GMT [6220][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:49.199 GMT [6220][client backend] [[unknown]][8/13:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:49.199 GMT [6220][client backend] [[unknown]][8/13:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:49.219 GMT [6220][client backend] [013_partition.pl][8/14:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-25 11:06:49.222 GMT [6220][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.027 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:49.317 GMT [5016][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:49.318 GMT [5016][client backend] [[unknown]][9/13:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:49.318 GMT [5016][client backend] [[unknown]][9/13:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:49.321 GMT [5016][client backend] [013_partition.pl][9/14:0] LOG: statement: SELECT '0/17AF688' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub1', 'walreceiver') 2024-11-25 11:06:49.331 GMT [5016][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:49.393 GMT [6280][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:49.394 GMT [6280][client backend] [[unknown]][0/15:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:49.394 GMT [6280][client backend] [[unknown]][0/15:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:49.396 GMT [6280][client backend] [013_partition.pl][0/16:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-25 11:06:49.398 GMT [6280][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:49.488 GMT [4476][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:49.489 GMT [4476][client backend] [[unknown]][1/15:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:49.489 GMT [4476][client backend] [[unknown]][1/15:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:49.492 GMT [4476][client backend] [013_partition.pl][1/16:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-25 11:06:49.494 GMT [4476][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:49.575 GMT [3344][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:49.576 GMT [3344][client backend] [[unknown]][2/15:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:49.576 GMT [3344][client backend] [[unknown]][2/15:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:49.579 GMT [3344][client backend] [013_partition.pl][2/16:0] LOG: statement: SELECT '0/17AF688' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub2', 'walreceiver') 2024-11-25 11:06:49.587 GMT [3344][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:49.692 GMT [5292][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:49.693 GMT [5292][client backend] [[unknown]][3/15:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:49.693 GMT [5292][client backend] [[unknown]][3/15:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:49.696 GMT [5292][client backend] [013_partition.pl][3/16:0] LOG: statement: DROP PUBLICATION pub1 2024-11-25 11:06:49.700 GMT [5292][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:49.791 GMT [6864][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:49.793 GMT [6864][client backend] [[unknown]][4/15:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:49.793 GMT [6864][client backend] [[unknown]][4/15:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:49.799 GMT [6864][client backend] [013_partition.pl][4/16:0] LOG: statement: CREATE TABLE tab2 (a int PRIMARY KEY, b text) PARTITION BY LIST (a) 2024-11-25 11:06:49.806 GMT [6864][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:49.942 GMT [4016][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:49.943 GMT [4016][client backend] [[unknown]][5/15:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:49.943 GMT [4016][client backend] [[unknown]][5/15:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:49.951 GMT [4016][client backend] [013_partition.pl][5/16:0] LOG: statement: CREATE TABLE tab2_1 (b text, a int NOT NULL) 2024-11-25 11:06:49.963 GMT [4016][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.024 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:50.061 GMT [3400][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:50.062 GMT [3400][client backend] [[unknown]][6/15:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:50.062 GMT [3400][client backend] [[unknown]][6/15:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:50.065 GMT [3400][client backend] [013_partition.pl][6/16:0] LOG: statement: ALTER TABLE tab2 ATTACH PARTITION tab2_1 FOR VALUES IN (0, 1, 2, 3) 2024-11-25 11:06:50.076 GMT [3400][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.018 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:50.184 GMT [5436][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:50.185 GMT [5436][client backend] [[unknown]][7/15:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:50.185 GMT [5436][client backend] [[unknown]][7/15:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:50.193 GMT [5436][client backend] [013_partition.pl][7/16:0] LOG: statement: CREATE TABLE tab2_2 PARTITION OF tab2 FOR VALUES IN (5, 6) 2024-11-25 11:06:50.205 GMT [5436][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.024 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:50.282 GMT [2444][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:50.283 GMT [2444][client backend] [[unknown]][8/15:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:50.283 GMT [2444][client backend] [[unknown]][8/15:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:50.287 GMT [2444][client backend] [013_partition.pl][8/16:0] LOG: statement: CREATE TABLE tab3 (a int PRIMARY KEY, b text) PARTITION BY LIST (a) 2024-11-25 11:06:50.293 GMT [2444][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:51.080 GMT [6584][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:51.082 GMT [6584][client backend] [[unknown]][9/15:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:51.082 GMT [6584][client backend] [[unknown]][9/15:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:51.085 GMT [6584][client backend] [013_partition.pl][9/16:0] LOG: statement: CREATE TABLE tab3_1 PARTITION OF tab3 FOR VALUES IN (0, 1, 2, 3, 5, 6) 2024-11-25 11:06:51.097 GMT [6584][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:51.301 GMT [2328][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:51.302 GMT [2328][client backend] [[unknown]][0/17:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:51.302 GMT [2328][client backend] [[unknown]][0/17:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:51.306 GMT [2328][client backend] [013_partition.pl][0/18:0] LOG: statement: CREATE TABLE tab4 (a int PRIMARY KEY) PARTITION BY LIST (a) 2024-11-25 11:06:51.311 GMT [2328][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:51.456 GMT [5980][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:51.457 GMT [5980][client backend] [[unknown]][1/17:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:51.457 GMT [5980][client backend] [[unknown]][1/17:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:51.461 GMT [5980][client backend] [013_partition.pl][1/18:0] LOG: statement: CREATE TABLE tab4_1 PARTITION OF tab4 FOR VALUES IN (-1, 0, 1) PARTITION BY LIST (a) 2024-11-25 11:06:51.469 GMT [5980][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:51.680 GMT [5180][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:51.681 GMT [5180][client backend] [[unknown]][2/17:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:51.681 GMT [5180][client backend] [[unknown]][2/17:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:51.685 GMT [5180][client backend] [013_partition.pl][2/18:0] LOG: statement: CREATE TABLE tab4_1_1 PARTITION OF tab4_1 FOR VALUES IN (-1, 0, 1) 2024-11-25 11:06:51.693 GMT [5180][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:51.918 GMT [5224][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:51.920 GMT [5224][client backend] [[unknown]][3/17:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:51.920 GMT [5224][client backend] [[unknown]][3/17:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:51.926 GMT [5224][client backend] [013_partition.pl][3/18:0] LOG: statement: ALTER PUBLICATION pub_all SET (publish_via_partition_root = true) 2024-11-25 11:06:51.929 GMT [5224][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:52.087 GMT [2756][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:52.088 GMT [2756][client backend] [[unknown]][4/17:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:52.088 GMT [2756][client backend] [[unknown]][4/17:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:52.104 GMT [2756][client backend] [013_partition.pl][4/18:0] LOG: statement: CREATE PUBLICATION pub_viaroot FOR TABLE tab2, tab2_1, tab3_1 WITH (publish_via_partition_root = true) 2024-11-25 11:06:52.107 GMT [2756][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.054 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:52.275 GMT [2272][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:52.277 GMT [2272][client backend] [[unknown]][5/17:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:52.277 GMT [2272][client backend] [[unknown]][5/17:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:52.281 GMT [2272][client backend] [013_partition.pl][5/18:0] LOG: statement: CREATE PUBLICATION pub_lower_level FOR TABLE tab4_1 WITH (publish_via_partition_root = true) 2024-11-25 11:06:52.284 GMT [2272][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:52.469 GMT [7148][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:52.471 GMT [7148][client backend] [[unknown]][6/17:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:52.471 GMT [7148][client backend] [[unknown]][6/17:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:52.473 GMT [7148][client backend] [013_partition.pl][6/18:0] LOG: statement: INSERT INTO tab2 VALUES (1) 2024-11-25 11:06:52.475 GMT [7148][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:52.477 GMT [7124][walsender] [sub1][23/0:0] ERROR: publication "pub1" does not exist 2024-11-25 11:06:52.477 GMT [7124][walsender] [sub1][23/0:0] CONTEXT: slot "sub1", output plugin "pgoutput", in the change callback, associated LSN 0/17E1758 2024-11-25 11:06:52.477 GMT [7124][walsender] [sub1][23/0:0] STATEMENT: START_REPLICATION SLOT "sub1" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:52.478 GMT [7124][walsender] [sub1][23/0:0] LOG: released logical replication slot "sub1" 2024-11-25 11:06:52.478 GMT [7124][walsender] [sub1][23/0:0] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2024-11-25 11:06:52.478 GMT [7124][walsender] [sub1][:0] LOG: disconnection: session time: 0:00:18.828 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:52.479 GMT [2380][walsender] [sub2][28/0:0] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2024-11-25 11:06:52.479 GMT [2380][walsender] [sub2][28/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:52.479 GMT [2380][walsender] [sub2][28/0:0] LOG: unexpected EOF on standby connection 2024-11-25 11:06:52.479 GMT [2380][walsender] [sub2][28/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:52.479 GMT [2380][walsender] [sub2][28/0:0] LOG: released logical replication slot "sub2" 2024-11-25 11:06:52.479 GMT [2380][walsender] [sub2][:0] LOG: disconnection: session time: 0:00:17.793 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:52.552 GMT [7152][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:52.553 GMT [4328][postmaster] LOG: could not reserve shared memory region (addr=0000027C43000000) for child 00000000000012A0: error code 487 2024-11-25 11:06:52.553 GMT [7152][walsender] [[unknown]][22/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:52.554 GMT [7152][walsender] [[unknown]][22/5:0] LOG: replication connection authorized: user=SYSTEM application_name=sub1 2024-11-25 11:06:52.556 GMT [7152][walsender] [sub1][22/6:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:52.557 GMT [7152][walsender] [sub1][22/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-25 11:06:52.557 GMT [7152][walsender] [sub1][22/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-25 11:06:52.557 GMT [7152][walsender] [sub1][22/0:0] LOG: received replication command: START_REPLICATION SLOT "sub1" LOGICAL 0/17AF518 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:52.557 GMT [7152][walsender] [sub1][22/0:0] STATEMENT: START_REPLICATION SLOT "sub1" LOGICAL 0/17AF518 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:52.557 GMT [7152][walsender] [sub1][22/0:0] LOG: acquired logical replication slot "sub1" 2024-11-25 11:06:52.557 GMT [7152][walsender] [sub1][22/0:0] STATEMENT: START_REPLICATION SLOT "sub1" LOGICAL 0/17AF518 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:52.557 GMT [7152][walsender] [sub1][22/0:0] LOG: 0/17AF518 has been already streamed, forwarding to 0/17E1758 2024-11-25 11:06:52.557 GMT [7152][walsender] [sub1][22/0:0] STATEMENT: START_REPLICATION SLOT "sub1" LOGICAL 0/17AF518 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:52.558 GMT [7152][walsender] [sub1][22/0:0] LOG: starting logical decoding for slot "sub1" 2024-11-25 11:06:52.558 GMT [7152][walsender] [sub1][22/0:0] DETAIL: Streaming transactions committing after 0/17E1758, reading WAL from 0/17A8510. 2024-11-25 11:06:52.558 GMT [7152][walsender] [sub1][22/0:0] STATEMENT: START_REPLICATION SLOT "sub1" LOGICAL 0/17AF518 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:52.558 GMT [7152][walsender] [sub1][22/0:0] LOG: logical decoding found consistent point at 0/17A8510 2024-11-25 11:06:52.558 GMT [7152][walsender] [sub1][22/0:0] DETAIL: There are no running transactions. 2024-11-25 11:06:52.558 GMT [7152][walsender] [sub1][22/0:0] STATEMENT: START_REPLICATION SLOT "sub1" LOGICAL 0/17AF518 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:52.562 GMT [7152][walsender] [sub1][22/0:0] ERROR: publication "pub1" does not exist 2024-11-25 11:06:52.562 GMT [7152][walsender] [sub1][22/0:0] CONTEXT: slot "sub1", output plugin "pgoutput", in the change callback, associated LSN 0/17E1758 2024-11-25 11:06:52.562 GMT [7152][walsender] [sub1][22/0:0] STATEMENT: START_REPLICATION SLOT "sub1" LOGICAL 0/17AF518 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-11-25 11:06:52.562 GMT [7152][walsender] [sub1][22/0:0] LOG: released logical replication slot "sub1" 2024-11-25 11:06:52.562 GMT [7152][walsender] [sub1][22/0:0] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2024-11-25 11:06:52.563 GMT [7152][walsender] [sub1][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:52.584 GMT [2916][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:52.586 GMT [2916][walsender] [[unknown]][24/4:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:52.586 GMT [2916][walsender] [[unknown]][24/4:0] LOG: replication connection authorized: user=SYSTEM application_name=sub2 2024-11-25 11:06:52.589 GMT [2916][walsender] [sub2][24/5:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:52.589 GMT [2916][walsender] [sub2][24/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-25 11:06:52.589 GMT [2916][walsender] [sub2][24/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-25 11:06:52.589 GMT [2916][walsender] [sub2][24/0:0] LOG: received replication command: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:52.589 GMT [2916][walsender] [sub2][24/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:52.589 GMT [2916][walsender] [sub2][24/0:0] LOG: acquired logical replication slot "sub2" 2024-11-25 11:06:52.589 GMT [2916][walsender] [sub2][24/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:52.589 GMT [2916][walsender] [sub2][24/0:0] LOG: 0/17AF688 has been already streamed, forwarding to 0/17E1758 2024-11-25 11:06:52.589 GMT [2916][walsender] [sub2][24/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:52.590 GMT [2916][walsender] [sub2][24/0:0] LOG: starting logical decoding for slot "sub2" 2024-11-25 11:06:52.590 GMT [2916][walsender] [sub2][24/0:0] DETAIL: Streaming transactions committing after 0/17E1758, reading WAL from 0/17A8510. 2024-11-25 11:06:52.590 GMT [2916][walsender] [sub2][24/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:52.590 GMT [2916][walsender] [sub2][24/0:0] LOG: logical decoding found consistent point at 0/17A8510 2024-11-25 11:06:52.590 GMT [2916][walsender] [sub2][24/0:0] DETAIL: There are no running transactions. 2024-11-25 11:06:52.590 GMT [2916][walsender] [sub2][24/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:52.595 GMT [2916][walsender] [sub2][24/0:0] LOG: released logical replication slot "sub2" 2024-11-25 11:06:52.595 GMT [2916][walsender] [sub2][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:52.602 GMT [2620][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:52.603 GMT [2620][client backend] [[unknown]][7/17:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:52.603 GMT [2620][client backend] [[unknown]][7/17:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:52.606 GMT [2620][client backend] [013_partition.pl][7/18:0] LOG: statement: INSERT INTO tab4 VALUES (-1) 2024-11-25 11:06:52.608 GMT [2620][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:52.865 GMT [5592][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:52.867 GMT [5592][walsender] [[unknown]][25/4:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:52.867 GMT [5592][walsender] [[unknown]][25/4:0] LOG: replication connection authorized: user=SYSTEM application_name=sub1 2024-11-25 11:06:52.879 GMT [5592][walsender] [sub1][25/5:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:52.880 GMT [5592][walsender] [sub1][25/0:0] LOG: received replication command: DROP_REPLICATION_SLOT sub1 WAIT 2024-11-25 11:06:52.880 GMT [5592][walsender] [sub1][25/0:0] STATEMENT: DROP_REPLICATION_SLOT sub1 WAIT 2024-11-25 11:06:52.880 GMT [5592][walsender] [sub1][25/0:0] LOG: acquired logical replication slot "sub1" 2024-11-25 11:06:52.880 GMT [5592][walsender] [sub1][25/0:0] STATEMENT: DROP_REPLICATION_SLOT sub1 WAIT 2024-11-25 11:06:52.881 GMT [5592][walsender] [sub1][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:53.058 GMT [6944][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:53.059 GMT [6944][walsender] [[unknown]][26/4:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:53.059 GMT [6944][walsender] [[unknown]][26/4:0] LOG: replication connection authorized: user=SYSTEM application_name=sub2 2024-11-25 11:06:53.064 GMT [6944][walsender] [sub2][26/5:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:53.065 GMT [6944][walsender] [sub2][26/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-25 11:06:53.065 GMT [6944][walsender] [sub2][26/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-25 11:06:53.065 GMT [6944][walsender] [sub2][26/0:0] LOG: received replication command: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:53.065 GMT [6944][walsender] [sub2][26/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:53.065 GMT [6944][walsender] [sub2][26/0:0] LOG: acquired logical replication slot "sub2" 2024-11-25 11:06:53.065 GMT [6944][walsender] [sub2][26/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:53.065 GMT [6944][walsender] [sub2][26/0:0] LOG: 0/17AF688 has been already streamed, forwarding to 0/17E1758 2024-11-25 11:06:53.065 GMT [6944][walsender] [sub2][26/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:53.065 GMT [6944][walsender] [sub2][26/0:0] LOG: starting logical decoding for slot "sub2" 2024-11-25 11:06:53.065 GMT [6944][walsender] [sub2][26/0:0] DETAIL: Streaming transactions committing after 0/17E1758, reading WAL from 0/17A8510. 2024-11-25 11:06:53.065 GMT [6944][walsender] [sub2][26/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:53.066 GMT [6944][walsender] [sub2][26/0:0] LOG: logical decoding found consistent point at 0/17A8510 2024-11-25 11:06:53.066 GMT [6944][walsender] [sub2][26/0:0] DETAIL: There are no running transactions. 2024-11-25 11:06:53.066 GMT [6944][walsender] [sub2][26/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:53.075 GMT [6944][walsender] [sub2][26/0:0] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2024-11-25 11:06:53.075 GMT [6944][walsender] [sub2][26/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:53.075 GMT [6944][walsender] [sub2][26/0:0] LOG: unexpected EOF on standby connection 2024-11-25 11:06:53.075 GMT [6944][walsender] [sub2][26/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:53.075 GMT [6944][walsender] [sub2][26/0:0] LOG: released logical replication slot "sub2" 2024-11-25 11:06:53.075 GMT [6944][walsender] [sub2][:0] LOG: disconnection: session time: 0:00:00.020 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:53.556 GMT [5552][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:53.557 GMT [5552][walsender] [[unknown]][27/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:53.557 GMT [5552][walsender] [[unknown]][27/5:0] LOG: replication connection authorized: user=SYSTEM application_name=sub2 2024-11-25 11:06:53.560 GMT [5552][walsender] [sub2][27/6:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:53.561 GMT [5552][walsender] [sub2][27/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-25 11:06:53.561 GMT [5552][walsender] [sub2][27/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-25 11:06:53.561 GMT [5552][walsender] [sub2][27/0:0] LOG: received replication command: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:53.561 GMT [5552][walsender] [sub2][27/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:53.561 GMT [5552][walsender] [sub2][27/0:0] LOG: acquired logical replication slot "sub2" 2024-11-25 11:06:53.561 GMT [5552][walsender] [sub2][27/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:53.561 GMT [5552][walsender] [sub2][27/0:0] LOG: 0/17AF688 has been already streamed, forwarding to 0/17E1758 2024-11-25 11:06:53.561 GMT [5552][walsender] [sub2][27/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:53.561 GMT [5552][walsender] [sub2][27/0:0] LOG: starting logical decoding for slot "sub2" 2024-11-25 11:06:53.561 GMT [5552][walsender] [sub2][27/0:0] DETAIL: Streaming transactions committing after 0/17E1758, reading WAL from 0/17A8510. 2024-11-25 11:06:53.561 GMT [5552][walsender] [sub2][27/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:53.562 GMT [5552][walsender] [sub2][27/0:0] LOG: logical decoding found consistent point at 0/17A8510 2024-11-25 11:06:53.562 GMT [5552][walsender] [sub2][27/0:0] DETAIL: There are no running transactions. 2024-11-25 11:06:53.562 GMT [5552][walsender] [sub2][27/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:53.566 GMT [5552][walsender] [sub2][27/9:0] LOG: could not send data to client: An existing connection was forcibly closed by the remote host. 2024-11-25 11:06:53.566 GMT [5552][walsender] [sub2][27/9:0] CONTEXT: slot "sub2", output plugin "pgoutput", in the change callback, associated LSN 0/17E1868 2024-11-25 11:06:53.566 GMT [5552][walsender] [sub2][27/9:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:53.566 GMT [5552][walsender] [sub2][27/0:0] LOG: released logical replication slot "sub2" 2024-11-25 11:06:53.566 GMT [5552][walsender] [sub2][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:53.616 GMT [4612][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:53.625 GMT [4612][walsender] [[unknown]][29/4:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:53.625 GMT [4612][walsender] [[unknown]][29/4:0] LOG: replication connection authorized: user=SYSTEM application_name=sub_viaroot 2024-11-25 11:06:53.634 GMT [4612][walsender] [sub_viaroot][29/5:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:53.634 GMT [4612][walsender] [sub_viaroot][29/6:0] LOG: statement: SELECT t.pubname FROM pg_catalog.pg_publication t WHERE t.pubname IN ('pub_viaroot') 2024-11-25 11:06:53.638 GMT [4612][walsender] [sub_viaroot][29/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 ( 'pub_viaroot' )) AS gpt ON gpt.relid = c.oid 2024-11-25 11:06:53.646 GMT [4612][walsender] [sub_viaroot][29/0:0] LOG: received replication command: CREATE_REPLICATION_SLOT "sub_viaroot" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-25 11:06:53.646 GMT [4612][walsender] [sub_viaroot][29/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub_viaroot" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-25 11:06:53.652 GMT [4612][walsender] [sub_viaroot][29/0:0] LOG: logical decoding found consistent point at 0/17E1978 2024-11-25 11:06:53.652 GMT [4612][walsender] [sub_viaroot][29/0:0] DETAIL: There are no running transactions. 2024-11-25 11:06:53.652 GMT [4612][walsender] [sub_viaroot][29/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub_viaroot" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-25 11:06:53.654 GMT [4612][walsender] [sub_viaroot][29/0:0] LOG: released logical replication slot "sub_viaroot" 2024-11-25 11:06:53.654 GMT [4612][walsender] [sub_viaroot][29/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub_viaroot" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-25 11:06:53.655 GMT [4612][walsender] [sub_viaroot][:0] LOG: disconnection: session time: 0:00:00.056 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:53.747 GMT [5004][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:53.749 GMT [5004][walsender] [[unknown]][30/4:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:53.750 GMT [5004][walsender] [[unknown]][30/4:0] LOG: replication connection authorized: user=SYSTEM application_name=sub_viaroot 2024-11-25 11:06:53.755 GMT [5004][walsender] [sub_viaroot][30/5:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:53.755 GMT [5004][walsender] [sub_viaroot][30/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-25 11:06:53.755 GMT [5004][walsender] [sub_viaroot][30/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-25 11:06:53.755 GMT [5004][walsender] [sub_viaroot][30/0:0] LOG: received replication command: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:53.755 GMT [5004][walsender] [sub_viaroot][30/0:0] STATEMENT: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:53.756 GMT [5004][walsender] [sub_viaroot][30/0:0] LOG: acquired logical replication slot "sub_viaroot" 2024-11-25 11:06:53.756 GMT [5004][walsender] [sub_viaroot][30/0:0] STATEMENT: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:53.756 GMT [5004][walsender] [sub_viaroot][30/0:0] LOG: starting logical decoding for slot "sub_viaroot" 2024-11-25 11:06:53.756 GMT [5004][walsender] [sub_viaroot][30/0:0] DETAIL: Streaming transactions committing after 0/17E19B0, reading WAL from 0/17E1978. 2024-11-25 11:06:53.756 GMT [5004][walsender] [sub_viaroot][30/0:0] STATEMENT: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:53.756 GMT [5004][walsender] [sub_viaroot][30/0:0] LOG: logical decoding found consistent point at 0/17E1978 2024-11-25 11:06:53.756 GMT [5004][walsender] [sub_viaroot][30/0:0] DETAIL: There are no running transactions. 2024-11-25 11:06:53.756 GMT [5004][walsender] [sub_viaroot][30/0:0] STATEMENT: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:53.837 GMT [5208][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:53.838 GMT [5208][walsender] [[unknown]][31/4:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:53.838 GMT [5208][walsender] [[unknown]][31/4:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16498_sync_16489_7441169425071779680 2024-11-25 11:06:53.841 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/5:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:53.842 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/6:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-11-25 11:06:53.842 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/6:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16498_sync_16489_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:53.842 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/6:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16498_sync_16489_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:53.857 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/6:0] LOG: logical decoding found consistent point at 0/17E19B0 2024-11-25 11:06:53.857 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/6:0] DETAIL: There are no running transactions. 2024-11-25 11:06:53.857 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/6:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16498_sync_16489_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:53.861 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/6:0] LOG: released logical replication slot "pg_16498_sync_16489_7441169425071779680" 2024-11-25 11:06:53.861 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/6:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16498_sync_16489_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:53.862 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][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 = 'tab3_1' 2024-11-25 11:06:53.866 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][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 = 16462 AND c.oid = gpt.relid AND p.pubname IN ( 'pub_viaroot' ) 2024-11-25 11:06:53.871 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/6:0] LOG: statement: SELECT a.attnum, a.attname, a.atttypid, a.attnum = ANY(i.indkey), a.attgenerated != '' FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_index i ON (i.indexrelid = pg_get_replica_identity_index(16462)) WHERE a.attnum > 0::pg_catalog.int2 AND NOT a.attisdropped AND a.attrelid = 16462 ORDER BY a.attnum 2024-11-25 11:06:53.873 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][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 = 16462 AND p.pubname IN ( 'pub_viaroot' ) 2024-11-25 11:06:53.875 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/6:0] LOG: statement: COPY public.tab3_1 (a, b) TO STDOUT 2024-11-25 11:06:53.875 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/6:0] LOG: statement: COMMIT 2024-11-25 11:06:53.876 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/0:0] LOG: received replication command: START_REPLICATION SLOT "pg_16498_sync_16489_7441169425071779680" LOGICAL 0/17E19E8 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:53.876 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16498_sync_16489_7441169425071779680" LOGICAL 0/17E19E8 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:53.876 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/0:0] LOG: acquired logical replication slot "pg_16498_sync_16489_7441169425071779680" 2024-11-25 11:06:53.876 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16498_sync_16489_7441169425071779680" LOGICAL 0/17E19E8 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:53.876 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/0:0] LOG: starting logical decoding for slot "pg_16498_sync_16489_7441169425071779680" 2024-11-25 11:06:53.876 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/0:0] DETAIL: Streaming transactions committing after 0/17E19E8, reading WAL from 0/17E19B0. 2024-11-25 11:06:53.876 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16498_sync_16489_7441169425071779680" LOGICAL 0/17E19E8 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:53.876 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/0:0] LOG: logical decoding found consistent point at 0/17E19B0 2024-11-25 11:06:53.876 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/0:0] DETAIL: There are no running transactions. 2024-11-25 11:06:53.876 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16498_sync_16489_7441169425071779680" LOGICAL 0/17E19E8 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:53.876 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/0:0] LOG: released logical replication slot "pg_16498_sync_16489_7441169425071779680" 2024-11-25 11:06:53.876 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16498_sync_16489_7441169425071779680" LOGICAL 0/17E19E8 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:53.877 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16498_sync_16489_7441169425071779680 WAIT 2024-11-25 11:06:53.877 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16498_sync_16489_7441169425071779680 WAIT 2024-11-25 11:06:53.877 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/0:0] LOG: acquired logical replication slot "pg_16498_sync_16489_7441169425071779680" 2024-11-25 11:06:53.877 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][31/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16498_sync_16489_7441169425071779680 WAIT 2024-11-25 11:06:53.878 GMT [5208][walsender] [pg_16498_sync_16489_7441169425071779680][:0] LOG: disconnection: session time: 0:00:00.044 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:53.907 GMT [6376][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:53.909 GMT [6376][walsender] [[unknown]][23/35:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:53.909 GMT [6376][walsender] [[unknown]][23/35:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16498_sync_16473_7441169425071779680 2024-11-25 11:06:53.913 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/36:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:53.915 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/37:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-11-25 11:06:53.915 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/37:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16498_sync_16473_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:53.915 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/37:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16498_sync_16473_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:53.933 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/37:0] LOG: logical decoding found consistent point at 0/17E19E8 2024-11-25 11:06:53.933 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/37:0] DETAIL: There are no running transactions. 2024-11-25 11:06:53.933 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/37:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16498_sync_16473_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:53.935 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/37:0] LOG: released logical replication slot "pg_16498_sync_16473_7441169425071779680" 2024-11-25 11:06:53.935 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/37:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16498_sync_16473_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:53.935 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/37: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-11-25 11:06:53.940 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/37: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 ( 'pub_viaroot' ) 2024-11-25 11:06:53.944 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/37:0] LOG: statement: SELECT a.attnum, a.attname, a.atttypid, a.attnum = ANY(i.indkey), a.attgenerated != '' FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_index i ON (i.indexrelid = pg_get_replica_identity_index(16434)) WHERE a.attnum > 0::pg_catalog.int2 AND NOT a.attisdropped AND a.attrelid = 16434 ORDER BY a.attnum 2024-11-25 11:06:53.946 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/37: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 ( 'pub_viaroot' ) 2024-11-25 11:06:53.948 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/37:0] LOG: statement: COPY (SELECT a, b FROM public.tab2) TO STDOUT 2024-11-25 11:06:53.950 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/37:0] LOG: statement: COMMIT 2024-11-25 11:06:53.951 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/0:0] LOG: received replication command: START_REPLICATION SLOT "pg_16498_sync_16473_7441169425071779680" LOGICAL 0/17E1A20 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:53.951 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/0:0] STATEMENT: START_REPLICATION SLOT "pg_16498_sync_16473_7441169425071779680" LOGICAL 0/17E1A20 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:53.951 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/0:0] LOG: acquired logical replication slot "pg_16498_sync_16473_7441169425071779680" 2024-11-25 11:06:53.951 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/0:0] STATEMENT: START_REPLICATION SLOT "pg_16498_sync_16473_7441169425071779680" LOGICAL 0/17E1A20 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:53.951 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/0:0] LOG: starting logical decoding for slot "pg_16498_sync_16473_7441169425071779680" 2024-11-25 11:06:53.951 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/0:0] DETAIL: Streaming transactions committing after 0/17E1A20, reading WAL from 0/17E19E8. 2024-11-25 11:06:53.951 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/0:0] STATEMENT: START_REPLICATION SLOT "pg_16498_sync_16473_7441169425071779680" LOGICAL 0/17E1A20 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:53.951 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/0:0] LOG: logical decoding found consistent point at 0/17E19E8 2024-11-25 11:06:53.951 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/0:0] DETAIL: There are no running transactions. 2024-11-25 11:06:53.951 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/0:0] STATEMENT: START_REPLICATION SLOT "pg_16498_sync_16473_7441169425071779680" LOGICAL 0/17E1A20 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:53.952 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/0:0] LOG: released logical replication slot "pg_16498_sync_16473_7441169425071779680" 2024-11-25 11:06:53.952 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/0:0] STATEMENT: START_REPLICATION SLOT "pg_16498_sync_16473_7441169425071779680" LOGICAL 0/17E1A20 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:53.952 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16498_sync_16473_7441169425071779680 WAIT 2024-11-25 11:06:53.952 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16498_sync_16473_7441169425071779680 WAIT 2024-11-25 11:06:53.952 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/0:0] LOG: acquired logical replication slot "pg_16498_sync_16473_7441169425071779680" 2024-11-25 11:06:53.952 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][23/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16498_sync_16473_7441169425071779680 WAIT 2024-11-25 11:06:53.953 GMT [6376][walsender] [pg_16498_sync_16473_7441169425071779680][:0] LOG: disconnection: session time: 0:00:00.049 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:54.122 GMT [1292][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:54.124 GMT [1292][walsender] [[unknown]][28/35:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:54.124 GMT [1292][walsender] [[unknown]][28/35:0] LOG: replication connection authorized: user=SYSTEM application_name=sub2 2024-11-25 11:06:54.129 GMT [1292][walsender] [sub2][28/36:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:54.130 GMT [1292][walsender] [sub2][28/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-25 11:06:54.130 GMT [1292][walsender] [sub2][28/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-25 11:06:54.130 GMT [1292][walsender] [sub2][28/0:0] LOG: received replication command: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:54.130 GMT [1292][walsender] [sub2][28/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:54.130 GMT [1292][walsender] [sub2][28/0:0] LOG: acquired logical replication slot "sub2" 2024-11-25 11:06:54.130 GMT [1292][walsender] [sub2][28/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:54.130 GMT [1292][walsender] [sub2][28/0:0] LOG: 0/17AF688 has been already streamed, forwarding to 0/17E1758 2024-11-25 11:06:54.130 GMT [1292][walsender] [sub2][28/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:54.131 GMT [1292][walsender] [sub2][28/0:0] LOG: starting logical decoding for slot "sub2" 2024-11-25 11:06:54.131 GMT [1292][walsender] [sub2][28/0:0] DETAIL: Streaming transactions committing after 0/17E1758, reading WAL from 0/17A8510. 2024-11-25 11:06:54.131 GMT [1292][walsender] [sub2][28/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:54.131 GMT [1292][walsender] [sub2][28/0:0] LOG: logical decoding found consistent point at 0/17A8510 2024-11-25 11:06:54.131 GMT [1292][walsender] [sub2][28/0:0] DETAIL: There are no running transactions. 2024-11-25 11:06:54.131 GMT [1292][walsender] [sub2][28/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:54.137 GMT [1292][walsender] [sub2][28/39:0] LOG: could not send data to client: An existing connection was forcibly closed by the remote host. 2024-11-25 11:06:54.137 GMT [1292][walsender] [sub2][28/39:0] CONTEXT: slot "sub2", output plugin "pgoutput", in the change callback, associated LSN 0/17E1868 2024-11-25 11:06:54.137 GMT [1292][walsender] [sub2][28/39:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:54.137 GMT [1292][walsender] [sub2][28/0:0] LOG: released logical replication slot "sub2" 2024-11-25 11:06:54.137 GMT [1292][walsender] [sub2][:0] LOG: disconnection: session time: 0:00:00.040 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:54.570 GMT [1192][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:54.572 GMT [1192][walsender] [[unknown]][22/9:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:54.572 GMT [1192][walsender] [[unknown]][22/9:0] LOG: replication connection authorized: user=SYSTEM application_name=sub2 2024-11-25 11:06:54.580 GMT [1192][walsender] [sub2][22/10:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:54.580 GMT [1192][walsender] [sub2][22/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-25 11:06:54.580 GMT [1192][walsender] [sub2][22/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-25 11:06:54.580 GMT [1192][walsender] [sub2][22/0:0] LOG: received replication command: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:54.580 GMT [1192][walsender] [sub2][22/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:54.580 GMT [1192][walsender] [sub2][22/0:0] LOG: acquired logical replication slot "sub2" 2024-11-25 11:06:54.580 GMT [1192][walsender] [sub2][22/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:54.580 GMT [1192][walsender] [sub2][22/0:0] LOG: 0/17AF688 has been already streamed, forwarding to 0/17E1758 2024-11-25 11:06:54.580 GMT [1192][walsender] [sub2][22/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:54.581 GMT [1192][walsender] [sub2][22/0:0] LOG: starting logical decoding for slot "sub2" 2024-11-25 11:06:54.581 GMT [1192][walsender] [sub2][22/0:0] DETAIL: Streaming transactions committing after 0/17E1758, reading WAL from 0/17A8510. 2024-11-25 11:06:54.581 GMT [1192][walsender] [sub2][22/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:54.581 GMT [1192][walsender] [sub2][22/0:0] LOG: logical decoding found consistent point at 0/17A8510 2024-11-25 11:06:54.581 GMT [1192][walsender] [sub2][22/0:0] DETAIL: There are no running transactions. 2024-11-25 11:06:54.581 GMT [1192][walsender] [sub2][22/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:54.586 GMT [1192][walsender] [sub2][22/13:0] LOG: could not send data to client: An existing connection was forcibly closed by the remote host. 2024-11-25 11:06:54.586 GMT [1192][walsender] [sub2][22/13:0] CONTEXT: slot "sub2", output plugin "pgoutput", in the change callback, associated LSN 0/17E1868 2024-11-25 11:06:54.586 GMT [1192][walsender] [sub2][22/13:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:54.586 GMT [1192][walsender] [sub2][22/0:0] LOG: released logical replication slot "sub2" 2024-11-25 11:06:54.586 GMT [1192][walsender] [sub2][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:55.125 GMT [2540][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:55.133 GMT [2540][walsender] [[unknown]][24/8:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:55.133 GMT [2540][walsender] [[unknown]][24/8:0] LOG: replication connection authorized: user=SYSTEM application_name=sub2 2024-11-25 11:06:55.148 GMT [2540][walsender] [sub2][24/9:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:55.149 GMT [2540][walsender] [sub2][24/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-25 11:06:55.149 GMT [2540][walsender] [sub2][24/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-25 11:06:55.149 GMT [2540][walsender] [sub2][24/0:0] LOG: received replication command: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:55.149 GMT [2540][walsender] [sub2][24/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:55.149 GMT [2540][walsender] [sub2][24/0:0] LOG: acquired logical replication slot "sub2" 2024-11-25 11:06:55.149 GMT [2540][walsender] [sub2][24/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:55.149 GMT [2540][walsender] [sub2][24/0:0] LOG: 0/17AF688 has been already streamed, forwarding to 0/17E1758 2024-11-25 11:06:55.149 GMT [2540][walsender] [sub2][24/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:55.149 GMT [2540][walsender] [sub2][24/0:0] LOG: starting logical decoding for slot "sub2" 2024-11-25 11:06:55.149 GMT [2540][walsender] [sub2][24/0:0] DETAIL: Streaming transactions committing after 0/17E1758, reading WAL from 0/17A8510. 2024-11-25 11:06:55.149 GMT [2540][walsender] [sub2][24/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:55.150 GMT [2540][walsender] [sub2][24/0:0] LOG: logical decoding found consistent point at 0/17A8510 2024-11-25 11:06:55.150 GMT [2540][walsender] [sub2][24/0:0] DETAIL: There are no running transactions. 2024-11-25 11:06:55.150 GMT [2540][walsender] [sub2][24/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_all"') 2024-11-25 11:06:55.326 GMT [5592][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:55.328 GMT [5592][walsender] [[unknown]][25/6:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:55.328 GMT [5592][walsender] [[unknown]][25/6:0] LOG: replication connection authorized: user=SYSTEM application_name=sub2 2024-11-25 11:06:55.331 GMT [5592][walsender] [sub2][25/7:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:55.331 GMT [5592][walsender] [sub2][25/8:0] LOG: statement: SELECT t.pubname FROM pg_catalog.pg_publication t WHERE t.pubname IN ('pub_lower_level', 'pub_all') 2024-11-25 11:06:55.335 GMT [5592][walsender] [sub2][25/9: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 ( 'pub_lower_level', 'pub_all' )) AS gpt ON gpt.relid = c.oid 2024-11-25 11:06:55.342 GMT [5592][walsender] [sub2][:0] LOG: disconnection: session time: 0:00:00.018 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:55.344 GMT [2540][walsender] [sub2][24/0:0] LOG: released logical replication slot "sub2" 2024-11-25 11:06:55.344 GMT [2540][walsender] [sub2][:0] LOG: disconnection: session time: 0:00:00.233 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:55.404 GMT [6464][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:55.405 GMT [6464][walsender] [[unknown]][26/8:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:55.405 GMT [6464][walsender] [[unknown]][26/8:0] LOG: replication connection authorized: user=SYSTEM application_name=sub2 2024-11-25 11:06:55.412 GMT [6464][walsender] [sub2][26/9:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:55.413 GMT [6464][walsender] [sub2][26/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-25 11:06:55.413 GMT [6464][walsender] [sub2][26/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-25 11:06:55.413 GMT [6464][walsender] [sub2][26/0:0] LOG: received replication command: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.413 GMT [6464][walsender] [sub2][26/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.413 GMT [6464][walsender] [sub2][26/0:0] LOG: acquired logical replication slot "sub2" 2024-11-25 11:06:55.413 GMT [6464][walsender] [sub2][26/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.413 GMT [6464][walsender] [sub2][26/0:0] LOG: 0/17AF688 has been already streamed, forwarding to 0/17E1A20 2024-11-25 11:06:55.413 GMT [6464][walsender] [sub2][26/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.414 GMT [6464][walsender] [sub2][26/0:0] LOG: starting logical decoding for slot "sub2" 2024-11-25 11:06:55.414 GMT [6464][walsender] [sub2][26/0:0] DETAIL: Streaming transactions committing after 0/17E1A20, reading WAL from 0/17E1978. 2024-11-25 11:06:55.414 GMT [6464][walsender] [sub2][26/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.414 GMT [6464][walsender] [sub2][26/0:0] LOG: logical decoding found consistent point at 0/17E1978 2024-11-25 11:06:55.414 GMT [6464][walsender] [sub2][26/0:0] DETAIL: There are no running transactions. 2024-11-25 11:06:55.414 GMT [6464][walsender] [sub2][26/0:0] STATEMENT: START_REPLICATION SLOT "sub2" LOGICAL 0/17AF688 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.487 GMT [4804][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:55.488 GMT [4804][walsender] [[unknown]][27/10:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:55.488 GMT [4804][walsender] [[unknown]][27/10:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16420_sync_16496_7441169425071779680 2024-11-25 11:06:55.514 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/11:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:55.515 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/12:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-11-25 11:06:55.515 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/12:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16420_sync_16496_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:55.515 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/12:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16420_sync_16496_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:55.522 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/12:0] LOG: logical decoding found consistent point at 0/17E1A58 2024-11-25 11:06:55.522 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/12:0] DETAIL: There are no running transactions. 2024-11-25 11:06:55.522 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/12:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16420_sync_16496_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:55.523 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/12:0] LOG: released logical replication slot "pg_16420_sync_16496_7441169425071779680" 2024-11-25 11:06:55.523 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/12:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16420_sync_16496_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:55.524 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/12: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-11-25 11:06:55.529 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/12: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 = 16470 AND c.oid = gpt.relid AND p.pubname IN ( 'pub_lower_level', 'pub_all' ) 2024-11-25 11:06:55.531 GMT [4408][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:55.532 GMT [4408][walsender] [[unknown]][29/8:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:55.532 GMT [4408][walsender] [[unknown]][29/8:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16420_sync_16478_7441169425071779680 2024-11-25 11:06:55.534 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/12:0] LOG: statement: SELECT a.attnum, a.attname, a.atttypid, a.attnum = ANY(i.indkey), a.attgenerated != '' FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_index i ON (i.indexrelid = pg_get_replica_identity_index(16470)) WHERE a.attnum > 0::pg_catalog.int2 AND NOT a.attisdropped AND a.attrelid = 16470 ORDER BY a.attnum 2024-11-25 11:06:55.536 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/12: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 = 16470 AND p.pubname IN ( 'pub_lower_level', 'pub_all' ) 2024-11-25 11:06:55.538 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/12:0] LOG: statement: COPY (SELECT a FROM public.tab4) TO STDOUT 2024-11-25 11:06:55.540 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/12:0] LOG: statement: COMMIT 2024-11-25 11:06:55.541 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/0:0] LOG: received replication command: START_REPLICATION SLOT "pg_16420_sync_16496_7441169425071779680" LOGICAL 0/17E1A90 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.541 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16496_7441169425071779680" LOGICAL 0/17E1A90 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.541 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/0:0] LOG: acquired logical replication slot "pg_16420_sync_16496_7441169425071779680" 2024-11-25 11:06:55.541 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16496_7441169425071779680" LOGICAL 0/17E1A90 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.541 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/0:0] LOG: starting logical decoding for slot "pg_16420_sync_16496_7441169425071779680" 2024-11-25 11:06:55.541 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/0:0] DETAIL: Streaming transactions committing after 0/17E1A90, reading WAL from 0/17E1A58. 2024-11-25 11:06:55.541 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16496_7441169425071779680" LOGICAL 0/17E1A90 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.541 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/0:0] LOG: logical decoding found consistent point at 0/17E1A58 2024-11-25 11:06:55.541 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/0:0] DETAIL: There are no running transactions. 2024-11-25 11:06:55.541 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16496_7441169425071779680" LOGICAL 0/17E1A90 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.541 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/0:0] LOG: released logical replication slot "pg_16420_sync_16496_7441169425071779680" 2024-11-25 11:06:55.541 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16496_7441169425071779680" LOGICAL 0/17E1A90 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.541 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16420_sync_16496_7441169425071779680 WAIT 2024-11-25 11:06:55.541 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16420_sync_16496_7441169425071779680 WAIT 2024-11-25 11:06:55.541 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/0:0] LOG: acquired logical replication slot "pg_16420_sync_16496_7441169425071779680" 2024-11-25 11:06:55.541 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][27/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16420_sync_16496_7441169425071779680 WAIT 2024-11-25 11:06:55.543 GMT [4804][walsender] [pg_16420_sync_16496_7441169425071779680][:0] LOG: disconnection: session time: 0:00:00.058 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:55.548 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/9:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:55.549 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/10:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-11-25 11:06:55.549 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/10:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16420_sync_16478_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:55.549 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/10:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16420_sync_16478_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:55.563 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/10:0] LOG: logical decoding found consistent point at 0/17E1BA8 2024-11-25 11:06:55.563 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/10:0] DETAIL: There are no running transactions. 2024-11-25 11:06:55.563 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/10:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16420_sync_16478_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:55.568 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/10:0] LOG: released logical replication slot "pg_16420_sync_16478_7441169425071779680" 2024-11-25 11:06:55.568 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/10:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16420_sync_16478_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:55.568 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/10: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-11-25 11:06:55.572 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/10: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 = 16456 AND c.oid = gpt.relid AND p.pubname IN ( 'pub_lower_level', 'pub_all' ) 2024-11-25 11:06:55.577 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/10:0] LOG: statement: SELECT a.attnum, a.attname, a.atttypid, a.attnum = ANY(i.indkey), a.attgenerated != '' FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_index i ON (i.indexrelid = pg_get_replica_identity_index(16456)) WHERE a.attnum > 0::pg_catalog.int2 AND NOT a.attisdropped AND a.attrelid = 16456 ORDER BY a.attnum 2024-11-25 11:06:55.579 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/10: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 = 16456 AND p.pubname IN ( 'pub_lower_level', 'pub_all' ) 2024-11-25 11:06:55.581 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/10:0] LOG: statement: COPY (SELECT a, b FROM public.tab3) TO STDOUT 2024-11-25 11:06:55.582 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/10:0] LOG: statement: COMMIT 2024-11-25 11:06:55.609 GMT [2628][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:55.617 GMT [2628][walsender] [[unknown]][31/7:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:55.617 GMT [2628][walsender] [[unknown]][31/7:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16420_sync_16445_7441169425071779680 2024-11-25 11:06:55.624 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/8:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:55.631 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/9:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-11-25 11:06:55.632 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/9:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16420_sync_16445_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:55.632 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/9:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16420_sync_16445_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:55.645 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/9:0] LOG: logical decoding found consistent point at 0/17E1BE0 2024-11-25 11:06:55.645 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/9:0] DETAIL: There are no running transactions. 2024-11-25 11:06:55.645 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/9:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16420_sync_16445_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:55.646 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/9:0] LOG: released logical replication slot "pg_16420_sync_16445_7441169425071779680" 2024-11-25 11:06:55.646 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/9:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16420_sync_16445_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:55.647 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/9: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-11-25 11:06:55.651 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/9: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 = 16386 AND c.oid = gpt.relid AND p.pubname IN ( 'pub_lower_level', 'pub_all' ) 2024-11-25 11:06:55.656 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/9:0] LOG: statement: SELECT a.attnum, a.attname, a.atttypid, a.attnum = ANY(i.indkey), a.attgenerated != '' FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_index i ON (i.indexrelid = pg_get_replica_identity_index(16386)) WHERE a.attnum > 0::pg_catalog.int2 AND NOT a.attisdropped AND a.attrelid = 16386 ORDER BY a.attnum 2024-11-25 11:06:55.658 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/9: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 = 16386 AND p.pubname IN ( 'pub_lower_level', 'pub_all' ) 2024-11-25 11:06:55.660 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/9:0] LOG: statement: COPY (SELECT a, b FROM public.tab1) TO STDOUT 2024-11-25 11:06:55.662 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/9:0] LOG: statement: COMMIT 2024-11-25 11:06:55.663 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/0:0] LOG: received replication command: START_REPLICATION SLOT "pg_16420_sync_16478_7441169425071779680" LOGICAL 0/17E1BE0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.663 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16478_7441169425071779680" LOGICAL 0/17E1BE0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.663 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/0:0] LOG: acquired logical replication slot "pg_16420_sync_16478_7441169425071779680" 2024-11-25 11:06:55.663 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16478_7441169425071779680" LOGICAL 0/17E1BE0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.663 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/0:0] LOG: starting logical decoding for slot "pg_16420_sync_16478_7441169425071779680" 2024-11-25 11:06:55.663 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/0:0] DETAIL: Streaming transactions committing after 0/17E1BE0, reading WAL from 0/17E1BA8. 2024-11-25 11:06:55.663 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16478_7441169425071779680" LOGICAL 0/17E1BE0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.663 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/0:0] LOG: logical decoding found consistent point at 0/17E1BA8 2024-11-25 11:06:55.663 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/0:0] DETAIL: There are no running transactions. 2024-11-25 11:06:55.663 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16478_7441169425071779680" LOGICAL 0/17E1BE0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.665 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/0:0] LOG: released logical replication slot "pg_16420_sync_16478_7441169425071779680" 2024-11-25 11:06:55.665 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16478_7441169425071779680" LOGICAL 0/17E1BE0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.665 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16420_sync_16478_7441169425071779680 WAIT 2024-11-25 11:06:55.665 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16420_sync_16478_7441169425071779680 WAIT 2024-11-25 11:06:55.665 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/0:0] LOG: acquired logical replication slot "pg_16420_sync_16478_7441169425071779680" 2024-11-25 11:06:55.665 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][29/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16420_sync_16478_7441169425071779680 WAIT 2024-11-25 11:06:55.666 GMT [4408][walsender] [pg_16420_sync_16478_7441169425071779680][:0] LOG: disconnection: session time: 0:00:00.138 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:55.666 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/0:0] LOG: received replication command: START_REPLICATION SLOT "pg_16420_sync_16445_7441169425071779680" LOGICAL 0/17E1C18 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.666 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16445_7441169425071779680" LOGICAL 0/17E1C18 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.667 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/0:0] LOG: acquired logical replication slot "pg_16420_sync_16445_7441169425071779680" 2024-11-25 11:06:55.667 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16445_7441169425071779680" LOGICAL 0/17E1C18 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.667 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/0:0] LOG: starting logical decoding for slot "pg_16420_sync_16445_7441169425071779680" 2024-11-25 11:06:55.667 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/0:0] DETAIL: Streaming transactions committing after 0/17E1C18, reading WAL from 0/17E1BE0. 2024-11-25 11:06:55.667 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16445_7441169425071779680" LOGICAL 0/17E1C18 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.667 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/0:0] LOG: logical decoding found consistent point at 0/17E1BE0 2024-11-25 11:06:55.667 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/0:0] DETAIL: There are no running transactions. 2024-11-25 11:06:55.667 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16445_7441169425071779680" LOGICAL 0/17E1C18 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.667 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/0:0] LOG: released logical replication slot "pg_16420_sync_16445_7441169425071779680" 2024-11-25 11:06:55.667 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16445_7441169425071779680" LOGICAL 0/17E1C18 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.667 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16420_sync_16445_7441169425071779680 WAIT 2024-11-25 11:06:55.667 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16420_sync_16445_7441169425071779680 WAIT 2024-11-25 11:06:55.667 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/0:0] LOG: acquired logical replication slot "pg_16420_sync_16445_7441169425071779680" 2024-11-25 11:06:55.667 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][31/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16420_sync_16445_7441169425071779680 WAIT 2024-11-25 11:06:55.669 GMT [2628][walsender] [pg_16420_sync_16445_7441169425071779680][:0] LOG: disconnection: session time: 0:00:00.070 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:55.767 GMT [2184][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:55.768 GMT [2184][walsender] [[unknown]][23/38:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:55.768 GMT [2184][walsender] [[unknown]][23/38:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16420_sync_16469_7441169425071779680 2024-11-25 11:06:55.774 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/39:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:55.775 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/40:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-11-25 11:06:55.775 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/40:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16420_sync_16469_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:55.775 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/40:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16420_sync_16469_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:55.781 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/40:0] LOG: logical decoding found consistent point at 0/17E1C18 2024-11-25 11:06:55.781 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/40:0] DETAIL: There are no running transactions. 2024-11-25 11:06:55.781 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/40:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16420_sync_16469_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:55.782 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/40:0] LOG: released logical replication slot "pg_16420_sync_16469_7441169425071779680" 2024-11-25 11:06:55.782 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/40:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16420_sync_16469_7441169425071779680" LOGICAL pgoutput (SNAPSHOT 'use') 2024-11-25 11:06:55.782 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/40: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-11-25 11:06:55.786 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/40: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 ( 'pub_lower_level', 'pub_all' ) 2024-11-25 11:06:55.792 GMT [5004][walsender] [sub_viaroot][30/0:0] PANIC: could not open file "pg_logical/snapshots/0-17E1C18.snap": No such file or directory 2024-11-25 11:06:55.792 GMT [5004][walsender] [sub_viaroot][30/0:0] STATEMENT: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') abort() has been called2024-11-25 11:06:55.793 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/40:0] LOG: statement: SELECT a.attnum, a.attname, a.atttypid, a.attnum = ANY(i.indkey), a.attgenerated != '' FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_index i ON (i.indexrelid = pg_get_replica_identity_index(16434)) WHERE a.attnum > 0::pg_catalog.int2 AND NOT a.attisdropped AND a.attrelid = 16434 ORDER BY a.attnum 2024-11-25 11:06:55.795 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/40: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 ( 'pub_lower_level', 'pub_all' ) 2024-11-25 11:06:55.797 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/40:0] LOG: statement: COPY (SELECT a, b FROM public.tab2) TO STDOUT 2024-11-25 11:06:55.829 GMT [4128][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:55.830 GMT [4128][walsender] [[unknown]][28/40:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:55.831 GMT [4128][walsender] [[unknown]][28/40:0] LOG: replication connection authorized: user=SYSTEM application_name=sub_viaroot 2024-11-25 11:06:55.938 GMT [4128][walsender] [sub_viaroot][28/41:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:55.938 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/40:0] LOG: statement: COMMIT 2024-11-25 11:06:55.939 GMT [4128][walsender] [sub_viaroot][28/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-25 11:06:55.939 GMT [4128][walsender] [sub_viaroot][28/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-25 11:06:55.939 GMT [4128][walsender] [sub_viaroot][28/0:0] LOG: received replication command: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:55.939 GMT [4128][walsender] [sub_viaroot][28/0:0] STATEMENT: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:55.939 GMT [4128][walsender] [sub_viaroot][28/0:0] ERROR: replication slot "sub_viaroot" is active for PID 5004 2024-11-25 11:06:55.939 GMT [4128][walsender] [sub_viaroot][28/0:0] STATEMENT: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:55.940 GMT [4128][walsender] [sub_viaroot][:0] LOG: disconnection: session time: 0:00:00.114 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:55.942 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/0:0] LOG: received replication command: START_REPLICATION SLOT "pg_16420_sync_16469_7441169425071779680" LOGICAL 0/17E1C50 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.942 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16469_7441169425071779680" LOGICAL 0/17E1C50 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.942 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/0:0] LOG: acquired logical replication slot "pg_16420_sync_16469_7441169425071779680" 2024-11-25 11:06:55.942 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16469_7441169425071779680" LOGICAL 0/17E1C50 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.943 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/0:0] LOG: starting logical decoding for slot "pg_16420_sync_16469_7441169425071779680" 2024-11-25 11:06:55.943 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/0:0] DETAIL: Streaming transactions committing after 0/17E1C50, reading WAL from 0/17E1C18. 2024-11-25 11:06:55.943 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16469_7441169425071779680" LOGICAL 0/17E1C50 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.943 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/0:0] LOG: logical decoding found consistent point at 0/17E1C18 2024-11-25 11:06:55.943 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/0:0] DETAIL: There are no running transactions. 2024-11-25 11:06:55.943 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16469_7441169425071779680" LOGICAL 0/17E1C50 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.943 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/0:0] LOG: released logical replication slot "pg_16420_sync_16469_7441169425071779680" 2024-11-25 11:06:55.943 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/0:0] STATEMENT: START_REPLICATION SLOT "pg_16420_sync_16469_7441169425071779680" LOGICAL 0/17E1C50 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_lower_level","pub_all"') 2024-11-25 11:06:55.943 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16420_sync_16469_7441169425071779680 WAIT 2024-11-25 11:06:55.943 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16420_sync_16469_7441169425071779680 WAIT 2024-11-25 11:06:55.943 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/0:0] LOG: acquired logical replication slot "pg_16420_sync_16469_7441169425071779680" 2024-11-25 11:06:55.943 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][23/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16420_sync_16469_7441169425071779680 WAIT 2024-11-25 11:06:55.946 GMT [2184][walsender] [pg_16420_sync_16469_7441169425071779680][:0] LOG: disconnection: session time: 0:00:00.184 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:56.398 GMT [4892][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:56.399 GMT [4892][walsender] [[unknown]][22/14:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:56.399 GMT [4892][walsender] [[unknown]][22/14:0] LOG: replication connection authorized: user=SYSTEM application_name=sub_viaroot 2024-11-25 11:06:56.402 GMT [4892][walsender] [sub_viaroot][22/15:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:56.402 GMT [4892][walsender] [sub_viaroot][22/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-25 11:06:56.402 GMT [4892][walsender] [sub_viaroot][22/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-25 11:06:56.402 GMT [4892][walsender] [sub_viaroot][22/0:0] LOG: received replication command: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:56.402 GMT [4892][walsender] [sub_viaroot][22/0:0] STATEMENT: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:56.402 GMT [4892][walsender] [sub_viaroot][22/0:0] ERROR: replication slot "sub_viaroot" is active for PID 5004 2024-11-25 11:06:56.402 GMT [4892][walsender] [sub_viaroot][22/0:0] STATEMENT: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:56.403 GMT [4892][walsender] [sub_viaroot][:0] LOG: disconnection: session time: 0:00:00.007 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:56.485 GMT [936][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:56.486 GMT [936][client backend] [[unknown]][8/17:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:56.486 GMT [936][client backend] [[unknown]][8/17:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:56.496 GMT [936][client backend] [013_partition.pl][8/18:0] LOG: statement: INSERT INTO tab1 VALUES (1), (0) 2024-11-25 11:06:56.499 GMT [936][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:56.618 GMT [6476][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:56.619 GMT [6476][client backend] [[unknown]][9/17:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:56.619 GMT [6476][client backend] [[unknown]][9/17:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:56.621 GMT [6476][client backend] [013_partition.pl][9/18:0] LOG: statement: INSERT INTO tab1_1 (a) VALUES (3) 2024-11-25 11:06:56.623 GMT [6476][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:56.686 GMT [2628][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:56.688 GMT [2628][client backend] [[unknown]][0/19:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:56.688 GMT [2628][client backend] [[unknown]][0/19:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:56.698 GMT [2628][client backend] [013_partition.pl][0/20:0] LOG: statement: INSERT INTO tab1_2 VALUES (5) 2024-11-25 11:06:56.699 GMT [2628][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:56.763 GMT [5620][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:56.765 GMT [5620][client backend] [[unknown]][1/19:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:56.765 GMT [5620][client backend] [[unknown]][1/19:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:56.768 GMT [5620][client backend] [013_partition.pl][1/20:0] LOG: statement: INSERT INTO tab2 VALUES (0), (3), (5) 2024-11-25 11:06:56.770 GMT [5620][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:56.874 GMT [6728][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:56.875 GMT [6728][client backend] [[unknown]][2/19:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:56.875 GMT [6728][client backend] [[unknown]][2/19:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:56.889 GMT [6728][client backend] [013_partition.pl][2/20:0] LOG: statement: INSERT INTO tab3 VALUES (1), (0), (3), (5) 2024-11-25 11:06:56.891 GMT [6728][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.020 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:56.893 GMT [4120][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:56.896 GMT [4120][walsender] [[unknown]][25/10:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:56.896 GMT [4120][walsender] [[unknown]][25/10:0] LOG: replication connection authorized: user=SYSTEM application_name=sub_viaroot 2024-11-25 11:06:56.900 GMT [4120][walsender] [sub_viaroot][25/11:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:56.901 GMT [4120][walsender] [sub_viaroot][25/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-25 11:06:56.901 GMT [4120][walsender] [sub_viaroot][25/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-25 11:06:56.901 GMT [4120][walsender] [sub_viaroot][25/0:0] LOG: received replication command: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:56.901 GMT [4120][walsender] [sub_viaroot][25/0:0] STATEMENT: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:56.901 GMT [4120][walsender] [sub_viaroot][25/0:0] ERROR: replication slot "sub_viaroot" is active for PID 5004 2024-11-25 11:06:56.901 GMT [4120][walsender] [sub_viaroot][25/0:0] STATEMENT: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:56.901 GMT [4120][walsender] [sub_viaroot][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:56.962 GMT [3744][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:56.968 GMT [3744][client backend] [[unknown]][3/19:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:56.968 GMT [3744][client backend] [[unknown]][3/19:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:56.976 GMT [3744][client backend] [013_partition.pl][3/20:0] LOG: statement: INSERT INTO tab4 VALUES (0) 2024-11-25 11:06:56.979 GMT [3744][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:57.073 GMT [1584][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:57.077 GMT [1584][client backend] [[unknown]][4/19:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:57.077 GMT [1584][client backend] [[unknown]][4/19:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:57.099 GMT [1584][client backend] [013_partition.pl][4/20:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-25 11:06:57.103 GMT [1584][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.046 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:57.170 GMT [1780][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:57.172 GMT [1780][client backend] [[unknown]][5/19:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:57.172 GMT [1780][client backend] [[unknown]][5/19:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:57.174 GMT [1780][client backend] [013_partition.pl][5/20:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-25 11:06:57.178 GMT [1780][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:57.335 GMT [6492][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:57.336 GMT [6492][client backend] [[unknown]][6/19:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:57.336 GMT [6492][client backend] [[unknown]][6/19:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:57.340 GMT [6492][client backend] [013_partition.pl][6/20:0] LOG: statement: SELECT '0/17E2448' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub_viaroot', 'walreceiver') 2024-11-25 11:06:57.351 GMT [6492][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:57.415 GMT [4740][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:57.437 GMT [4740][walsender] [[unknown]][24/13:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:57.437 GMT [4740][walsender] [[unknown]][24/13:0] LOG: replication connection authorized: user=SYSTEM application_name=sub_viaroot 2024-11-25 11:06:57.443 GMT [4740][walsender] [sub_viaroot][24/14:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:57.444 GMT [4740][walsender] [sub_viaroot][24/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-25 11:06:57.444 GMT [4740][walsender] [sub_viaroot][24/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-25 11:06:57.444 GMT [4740][walsender] [sub_viaroot][24/0:0] LOG: received replication command: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:57.444 GMT [4740][walsender] [sub_viaroot][24/0:0] STATEMENT: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:57.444 GMT [4740][walsender] [sub_viaroot][24/0:0] ERROR: replication slot "sub_viaroot" is active for PID 5004 2024-11-25 11:06:57.444 GMT [4740][walsender] [sub_viaroot][24/0:0] STATEMENT: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:57.444 GMT [4740][walsender] [sub_viaroot][:0] LOG: disconnection: session time: 0:00:00.032 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:57.586 GMT [1528][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:57.587 GMT [1528][client backend] [[unknown]][7/19:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:57.587 GMT [1528][client backend] [[unknown]][7/19:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:57.590 GMT [1528][client backend] [013_partition.pl][7/20:0] LOG: statement: SELECT '0/17E2448' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub_viaroot', 'walreceiver') 2024-11-25 11:06:57.599 GMT [1528][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:57.807 GMT [1896][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:57.809 GMT [1896][client backend] [[unknown]][8/19:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:57.809 GMT [1896][client backend] [[unknown]][8/19:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:57.811 GMT [1896][client backend] [013_partition.pl][8/20:0] LOG: statement: SELECT '0/17E2448' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub_viaroot', 'walreceiver') 2024-11-25 11:06:57.819 GMT [1896][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.028 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:57.895 GMT [2656][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:57.898 GMT [2656][walsender] [[unknown]][27/13:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:57.898 GMT [2656][walsender] [[unknown]][27/13:0] LOG: replication connection authorized: user=SYSTEM application_name=sub_viaroot 2024-11-25 11:06:57.901 GMT [2656][walsender] [sub_viaroot][27/14:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:57.902 GMT [2656][walsender] [sub_viaroot][27/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-25 11:06:57.902 GMT [2656][walsender] [sub_viaroot][27/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-25 11:06:57.902 GMT [2656][walsender] [sub_viaroot][27/0:0] LOG: received replication command: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:57.902 GMT [2656][walsender] [sub_viaroot][27/0:0] STATEMENT: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:57.902 GMT [2656][walsender] [sub_viaroot][27/0:0] ERROR: replication slot "sub_viaroot" is active for PID 5004 2024-11-25 11:06:57.902 GMT [2656][walsender] [sub_viaroot][27/0:0] STATEMENT: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:57.902 GMT [2656][walsender] [sub_viaroot][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:58.073 GMT [6472][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:58.075 GMT [6472][client backend] [[unknown]][9/19:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:58.075 GMT [6472][client backend] [[unknown]][9/19:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:58.079 GMT [6472][client backend] [013_partition.pl][9/20:0] LOG: statement: SELECT '0/17E2448' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub_viaroot', 'walreceiver') 2024-11-25 11:06:58.085 GMT [6472][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:58.283 GMT [2180][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:58.285 GMT [2180][client backend] [[unknown]][0/21:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:58.285 GMT [2180][client backend] [[unknown]][0/21:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:58.287 GMT [2180][client backend] [013_partition.pl][0/22:0] LOG: statement: SELECT '0/17E2448' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub_viaroot', 'walreceiver') 2024-11-25 11:06:58.293 GMT [2180][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:58.400 GMT [6632][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:58.401 GMT [6632][walsender] [[unknown]][29/11:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:58.401 GMT [6632][walsender] [[unknown]][29/11:0] LOG: replication connection authorized: user=SYSTEM application_name=sub_viaroot 2024-11-25 11:06:58.404 GMT [6632][walsender] [sub_viaroot][29/12:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:58.404 GMT [6632][walsender] [sub_viaroot][29/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-25 11:06:58.404 GMT [6632][walsender] [sub_viaroot][29/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-25 11:06:58.404 GMT [6632][walsender] [sub_viaroot][29/0:0] LOG: received replication command: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:58.404 GMT [6632][walsender] [sub_viaroot][29/0:0] STATEMENT: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:58.404 GMT [6632][walsender] [sub_viaroot][29/0:0] ERROR: replication slot "sub_viaroot" is active for PID 5004 2024-11-25 11:06:58.404 GMT [6632][walsender] [sub_viaroot][29/0:0] STATEMENT: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:58.405 GMT [6632][walsender] [sub_viaroot][:0] LOG: disconnection: session time: 0:00:00.008 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:58.536 GMT [1528][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:58.537 GMT [1528][client backend] [[unknown]][1/21:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:58.537 GMT [1528][client backend] [[unknown]][1/21:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:58.540 GMT [1528][client backend] [013_partition.pl][1/22:0] LOG: statement: SELECT '0/17E2448' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub_viaroot', 'walreceiver') 2024-11-25 11:06:58.547 GMT [1528][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:58.743 GMT [2876][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:58.745 GMT [2876][client backend] [[unknown]][2/21:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:58.745 GMT [2876][client backend] [[unknown]][2/21:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:58.774 GMT [2876][client backend] [013_partition.pl][2/22:0] LOG: statement: SELECT '0/17E2448' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub_viaroot', 'walreceiver') 2024-11-25 11:06:58.783 GMT [2876][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.042 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:58.938 GMT [6572][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:58.939 GMT [6572][walsender] [[unknown]][31/10:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:58.939 GMT [6572][walsender] [[unknown]][31/10:0] LOG: replication connection authorized: user=SYSTEM application_name=sub_viaroot 2024-11-25 11:06:58.946 GMT [6572][walsender] [sub_viaroot][31/11:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:58.947 GMT [6572][walsender] [sub_viaroot][31/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-25 11:06:58.947 GMT [6572][walsender] [sub_viaroot][31/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-25 11:06:58.947 GMT [6572][walsender] [sub_viaroot][31/0:0] LOG: received replication command: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:58.947 GMT [6572][walsender] [sub_viaroot][31/0:0] STATEMENT: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:58.947 GMT [6572][walsender] [sub_viaroot][31/0:0] ERROR: replication slot "sub_viaroot" is active for PID 5004 2024-11-25 11:06:58.947 GMT [6572][walsender] [sub_viaroot][31/0:0] STATEMENT: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:58.947 GMT [6572][walsender] [sub_viaroot][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:58.983 GMT [7020][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:58.985 GMT [7020][client backend] [[unknown]][3/21:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:58.985 GMT [7020][client backend] [[unknown]][3/21:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:58.987 GMT [7020][client backend] [013_partition.pl][3/22:0] LOG: statement: SELECT '0/17E2448' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub_viaroot', 'walreceiver') 2024-11-25 11:06:58.996 GMT [7020][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:59.208 GMT [5948][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:59.209 GMT [5948][client backend] [[unknown]][4/21:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:59.209 GMT [5948][client backend] [[unknown]][4/21:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:59.212 GMT [5948][client backend] [013_partition.pl][4/22:0] LOG: statement: SELECT '0/17E2448' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub_viaroot', 'walreceiver') 2024-11-25 11:06:59.219 GMT [5948][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:59.456 GMT [2636][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:59.457 GMT [2636][client backend] [[unknown]][5/21:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:59.457 GMT [2636][client backend] [[unknown]][5/21:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:59.461 GMT [2636][client backend] [013_partition.pl][5/22:0] LOG: statement: SELECT '0/17E2448' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub_viaroot', 'walreceiver') 2024-11-25 11:06:59.467 GMT [2636][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:59.468 GMT [6712][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:59.469 GMT [6712][walsender] [[unknown]][28/43:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:59.469 GMT [6712][walsender] [[unknown]][28/43:0] LOG: replication connection authorized: user=SYSTEM application_name=sub_viaroot 2024-11-25 11:06:59.475 GMT [6712][walsender] [sub_viaroot][28/44:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:59.475 GMT [6712][walsender] [sub_viaroot][28/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-25 11:06:59.475 GMT [6712][walsender] [sub_viaroot][28/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-25 11:06:59.475 GMT [6712][walsender] [sub_viaroot][28/0:0] LOG: received replication command: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:59.475 GMT [6712][walsender] [sub_viaroot][28/0:0] STATEMENT: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:59.476 GMT [6712][walsender] [sub_viaroot][28/0:0] ERROR: replication slot "sub_viaroot" is active for PID 5004 2024-11-25 11:06:59.476 GMT [6712][walsender] [sub_viaroot][28/0:0] STATEMENT: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:59.476 GMT [6712][walsender] [sub_viaroot][:0] LOG: disconnection: session time: 0:00:00.035 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:59.658 GMT [3424][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:59.659 GMT [3424][client backend] [[unknown]][6/21:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:59.659 GMT [3424][client backend] [[unknown]][6/21:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:59.662 GMT [3424][client backend] [013_partition.pl][6/22:0] LOG: statement: SELECT '0/17E2448' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub_viaroot', 'walreceiver') 2024-11-25 11:06:59.668 GMT [3424][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:59.909 GMT [5420][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:59.910 GMT [5420][client backend] [[unknown]][7/21:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:59.910 GMT [5420][client backend] [[unknown]][7/21:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:06:59.912 GMT [5420][client backend] [013_partition.pl][7/22:0] LOG: statement: SELECT '0/17E2448' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub_viaroot', 'walreceiver') 2024-11-25 11:06:59.919 GMT [5420][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2024-11-25 11:06:59.977 GMT [5748][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:06:59.981 GMT [5748][walsender] [[unknown]][23/41:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:06:59.981 GMT [5748][walsender] [[unknown]][23/41:0] LOG: replication connection authorized: user=SYSTEM application_name=sub_viaroot 2024-11-25 11:06:59.986 GMT [5748][walsender] [sub_viaroot][23/42:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:06:59.987 GMT [5748][walsender] [sub_viaroot][23/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-25 11:06:59.987 GMT [5748][walsender] [sub_viaroot][23/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-25 11:06:59.987 GMT [5748][walsender] [sub_viaroot][23/0:0] LOG: received replication command: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:59.987 GMT [5748][walsender] [sub_viaroot][23/0:0] STATEMENT: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:59.987 GMT [5748][walsender] [sub_viaroot][23/0:0] ERROR: replication slot "sub_viaroot" is active for PID 5004 2024-11-25 11:06:59.987 GMT [5748][walsender] [sub_viaroot][23/0:0] STATEMENT: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:06:59.987 GMT [5748][walsender] [sub_viaroot][:0] LOG: disconnection: session time: 0:00:00.036 user=SYSTEM database=postgres host=[local] 2024-11-25 11:07:00.239 GMT [6848][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:07:00.241 GMT [6848][client backend] [[unknown]][8/21:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:07:00.241 GMT [6848][client backend] [[unknown]][8/21:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:07:00.246 GMT [6848][client backend] [013_partition.pl][8/22:0] LOG: statement: SELECT '0/17E2448' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub_viaroot', 'walreceiver') 2024-11-25 11:07:00.255 GMT [6848][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=SYSTEM database=postgres host=[local] 2024-11-25 11:07:00.447 GMT [6804][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:07:00.448 GMT [6804][walsender] [[unknown]][22/17:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:07:00.448 GMT [6804][walsender] [[unknown]][22/17:0] LOG: replication connection authorized: user=SYSTEM application_name=sub_viaroot 2024-11-25 11:07:00.451 GMT [6804][walsender] [sub_viaroot][22/18:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-25 11:07:00.451 GMT [6804][walsender] [sub_viaroot][22/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-25 11:07:00.451 GMT [6804][walsender] [sub_viaroot][22/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-25 11:07:00.451 GMT [6804][walsender] [sub_viaroot][22/0:0] LOG: received replication command: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:07:00.451 GMT [6804][walsender] [sub_viaroot][22/0:0] STATEMENT: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:07:00.451 GMT [6804][walsender] [sub_viaroot][22/0:0] ERROR: replication slot "sub_viaroot" is active for PID 5004 2024-11-25 11:07:00.451 GMT [6804][walsender] [sub_viaroot][22/0:0] STATEMENT: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:07:00.452 GMT [6804][walsender] [sub_viaroot][:0] LOG: disconnection: session time: 0:00:00.007 user=SYSTEM database=postgres host=[local] 2024-11-25 11:07:00.452 GMT [1704][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:07:00.453 GMT [1704][client backend] [[unknown]][9/21:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:07:00.454 GMT [1704][client backend] [[unknown]][9/21:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:07:00.456 GMT [1704][client backend] [013_partition.pl][9/22:0] LOG: statement: SELECT '0/17E2448' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub_viaroot', 'walreceiver') 2024-11-25 11:07:00.464 GMT [1704][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2024-11-25 11:07:00.663 GMT [1324][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:07:00.673 GMT [1324][client backend] [[unknown]][0/23:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:07:00.673 GMT [1324][client backend] [[unknown]][0/23:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:07:00.679 GMT [1324][client backend] [013_partition.pl][0/24:0] LOG: statement: SELECT '0/17E2448' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub_viaroot', 'walreceiver') 2024-11-25 11:07:00.687 GMT [1324][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.036 user=SYSTEM database=postgres host=[local] 2024-11-25 11:07:00.947 GMT [7020][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-25 11:07:00.949 GMT [7020][client backend] [[unknown]][1/23:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata/pg_hba.conf:117) 2024-11-25 11:07:00.949 GMT [7020][client backend] [[unknown]][1/23:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=013_partition.pl 2024-11-25 11:07:00.952 GMT [7020][client backend] [013_partition.pl][1/24:0] LOG: statement: SELECT '0/17E2448' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub_viaroot', 'walreceiver') 2024-11-25 11:07:00.959 GMT [7020][client backend] [013_partition.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2024-11-25 11:07:00.964 GMT [4328][postmaster] LOG: client backend (PID 5004) was terminated by exception 0xC0000354 2024-11-25 11:07:00.964 GMT [4328][postmaster] DETAIL: Failed process was running: START_REPLICATION SLOT "sub_viaroot" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_viaroot"') 2024-11-25 11:07:00.964 GMT [4328][postmaster] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2024-11-25 11:07:00.964 GMT [4328][postmaster] LOG: terminating any other active server processes 2024-11-25 11:07:01.050 GMT [4328][postmaster] LOG: shutting down because "restart_after_crash" is off 2024-11-25 11:07:01.051 GMT [4328][postmaster] LOG: database system is shut down