Re: BUG #19519: REPACK can fail due to missing chunk for toast value
От
Imran Zaheer
Тема
Re: BUG #19519: REPACK can fail due to missing chunk for toast value
Дата
Msg-id
CA+UBfa=r2yE7swa_xX9X0y4uq0wury5_AAHr_yHvG3A+9mKzcA@mail.gmail.com
Ответ на
Re: BUG #19519: REPACK can fail due to missing chunk for toast value (Heikki Linnakangas)
Список
Дерево обсуждения
BUG #19519: REPACK can fail due to missing chunk for toast value PG Bug reporting form <noreply@postgresql.org>
Re: BUG #19519: REPACK can fail due to missing chunk for toast value Srinath Reddy Sadipiralla <srinath2133@gmail.com>
Re: BUG #19519: REPACK can fail due to missing chunk for toast value Imran Zaheer <imran.zhir@gmail.com>
Hi.
@@ -934,10 +953,17 @@ heapam_relation_copy_for_cluster(Relation
OldHeap, Relation NewHeap,
- reform_and_rewrite_tuple(tuple,
- OldHeap, NewHeap,
- values, isnull,
- rwstate);
+ {
+ if (!reform_and_rewrite_tuple(tuple,
+ OldHeap, NewHeap,
+ values, isnull,
+ rwstate, true))
+ {
+ /* TOAST gone for a recently dead tuple */
+ n_tuples -= 1;
+ continue;
+ }
+ }
The tuplesort_getheaptuple() will contain both live and recently
deleted tuples. However, the proposed fix passes missing_ok=true for
all tuples coming out of the sort, which means a toast fetch failure
for a LIVE tuple would be acceptable and will be silently skipped. Or
am I missing something?
Thanks
Imran Zaheer
В списке pgsql-bugs по дате отправления
От: Heikki Linnakangas
Дата:
От: Peter Eisentraut
Дата: