Re: PANIC in heap_delete during ALTER TABLE

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: PANIC in heap_delete during ALTER TABLE
Дата
Msg-id 84255ddfad9b98b37fec4d031c4853de344cddea.camel@j-davis.com
обсуждение исходный текст
Ответ на Re: PANIC in heap_delete during ALTER TABLE  (Jeff Davis <pgsql@j-davis.com>)
Ответы Re: PANIC in heap_delete during ALTER TABLE  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-bugs
On Thu, 2022-09-08 at 10:30 -0700, Jeff Davis wrote:
> I wasn't able to repro on 13, but Robins' report indicates that it's
> possible.

I looked again, and I still can't find a way to repro on 13,
specifically the sha1 you mentioned (7cdd0c2d7c).

heap_delete() lets go of its exclusive lock (but not pin) in a couple
places (just like on master). But it looks like all the places that set
PD_ALL_VISIBLE are doing so under a cleanup lock (unlike master), which
means that it can't change for the duration of heap_delete().

I'm hesitant to commit anything here if I can't repro the problem on
13. I must be missing something.

Regards,
    Jeff Davis




В списке pgsql-bugs по дате отправления:

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: huge memory of Postgresql backend process
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: PANIC in heap_delete during ALTER TABLE