2024-06-03 22:39:11.552 UTC [34629][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-03 22:39:11.552 UTC [34629][postmaster] LOG: listening on Unix socket "/tmp/cqdCtxmdFK/.s.PGSQL.54545" 2024-06-03 22:39:11.563 UTC [34641][startup] LOG: database system was shut down at 2024-06-03 22:36:14 UTC 2024-06-03 22:39:11.577 UTC [34629][postmaster] LOG: database system is ready to accept connections 2024-06-03 22:39:11.639 UTC [34660][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-03 22:39:11.640 UTC [34660][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-03 22:39:11.640 UTC [34660][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-03 22:39:11.677 UTC [34660][client backend] [001_worker_spi.pl][0/2:0] LOG: statement: CREATE EXTENSION worker_spi; 2024-06-03 22:39:11.688 UTC [34660][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.050 user=postgres database=postgres host=[local] 2024-06-03 22:39:11.718 UTC [34680][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-03 22:39:11.720 UTC [34680][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-03 22:39:11.720 UTC [34680][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-03 22:39:11.722 UTC [34680][client backend] [001_worker_spi.pl][1/2:0] LOG: statement: SELECT worker_spi_launch(4) IS NOT NULL; 2024-06-03 22:39:11.728 UTC [34687][worker_spi dynamic] LOG: worker_spi dynamic worker 4 initialized with schema4.counted 2024-06-03 22:39:11.730 UTC [34680][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.021 user=postgres database=postgres host=[local] 2024-06-03 22:39:11.774 UTC [34697][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-03 22:39:11.775 UTC [34697][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-03 22:39:11.775 UTC [34697][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-03 22:39:11.779 UTC [34697][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-03 22:39:11.805 UTC [34697][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.031 user=postgres database=postgres host=[local] 2024-06-03 22:39:11.850 UTC [34710][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-03 22:39:11.852 UTC [34710][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-03 22:39:11.852 UTC [34710][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-03 22:39:11.856 UTC [34710][client backend] [001_worker_spi.pl][3/2:0] LOG: statement: INSERT INTO schema4.counted VALUES ('total', 0), ('delta', 1); 2024-06-03 22:39:11.867 UTC [34710][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.018 user=postgres database=postgres host=[local] 2024-06-03 22:39:11.889 UTC [34629][postmaster] LOG: received SIGHUP, reloading configuration files 2024-06-03 22:39:11.892 UTC [34687][worker_spi dynamic] LOG: worker_spi dynamic worker 4: count in schema4.counted is now 1 2024-06-03 22:39:11.892 UTC [34687][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-03 22:39:11.907 UTC [34726][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-03 22:39:11.908 UTC [34726][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-03 22:39:11.908 UTC [34726][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-03 22:39:11.910 UTC [34726][client backend] [001_worker_spi.pl][4/2:0] LOG: statement: SELECT count(*) FROM schema4.counted WHERE type = 'delta'; 2024-06-03 22:39:11.917 UTC [34726][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=postgres database=postgres host=[local] 2024-06-03 22:39:11.946 UTC [34732][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-03 22:39:11.948 UTC [34732][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-03 22:39:11.948 UTC [34732][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-03 22:39:11.952 UTC [34732][client backend] [001_worker_spi.pl][5/2:0] LOG: statement: SELECT * FROM schema4.counted; 2024-06-03 22:39:11.961 UTC [34732][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=postgres database=postgres host=[local] 2024-06-03 22:39:11.993 UTC [34740][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-03 22:39:11.995 UTC [34740][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-03 22:39:11.995 UTC [34740][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-03 22:39:11.997 UTC [34740][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-03 22:39:12.034 UTC [34740][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.040 user=postgres database=postgres host=[local] 2024-06-03 22:39:12.037 UTC [34752][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-03 22:39:12.038 UTC [34752][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-03 22:39:12.038 UTC [34752][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-03 22:39:12.044 UTC [34752][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-03 22:39:12.059 UTC [34752][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=postgres database=postgres host=[local] 2024-06-03 22:39:12.104 UTC [34762][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-03 22:39:12.106 UTC [34762][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-03 22:39:12.106 UTC [34762][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-03 22:39:12.109 UTC [34762][client backend] [001_worker_spi.pl][8/2:0] LOG: statement: CREATE DATABASE mydb; 2024-06-03 22:39:12.286 UTC [34762][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.182 user=postgres database=postgres host=[local] 2024-06-03 22:39:12.303 UTC [34803][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-03 22:39:12.304 UTC [34803][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-03 22:39:12.304 UTC [34803][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-03 22:39:12.314 UTC [34803][client backend] [001_worker_spi.pl][9/2:0] LOG: statement: CREATE ROLE myrole SUPERUSER LOGIN; 2024-06-03 22:39:12.315 UTC [34803][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=postgres database=postgres host=[local] 2024-06-03 22:39:12.370 UTC [34809][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-03 22:39:12.371 UTC [34809][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-03 22:39:12.371 UTC [34809][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-03 22:39:12.402 UTC [34809][client backend] [001_worker_spi.pl][10/2:0] LOG: statement: CREATE EXTENSION worker_spi; 2024-06-03 22:39:12.409 UTC [34809][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.050 user=postgres database=mydb host=[local] 2024-06-03 22:39:12.422 UTC [34629][postmaster] LOG: received fast shutdown request 2024-06-03 22:39:12.422 UTC [34629][postmaster] LOG: aborting any active transactions 2024-06-03 22:39:12.422 UTC [34687][worker_spi dynamic] FATAL: terminating background worker "worker_spi dynamic" due to administrator command 2024-06-03 22:39:12.440 UTC [34629][postmaster] LOG: background worker "logical replication launcher" (PID 34649) exited with exit code 1 2024-06-03 22:39:12.444 UTC [34629][postmaster] LOG: background worker "worker_spi dynamic" (PID 34687) exited with exit code 1 2024-06-03 22:39:12.444 UTC [34639][checkpointer] LOG: shutting down 2024-06-03 22:39:12.444 UTC [34639][checkpointer] LOG: checkpoint starting: shutdown immediate 2024-06-03 22:39:12.457 UTC [34639][checkpointer] LOG: checkpoint complete: wrote 1009 buffers (6.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.013 s, sync=0.001 s, total=0.013 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-03 22:39:12.470 UTC [34629][postmaster] LOG: database system is shut down 2024-06-03 22:39:12.610 UTC [34837][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-03 22:39:12.610 UTC [34837][postmaster] LOG: listening on Unix socket "/tmp/cqdCtxmdFK/.s.PGSQL.54545" 2024-06-03 22:39:12.627 UTC [34851][startup] LOG: database system was shut down at 2024-06-03 22:39:12 UTC 2024-06-03 22:39:12.683 UTC [34837][postmaster] LOG: database system is ready to accept connections TRAP: failed Assert("OidIsValid(dboid)"), File: "worker_spi.c", Line: 170, PID: 34871 /lib/x86_64-linux-gnu/libasan.so.6(+0x43df1)[0x7ff37f8fbdf1] postgres: mynode: worker_spi worker 1 (ExceptionalCondition+0xe6)[0x55e26231f544] /tmp/cirrus-ci-build/tmp_install/usr/local/pgsql/lib/worker_spi.so(worker_spi_main+0x291)[0x7ff379489d51] postgres: mynode: worker_spi worker 1 (BackgroundWorkerMain+0x4c9)[0x55e261e2c485] postgres: mynode: worker_spi worker 1 (postmaster_child_launch+0x17f)[0x55e261e2fbdf] postgres: mynode: worker_spi worker 1 (+0xce8e2e)[0x55e261e35e2e] postgres: mynode: worker_spi worker 1 (+0xce958b)[0x55e261e3658b] postgres: mynode: worker_spi worker 1 (+0xce98cc)[0x55e261e368cc] postgres: mynode: worker_spi worker 1 (+0xceb019)[0x55e261e38019] postgres: mynode: worker_spi worker 1 (PostmasterMarkPIDForWorkerNotify+0x0)[0x55e261e3a4a0] postgres: mynode: worker_spi worker 1 (main+0x2f7)[0x55e261bd8dbd] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xea)[0x7ff37e8ded0a] postgres: mynode: worker_spi worker 1 (_start+0x2a)[0x55e26155749a] TRAP: failed Assert("OidIsValid(dboid)"), File: "worker_spi.c", Line: 170, PID: 34869 /lib/x86_64-linux-gnu/libasan.so.6(+0x43df1)[0x7ff37f8fbdf1] postgres: mynode: worker_spi worker 3 (ExceptionalCondition+0xe6)[0x55e26231f544] /tmp/cirrus-ci-build/tmp_install/usr/local/pgsql/lib/worker_spi.so(worker_spi_main+0x291)[0x7ff379489d51] postgres: mynode: worker_spi worker 3 (BackgroundWorkerMain+0x4c9)[0x55e261e2c485] postgres: mynode: worker_spi worker 3 (postmaster_child_launch+0x17f)[0x55e261e2fbdf] postgres: mynode: worker_spi worker 3 (+0xce8e2e)[0x55e261e35e2e] postgres: mynode: worker_spi worker 3 (+0xce958b)[0x55e261e3658b] postgres: mynode: worker_spi worker 3 (+0xce98cc)[0x55e261e368cc] postgres: mynode: worker_spi worker 3 (+0xceb019)[0x55e261e38019] postgres: mynode: worker_spi worker 3 (PostmasterMarkPIDForWorkerNotify+0x0)[0x55e261e3a4a0] postgres: mynode: worker_spi worker 3 (main+0x2f7)[0x55e261bd8dbd] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xea)[0x7ff37e8ded0a] postgres: mynode: worker_spi worker 3 (_start+0x2a)[0x55e26155749a] TRAP: failed Assert("OidIsValid(dboid)"), File: "worker_spi.c", Line: 170, PID: 34870 /lib/x86_64-linux-gnu/libasan.so.6(+0x43df1)[0x7ff37f8fbdf1] postgres: mynode: worker_spi worker 2 (ExceptionalCondition+0xe6)[0x55e26231f544] /tmp/cirrus-ci-build/tmp_install/usr/local/pgsql/lib/worker_spi.so(worker_spi_main+0x291)[0x7ff379489d51] postgres: mynode: worker_spi worker 2 (BackgroundWorkerMain+0x4c9)[0x55e261e2c485] postgres: mynode: worker_spi worker 2 (postmaster_child_launch+0x17f)[0x55e261e2fbdf] postgres: mynode: worker_spi worker 2 (+0xce8e2e)[0x55e261e35e2e] postgres: mynode: worker_spi worker 2 (+0xce958b)[0x55e261e3658b] postgres: mynode: worker_spi worker 2 (+0xce98cc)[0x55e261e368cc] postgres: mynode: worker_spi worker 2 (+0xceb019)[0x55e261e38019] postgres: mynode: worker_spi worker 2 (PostmasterMarkPIDForWorkerNotify+0x0)[0x55e261e3a4a0] postgres: mynode: worker_spi worker 2 (main+0x2f7)[0x55e261bd8dbd] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xea)[0x7ff37e8ded0a] postgres: mynode: worker_spi worker 2 (_start+0x2a)[0x55e26155749a] 2024-06-03 22:39:12.799 UTC [34904][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-03 22:39:12.800 UTC [34904][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-03 22:39:12.800 UTC [34904][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-03 22:39:12.846 UTC [34904][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-03 22:39:12.866 UTC [34904][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.067 user=postgres database=mydb host=[local] 2024-06-03 22:39:12.990 UTC [34963][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-03 22:39:12.992 UTC [34963][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-03 22:39:12.992 UTC [34963][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-03 22:39:13.006 UTC [34963][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-03 22:39:13.023 UTC [34963][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.034 user=postgres database=mydb host=[local] 2024-06-03 22:39:13.196 UTC [35002][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-03 22:39:13.197 UTC [35002][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-03 22:39:13.197 UTC [35002][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-03 22:39:13.206 UTC [35002][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-03 22:39:13.252 UTC [35002][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.057 user=postgres database=mydb host=[local] 2024-06-03 22:39:13.393 UTC [35014][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-03 22:39:13.394 UTC [35014][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-03 22:39:13.394 UTC [35014][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-03 22:39:13.402 UTC [35014][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-03 22:39:13.443 UTC [35014][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.050 user=postgres database=mydb host=[local] 2024-06-03 22:39:13.591 UTC [35035][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-03 22:39:13.597 UTC [35035][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-03 22:39:13.597 UTC [35035][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-03 22:39:13.600 UTC [35035][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-03 22:39:13.633 UTC [35035][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.042 user=postgres database=mydb host=[local] 2024-06-03 22:39:13.769 UTC [35051][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-03 22:39:13.770 UTC [35051][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-03 22:39:13.770 UTC [35051][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-03 22:39:13.774 UTC [35051][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-03 22:39:13.796 UTC [35051][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.037 user=postgres database=mydb host=[local] 2024-06-03 22:39:13.921 UTC [35070][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-03 22:39:13.929 UTC [35070][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-03 22:39:13.929 UTC [35070][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-03 22:39:13.931 UTC [35070][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-03 22:39:13.945 UTC [35070][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.025 user=postgres database=mydb host=[local] 2024-06-03 22:39:14.060 UTC [35111][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-03 22:39:14.061 UTC [35111][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-03 22:39:14.061 UTC [35111][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-03 22:39:14.063 UTC [35111][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-03 22:39:14.073 UTC [35111][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=postgres database=mydb host=[local] 2024-06-03 22:39:14.200 UTC [35131][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-03 22:39:14.201 UTC [35131][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-03 22:39:14.201 UTC [35131][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-03 22:39:14.203 UTC [35131][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-03 22:39:14.214 UTC [35131][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=postgres database=mydb host=[local] 2024-06-03 22:39:14.362 UTC [35177][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-03 22:39:14.364 UTC [35177][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-03 22:39:14.364 UTC [35177][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-03 22:39:14.366 UTC [35177][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-03 22:39:14.378 UTC [35177][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.023 user=postgres database=mydb host=[local] 2024-06-03 22:39:14.501 UTC [35238][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-03 22:39:14.663 UTC [35238][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-03 22:39:14.663 UTC [35238][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-03 22:39:14.665 UTC [35238][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-03 22:39:14.779 UTC [35238][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.277 user=postgres database=mydb host=[local] 2024-06-03 22:39:14.975 UTC [35259][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-03 22:39:14.976 UTC [35259][client backend] [[unknown]][11/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-03 22:39:14.976 UTC [35259][client backend] [[unknown]][11/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-03 22:39:14.991 UTC [35259][client backend] [001_worker_spi.pl][11/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-03 22:39:15.005 UTC [35259][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.034 user=postgres database=mydb host=[local] 2024-06-03 22:39:15.111 UTC [34837][postmaster] LOG: background worker "worker_spi" (PID 34871) was terminated by signal 6: Aborted 2024-06-03 22:39:15.111 UTC [34837][postmaster] LOG: terminating any other active server processes 2024-06-03 22:39:15.206 UTC [35269][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-03 22:39:15.206 UTC [35269][client backend] [[unknown]][:0] FATAL: the database system is in recovery mode 2024-06-03 22:39:15.325 UTC [35297][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-03 22:39:15.326 UTC [35297][client backend] [[unknown]][:0] FATAL: the database system is in recovery mode 2024-06-03 22:39:15.418 UTC [34837][postmaster] LOG: shutting down because "restart_after_crash" is off 2024-06-03 22:39:15.552 UTC [34837][postmaster] LOG: database system is shut down