# Checking port 57197 # Found port 57197 Name: node_checksum Data directory: C:\cirrus\build/testrun/pg_checksums/002_actions\data/t_002_actions_node_checksum_data/pgdata Backup directory: C:\cirrus\build/testrun/pg_checksums/002_actions\data/t_002_actions_node_checksum_data/backup Archive directory: C:\cirrus\build/testrun/pg_checksums/002_actions\data/t_002_actions_node_checksum_data/archives Connection string: port=57197 host=C:/Windows/TEMP/QzpB4AkE2E Log file: C:\cirrus\build/testrun/pg_checksums/002_actions\log/002_actions_node_checksum.log [02:39:55.748](0.199s) # initializing database system by copying initdb template # Running: robocopy /E /NJS /NJH /NFL /NDL /NP C:/cirrus/build/tmp_install/initdb-template C:\cirrus\build/testrun/pg_checksums/002_actions\data/t_002_actions_node_checksum_data/pgdata # Running: C:\cirrus\build\src/test\regress\pg_regress.exe --config-auth C:\cirrus\build/testrun/pg_checksums/002_actions\data/t_002_actions_node_checksum_data/pgdata # Running: pg_controldata C:\cirrus\build/testrun/pg_checksums/002_actions\data/t_002_actions_node_checksum_data/pgdata [02:39:57.778](2.030s) ok 1 - checksums disabled in control file: exit code 0 [02:39:57.779](0.000s) ok 2 - checksums disabled in control file: no stderr [02:39:57.779](0.000s) ok 3 - checksums disabled in control file: matches # Running: pg_checksums --enable --no-sync -D C:\cirrus\build/testrun/pg_checksums/002_actions\data/t_002_actions_node_checksum_data/pgdata Checksum operation completed Files scanned: 956 Blocks scanned: 2829 Files written: 780 Blocks written: 2829 pg_checksums: updating control file Checksums enabled in cluster [02:39:58.196](0.417s) ok 4 - checksums successfully enabled in cluster # Running: pg_checksums --enable --no-sync -D C:\cirrus\build/testrun/pg_checksums/002_actions\data/t_002_actions_node_checksum_data/pgdata pg_checksums: error: data checksums are already enabled in cluster [02:39:58.241](0.046s) ok 5 - enabling checksums fails if already enabled # Running: pg_controldata C:\cirrus\build/testrun/pg_checksums/002_actions\data/t_002_actions_node_checksum_data/pgdata [02:39:58.461](0.220s) ok 6 - checksums enabled in control file: exit code 0 [02:39:58.461](0.000s) ok 7 - checksums enabled in control file: no stderr [02:39:58.462](0.000s) ok 8 - checksums enabled in control file: matches # Running: pg_checksums --disable -D C:\cirrus\build/testrun/pg_checksums/002_actions\data/t_002_actions_node_checksum_data/pgdata pg_checksums: syncing data directory pg_checksums: updating control file Checksums disabled in cluster [02:40:02.550](4.089s) ok 9 - checksums successfully disabled in cluster # Running: pg_checksums --disable --no-sync -D C:\cirrus\build/testrun/pg_checksums/002_actions\data/t_002_actions_node_checksum_data/pgdata pg_checksums: error: data checksums are already disabled in cluster [02:40:02.683](0.133s) ok 10 - disabling checksums fails if already disabled # Running: pg_controldata C:\cirrus\build/testrun/pg_checksums/002_actions\data/t_002_actions_node_checksum_data/pgdata [02:40:02.789](0.106s) ok 11 - checksums disabled in control file: exit code 0 [02:40:02.789](0.001s) ok 12 - checksums disabled in control file: no stderr [02:40:02.790](0.000s) ok 13 - checksums disabled in control file: matches # Running: pg_checksums --enable --no-sync -D C:\cirrus\build/testrun/pg_checksums/002_actions\data/t_002_actions_node_checksum_data/pgdata Checksum operation completed Files scanned: 956 Blocks scanned: 2829 Files written: 0 Blocks written: 0 pg_checksums: updating control file Checksums enabled in cluster [02:40:02.975](0.186s) ok 14 - checksums successfully enabled in cluster # Running: pg_controldata C:\cirrus\build/testrun/pg_checksums/002_actions\data/t_002_actions_node_checksum_data/pgdata [02:40:03.049](0.073s) ok 15 - checksums enabled in control file: exit code 0 [02:40:03.049](0.000s) ok 16 - checksums enabled in control file: no stderr [02:40:03.049](0.000s) ok 17 - checksums enabled in control file: matches # Running: pg_checksums --check -D C:\cirrus\build/testrun/pg_checksums/002_actions\data/t_002_actions_node_checksum_data/pgdata Checksum operation completed Files scanned: 956 Blocks scanned: 2829 Bad checksums: 0 Data checksum version: 1 [02:40:03.244](0.195s) ok 18 - succeeds with offline cluster # Running: pg_checksums -D C:\cirrus\build/testrun/pg_checksums/002_actions\data/t_002_actions_node_checksum_data/pgdata Checksum operation completed Files scanned: 956 Blocks scanned: 2829 Bad checksums: 0 Data checksum version: 1 [02:40:04.042](0.797s) ok 19 - verifies checksums as default action # Running: pg_checksums --disable --filenode 1234 -D C:\cirrus\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. [02:40:04.110](0.068s) ok 20 - fails when relfilenodes are requested and action is --disable # Running: pg_checksums --enable --filenode 1234 -D C:\cirrus\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. [02:40:04.186](0.076s) ok 21 - fails when relfilenodes are requested and action is --enable # Running: pg_ctl start -D C:\cirrus\build/testrun/pg_checksums/002_actions\data/t_002_actions_node_checksum_data/pgdata -s -o -C data_checksums -c log_min_messages=fatal [02:40:05.257](1.071s) ok 22 - data_checksums=on is reported on an offline cluster status (got 1 vs expected 1) [02:40:05.259](0.002s) ok 23 - data_checksums=on is reported on an offline cluster stdout /(?^:^on$)/ [02:40:05.262](0.003s) 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 C:\cirrus\build/testrun/pg_checksums/002_actions\data/t_002_actions_node_checksum_data/pgdata -l C:\cirrus\build/testrun/pg_checksums/002_actions\log/002_actions_node_checksum.log -o --cluster-name=node_checksum start waiting for server to start...... stopped waiting pg_ctl: could not start server Examine the log output. # pg_ctl start failed; logfile: 2024-03-31 02:40:05.717 GMT [5932][postmaster] LOG: starting PostgreSQL 17devel on x86_64-windows, compiled by msvc-19.29.30151, 64-bit 2024-03-31 02:40:05.719 GMT [5932][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/QzpB4AkE2E/.s.PGSQL.57197" 2024-03-31 02:40:05.787 GMT [1316][startup] LOG: database system was shut down at 2024-03-31 02:40:02 GMT 2024-03-31 02:40:08.695 GMT [5932][postmaster] LOG: startup process (PID 1316) was terminated by exception 0xC0000354 2024-03-31 02:40:08.695 GMT [5932][postmaster] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2024-03-31 02:40:08.696 GMT [5932][postmaster] LOG: aborting startup due to startup process failure 2024-03-31 02:40:08.700 GMT [5932][postmaster] LOG: database system is shut down # No postmaster PID for node "node_checksum" [02:40:08.808](3.546s) Bail out! pg_ctl start failed # No postmaster PID for node "node_checksum"