# Checking port 51932
# Found port 51932
Name: node_checksum
Data directory: /tmp/cirrus-ci-build/build/testrun/pg_checksums/002_actions/data/t_002_actions_node_checksum_data/pgdata
Backup directory: /tmp/cirrus-ci-build/build/testrun/pg_checksums/002_actions/data/t_002_actions_node_checksum_data/backup
Archive directory: /tmp/cirrus-ci-build/build/testrun/pg_checksums/002_actions/data/t_002_actions_node_checksum_data/archives
Connection string: port=51932 host=/tmp/6o04M_oH89
Log file: /tmp/cirrus-ci-build/build/testrun/pg_checksums/002_actions/log/002_actions_node_checksum.log
[18:47:40.250](0.013s) # initializing database system by copying initdb template
# Running: cp -RPp /tmp/cirrus-ci-build/build/tmp_install/initdb-template /tmp/cirrus-ci-build/build/testrun/pg_checksums/002_actions/data/t_002_actions_node_checksum_data/pgdata
# Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/pg_checksums/002_actions/data/t_002_actions_node_checksum_data/pgdata
# Running: pg_controldata /tmp/cirrus-ci-build/build/testrun/pg_checksums/002_actions/data/t_002_actions_node_checksum_data/pgdata
[18:47:40.507](0.256s) ok 1 - checksums disabled in control file: exit code 0
[18:47:40.507](0.000s) ok 2 - checksums disabled in control file: no stderr
[18:47:40.507](0.000s) ok 3 - checksums disabled in control file: matches
# Running: pg_checksums --enable --no-sync -D /tmp/cirrus-ci-build/build/testrun/pg_checksums/002_actions/data/t_002_actions_node_checksum_data/pgdata
pg_checksums: error: cluster must be shut down
[18:47:40.520](0.013s) not ok 4 - checksums successfully enabled in cluster
[18:47:40.520](0.000s) #   Failed test 'checksums successfully enabled in cluster'
#   at /tmp/cirrus-ci-build/src/bin/pg_checksums/t/002_actions.pl line 125.
# Running: pg_checksums --enable --no-sync -D /tmp/cirrus-ci-build/build/testrun/pg_checksums/002_actions/data/t_002_actions_node_checksum_data/pgdata
pg_checksums: error: cluster must be shut down
[18:47:40.532](0.012s) ok 5 - enabling checksums fails if already enabled
# Running: pg_controldata /tmp/cirrus-ci-build/build/testrun/pg_checksums/002_actions/data/t_002_actions_node_checksum_data/pgdata
[18:47:40.536](0.003s) ok 6 - checksums enabled in control file: exit code 0
[18:47:40.536](0.000s) ok 7 - checksums enabled in control file: no stderr
[18:47:40.536](0.000s) not ok 8 - checksums enabled in control file: matches
[18:47:40.536](0.000s) #   Failed test 'checksums enabled in control file: matches'
#   at /tmp/cirrus-ci-build/src/bin/pg_checksums/t/002_actions.pl line 133.
[18:47:40.537](0.000s) #                   'pg_control version number:            1300
# Catalog version number:               202402142
# Database system identifier:           7340355284229055003
# Database cluster state:               in production
# pg_control last modified:             Tue Feb 27 18:47:25 2024
# Latest checkpoint location:           0/10B1BC0
# Latest checkpoint's REDO location:    0/10B1BC0
# Latest checkpoint's REDO WAL file:    000000010000000000000001
# Latest checkpoint's TimeLineID:       1
# Latest checkpoint's PrevTimeLineID:   1
# Latest checkpoint's full_page_writes: on
# Latest checkpoint's NextXID:          0:3
# Latest checkpoint's NextOID:          10115
# Latest checkpoint's NextMultiXactId:  1
# Latest checkpoint's NextMultiOffset:  0
# Latest checkpoint's oldestXID:        3
# Latest checkpoint's oldestXID's DB:   1
# Latest checkpoint's oldestActiveXID:  0
# Latest checkpoint's oldestMultiXid:   1
# Latest checkpoint's oldestMulti's DB: 1
# Latest checkpoint's oldestCommitTsXid:0
# Latest checkpoint's newestCommitTsXid:0
# Time of latest checkpoint:            Tue Feb 27 18:47:25 2024
# Fake LSN counter for unlogged rels:   0/3E8
# Minimum recovery ending location:     0/0
# Min recovery ending loc's timeline:   0
# Backup start location:                0/0
# Backup end location:                  0/0
# End-of-backup record required:        no
# wal_level setting:                    replica
# wal_log_hints setting:                off
# max_connections setting:              100
# max_worker_processes setting:         8
# max_wal_senders setting:              10
# max_prepared_xacts setting:           0
# max_locks_per_xact setting:           64
# track_commit_timestamp setting:       off
# Maximum data alignment:               8
# Database block size:                  8192
# Blocks per segment of large relation: 131072
# WAL block size:                       8192
# Bytes per WAL segment:                16777216
# Maximum length of identifiers:        64
# Maximum columns in an index:          32
# Maximum size of a TOAST chunk:        1996
# Size of a large-object chunk:         2048
# Date/time type storage:               64-bit integers
# Float8 argument passing:              by value
# Data page checksum version:           0
# Mock authentication nonce:            3485ca510088c91f9bc7cab28046af8a849b87e2b68942379ef1a3076ef226a7
# '
#     doesn't match '(?^:Data page checksum version:.*1)'
# Running: pg_checksums --disable -D /tmp/cirrus-ci-build/build/testrun/pg_checksums/002_actions/data/t_002_actions_node_checksum_data/pgdata
pg_checksums: error: cluster must be shut down
[18:47:40.549](0.012s) not ok 9 - checksums successfully disabled in cluster
[18:47:40.549](0.000s) #   Failed test 'checksums successfully disabled in cluster'
#   at /tmp/cirrus-ci-build/src/bin/pg_checksums/t/002_actions.pl line 139.
# Running: pg_checksums --disable --no-sync -D /tmp/cirrus-ci-build/build/testrun/pg_checksums/002_actions/data/t_002_actions_node_checksum_data/pgdata
pg_checksums: error: cluster must be shut down
[18:47:40.562](0.013s) ok 10 - disabling checksums fails if already disabled
# Running: pg_controldata /tmp/cirrus-ci-build/build/testrun/pg_checksums/002_actions/data/t_002_actions_node_checksum_data/pgdata
[18:47:40.565](0.003s) ok 11 - checksums disabled in control file: exit code 0
[18:47:40.566](0.000s) ok 12 - checksums disabled in control file: no stderr
[18:47:40.566](0.000s) ok 13 - checksums disabled in control file: matches
# Running: pg_checksums --enable --no-sync -D /tmp/cirrus-ci-build/build/testrun/pg_checksums/002_actions/data/t_002_actions_node_checksum_data/pgdata
pg_checksums: error: cluster must be shut down
[18:47:40.578](0.012s) not ok 14 - checksums successfully enabled in cluster
[18:47:40.578](0.000s) #   Failed test 'checksums successfully enabled in cluster'
#   at /tmp/cirrus-ci-build/src/bin/pg_checksums/t/002_actions.pl line 155.
# Running: pg_controldata /tmp/cirrus-ci-build/build/testrun/pg_checksums/002_actions/data/t_002_actions_node_checksum_data/pgdata
[18:47:40.581](0.003s) ok 15 - checksums enabled in control file: exit code 0
[18:47:40.581](0.000s) ok 16 - checksums enabled in control file: no stderr
[18:47:40.581](0.000s) not ok 17 - checksums enabled in control file: matches
[18:47:40.582](0.000s) #   Failed test 'checksums enabled in control file: matches'
#   at /tmp/cirrus-ci-build/src/bin/pg_checksums/t/002_actions.pl line 159.
[18:47:40.582](0.000s) #                   'pg_control version number:            1300
# Catalog version number:               202402142
# Database system identifier:           7340355284229055003
# Database cluster state:               in production
# pg_control last modified:             Tue Feb 27 18:47:25 2024
# Latest checkpoint location:           0/10B1BC0
# Latest checkpoint's REDO location:    0/10B1BC0
# Latest checkpoint's REDO WAL file:    000000010000000000000001
# Latest checkpoint's TimeLineID:       1
# Latest checkpoint's PrevTimeLineID:   1
# Latest checkpoint's full_page_writes: on
# Latest checkpoint's NextXID:          0:3
# Latest checkpoint's NextOID:          10115
# Latest checkpoint's NextMultiXactId:  1
# Latest checkpoint's NextMultiOffset:  0
# Latest checkpoint's oldestXID:        3
# Latest checkpoint's oldestXID's DB:   1
# Latest checkpoint's oldestActiveXID:  0
# Latest checkpoint's oldestMultiXid:   1
# Latest checkpoint's oldestMulti's DB: 1
# Latest checkpoint's oldestCommitTsXid:0
# Latest checkpoint's newestCommitTsXid:0
# Time of latest checkpoint:            Tue Feb 27 18:47:25 2024
# Fake LSN counter for unlogged rels:   0/3E8
# Minimum recovery ending location:     0/0
# Min recovery ending loc's timeline:   0
# Backup start location:                0/0
# Backup end location:                  0/0
# End-of-backup record required:        no
# wal_level setting:                    replica
# wal_log_hints setting:                off
# max_connections setting:              100
# max_worker_processes setting:         8
# max_wal_senders setting:              10
# max_prepared_xacts setting:           0
# max_locks_per_xact setting:           64
# track_commit_timestamp setting:       off
# Maximum data alignment:               8
# Database block size:                  8192
# Blocks per segment of large relation: 131072
# WAL block size:                       8192
# Bytes per WAL segment:                16777216
# Maximum length of identifiers:        64
# Maximum columns in an index:          32
# Maximum size of a TOAST chunk:        1996
# Size of a large-object chunk:         2048
# Date/time type storage:               64-bit integers
# Float8 argument passing:              by value
# Data page checksum version:           0
# Mock authentication nonce:            3485ca510088c91f9bc7cab28046af8a849b87e2b68942379ef1a3076ef226a7
# '
#     doesn't match '(?^:Data page checksum version:.*1)'
# Running: pg_checksums --check -D /tmp/cirrus-ci-build/build/testrun/pg_checksums/002_actions/data/t_002_actions_node_checksum_data/pgdata
pg_checksums: error: cluster must be shut down
[18:47:40.594](0.012s) not ok 18 - succeeds with offline cluster
[18:47:40.594](0.000s) #   Failed test 'succeeds with offline cluster'
#   at /tmp/cirrus-ci-build/src/bin/pg_checksums/t/002_actions.pl line 165.
# Running: pg_checksums -D /tmp/cirrus-ci-build/build/testrun/pg_checksums/002_actions/data/t_002_actions_node_checksum_data/pgdata
pg_checksums: error: cluster must be shut down
[18:47:40.606](0.012s) not ok 19 - verifies checksums as default action
[18:47:40.607](0.000s) #   Failed test 'verifies checksums as default action'
#   at /tmp/cirrus-ci-build/src/bin/pg_checksums/t/002_actions.pl line 169.
# Running: pg_checksums --disable --filenode 1234 -D /tmp/cirrus-ci-build/build/testrun/pg_checksums/002_actions/data/t_002_actions_node_checksum_data/pgdata
pg_checksums: error: option -f/--filenode can only be used with --check
pg_checksums: hint: Try "pg_checksums --help" for more information.
[18:47:40.619](0.013s) ok 20 - fails when relfilenodes are requested and action is --disable
# Running: pg_checksums --enable --filenode 1234 -D /tmp/cirrus-ci-build/build/testrun/pg_checksums/002_actions/data/t_002_actions_node_checksum_data/pgdata
pg_checksums: error: option -f/--filenode can only be used with --check
pg_checksums: hint: Try "pg_checksums --help" for more information.
[18:47:40.632](0.012s) ok 21 - fails when relfilenodes are requested and action is --enable
# Running: pg_ctl start -D /tmp/cirrus-ci-build/build/testrun/pg_checksums/002_actions/data/t_002_actions_node_checksum_data/pgdata -s -o -C data_checksums -c log_min_messages=fatal
[18:47:40.747](0.115s) ok 22 - data_checksums=on is reported on an offline cluster status (got 1 vs expected 1)
[18:47:40.747](0.000s) not ok 23 - data_checksums=on is reported on an offline cluster stdout /(?^:^on$)/
[18:47:40.747](0.000s) #   Failed test 'data_checksums=on is reported on an offline cluster stdout /(?^:^on$)/'
#   at /tmp/cirrus-ci-build/src/bin/pg_checksums/t/002_actions.pl line 188.
[18:47:40.748](0.000s) #                   'off
# '
#     doesn't match '(?^:^on$)'
[18:47:40.748](0.000s) ok 24 - data_checksums=on is reported on an offline cluster stderr /(?^:could not start server)/
### Starting node "node_checksum"
# Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/pg_checksums/002_actions/data/t_002_actions_node_checksum_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/pg_checksums/002_actions/log/002_actions_node_checksum.log -o --cluster-name=node_checksum start
waiting for server to start.... done
server started
# Postmaster PID for node "node_checksum" is 25313
# Running: pg_checksums --check -D /tmp/cirrus-ci-build/build/testrun/pg_checksums/002_actions/data/t_002_actions_node_checksum_data/pgdata
pg_checksums: error: cluster must be shut down
[18:47:40.874](0.126s) ok 25 - fails with online cluster
connection error: 'psql: error: connection to server on socket "/tmp/6o04M_oH89/.s.PGSQL.51932" failed: FATAL:  database "postgres" does not exist'
while running 'psql -XAtq -d port=51932 host=/tmp/6o04M_oH89 dbname='postgres' -f - -v ON_ERROR_STOP=1' at /tmp/cirrus-ci-build/src/test/perl/PostgreSQL/Test/Cluster.pm line 2043.
# Postmaster PID for node "node_checksum" is 25313
### Stopping node "node_checksum" using mode immediate
# Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/pg_checksums/002_actions/data/t_002_actions_node_checksum_data/pgdata -m immediate stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "node_checksum"
[18:47:40.988](0.114s) # Tests were run but no plan was declared and done_testing() was not seen.
[18:47:40.988](0.000s) # Looks like your test exited with 29 just after 25.