# Checking port 59453 # Found port 59453 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=59453 host=/tmp/6G8vY10nKA Log file: /tmp/cirrus-ci-build/build/testrun/scripts/102_vacuumdb_stages/log/102_vacuumdb_stages_main.log [12:38:30.167](0.011s) # 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/6G8vY10nKA/.s.PGSQL.59453" failed: FATAL: database "postgres" does not exist [12:38:30.319](0.152s) not ok 1 - vacuumdb --analyze-in-stages postgres exit code 0 [12:38:30.319](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. [12:38:30.320](0.000s) not ok 2 - analyze three times: SQL found in server log [12:38:30.320](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. [12:38:30.320](0.000s) # '2024-03-19 12:38:30.313 UTC [29874][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-19 12:38:30.314 UTC [29874][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-19 12:38:30.314 UTC [29874][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=postgres application_name=102_vacuumdb_stages.pl # 2024-03-19 12:38:30.314 UTC [29874][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); [12:38:30.634](0.314s) not ok 3 - vacuumdb --analyze-in-stages --all exit code 0 [12:38:30.634](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. [12:38:30.635](0.000s) not ok 4 - analyze more than one database in stages: SQL found in server log [12:38:30.635](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. [12:38:30.635](0.000s) # '2024-03-19 12:38:30.325 UTC [29879][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-19 12:38:30.325 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-19 12:38:30.325 UTC [29879][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=postgres application_name=102_vacuumdb_stages.pl # 2024-03-19 12:38:30.325 UTC [29879][client backend] [[unknown]][1/1:0] FATAL: database "postgres" does not exist # 2024-03-19 12:38:30.326 UTC [29880][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-19 12:38:30.326 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-19 12:38:30.326 UTC [29880][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=postgres database=template1 application_name=102_vacuumdb_stages.pl # 2024-03-19 12:38:30.441 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 57, which is not a valid value for type '_Bool' # ==29880==Using libbacktrace symbolizer. # #0 0x55aa06f842e0 in standard_planner ../src/backend/optimizer/plan/planner.c:569 # #1 0x55aa06f8436c in planner ../src/backend/optimizer/plan/planner.c:276 # #2 0x55aa071f3331 in pg_plan_query ../src/backend/tcop/postgres.c:904 # #3 0x55aa071f369e in pg_plan_queries ../src/backend/tcop/postgres.c:996 # #4 0x55aa071f3a78 in exec_simple_query ../src/backend/tcop/postgres.c:1193 # #5 0x55aa071f6978 in PostgresMain ../src/backend/tcop/postgres.c:4680 # #6 0x55aa071ed12f in BackendMain ../src/backend/tcop/backend_startup.c:101 # #7 0x55aa07097a31 in postmaster_child_launch ../src/backend/postmaster/launch_backend.c:267 # #8 0x55aa0709dbb1 in BackendStartup ../src/backend/postmaster/postmaster.c:3593 # #9 0x55aa0709e15f in ServerLoop ../src/backend/postmaster/postmaster.c:1674 # #10 0x55aa0709fb81 in PostmasterMain ../src/backend/postmaster/postmaster.c:1372 # #11 0x55aa06eca488 in main ../src/backend/main/main.c:197 # #12 0x7fb4ddbc6d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09) # #13 0x55aa06a38219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b8219) # # ' # 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)' [12:38:30.635](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" [12:38:32.441](1.805s) # Looks like you failed 4 tests of 4.