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

From: Andres Freund <andres(at)anarazel(dot)de>
To: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
Cc: PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Pg 15 devel crashes when fetching data from table using cursor
Date: 2022-03-11 00:50:45
Message-ID: 20220311005045.vnwb3aa5htilh3rh@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Geoghegan 2022-03-11 01:38:10 Re: Pg 15 devel crashes when fetching data from table using cursor
Previous Message Tom Lane 2022-03-11 00:37:45 Re: BUG #17409: Unable to alter data type of clustered column which is referenced by foreign key