2024-06-03 20:03:16.900 UTC [20650][postmaster] LOG:  starting PostgreSQL 17beta1 on x86_64-linux, compiled by gcc-10.2.1, 64-bit
2024-06-03 20:03:16.900 UTC [20650][postmaster] LOG:  listening on Unix socket "/tmp/10Q09bxqlT/.s.PGSQL.54151"
2024-06-03 20:03:16.912 UTC [20660][startup] LOG:  database system was shut down at 2024-06-03 20:02:51 UTC
2024-06-03 20:03:16.918 UTC [20650][postmaster] LOG:  database system is ready to accept connections
2024-06-03 20:03:16.991 UTC [20650][postmaster] LOG:  received fast shutdown request
2024-06-03 20:03:16.991 UTC [20650][postmaster] LOG:  aborting any active transactions
2024-06-03 20:03:16.993 UTC [20650][postmaster] LOG:  background worker "logical replication launcher" (PID 20667) exited with exit code 1
2024-06-03 20:03:16.994 UTC [20658][checkpointer] LOG:  shutting down
2024-06-03 20:03:16.994 UTC [20658][checkpointer] LOG:  checkpoint starting: shutdown immediate
2024-06-03 20:03:16.995 UTC [20658][checkpointer] LOG:  checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.001 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=0 kB; lsn=0/151FBD0, redo lsn=0/151FBD0
2024-06-03 20:03:16.999 UTC [20650][postmaster] LOG:  database system is shut down
2024-06-03 20:03:17.170 UTC [20684][postmaster] LOG:  starting PostgreSQL 17beta1 on x86_64-linux, compiled by gcc-10.2.1, 64-bit
2024-06-03 20:03:17.170 UTC [20684][postmaster] LOG:  listening on Unix socket "/tmp/10Q09bxqlT/.s.PGSQL.54151"
2024-06-03 20:03:17.181 UTC [20695][startup] LOG:  database system was shut down at 2024-06-03 20:03:16 UTC
2024-06-03 20:03:17.188 UTC [20684][postmaster] LOG:  database system is ready to accept connections
TRAP: failed Assert("latch->maybe_sleeping == false"), File: "../src/backend/storage/ipc/latch.c", Line: 728, PID: 20696
postgres: gnat: walwriter (ExceptionalCondition+0x56)[0x557abd538236]
postgres: gnat: walwriter (CreateWaitEventSet+0x0)[0x557abd229061]
postgres: gnat: walwriter (WalWriterMain+0x2fc)[0x557abd1354f0]
postgres: gnat: walwriter (postmaster_child_launch+0x188)[0x557abd1278bc]
postgres: gnat: walwriter (+0xf5f935)[0x557abd129935]
postgres: gnat: walwriter (+0xf63098)[0x557abd12d098]
postgres: gnat: walwriter (+0xf63fc4)[0x557abd12dfc4]
postgres: gnat: walwriter (BackgroundWorkerInitializeConnection+0x0)[0x557abd12fbba]
postgres: gnat: walwriter (main+0x393)[0x557abcf544d4]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xea)[0x7fb7a5739d0a]
postgres: gnat: walwriter (_start+0x2a)[0x557abcaaa24a]
2024-06-03 20:03:17.386 UTC [20730][postmaster] FATAL:  pre-existing shared memory block (key 676385, ID 32824) is still in use
2024-06-03 20:03:17.386 UTC [20730][postmaster] HINT:  Terminate any old server processes associated with data directory "/tmp/cirrus-ci-build/build/testrun/recovery/017_shm/data/t_017_shm_gnat_data/pgdata".
2024-06-03 20:03:17.575 UTC [20768][postmaster] FATAL:  pre-existing shared memory block (key 676385, ID 32824) is still in use
2024-06-03 20:03:17.575 UTC [20768][postmaster] HINT:  Terminate any old server processes associated with data directory "/tmp/cirrus-ci-build/build/testrun/recovery/017_shm/data/t_017_shm_gnat_data/pgdata".
2024-06-03 20:03:17.842 UTC [20796][postmaster] LOG:  starting PostgreSQL 17beta1 on x86_64-linux, compiled by gcc-10.2.1, 64-bit
2024-06-03 20:03:17.842 UTC [20796][postmaster] LOG:  listening on Unix socket "/tmp/10Q09bxqlT/.s.PGSQL.54151"
2024-06-03 20:03:17.867 UTC [20813][startup] LOG:  database system was interrupted; last known up at 2024-06-03 20:03:17 UTC
2024-06-03 20:03:17.867 UTC [20813][startup] LOG:  database system was not properly shut down; automatic recovery in progress
2024-06-03 20:03:17.868 UTC [20813][startup] LOG:  invalid record length at 0/151FC48: expected at least 24, got 0
2024-06-03 20:03:17.868 UTC [20813][startup] LOG:  redo is not required
2024-06-03 20:03:17.869 UTC [20811][checkpointer] LOG:  checkpoint starting: end-of-recovery immediate wait
2024-06-03 20:03:17.870 UTC [20811][checkpointer] LOG:  checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.001 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=0 kB; lsn=0/151FC48, redo lsn=0/151FC48
2024-06-03 20:03:17.880 UTC [20796][postmaster] LOG:  database system is ready to accept connections
2024-06-03 20:03:18.146 UTC [20855][postmaster] LOG:  starting PostgreSQL 17beta1 on x86_64-linux, compiled by gcc-10.2.1, 64-bit
2024-06-03 20:03:18.146 UTC [20855][postmaster] LOG:  listening on Unix socket "/tmp/10Q09bxqlT/.s.PGSQL.54151"
2024-06-03 20:03:18.200 UTC [20870][startup] LOG:  database system was interrupted; last known up at 2024-06-03 20:03:17 UTC
2024-06-03 20:03:18.200 UTC [20870][startup] LOG:  database system was not properly shut down; automatic recovery in progress
2024-06-03 20:03:18.201 UTC [20870][startup] LOG:  invalid record length at 0/151FCC0: expected at least 24, got 0
2024-06-03 20:03:18.201 UTC [20870][startup] LOG:  redo is not required
2024-06-03 20:03:18.202 UTC [20867][checkpointer] LOG:  checkpoint starting: end-of-recovery immediate wait
2024-06-03 20:03:18.301 UTC [20867][checkpointer] LOG:  checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.100 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=0 kB; lsn=0/151FCC0, redo lsn=0/151FCC0
2024-06-03 20:03:18.306 UTC [20855][postmaster] LOG:  database system is ready to accept connections
2024-06-03 20:03:18.387 UTC [20855][postmaster] LOG:  received fast shutdown request
2024-06-03 20:03:18.387 UTC [20855][postmaster] LOG:  aborting any active transactions
2024-06-03 20:03:18.390 UTC [20855][postmaster] LOG:  background worker "logical replication launcher" (PID 20891) exited with exit code 1
2024-06-03 20:03:18.391 UTC [20867][checkpointer] LOG:  shutting down
2024-06-03 20:03:18.391 UTC [20867][checkpointer] LOG:  checkpoint starting: shutdown immediate
2024-06-03 20:03:18.398 UTC [20867][checkpointer] LOG:  checkpoint complete: wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.008 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=0 kB; lsn=0/151FD38, redo lsn=0/151FD38
2024-06-03 20:03:18.402 UTC [20855][postmaster] LOG:  database system is shut down
2024-06-03 20:03:18.670 UTC [20954][postmaster] LOG:  starting PostgreSQL 17beta1 on x86_64-linux, compiled by gcc-10.2.1, 64-bit
2024-06-03 20:03:18.670 UTC [20954][postmaster] LOG:  listening on Unix socket "/tmp/10Q09bxqlT/.s.PGSQL.54151"
2024-06-03 20:03:18.695 UTC [20969][startup] LOG:  database system was shut down at 2024-06-03 20:03:18 UTC
2024-06-03 20:03:18.699 UTC [20954][postmaster] LOG:  database system is ready to accept connections
2024-06-03 20:03:18.750 UTC [20954][postmaster] LOG:  received fast shutdown request
2024-06-03 20:03:18.750 UTC [20954][postmaster] LOG:  aborting any active transactions
2024-06-03 20:03:18.752 UTC [20954][postmaster] LOG:  background worker "logical replication launcher" (PID 20976) exited with exit code 1
2024-06-03 20:03:18.752 UTC [20967][checkpointer] LOG:  shutting down
2024-06-03 20:03:18.752 UTC [20967][checkpointer] LOG:  checkpoint starting: shutdown immediate
2024-06-03 20:03:18.753 UTC [20967][checkpointer] LOG:  checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.001 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=0 kB; lsn=0/151FDB0, redo lsn=0/151FDB0
2024-06-03 20:03:18.757 UTC [20954][postmaster] LOG:  database system is shut down
2024-06-03 20:03:19.038 UTC [21058][postmaster] LOG:  starting PostgreSQL 17beta1 on x86_64-linux, compiled by gcc-10.2.1, 64-bit
2024-06-03 20:03:19.038 UTC [21058][postmaster] LOG:  listening on Unix socket "/tmp/10Q09bxqlT/.s.PGSQL.54151"
2024-06-03 20:03:19.066 UTC [21077][startup] LOG:  database system was shut down at 2024-06-03 20:03:18 UTC
2024-06-03 20:03:19.069 UTC [21058][postmaster] LOG:  database system is ready to accept connections
2024-06-03 20:03:19.181 UTC [21101][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-06-03 20:03:19.182 UTC [21101][client backend] [[unknown]][0/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/017_shm/data/t_017_shm_gnat_data/pgdata/pg_hba.conf:117)
2024-06-03 20:03:19.182 UTC [21101][client backend] [[unknown]][0/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=017_shm.pl
2024-06-03 20:03:19.199 UTC [21101][client backend] [017_shm.pl][0/2:0] LOG:  statement: CREATE FUNCTION wait_pid(int)
	   RETURNS void
	   AS '/tmp/cirrus-ci-build/build/src/test/regress/regress.so'
	   LANGUAGE C STRICT;
2024-06-03 20:03:19.204 UTC [21101][client backend] [017_shm.pl][:0] LOG:  disconnection: session time: 0:00:00.031 user=postgres database=postgres host=[local]
2024-06-03 20:03:19.217 UTC [21106][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-06-03 20:03:19.218 UTC [21106][client backend] [[unknown]][1/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/017_shm/data/t_017_shm_gnat_data/pgdata/pg_hba.conf:117)
2024-06-03 20:03:19.218 UTC [21106][client backend] [[unknown]][1/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=017_shm.pl
2024-06-03 20:03:19.219 UTC [21106][client backend] [017_shm.pl][1/2:0] LOG:  statement: SELECT wait_pid(pg_backend_pid())
2024-06-03 20:03:19.227 UTC [21107][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-06-03 20:03:19.228 UTC [21107][client backend] [[unknown]][2/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/017_shm/data/t_017_shm_gnat_data/pgdata/pg_hba.conf:117)
2024-06-03 20:03:19.228 UTC [21107][client backend] [[unknown]][2/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=017_shm.pl
2024-06-03 20:03:19.229 UTC [21107][client backend] [017_shm.pl][2/2:0] LOG:  statement: SELECT 1 FROM pg_stat_activity WHERE query = 'SELECT wait_pid(pg_backend_pid())'
2024-06-03 20:03:19.235 UTC [21107][client backend] [017_shm.pl][:0] LOG:  disconnection: session time: 0:00:00.007 user=postgres database=postgres host=[local]
2024-06-03 20:03:19.259 UTC [21113][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-06-03 20:03:19.259 UTC [21113][client backend] [[unknown]][3/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/017_shm/data/t_017_shm_gnat_data/pgdata/pg_hba.conf:117)
2024-06-03 20:03:19.259 UTC [21113][client backend] [[unknown]][3/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=017_shm.pl
2024-06-03 20:03:19.262 UTC [21113][client backend] [017_shm.pl][3/2:0] LOG:  statement: SELECT pid FROM pg_stat_activity WHERE query = 'SELECT wait_pid(pg_backend_pid())'
2024-06-03 20:03:19.272 UTC [21113][client backend] [017_shm.pl][:0] LOG:  disconnection: session time: 0:00:00.015 user=postgres database=postgres host=[local]
2024-06-03 20:03:19.475 UTC [21106][client backend] [017_shm.pl][1/2:0] WARNING:  terminating connection because of unexpected SIGQUIT signal