Re: postgres crash on concurrent update of inheritance partitionedtable

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: postgres crash on concurrent update of inheritance partitionedtable
Дата
Msg-id 20200203062314.qvu53j4ek4dwutk2@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: postgres crash on concurrent update of inheritance partitioned table  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Hi,

On 2020-01-28 17:29:59 -0500, Tom Lane wrote:
> Tomas Vondra <tomas.vondra@2ndquadrant.com> writes:
> > On Tue, Jan 28, 2020 at 05:17:14PM +0100, Oleksii Kliukin wrote:
> >> We have experienced a few crashes a day since upgrading to pg 12.1 last
> >> week, during the process of updating an inheritance-partitioned table by
> >> several concurrent sessions.
> 
> > Yeah, I can reproduce it too. If I had to guess, I'd say it's another
> > bug due to 
> >      commit 3fb307bc4a76815f96fec28a0d1525ab3fbbcfb4
> >      Author: Andres Freund <andres@anarazel.de>
> >      Date:   Mon Sep 9 05:21:30 2019 -0700
> >      Reorder EPQ work, to fix rowmark related bugs and improve efficiency.
> > which introduced relsubs_done et al, and perhaps did not get the life
> > cycle / resetting right. Not sure.
> 
> Yup, that's it exactly.  EvalPlanQualStart was expecting to reuse
> relsubs_rowmark and relsubs_done, but that storage will be recycled by
> EvalPlanQualEnd because it's in the query context of the recheckestate.
> AFAICS the re-use has no semantic value, so I just got rid of it.

Thanks!

Greetings,

Andres Freund



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

Предыдущее
От: Jack Plasterer
Дата:
Сообщение: Unable to trigger createdb
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: ERROR: subtransaction logged without previous top-level txn record