# Checking port 50463
# Found port 50463
Name: mynode
Data directory: /tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/data/t_001_worker_spi_mynode_data/pgdata
Backup directory: /tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/data/t_001_worker_spi_mynode_data/backup
Archive directory: /tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/data/t_001_worker_spi_mynode_data/archives
Connection string: port=50463 host=/tmp/vx_m4YHYiU
Log file: /tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/log/001_worker_spi_mynode.log
[16:23:56.907](0.015s) # initializing database system by copying initdb template
# Running: cp -RPp /tmp/cirrus-ci-build/build/tmp_install/initdb-template /tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/data/t_001_worker_spi_mynode_data/pgdata
# Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/data/t_001_worker_spi_mynode_data/pgdata
### Starting node "mynode"
# Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/data/t_001_worker_spi_mynode_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/log/001_worker_spi_mynode.log -o --cluster-name=mynode start
waiting for server to start.... done
server started
# Postmaster PID for node "mynode" is 28030
[16:23:57.060](0.154s) # testing dynamic bgworkers
[16:23:57.094](0.033s) ok 1 - dynamic bgworker launched
[16:27:29.735](212.641s) # poll_query_until timed out executing this query:
# SELECT count(*) > 0 FROM information_schema.tables
# 	    WHERE table_schema = 'schema4' AND table_name = 'counted';
# expecting this output:
# t
# last actual query output:
# t
# with stderr:
# WARNING:  outfuncs/readfuncs failed to produce an equal rewritten parse tree
#### Begin standard error
psql:<stdin>:1: WARNING:  outfuncs/readfuncs failed to produce an equal rewritten parse tree
#### End standard error
### Reloading node "mynode"
# Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/data/t_001_worker_spi_mynode_data/pgdata reload
server signaled
[16:27:29.767](0.033s) ok 2 - dynamic bgworker correctly consumed tuple data
[16:31:12.822](223.055s) # poll_query_until timed out executing this query:
# SELECT wait_event FROM pg_stat_activity WHERE backend_type ~ 'worker_spi';
# expecting this output:
# WorkerSpiMain
# last actual query output:
# WorkerSpiMain
# with stderr:
# WARNING:  outfuncs/readfuncs failed to produce an equal rewritten parse tree
[16:31:12.823](0.001s) not ok 3 - dynamic bgworker has reported "WorkerSpiMain" as wait event
[16:31:12.823](0.000s) #   Failed test 'dynamic bgworker has reported "WorkerSpiMain" as wait event'
#   at /tmp/cirrus-ci-build/src/test/modules/worker_spi/t/001_worker_spi.pl line 49.
[16:31:12.823](0.000s) #          got: '0'
#     expected: '1'
#### Begin standard error
psql:<stdin>:1: WARNING:  outfuncs/readfuncs failed to produce an equal rewritten parse tree
#### End standard error
[16:31:12.834](0.011s) ok 4 - "WorkerSpiMain" is reported in pg_wait_events
[16:31:12.834](0.000s) # testing bgworkers loaded with shared_preload_libraries
#### Begin standard error
psql:<stdin>:1: WARNING:  databases created by regression test cases should have names including "regression"
#### End standard error
#### Begin standard error
psql:<stdin>:1: WARNING:  roles created by regression test cases should have names starting with "regress_"
#### End standard error
### Restarting node "mynode"
# Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/data/t_001_worker_spi_mynode_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/log/001_worker_spi_mynode.log restart
waiting for server to shut down.... done
server stopped
waiting for server to start.... done
server started
# Postmaster PID for node "mynode" is 47092
[16:34:51.666](218.832s) # poll_query_until timed out executing this query:
# SELECT datname, count(datname), wait_event FROM pg_stat_activity
#             WHERE backend_type = 'worker_spi' GROUP BY datname, wait_event;
# expecting this output:
# mydb|3|WorkerSpiMain
# last actual query output:
# mydb|3|WorkerSpiMain
# with stderr:
# WARNING:  outfuncs/readfuncs failed to produce an equal rewritten parse tree
[16:34:51.667](0.001s) not ok 5 - bgworkers all launched
[16:34:51.667](0.000s) #   Failed test 'bgworkers all launched'
#   at /tmp/cirrus-ci-build/src/test/modules/worker_spi/t/001_worker_spi.pl line 78.
Timed out while waiting for bgworkers to be launched at /tmp/cirrus-ci-build/src/test/modules/worker_spi/t/001_worker_spi.pl line 78.
# Postmaster PID for node "mynode" is 47092
### Stopping node "mynode" using mode immediate
# Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/worker_spi/001_worker_spi/data/t_001_worker_spi_mynode_data/pgdata -m immediate stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "mynode"
[16:34:51.778](0.111s) # Tests were run but no plan was declared and done_testing() was not seen.
[16:34:51.778](0.000s) # Looks like your test exited with 29 just after 5.