2024-06-25 16:23:03.449 UTC [38173][postmaster] LOG: starting PostgreSQL 17beta2 on x86_64-freebsd, compiled by clang-17.0.6, 64-bit 2024-06-25 16:23:03.449 UTC [38173][postmaster] LOG: listening on Unix socket "/tmp/zRyeyzWU5r/.s.PGSQL.55692" 2024-06-25 16:23:03.452 UTC [38181][startup] LOG: database system was shut down at 2024-06-25 16:20:48 UTC 2024-06-25 16:23:03.460 UTC [38173][postmaster] LOG: database system is ready to accept connections 2024-06-25 16:23:03.590 UTC [38237][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-25 16:23:03.590 UTC [38237][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/data/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-25 16:23:03.590 UTC [38237][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-25 16:23:03.595 UTC [38237][client backend] [001_worker_spi.pl][0/2:0] LOG: statement: CREATE EXTENSION worker_spi; 2024-06-25 16:23:03.599 UTC [38237][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=postgres database=postgres host=[local] 2024-06-25 16:23:03.609 UTC [38246][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-25 16:23:03.609 UTC [38246][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/data/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-25 16:23:03.609 UTC [38246][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-25 16:23:03.610 UTC [38246][client backend] [001_worker_spi.pl][1/2:0] LOG: statement: SELECT worker_spi_launch(4) IS NOT NULL; 2024-06-25 16:23:03.611 UTC [38246][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.002 user=postgres database=postgres host=[local] 2024-06-25 16:23:03.613 UTC [38247][worker_spi dynamic] LOG: worker_spi dynamic worker 4 initialized with schema4.counted 2024-06-25 16:23:03.631 UTC [38251][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-25 16:23:03.632 UTC [38251][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/data/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-25 16:23:03.632 UTC [38251][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-25 16:23:03.632 UTC [38251][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-25 16:23:03.640 UTC [38251][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=postgres database=postgres host=[local] 2024-06-25 16:23:03.647 UTC [38256][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-25 16:23:03.647 UTC [38256][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/data/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-25 16:23:03.647 UTC [38256][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-25 16:23:03.648 UTC [38256][client backend] [001_worker_spi.pl][3/2:0] LOG: statement: INSERT INTO schema4.counted VALUES ('total', 0), ('delta', 1); 2024-06-25 16:23:03.649 UTC [38256][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.002 user=postgres database=postgres host=[local] 2024-06-25 16:23:03.651 UTC [38173][postmaster] LOG: received SIGHUP, reloading configuration files 2024-06-25 16:23:03.653 UTC [38247][worker_spi dynamic] LOG: worker_spi dynamic worker 4: count in schema4.counted is now 1 2024-06-25 16:23:03.653 UTC [38247][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-25 16:23:03.660 UTC [38259][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-25 16:23:03.661 UTC [38259][client backend] [[unknown]][4/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/data/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-25 16:23:03.661 UTC [38259][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-25 16:23:03.661 UTC [38259][client backend] [001_worker_spi.pl][4/2:0] LOG: statement: SELECT count(*) FROM schema4.counted WHERE type = 'delta'; 2024-06-25 16:23:03.663 UTC [38259][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.002 user=postgres database=postgres host=[local] 2024-06-25 16:23:03.668 UTC [38261][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-25 16:23:03.668 UTC [38261][client backend] [[unknown]][5/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/data/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-25 16:23:03.668 UTC [38261][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-25 16:23:03.669 UTC [38261][client backend] [001_worker_spi.pl][5/2:0] LOG: statement: SELECT * FROM schema4.counted; 2024-06-25 16:23:03.670 UTC [38261][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.001 user=postgres database=postgres host=[local] 2024-06-25 16:23:03.676 UTC [38265][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-25 16:23:03.676 UTC [38265][client backend] [[unknown]][6/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/data/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-25 16:23:03.676 UTC [38265][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-25 16:23:03.677 UTC [38265][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-25 16:23:03.681 UTC [38265][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.005 user=postgres database=postgres host=[local] 2024-06-25 16:23:03.735 UTC [38280][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-25 16:23:03.735 UTC [38280][client backend] [[unknown]][7/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/data/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-25 16:23:03.735 UTC [38280][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-25 16:23:03.736 UTC [38280][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-25 16:23:03.737 UTC [38280][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.002 user=postgres database=postgres host=[local] 2024-06-25 16:23:03.748 UTC [38285][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-25 16:23:03.748 UTC [38285][client backend] [[unknown]][8/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/data/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-25 16:23:03.748 UTC [38285][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-25 16:23:03.749 UTC [38285][client backend] [001_worker_spi.pl][8/2:0] LOG: statement: CREATE DATABASE mydb; 2024-06-25 16:23:03.749 UTC [38285][client backend] [001_worker_spi.pl][8/2:0] WARNING: databases created by regression test cases should have names including "regression" 2024-06-25 16:23:03.771 UTC [38285][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.023 user=postgres database=postgres host=[local] 2024-06-25 16:23:03.804 UTC [38299][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-25 16:23:03.804 UTC [38299][client backend] [[unknown]][9/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/data/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-25 16:23:03.804 UTC [38299][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_worker_spi.pl 2024-06-25 16:23:03.805 UTC [38299][client backend] [001_worker_spi.pl][9/2:0] LOG: statement: CREATE ROLE myrole SUPERUSER LOGIN; 2024-06-25 16:23:03.805 UTC [38299][client backend] [001_worker_spi.pl][9/2:0] WARNING: roles created by regression test cases should have names starting with "regress_" 2024-06-25 16:23:03.805 UTC [38299][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.001 user=postgres database=postgres host=[local] 2024-06-25 16:23:03.811 UTC [38301][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-25 16:23:03.811 UTC [38301][client backend] [[unknown]][10/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/data/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-25 16:23:03.811 UTC [38301][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-25 16:23:03.816 UTC [38301][client backend] [001_worker_spi.pl][10/2:0] LOG: statement: CREATE EXTENSION worker_spi; 2024-06-25 16:23:03.817 UTC [38301][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.006 user=postgres database=mydb host=[local] 2024-06-25 16:23:03.852 UTC [38173][postmaster] LOG: received fast shutdown request 2024-06-25 16:23:03.852 UTC [38173][postmaster] LOG: aborting any active transactions 2024-06-25 16:23:03.852 UTC [38247][worker_spi dynamic] FATAL: terminating background worker "worker_spi dynamic" due to administrator command 2024-06-25 16:23:03.856 UTC [38173][postmaster] LOG: background worker "logical replication launcher" (PID 38189) exited with exit code 1 2024-06-25 16:23:03.912 UTC [38173][postmaster] LOG: background worker "worker_spi dynamic" (PID 38247) exited with exit code 1 2024-06-25 16:23:03.912 UTC [38179][checkpointer] LOG: shutting down 2024-06-25 16:23:03.913 UTC [38179][checkpointer] LOG: checkpoint starting: shutdown immediate 2024-06-25 16:23:03.923 UTC [38179][checkpointer] LOG: checkpoint complete: wrote 1003 buffers (6.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.010 s, sync=0.001 s, total=0.010 s; sync files=0, longest=0.000 s, average=0.000 s; distance=7719 kB, estimate=7719 kB; lsn=0/1C9A308, redo lsn=0/1C9A308 2024-06-25 16:23:03.925 UTC [38173][postmaster] LOG: database system is shut down 2024-06-25 16:23:04.002 UTC [38359][postmaster] LOG: starting PostgreSQL 17beta2 on x86_64-freebsd, compiled by clang-17.0.6, 64-bit 2024-06-25 16:23:04.002 UTC [38359][postmaster] LOG: listening on Unix socket "/tmp/zRyeyzWU5r/.s.PGSQL.55692" 2024-06-25 16:23:04.004 UTC [38366][startup] LOG: database system was shut down at 2024-06-25 16:23:03 UTC 2024-06-25 16:23:04.017 UTC [38359][postmaster] LOG: database system is ready to accept connections TRAP: failed Assert("OidIsValid(dboid)"), File: "../src/test/modules/worker_spi/worker_spi.c", Line: 170, PID: 38385 TRAP: failed Assert("OidIsValid(dboid)"), File: "../src/test/modules/worker_spi/worker_spi.c", Line: 170, PID: 38381 0xa52a52 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x837b265b9 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/lib/worker_spi.so 0x84f5cd at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x851cf2 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x854575 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x855917 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x853ed5 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0xa52a52 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x837b265b9 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/lib/worker_spi.so 0x84f5cd at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x851cf2 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x854575 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x855917 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x853ed5 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres TRAP: failed Assert("OidIsValid(dboid)"), File: "../src/test/modules/worker_spi/worker_spi.c", Line: 170, PID: 38383 0xa52a52 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x837b265b9 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/lib/worker_spi.so 0x84f5cd at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x851cf2 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x854575 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x855917 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 0x853ed5 at /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres 2024-06-25 16:23:04.105 UTC [38427][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-25 16:23:04.106 UTC [38427][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/data/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-25 16:23:04.106 UTC [38427][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-25 16:23:04.113 UTC [38427][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-25 16:23:04.121 UTC [38427][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=postgres database=mydb host=[local] 2024-06-25 16:23:04.244 UTC [38478][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-25 16:23:04.244 UTC [38478][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/data/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-25 16:23:04.244 UTC [38478][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-25 16:23:04.246 UTC [38478][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-25 16:23:04.253 UTC [38478][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=postgres database=mydb host=[local] 2024-06-25 16:23:04.367 UTC [38504][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-25 16:23:04.368 UTC [38504][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/data/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-25 16:23:04.368 UTC [38504][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-25 16:23:04.368 UTC [38504][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-25 16:23:04.374 UTC [38504][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.006 user=postgres database=mydb host=[local] 2024-06-25 16:23:04.494 UTC [38530][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-25 16:23:04.494 UTC [38530][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/data/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-25 16:23:04.494 UTC [38530][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-25 16:23:04.495 UTC [38530][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-25 16:23:04.500 UTC [38530][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.006 user=postgres database=mydb host=[local] 2024-06-25 16:23:04.617 UTC [38594][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-25 16:23:04.618 UTC [38594][client backend] [[unknown]][4/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/data/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-25 16:23:04.618 UTC [38594][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-25 16:23:04.619 UTC [38594][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-25 16:23:04.624 UTC [38594][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.007 user=postgres database=mydb host=[local] 2024-06-25 16:23:04.733 UTC [38644][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-06-25 16:23:04.733 UTC [38644][client backend] [[unknown]][5/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/data/t_001_worker_spi_mynode_data/pgdata/pg_hba.conf:117) 2024-06-25 16:23:04.733 UTC [38644][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=postgres database=mydb application_name=001_worker_spi.pl 2024-06-25 16:23:04.734 UTC [38644][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-25 16:23:04.740 UTC [38644][client backend] [001_worker_spi.pl][:0] LOG: disconnection: session time: 0:00:00.007 user=postgres database=mydb host=[local] 2024-06-25 16:23:04.775 UTC [38359][postmaster] LOG: background worker "worker_spi" (PID 38383) was terminated by signal 6: Abort trap 2024-06-25 16:23:04.775 UTC [38359][postmaster] LOG: terminating any other active server processes 2024-06-25 16:23:04.840 UTC [38359][postmaster] LOG: shutting down because "restart_after_crash" is off 2024-06-25 16:23:04.840 UTC [38359][postmaster] LOG: database system is shut down