Postgres Pro
Downloads
Home   >   mailing lists

Re: Pg 15 devel crashes when fetching data from table using cursor - Mailing list pgsql-bugs

From Andres Freund
Subject Re: Pg 15 devel crashes when fetching data from table using cursor
Date
Msg-id 20220311005045.vnwb3aa5htilh3rh@alap3.anarazel.de
Whole thread Raw
In response to Pg 15 devel crashes when fetching data from table using cursor  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses 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>)
List pgsql-bugs
Tree view 
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #17409: Unable to alter data type of clustered column which is referenced by foreign key
Next
From: Peter Geoghegan
Date:
Subject: Re: Pg 15 devel crashes when fetching data from table using cursor