2025-01-31 07:52:19.914 GMT [6896][postmaster] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30158, 64-bit 2025-01-31 07:52:19.917 GMT [6896][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/2VANccdIQK/.s.PGSQL.23010" 2025-01-31 07:52:19.963 GMT [7260][startup] LOG: database system was shut down at 2025-01-31 07:44:57 GMT 2025-01-31 07:52:19.978 GMT [6896][postmaster] LOG: database system is ready to accept connections 2025-01-31 07:52:21.681 GMT [6328][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:21.684 GMT [6328][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) 2025-01-31 07:52:21.684 GMT [6328][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:21.702 GMT [6328][client backend] [003_constraints.pl][0/2:0] LOG: statement: CREATE TABLE tab_fk (bid int PRIMARY KEY); 2025-01-31 07:52:21.711 GMT [6328][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.036 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:21.807 GMT [1408][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:21.808 GMT [1408][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) 2025-01-31 07:52:21.808 GMT [1408][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:21.812 GMT [1408][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)); 2025-01-31 07:52:21.826 GMT [1408][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:22.160 GMT [1228][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:22.162 GMT [1228][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) 2025-01-31 07:52:22.162 GMT [1228][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:22.177 GMT [1228][client backend] [003_constraints.pl][2/2:0] LOG: statement: CREATE PUBLICATION tap_pub FOR ALL TABLES; 2025-01-31 07:52:22.180 GMT [1228][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.023 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:22.337 GMT [3312][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:22.338 GMT [3312][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) 2025-01-31 07:52:22.338 GMT [3312][walsender] [[unknown]][23/1:0] LOG: replication connection authorized: user=SYSTEM application_name=tap_sub 2025-01-31 07:52:22.356 GMT [3312][walsender] [tap_sub][23/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2025-01-31 07:52:22.358 GMT [3312][walsender] [tap_sub][23/3:0] LOG: statement: SELECT t.pubname FROM pg_catalog.pg_publication t WHERE t.pubname IN ('tap_pub') 2025-01-31 07:52:22.362 GMT [3312][walsender] [tap_sub][23/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 2025-01-31 07:52:22.373 GMT [3312][walsender] [tap_sub][23/0:0] LOG: received replication command: CREATE_REPLICATION_SLOT "tap_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2025-01-31 07:52:22.373 GMT [3312][walsender] [tap_sub][23/0:0] STATEMENT: CREATE_REPLICATION_SLOT "tap_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2025-01-31 07:52:22.377 GMT [3312][walsender] [tap_sub][23/0:0] LOG: logical decoding found consistent point at 0/1799318 2025-01-31 07:52:22.377 GMT [3312][walsender] [tap_sub][23/0:0] DETAIL: There are no running transactions. 2025-01-31 07:52:22.377 GMT [3312][walsender] [tap_sub][23/0:0] STATEMENT: CREATE_REPLICATION_SLOT "tap_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2025-01-31 07:52:22.378 GMT [3312][walsender] [tap_sub][23/0:0] LOG: released logical replication slot "tap_sub" 2025-01-31 07:52:22.378 GMT [3312][walsender] [tap_sub][23/0:0] STATEMENT: CREATE_REPLICATION_SLOT "tap_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2025-01-31 07:52:22.378 GMT [3312][walsender] [tap_sub][:0] LOG: disconnection: session time: 0:00:00.044 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:22.439 GMT [408][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:22.440 GMT [408][walsender] [[unknown]][24/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) 2025-01-31 07:52:22.440 GMT [408][walsender] [[unknown]][24/1:0] LOG: replication connection authorized: user=SYSTEM application_name=tap_sub 2025-01-31 07:52:22.445 GMT [408][walsender] [tap_sub][24/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2025-01-31 07:52:22.446 GMT [408][walsender] [tap_sub][24/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2025-01-31 07:52:22.446 GMT [408][walsender] [tap_sub][24/0:0] STATEMENT: IDENTIFY_SYSTEM 2025-01-31 07:52:22.446 GMT [408][walsender] [tap_sub][24/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"') 2025-01-31 07:52:22.446 GMT [408][walsender] [tap_sub][24/0:0] STATEMENT: START_REPLICATION SLOT "tap_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"tap_pub"') 2025-01-31 07:52:22.446 GMT [408][walsender] [tap_sub][24/0:0] LOG: acquired logical replication slot "tap_sub" 2025-01-31 07:52:22.446 GMT [408][walsender] [tap_sub][24/0:0] STATEMENT: START_REPLICATION SLOT "tap_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"tap_pub"') 2025-01-31 07:52:22.446 GMT [408][walsender] [tap_sub][24/0:0] LOG: starting logical decoding for slot "tap_sub" 2025-01-31 07:52:22.446 GMT [408][walsender] [tap_sub][24/0:0] DETAIL: Streaming transactions committing after 0/1799350, reading WAL from 0/1799318. 2025-01-31 07:52:22.446 GMT [408][walsender] [tap_sub][24/0:0] STATEMENT: START_REPLICATION SLOT "tap_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"tap_pub"') 2025-01-31 07:52:22.446 GMT [408][walsender] [tap_sub][24/0:0] LOG: logical decoding found consistent point at 0/1799318 2025-01-31 07:52:22.446 GMT [408][walsender] [tap_sub][24/0:0] DETAIL: There are no running transactions. 2025-01-31 07:52:22.446 GMT [408][walsender] [tap_sub][24/0:0] STATEMENT: START_REPLICATION SLOT "tap_sub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"tap_pub"') 2025-01-31 07:52:22.491 GMT [6444][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:22.492 GMT [6444][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) 2025-01-31 07:52:22.492 GMT [6444][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:22.501 GMT [6444][client backend] [003_constraints.pl][3/2:0] LOG: statement: SELECT pg_is_in_recovery() 2025-01-31 07:52:22.505 GMT [6444][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.020 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:22.581 GMT [612][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:22.582 GMT [612][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) 2025-01-31 07:52:22.582 GMT [612][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:22.589 GMT [612][client backend] [003_constraints.pl][4/2:0] LOG: statement: SELECT pg_current_wal_lsn() 2025-01-31 07:52:22.598 GMT [612][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.024 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:22.716 GMT [464][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:22.718 GMT [464][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) 2025-01-31 07:52:22.718 GMT [464][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:22.722 GMT [464][client backend] [003_constraints.pl][5/2:0] LOG: statement: SELECT '0/1799350' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('tap_sub', 'walreceiver') 2025-01-31 07:52:22.732 GMT [464][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:22.869 GMT [4736][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:22.870 GMT [4736][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) 2025-01-31 07:52:22.870 GMT [4736][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:22.873 GMT [4736][client backend] [003_constraints.pl][6/2:0] LOG: statement: INSERT INTO tab_fk (bid) VALUES (1); 2025-01-31 07:52:22.885 GMT [4736][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:22.998 GMT [6728][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:22.999 GMT [6728][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) 2025-01-31 07:52:22.999 GMT [6728][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:23.002 GMT [6728][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)); 2025-01-31 07:52:23.012 GMT [6728][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:23.075 GMT [5276][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:23.077 GMT [5276][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) 2025-01-31 07:52:23.077 GMT [5276][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:23.080 GMT [5276][client backend] [003_constraints.pl][8/2:0] LOG: statement: SELECT pg_is_in_recovery() 2025-01-31 07:52:23.084 GMT [5276][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:23.162 GMT [3752][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:23.164 GMT [3752][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) 2025-01-31 07:52:23.164 GMT [3752][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:23.166 GMT [3752][client backend] [003_constraints.pl][9/2:0] LOG: statement: SELECT pg_current_wal_lsn() 2025-01-31 07:52:23.169 GMT [3752][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:23.273 GMT [6912][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:23.274 GMT [6912][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) 2025-01-31 07:52:23.274 GMT [6912][client backend] [[unknown]][0/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:23.277 GMT [6912][client backend] [003_constraints.pl][0/4:0] LOG: statement: SELECT '0/179A690' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('tap_sub', 'walreceiver') 2025-01-31 07:52:23.287 GMT [6912][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:23.521 GMT [5232][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:23.522 GMT [5232][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) 2025-01-31 07:52:23.522 GMT [5232][client backend] [[unknown]][1/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:23.525 GMT [5232][client backend] [003_constraints.pl][1/4:0] LOG: statement: DROP TABLE tab_fk CASCADE; 2025-01-31 07:52:23.537 GMT [5232][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:23.680 GMT [5392][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:23.687 GMT [5392][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) 2025-01-31 07:52:23.687 GMT [5392][client backend] [[unknown]][2/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:23.690 GMT [5392][client backend] [003_constraints.pl][2/4:0] LOG: statement: INSERT INTO tab_fk_ref (id, bid) VALUES (2, 2); 2025-01-31 07:52:23.692 GMT [5392][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:23.784 GMT [4676][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:23.786 GMT [4676][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) 2025-01-31 07:52:23.786 GMT [4676][client backend] [[unknown]][3/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:23.788 GMT [4676][client backend] [003_constraints.pl][3/4:0] LOG: statement: SELECT pg_is_in_recovery() 2025-01-31 07:52:23.791 GMT [4676][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:23.921 GMT [6296][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:23.922 GMT [6296][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) 2025-01-31 07:52:23.922 GMT [6296][client backend] [[unknown]][4/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:23.939 GMT [6296][client backend] [003_constraints.pl][4/4:0] LOG: statement: SELECT pg_current_wal_lsn() 2025-01-31 07:52:23.941 GMT [6296][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.023 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:24.024 GMT [3596][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:24.026 GMT [3596][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) 2025-01-31 07:52:24.026 GMT [3596][client backend] [[unknown]][5/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:24.029 GMT [3596][client backend] [003_constraints.pl][5/4:0] LOG: statement: SELECT '0/179BF08' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('tap_sub', 'walreceiver') 2025-01-31 07:52:24.040 GMT [3596][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:24.297 GMT [1020][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:24.298 GMT [1020][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) 2025-01-31 07:52:24.298 GMT [1020][client backend] [[unknown]][6/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:24.301 GMT [1020][client backend] [003_constraints.pl][6/4:0] LOG: statement: INSERT INTO tab_fk_ref (id, bid) VALUES (10, 10); 2025-01-31 07:52:24.303 GMT [1020][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:24.363 GMT [7816][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:24.365 GMT [7816][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) 2025-01-31 07:52:24.365 GMT [7816][client backend] [[unknown]][7/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:24.368 GMT [7816][client backend] [003_constraints.pl][7/4:0] LOG: statement: SELECT pg_is_in_recovery() 2025-01-31 07:52:24.370 GMT [7816][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:24.430 GMT [5152][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:24.431 GMT [5152][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) 2025-01-31 07:52:24.431 GMT [5152][client backend] [[unknown]][8/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:24.435 GMT [5152][client backend] [003_constraints.pl][8/4:0] LOG: statement: SELECT pg_current_wal_lsn() 2025-01-31 07:52:24.437 GMT [5152][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:24.502 GMT [6832][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:24.504 GMT [6832][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) 2025-01-31 07:52:24.504 GMT [6832][client backend] [[unknown]][9/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:24.507 GMT [6832][client backend] [003_constraints.pl][9/4:0] LOG: statement: SELECT '0/179BFB8' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('tap_sub', 'walreceiver') 2025-01-31 07:52:24.518 GMT [6832][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.020 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:24.663 GMT [7276][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:24.664 GMT [7276][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) 2025-01-31 07:52:24.664 GMT [7276][client backend] [[unknown]][0/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:24.667 GMT [7276][client backend] [003_constraints.pl][0/6:0] LOG: statement: UPDATE tab_fk_ref SET bid = 2 WHERE bid = 1; 2025-01-31 07:52:24.670 GMT [7276][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:24.752 GMT [3120][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:24.754 GMT [3120][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) 2025-01-31 07:52:24.754 GMT [3120][client backend] [[unknown]][1/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:24.757 GMT [3120][client backend] [003_constraints.pl][1/6:0] LOG: statement: SELECT pg_is_in_recovery() 2025-01-31 07:52:24.760 GMT [3120][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:24.828 GMT [5936][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:24.830 GMT [5936][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) 2025-01-31 07:52:24.830 GMT [5936][client backend] [[unknown]][2/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:24.834 GMT [5936][client backend] [003_constraints.pl][2/6:0] LOG: statement: SELECT pg_current_wal_lsn() 2025-01-31 07:52:24.837 GMT [5936][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:24.896 GMT [7708][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:24.897 GMT [7708][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) 2025-01-31 07:52:24.897 GMT [7708][client backend] [[unknown]][3/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:24.904 GMT [7708][client backend] [003_constraints.pl][3/6:0] LOG: statement: SELECT '0/179C098' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('tap_sub', 'walreceiver') 2025-01-31 07:52:24.915 GMT [7708][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:25.066 GMT [8032][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:25.067 GMT [8032][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) 2025-01-31 07:52:25.067 GMT [8032][client backend] [[unknown]][4/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:25.070 GMT [8032][client backend] [003_constraints.pl][4/6:0] LOG: statement: UPDATE tab_fk_ref SET id = 6 WHERE id = 1; 2025-01-31 07:52:25.073 GMT [8032][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:25.141 GMT [3200][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:25.143 GMT [3200][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) 2025-01-31 07:52:25.143 GMT [3200][client backend] [[unknown]][5/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:25.145 GMT [3200][client backend] [003_constraints.pl][5/6:0] LOG: statement: SELECT pg_is_in_recovery() 2025-01-31 07:52:25.149 GMT [3200][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:25.210 GMT [2140][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:25.211 GMT [2140][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) 2025-01-31 07:52:25.211 GMT [2140][client backend] [[unknown]][6/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:25.214 GMT [2140][client backend] [003_constraints.pl][6/6:0] LOG: statement: SELECT pg_current_wal_lsn() 2025-01-31 07:52:25.218 GMT [2140][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:25.284 GMT [7144][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-31 07:52:25.285 GMT [7144][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) 2025-01-31 07:52:25.285 GMT [7144][client backend] [[unknown]][7/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-31 07:52:25.288 GMT [7144][client backend] [003_constraints.pl][7/6:0] LOG: statement: SELECT '0/179C1A8' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('tap_sub', 'walreceiver') 2025-01-31 07:52:25.297 GMT [7144][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:26.464 GMT [408][walsender] [tap_sub][24/0:0] LOG: released logical replication slot "tap_sub" 2025-01-31 07:52:26.464 GMT [408][walsender] [tap_sub][:0] LOG: disconnection: session time: 0:00:04.028 user=SYSTEM database=postgres host=[local] 2025-01-31 07:52:26.613 GMT [6896][postmaster] LOG: received immediate shutdown request TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2951, PID: 6896 abort() has been called