2024-11-21 04:56:30.866 GMT [2404][postmaster] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30157, 64-bit 2024-11-21 04:56:30.868 GMT [2404][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/N_idL_LBrL/.s.PGSQL.21414" 2024-11-21 04:56:30.889 GMT [1388][startup] LOG: database system was shut down at 2024-11-21 04:49:12 GMT 2024-11-21 04:56:30.900 GMT [2404][postmaster] LOG: database system is ready to accept connections 2024-11-21 04:56:32.379 GMT [4388][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:32.384 GMT [4388][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-21 04:56:32.384 GMT [4388][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:32.418 GMT [4388][client backend] [003_constraints.pl][0/2:0] LOG: statement: CREATE TABLE tab_fk (bid int PRIMARY KEY); 2024-11-21 04:56:32.433 GMT [4388][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.060 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:32.617 GMT [1388][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:32.619 GMT [1388][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-21 04:56:32.619 GMT [1388][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:32.624 GMT [1388][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-21 04:56:32.646 GMT [1388][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.032 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:33.034 GMT [6468][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:33.036 GMT [6468][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-21 04:56:33.036 GMT [6468][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:33.040 GMT [6468][client backend] [003_constraints.pl][2/2:0] LOG: statement: CREATE PUBLICATION tap_pub FOR ALL TABLES; 2024-11-21 04:56:33.044 GMT [6468][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:33.245 GMT [2876][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:33.246 GMT [2876][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-21 04:56:33.246 GMT [2876][walsender] [[unknown]][22/1:0] LOG: replication connection authorized: user=SYSTEM application_name=tap_sub 2024-11-21 04:56:33.284 GMT [2876][walsender] [tap_sub][22/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-21 04:56:33.294 GMT [2876][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-21 04:56:33.297 GMT [2876][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-21 04:56:33.310 GMT [2876][walsender] [tap_sub][22/0:0] LOG: received replication command: CREATE_REPLICATION_SLOT "tap_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-21 04:56:33.310 GMT [2876][walsender] [tap_sub][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "tap_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-21 04:56:33.313 GMT [2876][walsender] [tap_sub][22/0:0] LOG: logical decoding found consistent point at 0/1798C88 2024-11-21 04:56:33.313 GMT [2876][walsender] [tap_sub][22/0:0] DETAIL: There are no running transactions. 2024-11-21 04:56:33.313 GMT [2876][walsender] [tap_sub][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "tap_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-21 04:56:33.327 GMT [2876][walsender] [tap_sub][22/0:0] LOG: released logical replication slot "tap_sub" 2024-11-21 04:56:33.327 GMT [2876][walsender] [tap_sub][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "tap_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-11-21 04:56:33.327 GMT [2876][walsender] [tap_sub][:0] LOG: disconnection: session time: 0:00:00.086 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:33.431 GMT [7260][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:33.433 GMT [7260][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-21 04:56:33.433 GMT [7260][walsender] [[unknown]][23/1:0] LOG: replication connection authorized: user=SYSTEM application_name=tap_sub 2024-11-21 04:56:33.437 GMT [7260][walsender] [tap_sub][23/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-11-21 04:56:33.437 GMT [7260][walsender] [tap_sub][23/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-11-21 04:56:33.437 GMT [7260][walsender] [tap_sub][23/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-11-21 04:56:33.437 GMT [7260][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-21 04:56:33.437 GMT [7260][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-21 04:56:33.437 GMT [7260][walsender] [tap_sub][23/0:0] LOG: acquired logical replication slot "tap_sub" 2024-11-21 04:56:33.437 GMT [7260][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-21 04:56:33.438 GMT [7260][walsender] [tap_sub][23/0:0] LOG: starting logical decoding for slot "tap_sub" 2024-11-21 04:56:33.438 GMT [7260][walsender] [tap_sub][23/0:0] DETAIL: Streaming transactions committing after 0/1798CC0, reading WAL from 0/1798C88. 2024-11-21 04:56:33.438 GMT [7260][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-21 04:56:33.438 GMT [7260][walsender] [tap_sub][23/0:0] LOG: logical decoding found consistent point at 0/1798C88 2024-11-21 04:56:33.438 GMT [7260][walsender] [tap_sub][23/0:0] DETAIL: There are no running transactions. 2024-11-21 04:56:33.438 GMT [7260][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-21 04:56:33.547 GMT [5940][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:33.549 GMT [5940][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-21 04:56:33.549 GMT [5940][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:33.560 GMT [5940][client backend] [003_constraints.pl][3/2:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-21 04:56:33.563 GMT [5940][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.034 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:33.710 GMT [7724][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:33.711 GMT [7724][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-21 04:56:33.711 GMT [7724][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:33.716 GMT [7724][client backend] [003_constraints.pl][4/2:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-21 04:56:33.720 GMT [7724][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:33.844 GMT [3176][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:33.845 GMT [3176][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-21 04:56:33.845 GMT [3176][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:33.848 GMT [3176][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-21 04:56:33.860 GMT [3176][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:33.950 GMT [5692][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:33.952 GMT [5692][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-21 04:56:33.952 GMT [5692][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:33.954 GMT [5692][client backend] [003_constraints.pl][6/2:0] LOG: statement: INSERT INTO tab_fk (bid) VALUES (1); 2024-11-21 04:56:33.956 GMT [5692][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:34.026 GMT [6872][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:34.027 GMT [6872][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-21 04:56:34.027 GMT [6872][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:34.033 GMT [6872][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-21 04:56:34.044 GMT [6872][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.021 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:34.114 GMT [4340][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:34.116 GMT [4340][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-21 04:56:34.116 GMT [4340][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:34.118 GMT [4340][client backend] [003_constraints.pl][8/2:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-21 04:56:34.122 GMT [4340][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:34.188 GMT [844][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:34.189 GMT [844][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-21 04:56:34.189 GMT [844][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:34.202 GMT [844][client backend] [003_constraints.pl][9/2:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-21 04:56:34.205 GMT [844][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.025 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:34.305 GMT [7644][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:34.306 GMT [7644][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-21 04:56:34.306 GMT [7644][client backend] [[unknown]][0/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:34.310 GMT [7644][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-21 04:56:34.323 GMT [7644][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:34.689 GMT [1604][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:34.691 GMT [1604][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-21 04:56:34.691 GMT [1604][client backend] [[unknown]][1/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:34.693 GMT [1604][client backend] [003_constraints.pl][1/4:0] LOG: statement: DROP TABLE tab_fk CASCADE; 2024-11-21 04:56:34.713 GMT [1604][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.027 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:34.848 GMT [4244][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:34.850 GMT [4244][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-21 04:56:34.850 GMT [4244][client backend] [[unknown]][2/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:34.852 GMT [4244][client backend] [003_constraints.pl][2/4:0] LOG: statement: INSERT INTO tab_fk_ref (id, bid) VALUES (2, 2); 2024-11-21 04:56:34.854 GMT [4244][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:34.940 GMT [2720][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:34.941 GMT [2720][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-21 04:56:34.942 GMT [2720][client backend] [[unknown]][3/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:34.945 GMT [2720][client backend] [003_constraints.pl][3/4:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-21 04:56:34.948 GMT [2720][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:35.030 GMT [3920][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:35.031 GMT [3920][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-21 04:56:35.031 GMT [3920][client backend] [[unknown]][4/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:35.034 GMT [3920][client backend] [003_constraints.pl][4/4:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-21 04:56:35.036 GMT [3920][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:35.123 GMT [5996][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:35.125 GMT [5996][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-21 04:56:35.125 GMT [5996][client backend] [[unknown]][5/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:35.128 GMT [5996][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-21 04:56:35.139 GMT [5996][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:35.460 GMT [4944][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:35.462 GMT [4944][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-21 04:56:35.462 GMT [4944][client backend] [[unknown]][6/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:35.465 GMT [4944][client backend] [003_constraints.pl][6/4:0] LOG: statement: INSERT INTO tab_fk_ref (id, bid) VALUES (10, 10); 2024-11-21 04:56:35.468 GMT [4944][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:35.554 GMT [6384][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:35.555 GMT [6384][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-21 04:56:35.555 GMT [6384][client backend] [[unknown]][7/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:35.559 GMT [6384][client backend] [003_constraints.pl][7/4:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-21 04:56:35.562 GMT [6384][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:35.680 GMT [6068][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:35.681 GMT [6068][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-21 04:56:35.681 GMT [6068][client backend] [[unknown]][8/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:35.685 GMT [6068][client backend] [003_constraints.pl][8/4:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-21 04:56:35.688 GMT [6068][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.030 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:35.773 GMT [7000][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:35.774 GMT [7000][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-21 04:56:35.774 GMT [7000][client backend] [[unknown]][9/3:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:35.777 GMT [7000][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-21 04:56:35.787 GMT [7000][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:35.968 GMT [7916][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:35.969 GMT [7916][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-21 04:56:35.969 GMT [7916][client backend] [[unknown]][0/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:35.972 GMT [7916][client backend] [003_constraints.pl][0/6:0] LOG: statement: UPDATE tab_fk_ref SET bid = 2 WHERE bid = 1; 2024-11-21 04:56:35.974 GMT [7916][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:36.078 GMT [4440][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:36.083 GMT [4440][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-21 04:56:36.083 GMT [4440][client backend] [[unknown]][1/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:36.087 GMT [4440][client backend] [003_constraints.pl][1/6:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-21 04:56:36.091 GMT [4440][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:36.183 GMT [4000][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:36.184 GMT [4000][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-21 04:56:36.184 GMT [4000][client backend] [[unknown]][2/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:36.189 GMT [4000][client backend] [003_constraints.pl][2/6:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-21 04:56:36.192 GMT [4000][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:36.277 GMT [2396][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:36.278 GMT [2396][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-21 04:56:36.278 GMT [2396][client backend] [[unknown]][3/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:36.284 GMT [2396][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-21 04:56:36.295 GMT [2396][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.021 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:36.470 GMT [6676][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:36.471 GMT [6676][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-21 04:56:36.471 GMT [6676][client backend] [[unknown]][4/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:36.474 GMT [6676][client backend] [003_constraints.pl][4/6:0] LOG: statement: UPDATE tab_fk_ref SET id = 6 WHERE id = 1; 2024-11-21 04:56:36.477 GMT [6676][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:36.543 GMT [4256][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:36.544 GMT [4256][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-21 04:56:36.544 GMT [4256][client backend] [[unknown]][5/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:36.553 GMT [4256][client backend] [003_constraints.pl][5/6:0] LOG: statement: SELECT pg_is_in_recovery() 2024-11-21 04:56:36.559 GMT [4256][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:36.724 GMT [2500][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:36.726 GMT [2500][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-21 04:56:36.726 GMT [2500][client backend] [[unknown]][6/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:36.728 GMT [2500][client backend] [003_constraints.pl][6/6:0] LOG: statement: SELECT pg_current_wal_lsn() 2024-11-21 04:56:36.731 GMT [2500][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:36.909 GMT [8032][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-21 04:56:36.911 GMT [8032][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-21 04:56:36.911 GMT [8032][client backend] [[unknown]][7/5:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=003_constraints.pl 2024-11-21 04:56:36.914 GMT [8032][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-21 04:56:36.923 GMT [8032][client backend] [003_constraints.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:38.174 GMT [7260][walsender] [tap_sub][23/0:0] LOG: released logical replication slot "tap_sub" 2024-11-21 04:56:38.174 GMT [7260][walsender] [tap_sub][:0] LOG: disconnection: session time: 0:00:04.745 user=SYSTEM database=postgres host=[local] 2024-11-21 04:56:38.300 GMT [2404][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: 2404 abort() has been called