# Checking port 59808
# Found port 59808
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=59808 host=C:/Windows/TEMP/ieqArXjr8I
Log file: C:\cirrus\build/testrun/recovery/037_invalid_database\log/037_invalid_database_node.log
[06:25:11.813](0.079s) # 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 752
[06:25:17.431](5.618s) ok 1 - can't connect to invalid database - error code
[06:25:17.431](0.001s) not ok 2 - can't connect to invalid database - error message
[06:25:17.432](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.
[06:25:17.432](0.000s) #                   'psql: error: connection to server on socket "C:/Windows/TEMP/ieqArXjr8I/.s.PGSQL.59808" 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:<stdin>:1: FATAL:  cannot alter invalid database "regression_invalid"
HINT:  Use DROP DATABASE to drop invalid databases.
psql:<stdin>:1: server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
psql:<stdin>:1: error: connection to server was lost
[06:25:17.996](0.564s) ok 3 - can't ALTER invalid database
psql:<stdin>:1: ERROR:  cannot use invalid database "regression_invalid" as template
HINT:  Use DROP DATABASE to drop invalid databases.
[06:25:18.207](0.210s) ok 4 - can't use invalid database as template
[06:25:18.716](0.509s) ok 5 - invalid databases are ignored by vac_truncate_clog
[06:25:19.018](0.302s) ok 6 - can DROP invalid database
psql:<stdin>:1: ERROR:  database "regression_invalid" does not exist
[06:25:19.388](0.371s) ok 7 - can't drop already dropped database
[06:25:19.787](0.399s) # issuing query via background psql: SELECT pg_backend_pid()
[06:25:19.789](0.002s) # issuing query via background psql: 
#   CREATE DATABASE regression_invalid_interrupt;
#   BEGIN;
#   LOCK pg_tablespace;
#   PREPARE TRANSACTION 'lock_tblspc';
[06:25:20.951](1.162s) ok 8 - blocked DROP DATABASE completion
[06:25:21.288](0.337s) ok 9 - canceling DROP DATABASE
[06:25:21.293](0.005s) ok 10 - cancel processed
psql: error: connection to server on socket "C:/Windows/TEMP/ieqArXjr8I/.s.PGSQL.59808" failed: FATAL:  cannot connect to invalid database "regression_invalid_interrupt"
HINT:  Use DROP DATABASE to drop invalid databases.
[06:25:21.468](0.176s) ok 11 - can't connect to invalid_interrupt database
[06:25:21.470](0.002s) # issuing query via background psql: ROLLBACK PREPARED 'lock_tblspc'
[06:25:21.473](0.003s) ok 12 - unblock DROP DATABASE
[06:25:21.474](0.000s) # issuing query via background psql: DROP DATABASE regression_invalid_interrupt
[06:25:21.526](0.052s) ok 13 - DROP DATABASE invalid_interrupt
[06:25:21.646](0.120s) 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"
[06:25:21.814](0.169s) # Looks like you failed 1 test of 13.