Re: Pg 15 devel crashes when fetching data from table using cursor

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Pg 15 devel crashes when fetching data from table using cursor
Дата
Msg-id 20220311005045.vnwb3aa5htilh3rh@alap3.anarazel.de
обсуждение исходный текст
Ответ на Pg 15 devel crashes when fetching data from table using cursor  (hubert depesz lubaczewski <depesz@depesz.com>)
Ответы Re: Pg 15 devel crashes when fetching data from table using cursor  (Peter Geoghegan <pg@bowt.ie>)
Re: Pg 15 devel crashes when fetching data from table using cursor  (Andres Freund <andres@anarazel.de>)
Список pgsql-bugs
Hi,

On 2022-03-07 10:44:23 +0100, hubert depesz lubaczewski wrote:
> I ran 15devel, compiled today, on Ryzen processor (amd64), with data for
> explain.depesz.com.

> TRAP: FailedAssertion("HaveRegisteredOrActiveSnapshot()", File: "toast_internals.c", Line: 670, PID: 526595)
> postgres: depesz_explain depesz_explain [local] FETCH(ExceptionalCondition+0x99)[0x557da5491dc9]
> postgres: depesz_explain depesz_explain [local] FETCH(+0x174f64)[0x557da5010f64]
> postgres: depesz_explain depesz_explain [local] FETCH(heap_fetch_toast_slice+0x15f)[0x557da50606cf]

That's a new assertion, but I put it in to detect bugs like what's fixed in
7c38ef2a5d6cf6d8dc3834399d7a1c364d64ce64. Looks like something in the snapshot
mangement of cursors is busted...

Any chance you could try to come up with a reproducer?

Greetings,

Andres Freund



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #17409: Unable to alter data type of clustered column which is referenced by foreign key
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Pg 15 devel crashes when fetching data from table using cursor