# Checking port 53770 # Found port 53770 Name: test Data directory: /Users/admin/pgsql/build/testrun/pg_amcheck/002_nonesuch/data/t_002_nonesuch_test_data/pgdata Backup directory: /Users/admin/pgsql/build/testrun/pg_amcheck/002_nonesuch/data/t_002_nonesuch_test_data/backup Archive directory: /Users/admin/pgsql/build/testrun/pg_amcheck/002_nonesuch/data/t_002_nonesuch_test_data/archives Connection string: port=53770 host=/var/folders/xc/tpssff9959345bnqq4c6tlww0000gn/T/OKavHYDDWv Log file: /Users/admin/pgsql/build/testrun/pg_amcheck/002_nonesuch/log/002_nonesuch_test.log [22:37:18.330](0.013s) # initializing database system by copying initdb template # Running: cp -RPp /Users/admin/pgsql/build/tmp_install/initdb-template /Users/admin/pgsql/build/testrun/pg_amcheck/002_nonesuch/data/t_002_nonesuch_test_data/pgdata # Running: /Users/admin/pgsql/build/src/test/regress/pg_regress --config-auth /Users/admin/pgsql/build/testrun/pg_amcheck/002_nonesuch/data/t_002_nonesuch_test_data/pgdata ### Starting node "test" # Running: pg_ctl -w -D /Users/admin/pgsql/build/testrun/pg_amcheck/002_nonesuch/data/t_002_nonesuch_test_data/pgdata -l /Users/admin/pgsql/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 20816 # Running: pg_amcheck qqq [22:37:18.783](0.452s) ok 1 - checking a non-existent database status (got 1 vs expected 1) [22:37:18.783](0.000s) ok 2 - checking a non-existent database stdout /(?^:^$)/ [22:37:18.783](0.000s) ok 3 - checking a non-existent database stderr /(?^:FATAL: database "qqq" does not exist)/ # Running: pg_amcheck -d qqq -d postgres [22:37:18.801](0.018s) ok 4 - checking an unresolvable database pattern status (got 1 vs expected 1) [22:37:18.802](0.000s) ok 5 - checking an unresolvable database pattern stdout /(?^:^$)/ [22:37:18.802](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 [22:37:18.953](0.152s) ok 7 - checking an unresolvable database pattern under --no-strict-names status (got 0 vs expected 0) [22:37:18.954](0.000s) ok 8 - checking an unresolvable database pattern under --no-strict-names stdout /(?^:^$)/ [22:37:18.954](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 [22:37:18.970](0.016s) ok 10 - checking an unresolvable database pattern (substring of existent database) status (got 1 vs expected 1) [22:37:18.970](0.000s) ok 11 - checking an unresolvable database pattern (substring of existent database) stdout /(?^:^$)/ [22:37:18.970](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 [22:37:18.985](0.015s) ok 13 - checking an unresolvable database pattern (superstring of existent database) status (got 1 vs expected 1) [22:37:18.985](0.000s) ok 14 - checking an unresolvable database pattern (superstring of existent database) stdout /(?^:^$)/ [22:37:18.985](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 [22:37:18.998](0.013s) ok 16 - checking with a non-existent user status (got 1 vs expected 1) [22:37:18.998](0.000s) ok 17 - checking with a non-existent user stdout /(?^:^$)/ # Running: pg_amcheck template1 [22:37:19.018](0.019s) ok 18 - checking a database by name without amcheck installed, no other databases status (got 1 vs expected 1) [22:37:19.018](0.000s) ok 19 - checking a database by name without amcheck installed, no other databases stdout /(?^:^$)/ [22:37:19.018](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)/ [22:37:19.018](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 [22:37:19.126](0.108s) ok 22 - checking a database by name without amcheck installed, with other databases status (got 0 vs expected 0) [22:37:19.126](0.000s) ok 23 - checking a database by name without amcheck installed, with other databases stdout /(?^:^$)/ [22:37:19.126](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 [22:37:19.275](0.149s) ok 25 - checking a database by pattern without amcheck installed, with other databases status (got 0 vs expected 0) [22:37:19.275](0.000s) ok 26 - checking a database by pattern without amcheck installed, with other databases stdout /(?^:^$)/ [22:37:19.276](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 .. [22:37:19.289](0.014s) ok 28 - checking table pattern ".." status (got 1 vs expected 1) [22:37:19.290](0.000s) ok 29 - checking table pattern ".." stdout /(?^:^$)/ [22:37:19.290](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 [22:37:19.303](0.013s) ok 31 - checking table pattern ".foo.bar" status (got 1 vs expected 1) [22:37:19.303](0.000s) ok 32 - checking table pattern ".foo.bar" stdout /(?^:^$)/ [22:37:19.303](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 . [22:37:19.317](0.014s) ok 34 - checking table pattern "." status (got 1 vs expected 1) [22:37:19.318](0.000s) ok 35 - checking table pattern "." stdout /(?^:^$)/ [22:37:19.318](0.000s) ok 36 - checking table pattern "." stderr /(?^:pg_amcheck: error: no heap tables to check matching "\.")/ # Running: pg_amcheck -d localhost.postgres [22:37:19.326](0.009s) ok 37 - multipart database patterns are rejected status (got 2 vs expected 2) [22:37:19.327](0.000s) ok 38 - multipart database patterns are rejected stdout /(?^:^$)/ [22:37:19.327](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 [22:37:19.339](0.012s) ok 40 - three part schema patterns are rejected status (got 2 vs expected 2) [22:37:19.339](0.000s) ok 41 - three part schema patterns are rejected stdout /(?^:^$)/ [22:37:19.339](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 [22:37:19.351](0.012s) ok 43 - four part table patterns are rejected status (got 2 vs expected 2) [22:37:19.351](0.000s) ok 44 - four part table patterns are rejected stdout /(?^:^$)/ [22:37:19.351](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 [22:37:19.360](0.009s) ok 46 - ungrammatical table names still draw errors under --no-strict-names status (got 2 vs expected 2) [22:37:19.361](0.000s) ok 47 - ungrammatical table names still draw errors under --no-strict-names stdout /(?^:^$)/ [22:37:19.361](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 [22:37:19.376](0.015s) ok 49 - ungrammatical schema names still draw errors under --no-strict-names status (got 2 vs expected 2) [22:37:19.376](0.000s) ok 50 - ungrammatical schema names still draw errors under --no-strict-names stdout /(?^:^$)/ [22:37:19.377](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 [22:37:19.388](0.011s) ok 52 - ungrammatical database names still draw errors under --no-strict-names status (got 2 vs expected 2) [22:37:19.388](0.000s) ok 53 - ungrammatical database names still draw errors under --no-strict-names stdout /(?^:^$)/ [22:37:19.388](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 [22:37:19.398](0.010s) ok 55 - ungrammatical table exclusions still draw errors under --no-strict-names status (got 2 vs expected 2) [22:37:19.399](0.000s) ok 56 - ungrammatical table exclusions still draw errors under --no-strict-names stdout /(?^:^$)/ [22:37:19.399](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 [22:37:19.409](0.011s) ok 58 - ungrammatical schema exclusions still draw errors under --no-strict-names status (got 2 vs expected 2) [22:37:19.410](0.000s) ok 59 - ungrammatical schema exclusions still draw errors under --no-strict-names stdout /(?^:^$)/ [22:37:19.410](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 [22:37:19.422](0.013s) ok 61 - ungrammatical database exclusions still draw errors under --no-strict-names status (got 2 vs expected 2) [22:37:19.423](0.000s) ok 62 - ungrammatical database exclusions still draw errors under --no-strict-names stdout /(?^:^$)/ [22:37:19.423](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 [22:37:19.452](0.029s) ok 64 - many unmatched patterns and one matched pattern under --no-strict-names status (got 0 vs expected 0) [22:37:19.452](0.000s) ok 65 - many unmatched patterns and one matched pattern under --no-strict-names stdout /(?^:^$)/ [22:37:19.452](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")/ [22:37:19.452](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")/ [22:37:19.452](0.000s) 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")/ [22:37:19.452](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")/ [22:37:19.452](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")/ [22:37:19.452](0.000s) 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")/ [22:37:19.452](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")/ [22:37:19.453](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")/ [22:37:19.453](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")/ [22:37:19.453](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")/ [22:37:19.453](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")/ [22:37:19.453](0.000s) 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")/ [22:37:19.453](0.000s) 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")/ [22:37:19.453](0.000s) 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")/ [22:37:19.453](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")/ [22:37:19.453](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")/ [22:37:19.453](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 [22:37:19.560](0.107s) ok 83 - checking handling of invalid database status (got 1 vs expected 1) [22:37:19.560](0.000s) ok 84 - checking handling of invalid database stdout /(?^:^$)/ [22:37:19.560](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 [22:37:19.575](0.015s) ok 86 - checking handling of object in invalid database status (got 1 vs expected 1) [22:37:19.575](0.000s) ok 87 - checking handling of object in invalid database stdout /(?^:^$)/ [22:37:19.575](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 [22:37:19.718](0.143s) ok 89 - checking otherwise existent objects in the wrong databases status (got 1 vs expected 1) [22:37:19.718](0.000s) ok 90 - checking otherwise existent objects in the wrong databases stdout /(?^:^$)/ [22:37:19.718](0.000s) not ok 91 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)/ [22:37:19.719](0.000s) # Failed test 'checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)/' # at /Users/admin/pgsql/src/bin/pg_amcheck/t/002_nonesuch.pl line 338. [22:37:19.719](0.000s) # 'pg_amcheck: warning: no connectable databases to check matching "no_such_database.public.foo" # pg_amcheck: warning: no connectable databases to check matching "no_such_database.public.foo_idx" # pg_amcheck: warning: skipping database "another_db": amcheck is not installed # ' # doesn't match '(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)' [22:37:19.719](0.000s) not ok 92 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: warning: no heap tables to check matching "template1\.public\.foo")/ [22:37:19.719](0.000s) # Failed test 'checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: warning: no heap tables to check matching "template1\.public\.foo")/' # at /Users/admin/pgsql/src/bin/pg_amcheck/t/002_nonesuch.pl line 338. [22:37:19.719](0.000s) # 'pg_amcheck: warning: no connectable databases to check matching "no_such_database.public.foo" # pg_amcheck: warning: no connectable databases to check matching "no_such_database.public.foo_idx" # pg_amcheck: warning: skipping database "another_db": amcheck is not installed # ' # doesn't match '(?^:pg_amcheck: warning: no heap tables to check matching "template1\.public\.foo")' [22:37:19.719](0.000s) not ok 93 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: warning: no heap tables to check matching "another_db\.public\.foo")/ [22:37:19.719](0.000s) # Failed test 'checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: warning: no heap tables to check matching "another_db\.public\.foo")/' # at /Users/admin/pgsql/src/bin/pg_amcheck/t/002_nonesuch.pl line 338. [22:37:19.719](0.000s) # 'pg_amcheck: warning: no connectable databases to check matching "no_such_database.public.foo" # pg_amcheck: warning: no connectable databases to check matching "no_such_database.public.foo_idx" # pg_amcheck: warning: skipping database "another_db": amcheck is not installed # ' # doesn't match '(?^:pg_amcheck: warning: no heap tables to check matching "another_db\.public\.foo")' [22:37:19.719](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")/ [22:37:19.719](0.000s) not ok 95 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: warning: no btree indexes to check matching "template1\.public\.foo_idx")/ [22:37:19.719](0.000s) # Failed test 'checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: warning: no btree indexes to check matching "template1\.public\.foo_idx")/' # at /Users/admin/pgsql/src/bin/pg_amcheck/t/002_nonesuch.pl line 338. [22:37:19.720](0.000s) # 'pg_amcheck: warning: no connectable databases to check matching "no_such_database.public.foo" # pg_amcheck: warning: no connectable databases to check matching "no_such_database.public.foo_idx" # pg_amcheck: warning: skipping database "another_db": amcheck is not installed # ' # doesn't match '(?^:pg_amcheck: warning: no btree indexes to check matching "template1\.public\.foo_idx")' [22:37:19.720](0.000s) not 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")/ [22:37:19.720](0.000s) # Failed test 'checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: warning: no btree indexes to check matching "another_db\.public\.foo_idx")/' # at /Users/admin/pgsql/src/bin/pg_amcheck/t/002_nonesuch.pl line 338. [22:37:19.720](0.000s) # 'pg_amcheck: warning: no connectable databases to check matching "no_such_database.public.foo" # pg_amcheck: warning: no connectable databases to check matching "no_such_database.public.foo_idx" # pg_amcheck: warning: skipping database "another_db": amcheck is not installed # ' # doesn't match '(?^:pg_amcheck: warning: no btree indexes to check matching "another_db\.public\.foo_idx")' [22:37:19.720](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")/ [22:37:19.720](0.000s) not ok 98 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: error: no relations to check)/ [22:37:19.720](0.000s) # Failed test 'checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: error: no relations to check)/' # at /Users/admin/pgsql/src/bin/pg_amcheck/t/002_nonesuch.pl line 338. [22:37:19.720](0.000s) # 'pg_amcheck: warning: no connectable databases to check matching "no_such_database.public.foo" # pg_amcheck: warning: no connectable databases to check matching "no_such_database.public.foo_idx" # pg_amcheck: warning: skipping database "another_db": amcheck is not installed # ' # doesn't match '(?^: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 [22:37:19.740](0.020s) ok 99 - schema exclusion patterns exclude all relations status (got 1 vs expected 1) [22:37:19.740](0.000s) ok 100 - schema exclusion patterns exclude all relations stdout /(?^:^$)/ [22:37:19.740](0.000s) ok 101 - schema exclusion patterns exclude all relations stderr /(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)/ [22:37:19.740](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* [22:37:19.759](0.018s) ok 103 - schema exclusion pattern overrides all inclusion patterns status (got 1 vs expected 1) [22:37:19.759](0.000s) ok 104 - schema exclusion pattern overrides all inclusion patterns stdout /(?^:^$)/ [22:37:19.759](0.000s) ok 105 - schema exclusion pattern overrides all inclusion patterns stderr /(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)/ [22:37:19.759](0.000s) ok 106 - schema exclusion pattern overrides all inclusion patterns stderr /(?^:pg_amcheck: error: no relations to check)/ [22:37:19.759](0.000s) 1..106 ### Stopping node "test" using mode immediate # Running: pg_ctl -D /Users/admin/pgsql/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" [22:37:19.869](0.109s) # Looks like you failed 6 tests of 106.