# Checking port 56521 # Found port 56521 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=56521 host=/var/folders/xc/tpssff9959345bnqq4c6tlww0000gn/T/s607Kbpeut Log file: /Users/admin/pgsql/build/testrun/pg_amcheck/002_nonesuch/log/002_nonesuch_test.log [01:29:52.294](0.017s) # 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 25837 # Running: pg_amcheck qqq [01:29:52.845](0.551s) ok 1 - checking a non-existent database status (got 1 vs expected 1) [01:29:52.845](0.000s) ok 2 - checking a non-existent database stdout /(?^:^$)/ [01:29:52.845](0.000s) ok 3 - checking a non-existent database stderr /(?^:FATAL: database "qqq" does not exist)/ # Running: pg_amcheck -d qqq -d postgres [01:29:52.859](0.013s) ok 4 - checking an unresolvable database pattern status (got 1 vs expected 1) [01:29:52.859](0.000s) ok 5 - checking an unresolvable database pattern stdout /(?^:^$)/ [01:29:52.859](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 [01:29:53.029](0.170s) ok 7 - checking an unresolvable database pattern under --no-strict-names status (got 0 vs expected 0) [01:29:53.029](0.000s) ok 8 - checking an unresolvable database pattern under --no-strict-names stdout /(?^:^$)/ [01:29:53.029](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 [01:29:53.050](0.021s) ok 10 - checking an unresolvable database pattern (substring of existent database) status (got 1 vs expected 1) [01:29:53.051](0.000s) ok 11 - checking an unresolvable database pattern (substring of existent database) stdout /(?^:^$)/ [01:29:53.051](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 [01:29:53.066](0.016s) ok 13 - checking an unresolvable database pattern (superstring of existent database) status (got 1 vs expected 1) [01:29:53.067](0.000s) ok 14 - checking an unresolvable database pattern (superstring of existent database) stdout /(?^:^$)/ [01:29:53.067](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 [01:29:53.078](0.011s) ok 16 - checking with a non-existent user status (got 1 vs expected 1) [01:29:53.078](0.000s) ok 17 - checking with a non-existent user stdout /(?^:^$)/ # Running: pg_amcheck template1 [01:29:53.103](0.024s) ok 18 - checking a database by name without amcheck installed, no other databases status (got 1 vs expected 1) [01:29:53.103](0.000s) ok 19 - checking a database by name without amcheck installed, no other databases stdout /(?^:^$)/ [01:29:53.103](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)/ [01:29:53.103](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 [01:29:53.247](0.144s) ok 22 - checking a database by name without amcheck installed, with other databases status (got 0 vs expected 0) [01:29:53.247](0.000s) ok 23 - checking a database by name without amcheck installed, with other databases stdout /(?^:^$)/ [01:29:53.248](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 [01:29:53.329](0.081s) ok 25 - checking a database by pattern without amcheck installed, with other databases status (got 0 vs expected 0) [01:29:53.329](0.000s) ok 26 - checking a database by pattern without amcheck installed, with other databases stdout /(?^:^$)/ [01:29:53.329](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 .. [01:29:53.380](0.050s) ok 28 - checking table pattern ".." status (got 1 vs expected 1) [01:29:53.380](0.000s) ok 29 - checking table pattern ".." stdout /(?^:^$)/ [01:29:53.380](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 [01:29:53.508](0.128s) ok 31 - checking table pattern ".foo.bar" status (got 1 vs expected 1) [01:29:53.508](0.000s) ok 32 - checking table pattern ".foo.bar" stdout /(?^:^$)/ [01:29:53.509](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 . [01:29:53.544](0.035s) ok 34 - checking table pattern "." status (got 1 vs expected 1) [01:29:53.544](0.000s) ok 35 - checking table pattern "." stdout /(?^:^$)/ [01:29:53.544](0.000s) ok 36 - checking table pattern "." stderr /(?^:pg_amcheck: error: no heap tables to check matching "\.")/ # Running: pg_amcheck -d localhost.postgres [01:29:53.557](0.013s) ok 37 - multipart database patterns are rejected status (got 2 vs expected 2) [01:29:53.557](0.000s) ok 38 - multipart database patterns are rejected stdout /(?^:^$)/ [01:29:53.557](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 [01:29:53.571](0.014s) ok 40 - three part schema patterns are rejected status (got 2 vs expected 2) [01:29:53.571](0.000s) ok 41 - three part schema patterns are rejected stdout /(?^:^$)/ [01:29:53.571](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 [01:29:53.585](0.014s) ok 43 - four part table patterns are rejected status (got 2 vs expected 2) [01:29:53.585](0.000s) ok 44 - four part table patterns are rejected stdout /(?^:^$)/ [01:29:53.586](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 [01:29:53.600](0.014s) ok 46 - ungrammatical table names still draw errors under --no-strict-names status (got 2 vs expected 2) [01:29:53.600](0.000s) ok 47 - ungrammatical table names still draw errors under --no-strict-names stdout /(?^:^$)/ [01:29:53.600](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 [01:29:53.613](0.013s) ok 49 - ungrammatical schema names still draw errors under --no-strict-names status (got 2 vs expected 2) [01:29:53.613](0.000s) ok 50 - ungrammatical schema names still draw errors under --no-strict-names stdout /(?^:^$)/ [01:29:53.613](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 [01:29:53.627](0.014s) ok 52 - ungrammatical database names still draw errors under --no-strict-names status (got 2 vs expected 2) [01:29:53.627](0.000s) ok 53 - ungrammatical database names still draw errors under --no-strict-names stdout /(?^:^$)/ [01:29:53.627](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 [01:29:53.639](0.012s) ok 55 - ungrammatical table exclusions still draw errors under --no-strict-names status (got 2 vs expected 2) [01:29:53.640](0.000s) ok 56 - ungrammatical table exclusions still draw errors under --no-strict-names stdout /(?^:^$)/ [01:29:53.640](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 [01:29:53.715](0.075s) ok 58 - ungrammatical schema exclusions still draw errors under --no-strict-names status (got 2 vs expected 2) [01:29:53.720](0.005s) ok 59 - ungrammatical schema exclusions still draw errors under --no-strict-names stdout /(?^:^$)/ [01:29:53.720](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 [01:29:53.739](0.019s) ok 61 - ungrammatical database exclusions still draw errors under --no-strict-names status (got 2 vs expected 2) [01:29:53.739](0.000s) ok 62 - ungrammatical database exclusions still draw errors under --no-strict-names stdout /(?^:^$)/ [01:29:53.739](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 [01:29:53.765](0.026s) ok 64 - many unmatched patterns and one matched pattern under --no-strict-names status (got 0 vs expected 0) [01:29:53.765](0.000s) ok 65 - many unmatched patterns and one matched pattern under --no-strict-names stdout /(?^:^$)/ [01:29:53.765](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")/ [01:29:53.765](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")/ [01:29:53.765](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")/ [01:29:53.765](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")/ [01:29:53.765](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")/ [01:29:53.823](0.058s) 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")/ [01:29:53.823](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")/ [01:29:53.823](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")/ [01:29:53.824](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")/ [01:29:53.824](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")/ [01:29:53.824](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")/ [01:29:53.824](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")/ [01:29:53.824](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")/ [01:29:53.824](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")/ [01:29:53.824](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")/ [01:29:53.824](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")/ [01:29:53.824](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 [01:29:54.025](0.201s) ok 83 - checking handling of invalid database status (got 1 vs expected 1) [01:29:54.025](0.000s) ok 84 - checking handling of invalid database stdout /(?^:^$)/ [01:29:54.025](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 [01:29:54.037](0.012s) ok 86 - checking handling of object in invalid database status (got 1 vs expected 1) [01:29:54.133](0.096s) ok 87 - checking handling of object in invalid database stdout /(?^:^$)/ [01:29:54.133](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 [01:29:54.445](0.312s) ok 89 - checking otherwise existent objects in the wrong databases status (got 1 vs expected 1) [01:29:54.445](0.000s) ok 90 - checking otherwise existent objects in the wrong databases stdout /(?^:^$)/ [01:29:54.445](0.000s) not ok 91 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)/ [01:29:54.446](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. [01:29:54.446](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)' [01:29:54.446](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")/ [01:29:54.446](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. [01:29:54.446](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")' [01:29:54.446](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")/ [01:29:54.446](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. [01:29:54.446](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")' [01:29:54.446](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")/ [01:29:54.446](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")/ [01:29:54.446](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. [01:29:54.446](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")' [01:29:54.446](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")/ [01:29:54.446](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. [01:29:54.447](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")' [01:29:54.447](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")/ [01:29:54.447](0.000s) not ok 98 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: error: no relations to check)/ [01:29:54.447](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. [01:29:54.447](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 [01:29:54.476](0.029s) ok 99 - schema exclusion patterns exclude all relations status (got 1 vs expected 1) [01:29:54.476](0.000s) ok 100 - schema exclusion patterns exclude all relations stdout /(?^:^$)/ [01:29:54.476](0.000s) ok 101 - schema exclusion patterns exclude all relations stderr /(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)/ [01:29:54.477](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* [01:29:54.503](0.027s) ok 103 - schema exclusion pattern overrides all inclusion patterns status (got 1 vs expected 1) [01:29:54.503](0.000s) ok 104 - schema exclusion pattern overrides all inclusion patterns stdout /(?^:^$)/ [01:29:54.504](0.000s) ok 105 - schema exclusion pattern overrides all inclusion patterns stderr /(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)/ [01:29:54.504](0.000s) ok 106 - schema exclusion pattern overrides all inclusion patterns stderr /(?^:pg_amcheck: error: no relations to check)/ [01:29:54.504](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" [01:29:54.615](0.111s) # Looks like you failed 6 tests of 106.