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

Log in to 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 2 weeks. Failing since 2 weeks.
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 (1 month ago)
Latest email 2026-10-24 15:36:05 (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) Log in to 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-24 15:36:05 by Rui Zhao <zhaorui126 at gmail.com>
Latest attachment (nocfbot-0001-Fix-handling-of-skipped-prior-versions-during-heap-r.patch) at 2026-10-24 15:36:05 from Rui Zhao <zhaorui126 at gmail.com>
    Attachment (nocfbot-0001-Fix-handling-of-skipped-prior-versions-during-heap-r.patch) at 2026-10-24 15:36:05 from Rui Zhao <zhaorui126 at gmail.com> (Patch: No)
    Attachment (nocfbot-v7-review-fixes.txt) at 2026-10-24 04:41:55 from shihao zhong <zhong950419 at gmail.com> (Patch: Yes)
    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
Log in to edit