Test improvements for online checksums
Daniel Gustafsson <dgustafsson@postgresql.org>
Author:
Daniel Gustafsson <dgustafsson@postgresql.org>
Date: 2026-04-30T11:41:43Z
Releases:
19 (unreleased)
Test improvements for online checksums This includes a number of smaller fixups to the online checksums test module which were found during postcommit review and stabilization work. * Fix scope increase for PG_TEST_EXTRA: The online checksums tests have two levels of PG_TEST_EXTRA, checksum and checksums_extended for extra test runs and test runs with increased randomization. The logic for increasing the number of test iterations was however backwards. * Change stopmode for PITR test: The pitr suite used immediate stop mode which caused problems on slower machines where the sigquit would interrupt archive commands leaving partial WAL files behind. This would then prevent restart. Fix by using fast mode which is the appropriate mode for the test at hand. Also increase timeouts to help slower test systems since an expired timeout will incur the same effect as an immediate standby with a partial WAL left behind. This issue was observed when running the test suites on a Raspberry Pi 4 machine. * Improve logging: The test suite for data checksums use a set of helper functions in a Perl module to avoid repeating code, this makes sure that the helper functions do a better job of logging their test output to make debug easier. * Remove unused code: wait_for_cluster_crash was used during the development of online checksums but was never used in any test which shipped, so remove the function. * Standby fixes: Ensure no vacuum on pgbench init on standby with -n to avoid bogus error message in the log, and enable hot_standby_feedback to prevent queries from getting cancelled due to recovery on slower systems. Author: Daniel Gustafsson <daniel@yesql.se> Author: Tomas Vondra <tomas@vondra.me> Reviewed-by: Ayush Tiwari <ayushtiwari.slg01@gmail.com> Reviewed-by: SATYANARAYANA NARLAPURAM <satyanarlapuram@gmail.com> Discussion: https://postgr.es/m/9197F930-DDEB-4CAC-82A2-16FEC715CCE8@yesql.se
Files
| Path | Change | +/− |
|---|---|---|
| src/test/modules/test_checksums/t/007_pgbench_standby.pl | modified | +8 −4 |
| src/test/modules/test_checksums/t/008_pitr.pl | modified | +4 −1 |
| src/test/modules/test_checksums/t/DataChecksums/Utils.pm | modified | +8 −45 |
Discussion
- Changing the state of data checksums in a running cluster 144 messages · 2024-07-03 → 2026-07-02