2024-06-09 07:32:05.321 UTC [29314][postmaster] LOG: starting PostgreSQL 17beta1 on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit 2024-06-09 07:32:05.321 UTC [29314][postmaster] LOG: listening on Unix socket "/tmp/dQldiJMXeg/.s.PGSQL.56351" 2024-06-09 07:32:05.357 UTC [29322][startup] LOG: database system was shut down at 2024-06-09 07:30:11 UTC 2024-06-09 07:32:05.367 UTC [29314][postmaster] LOG: database system is ready to accept connections 2024-06-09 07:32:05.516 UTC [29338][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:05.517 UTC [29338][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/modules/worker_spi/tmp_check/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-09 07:32:05.517 UTC [29338][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-09 07:32:05.540 UTC [29338][client backend] [001_worker_spi.pl][0/2:0] LOG: statement: CREATE EXTENSION worker_spi; 2024-06-09 07:32:05.550 UTC [29338][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.045 user=postgres database=postgres host=[local] 2024-06-09 07:32:05.581 UTC [29351][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:05.582 UTC [29351][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/modules/worker_spi/tmp_check/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-09 07:32:05.582 UTC [29351][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-09 07:32:05.585 UTC [29351][client backend] [001_worker_spi.pl][1/2:0] LOG: statement: SELECT worker_spi_launch(4) IS NOT NULL; 2024-06-09 07:32:05.600 UTC [29351][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.020 user=postgres database=postgres host=[local] 2024-06-09 07:32:05.601 UTC [29356][worker_spi dynamic] LOG: worker_spi dynamic worker 4 initialized with schema4.counted 2024-06-09 07:32:05.635 UTC [29361][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:05.636 UTC [29361][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/modules/worker_spi/tmp_check/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-09 07:32:05.636 UTC [29361][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-09 07:32:05.644 UTC [29361][client backend] [001_worker_spi.pl][2/2:0] LOG: statement: SELECT count(*) > 0 FROM information_schema.tables WHERE table_schema = 'schema4' AND table_name = 'counted'; 2024-06-09 07:32:05.671 UTC [29361][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.036 user=postgres database=postgres host=[local] 2024-06-09 07:32:05.716 UTC [29376][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:05.717 UTC [29376][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/modules/worker_spi/tmp_check/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-09 07:32:05.717 UTC [29376][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-09 07:32:05.722 UTC [29376][client backend] [001_worker_spi.pl][3/2:0] LOG: statement: INSERT INTO schema4.counted VALUES ('total', 0), ('delta', 1); 2024-06-09 07:32:05.745 UTC [29376][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.033 user=postgres database=postgres host=[local] 2024-06-09 07:32:05.746 UTC [29314][postmaster] LOG: received SIGHUP, reloading configuration files 2024-06-09 07:32:05.750 UTC [29356][worker_spi dynamic] LOG: worker_spi dynamic worker 4: count in schema4.counted is now 1 2024-06-09 07:32:05.750 UTC [29356][worker_spi dynamic] STATEMENT: WITH deleted AS (DELETE FROM schema4.counted WHERE type = 'delta' RETURNING value), total AS (SELECT coalesce(sum(value), 0) as sum FROM deleted) UPDATE schema4.counted SET value = counted.value + total.sum FROM total WHERE type = 'total' RETURNING counted.value 2024-06-09 07:32:05.771 UTC [29388][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:05.772 UTC [29388][client backend] [[unknown]][4/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/modules/worker_spi/tmp_check/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-09 07:32:05.772 UTC [29388][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-09 07:32:05.774 UTC [29388][client backend] [001_worker_spi.pl][4/2:0] LOG: statement: SELECT count(*) FROM schema4.counted WHERE type = 'delta'; 2024-06-09 07:32:05.780 UTC [29388][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=postgres database=postgres host=[local] 2024-06-09 07:32:05.803 UTC [29398][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:05.804 UTC [29398][client backend] [[unknown]][5/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/modules/worker_spi/tmp_check/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-09 07:32:05.804 UTC [29398][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-09 07:32:05.809 UTC [29398][client backend] [001_worker_spi.pl][5/2:0] LOG: statement: SELECT * FROM schema4.counted; 2024-06-09 07:32:05.814 UTC [29398][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=postgres database=postgres host=[local] 2024-06-09 07:32:05.842 UTC [29403][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:05.843 UTC [29403][client backend] [[unknown]][6/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/modules/worker_spi/tmp_check/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-09 07:32:05.843 UTC [29403][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-09 07:32:05.848 UTC [29403][client backend] [001_worker_spi.pl][6/2:0] LOG: statement: SELECT wait_event FROM pg_stat_activity WHERE backend_type ~ 'worker_spi'; 2024-06-09 07:32:05.860 UTC [29403][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.018 user=postgres database=postgres host=[local] 2024-06-09 07:32:05.914 UTC [29412][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:05.915 UTC [29412][client backend] [[unknown]][7/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/modules/worker_spi/tmp_check/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-09 07:32:05.915 UTC [29412][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-09 07:32:05.917 UTC [29412][client backend] [001_worker_spi.pl][7/2:0] LOG: statement: SELECT count(*) > 0 from pg_wait_events where type = 'Extension' and name = 'WorkerSpiMain'; 2024-06-09 07:32:05.924 UTC [29412][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=postgres database=postgres host=[local] 2024-06-09 07:32:05.942 UTC [29416][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:05.944 UTC [29416][client backend] [[unknown]][8/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/modules/worker_spi/tmp_check/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-09 07:32:05.944 UTC [29416][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-09 07:32:05.946 UTC [29416][client backend] [001_worker_spi.pl][8/2:0] LOG: statement: CREATE DATABASE mydb; 2024-06-09 07:32:06.042 UTC [29416][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.099 user=postgres database=postgres host=[local] 2024-06-09 07:32:06.076 UTC [29435][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:06.077 UTC [29435][client backend] [[unknown]][9/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/modules/worker_spi/tmp_check/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-09 07:32:06.077 UTC [29435][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-09 07:32:06.079 UTC [29435][client backend] [001_worker_spi.pl][9/2:0] LOG: statement: CREATE ROLE myrole SUPERUSER LOGIN; 2024-06-09 07:32:06.085 UTC [29435][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=postgres database=postgres host=[local] 2024-06-09 07:32:06.113 UTC [29439][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:06.117 UTC [29439][client backend] [[unknown]][10/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/modules/worker_spi/tmp_check/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-09 07:32:06.117 UTC [29439][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-09 07:32:06.160 UTC [29439][client backend] [001_worker_spi.pl][10/2:0] LOG: statement: CREATE EXTENSION worker_spi; 2024-06-09 07:32:06.171 UTC [29439][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.058 user=postgres database=mydb host=[local] 2024-06-09 07:32:06.171 UTC [29314][postmaster] LOG: received fast shutdown request 2024-06-09 07:32:06.171 UTC [29314][postmaster] LOG: aborting any active transactions 2024-06-09 07:32:06.171 UTC [29356][worker_spi dynamic] FATAL: terminating background worker "worker_spi dynamic" due to administrator command 2024-06-09 07:32:06.190 UTC [29314][postmaster] LOG: background worker "logical replication launcher" (PID 29325) exited with exit code 1 2024-06-09 07:32:06.192 UTC [29314][postmaster] LOG: background worker "worker_spi dynamic" (PID 29356) exited with exit code 1 2024-06-09 07:32:06.192 UTC [29318][checkpointer] LOG: shutting down 2024-06-09 07:32:06.192 UTC [29318][checkpointer] LOG: checkpoint starting: shutdown immediate 2024-06-09 07:32:06.211 UTC [29318][checkpointer] LOG: checkpoint complete: wrote 1009 buffers (6.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.019 s, sync=0.001 s, total=0.019 s; sync files=0, longest=0.000 s, average=0.000 s; distance=7761 kB, estimate=7761 kB; lsn=0/1CB4078, redo lsn=0/1CB4078 2024-06-09 07:32:06.227 UTC [29314][postmaster] LOG: database system is shut down 2024-06-09 07:32:06.354 UTC [29453][postmaster] LOG: starting PostgreSQL 17beta1 on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit 2024-06-09 07:32:06.354 UTC [29453][postmaster] LOG: listening on Unix socket "/tmp/dQldiJMXeg/.s.PGSQL.56351" 2024-06-09 07:32:06.377 UTC [29463][startup] LOG: database system was shut down at 2024-06-09 07:32:06 UTC 2024-06-09 07:32:06.425 UTC [29453][postmaster] LOG: database system is ready to accept connections TRAP: failed Assert("OidIsValid(dboid)"), File: "worker_spi.c", Line: 170, PID: 29477 /lib/x86_64-linux-gnu/libasan.so.6(+0x43df1)[0x7ffa03935df1] postgres: mynode: worker_spi worker 2 (ExceptionalCondition+0xe6)[0x55ae46c051e5] /tmp/cirrus-ci-build/tmp_install/usr/local/pgsql/lib/worker_spi.so(worker_spi_main+0x291)[0x7ff9fd4c3d51] postgres: mynode: worker_spi worker 2 (BackgroundWorkerMain+0x4c9)[0x55ae46711edf] postgres: mynode: worker_spi worker 2 (postmaster_child_launch+0x17f)[0x55ae46715639] postgres: mynode: worker_spi worker 2 (+0xcea888)[0x55ae4671b888] postgres: mynode: worker_spi worker 2 (+0xceafe5)[0x55ae4671bfe5] postgres: mynode: worker_spi worker 2 (+0xceb326)[0x55ae4671c326] postgres: mynode: worker_spi worker 2 (+0xceca73)[0x55ae4671da73] postgres: mynode: worker_spi worker 2 (PostmasterMarkPIDForWorkerNotify+0x0)[0x55ae4671fefa] postgres: mynode: worker_spi worker 2 (main+0x2f7)[0x55ae464bdd73] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xea)[0x7ffa02918d0a] postgres: mynode: worker_spi worker 2 (_start+0x2a)[0x55ae45e3c49a] TRAP: failed Assert("OidIsValid(dboid)"), File: "worker_spi.c", Line: 170, PID: 29479 /lib/x86_64-linux-gnu/libasan.so.6(+0x43df1)[0x7ffa03935df1] postgres: mynode: worker_spi worker 1 (ExceptionalCondition+0xe6)[0x55ae46c051e5] /tmp/cirrus-ci-build/tmp_install/usr/local/pgsql/lib/worker_spi.so(worker_spi_main+0x291)[0x7ff9fd4c3d51] postgres: mynode: worker_spi worker 1 (BackgroundWorkerMain+0x4c9)[0x55ae46711edf] postgres: mynode: worker_spi worker 1 (postmaster_child_launch+0x17f)[0x55ae46715639] postgres: mynode: worker_spi worker 1 (+0xcea888)[0x55ae4671b888] postgres: mynode: worker_spi worker 1 (+0xceafe5)[0x55ae4671bfe5] postgres: mynode: worker_spi worker 1 (+0xceb326)[0x55ae4671c326] postgres: mynode: worker_spi worker 1 (+0xceca73)[0x55ae4671da73] postgres: mynode: worker_spi worker 1 (PostmasterMarkPIDForWorkerNotify+0x0)[0x55ae4671fefa] postgres: mynode: worker_spi worker 1 (main+0x2f7)[0x55ae464bdd73] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xea)[0x7ffa02918d0a] postgres: mynode: worker_spi worker 1 (_start+0x2a)[0x55ae45e3c49a] TRAP: failed Assert("OidIsValid(dboid)"), File: "worker_spi.c", Line: 170, PID: 29476 /lib/x86_64-linux-gnu/libasan.so.6(+0x43df1)[0x7ffa03935df1] postgres: mynode: worker_spi worker 3 (ExceptionalCondition+0xe6)[0x55ae46c051e5] /tmp/cirrus-ci-build/tmp_install/usr/local/pgsql/lib/worker_spi.so(worker_spi_main+0x291)[0x7ff9fd4c3d51] postgres: mynode: worker_spi worker 3 (BackgroundWorkerMain+0x4c9)[0x55ae46711edf] postgres: mynode: worker_spi worker 3 (postmaster_child_launch+0x17f)[0x55ae46715639] postgres: mynode: worker_spi worker 3 (+0xcea888)[0x55ae4671b888] postgres: mynode: worker_spi worker 3 (+0xceafe5)[0x55ae4671bfe5] postgres: mynode: worker_spi worker 3 (+0xceb326)[0x55ae4671c326] postgres: mynode: worker_spi worker 3 (+0xceca73)[0x55ae4671da73] postgres: mynode: worker_spi worker 3 (PostmasterMarkPIDForWorkerNotify+0x0)[0x55ae4671fefa] postgres: mynode: worker_spi worker 3 (main+0x2f7)[0x55ae464bdd73] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xea)[0x7ffa02918d0a] postgres: mynode: worker_spi worker 3 (_start+0x2a)[0x55ae45e3c49a] 2024-06-09 07:32:06.536 UTC [29495][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:06.537 UTC [29495][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/modules/worker_spi/tmp_check/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-09 07:32:06.537 UTC [29495][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-09 07:32:06.591 UTC [29495][client backend] [001_worker_spi.pl][0/2:0] LOG: statement: SELECT datname, count(datname), wait_event FROM pg_stat_activity WHERE backend_type = 'worker_spi' GROUP BY datname, wait_event; 2024-06-09 07:32:06.616 UTC [29495][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.087 user=postgres database=mydb host=[local] 2024-06-09 07:32:06.760 UTC [29520][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:06.761 UTC [29520][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/modules/worker_spi/tmp_check/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-09 07:32:06.761 UTC [29520][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-09 07:32:06.769 UTC [29520][client backend] [001_worker_spi.pl][1/2:0] LOG: statement: SELECT datname, count(datname), wait_event FROM pg_stat_activity WHERE backend_type = 'worker_spi' GROUP BY datname, wait_event; 2024-06-09 07:32:06.805 UTC [29520][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.048 user=postgres database=mydb host=[local] 2024-06-09 07:32:06.932 UTC [29537][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:06.934 UTC [29537][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/modules/worker_spi/tmp_check/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-09 07:32:06.934 UTC [29537][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-09 07:32:06.936 UTC [29537][client backend] [001_worker_spi.pl][2/2:0] LOG: statement: SELECT datname, count(datname), wait_event FROM pg_stat_activity WHERE backend_type = 'worker_spi' GROUP BY datname, wait_event; 2024-06-09 07:32:06.958 UTC [29537][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.028 user=postgres database=mydb host=[local] 2024-06-09 07:32:07.070 UTC [29558][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:07.071 UTC [29558][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/modules/worker_spi/tmp_check/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-09 07:32:07.071 UTC [29558][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-09 07:32:07.073 UTC [29558][client backend] [001_worker_spi.pl][3/2:0] LOG: statement: SELECT datname, count(datname), wait_event FROM pg_stat_activity WHERE backend_type = 'worker_spi' GROUP BY datname, wait_event; 2024-06-09 07:32:07.092 UTC [29558][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=postgres database=mydb host=[local] 2024-06-09 07:32:07.240 UTC [29575][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:07.242 UTC [29575][client backend] [[unknown]][4/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/modules/worker_spi/tmp_check/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-09 07:32:07.242 UTC [29575][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-09 07:32:07.248 UTC [29575][client backend] [001_worker_spi.pl][4/2:0] LOG: statement: SELECT datname, count(datname), wait_event FROM pg_stat_activity WHERE backend_type = 'worker_spi' GROUP BY datname, wait_event; 2024-06-09 07:32:07.272 UTC [29575][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.033 user=postgres database=mydb host=[local] 2024-06-09 07:32:07.414 UTC [29604][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:07.418 UTC [29604][client backend] [[unknown]][5/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/modules/worker_spi/tmp_check/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-09 07:32:07.418 UTC [29604][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-09 07:32:07.420 UTC [29604][client backend] [001_worker_spi.pl][5/2:0] LOG: statement: SELECT datname, count(datname), wait_event FROM pg_stat_activity WHERE backend_type = 'worker_spi' GROUP BY datname, wait_event; 2024-06-09 07:32:07.440 UTC [29604][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.043 user=postgres database=mydb host=[local] 2024-06-09 07:32:07.572 UTC [29633][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:07.574 UTC [29633][client backend] [[unknown]][6/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/modules/worker_spi/tmp_check/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-09 07:32:07.574 UTC [29633][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-09 07:32:07.582 UTC [29633][client backend] [001_worker_spi.pl][6/2:0] LOG: statement: SELECT datname, count(datname), wait_event FROM pg_stat_activity WHERE backend_type = 'worker_spi' GROUP BY datname, wait_event; 2024-06-09 07:32:07.609 UTC [29633][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.037 user=postgres database=mydb host=[local] 2024-06-09 07:32:07.722 UTC [29658][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:07.723 UTC [29658][client backend] [[unknown]][7/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/modules/worker_spi/tmp_check/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-09 07:32:07.723 UTC [29658][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-09 07:32:07.725 UTC [29658][client backend] [001_worker_spi.pl][7/2:0] LOG: statement: SELECT datname, count(datname), wait_event FROM pg_stat_activity WHERE backend_type = 'worker_spi' GROUP BY datname, wait_event; 2024-06-09 07:32:07.735 UTC [29658][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=postgres database=mydb host=[local] 2024-06-09 07:32:07.874 UTC [29684][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:07.877 UTC [29684][client backend] [[unknown]][8/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/modules/worker_spi/tmp_check/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-09 07:32:07.877 UTC [29684][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-09 07:32:07.879 UTC [29684][client backend] [001_worker_spi.pl][8/2:0] LOG: statement: SELECT datname, count(datname), wait_event FROM pg_stat_activity WHERE backend_type = 'worker_spi' GROUP BY datname, wait_event; 2024-06-09 07:32:07.899 UTC [29684][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.025 user=postgres database=mydb host=[local] 2024-06-09 07:32:08.038 UTC [29702][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:08.040 UTC [29702][client backend] [[unknown]][9/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/modules/worker_spi/tmp_check/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-09 07:32:08.040 UTC [29702][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-09 07:32:08.042 UTC [29702][client backend] [001_worker_spi.pl][9/2:0] LOG: statement: SELECT datname, count(datname), wait_event FROM pg_stat_activity WHERE backend_type = 'worker_spi' GROUP BY datname, wait_event; 2024-06-09 07:32:08.052 UTC [29702][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=postgres database=mydb host=[local] 2024-06-09 07:32:08.172 UTC [29721][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:08.173 UTC [29721][client backend] [[unknown]][10/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/modules/worker_spi/tmp_check/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-09 07:32:08.173 UTC [29721][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-09 07:32:08.175 UTC [29721][client backend] [001_worker_spi.pl][10/2:0] LOG: statement: SELECT datname, count(datname), wait_event FROM pg_stat_activity WHERE backend_type = 'worker_spi' GROUP BY datname, wait_event; 2024-06-09 07:32:08.189 UTC [29721][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=postgres database=mydb host=[local] 2024-06-09 07:32:08.294 UTC [29453][postmaster] LOG: background worker "worker_spi" (PID 29479) was terminated by signal 6: Aborted 2024-06-09 07:32:08.294 UTC [29453][postmaster] LOG: terminating any other active server processes 2024-06-09 07:32:08.332 UTC [29730][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:08.332 UTC [29730][client backend] [[unknown]][:0] FATAL: the database system is in recovery mode 2024-06-09 07:32:08.460 UTC [29749][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:08.460 UTC [29749][client backend] [[unknown]][:0] FATAL: the database system is in recovery mode 2024-06-09 07:32:08.603 UTC [29769][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:08.603 UTC [29769][client backend] [[unknown]][:0] FATAL: the database system is in recovery mode 2024-06-09 07:32:08.745 UTC [29794][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:08.745 UTC [29794][client backend] [[unknown]][:0] FATAL: the database system is in recovery mode 2024-06-09 07:32:08.861 UTC [29809][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-09 07:32:08.861 UTC [29809][client backend] [[unknown]][:0] FATAL: the database system is in recovery mode 2024-06-09 07:32:08.969 UTC [29453][postmaster] LOG: shutting down because "restart_after_crash" is off 2024-06-09 07:32:09.035 UTC [29453][postmaster] LOG: database system is shut down