2024-11-30 22:48:22.218 GMT [4020][postmaster] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30157, 64-bit 2024-11-30 22:48:22.221 GMT [4020][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/TbvZDSwSOB/.s.PGSQL.31391" 2024-11-30 22:48:22.253 GMT [1592][startup] LOG: database system was shut down at 2024-11-30 22:41:11 GMT 2024-11-30 22:48:22.271 GMT [4020][postmaster] LOG: database system is ready to accept connections 2024-11-30 22:48:23.660 GMT [5424][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:23.663 GMT [5424][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:23.663 GMT [5424][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:23.690 GMT [5424][client backend] [003_constraints.pl][0/2:0] LOG: statement: CREATE TABLE tab_fk (bid int PRIMARY KEY); 2024-11-30 22:48:23.706 GMT [5424][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.050 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:23.810 GMT [7360][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:23.812 GMT [7360][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:23.812 GMT [7360][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:23.819 GMT [7360][client backend] [003_constraints.pl][1/2:0] LOG: statement: CREATE TABLE tab_fk_ref (id int PRIMARY KEY, junk text, bid int REFERENCES tab_fk (bid)); 2024-11-30 22:48:23.834 GMT [7360][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.027 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:24.133 GMT [6384][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:24.135 GMT [6384][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:24.135 GMT [6384][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:24.138 GMT [6384][client backend] [003_constraints.pl][2/2:0] LOG: statement: CREATE PUBLICATION tap_pub FOR ALL TABLES; 2024-11-30 22:48:24.142 GMT [6384][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:24.217 GMT [804][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:24.218 GMT [804][walsender] [[unknown]][22/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:24.218 GMT [804][walsender] [[unknown]][22/1:0] LOG: replication connection authorized: user=SYSTEM application_name=tap_sub 2024-11-30 22:48:24.233 GMT [804][walsender] [tap_sub][22/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-30 22:48:24.234 GMT [804][walsender] [tap_sub][22/3:0] LOG: statement: SELECT t.pubname FROM pg_catalog.pg_publication t WHERE t.pubname IN ('tap_pub') 2024-11-30 22:48:24.237 GMT [804][walsender] [tap_sub][22/4:0] LOG: statement: SELECT DISTINCT n.nspname, c.relname, gpt.attrs FROM pg_class c JOIN pg_namespace n ON n.oid = c.relnamespace JOIN ( SELECT (pg_get_publication_tables(VARIADIC array_agg(pubname::text))).* FROM pg_publication WHERE pubname IN ( 'tap_pub' )) AS gpt ON gpt.relid = c.oid 2024-11-30 22:48:24.247 GMT [804][walsender] [tap_sub][22/0:0] LOG: received replication command: CREATE_REPLICATION_SLOT "tap_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-30 22:48:24.247 GMT [804][walsender] [tap_sub][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "tap_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-30 22:48:24.250 GMT [804][walsender] [tap_sub][22/0:0] LOG: logical decoding found consistent point at 0/1798C88 2024-11-30 22:48:24.250 GMT [804][walsender] [tap_sub][22/0:0] DETAIL: There are no running transactions. 2024-11-30 22:48:24.250 GMT [804][walsender] [tap_sub][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "tap_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-30 22:48:24.252 GMT [804][walsender] [tap_sub][22/0:0] LOG: released logical replication slot "tap_sub" 2024-11-30 22:48:24.252 GMT [804][walsender] [tap_sub][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "tap_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-30 22:48:24.252 GMT [804][walsender] [tap_sub][:0] LOG: disconnection: session time: 0:00:00.038 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:24.288 GMT [5936][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:24.290 GMT [5936][walsender] [[unknown]][23/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:24.290 GMT [5936][walsender] [[unknown]][23/1:0] LOG: replication connection authorized: user=SYSTEM application_name=tap_sub 2024-11-30 22:48:24.295 GMT [5936][walsender] [tap_sub][23/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-30 22:48:24.295 GMT [5936][walsender] [tap_sub][23/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-30 22:48:24.295 GMT [5936][walsender] [tap_sub][23/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-30 22:48:24.296 GMT [5936][walsender] [tap_sub][23/0:0] LOG: received replication command: START_REPLICATION SLOT "tap_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"tap_pub"') 2024-11-30 22:48:24.296 GMT [5936][walsender] [tap_sub][23/0:0] STATEMENT: START_REPLICATION SLOT "tap_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"tap_pub"') 2024-11-30 22:48:24.296 GMT [5936][walsender] [tap_sub][23/0:0] LOG: acquired logical replication slot "tap_sub" 2024-11-30 22:48:24.296 GMT [5936][walsender] [tap_sub][23/0:0] STATEMENT: START_REPLICATION SLOT "tap_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"tap_pub"') 2024-11-30 22:48:24.296 GMT [5936][walsender] [tap_sub][23/0:0] LOG: starting logical decoding for slot "tap_sub" 2024-11-30 22:48:24.296 GMT [5936][walsender] [tap_sub][23/0:0] DETAIL: Streaming transactions committing after 0/1798CC0, reading WAL from 0/1798C88. 2024-11-30 22:48:24.296 GMT [5936][walsender] [tap_sub][23/0:0] STATEMENT: START_REPLICATION SLOT "tap_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"tap_pub"') 2024-11-30 22:48:24.296 GMT [5936][walsender] [tap_sub][23/0:0] LOG: logical decoding found consistent point at 0/1798C88 2024-11-30 22:48:24.296 GMT [5936][walsender] [tap_sub][23/0:0] DETAIL: There are no running transactions. 2024-11-30 22:48:24.296 GMT [5936][walsender] [tap_sub][23/0:0] STATEMENT: START_REPLICATION SLOT "tap_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"tap_pub"') 2024-11-30 22:48:24.400 GMT [6520][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:24.402 GMT [6520][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:24.402 GMT [6520][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:24.406 GMT [6520][client backend] [003_constraints.pl][3/2:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-30 22:48:24.410 GMT [6520][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:24.464 GMT [6360][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:24.465 GMT [6360][client backend] [[unknown]][4/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:24.465 GMT [6360][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:24.468 GMT [6360][client backend] [003_constraints.pl][4/2:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-30 22:48:24.471 GMT [6360][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:24.524 GMT [4720][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:24.526 GMT [4720][client backend] [[unknown]][5/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:24.526 GMT [4720][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:24.529 GMT [4720][client backend] [003_constraints.pl][5/2:0] LOG: statement: SELECT '0/1798CC0' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('tap_sub', 'walreceiver') 2024-11-30 22:48:24.539 GMT [4720][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.018 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:24.639 GMT [5476][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:24.641 GMT [5476][client backend] [[unknown]][6/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:24.641 GMT [5476][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:24.643 GMT [5476][client backend] [003_constraints.pl][6/2:0] LOG: statement: INSERT INTO tab_fk (bid) VALUES (1); 2024-11-30 22:48:24.646 GMT [5476][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:24.749 GMT [5972][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:24.752 GMT [5972][client backend] [[unknown]][7/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:24.752 GMT [5972][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:24.757 GMT [5972][client backend] [003_constraints.pl][7/2:0] LOG: statement: INSERT INTO tab_fk_ref (id, bid, junk) VALUES (1, 1, repeat(pi()::text,20000)); 2024-11-30 22:48:24.774 GMT [5972][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.029 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:24.888 GMT [6616][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:24.889 GMT [6616][client backend] [[unknown]][8/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:24.889 GMT [6616][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:24.892 GMT [6616][client backend] [003_constraints.pl][8/2:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-30 22:48:24.895 GMT [6616][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:25.037 GMT [5292][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:25.038 GMT [5292][client backend] [[unknown]][9/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:25.039 GMT [5292][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:25.041 GMT [5292][client backend] [003_constraints.pl][9/2:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-30 22:48:25.044 GMT [5292][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:25.096 GMT [3968][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:25.097 GMT [3968][client backend] [[unknown]][0/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:25.097 GMT [3968][client backend] [[unknown]][0/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:25.100 GMT [3968][client backend] [003_constraints.pl][0/4:0] LOG: statement: SELECT '0/1799FE8' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('tap_sub', 'walreceiver') 2024-11-30 22:48:25.110 GMT [3968][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:25.303 GMT [1792][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:25.304 GMT [1792][client backend] [[unknown]][1/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:25.305 GMT [1792][client backend] [[unknown]][1/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:25.307 GMT [1792][client backend] [003_constraints.pl][1/4:0] LOG: statement: DROP TABLE tab_fk CASCADE; 2024-11-30 22:48:25.322 GMT [1792][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:25.444 GMT [3380][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:25.445 GMT [3380][client backend] [[unknown]][2/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:25.445 GMT [3380][client backend] [[unknown]][2/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:25.448 GMT [3380][client backend] [003_constraints.pl][2/4:0] LOG: statement: INSERT INTO tab_fk_ref (id, bid) VALUES (2, 2); 2024-11-30 22:48:25.450 GMT [3380][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:25.521 GMT [6272][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:25.522 GMT [6272][client backend] [[unknown]][3/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:25.522 GMT [6272][client backend] [[unknown]][3/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:25.525 GMT [6272][client backend] [003_constraints.pl][3/4:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-30 22:48:25.528 GMT [6272][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:25.596 GMT [8056][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:25.597 GMT [8056][client backend] [[unknown]][4/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:25.597 GMT [8056][client backend] [[unknown]][4/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:25.604 GMT [8056][client backend] [003_constraints.pl][4/4:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-30 22:48:25.607 GMT [8056][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:25.694 GMT [3740][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:25.696 GMT [3740][client backend] [[unknown]][5/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:25.696 GMT [3740][client backend] [[unknown]][5/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:25.699 GMT [3740][client backend] [003_constraints.pl][5/4:0] LOG: statement: SELECT '0/179B878' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('tap_sub', 'walreceiver') 2024-11-30 22:48:25.712 GMT [3740][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.020 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:25.950 GMT [3552][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:25.951 GMT [3552][client backend] [[unknown]][6/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:25.951 GMT [3552][client backend] [[unknown]][6/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:25.954 GMT [3552][client backend] [003_constraints.pl][6/4:0] LOG: statement: INSERT INTO tab_fk_ref (id, bid) VALUES (10, 10); 2024-11-30 22:48:25.956 GMT [3552][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:26.006 GMT [3980][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:26.008 GMT [3980][client backend] [[unknown]][7/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:26.008 GMT [3980][client backend] [[unknown]][7/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:26.011 GMT [3980][client backend] [003_constraints.pl][7/4:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-30 22:48:26.013 GMT [3980][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:26.066 GMT [6712][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:26.067 GMT [6712][client backend] [[unknown]][8/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:26.068 GMT [6712][client backend] [[unknown]][8/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:26.070 GMT [6712][client backend] [003_constraints.pl][8/4:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-30 22:48:26.074 GMT [6712][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:26.137 GMT [7220][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:26.138 GMT [7220][client backend] [[unknown]][9/3:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:26.138 GMT [7220][client backend] [[unknown]][9/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:26.141 GMT [7220][client backend] [003_constraints.pl][9/4:0] LOG: statement: SELECT '0/179B928' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('tap_sub', 'walreceiver') 2024-11-30 22:48:26.150 GMT [7220][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:26.336 GMT [3152][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:26.337 GMT [3152][client backend] [[unknown]][0/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:26.337 GMT [3152][client backend] [[unknown]][0/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:26.339 GMT [3152][client backend] [003_constraints.pl][0/6:0] LOG: statement: UPDATE tab_fk_ref SET bid = 2 WHERE bid = 1; 2024-11-30 22:48:26.342 GMT [3152][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:26.470 GMT [5692][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:26.472 GMT [5692][client backend] [[unknown]][1/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:26.472 GMT [5692][client backend] [[unknown]][1/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:26.475 GMT [5692][client backend] [003_constraints.pl][1/6:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-30 22:48:26.478 GMT [5692][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:26.584 GMT [960][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:26.585 GMT [960][client backend] [[unknown]][2/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:26.585 GMT [960][client backend] [[unknown]][2/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:26.588 GMT [960][client backend] [003_constraints.pl][2/6:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-30 22:48:26.591 GMT [960][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:26.646 GMT [5884][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:26.647 GMT [5884][client backend] [[unknown]][3/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:26.647 GMT [5884][client backend] [[unknown]][3/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:26.650 GMT [5884][client backend] [003_constraints.pl][3/6:0] LOG: statement: SELECT '0/179B9F0' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('tap_sub', 'walreceiver') 2024-11-30 22:48:26.659 GMT [5884][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:26.792 GMT [2372][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:26.794 GMT [2372][client backend] [[unknown]][4/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:26.794 GMT [2372][client backend] [[unknown]][4/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:26.797 GMT [2372][client backend] [003_constraints.pl][4/6:0] LOG: statement: UPDATE tab_fk_ref SET id = 6 WHERE id = 1; 2024-11-30 22:48:26.800 GMT [2372][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:26.854 GMT [5356][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:26.855 GMT [5356][client backend] [[unknown]][5/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:26.855 GMT [5356][client backend] [[unknown]][5/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:26.858 GMT [5356][client backend] [003_constraints.pl][5/6:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-30 22:48:26.861 GMT [5356][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:26.921 GMT [6244][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:26.922 GMT [6244][client backend] [[unknown]][6/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:26.922 GMT [6244][client backend] [[unknown]][6/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:26.925 GMT [6244][client backend] [003_constraints.pl][6/6:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-30 22:48:26.928 GMT [6244][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:26.992 GMT [5404][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-30 22:48:26.993 GMT [5404][client backend] [[unknown]][7/5:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/003_constraints/data/t_003_constraints_publisher_data/pgdata/pg_hba.conf:117) 2024-11-30 22:48:26.993 GMT [5404][client backend] [[unknown]][7/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-30 22:48:26.996 GMT [5404][client backend] [003_constraints.pl][7/6:0] LOG: statement: SELECT '0/179BB00' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('tap_sub', 'walreceiver') 2024-11-30 22:48:27.003 GMT [5404][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:28.101 GMT [5936][walsender] [tap_sub][23/0:0] LOG: released logical replication slot "tap_sub" 2024-11-30 22:48:28.101 GMT [5936][walsender] [tap_sub][:0] LOG: disconnection: session time: 0:00:03.815 user=SYSTEM database=postgres host=[local] 2024-11-30 22:48:28.229 GMT [4020][postmaster] LOG: received immediate shutdown request TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2887, PID: 4020 abort() has been called