# Checking port 56875 # Found port 56875 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=56875 host=/var/folders/xc/tpssff9959345bnqq4c6tlww0000gn/T/_wwt03eiK7 Log file: /Users/admin/pgsql/build/testrun/pg_amcheck/002_nonesuch/log/002_nonesuch_test.log [06:00:00.962](0.022s) # 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 25127 # Running: pg_amcheck qqq [06:00:01.793](0.831s) ok 1 - checking a non-existent database status (got 1 vs expected 1) [06:00:01.794](0.000s) ok 2 - checking a non-existent database stdout /(?^:^$)/ [06:00:01.794](0.000s) ok 3 - checking a non-existent database stderr /(?^:FATAL: database "qqq" does not exist)/ # Running: pg_amcheck -d qqq -d postgres [06:00:01.818](0.024s) ok 4 - checking an unresolvable database pattern status (got 1 vs expected 1) [06:00:01.818](0.000s) ok 5 - checking an unresolvable database pattern stdout /(?^:^$)/ [06:00:01.818](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 [06:00:01.883](0.065s) ok 7 - checking an unresolvable database pattern under --no-strict-names status (got 0 vs expected 0) [06:00:01.884](0.000s) ok 8 - checking an unresolvable database pattern under --no-strict-names stdout /(?^:^$)/ [06:00:01.884](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 [06:00:01.897](0.013s) ok 10 - checking an unresolvable database pattern (substring of existent database) status (got 1 vs expected 1) [06:00:01.897](0.000s) ok 11 - checking an unresolvable database pattern (substring of existent database) stdout /(?^:^$)/ [06:00:01.897](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 [06:00:01.908](0.011s) ok 13 - checking an unresolvable database pattern (superstring of existent database) status (got 1 vs expected 1) [06:00:01.908](0.000s) ok 14 - checking an unresolvable database pattern (superstring of existent database) stdout /(?^:^$)/ [06:00:01.908](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 [06:00:01.917](0.009s) ok 16 - checking with a non-existent user status (got 1 vs expected 1) [06:00:01.917](0.000s) ok 17 - checking with a non-existent user stdout /(?^:^$)/ # Running: pg_amcheck template1 [06:00:01.930](0.013s) ok 18 - checking a database by name without amcheck installed, no other databases status (got 1 vs expected 1) [06:00:01.930](0.000s) ok 19 - checking a database by name without amcheck installed, no other databases stdout /(?^:^$)/ [06:00:01.930](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)/ [06:00:01.930](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 [06:00:02.086](0.156s) ok 22 - checking a database by name without amcheck installed, with other databases status (got 0 vs expected 0) [06:00:02.086](0.000s) ok 23 - checking a database by name without amcheck installed, with other databases stdout /(?^:^$)/ [06:00:02.086](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 [06:00:02.188](0.102s) ok 25 - checking a database by pattern without amcheck installed, with other databases status (got 0 vs expected 0) [06:00:02.188](0.000s) ok 26 - checking a database by pattern without amcheck installed, with other databases stdout /(?^:^$)/ [06:00:02.188](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 .. [06:00:02.222](0.034s) ok 28 - checking table pattern ".." status (got 1 vs expected 1) [06:00:02.223](0.000s) ok 29 - checking table pattern ".." stdout /(?^:^$)/ [06:00:02.223](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 [06:00:02.238](0.016s) ok 31 - checking table pattern ".foo.bar" status (got 1 vs expected 1) [06:00:02.238](0.000s) ok 32 - checking table pattern ".foo.bar" stdout /(?^:^$)/ [06:00:02.238](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 . [06:00:02.255](0.017s) ok 34 - checking table pattern "." status (got 1 vs expected 1) [06:00:02.256](0.000s) ok 35 - checking table pattern "." stdout /(?^:^$)/ [06:00:02.256](0.000s) ok 36 - checking table pattern "." stderr /(?^:pg_amcheck: error: no heap tables to check matching "\.")/ # Running: pg_amcheck -d localhost.postgres [06:00:02.265](0.009s) ok 37 - multipart database patterns are rejected status (got 2 vs expected 2) [06:00:02.265](0.000s) ok 38 - multipart database patterns are rejected stdout /(?^:^$)/ [06:00:02.265](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 [06:00:02.276](0.011s) ok 40 - three part schema patterns are rejected status (got 2 vs expected 2) [06:00:02.276](0.000s) ok 41 - three part schema patterns are rejected stdout /(?^:^$)/ [06:00:02.276](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 [06:00:02.287](0.010s) ok 43 - four part table patterns are rejected status (got 2 vs expected 2) [06:00:02.287](0.000s) ok 44 - four part table patterns are rejected stdout /(?^:^$)/ [06:00:02.287](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 [06:00:02.299](0.012s) ok 46 - ungrammatical table names still draw errors under --no-strict-names status (got 2 vs expected 2) [06:00:02.299](0.000s) ok 47 - ungrammatical table names still draw errors under --no-strict-names stdout /(?^:^$)/ [06:00:02.299](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 [06:00:02.313](0.014s) ok 49 - ungrammatical schema names still draw errors under --no-strict-names status (got 2 vs expected 2) [06:00:02.314](0.000s) ok 50 - ungrammatical schema names still draw errors under --no-strict-names stdout /(?^:^$)/ [06:00:02.314](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 [06:00:02.330](0.016s) ok 52 - ungrammatical database names still draw errors under --no-strict-names status (got 2 vs expected 2) [06:00:02.330](0.000s) ok 53 - ungrammatical database names still draw errors under --no-strict-names stdout /(?^:^$)/ [06:00:02.330](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 [06:00:02.352](0.022s) ok 55 - ungrammatical table exclusions still draw errors under --no-strict-names status (got 2 vs expected 2) [06:00:02.352](0.000s) ok 56 - ungrammatical table exclusions still draw errors under --no-strict-names stdout /(?^:^$)/ [06:00:02.353](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 [06:00:02.365](0.013s) ok 58 - ungrammatical schema exclusions still draw errors under --no-strict-names status (got 2 vs expected 2) [06:00:02.366](0.000s) ok 59 - ungrammatical schema exclusions still draw errors under --no-strict-names stdout /(?^:^$)/ [06:00:02.366](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 [06:00:02.379](0.013s) ok 61 - ungrammatical database exclusions still draw errors under --no-strict-names status (got 2 vs expected 2) [06:00:02.379](0.000s) ok 62 - ungrammatical database exclusions still draw errors under --no-strict-names stdout /(?^:^$)/ [06:00:02.379](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 [06:00:02.408](0.029s) ok 64 - many unmatched patterns and one matched pattern under --no-strict-names status (got 0 vs expected 0) [06:00:02.408](0.000s) ok 65 - many unmatched patterns and one matched pattern under --no-strict-names stdout /(?^:^$)/ [06:00:02.408](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")/ [06:00:02.408](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")/ [06:00:02.408](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")/ [06:00:02.409](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")/ [06:00:02.409](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")/ [06:00:02.409](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")/ [06:00:02.409](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")/ [06:00:02.409](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")/ [06:00:02.409](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")/ [06:00:02.409](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")/ [06:00:02.409](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")/ [06:00:02.409](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")/ [06:00:02.409](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")/ [06:00:02.409](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")/ [06:00:02.409](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")/ [06:00:02.409](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")/ [06:00:02.409](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 [06:00:02.514](0.105s) ok 83 - checking handling of invalid database status (got 1 vs expected 1) [06:00:02.514](0.000s) ok 84 - checking handling of invalid database stdout /(?^:^$)/ [06:00:02.514](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 [06:00:02.536](0.022s) ok 86 - checking handling of object in invalid database status (got 1 vs expected 1) [06:00:02.536](0.000s) ok 87 - checking handling of object in invalid database stdout /(?^:^$)/ [06:00:02.536](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 [06:00:02.784](0.248s) ok 89 - checking otherwise existent objects in the wrong databases status (got 1 vs expected 1) [06:00:02.785](0.000s) ok 90 - checking otherwise existent objects in the wrong databases stdout /(?^:^$)/ [06:00:02.785](0.000s) not ok 91 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)/ [06:00:02.785](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. [06:00:02.785](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)' [06:00:02.785](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")/ [06:00:02.785](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. [06:00:02.785](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")' [06:00:02.785](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")/ [06:00:02.785](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. [06:00:02.785](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")' [06:00:02.786](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")/ [06:00:02.786](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")/ [06:00:02.786](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. [06:00:02.786](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")' [06:00:02.786](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")/ [06:00:02.786](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. [06:00:02.786](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")' [06:00:02.786](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")/ [06:00:02.786](0.000s) not ok 98 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: error: no relations to check)/ [06:00:02.786](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. [06:00:02.786](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 [06:00:02.819](0.033s) ok 99 - schema exclusion patterns exclude all relations status (got 1 vs expected 1) [06:00:02.819](0.000s) ok 100 - schema exclusion patterns exclude all relations stdout /(?^:^$)/ [06:00:02.819](0.000s) ok 101 - schema exclusion patterns exclude all relations stderr /(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)/ [06:00:02.819](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* [06:00:02.842](0.023s) ok 103 - schema exclusion pattern overrides all inclusion patterns status (got 1 vs expected 1) [06:00:02.842](0.000s) ok 104 - schema exclusion pattern overrides all inclusion patterns stdout /(?^:^$)/ [06:00:02.842](0.000s) ok 105 - schema exclusion pattern overrides all inclusion patterns stderr /(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)/ [06:00:02.842](0.000s) ok 106 - schema exclusion pattern overrides all inclusion patterns stderr /(?^:pg_amcheck: error: no relations to check)/ [06:00:02.842](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" [06:00:02.956](0.113s) # Looks like you failed 6 tests of 106.