# Checking port 63260
# Found port 63260
Name: test
Data directory: C:\cirrus\build/testrun/pg_amcheck/002_nonesuch\data/t_002_nonesuch_test_data/pgdata
Backup directory: C:\cirrus\build/testrun/pg_amcheck/002_nonesuch\data/t_002_nonesuch_test_data/backup
Archive directory: C:\cirrus\build/testrun/pg_amcheck/002_nonesuch\data/t_002_nonesuch_test_data/archives
Connection string: port=63260 host=C:/Windows/TEMP/KX6uc_YbAE
Log file: C:\cirrus\build/testrun/pg_amcheck/002_nonesuch\log/002_nonesuch_test.log
[08:01:29.115](0.073s) # 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/pg_amcheck/002_nonesuch\data/t_002_nonesuch_test_data/pgdata

# Running: C:\cirrus\build\src/test\regress\pg_regress.exe --config-auth C:\cirrus\build/testrun/pg_amcheck/002_nonesuch\data/t_002_nonesuch_test_data/pgdata
### Starting node "test"
# Running: pg_ctl -w -D C:\cirrus\build/testrun/pg_amcheck/002_nonesuch\data/t_002_nonesuch_test_data/pgdata -l C:\cirrus\build/testrun/pg_amcheck/002_nonesuch\log/002_nonesuch_test.log -o --cluster-name=test start
waiting for server to start.... done
server started
# Postmaster PID for node "test" is 6020
# Running: pg_amcheck qqq
[08:01:30.889](1.774s) ok 1 - checking a non-existent database status (got 1 vs expected 1)
[08:01:30.889](0.000s) ok 2 - checking a non-existent database stdout /(?^:^$)/
[08:01:30.889](0.000s) not ok 3 - checking a non-existent database stderr /(?^:FATAL:  database "qqq" does not exist)/
[08:01:30.889](0.000s) #   Failed test 'checking a non-existent database stderr /(?^:FATAL:  database "qqq" does not exist)/'
#   at C:/cirrus/src/bin/pg_amcheck/t/002_nonesuch.pl line 25.
[08:01:30.890](0.000s) #                   'pg_amcheck: error: connection to server on socket "C:/Windows/TEMP/KX6uc_YbAE/.s.PGSQL.63260" failed: server closed the connection unexpectedly
# 	This probably means the server terminated abnormally
# 	before or while processing the request.
# '
#     doesn't match '(?^:FATAL:  database "qqq" does not exist)'
# Running: pg_amcheck -d qqq -d postgres
[08:01:31.047](0.157s) ok 4 - checking an unresolvable database pattern status (got 1 vs expected 1)
[08:01:31.047](0.000s) ok 5 - checking an unresolvable database pattern stdout /(?^:^$)/
[08:01:31.047](0.000s) ok 6 - checking an unresolvable database pattern stderr /(?^:pg_amcheck: error: no connectable databases to check matching "qqq")/
# Running: pg_amcheck --no-strict-names -d qqq -d postgres
[08:01:31.387](0.340s) ok 7 - checking an unresolvable database pattern under --no-strict-names status (got 0 vs expected 0)
[08:01:31.388](0.001s) ok 8 - checking an unresolvable database pattern under --no-strict-names stdout /(?^:^$)/
[08:01:31.388](0.000s) ok 9 - checking an unresolvable database pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no connectable databases to check matching "qqq")/
# Running: pg_amcheck -d post -d postgres
[08:01:31.546](0.158s) ok 10 - checking an unresolvable database pattern (substring of existent database) status (got 1 vs expected 1)
[08:01:31.547](0.001s) ok 11 - checking an unresolvable database pattern (substring of existent database) stdout /(?^:^$)/
[08:01:31.547](0.000s) ok 12 - checking an unresolvable database pattern (substring of existent database) stderr /(?^:pg_amcheck: error: no connectable databases to check matching "post")/
# Running: pg_amcheck -d postgresql -d postgres
[08:01:31.662](0.115s) ok 13 - checking an unresolvable database pattern (superstring of existent database) status (got 1 vs expected 1)
[08:01:31.662](0.001s) ok 14 - checking an unresolvable database pattern (superstring of existent database) stdout /(?^:^$)/
[08:01:31.663](0.000s) ok 15 - checking an unresolvable database pattern (superstring of existent database) stderr /(?^:pg_amcheck: error: no connectable databases to check matching "postgresql")/
# Running: pg_amcheck -U no_such_user postgres
[08:01:31.787](0.124s) ok 16 - checking with a non-existent user status (got 1 vs expected 1)
[08:01:31.788](0.000s) ok 17 - checking with a non-existent user stdout /(?^:^$)/
# Running: pg_amcheck template1
[08:01:31.966](0.178s) ok 18 - checking a database by name without amcheck installed, no other databases status (got 1 vs expected 1)
[08:01:31.966](0.000s) ok 19 - checking a database by name without amcheck installed, no other databases stdout /(?^:^$)/
[08:01:31.966](0.000s) ok 20 - checking a database by name without amcheck installed, no other databases stderr /(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)/
[08:01:31.967](0.000s) ok 21 - checking a database by name without amcheck installed, no other databases stderr /(?^:pg_amcheck: error: no relations to check)/
# Running: pg_amcheck -d template1 -d postgres
[08:01:32.454](0.487s) ok 22 - checking a database by name without amcheck installed, with other databases status (got 0 vs expected 0)
[08:01:32.454](0.000s) ok 23 - checking a database by name without amcheck installed, with other databases stdout /(?^:^$)/
[08:01:32.455](0.000s) ok 24 - checking a database by name without amcheck installed, with other databases stderr /(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)/
# Running: pg_amcheck --all
[08:01:32.908](0.453s) ok 25 - checking a database by pattern without amcheck installed, with other databases status (got 0 vs expected 0)
[08:01:32.908](0.001s) ok 26 - checking a database by pattern without amcheck installed, with other databases stdout /(?^:^$)/
[08:01:32.909](0.000s) ok 27 - checking a database by pattern without amcheck installed, with other databases stderr /(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)/
# Running: pg_amcheck -d postgres -t ..
[08:01:33.032](0.123s) ok 28 - checking table pattern ".." status (got 1 vs expected 1)
[08:01:33.033](0.000s) ok 29 - checking table pattern ".." stdout /(?^:^$)/
[08:01:33.033](0.000s) ok 30 - checking table pattern ".." stderr /(?^:pg_amcheck: error: no connectable databases to check matching "\.\.")/
# Running: pg_amcheck -d postgres -t .foo.bar
[08:01:33.118](0.085s) ok 31 - checking table pattern ".foo.bar" status (got 1 vs expected 1)
[08:01:33.119](0.002s) ok 32 - checking table pattern ".foo.bar" stdout /(?^:^$)/
[08:01:33.120](0.000s) ok 33 - checking table pattern ".foo.bar" stderr /(?^:pg_amcheck: error: no connectable databases to check matching "\.foo\.bar")/
# Running: pg_amcheck -d postgres -t .
[08:01:33.267](0.147s) ok 34 - checking table pattern "." status (got 1 vs expected 1)
[08:01:33.267](0.000s) ok 35 - checking table pattern "." stdout /(?^:^$)/
[08:01:33.268](0.000s) ok 36 - checking table pattern "." stderr /(?^:pg_amcheck: error: no heap tables to check matching "\.")/
# Running: pg_amcheck -d localhost.postgres
[08:01:33.347](0.079s) ok 37 - multipart database patterns are rejected status (got 2 vs expected 2)
[08:01:33.347](0.000s) ok 38 - multipart database patterns are rejected stdout /(?^:^$)/
[08:01:33.347](0.000s) ok 39 - multipart database patterns are rejected stderr /(?^:pg_amcheck: error: improper qualified name \(too many dotted names\): localhost\.postgres)/
# Running: pg_amcheck -s localhost.postgres.pg_catalog
[08:01:33.413](0.066s) ok 40 - three part schema patterns are rejected status (got 2 vs expected 2)
[08:01:33.414](0.000s) ok 41 - three part schema patterns are rejected stdout /(?^:^$)/
[08:01:33.414](0.000s) ok 42 - three part schema patterns are rejected stderr /(?^:pg_amcheck: error: improper qualified name \(too many dotted names\): localhost\.postgres\.pg_catalog)/
# Running: pg_amcheck -t localhost.postgres.pg_catalog.pg_class
[08:01:33.483](0.070s) ok 43 - four part table patterns are rejected status (got 2 vs expected 2)
[08:01:33.484](0.000s) ok 44 - four part table patterns are rejected stdout /(?^:^$)/
[08:01:33.484](0.000s) ok 45 - four part table patterns are rejected stderr /(?^:pg_amcheck: error: improper relation name \(too many dotted names\): localhost\.postgres\.pg_catalog\.pg_class)/
# Running: pg_amcheck --no-strict-names -t this.is.a.really.long.dotted.string
[08:01:33.548](0.064s) ok 46 - ungrammatical table names still draw errors under --no-strict-names status (got 2 vs expected 2)
[08:01:33.548](0.000s) ok 47 - ungrammatical table names still draw errors under --no-strict-names stdout /(?^:^$)/
[08:01:33.548](0.000s) ok 48 - ungrammatical table names still draw errors under --no-strict-names stderr /(?^:pg_amcheck: error: improper relation name \(too many dotted names\): this\.is\.a\.really\.long\.dotted\.string)/
# Running: pg_amcheck --no-strict-names -s postgres.long.dotted.string
[08:01:33.629](0.080s) ok 49 - ungrammatical schema names still draw errors under --no-strict-names status (got 2 vs expected 2)
[08:01:33.629](0.000s) ok 50 - ungrammatical schema names still draw errors under --no-strict-names stdout /(?^:^$)/
[08:01:33.629](0.000s) ok 51 - ungrammatical schema names still draw errors under --no-strict-names stderr /(?^:pg_amcheck: error: improper qualified name \(too many dotted names\): postgres\.long\.dotted\.string)/
# Running: pg_amcheck --no-strict-names -d postgres.long.dotted.string
[08:01:33.712](0.083s) ok 52 - ungrammatical database names still draw errors under --no-strict-names status (got 2 vs expected 2)
[08:01:33.712](0.000s) ok 53 - ungrammatical database names still draw errors under --no-strict-names stdout /(?^:^$)/
[08:01:33.712](0.000s) ok 54 - ungrammatical database names still draw errors under --no-strict-names stderr /(?^:pg_amcheck: error: improper qualified name \(too many dotted names\): postgres\.long\.dotted\.string)/
# Running: pg_amcheck --no-strict-names -T a.b.c.d
[08:01:33.801](0.088s) ok 55 - ungrammatical table exclusions still draw errors under --no-strict-names status (got 2 vs expected 2)
[08:01:33.801](0.000s) ok 56 - ungrammatical table exclusions still draw errors under --no-strict-names stdout /(?^:^$)/
[08:01:33.801](0.000s) ok 57 - ungrammatical table exclusions still draw errors under --no-strict-names stderr /(?^:pg_amcheck: error: improper relation name \(too many dotted names\): a\.b\.c\.d)/
# Running: pg_amcheck --no-strict-names -S a.b.c
[08:01:33.880](0.079s) ok 58 - ungrammatical schema exclusions still draw errors under --no-strict-names status (got 2 vs expected 2)
[08:01:33.880](0.000s) ok 59 - ungrammatical schema exclusions still draw errors under --no-strict-names stdout /(?^:^$)/
[08:01:33.880](0.000s) ok 60 - ungrammatical schema exclusions still draw errors under --no-strict-names stderr /(?^:pg_amcheck: error: improper qualified name \(too many dotted names\): a\.b\.c)/
# Running: pg_amcheck --no-strict-names -D a.b
[08:01:33.953](0.073s) ok 61 - ungrammatical database exclusions still draw errors under --no-strict-names status (got 2 vs expected 2)
[08:01:33.953](0.000s) ok 62 - ungrammatical database exclusions still draw errors under --no-strict-names stdout /(?^:^$)/
[08:01:33.954](0.000s) ok 63 - ungrammatical database exclusions still draw errors under --no-strict-names stderr /(?^:pg_amcheck: error: improper qualified name \(too many dotted names\): a\.b)/
# Running: pg_amcheck --no-strict-names -t no_such_table -t no*such*table -i no_such_index -i no*such*index -r no_such_relation -r no*such*relation -d no_such_database -d no*such*database -r none.none -r none.none.none -r postgres.none.none -r postgres.pg_catalog.none -r postgres.none.pg_class -t postgres.pg_catalog.pg_class
[08:01:34.220](0.266s) ok 64 - many unmatched patterns and one matched pattern under --no-strict-names status (got 0 vs expected 0)
[08:01:34.220](0.000s) ok 65 - many unmatched patterns and one matched pattern under --no-strict-names stdout /(?^:^$)/
[08:01:34.221](0.000s) ok 66 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no heap tables to check matching "no_such_table")/
[08:01:34.221](0.000s) ok 67 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no heap tables to check matching "no\*such\*table")/
[08:01:34.221](0.001s) ok 68 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no btree indexes to check matching "no_such_index")/
[08:01:34.222](0.000s) ok 69 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no btree indexes to check matching "no\*such\*index")/
[08:01:34.222](0.000s) ok 70 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no relations to check matching "no_such_relation")/
[08:01:34.227](0.005s) ok 71 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no relations to check matching "no\*such\*relation")/
[08:01:34.227](0.000s) ok 72 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no heap tables to check matching "no\*such\*table")/
[08:01:34.228](0.000s) ok 73 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no connectable databases to check matching "no_such_database")/
[08:01:34.228](0.000s) ok 74 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no connectable databases to check matching "no\*such\*database")/
[08:01:34.229](0.000s) ok 75 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no relations to check matching "none\.none")/
[08:01:34.229](0.000s) ok 76 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no connectable databases to check matching "none\.none\.none")/
[08:01:34.231](0.002s) ok 77 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no relations to check matching "postgres\.none\.none")/
[08:01:34.232](0.001s) ok 78 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no relations to check matching "postgres\.pg_catalog\.none")/
[08:01:34.232](0.001s) ok 79 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no relations to check matching "postgres\.none\.pg_class")/
[08:01:34.233](0.000s) ok 80 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no connectable databases to check matching "no_such_database")/
[08:01:34.233](0.000s) ok 81 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no connectable databases to check matching "no\*such\*database")/
[08:01:34.233](0.000s) ok 82 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no connectable databases to check matching "none\.none\.none")/
# Running: pg_amcheck -d regression_invalid
[08:01:34.799](0.566s) ok 83 - checking handling of invalid database status (got 1 vs expected 1)
[08:01:34.799](0.000s) ok 84 - checking handling of invalid database stdout /(?^:^$)/
[08:01:34.799](0.000s) ok 85 - checking handling of invalid database stderr /(?^:pg_amcheck: error: no connectable databases to check matching "regression_invalid")/
# Running: pg_amcheck -d postgres -t regression_invalid.public.foo
[08:01:34.921](0.122s) ok 86 - checking handling of object in invalid database status (got 1 vs expected 1)
[08:01:34.922](0.000s) ok 87 - checking handling of object in invalid database stdout /(?^:^$)/
[08:01:34.922](0.000s) ok 88 - checking handling of object in invalid database stderr /(?^:pg_amcheck: error: no connectable databases to check matching "regression_invalid.public.foo")/
# Running: pg_amcheck -d postgres --no-strict-names -t template1.public.foo -t another_db.public.foo -t no_such_database.public.foo -i template1.public.foo_idx -i another_db.public.foo_idx -i no_such_database.public.foo_idx
[08:01:36.309](1.387s) ok 89 - checking otherwise existent objects in the wrong databases status (got 1 vs expected 1)
[08:01:36.310](0.001s) ok 90 - checking otherwise existent objects in the wrong databases stdout /(?^:^$)/
[08:01:36.310](0.000s) ok 91 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)/
[08:01:36.311](0.001s) ok 92 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: warning: no heap tables to check matching "template1\.public\.foo")/
[08:01:36.311](0.000s) ok 93 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: warning: no heap tables to check matching "another_db\.public\.foo")/
[08:01:36.311](0.000s) ok 94 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: warning: no connectable databases to check matching "no_such_database\.public\.foo")/
[08:01:36.312](0.000s) ok 95 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: warning: no btree indexes to check matching "template1\.public\.foo_idx")/
[08:01:36.312](0.000s) ok 96 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: warning: no btree indexes to check matching "another_db\.public\.foo_idx")/
[08:01:36.312](0.000s) ok 97 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: warning: no connectable databases to check matching "no_such_database\.public\.foo_idx")/
[08:01:36.312](0.000s) ok 98 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: error: no relations to check)/
# Running: pg_amcheck --all --no-strict-names -S public -S pg_catalog -S pg_toast -S information_schema
[08:01:36.632](0.320s) ok 99 - schema exclusion patterns exclude all relations status (got 1 vs expected 1)
[08:01:36.633](0.001s) ok 100 - schema exclusion patterns exclude all relations stdout /(?^:^$)/
[08:01:36.633](0.000s) ok 101 - schema exclusion patterns exclude all relations stderr /(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)/
[08:01:36.634](0.000s) ok 102 - schema exclusion patterns exclude all relations stderr /(?^:pg_amcheck: error: no relations to check)/
# Running: pg_amcheck --all --no-strict-names -s public -s pg_catalog -s pg_toast -s information_schema -t pg_catalog.pg_class -S*
[08:01:36.912](0.279s) ok 103 - schema exclusion pattern overrides all inclusion patterns status (got 1 vs expected 1)
[08:01:36.921](0.009s) ok 104 - schema exclusion pattern overrides all inclusion patterns stdout /(?^:^$)/
[08:01:36.921](0.000s) ok 105 - schema exclusion pattern overrides all inclusion patterns stderr /(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)/
[08:01:36.921](0.000s) ok 106 - schema exclusion pattern overrides all inclusion patterns stderr /(?^:pg_amcheck: error: no relations to check)/
[08:01:36.924](0.002s) 1..106
### Stopping node "test" using mode immediate
# Running: pg_ctl -D C:\cirrus\build/testrun/pg_amcheck/002_nonesuch\data/t_002_nonesuch_test_data/pgdata -m immediate stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "test"
[08:01:37.066](0.142s) # Looks like you failed 1 test of 106.