# Checking port 23236
# Found port 23236
Name: test
Version: 19devel
Data directory: /tmp/cirrus-ci-build/build/testrun/pg_amcheck/003_check/data/t_003_check_test_data/pgdata
Backup directory: /tmp/cirrus-ci-build/build/testrun/pg_amcheck/003_check/data/t_003_check_test_data/backup
Archive directory: /tmp/cirrus-ci-build/build/testrun/pg_amcheck/003_check/data/t_003_check_test_data/archives
Connection string: port=23236 host=/tmp/giX7DI0jF0
Log file: /tmp/cirrus-ci-build/build/testrun/pg_amcheck/003_check/log/003_check_test.log
[21:22:36.841](0.025s) # initializing database system by running initdb
# Running: initdb --no-sync --pgdata /tmp/cirrus-ci-build/build/testrun/pg_amcheck/003_check/data/t_003_check_test_data/pgdata --auth trust -c debug_copy_parse_plan_trees=on -c debug_write_read_parse_plan_trees=on -c debug_raw_expression_coverage_test=on -c debug_parallel_query=regress --no-data-checksums
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with this locale configuration:
  locale provider:   libc
  LC_COLLATE:  en_US.UTF-8
  LC_CTYPE:    en_US.UTF-8
  LC_MESSAGES: C
  LC_MONETARY: en_US.UTF-8
  LC_NUMERIC:  C
  LC_TIME:     en_US.UTF-8
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory /tmp/cirrus-ci-build/build/testrun/pg_amcheck/003_check/data/t_003_check_test_data/pgdata ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default "max_connections" ... 100
selecting default "shared_buffers" ... 128MB
selecting default time zone ... UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok

Sync to disk skipped.
The data directory might become corrupt if the operating system crashes.

Success. You can now start the database server using:

    pg_ctl -D /tmp/cirrus-ci-build/build/testrun/pg_amcheck/003_check/data/t_003_check_test_data/pgdata -l logfile start

# Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/pg_amcheck/003_check/data/t_003_check_test_data/pgdata
### Starting node "test"
# Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/pg_amcheck/003_check/data/t_003_check_test_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/pg_amcheck/003_check/log/003_check_test.log --options --cluster-name=test start
waiting for server to start.... done
server started
# Postmaster PID for node "test" is 7977
#### Begin standard error
psql:<stdin>:1: WARNING:  databases created by regression test cases should have names including "regression"
#### End standard error
#### Begin standard error
psql:<stdin>:1: WARNING:  databases created by regression test cases should have names including "regression"
#### End standard error
#### Begin standard error
psql:<stdin>:1: WARNING:  databases created by regression test cases should have names including "regression"
#### End standard error
# Running: pg_amcheck --port 23236 --database db1 --database db2 --database db3
[21:22:45.707](8.866s) ok 1 - pg_amcheck prior to corruption status (got 0 vs expected 0)
[21:22:45.707](0.001s) ok 2 - pg_amcheck prior to corruption stdout /(?^:^$)/
[21:22:45.708](0.000s) ok 3 - pg_amcheck prior to corruption stderr /(?^:^$)/
### Stopping node "test" using mode fast
# Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/pg_amcheck/003_check/data/t_003_check_test_data/pgdata --mode fast stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "test"
### Starting node "test"
# Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/pg_amcheck/003_check/data/t_003_check_test_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/pg_amcheck/003_check/log/003_check_test.log --options --cluster-name=test start
waiting for server to start.... done
server started
# Postmaster PID for node "test" is 9853
# Running: pg_amcheck --port 23236 db1
[21:22:46.642](0.935s) ok 4 - pg_amcheck all schemas, tables and indexes in database db1 status (got 2 vs expected 2)
[21:22:46.643](0.001s) ok 5 - pg_amcheck all schemas, tables and indexes in database db1 stdout /(?^:index ".*" lacks a main relation fork)/
[21:22:46.643](0.000s) ok 6 - pg_amcheck all schemas, tables and indexes in database db1 stdout /(?^:line pointer)/
[21:22:46.644](0.000s) ok 7 - pg_amcheck all schemas, tables and indexes in database db1 stdout /(?^:could not open file ".*": No such file or directory)/
[21:22:46.644](0.000s) ok 8 - pg_amcheck all schemas, tables and indexes in database db1 stderr /(?^:^$)/
# Running: pg_amcheck --port 23236 --database db1 --database db2 --database db3
[21:22:49.096](2.452s) ok 9 - pg_amcheck all schemas, tables and indexes in databases db1, db2, and db3 status (got 2 vs expected 2)
[21:22:49.097](0.001s) ok 10 - pg_amcheck all schemas, tables and indexes in databases db1, db2, and db3 stdout /(?^:index ".*" lacks a main relation fork)/
[21:22:49.097](0.000s) ok 11 - pg_amcheck all schemas, tables and indexes in databases db1, db2, and db3 stdout /(?^:line pointer)/
[21:22:49.097](0.000s) ok 12 - pg_amcheck all schemas, tables and indexes in databases db1, db2, and db3 stdout /(?^:could not open file ".*": No such file or directory)/
[21:22:49.098](0.000s) ok 13 - pg_amcheck all schemas, tables and indexes in databases db1, db2, and db3 stderr /(?^:^$)/
# Running: pg_amcheck --port 23236 --all --schema s1 --index t1_btree
[21:22:49.427](0.329s) ok 14 - pg_amcheck index s1.t1_btree reports missing main relation fork status (got 2 vs expected 2)
[21:22:49.428](0.001s) ok 15 - pg_amcheck index s1.t1_btree reports missing main relation fork stdout /(?^:index ".*" lacks a main relation fork)/
[21:22:49.428](0.000s) ok 16 - pg_amcheck index s1.t1_btree reports missing main relation fork stderr /(?^:pg_amcheck: warning: skipping database "postgres": amcheck is not installed)/
# Running: pg_amcheck --port 23236 --database db1 --schema s1 --index t2_btree
[21:22:49.499](0.071s) ok 17 - pg_amcheck index s1.s2 reports index corruption status (got 2 vs expected 2)
[21:22:49.501](0.002s) ok 18 - pg_amcheck index s1.s2 reports index corruption stdout /(?^:.+)/
[21:22:49.503](0.002s) ok 19 - pg_amcheck index s1.s2 reports index corruption stderr /(?^:^$)/
# Running: pg_amcheck --port 23236 --table s1.* --no-dependent-indexes db1
[21:22:49.548](0.045s) ok 20 - pg_amcheck of db1.s1 excluding indexes status (got 0 vs expected 0)
[21:22:49.548](0.000s) ok 21 - pg_amcheck of db1.s1 excluding indexes stdout /(?^:^$)/
[21:22:49.549](0.000s) ok 22 - pg_amcheck of db1.s1 excluding indexes stderr /(?^:^$)/
# Running: pg_amcheck --port 23236 --table s1.* --no-dependent-indexes db2
[21:22:49.620](0.072s) ok 23 - pg_amcheck of db2.s1 excluding indexes status (got 2 vs expected 2)
[21:22:49.621](0.001s) ok 24 - pg_amcheck of db2.s1 excluding indexes stdout /(?^:could not open file ".*": No such file or directory)/
[21:22:49.621](0.000s) ok 25 - pg_amcheck of db2.s1 excluding indexes stderr /(?^:^$)/
# Running: pg_amcheck --port 23236 --schema s3 db1
[21:22:49.687](0.066s) ok 26 - pg_amcheck schema s3 reports table and index errors status (got 2 vs expected 2)
[21:22:49.689](0.001s) ok 27 - pg_amcheck schema s3 reports table and index errors stdout /(?^:index ".*" lacks a main relation fork)/
[21:22:49.689](0.000s) ok 28 - pg_amcheck schema s3 reports table and index errors stdout /(?^:line pointer)/
[21:22:49.689](0.000s) ok 29 - pg_amcheck schema s3 reports table and index errors stdout /(?^:could not open file ".*": No such file or directory)/
[21:22:49.690](0.000s) ok 30 - pg_amcheck schema s3 reports table and index errors stderr /(?^:^$)/
# Running: pg_amcheck --port 23236 --schema s4 db1
[21:22:49.830](0.140s) ok 31 - pg_amcheck in schema s4 reports toast corruption status (got 2 vs expected 2)
[21:22:49.832](0.002s) ok 32 - pg_amcheck in schema s4 reports toast corruption stdout /(?^:could not open file ".*": No such file or directory)/
[21:22:49.834](0.003s) ok 33 - pg_amcheck in schema s4 reports toast corruption stderr /(?^:^$)/
# Running: pg_amcheck --port 23236 --no-dependent-toast --exclude-toast-pointers --schema s4 db1
[21:22:49.917](0.083s) ok 34 - pg_amcheck in schema s4 excluding toast reports no corruption status (got 0 vs expected 0)
[21:22:49.920](0.003s) ok 35 - pg_amcheck in schema s4 excluding toast reports no corruption stdout /(?^:^$)/
[21:22:49.921](0.001s) ok 36 - pg_amcheck in schema s4 excluding toast reports no corruption stderr /(?^:^$)/
# Running: pg_amcheck --port 23236 --schema s5 db1
[21:22:50.014](0.093s) ok 37 - pg_amcheck over schema s5 reports no corruption status (got 0 vs expected 0)
[21:22:50.014](0.001s) ok 38 - pg_amcheck over schema s5 reports no corruption stdout /(?^:^$)/
[21:22:50.015](0.000s) ok 39 - pg_amcheck over schema s5 reports no corruption stderr /(?^:^$)/
# Running: pg_amcheck --port 23236 --schema s1 --exclude-index t1_btree --exclude-index t2_btree db1
[21:22:50.094](0.079s) ok 40 - pg_amcheck over schema s1 with corrupt indexes excluded reports no corruption status (got 0 vs expected 0)
[21:22:50.096](0.002s) ok 41 - pg_amcheck over schema s1 with corrupt indexes excluded reports no corruption stdout /(?^:^$)/
[21:22:50.098](0.002s) ok 42 - pg_amcheck over schema s1 with corrupt indexes excluded reports no corruption stderr /(?^:^$)/
# Running: pg_amcheck --port 23236 --table s1.* --no-dependent-indexes db1
[21:22:50.155](0.057s) ok 43 - pg_amcheck over schema s1 with all indexes excluded reports no corruption status (got 0 vs expected 0)
[21:22:50.157](0.002s) ok 44 - pg_amcheck over schema s1 with all indexes excluded reports no corruption stdout /(?^:^$)/
[21:22:50.157](0.001s) ok 45 - pg_amcheck over schema s1 with all indexes excluded reports no corruption stderr /(?^:^$)/
# Running: pg_amcheck --port 23236 --schema s2 --exclude-table t1 --exclude-table t2 db1
[21:22:50.207](0.050s) not ok 46 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption status (got 2 vs expected 0)
[21:22:50.208](0.000s) #   Failed test 'pg_amcheck over schema s2 with corrupt tables excluded reports no corruption status (got 2 vs expected 0)'
#   at /tmp/cirrus-ci-build/src/bin/pg_amcheck/t/003_check.pl line 501.
[21:22:50.208](0.001s) not ok 47 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption stdout /(?^:^$)/
[21:22:50.208](0.000s) #   Failed test 'pg_amcheck over schema s2 with corrupt tables excluded reports no corruption stdout /(?^:^$)/'
#   at /tmp/cirrus-ci-build/src/bin/pg_amcheck/t/003_check.pl line 501.
[21:22:50.209](0.000s) #                   'btree index "db1.s2.t1_btree":
#     ERROR:  could not open file "base/16384/16508": No such file or directory
# btree index "db1.s2.t1_btree_unique":
#     ERROR:  could not open file "base/16384/16508": No such file or directory
# '
#     doesn't match '(?^:^$)'
[21:22:50.209](0.000s) ok 48 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption stderr /(?^:^$)/
# Running: pg_amcheck --port 23236 --schema s5 --startblock junk db1
[21:22:50.216](0.007s) ok 49 - pg_amcheck rejects garbage startblock: exit code not 0
[21:22:50.217](0.001s) ok 50 - pg_amcheck rejects garbage startblock: matches
# Running: pg_amcheck --port 23236 --schema s5 --endblock 1234junk db1
[21:22:50.227](0.010s) ok 51 - pg_amcheck rejects garbage endblock: exit code not 0
[21:22:50.227](0.001s) ok 52 - pg_amcheck rejects garbage endblock: matches
# Running: pg_amcheck --port 23236 --schema s5 --startblock 5 --endblock 4 db1
[21:22:50.234](0.007s) ok 53 - pg_amcheck rejects invalid block range: exit code not 0
[21:22:50.235](0.001s) ok 54 - pg_amcheck rejects invalid block range: matches
# Running: pg_amcheck --port 23236 --schema s1 --index t1_btree --parent-check db1
[21:22:50.299](0.064s) ok 55 - pg_amcheck smoke test --parent-check status (got 2 vs expected 2)
[21:22:50.299](0.001s) ok 56 - pg_amcheck smoke test --parent-check stdout /(?^:index ".*" lacks a main relation fork)/
[21:22:50.300](0.000s) ok 57 - pg_amcheck smoke test --parent-check stderr /(?^:^$)/
# Running: pg_amcheck --port 23236 --schema s1 --index t1_btree --heapallindexed --rootdescend db1
[21:22:50.362](0.062s) ok 58 - pg_amcheck smoke test --heapallindexed --rootdescend status (got 2 vs expected 2)
[21:22:50.373](0.011s) ok 59 - pg_amcheck smoke test --heapallindexed --rootdescend stdout /(?^:index ".*" lacks a main relation fork)/
[21:22:50.373](0.000s) ok 60 - pg_amcheck smoke test --heapallindexed --rootdescend stderr /(?^:^$)/
# Running: pg_amcheck --port 23236 --database db1 --database db2 --database db3 --exclude-schema s*
[21:22:51.710](1.337s) ok 61 - pg_amcheck excluding all corrupt schemas status (got 0 vs expected 0)
[21:22:51.711](0.001s) ok 62 - pg_amcheck excluding all corrupt schemas stdout /(?^:^$)/
[21:22:51.711](0.000s) ok 63 - pg_amcheck excluding all corrupt schemas stderr /(?^:^$)/
# Running: pg_amcheck --port 23236 --schema s1 --index t1_btree --parent-check --checkunique db1
[21:22:51.801](0.090s) ok 64 - pg_amcheck smoke test --parent-check --checkunique status (got 2 vs expected 2)
[21:22:51.802](0.001s) ok 65 - pg_amcheck smoke test --parent-check --checkunique stdout /(?^:index ".*" lacks a main relation fork)/
[21:22:51.802](0.000s) ok 66 - pg_amcheck smoke test --parent-check --checkunique stderr /(?^:^$)/
# Running: pg_amcheck --port 23236 --schema s1 --index t1_btree --heapallindexed --rootdescend --checkunique db1
[21:22:51.994](0.191s) ok 67 - pg_amcheck smoke test --heapallindexed --rootdescend --checkunique status (got 2 vs expected 2)
[21:22:51.994](0.001s) ok 68 - pg_amcheck smoke test --heapallindexed --rootdescend --checkunique stdout /(?^:index ".*" lacks a main relation fork)/
[21:22:51.995](0.001s) ok 69 - pg_amcheck smoke test --heapallindexed --rootdescend --checkunique stderr /(?^:^$)/
# Running: pg_amcheck --port 23236 --checkunique --database db1 --database db2 --database db3 --exclude-schema s*
[21:22:53.224](1.229s) ok 70 - pg_amcheck excluding all corrupt schemas with --checkunique option status (got 0 vs expected 0)
[21:22:53.224](0.001s) ok 71 - pg_amcheck excluding all corrupt schemas with --checkunique option stdout /(?^:^$)/
[21:22:53.226](0.002s) ok 72 - pg_amcheck excluding all corrupt schemas with --checkunique option stderr /(?^:^$)/
# Running: pg_amcheck --port 23236 --checkunique db3
[21:22:53.602](0.376s) ok 73 - pg_amcheck smoke test --checkunique status (got 0 vs expected 0)
[21:22:53.602](0.001s) ok 74 - pg_amcheck smoke test --checkunique stdout /(?^:^$)/
[21:22:53.603](0.000s) ok 75 - pg_amcheck smoke test --checkunique stderr /(?^:pg_amcheck: warning: option --checkunique is not supported by amcheck version 1.3)/
[21:22:53.603](0.001s) 1..75
### Stopping node "test" using mode immediate
# Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/pg_amcheck/003_check/data/t_003_check_test_data/pgdata --mode immediate stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "test"
[21:22:53.717](0.114s) # Looks like you failed 2 tests of 75.