2025-01-18 18:41:25.084 GMT [2940][postmaster] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30158, 64-bit 2025-01-18 18:41:25.087 GMT [2940][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/PTdtZqlZ9o/.s.PGSQL.25421" 2025-01-18 18:41:25.120 GMT [5000][startup] LOG: database system was shut down at 2025-01-18 18:33:55 GMT 2025-01-18 18:41:25.134 GMT [2940][postmaster] LOG: database system is ready to accept connections 2025-01-18 18:41:26.519 GMT [7960][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:26.522 GMT [7960][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-18 18:41:26.522 GMT [7960][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:26.540 GMT [7960][client backend] [003_constraints.pl][0/2:0] LOG: statement: CREATE TABLE tab_fk (bid int PRIMARY KEY); 2025-01-18 18:41:26.551 GMT [7960][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.034 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:26.668 GMT [6592][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:26.670 GMT [6592][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-18 18:41:26.670 GMT [6592][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:26.680 GMT [6592][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-18 18:41:26.697 GMT [6592][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.036 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:27.071 GMT [3224][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:27.075 GMT [3224][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-18 18:41:27.075 GMT [3224][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:27.085 GMT [3224][client backend] [003_constraints.pl][2/2:0] LOG: statement: CREATE PUBLICATION tap_pub FOR ALL TABLES; 2025-01-18 18:41:27.090 GMT [3224][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.025 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:27.245 GMT [1064][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:27.246 GMT [1064][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-18 18:41:27.246 GMT [1064][walsender] [[unknown]][23/1:0] LOG: replication connection authorized: user=SYSTEM application_name=tap_sub 2025-01-18 18:41:27.268 GMT [1064][walsender] [tap_sub][23/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2025-01-18 18:41:27.269 GMT [1064][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-18 18:41:27.278 GMT [1064][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-18 18:41:27.289 GMT [1064][walsender] [tap_sub][23/0:0] LOG: received replication command: CREATE_REPLICATION_SLOT "tap_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2025-01-18 18:41:27.289 GMT [1064][walsender] [tap_sub][23/0:0] STATEMENT: CREATE_REPLICATION_SLOT "tap_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2025-01-18 18:41:27.292 GMT [1064][walsender] [tap_sub][23/0:0] LOG: logical decoding found consistent point at 0/17981C8 2025-01-18 18:41:27.292 GMT [1064][walsender] [tap_sub][23/0:0] DETAIL: There are no running transactions. 2025-01-18 18:41:27.292 GMT [1064][walsender] [tap_sub][23/0:0] STATEMENT: CREATE_REPLICATION_SLOT "tap_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2025-01-18 18:41:27.299 GMT [1064][walsender] [tap_sub][23/0:0] LOG: released logical replication slot "tap_sub" 2025-01-18 18:41:27.299 GMT [1064][walsender] [tap_sub][23/0:0] STATEMENT: CREATE_REPLICATION_SLOT "tap_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2025-01-18 18:41:27.299 GMT [1064][walsender] [tap_sub][:0] LOG: disconnection: session time: 0:00:00.064 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:27.397 GMT [2584][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:27.398 GMT [2584][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-18 18:41:27.398 GMT [2584][walsender] [[unknown]][24/1:0] LOG: replication connection authorized: user=SYSTEM application_name=tap_sub 2025-01-18 18:41:27.403 GMT [2584][walsender] [tap_sub][24/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2025-01-18 18:41:27.404 GMT [2584][walsender] [tap_sub][24/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2025-01-18 18:41:27.404 GMT [2584][walsender] [tap_sub][24/0:0] STATEMENT: IDENTIFY_SYSTEM 2025-01-18 18:41:27.404 GMT [2584][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-18 18:41:27.404 GMT [2584][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-18 18:41:27.404 GMT [2584][walsender] [tap_sub][24/0:0] LOG: acquired logical replication slot "tap_sub" 2025-01-18 18:41:27.404 GMT [2584][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-18 18:41:27.404 GMT [2584][walsender] [tap_sub][24/0:0] LOG: starting logical decoding for slot "tap_sub" 2025-01-18 18:41:27.404 GMT [2584][walsender] [tap_sub][24/0:0] DETAIL: Streaming transactions committing after 0/1798200, reading WAL from 0/17981C8. 2025-01-18 18:41:27.404 GMT [2584][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-18 18:41:27.404 GMT [2584][walsender] [tap_sub][24/0:0] LOG: logical decoding found consistent point at 0/17981C8 2025-01-18 18:41:27.404 GMT [2584][walsender] [tap_sub][24/0:0] DETAIL: There are no running transactions. 2025-01-18 18:41:27.404 GMT [2584][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-18 18:41:27.632 GMT [5520][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:27.634 GMT [5520][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-18 18:41:27.634 GMT [5520][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:27.646 GMT [5520][client backend] [003_constraints.pl][3/2:0] LOG: statement: SELECT pg_is_in_recovery() 2025-01-18 18:41:27.649 GMT [5520][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.035 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:27.750 GMT [4924][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:27.751 GMT [4924][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-18 18:41:27.751 GMT [4924][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:27.754 GMT [4924][client backend] [003_constraints.pl][4/2:0] LOG: statement: SELECT pg_current_wal_lsn() 2025-01-18 18:41:27.757 GMT [4924][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:27.813 GMT [7308][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:27.814 GMT [7308][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-18 18:41:27.814 GMT [7308][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:27.817 GMT [7308][client backend] [003_constraints.pl][5/2:0] LOG: statement: SELECT '0/1798200' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('tap_sub', 'walreceiver') 2025-01-18 18:41:27.829 GMT [7308][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:27.887 GMT [4932][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:27.888 GMT [4932][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-18 18:41:27.888 GMT [4932][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:27.891 GMT [4932][client backend] [003_constraints.pl][6/2:0] LOG: statement: INSERT INTO tab_fk (bid) VALUES (1); 2025-01-18 18:41:27.893 GMT [4932][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:27.948 GMT [5188][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:27.949 GMT [5188][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-18 18:41:27.949 GMT [5188][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:27.952 GMT [5188][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-18 18:41:27.967 GMT [5188][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.021 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:28.064 GMT [3596][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:28.065 GMT [3596][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-18 18:41:28.065 GMT [3596][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:28.069 GMT [3596][client backend] [003_constraints.pl][8/2:0] LOG: statement: SELECT pg_is_in_recovery() 2025-01-18 18:41:28.071 GMT [3596][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:28.130 GMT [6488][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:28.131 GMT [6488][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-18 18:41:28.131 GMT [6488][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:28.134 GMT [6488][client backend] [003_constraints.pl][9/2:0] LOG: statement: SELECT pg_current_wal_lsn() 2025-01-18 18:41:28.137 GMT [6488][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:28.207 GMT [6228][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:28.208 GMT [6228][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-18 18:41:28.208 GMT [6228][client backend] [[unknown]][0/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:28.211 GMT [6228][client backend] [003_constraints.pl][0/4:0] LOG: statement: SELECT '0/1799528' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('tap_sub', 'walreceiver') 2025-01-18 18:41:28.220 GMT [6228][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:28.417 GMT [6500][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:28.419 GMT [6500][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-18 18:41:28.419 GMT [6500][client backend] [[unknown]][1/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:28.422 GMT [6500][client backend] [003_constraints.pl][1/4:0] LOG: statement: DROP TABLE tab_fk CASCADE; 2025-01-18 18:41:28.435 GMT [6500][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.026 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:28.535 GMT [5676][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:28.537 GMT [5676][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-18 18:41:28.537 GMT [5676][client backend] [[unknown]][2/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:28.540 GMT [5676][client backend] [003_constraints.pl][2/4:0] LOG: statement: INSERT INTO tab_fk_ref (id, bid) VALUES (2, 2); 2025-01-18 18:41:28.542 GMT [5676][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:28.637 GMT [5336][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:28.643 GMT [5336][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-18 18:41:28.643 GMT [5336][client backend] [[unknown]][3/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:28.648 GMT [5336][client backend] [003_constraints.pl][3/4:0] LOG: statement: SELECT pg_is_in_recovery() 2025-01-18 18:41:28.651 GMT [5336][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:28.756 GMT [5872][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:28.758 GMT [5872][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-18 18:41:28.758 GMT [5872][client backend] [[unknown]][4/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:28.761 GMT [5872][client backend] [003_constraints.pl][4/4:0] LOG: statement: SELECT pg_current_wal_lsn() 2025-01-18 18:41:28.764 GMT [5872][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:28.947 GMT [7052][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:28.949 GMT [7052][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-18 18:41:28.949 GMT [7052][client backend] [[unknown]][5/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:28.952 GMT [7052][client backend] [003_constraints.pl][5/4:0] LOG: statement: SELECT '0/179ADB8' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('tap_sub', 'walreceiver') 2025-01-18 18:41:28.962 GMT [7052][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.018 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:29.252 GMT [5424][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:29.254 GMT [5424][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-18 18:41:29.254 GMT [5424][client backend] [[unknown]][6/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:29.256 GMT [5424][client backend] [003_constraints.pl][6/4:0] LOG: statement: INSERT INTO tab_fk_ref (id, bid) VALUES (10, 10); 2025-01-18 18:41:29.258 GMT [5424][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:29.349 GMT [5748][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:29.350 GMT [5748][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-18 18:41:29.350 GMT [5748][client backend] [[unknown]][7/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:29.353 GMT [5748][client backend] [003_constraints.pl][7/4:0] LOG: statement: SELECT pg_is_in_recovery() 2025-01-18 18:41:29.357 GMT [5748][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:29.450 GMT [5220][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:29.452 GMT [5220][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-18 18:41:29.452 GMT [5220][client backend] [[unknown]][8/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:29.455 GMT [5220][client backend] [003_constraints.pl][8/4:0] LOG: statement: SELECT pg_current_wal_lsn() 2025-01-18 18:41:29.457 GMT [5220][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:29.552 GMT [3020][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:29.553 GMT [3020][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-18 18:41:29.553 GMT [3020][client backend] [[unknown]][9/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:29.556 GMT [3020][client backend] [003_constraints.pl][9/4:0] LOG: statement: SELECT '0/179AE68' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('tap_sub', 'walreceiver') 2025-01-18 18:41:29.565 GMT [3020][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:29.798 GMT [4872][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:29.799 GMT [4872][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-18 18:41:29.799 GMT [4872][client backend] [[unknown]][0/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:29.802 GMT [4872][client backend] [003_constraints.pl][0/6:0] LOG: statement: UPDATE tab_fk_ref SET bid = 2 WHERE bid = 1; 2025-01-18 18:41:29.805 GMT [4872][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:29.873 GMT [8164][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:29.874 GMT [8164][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-18 18:41:29.874 GMT [8164][client backend] [[unknown]][1/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:29.877 GMT [8164][client backend] [003_constraints.pl][1/6:0] LOG: statement: SELECT pg_is_in_recovery() 2025-01-18 18:41:29.880 GMT [8164][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:29.971 GMT [6696][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:29.978 GMT [6696][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-18 18:41:29.978 GMT [6696][client backend] [[unknown]][2/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:29.982 GMT [6696][client backend] [003_constraints.pl][2/6:0] LOG: statement: SELECT pg_current_wal_lsn() 2025-01-18 18:41:29.986 GMT [6696][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.020 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:30.091 GMT [488][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:30.093 GMT [488][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-18 18:41:30.093 GMT [488][client backend] [[unknown]][3/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:30.096 GMT [488][client backend] [003_constraints.pl][3/6:0] LOG: statement: SELECT '0/179AF30' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('tap_sub', 'walreceiver') 2025-01-18 18:41:30.105 GMT [488][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.018 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:30.308 GMT [944][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:30.309 GMT [944][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-18 18:41:30.309 GMT [944][client backend] [[unknown]][4/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:30.312 GMT [944][client backend] [003_constraints.pl][4/6:0] LOG: statement: UPDATE tab_fk_ref SET id = 6 WHERE id = 1; 2025-01-18 18:41:30.315 GMT [944][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:30.419 GMT [5416][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:30.421 GMT [5416][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-18 18:41:30.421 GMT [5416][client backend] [[unknown]][5/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:30.424 GMT [5416][client backend] [003_constraints.pl][5/6:0] LOG: statement: SELECT pg_is_in_recovery() 2025-01-18 18:41:30.428 GMT [5416][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:30.491 GMT [2124][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:30.493 GMT [2124][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-18 18:41:30.493 GMT [2124][client backend] [[unknown]][6/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:30.496 GMT [2124][client backend] [003_constraints.pl][6/6:0] LOG: statement: SELECT pg_current_wal_lsn() 2025-01-18 18:41:30.499 GMT [2124][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:30.550 GMT [6676][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:30.552 GMT [6676][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-18 18:41:30.552 GMT [6676][client backend] [[unknown]][7/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2025-01-18 18:41:30.554 GMT [6676][client backend] [003_constraints.pl][7/6:0] LOG: statement: SELECT '0/179B040' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('tap_sub', 'walreceiver') 2025-01-18 18:41:30.564 GMT [6676][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:31.698 GMT [2584][walsender] [tap_sub][24/0:0] LOG: released logical replication slot "tap_sub" 2025-01-18 18:41:31.698 GMT [2584][walsender] [tap_sub][:0] LOG: disconnection: session time: 0:00:04.304 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:31.821 GMT [2940][postmaster] LOG: received immediate shutdown request TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2909, PID: 2940 abort() has been called