2025-01-31 22:26:05.289 GMT [6264][postmaster] LOG:  starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30158, 64-bit
2025-01-31 22:26:05.290 GMT [6264][postmaster] LOG:  listening on Unix socket "C:/Windows/TEMP/noMepbruWR/.s.PGSQL.21054"
2025-01-31 22:26:05.327 GMT [5448][startup] LOG:  database system was shut down at 2025-01-31 22:18:04 GMT
2025-01-31 22:26:05.345 GMT [6264][postmaster] LOG:  database system is ready to accept connections
2025-01-31 22:26:07.587 GMT [796][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-31 22:26:07.588 GMT [796][client backend] [[unknown]][0/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/009_matviews/data/t_009_matviews_publisher_data/pgdata/pg_hba.conf:117)
2025-01-31 22:26:07.589 GMT [796][client backend] [[unknown]][0/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=009_matviews.pl
2025-01-31 22:26:07.606 GMT [796][client backend] [009_matviews.pl][0/2:0] LOG:  statement: CREATE PUBLICATION mypub FOR ALL TABLES;
2025-01-31 22:26:07.611 GMT [796][client backend] [009_matviews.pl][:0] LOG:  disconnection: session time: 0:00:00.028 user=SYSTEM database=postgres host=[local]
2025-01-31 22:26:07.733 GMT [3908][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-31 22:26:07.735 GMT [3908][walsender] [[unknown]][23/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/009_matviews/data/t_009_matviews_publisher_data/pgdata/pg_hba.conf:117)
2025-01-31 22:26:07.735 GMT [3908][walsender] [[unknown]][23/1:0] LOG:  replication connection authorized: user=SYSTEM application_name=mysub
2025-01-31 22:26:07.751 GMT [3908][walsender] [mysub][23/2:0] LOG:  statement: SELECT pg_catalog.set_config('search_path', '', false);
2025-01-31 22:26:07.752 GMT [3908][walsender] [mysub][23/3:0] LOG:  statement: SELECT t.pubname FROM
	 pg_catalog.pg_publication t WHERE
	 t.pubname IN ('mypub')
2025-01-31 22:26:07.755 GMT [3908][walsender] [mysub][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 ( 'mypub' )) AS gpt
	             ON gpt.relid = c.oid
	
2025-01-31 22:26:07.761 GMT [3908][walsender] [mysub][23/0:0] LOG:  received replication command: CREATE_REPLICATION_SLOT "mysub" LOGICAL pgoutput (SNAPSHOT 'nothing')
2025-01-31 22:26:07.761 GMT [3908][walsender] [mysub][23/0:0] STATEMENT:  CREATE_REPLICATION_SLOT "mysub" LOGICAL pgoutput (SNAPSHOT 'nothing')
2025-01-31 22:26:07.765 GMT [3908][walsender] [mysub][23/0:0] LOG:  logical decoding found consistent point at 0/1766E88
2025-01-31 22:26:07.765 GMT [3908][walsender] [mysub][23/0:0] DETAIL:  There are no running transactions.
2025-01-31 22:26:07.765 GMT [3908][walsender] [mysub][23/0:0] STATEMENT:  CREATE_REPLICATION_SLOT "mysub" LOGICAL pgoutput (SNAPSHOT 'nothing')
2025-01-31 22:26:07.767 GMT [3908][walsender] [mysub][23/0:0] LOG:  released logical replication slot "mysub"
2025-01-31 22:26:07.767 GMT [3908][walsender] [mysub][23/0:0] STATEMENT:  CREATE_REPLICATION_SLOT "mysub" LOGICAL pgoutput (SNAPSHOT 'nothing')
2025-01-31 22:26:07.768 GMT [3908][walsender] [mysub][:0] LOG:  disconnection: session time: 0:00:00.037 user=SYSTEM database=postgres host=[local]
2025-01-31 22:26:07.835 GMT [7148][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-31 22:26:07.843 GMT [7148][walsender] [[unknown]][24/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/009_matviews/data/t_009_matviews_publisher_data/pgdata/pg_hba.conf:117)
2025-01-31 22:26:07.843 GMT [7148][walsender] [[unknown]][24/1:0] LOG:  replication connection authorized: user=SYSTEM application_name=mysub
2025-01-31 22:26:07.860 GMT [7148][walsender] [mysub][24/2:0] LOG:  statement: SELECT pg_catalog.set_config('search_path', '', false);
2025-01-31 22:26:07.864 GMT [7148][walsender] [mysub][24/0:0] LOG:  received replication command: IDENTIFY_SYSTEM
2025-01-31 22:26:07.864 GMT [7148][walsender] [mysub][24/0:0] STATEMENT:  IDENTIFY_SYSTEM
2025-01-31 22:26:07.864 GMT [7148][walsender] [mysub][24/0:0] LOG:  received replication command: START_REPLICATION SLOT "mysub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"mypub"')
2025-01-31 22:26:07.864 GMT [7148][walsender] [mysub][24/0:0] STATEMENT:  START_REPLICATION SLOT "mysub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"mypub"')
2025-01-31 22:26:07.864 GMT [7148][walsender] [mysub][24/0:0] LOG:  acquired logical replication slot "mysub"
2025-01-31 22:26:07.864 GMT [7148][walsender] [mysub][24/0:0] STATEMENT:  START_REPLICATION SLOT "mysub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"mypub"')
2025-01-31 22:26:07.865 GMT [7148][walsender] [mysub][24/0:0] LOG:  starting logical decoding for slot "mysub"
2025-01-31 22:26:07.865 GMT [7148][walsender] [mysub][24/0:0] DETAIL:  Streaming transactions committing after 0/1766EC0, reading WAL from 0/1766E88.
2025-01-31 22:26:07.865 GMT [7148][walsender] [mysub][24/0:0] STATEMENT:  START_REPLICATION SLOT "mysub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"mypub"')
2025-01-31 22:26:07.865 GMT [7148][walsender] [mysub][24/0:0] LOG:  logical decoding found consistent point at 0/1766E88
2025-01-31 22:26:07.865 GMT [7148][walsender] [mysub][24/0:0] DETAIL:  There are no running transactions.
2025-01-31 22:26:07.865 GMT [7148][walsender] [mysub][24/0:0] STATEMENT:  START_REPLICATION SLOT "mysub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"mypub"')
2025-01-31 22:26:07.917 GMT [6676][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-31 22:26:07.918 GMT [6676][client backend] [[unknown]][1/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/009_matviews/data/t_009_matviews_publisher_data/pgdata/pg_hba.conf:117)
2025-01-31 22:26:07.918 GMT [6676][client backend] [[unknown]][1/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=009_matviews.pl
2025-01-31 22:26:07.921 GMT [6676][client backend] [009_matviews.pl][1/2:0] LOG:  statement: CREATE TABLE test1 (a int PRIMARY KEY, b text)
2025-01-31 22:26:07.936 GMT [6676][client backend] [009_matviews.pl][:0] LOG:  disconnection: session time: 0:00:00.022 user=SYSTEM database=postgres host=[local]
2025-01-31 22:26:08.062 GMT [7604][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-31 22:26:08.064 GMT [7604][client backend] [[unknown]][2/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/009_matviews/data/t_009_matviews_publisher_data/pgdata/pg_hba.conf:117)
2025-01-31 22:26:08.064 GMT [7604][client backend] [[unknown]][2/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=009_matviews.pl
2025-01-31 22:26:08.074 GMT [7604][client backend] [009_matviews.pl][2/2:0] LOG:  statement: INSERT INTO test1 (a, b) VALUES (1, 'one'), (2, 'two');
2025-01-31 22:26:08.076 GMT [7604][client backend] [009_matviews.pl][:0] LOG:  disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local]
2025-01-31 22:26:08.079 GMT [7148][walsender] [mysub][24/0:0] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.
	
2025-01-31 22:26:08.079 GMT [7148][walsender] [mysub][24/0:0] STATEMENT:  START_REPLICATION SLOT "mysub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"mypub"')
2025-01-31 22:26:08.079 GMT [7148][walsender] [mysub][24/0:0] LOG:  unexpected EOF on standby connection
2025-01-31 22:26:08.079 GMT [7148][walsender] [mysub][24/0:0] STATEMENT:  START_REPLICATION SLOT "mysub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"mypub"')
2025-01-31 22:26:08.079 GMT [7148][walsender] [mysub][24/0:0] LOG:  released logical replication slot "mysub"
2025-01-31 22:26:08.079 GMT [7148][walsender] [mysub][:0] LOG:  disconnection: session time: 0:00:00.258 user=SYSTEM database=postgres host=[local]
2025-01-31 22:26:08.283 GMT [2548][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-31 22:26:08.285 GMT [2548][client backend] [[unknown]][3/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/009_matviews/data/t_009_matviews_publisher_data/pgdata/pg_hba.conf:117)
2025-01-31 22:26:08.285 GMT [2548][client backend] [[unknown]][3/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=009_matviews.pl
2025-01-31 22:26:08.288 GMT [2548][client backend] [009_matviews.pl][3/2:0] LOG:  statement: SELECT pg_is_in_recovery()
2025-01-31 22:26:08.293 GMT [2548][client backend] [009_matviews.pl][:0] LOG:  disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local]
2025-01-31 22:26:08.328 GMT [3732][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-31 22:26:08.330 GMT [3732][walsender] [[unknown]][25/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/009_matviews/data/t_009_matviews_publisher_data/pgdata/pg_hba.conf:117)
2025-01-31 22:26:08.330 GMT [3732][walsender] [[unknown]][25/1:0] LOG:  replication connection authorized: user=SYSTEM application_name=mysub
2025-01-31 22:26:08.333 GMT [3732][walsender] [mysub][25/2:0] LOG:  statement: SELECT pg_catalog.set_config('search_path', '', false);
2025-01-31 22:26:08.334 GMT [3732][walsender] [mysub][25/0:0] LOG:  received replication command: IDENTIFY_SYSTEM
2025-01-31 22:26:08.334 GMT [3732][walsender] [mysub][25/0:0] STATEMENT:  IDENTIFY_SYSTEM
2025-01-31 22:26:08.334 GMT [3732][walsender] [mysub][25/0:0] LOG:  received replication command: START_REPLICATION SLOT "mysub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"mypub"')
2025-01-31 22:26:08.334 GMT [3732][walsender] [mysub][25/0:0] STATEMENT:  START_REPLICATION SLOT "mysub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"mypub"')
2025-01-31 22:26:08.334 GMT [3732][walsender] [mysub][25/0:0] LOG:  acquired logical replication slot "mysub"
2025-01-31 22:26:08.334 GMT [3732][walsender] [mysub][25/0:0] STATEMENT:  START_REPLICATION SLOT "mysub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"mypub"')
2025-01-31 22:26:08.335 GMT [3732][walsender] [mysub][25/0:0] LOG:  starting logical decoding for slot "mysub"
2025-01-31 22:26:08.335 GMT [3732][walsender] [mysub][25/0:0] DETAIL:  Streaming transactions committing after 0/178B7D0, reading WAL from 0/1766E88.
2025-01-31 22:26:08.335 GMT [3732][walsender] [mysub][25/0:0] STATEMENT:  START_REPLICATION SLOT "mysub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"mypub"')
2025-01-31 22:26:08.335 GMT [3732][walsender] [mysub][25/0:0] LOG:  logical decoding found consistent point at 0/1766E88
2025-01-31 22:26:08.335 GMT [3732][walsender] [mysub][25/0:0] DETAIL:  There are no running transactions.
2025-01-31 22:26:08.335 GMT [3732][walsender] [mysub][25/0:0] STATEMENT:  START_REPLICATION SLOT "mysub" LOGICAL 0/0 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"mypub"')
2025-01-31 22:26:08.381 GMT [3504][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-31 22:26:08.383 GMT [3504][client backend] [[unknown]][4/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/009_matviews/data/t_009_matviews_publisher_data/pgdata/pg_hba.conf:117)
2025-01-31 22:26:08.383 GMT [3504][client backend] [[unknown]][4/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=009_matviews.pl
2025-01-31 22:26:08.386 GMT [3504][client backend] [009_matviews.pl][4/2:0] LOG:  statement: SELECT pg_current_wal_lsn()
2025-01-31 22:26:08.389 GMT [3504][client backend] [009_matviews.pl][:0] LOG:  disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local]
2025-01-31 22:26:08.458 GMT [7852][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-31 22:26:08.460 GMT [7852][client backend] [[unknown]][5/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/009_matviews/data/t_009_matviews_publisher_data/pgdata/pg_hba.conf:117)
2025-01-31 22:26:08.460 GMT [7852][client backend] [[unknown]][5/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=009_matviews.pl
2025-01-31 22:26:08.463 GMT [7852][client backend] [009_matviews.pl][5/2:0] LOG:  statement: SELECT '0/178B960' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('mysub', 'walreceiver')
2025-01-31 22:26:08.542 GMT [7852][client backend] [009_matviews.pl][:0] LOG:  disconnection: session time: 0:00:00.093 user=SYSTEM database=postgres host=[local]
2025-01-31 22:26:08.673 GMT [7412][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-31 22:26:08.674 GMT [7412][client backend] [[unknown]][6/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/009_matviews/data/t_009_matviews_publisher_data/pgdata/pg_hba.conf:117)
2025-01-31 22:26:08.674 GMT [7412][client backend] [[unknown]][6/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=009_matviews.pl
2025-01-31 22:26:08.678 GMT [7412][client backend] [009_matviews.pl][6/2:0] LOG:  statement: CREATE MATERIALIZED VIEW testmv1 AS SELECT * FROM test1;
2025-01-31 22:26:08.699 GMT [7412][client backend] [009_matviews.pl][:0] LOG:  disconnection: session time: 0:00:00.030 user=SYSTEM database=postgres host=[local]
2025-01-31 22:26:08.801 GMT [2756][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-31 22:26:08.803 GMT [2756][client backend] [[unknown]][7/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/009_matviews/data/t_009_matviews_publisher_data/pgdata/pg_hba.conf:117)
2025-01-31 22:26:08.803 GMT [2756][client backend] [[unknown]][7/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=009_matviews.pl
2025-01-31 22:26:08.810 GMT [2756][client backend] [009_matviews.pl][7/2:0] LOG:  statement: SELECT pg_is_in_recovery()
2025-01-31 22:26:08.814 GMT [2756][client backend] [009_matviews.pl][:0] LOG:  disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local]
2025-01-31 22:26:08.960 GMT [6816][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-31 22:26:08.962 GMT [6816][client backend] [[unknown]][8/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/009_matviews/data/t_009_matviews_publisher_data/pgdata/pg_hba.conf:117)
2025-01-31 22:26:08.962 GMT [6816][client backend] [[unknown]][8/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=009_matviews.pl
2025-01-31 22:26:08.966 GMT [6816][client backend] [009_matviews.pl][8/2:0] LOG:  statement: SELECT pg_current_wal_lsn()
2025-01-31 22:26:08.974 GMT [6816][client backend] [009_matviews.pl][:0] LOG:  disconnection: session time: 0:00:00.018 user=SYSTEM database=postgres host=[local]
2025-01-31 22:26:09.082 GMT [7892][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2025-01-31 22:26:09.083 GMT [7892][client backend] [[unknown]][9/1:0] LOG:  connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/009_matviews/data/t_009_matviews_publisher_data/pgdata/pg_hba.conf:117)
2025-01-31 22:26:09.083 GMT [7892][client backend] [[unknown]][9/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=009_matviews.pl
2025-01-31 22:26:09.086 GMT [7892][client backend] [009_matviews.pl][9/2:0] LOG:  statement: SELECT '0/17A4160' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('mysub', 'walreceiver')
2025-01-31 22:26:09.098 GMT [7892][client backend] [009_matviews.pl][:0] LOG:  disconnection: session time: 0:00:00.020 user=SYSTEM database=postgres host=[local]
2025-01-31 22:26:10.361 GMT [3732][walsender] [mysub][25/0:0] LOG:  released logical replication slot "mysub"
2025-01-31 22:26:10.361 GMT [3732][walsender] [mysub][:0] LOG:  disconnection: session time: 0:00:02.037 user=SYSTEM database=postgres host=[local]
2025-01-31 22:26:10.477 GMT [6264][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: 6264
abort() has been called