# Checking port 61602
# Found port 61602
Name: main
Data directory: /tmp/cirrus-ci-build/build/testrun/scripts/102_vacuumdb_stages/data/t_102_vacuumdb_stages_main_data/pgdata
Backup directory: /tmp/cirrus-ci-build/build/testrun/scripts/102_vacuumdb_stages/data/t_102_vacuumdb_stages_main_data/backup
Archive directory: /tmp/cirrus-ci-build/build/testrun/scripts/102_vacuumdb_stages/data/t_102_vacuumdb_stages_main_data/archives
Connection string: port=61602 host=/tmp/uTPpsOq_nA
Log file: /tmp/cirrus-ci-build/build/testrun/scripts/102_vacuumdb_stages/log/102_vacuumdb_stages_main.log
[05:45:38.674](0.013s) # 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/scripts/102_vacuumdb_stages/data/t_102_vacuumdb_stages_main_data/pgdata
# Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/scripts/102_vacuumdb_stages/data/t_102_vacuumdb_stages_main_data/pgdata
### Starting node "main"
# Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/scripts/102_vacuumdb_stages/data/t_102_vacuumdb_stages_main_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/scripts/102_vacuumdb_stages/log/102_vacuumdb_stages_main.log -o --cluster-name=main start
pg_ctl: another server might be running; trying to start server anyway
waiting for server to start.... done
server started
# Postmaster PID for node "main" is 29858
# Running: vacuumdb --analyze-in-stages postgres
vacuumdb: error: connection to server on socket "/tmp/uTPpsOq_nA/.s.PGSQL.61602" failed: FATAL:  database "postgres" does not exist
[05:45:38.830](0.156s) not ok 1 - vacuumdb --analyze-in-stages postgres exit code 0
[05:45:38.830](0.000s) #   Failed test 'vacuumdb --analyze-in-stages postgres exit code 0'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/102_vacuumdb_stages.pl line 14.
[05:45:38.831](0.000s) not ok 2 - analyze three times: SQL found in server log
[05:45:38.831](0.000s) #   Failed test 'analyze three times: SQL found in server log'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/102_vacuumdb_stages.pl line 14.
[05:45:38.831](0.000s) #                   '2024-03-09 05:45:38.824 UTC [29877][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:38.825 UTC [29877][client backend] [[unknown]][0/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/scripts/102_vacuumdb_stages/data/t_102_vacuumdb_stages_main_data/pgdata/pg_hba.conf:117)
# 2024-03-09 05:45:38.825 UTC [29877][client backend] [[unknown]][0/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=102_vacuumdb_stages.pl
# 2024-03-09 05:45:38.825 UTC [29877][client backend] [[unknown]][0/1:0] FATAL:  database "postgres" does not exist
# '
#     doesn't match '(?^sx:statement:\ SET\ default_statistics_target=1;\ SET\ vacuum_cost_delay=0;
#                    .*statement:\ ANALYZE
#                    .*statement:\ SET\ default_statistics_target=10;\ RESET\ vacuum_cost_delay;
#                    .*statement:\ ANALYZE
#                    .*statement:\ RESET\ default_statistics_target;
#                    .*statement:\ ANALYZE)'
# Running: vacuumdb --analyze-in-stages --all
vacuumdb: error: query failed: server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
vacuumdb: detail: Query was: SELECT pg_catalog.set_config('search_path', '', false);
[05:45:39.145](0.315s) not ok 3 - vacuumdb --analyze-in-stages --all exit code 0
[05:45:39.146](0.000s) #   Failed test 'vacuumdb --analyze-in-stages --all exit code 0'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/102_vacuumdb_stages.pl line 24.
[05:45:39.146](0.000s) not ok 4 - analyze more than one database in stages: SQL found in server log
[05:45:39.146](0.000s) #   Failed test 'analyze more than one database in stages: SQL found in server log'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/102_vacuumdb_stages.pl line 24.
[05:45:39.146](0.000s) #                   '2024-03-09 05:45:38.837 UTC [29879][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:38.838 UTC [29879][client backend] [[unknown]][1/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/scripts/102_vacuumdb_stages/data/t_102_vacuumdb_stages_main_data/pgdata/pg_hba.conf:117)
# 2024-03-09 05:45:38.838 UTC [29879][client backend] [[unknown]][1/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=102_vacuumdb_stages.pl
# 2024-03-09 05:45:38.838 UTC [29879][client backend] [[unknown]][1/1:0] FATAL:  database "postgres" does not exist
# 2024-03-09 05:45:38.839 UTC [29880][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:38.839 UTC [29880][client backend] [[unknown]][2/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/scripts/102_vacuumdb_stages/data/t_102_vacuumdb_stages_main_data/pgdata/pg_hba.conf:117)
# 2024-03-09 05:45:38.839 UTC [29880][client backend] [[unknown]][2/1:0] LOG:  connection authorized: user=postgres database=template1 application_name=102_vacuumdb_stages.pl
# 2024-03-09 05:45:38.840 UTC [29880][client backend] [102_vacuumdb_stages.pl][2/2:0] LOG:  statement: SELECT pg_catalog.set_config('search_path', '', false);
# ../src/backend/optimizer/plan/planner.c:569:28: runtime error: load of value 83, which is not a valid value for type '_Bool'
# ==29880==Using libbacktrace symbolizer.
#     #0 0x563d3aca272f in standard_planner ../src/backend/optimizer/plan/planner.c:569
#     #1 0x563d3aca27bb in planner ../src/backend/optimizer/plan/planner.c:276
#     #2 0x563d3af10cd3 in pg_plan_query ../src/backend/tcop/postgres.c:903
#     #3 0x563d3af11040 in pg_plan_queries ../src/backend/tcop/postgres.c:995
#     #4 0x563d3af1141a in exec_simple_query ../src/backend/tcop/postgres.c:1192
#     #5 0x563d3af1431a in PostgresMain ../src/backend/tcop/postgres.c:4675
#     #6 0x563d3adb7754 in BackendRun ../src/backend/postmaster/postmaster.c:4475
#     #7 0x563d3adbd03c in BackendStartup ../src/backend/postmaster/postmaster.c:4151
#     #8 0x563d3adbd3b9 in ServerLoop ../src/backend/postmaster/postmaster.c:1769
#     #9 0x563d3adbee4b in PostmasterMain ../src/backend/postmaster/postmaster.c:1468
#     #10 0x563d3abe8a3b in main ../src/backend/main/main.c:197
#     #11 0x7f0683abdd09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09)
#     #12 0x563d3a758219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b5219)
# 
# '
#     doesn't match '(?^sx:statement:\ SET\ default_statistics_target=1;\ SET\ vacuum_cost_delay=0;
#                    .*statement:\ ANALYZE
#                    .*statement:\ SET\ default_statistics_target=1;\ SET\ vacuum_cost_delay=0;
#                    .*statement:\ ANALYZE
#                    .*statement:\ SET\ default_statistics_target=10;\ RESET\ vacuum_cost_delay;
#                    .*statement:\ ANALYZE
#                    .*statement:\ SET\ default_statistics_target=10;\ RESET\ vacuum_cost_delay;
#                    .*statement:\ ANALYZE
#                    .*statement:\ RESET\ default_statistics_target;
#                    .*statement:\ ANALYZE
#                    .*statement:\ RESET\ default_statistics_target;
#                    .*statement:\ ANALYZE)'
[05:45:39.147](0.000s) 1..4
### Stopping node "main" using mode immediate
# Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/scripts/102_vacuumdb_stages/data/t_102_vacuumdb_stages_main_data/pgdata -m immediate stop
waiting for server to shut down...... done
server stopped
# No postmaster PID for node "main"
[05:45:41.253](2.107s) # Looks like you failed 4 tests of 4.