Re: SKIP LOCKED assert triggered

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: SKIP LOCKED assert triggered
Дата
Msg-id CANbhV-Ek8nbeyOxGVUgpnj6TFwj8aZDJsQf-8z-FP1Sx3vK6FA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: SKIP LOCKED assert triggered  ("Bossart, Nathan" <bossartn@amazon.com>)
Ответы Re: SKIP LOCKED assert triggered  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-hackers
On Wed, 1 Dec 2021 at 14:33, Bossart, Nathan <bossartn@amazon.com> wrote:
>
> On 11/12/21, 8:56 AM, "Simon Riggs" <simon.riggs@enterprisedb.com> wrote:
> > The combination of these two statements in a transaction hits an
> > Assert in heapam.c at line 4770 on REL_14_STABLE
>
> I've been unable to reproduce this.  Do you have any tips for how to
> do so?  Does there need to be some sort of concurrent workload?

That path is only ever taken when there are multiple sessions, and as
I said, pgbench finds this reliably. I guess I didn't say "use -c 2"

-- 
Simon Riggs                http://www.EnterpriseDB.com/



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

Предыдущее
От: "Bossart, Nathan"
Дата:
Сообщение: Re: SKIP LOCKED assert triggered
Следующее
От: "Bossart, Nathan"
Дата:
Сообщение: O(n) tasks cause lengthy startups and checkpoints