# Checking port 49918 # Found port 49918 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=49918 host=/tmp/ZUHeXoTd7p Log file: /tmp/cirrus-ci-build/build/testrun/pg_checksums/002_actions/log/002_actions_node_checksum.log [12:38:00.822](0.018s) # 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 [12:38:01.082](0.261s) ok 1 - checksums disabled in control file: exit code 0 [12:38:01.082](0.000s) ok 2 - checksums disabled in control file: no stderr [12:38:01.083](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 [12:38:01.086](0.003s) not ok 4 - checksums successfully enabled in cluster [12:38:01.086](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 [12:38:01.098](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 [12:38:01.102](0.004s) ok 6 - checksums enabled in control file: exit code 0 [12:38:01.102](0.000s) ok 7 - checksums enabled in control file: no stderr [12:38:01.102](0.000s) not ok 8 - checksums enabled in control file: matches [12:38:01.103](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. [12:38:01.103](0.000s) # 'pg_control version number: 1300 # Catalog version number: 202403191 # Database system identifier: 7348052810791335810 # Database cluster state: in production # pg_control last modified: Tue Mar 19 12:37:45 2024 # Latest checkpoint location: 0/10B1C20 # Latest checkpoint's REDO location: 0/10B1C20 # 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 Mar 19 12:37:45 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: 7611606214ba2f1d74ca87ffbb3dd0238082ce401161e82b549731c6fe78d63f # ' # 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 [12:38:01.115](0.012s) not ok 9 - checksums successfully disabled in cluster [12:38:01.115](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 [12:38:01.131](0.015s) 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 [12:38:01.135](0.004s) ok 11 - checksums disabled in control file: exit code 0 [12:38:01.135](0.000s) ok 12 - checksums disabled in control file: no stderr [12:38:01.135](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 [12:38:01.147](0.012s) not ok 14 - checksums successfully enabled in cluster [12:38:01.147](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 [12:38:01.150](0.002s) ok 15 - checksums enabled in control file: exit code 0 [12:38:01.150](0.000s) ok 16 - checksums enabled in control file: no stderr [12:38:01.150](0.000s) not ok 17 - checksums enabled in control file: matches [12:38:01.150](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. [12:38:01.150](0.000s) # 'pg_control version number: 1300 # Catalog version number: 202403191 # Database system identifier: 7348052810791335810 # Database cluster state: in production # pg_control last modified: Tue Mar 19 12:37:45 2024 # Latest checkpoint location: 0/10B1C20 # Latest checkpoint's REDO location: 0/10B1C20 # 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 Mar 19 12:37:45 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: 7611606214ba2f1d74ca87ffbb3dd0238082ce401161e82b549731c6fe78d63f # ' # 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 [12:38:01.162](0.012s) not ok 18 - succeeds with offline cluster [12:38:01.162](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 [12:38:01.174](0.012s) not ok 19 - verifies checksums as default action [12:38:01.174](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. [12:38:01.186](0.012s) 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. [12:38:01.198](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 [12:38:01.313](0.116s) ok 22 - data_checksums=on is reported on an offline cluster status (got 1 vs expected 1) [12:38:01.314](0.000s) not ok 23 - data_checksums=on is reported on an offline cluster stdout /(?^:^on$)/ [12:38:01.314](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. [12:38:01.314](0.000s) # 'off # ' # doesn't match '(?^:^on$)' [12:38:01.314](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 26783 # 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 [12:38:01.442](0.128s) ok 25 - fails with online cluster connection error: 'psql: error: connection to server on socket "/tmp/ZUHeXoTd7p/.s.PGSQL.49918" failed: FATAL: database "postgres" does not exist' while running 'psql -XAtq -d port=49918 host=/tmp/ZUHeXoTd7p dbname='postgres' -f - -v ON_ERROR_STOP=1' at /tmp/cirrus-ci-build/src/test/perl/PostgreSQL/Test/Cluster.pm line 2040. # Postmaster PID for node "node_checksum" is 26783 ### 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" [12:38:01.557](0.115s) # Tests were run but no plan was declared and done_testing() was not seen. [12:38:01.557](0.000s) # Looks like your test exited with 29 just after 25.