# Checking port 58640 # Found port 58640 Name: node Data directory: C:\cirrus\build/testrun/recovery/037_invalid_database\data/t_037_invalid_database_node_data/pgdata Backup directory: C:\cirrus\build/testrun/recovery/037_invalid_database\data/t_037_invalid_database_node_data/backup Archive directory: C:\cirrus\build/testrun/recovery/037_invalid_database\data/t_037_invalid_database_node_data/archives Connection string: port=58640 host=C:/Windows/TEMP/KrkktQvqLX Log file: C:\cirrus\build/testrun/recovery/037_invalid_database\log/037_invalid_database_node.log [01:13:26.789](0.101s) # initializing database system by copying initdb template # Running: robocopy /E /NJS /NJH /NFL /NDL /NP C:/cirrus/build/tmp_install/initdb-template C:\cirrus\build/testrun/recovery/037_invalid_database\data/t_037_invalid_database_node_data/pgdata # Running: C:\cirrus\build\src/test\regress\pg_regress.exe --config-auth C:\cirrus\build/testrun/recovery/037_invalid_database\data/t_037_invalid_database_node_data/pgdata ### Starting node "node" # Running: pg_ctl -w -D C:\cirrus\build/testrun/recovery/037_invalid_database\data/t_037_invalid_database_node_data/pgdata -l C:\cirrus\build/testrun/recovery/037_invalid_database\log/037_invalid_database_node.log -o --cluster-name=node start waiting for server to start.... done server started # Postmaster PID for node "node" is 2452 [01:13:32.144](5.354s) ok 1 - can't connect to invalid database - error code [01:13:32.144](0.000s) not ok 2 - can't connect to invalid database - error message [01:13:32.144](0.000s) # Failed test 'can't connect to invalid database - error message' # at C:/cirrus/src/test/recovery/t/037_invalid_database.pl line 40. [01:13:32.145](0.000s) # 'psql: error: connection to server on socket "C:/Windows/TEMP/KrkktQvqLX/.s.PGSQL.58640" failed: server closed the connection unexpectedly # This probably means the server terminated abnormally # before or while processing the request.' # doesn't match '(?^:FATAL:\s+cannot connect to invalid database "regression_invalid")' psql::1: FATAL: cannot alter invalid database "regression_invalid" HINT: Use DROP DATABASE to drop invalid databases. psql::1: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. psql::1: error: connection to server was lost [01:13:32.766](0.621s) ok 3 - can't ALTER invalid database psql::1: ERROR: cannot use invalid database "regression_invalid" as template HINT: Use DROP DATABASE to drop invalid databases. [01:13:33.382](0.616s) ok 4 - can't use invalid database as template [01:13:34.461](1.080s) ok 5 - invalid databases are ignored by vac_truncate_clog [01:13:35.180](0.719s) ok 6 - can DROP invalid database psql::1: ERROR: database "regression_invalid" does not exist [01:13:35.376](0.196s) ok 7 - can't drop already dropped database [01:13:35.576](0.200s) # issuing query via background psql: SELECT pg_backend_pid() [01:13:35.578](0.002s) # issuing query via background psql: # CREATE DATABASE regression_invalid_interrupt; # BEGIN; # LOCK pg_tablespace; # PREPARE TRANSACTION 'lock_tblspc'; [01:13:36.040](0.461s) ok 8 - blocked DROP DATABASE completion [01:13:37.071](1.031s) ok 9 - canceling DROP DATABASE [01:13:37.071](0.000s) ok 10 - cancel processed psql: error: connection to server on socket "C:/Windows/TEMP/KrkktQvqLX/.s.PGSQL.58640" failed: FATAL: cannot connect to invalid database "regression_invalid_interrupt" HINT: Use DROP DATABASE to drop invalid databases. [01:13:37.460](0.389s) ok 11 - can't connect to invalid_interrupt database [01:13:37.460](0.000s) # issuing query via background psql: ROLLBACK PREPARED 'lock_tblspc' [01:13:37.464](0.004s) ok 12 - unblock DROP DATABASE [01:13:37.465](0.000s) # issuing query via background psql: DROP DATABASE regression_invalid_interrupt [01:13:37.548](0.084s) ok 13 - DROP DATABASE invalid_interrupt [01:13:37.680](0.132s) 1..13 ### Stopping node "node" using mode immediate # Running: pg_ctl -D C:\cirrus\build/testrun/recovery/037_invalid_database\data/t_037_invalid_database_node_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "node" [01:13:37.844](0.164s) # Looks like you failed 1 test of 13.