| From: | Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | datachecksums: handle invalid and dropped databases during enable |
| Date: | 2026-07-28 10:01:43 |
| Message-ID: | CAN4CZFOGdqxtZ5-6gb4apqmvoH=Z+TNH8RKJ3mVtoR1HirKQWg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello
While testing the online enabling of datachecksums, I discovered some
corner cases that can cause the background process to fail:
* Invalid databases were only discovered when we tried to create
checksums for them, when we could instead discover them before
starting and fail early
* Databases dropped while the checksum process was running also
resulted in errors when it reached them and tried to build checksums
for them. In this case we could continue safely: the database was
dropped, there's no need to create checksums for it.
I attached a patch that adds testcases for these and fixes the issues.
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-datachecksums-handle-invalid-and-dropped-databases-d.patch | application/octet-stream | 10.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andy Pogrebnoi | 2026-07-28 10:36:33 | Re: Return pg_control from pg_backup_stop(). |
| Previous Message | Florin Irion | 2026-07-28 09:53:14 | Re: pg_plan_advice: add NO_ scan and join method tags |