Fix: VACUUM FULL or CREATE INDEX fails with error "missing chunk number 0 for toast value XXX"

Edit
ID 6824
Title Fix: VACUUM FULL or CREATE INDEX fails with error "missing chunk number 0 for toast value XXX"
CI (CFBot) Needs rebase! Needs rebase since 5 days. Failing since 5 days.
Additional links previous successfully applied patch (outdated):
Stats (from CFBot) Unknown
Tags Bugfix
Created 2026-06-01 05:00:45
Last modified 2026-10-02 03:00:12 (2 weeks ago)
Latest email 2026-10-12 10:57:37 (1 week ago)
Status
PG20-3 (2026-11-01 – 2026-11-30): Needs review
PG20-2 (2026-09-01 – 2026-09-30): Moved to different CF
PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF
Target version 20
Authors Michael Paquier (michael-kun), Ekaterina Testova (e.testova)
Reviewers Andrey Borodin (x4m), Matthias van de Meent (mmeent), Rui Zhao (zhaorui) Become reviewer
Committer
Links
Emails
VACUUM FULL or CREATE INDEX fails with error: missing chunk number 0 for toast value XXX
First at 2026-05-18 04:20:55 by Тестова Екатерина <e.testova at postgrespro.ru>
Latest at 2026-07-14 23:45:41 by Michael Paquier <michael at paquier.xyz>
Latest attachment (0001-Add-injection-point-test-for-TOAST-heap-vacuum-horiz.patch) at 2026-07-14 09:45:11 from Andrey Borodin <x4mmm at yandex-team.ru>
    Attachment (0001-Add-injection-point-test-for-TOAST-heap-vacuum-horiz.patch) at 2026-07-14 09:45:11 from Andrey Borodin <x4mmm at yandex-team.ru> (Patch: Yes)
    Attachment (caching_oldest_xmin.patch) at 2026-05-18 04:20:55 from Тестова Екатерина <e.testova at postgrespro.ru> (Patch: Yes)
BUG #19519: REPACK can fail due to missing chunk for toast value
First at 2026-06-14 07:00:01 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2026-10-12 10:57:37 by Matthias van de Meent <boekewurm+postgres at gmail.com>
Latest attachment (v7-0001-Fix-missing-chunk-errors-during-heap-rewrites-and.patch) at 2026-10-12 10:57:37 from Matthias van de Meent <boekewurm+postgres at gmail.com>
    Attachment (v7-0001-Fix-missing-chunk-errors-during-heap-rewrites-and.patch) at 2026-10-12 10:57:37 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: No)
    Attachment (v6-0001-Fix-missing-chunk-errors-during-heap-rewrites-and.patch) at 2026-10-09 12:56:09 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: No)
    Attachment (0001-Write-stashed-update-chain-tuples-with-their-own-TOA.patch) at 2026-08-23 17:12:46 from Rui Zhao <zhaorui126 at gmail.com> (Patch: No)
    Attachment (v5-0002-Various-fixes-and-adjustments.patch) at 2026-07-30 19:54:58 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: No)
    Attachment (repro_sh) at 2026-07-24 11:39:25 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com> (Patch: No)
    Attachment (v4-0001-Fix-missing-chunk-errors-during-heap-rewrites-and.patch) at 2026-07-09 02:47:21 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (v3-0001-Fix-missing-chunk-errors-during-heap-rewrites-and.patch) at 2026-07-08 12:00:33 from Heikki Linnakangas <hlinnaka at iki.fi> (Patch: Yes)
    Attachment (v3-0001-Fix-missing-chunk-errors-during-heap-rewrites-and.patch) at 2026-07-07 05:21:56 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (v2-0001-Fix-missing-chunk-errors-during-heap-rewrites-and.patch) at 2026-07-06 06:36:39 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (v1-0001-Fix-missing-chunk-errors-during-heap-rewrites-by-ign.patch) at 2026-06-17 17:03:21 from Srinath Reddy Sadipiralla <srinath2133 at gmail.com> (Patch: Yes)
History
When Who What
2026-10-17 01:52:29 CFbot Patch needs rebase
2026-10-09 13:05:31 CFbot Patch does not need rebase anymore
2026-10-08 20:28:23 Matthias van de Meent (mmeent) Added mmeent as reviewer
2026-10-02 03:00:12 shihao zhong (zhong950419) Moved from CF PG20-2 to CF PG20-3
2026-08-23 17:14:35 Rui Zhao (zhaorui) Added zhaorui as reviewer
2026-08-07 15:23:07 Andrey Borodin (x4m) Added x4m as reviewer
2026-08-01 00:00:10 CFbot Moved from CF PG20-1 to CF PG20-2
2026-07-29 23:12:27 CFbot Patch needs rebase
2026-07-08 12:10:33 CFbot Patch does not need rebase anymore
2026-07-08 08:09:27 CFbot Patch needs rebase
2026-07-08 01:44:30 CFbot Patch does not need rebase anymore
2026-07-08 01:10:27 CFbot Patch needs rebase
2026-07-07 22:29:31 CFbot Patch does not need rebase anymore
2026-07-07 22:19:39 Michael Paquier (michael-kun) Changed targetversion to 20
2026-07-07 22:19:32 Michael Paquier (michael-kun) Changed authors to Michael Paquier (michael-kun), Ekaterina Testova (e.testova)
2026-07-07 22:19:12 Michael Paquier (michael-kun) Attached mail thread 19519-fe02d8ff679d834d@postgresql.org
2026-06-01 05:02:19 Ekaterina Testova (e.testova) Changed name to Fix: VACUUM FULL or CREATE INDEX fails with error "missing chunk number 0 for toast value XXX"
2026-06-01 05:01:29 CFbot Patch needs rebase
2026-06-01 05:00:45 Ekaterina Testova (e.testova) Attached mail thread 1779078055.630771314@fmail2.qdit
2026-06-01 05:00:45 Ekaterina Testova (e.testova) Created patch record
Edit