2024-06-12 23:39:49.737 UTC [36045][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-12 23:39:49.737 UTC [36045][postmaster] LOG: listening on Unix socket "/tmp/KX0L8RFdg6/.s.PGSQL.59245" 2024-06-12 23:39:49.761 UTC [36052][startup] LOG: database system was shut down at 2024-06-12 23:37:00 UTC 2024-06-12 23:39:49.770 UTC [36045][postmaster] LOG: database system is ready to accept connections 2024-06-12 23:39:49.805 UTC [36058][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:49.806 UTC [36058][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-12 23:39:49.806 UTC [36058][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-12 23:39:49.839 UTC [36058][client backend] [001_worker_spi.pl][0/2:0] LOG: statement: CREATE EXTENSION worker_spi; 2024-06-12 23:39:49.850 UTC [36058][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.045 user=postgres database=postgres host=[local] 2024-06-12 23:39:49.905 UTC [36072][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:49.906 UTC [36072][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-12 23:39:49.906 UTC [36072][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-12 23:39:49.914 UTC [36072][client backend] [001_worker_spi.pl][1/2:0] LOG: statement: SELECT worker_spi_launch(4) IS NOT NULL; 2024-06-12 23:39:49.923 UTC [36072][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=postgres database=postgres host=[local] 2024-06-12 23:39:49.935 UTC [36076][worker_spi dynamic] LOG: worker_spi dynamic worker 4 initialized with schema4.counted 2024-06-12 23:39:49.956 UTC [36080][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:49.957 UTC [36080][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-12 23:39:49.957 UTC [36080][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-12 23:39:49.958 UTC [36080][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-12 23:39:49.979 UTC [36080][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.031 user=postgres database=postgres host=[local] 2024-06-12 23:39:50.005 UTC [36085][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:50.006 UTC [36085][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-12 23:39:50.006 UTC [36085][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-12 23:39:50.016 UTC [36085][client backend] [001_worker_spi.pl][3/2:0] LOG: statement: INSERT INTO schema4.counted VALUES ('total', 0), ('delta', 1); 2024-06-12 23:39:50.019 UTC [36085][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=postgres database=postgres host=[local] 2024-06-12 23:39:50.032 UTC [36045][postmaster] LOG: received SIGHUP, reloading configuration files 2024-06-12 23:39:50.035 UTC [36076][worker_spi dynamic] LOG: worker_spi dynamic worker 4: count in schema4.counted is now 1 2024-06-12 23:39:50.035 UTC [36076][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-12 23:39:50.076 UTC [36103][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:50.077 UTC [36103][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-12 23:39:50.077 UTC [36103][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-12 23:39:50.079 UTC [36103][client backend] [001_worker_spi.pl][4/2:0] LOG: statement: SELECT count(*) FROM schema4.counted WHERE type = 'delta'; 2024-06-12 23:39:50.088 UTC [36103][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=postgres database=postgres host=[local] 2024-06-12 23:39:50.118 UTC [36112][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:50.119 UTC [36112][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-12 23:39:50.119 UTC [36112][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-12 23:39:50.125 UTC [36112][client backend] [001_worker_spi.pl][5/2:0] LOG: statement: SELECT * FROM schema4.counted; 2024-06-12 23:39:50.128 UTC [36112][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=postgres database=postgres host=[local] 2024-06-12 23:39:50.161 UTC [36117][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:50.162 UTC [36117][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-12 23:39:50.162 UTC [36117][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-12 23:39:50.164 UTC [36117][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-12 23:39:50.174 UTC [36117][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.018 user=postgres database=postgres host=[local] 2024-06-12 23:39:50.195 UTC [36128][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:50.196 UTC [36128][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-12 23:39:50.196 UTC [36128][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-12 23:39:50.198 UTC [36128][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-12 23:39:50.205 UTC [36128][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=postgres database=postgres host=[local] 2024-06-12 23:39:50.237 UTC [36141][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:50.239 UTC [36141][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-12 23:39:50.239 UTC [36141][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-12 23:39:50.240 UTC [36141][client backend] [001_worker_spi.pl][8/2:0] LOG: statement: CREATE DATABASE mydb; 2024-06-12 23:39:50.322 UTC [36141][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.084 user=postgres database=postgres host=[local] 2024-06-12 23:39:50.360 UTC [36153][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:50.361 UTC [36153][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-12 23:39:50.361 UTC [36153][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-12 23:39:50.363 UTC [36153][client backend] [001_worker_spi.pl][9/2:0] LOG: statement: CREATE ROLE myrole SUPERUSER LOGIN; 2024-06-12 23:39:50.366 UTC [36153][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.006 user=postgres database=postgres host=[local] 2024-06-12 23:39:50.400 UTC [36158][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:50.401 UTC [36158][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-12 23:39:50.401 UTC [36158][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-12 23:39:50.414 UTC [36158][client backend] [001_worker_spi.pl][10/2:0] LOG: statement: CREATE EXTENSION worker_spi; 2024-06-12 23:39:50.420 UTC [36158][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.032 user=postgres database=mydb host=[local] 2024-06-12 23:39:50.431 UTC [36045][postmaster] LOG: received fast shutdown request 2024-06-12 23:39:50.431 UTC [36045][postmaster] LOG: aborting any active transactions 2024-06-12 23:39:50.431 UTC [36076][worker_spi dynamic] FATAL: terminating background worker "worker_spi dynamic" due to administrator command 2024-06-12 23:39:50.437 UTC [36045][postmaster] LOG: background worker "logical replication launcher" (PID 36055) exited with exit code 1 2024-06-12 23:39:50.448 UTC [36045][postmaster] LOG: background worker "worker_spi dynamic" (PID 36076) exited with exit code 1 2024-06-12 23:39:50.448 UTC [36049][checkpointer] LOG: shutting down 2024-06-12 23:39:50.448 UTC [36049][checkpointer] LOG: checkpoint starting: shutdown immediate 2024-06-12 23:39:50.471 UTC [36049][checkpointer] LOG: checkpoint complete: wrote 1009 buffers (6.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.023 s, sync=0.001 s, total=0.023 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-12 23:39:50.495 UTC [36045][postmaster] LOG: database system is shut down 2024-06-12 23:39:50.604 UTC [36184][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-12 23:39:50.604 UTC [36184][postmaster] LOG: listening on Unix socket "/tmp/KX0L8RFdg6/.s.PGSQL.59245" 2024-06-12 23:39:50.619 UTC [36201][startup] LOG: database system was shut down at 2024-06-12 23:39:50 UTC 2024-06-12 23:39:50.665 UTC [36184][postmaster] LOG: database system is ready to accept connections TRAP: failed Assert("OidIsValid(dboid)"), File: "worker_spi.c", Line: 170, PID: 36213 /lib/x86_64-linux-gnu/libasan.so.6(+0x43df1)[0x7fb15e118df1] postgres: mynode: worker_spi worker 3 (ExceptionalCondition+0xe6)[0x55e701430318] /tmp/cirrus-ci-build/tmp_install/usr/local/pgsql/lib/worker_spi.so(worker_spi_main+0x291)[0x7fb157ca6d51] postgres: mynode: worker_spi worker 3 (BackgroundWorkerMain+0x4c9)[0x55e700f3cfd7] postgres: mynode: worker_spi worker 3 (postmaster_child_launch+0x17f)[0x55e700f40731] postgres: mynode: worker_spi worker 3 (+0xcea980)[0x55e700f46980] postgres: mynode: worker_spi worker 3 (+0xceb0dd)[0x55e700f470dd] postgres: mynode: worker_spi worker 3 (+0xceb41e)[0x55e700f4741e] postgres: mynode: worker_spi worker 3 (+0xcecb6b)[0x55e700f48b6b] TRAP: failed Assert("OidIsValid(dboid)"), File: "worker_spi.c", Line: 170, PID: 36216 /lib/x86_64-linux-gnu/libasan.so.6(+0x43df1)[0x7fb15e118df1] postgres: mynode: worker_spi worker 1 (ExceptionalCondition+0xe6)[0x55e701430318] /tmp/cirrus-ci-build/tmp_install/usr/local/pgsql/lib/worker_spi.so(worker_spi_main+0x291)[0x7fb157ca6d51] postgres: mynode: worker_spi worker 1 (BackgroundWorkerMain+0x4c9)[0x55e700f3cfd7] postgres: mynode: worker_spi worker 1 (postmaster_child_launch+0x17f)[0x55e700f40731] postgres: mynode: worker_spi worker 1 (+0xcea980)[0x55e700f46980] postgres: mynode: worker_spi worker 1 (+0xceb0dd)[0x55e700f470dd] postgres: mynode: worker_spi worker 1 (+0xceb41e)[0x55e700f4741e] postgres: mynode: worker_spi worker 1 (+0xcecb6b)[0x55e700f48b6b] postgres: mynode: worker_spi worker 1 (PostmasterMarkPIDForWorkerNotify+0x0)[0x55e700f4aff2] postgres: mynode: worker_spi worker 1 (main+0x2f7)[0x55e700ce8d73] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xea)[0x7fb15d0fbd0a] postgres: mynode: worker_spi worker 1 (_start+0x2a)[0x55e70066749a] postgres: mynode: worker_spi worker 3 (PostmasterMarkPIDForWorkerNotify+0x0)[0x55e700f4aff2] postgres: mynode: worker_spi worker 3 (main+0x2f7)[0x55e700ce8d73] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xea)[0x7fb15d0fbd0a] postgres: mynode: worker_spi worker 3 (_start+0x2a)[0x55e70066749a] TRAP: failed Assert("OidIsValid(dboid)"), File: "worker_spi.c", Line: 170, PID: 36214 /lib/x86_64-linux-gnu/libasan.so.6(+0x43df1)[0x7fb15e118df1] postgres: mynode: worker_spi worker 2 (ExceptionalCondition+0xe6)[0x55e701430318] /tmp/cirrus-ci-build/tmp_install/usr/local/pgsql/lib/worker_spi.so(worker_spi_main+0x291)[0x7fb157ca6d51] postgres: mynode: worker_spi worker 2 (BackgroundWorkerMain+0x4c9)[0x55e700f3cfd7] postgres: mynode: worker_spi worker 2 (postmaster_child_launch+0x17f)[0x55e700f40731] postgres: mynode: worker_spi worker 2 (+0xcea980)[0x55e700f46980] postgres: mynode: worker_spi worker 2 (+0xceb0dd)[0x55e700f470dd] postgres: mynode: worker_spi worker 2 (+0xceb41e)[0x55e700f4741e] postgres: mynode: worker_spi worker 2 (+0xcecb6b)[0x55e700f48b6b] postgres: mynode: worker_spi worker 2 (PostmasterMarkPIDForWorkerNotify+0x0)[0x55e700f4aff2] postgres: mynode: worker_spi worker 2 (main+0x2f7)[0x55e700ce8d73] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xea)[0x7fb15d0fbd0a] postgres: mynode: worker_spi worker 2 (_start+0x2a)[0x55e70066749a] 2024-06-12 23:39:50.789 UTC [36238][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:50.790 UTC [36238][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-12 23:39:50.790 UTC [36238][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-12 23:39:50.824 UTC [36238][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-12 23:39:50.846 UTC [36238][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.057 user=postgres database=mydb host=[local] 2024-06-12 23:39:50.973 UTC [36259][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:50.974 UTC [36259][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-12 23:39:50.974 UTC [36259][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-12 23:39:50.983 UTC [36259][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-12 23:39:51.007 UTC [36259][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.035 user=postgres database=mydb host=[local] 2024-06-12 23:39:51.135 UTC [36272][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:51.136 UTC [36272][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-12 23:39:51.136 UTC [36272][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-12 23:39:51.149 UTC [36272][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-12 23:39:51.162 UTC [36272][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.027 user=postgres database=mydb host=[local] 2024-06-12 23:39:51.299 UTC [36284][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:51.308 UTC [36284][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-12 23:39:51.308 UTC [36284][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-12 23:39:51.312 UTC [36284][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-12 23:39:51.336 UTC [36284][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.038 user=postgres database=mydb host=[local] 2024-06-12 23:39:51.488 UTC [36312][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:51.489 UTC [36312][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-12 23:39:51.489 UTC [36312][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-12 23:39:51.497 UTC [36312][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-12 23:39:51.508 UTC [36312][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.024 user=postgres database=mydb host=[local] 2024-06-12 23:39:51.644 UTC [36330][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:51.645 UTC [36330][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-12 23:39:51.645 UTC [36330][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-12 23:39:51.650 UTC [36330][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-12 23:39:51.675 UTC [36330][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.031 user=postgres database=mydb host=[local] 2024-06-12 23:39:51.796 UTC [36353][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:51.797 UTC [36353][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-12 23:39:51.797 UTC [36353][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-12 23:39:51.800 UTC [36353][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-12 23:39:51.819 UTC [36353][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.024 user=postgres database=mydb host=[local] 2024-06-12 23:39:51.946 UTC [36374][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:51.947 UTC [36374][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-12 23:39:51.947 UTC [36374][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-12 23:39:51.948 UTC [36374][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-12 23:39:51.958 UTC [36374][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=postgres database=mydb host=[local] 2024-06-12 23:39:52.087 UTC [36390][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:52.088 UTC [36390][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-12 23:39:52.088 UTC [36390][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-12 23:39:52.093 UTC [36390][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-12 23:39:52.109 UTC [36390][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=postgres database=mydb host=[local] 2024-06-12 23:39:52.247 UTC [36407][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:52.249 UTC [36407][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-12 23:39:52.249 UTC [36407][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-12 23:39:52.250 UTC [36407][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-12 23:39:52.260 UTC [36407][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.023 user=postgres database=mydb host=[local] 2024-06-12 23:39:52.377 UTC [36421][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:52.378 UTC [36421][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-12 23:39:52.378 UTC [36421][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-12 23:39:52.380 UTC [36421][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-12 23:39:52.389 UTC [36421][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=postgres database=mydb host=[local] 2024-06-12 23:39:52.524 UTC [36449][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:52.525 UTC [36449][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-12 23:39:52.525 UTC [36449][client backend] [[unknown]][11/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-12 23:39:52.526 UTC [36449][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-12 23:39:52.541 UTC [36449][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.021 user=postgres database=mydb host=[local] 2024-06-12 23:39:52.681 UTC [36466][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:52.682 UTC [36466][client backend] [[unknown]][12/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-12 23:39:52.682 UTC [36466][client backend] [[unknown]][12/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-12 23:39:52.684 UTC [36466][client backend] [001_worker_spi.pl][12/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-12 23:39:52.711 UTC [36466][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.035 user=postgres database=mydb host=[local] 2024-06-12 23:39:52.839 UTC [36488][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:52.841 UTC [36488][client backend] [[unknown]][13/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-12 23:39:52.841 UTC [36488][client backend] [[unknown]][13/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-12 23:39:52.848 UTC [36488][client backend] [001_worker_spi.pl][13/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-12 23:39:52.863 UTC [36488][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.024 user=postgres database=mydb host=[local] 2024-06-12 23:39:52.995 UTC [36499][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:52.997 UTC [36499][client backend] [[unknown]][14/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-12 23:39:52.997 UTC [36499][client backend] [[unknown]][14/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-12 23:39:52.998 UTC [36499][client backend] [001_worker_spi.pl][14/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-12 23:39:53.008 UTC [36499][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=postgres database=mydb host=[local] 2024-06-12 23:39:53.133 UTC [36525][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:53.135 UTC [36525][client backend] [[unknown]][15/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-12 23:39:53.135 UTC [36525][client backend] [[unknown]][15/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-12 23:39:53.137 UTC [36525][client backend] [001_worker_spi.pl][15/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-12 23:39:53.147 UTC [36525][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=postgres database=mydb host=[local] 2024-06-12 23:39:53.259 UTC [36533][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-12 23:39:53.280 UTC [36533][client backend] [[unknown]][16/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-12 23:39:53.280 UTC [36533][client backend] [[unknown]][16/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-12 23:39:53.282 UTC [36533][client backend] [001_worker_spi.pl][16/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-12 23:39:53.295 UTC [36184][postmaster] LOG: background worker "worker_spi" (PID 36214) was terminated by signal 6: Aborted 2024-06-12 23:39:53.296 UTC [36184][postmaster] LOG: terminating any other active server processes 2024-06-12 23:39:53.339 UTC [36184][postmaster] LOG: shutting down because "restart_after_crash" is off 2024-06-12 23:39:53.381 UTC [36184][postmaster] LOG: database system is shut down