2024-07-01 07:11:17.569 UTC [35117][postmaster] LOG: starting PostgreSQL 18devel on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit 2024-07-01 07:11:17.569 UTC [35117][postmaster] LOG: listening on Unix socket "/tmp/sO58J9LKah/.s.PGSQL.55185" 2024-07-01 07:11:17.586 UTC [35127][startup] LOG: database system was shut down at 2024-07-01 07:08:30 UTC 2024-07-01 07:11:17.597 UTC [35117][postmaster] LOG: database system is ready to accept connections 2024-07-01 07:11:17.654 UTC [35141][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-07-01 07:11:17.655 UTC [35141][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-07-01 07:11:17.655 UTC [35141][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-07-01 07:11:17.702 UTC [35141][client backend] [001_worker_spi.pl][0/2:0] LOG: statement: CREATE EXTENSION worker_spi; 2024-07-01 07:11:17.711 UTC [35141][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.057 user=postgres database=postgres host=[local] 2024-07-01 07:11:17.753 UTC [35156][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-07-01 07:11:17.755 UTC [35156][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-07-01 07:11:17.755 UTC [35156][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-07-01 07:11:17.760 UTC [35156][client backend] [001_worker_spi.pl][1/2:0] LOG: statement: SELECT worker_spi_launch(4) IS NOT NULL; 2024-07-01 07:11:17.768 UTC [35156][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=postgres database=postgres host=[local] 2024-07-01 07:11:17.794 UTC [35161][worker_spi dynamic] LOG: worker_spi dynamic worker 4 initialized with schema4.counted 2024-07-01 07:11:17.840 UTC [35164][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-07-01 07:11:17.841 UTC [35164][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-07-01 07:11:17.841 UTC [35164][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-07-01 07:11:17.843 UTC [35164][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-07-01 07:11:17.877 UTC [35164][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.047 user=postgres database=postgres host=[local] 2024-07-01 07:11:17.923 UTC [35176][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-07-01 07:11:17.924 UTC [35176][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-07-01 07:11:17.924 UTC [35176][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-07-01 07:11:17.926 UTC [35176][client backend] [001_worker_spi.pl][3/2:0] LOG: statement: INSERT INTO schema4.counted VALUES ('total', 0), ('delta', 1); 2024-07-01 07:11:17.931 UTC [35176][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=postgres database=postgres host=[local] 2024-07-01 07:11:17.954 UTC [35117][postmaster] LOG: received SIGHUP, reloading configuration files 2024-07-01 07:11:17.957 UTC [35161][worker_spi dynamic] LOG: worker_spi dynamic worker 4: count in schema4.counted is now 1 2024-07-01 07:11:17.957 UTC [35161][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-07-01 07:11:17.986 UTC [35196][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-07-01 07:11:17.997 UTC [35196][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-07-01 07:11:17.997 UTC [35196][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-07-01 07:11:17.999 UTC [35196][client backend] [001_worker_spi.pl][4/2:0] LOG: statement: SELECT count(*) FROM schema4.counted WHERE type = 'delta'; 2024-07-01 07:11:18.006 UTC [35196][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.020 user=postgres database=postgres host=[local] 2024-07-01 07:11:18.040 UTC [35204][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-07-01 07:11:18.046 UTC [35204][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-07-01 07:11:18.046 UTC [35204][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-07-01 07:11:18.048 UTC [35204][client backend] [001_worker_spi.pl][5/2:0] LOG: statement: SELECT * FROM schema4.counted; 2024-07-01 07:11:18.054 UTC [35204][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=postgres database=postgres host=[local] 2024-07-01 07:11:18.079 UTC [35208][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-07-01 07:11:18.081 UTC [35208][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-07-01 07:11:18.081 UTC [35208][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-07-01 07:11:18.088 UTC [35208][client backend] [001_worker_spi.pl][6/2:0] LOG: statement: SELECT wait_event FROM pg_stat_activity WHERE backend_type ~ 'worker_spi'; 2024-07-01 07:11:18.106 UTC [35208][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.027 user=postgres database=postgres host=[local] 2024-07-01 07:11:18.156 UTC [35219][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-07-01 07:11:18.157 UTC [35219][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-07-01 07:11:18.157 UTC [35219][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-07-01 07:11:18.159 UTC [35219][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-07-01 07:11:18.161 UTC [35219][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=postgres database=postgres host=[local] 2024-07-01 07:11:18.208 UTC [35223][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-07-01 07:11:18.209 UTC [35223][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-07-01 07:11:18.209 UTC [35223][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-07-01 07:11:18.216 UTC [35223][client backend] [001_worker_spi.pl][8/2:0] LOG: statement: CREATE DATABASE mydb; 2024-07-01 07:11:18.287 UTC [35223][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.091 user=postgres database=postgres host=[local] 2024-07-01 07:11:18.312 UTC [35238][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-07-01 07:11:18.313 UTC [35238][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-07-01 07:11:18.313 UTC [35238][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-07-01 07:11:18.315 UTC [35238][client backend] [001_worker_spi.pl][9/2:0] LOG: statement: CREATE ROLE myrole SUPERUSER LOGIN; 2024-07-01 07:11:18.319 UTC [35238][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=postgres database=postgres host=[local] 2024-07-01 07:11:18.357 UTC [35243][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-07-01 07:11:18.358 UTC [35243][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-07-01 07:11:18.358 UTC [35243][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-07-01 07:11:18.386 UTC [35243][client backend] [001_worker_spi.pl][10/2:0] LOG: statement: CREATE EXTENSION worker_spi; 2024-07-01 07:11:18.394 UTC [35243][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.037 user=postgres database=mydb host=[local] 2024-07-01 07:11:18.405 UTC [35117][postmaster] LOG: received fast shutdown request 2024-07-01 07:11:18.405 UTC [35117][postmaster] LOG: aborting any active transactions 2024-07-01 07:11:18.405 UTC [35161][worker_spi dynamic] FATAL: terminating background worker "worker_spi dynamic" due to administrator command 2024-07-01 07:11:18.411 UTC [35117][postmaster] LOG: background worker "logical replication launcher" (PID 35136) exited with exit code 1 2024-07-01 07:11:18.418 UTC [35117][postmaster] LOG: background worker "worker_spi dynamic" (PID 35161) exited with exit code 1 2024-07-01 07:11:18.418 UTC [35125][checkpointer] LOG: shutting down 2024-07-01 07:11:18.418 UTC [35125][checkpointer] LOG: checkpoint starting: shutdown immediate 2024-07-01 07:11:18.436 UTC [35125][checkpointer] LOG: checkpoint complete: wrote 1009 buffers (6.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.017 s, sync=0.001 s, total=0.018 s; sync files=0, longest=0.000 s, average=0.000 s; distance=7761 kB, estimate=7761 kB; lsn=0/1CB4298, redo lsn=0/1CB4298 2024-07-01 07:11:18.465 UTC [35117][postmaster] LOG: database system is shut down 2024-07-01 07:11:18.607 UTC [35276][postmaster] LOG: starting PostgreSQL 18devel on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit 2024-07-01 07:11:18.607 UTC [35276][postmaster] LOG: listening on Unix socket "/tmp/sO58J9LKah/.s.PGSQL.55185" 2024-07-01 07:11:18.614 UTC [35297][startup] LOG: database system was shut down at 2024-07-01 07:11:18 UTC 2024-07-01 07:11:18.648 UTC [35276][postmaster] LOG: database system is ready to accept connections TRAP: failed Assert("OidIsValid(dboid)"), File: "worker_spi.c", Line: 170, PID: 35307 /lib/x86_64-linux-gnu/libasan.so.6(+0x43df1)[0x7f3b6cd58df1] postgres: mynode: worker_spi worker 1 (ExceptionalCondition+0xe6)[0x55f51d7531ea] /tmp/cirrus-ci-build/tmp_install/usr/local/pgsql/lib/worker_spi.so(worker_spi_main+0x291)[0x7f3b668e6d51] postgres: mynode: worker_spi worker 1 (BackgroundWorkerMain+0x4c9)[0x55f51d25f1a2] postgres: mynode: worker_spi worker 1 (postmaster_child_launch+0x17f)[0x55f51d262919] postgres: mynode: worker_spi worker 1 (+0xcebb68)[0x55f51d268b68] postgres: mynode: worker_spi worker 1 (+0xcec2c5)[0x55f51d2692c5] postgres: mynode: worker_spi worker 1 (+0xcec606)[0x55f51d269606] postgres: mynode: worker_spi worker 1 (+0xcedd53)[0x55f51d26ad53] postgres: mynode: worker_spi worker 1 (PostmasterMarkPIDForWorkerNotify+0x0)[0x55f51d26d1da] postgres: mynode: worker_spi worker 1 (main+0x2f7)[0x55f51d00b12a] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xea)[0x7f3b6bd3bd0a] postgres: mynode: worker_spi worker 1 (_start+0x2a)[0x55f51c98849a] TRAP: failed Assert("OidIsValid(dboid)"), File: "worker_spi.c", Line: 170, PID: 35304 /lib/x86_64-linux-gnu/libasan.so.6(+0x43df1)[0x7f3b6cd58df1] postgres: mynode: worker_spi worker 3 (ExceptionalCondition+0xe6)[0x55f51d7531ea] /tmp/cirrus-ci-build/tmp_install/usr/local/pgsql/lib/worker_spi.so(worker_spi_main+0x291)[0x7f3b668e6d51] postgres: mynode: worker_spi worker 3 (BackgroundWorkerMain+0x4c9)[0x55f51d25f1a2] postgres: mynode: worker_spi worker 3 (postmaster_child_launch+0x17f)[0x55f51d262919] postgres: mynode: worker_spi worker 3 (+0xcebb68)[0x55f51d268b68] postgres: mynode: worker_spi worker 3 (+0xcec2c5)[0x55f51d2692c5] postgres: mynode: worker_spi worker 3 (+0xcec606)[0x55f51d269606] postgres: mynode: worker_spi worker 3 (+0xcedd53)[0x55f51d26ad53] postgres: mynode: worker_spi worker 3 (PostmasterMarkPIDForWorkerNotify+0x0)[0x55f51d26d1da] postgres: mynode: worker_spi worker 3 (main+0x2f7)[0x55f51d00b12a] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xea)[0x7f3b6bd3bd0a] postgres: mynode: worker_spi worker 3 (_start+0x2a)[0x55f51c98849a] TRAP: failed Assert("OidIsValid(dboid)"), File: "worker_spi.c", Line: 170, PID: 35306 /lib/x86_64-linux-gnu/libasan.so.6(+0x43df1)[0x7f3b6cd58df1] postgres: mynode: worker_spi worker 2 (ExceptionalCondition+0xe6)[0x55f51d7531ea] /tmp/cirrus-ci-build/tmp_install/usr/local/pgsql/lib/worker_spi.so(worker_spi_main+0x291)[0x7f3b668e6d51] postgres: mynode: worker_spi worker 2 (BackgroundWorkerMain+0x4c9)[0x55f51d25f1a2] postgres: mynode: worker_spi worker 2 (postmaster_child_launch+0x17f)[0x55f51d262919] postgres: mynode: worker_spi worker 2 (+0xcebb68)[0x55f51d268b68] postgres: mynode: worker_spi worker 2 (+0xcec2c5)[0x55f51d2692c5] postgres: mynode: worker_spi worker 2 (+0xcec606)[0x55f51d269606] postgres: mynode: worker_spi worker 2 (+0xcedd53)[0x55f51d26ad53] postgres: mynode: worker_spi worker 2 (PostmasterMarkPIDForWorkerNotify+0x0)[0x55f51d26d1da] postgres: mynode: worker_spi worker 2 (main+0x2f7)[0x55f51d00b12a] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xea)[0x7f3b6bd3bd0a] postgres: mynode: worker_spi worker 2 (_start+0x2a)[0x55f51c98849a] 2024-07-01 07:11:18.798 UTC [35330][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-07-01 07:11:18.799 UTC [35330][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-07-01 07:11:18.799 UTC [35330][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-07-01 07:11:18.871 UTC [35330][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-07-01 07:11:18.912 UTC [35330][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.115 user=postgres database=mydb host=[local] 2024-07-01 07:11:19.076 UTC [35358][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-07-01 07:11:19.077 UTC [35358][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-07-01 07:11:19.077 UTC [35358][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-07-01 07:11:19.092 UTC [35358][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-07-01 07:11:19.124 UTC [35358][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.055 user=postgres database=mydb host=[local] 2024-07-01 07:11:19.266 UTC [35370][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-07-01 07:11:19.267 UTC [35370][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-07-01 07:11:19.267 UTC [35370][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-07-01 07:11:19.269 UTC [35370][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-07-01 07:11:19.280 UTC [35370][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=postgres database=mydb host=[local] 2024-07-01 07:11:19.426 UTC [35396][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-07-01 07:11:19.427 UTC [35396][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-07-01 07:11:19.427 UTC [35396][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-07-01 07:11:19.434 UTC [35396][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-07-01 07:11:19.481 UTC [35396][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.055 user=postgres database=mydb host=[local] 2024-07-01 07:11:19.608 UTC [35417][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-07-01 07:11:19.609 UTC [35417][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-07-01 07:11:19.609 UTC [35417][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-07-01 07:11:19.612 UTC [35417][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-07-01 07:11:19.652 UTC [35417][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.050 user=postgres database=mydb host=[local] 2024-07-01 07:11:19.776 UTC [35438][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-07-01 07:11:19.777 UTC [35438][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-07-01 07:11:19.777 UTC [35438][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-07-01 07:11:19.784 UTC [35438][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-07-01 07:11:19.801 UTC [35438][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.028 user=postgres database=mydb host=[local] 2024-07-01 07:11:19.928 UTC [35455][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-07-01 07:11:19.929 UTC [35455][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-07-01 07:11:19.929 UTC [35455][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-07-01 07:11:19.931 UTC [35455][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-07-01 07:11:19.943 UTC [35455][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=postgres database=mydb host=[local] 2024-07-01 07:11:20.086 UTC [35470][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-07-01 07:11:20.119 UTC [35470][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-07-01 07:11:20.119 UTC [35470][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-07-01 07:11:20.121 UTC [35470][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-07-01 07:11:20.162 UTC [35470][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.076 user=postgres database=mydb host=[local] 2024-07-01 07:11:20.307 UTC [35488][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-07-01 07:11:20.309 UTC [35488][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-07-01 07:11:20.309 UTC [35488][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-07-01 07:11:20.311 UTC [35488][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-07-01 07:11:20.322 UTC [35488][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=postgres database=mydb host=[local] 2024-07-01 07:11:20.460 UTC [35509][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-07-01 07:11:20.461 UTC [35509][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-07-01 07:11:20.461 UTC [35509][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-07-01 07:11:20.463 UTC [35509][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-07-01 07:11:20.476 UTC [35509][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=postgres database=mydb host=[local] 2024-07-01 07:11:20.635 UTC [35543][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-07-01 07:11:20.637 UTC [35543][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-07-01 07:11:20.637 UTC [35543][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-07-01 07:11:20.641 UTC [35543][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-07-01 07:11:20.672 UTC [35543][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.037 user=postgres database=mydb host=[local] 2024-07-01 07:11:20.813 UTC [35575][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-07-01 07:11:20.814 UTC [35575][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-07-01 07:11:20.814 UTC [35575][client backend] [[unknown]][11/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-07-01 07:11:20.825 UTC [35575][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-07-01 07:11:20.842 UTC [35575][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.029 user=postgres database=mydb host=[local] 2024-07-01 07:11:20.988 UTC [35594][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-07-01 07:11:20.989 UTC [35594][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-07-01 07:11:20.989 UTC [35594][client backend] [[unknown]][12/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-07-01 07:11:20.998 UTC [35594][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-07-01 07:11:21.020 UTC [35594][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.033 user=postgres database=mydb host=[local] 2024-07-01 07:11:21.148 UTC [35619][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-07-01 07:11:21.171 UTC [35619][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-07-01 07:11:21.171 UTC [35619][client backend] [[unknown]][13/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-07-01 07:11:21.173 UTC [35619][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-07-01 07:11:21.183 UTC [35619][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.035 user=postgres database=mydb host=[local] 2024-07-01 07:11:21.298 UTC [35276][postmaster] LOG: background worker "worker_spi" (PID 35307) was terminated by signal 6: Aborted 2024-07-01 07:11:21.298 UTC [35276][postmaster] LOG: terminating any other active server processes 2024-07-01 07:11:21.310 UTC [35276][postmaster] LOG: shutting down because "restart_after_crash" is off 2024-07-01 07:11:21.367 UTC [35276][postmaster] LOG: database system is shut down