2024-12-18 07:17:55.068 GMT [7596][postmaster] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30157, 64-bit 2024-12-18 07:17:55.069 GMT [7596][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/H2s3Obxqz8/.s.PGSQL.25531" 2024-12-18 07:17:55.088 GMT [4372][startup] LOG: database system was shut down at 2024-12-18 07:10:05 GMT 2024-12-18 07:17:55.097 GMT [7596][postmaster] LOG: database system is ready to accept connections 2024-12-18 07:17:56.286 GMT [2308][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-18 07:17:56.287 GMT [2308][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata/pg_hba.conf:117) 2024-12-18 07:17:56.288 GMT [2308][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=100_bugs.pl 2024-12-18 07:17:56.302 GMT [2308][client backend] [100_bugs.pl][0/2:0] LOG: statement: CREATE TABLE tab1 (a int PRIMARY KEY, b int) 2024-12-18 07:17:56.311 GMT [2308][client backend] [100_bugs.pl][:0] LOG: disconnection: session time: 0:00:00.028 user=SYSTEM database=postgres host=[local] 2024-12-18 07:17:56.398 GMT [4380][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-18 07:17:56.399 GMT [4380][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata/pg_hba.conf:117) 2024-12-18 07:17:56.399 GMT [4380][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=100_bugs.pl 2024-12-18 07:17:56.412 GMT [4380][client backend] [100_bugs.pl][1/2:0] LOG: statement: CREATE FUNCTION double(x int) RETURNS int IMMUTABLE LANGUAGE SQL AS 'select x * 2' 2024-12-18 07:17:56.415 GMT [4380][client backend] [100_bugs.pl][:0] LOG: disconnection: session time: 0:00:00.020 user=SYSTEM database=postgres host=[local] 2024-12-18 07:17:56.512 GMT [7480][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-18 07:17:56.513 GMT [7480][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata/pg_hba.conf:117) 2024-12-18 07:17:56.513 GMT [7480][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=100_bugs.pl 2024-12-18 07:17:56.516 GMT [7480][client backend] [100_bugs.pl][2/2:0] LOG: statement: CREATE INDEX ON tab1 (b) WHERE a > double(1) 2024-12-18 07:17:56.522 GMT [7480][client backend] [100_bugs.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2024-12-18 07:17:56.839 GMT [3652][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-18 07:17:56.840 GMT [3652][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata/pg_hba.conf:117) 2024-12-18 07:17:56.840 GMT [3652][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=100_bugs.pl 2024-12-18 07:17:56.844 GMT [3652][client backend] [100_bugs.pl][3/2:0] LOG: statement: CREATE PUBLICATION pub1 FOR ALL TABLES 2024-12-18 07:17:56.848 GMT [3652][client backend] [100_bugs.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-12-18 07:17:56.962 GMT [6000][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-18 07:17:56.963 GMT [6000][walsender] [[unknown]][22/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata/pg_hba.conf:117) 2024-12-18 07:17:56.963 GMT [6000][walsender] [[unknown]][22/1:0] LOG: replication connection authorized: user=SYSTEM application_name=sub1 2024-12-18 07:17:56.977 GMT [6000][walsender] [sub1][22/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-12-18 07:17:56.978 GMT [6000][walsender] [sub1][22/3:0] LOG: statement: SELECT t.pubname FROM pg_catalog.pg_publication t WHERE t.pubname IN ('pub1') 2024-12-18 07:17:56.981 GMT [6000][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-12-18 07:17:56.988 GMT [6000][walsender] [sub1][22/0:0] LOG: received replication command: CREATE_REPLICATION_SLOT "sub1" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-12-18 07:17:56.988 GMT [6000][walsender] [sub1][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub1" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-12-18 07:17:56.990 GMT [6000][walsender] [sub1][22/0:0] LOG: logical decoding found consistent point at 0/17906C0 2024-12-18 07:17:56.990 GMT [6000][walsender] [sub1][22/0:0] DETAIL: There are no running transactions. 2024-12-18 07:17:56.990 GMT [6000][walsender] [sub1][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub1" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-12-18 07:17:56.991 GMT [6000][walsender] [sub1][22/0:0] LOG: released logical replication slot "sub1" 2024-12-18 07:17:56.991 GMT [6000][walsender] [sub1][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "sub1" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-12-18 07:17:56.991 GMT [6000][walsender] [sub1][:0] LOG: disconnection: session time: 0:00:00.033 user=SYSTEM database=postgres host=[local] 2024-12-18 07:17:57.032 GMT [4880][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-18 07:17:57.033 GMT [4880][walsender] [[unknown]][23/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata/pg_hba.conf:117) 2024-12-18 07:17:57.033 GMT [4880][walsender] [[unknown]][23/1:0] LOG: replication connection authorized: user=SYSTEM application_name=sub1 2024-12-18 07:17:57.036 GMT [4880][walsender] [sub1][23/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-12-18 07:17:57.037 GMT [4880][walsender] [sub1][23/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-12-18 07:17:57.037 GMT [4880][walsender] [sub1][23/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-12-18 07:17:57.037 GMT [4880][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-12-18 07:17:57.037 GMT [4880][walsender] [sub1][23/0:0] STATEMENT: START_REPLICATION SLOT "sub1" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-12-18 07:17:57.037 GMT [4880][walsender] [sub1][23/0:0] LOG: acquired logical replication slot "sub1" 2024-12-18 07:17:57.037 GMT [4880][walsender] [sub1][23/0:0] STATEMENT: START_REPLICATION SLOT "sub1" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-12-18 07:17:57.038 GMT [4880][walsender] [sub1][23/0:0] LOG: starting logical decoding for slot "sub1" 2024-12-18 07:17:57.038 GMT [4880][walsender] [sub1][23/0:0] DETAIL: Streaming transactions committing after 0/17906F8, reading WAL from 0/17906C0. 2024-12-18 07:17:57.038 GMT [4880][walsender] [sub1][23/0:0] STATEMENT: START_REPLICATION SLOT "sub1" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-12-18 07:17:57.038 GMT [4880][walsender] [sub1][23/0:0] LOG: logical decoding found consistent point at 0/17906C0 2024-12-18 07:17:57.038 GMT [4880][walsender] [sub1][23/0:0] DETAIL: There are no running transactions. 2024-12-18 07:17:57.038 GMT [4880][walsender] [sub1][23/0:0] STATEMENT: START_REPLICATION SLOT "sub1" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-12-18 07:17:57.058 GMT [6404][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-18 07:17:57.059 GMT [6404][client backend] [[unknown]][4/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata/pg_hba.conf:117) 2024-12-18 07:17:57.059 GMT [6404][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=100_bugs.pl 2024-12-18 07:17:57.062 GMT [6404][client backend] [100_bugs.pl][4/2:0] LOG: statement: SELECT pg_is_in_recovery() 2024-12-18 07:17:57.065 GMT [6404][client backend] [100_bugs.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-12-18 07:17:57.074 GMT [6700][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-18 07:17:57.075 GMT [6700][walsender] [[unknown]][24/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata/pg_hba.conf:117) 2024-12-18 07:17:57.075 GMT [6700][walsender] [[unknown]][24/1:0] LOG: replication connection authorized: user=SYSTEM application_name=pg_16392_sync_16384_7449645704288002436 2024-12-18 07:17:57.078 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-12-18 07:17:57.079 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/3:0] LOG: statement: BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ 2024-12-18 07:17:57.079 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/3:0] LOG: received replication command: CREATE_REPLICATION_SLOT "pg_16392_sync_16384_7449645704288002436" LOGICAL pgoutput (SNAPSHOT 'use') 2024-12-18 07:17:57.079 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16392_sync_16384_7449645704288002436" LOGICAL pgoutput (SNAPSHOT 'use') 2024-12-18 07:17:57.082 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/3:0] LOG: logical decoding found consistent point at 0/17906F8 2024-12-18 07:17:57.082 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/3:0] DETAIL: There are no running transactions. 2024-12-18 07:17:57.082 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16392_sync_16384_7449645704288002436" LOGICAL pgoutput (SNAPSHOT 'use') 2024-12-18 07:17:57.083 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/3:0] LOG: released logical replication slot "pg_16392_sync_16384_7449645704288002436" 2024-12-18 07:17:57.083 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/3:0] STATEMENT: CREATE_REPLICATION_SLOT "pg_16392_sync_16384_7449645704288002436" LOGICAL pgoutput (SNAPSHOT 'use') 2024-12-18 07:17:57.084 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/3:0] LOG: statement: SELECT c.oid, c.relreplident, c.relkind FROM pg_catalog.pg_class c INNER JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) WHERE n.nspname = 'public' AND c.relname = 'tab1' 2024-12-18 07:17:57.088 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/3:0] LOG: statement: SELECT DISTINCT (CASE WHEN (array_length(gpt.attrs, 1) = c.relnatts) THEN NULL ELSE gpt.attrs END) FROM pg_publication p, LATERAL pg_get_publication_tables(p.pubname) gpt, pg_class c WHERE gpt.relid = 16384 AND c.oid = gpt.relid AND p.pubname IN ( 'pub1' ) 2024-12-18 07:17:57.091 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/3:0] LOG: statement: SELECT a.attnum, a.attname, a.atttypid, a.attnum = ANY(i.indkey), a.attgenerated != '' FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_index i ON (i.indexrelid = pg_get_replica_identity_index(16384)) WHERE a.attnum > 0::pg_catalog.int2 AND NOT a.attisdropped AND a.attrelid = 16384 ORDER BY a.attnum 2024-12-18 07:17:57.093 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/3:0] LOG: statement: SELECT DISTINCT pg_get_expr(gpt.qual, gpt.relid) FROM pg_publication p, LATERAL pg_get_publication_tables(p.pubname) gpt WHERE gpt.relid = 16384 AND p.pubname IN ( 'pub1' ) 2024-12-18 07:17:57.095 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/3:0] LOG: statement: COPY public.tab1 (a, b) TO STDOUT 2024-12-18 07:17:57.095 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/3:0] LOG: statement: COMMIT 2024-12-18 07:17:57.096 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/0:0] LOG: received replication command: START_REPLICATION SLOT "pg_16392_sync_16384_7449645704288002436" LOGICAL 0/1790730 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-12-18 07:17:57.096 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/0:0] STATEMENT: START_REPLICATION SLOT "pg_16392_sync_16384_7449645704288002436" LOGICAL 0/1790730 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-12-18 07:17:57.096 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/0:0] LOG: acquired logical replication slot "pg_16392_sync_16384_7449645704288002436" 2024-12-18 07:17:57.096 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/0:0] STATEMENT: START_REPLICATION SLOT "pg_16392_sync_16384_7449645704288002436" LOGICAL 0/1790730 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-12-18 07:17:57.096 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/0:0] LOG: starting logical decoding for slot "pg_16392_sync_16384_7449645704288002436" 2024-12-18 07:17:57.096 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/0:0] DETAIL: Streaming transactions committing after 0/1790730, reading WAL from 0/17906F8. 2024-12-18 07:17:57.096 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/0:0] STATEMENT: START_REPLICATION SLOT "pg_16392_sync_16384_7449645704288002436" LOGICAL 0/1790730 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-12-18 07:17:57.096 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/0:0] LOG: logical decoding found consistent point at 0/17906F8 2024-12-18 07:17:57.096 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/0:0] DETAIL: There are no running transactions. 2024-12-18 07:17:57.096 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/0:0] STATEMENT: START_REPLICATION SLOT "pg_16392_sync_16384_7449645704288002436" LOGICAL 0/1790730 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-12-18 07:17:57.096 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/0:0] LOG: released logical replication slot "pg_16392_sync_16384_7449645704288002436" 2024-12-18 07:17:57.096 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/0:0] STATEMENT: START_REPLICATION SLOT "pg_16392_sync_16384_7449645704288002436" LOGICAL 0/1790730 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub1"') 2024-12-18 07:17:57.096 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/0:0] LOG: received replication command: DROP_REPLICATION_SLOT pg_16392_sync_16384_7449645704288002436 WAIT 2024-12-18 07:17:57.096 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16392_sync_16384_7449645704288002436 WAIT 2024-12-18 07:17:57.097 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/0:0] LOG: acquired logical replication slot "pg_16392_sync_16384_7449645704288002436" 2024-12-18 07:17:57.097 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][24/0:0] STATEMENT: DROP_REPLICATION_SLOT pg_16392_sync_16384_7449645704288002436 WAIT 2024-12-18 07:17:57.098 GMT [6700][walsender] [pg_16392_sync_16384_7449645704288002436][:0] LOG: disconnection: session time: 0:00:00.026 user=SYSTEM database=postgres host=[local] 2024-12-18 07:17:57.143 GMT [5956][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-18 07:17:57.145 GMT [5956][client backend] [[unknown]][5/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata/pg_hba.conf:117) 2024-12-18 07:17:57.145 GMT [5956][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=100_bugs.pl 2024-12-18 07:17:57.148 GMT [5956][client backend] [100_bugs.pl][5/2:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-12-18 07:17:57.151 GMT [5956][client backend] [100_bugs.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-12-18 07:17:57.225 GMT [5932][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-18 07:17:57.226 GMT [5932][client backend] [[unknown]][6/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata/pg_hba.conf:117) 2024-12-18 07:17:57.226 GMT [5932][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=100_bugs.pl 2024-12-18 07:17:57.230 GMT [5932][client backend] [100_bugs.pl][6/2:0] LOG: statement: SELECT '0/1790730' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub1', 'walreceiver') 2024-12-18 07:17:57.237 GMT [5932][client backend] [100_bugs.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2024-12-18 07:17:57.297 GMT [2720][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-18 07:17:57.298 GMT [2720][client backend] [[unknown]][7/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata/pg_hba.conf:117) 2024-12-18 07:17:57.298 GMT [2720][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=100_bugs.pl 2024-12-18 07:17:57.301 GMT [2720][client backend] [100_bugs.pl][7/2:0] LOG: statement: INSERT INTO tab1 VALUES (1, 2) 2024-12-18 07:17:57.303 GMT [2720][client backend] [100_bugs.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-12-18 07:17:57.376 GMT [3864][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-18 07:17:57.377 GMT [3864][client backend] [[unknown]][8/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata/pg_hba.conf:117) 2024-12-18 07:17:57.377 GMT [3864][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=100_bugs.pl 2024-12-18 07:17:57.380 GMT [3864][client backend] [100_bugs.pl][8/2:0] LOG: statement: SELECT pg_is_in_recovery() 2024-12-18 07:17:57.384 GMT [3864][client backend] [100_bugs.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-12-18 07:17:57.465 GMT [7552][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-18 07:17:57.467 GMT [7552][client backend] [[unknown]][9/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata/pg_hba.conf:117) 2024-12-18 07:17:57.467 GMT [7552][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=100_bugs.pl 2024-12-18 07:17:57.471 GMT [7552][client backend] [100_bugs.pl][9/2:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-12-18 07:17:57.474 GMT [7552][client backend] [100_bugs.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2024-12-18 07:17:57.536 GMT [4048][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-18 07:17:57.538 GMT [4048][client backend] [[unknown]][0/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata/pg_hba.conf:117) 2024-12-18 07:17:57.538 GMT [4048][client backend] [[unknown]][0/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=100_bugs.pl 2024-12-18 07:17:57.542 GMT [4048][client backend] [100_bugs.pl][0/4:0] LOG: statement: SELECT '0/1790840' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('sub1', 'walreceiver') 2024-12-18 07:17:57.551 GMT [4048][client backend] [100_bugs.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2024-12-18 07:17:57.611 GMT [4880][walsender] [sub1][23/0:0] LOG: released logical replication slot "sub1" 2024-12-18 07:17:57.611 GMT [4880][walsender] [sub1][:0] LOG: disconnection: session time: 0:00:00.582 user=SYSTEM database=postgres host=[local] 2024-12-18 07:17:57.647 GMT [7492][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-18 07:17:57.648 GMT [7492][walsender] [[unknown]][25/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata/pg_hba.conf:117) 2024-12-18 07:17:57.648 GMT [7492][walsender] [[unknown]][25/1:0] LOG: replication connection authorized: user=SYSTEM application_name=sub1 2024-12-18 07:17:57.650 GMT [7492][walsender] [sub1][25/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-12-18 07:17:57.651 GMT [7492][walsender] [sub1][25/0:0] LOG: received replication command: DROP_REPLICATION_SLOT sub1 WAIT 2024-12-18 07:17:57.651 GMT [7492][walsender] [sub1][25/0:0] STATEMENT: DROP_REPLICATION_SLOT sub1 WAIT 2024-12-18 07:17:57.651 GMT [7492][walsender] [sub1][25/0:0] LOG: acquired logical replication slot "sub1" 2024-12-18 07:17:57.651 GMT [7492][walsender] [sub1][25/0:0] STATEMENT: DROP_REPLICATION_SLOT sub1 WAIT 2024-12-18 07:17:57.653 GMT [7492][walsender] [sub1][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-12-18 07:17:57.747 GMT [7084][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-18 07:17:57.748 GMT [7084][client backend] [[unknown]][1/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata/pg_hba.conf:117) 2024-12-18 07:17:57.748 GMT [7084][client backend] [[unknown]][1/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=100_bugs.pl 2024-12-18 07:17:57.753 GMT [7084][client backend] [100_bugs.pl][1/4:0] LOG: statement: DROP PUBLICATION pub1 2024-12-18 07:17:57.763 GMT [7084][client backend] [100_bugs.pl][:0] LOG: disconnection: session time: 0:00:00.018 user=SYSTEM database=postgres host=[local] 2024-12-18 07:17:57.841 GMT [2804][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-18 07:17:57.842 GMT [2804][client backend] [[unknown]][2/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata/pg_hba.conf:117) 2024-12-18 07:17:57.842 GMT [2804][client backend] [[unknown]][2/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=100_bugs.pl 2024-12-18 07:17:57.854 GMT [2804][client backend] [100_bugs.pl][2/4:0] LOG: statement: DROP TABLE tab1 2024-12-18 07:17:57.858 GMT [2804][client backend] [100_bugs.pl][:0] LOG: disconnection: session time: 0:00:00.020 user=SYSTEM database=postgres host=[local] 2024-12-18 07:17:57.931 GMT [7596][postmaster] LOG: received fast shutdown request 2024-12-18 07:17:57.931 GMT [7596][postmaster] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2896, PID: 7596 abort() has been called