Re: backend crash on DELETE, reproducible locally - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: backend crash on DELETE, reproducible locally
Date
Msg-id 20181101152723.zq2dtcgntmcmr4br@alvherre.pgsql
Whole thread Raw
In response to Re: backend crash on DELETE, reproducible locally  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Re: backend crash on DELETE, reproducible locally
Re: backend crash on DELETE, reproducible locally
Re: backend crash on DELETE, reproducible locally
List pgsql-general
On 2018-Nov-01, Karsten Hilbert wrote:

> Program received signal SIGSEGV, Segmentation fault.
> heap_attisnull (tup=0x0, attnum=5, tupleDesc=0xb2990ef4) at ./build/../src/backend/access/common/heaptuple.c:403
> 403    ./build/../src/backend/access/common/heaptuple.c: Datei oder Verzeichnis nicht gefunden.
> (gdb) thread apply all bt full
> 
> Thread 1 (Thread 0xb4c429c0 (LWP 22367)):
> #0  heap_attisnull (tup=0x0, attnum=5, tupleDesc=0xb2990ef4) at ./build/../src/backend/access/common/heaptuple.c:403
>         __func__ = "heap_attisnull"
> #1  0x0087690d in ri_NullCheck (tupDesc=0xb2990ef4, tup=0x0, riinfo=0x2e1d548, rel_is_pk=true) at
./build/../src/backend/utils/adt/ri_triggers.c:2894
>         attnums = 0x2e1d5a4
>         i = 0
>         allnull = true
>         nonenull = true
> #2  0x00879bf7 in RI_FKey_cascade_del (fcinfo=0xbfbda9e4) at ./build/../src/backend/utils/adt/ri_triggers.c:917

Ah, now this is interesting.  Can you please supply the definition of
the table?  I'm wondering if there is a partitioned table with an FK to
this one.  I'm not quite seeing how come 'tup' is NULL there.  Can you
'print trigdata' in frame 2?

In general terms, this bug report would have been more actionable if you
had shown the definition of the tables involved right from the start.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: backend crash on DELETE, reproducible locally
Next
From: Karsten Hilbert
Date:
Subject: Re: backend crash on DELETE, reproducible locally