pg.ddx.io pgsql-general@postgresql.org mailing list archive help / color / mirror / Atom feed From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
To: pgsql-general@lists.postgresql.org
Subject: Re: backend crash on DELETE, reproducible locally
Date: Thu, 1 Nov 2018 16:21:15 +0100
Message-ID: <20181101152115.GF2954@hermes.hilbert.loc> (raw )
In-Reply-To: <20181101151133.GE2954@hermes.hilbert.loc >
References: <20181101140216.GA2954@hermes.hilbert.loc >
<20181101144257.GD2954@hermes.hilbert.loc >
<20181101151133.GE2954@hermes.hilbert.loc >
On Thu, Nov 01, 2018 at 04:11:33PM +0100, Karsten Hilbert wrote:
>> Will attempt to get a stack trace ...
Eventually, the stack trace (attached).
Thanks for insights,
Karsten
--
GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B
Script started on 2018-11-01 16:16:02+01:00
root@hermes:~/tmp/pg# gdb --pid=22367 --readnow
GNU gdb (Debian 8.1-4+b1) 8.1
Copyright (C) 2018 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html ;
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law. Type "show copying"
and "show warranty" for details.
This GDB was configured as "i686-linux-gnu".
Type "show configuration" for configuration details.
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/ ;.
Find the GDB manual and other documentation resources online at:
<http://www.gnu.org/software/gdb/documentation/ ;.
For help, type "help".
Type "apropos word" to search for commands related to "word".
Attaching to process 22367
Reading symbols from /usr/lib/postgresql/11/bin/postgres...Reading symbols from /usr/lib/debug/.build-id/c0/e1914ba590a236d6ee6e9ccdf7bee87a5c00da.debug...expanding to full symbols...done.
expanding to full symbols...done.
Reading symbols from /lib/i386-linux-gnu/libpthread.so.0...Reading symbols from /usr/lib/debug/.build-id/9b/6447528b2fffba536afc815a31304adde16f8b.debug...expanding to full symbols...done.
expanding to full symbols...done.
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/i386-linux-gnu/libthread_db.so.1".
Reading symbols from /usr/lib/i386-linux-gnu/libxml2.so.2...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/libpam.so.0...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libssl.so.1.1...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libcrypto.so.1.1...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libgssapi_krb5.so.2...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/librt.so.1...Reading symbols from /usr/lib/debug/.build-id/d1/de1cfe9b8c85c6195a28a26206906acd9083ff.debug...expanding to full symbols...done.
expanding to full symbols...done.
Reading symbols from /lib/i386-linux-gnu/libdl.so.2...Reading symbols from /usr/lib/debug/.build-id/65/c7a119514fa310ef4bd22bbf97f82b30511805.debug...expanding to full symbols...done.
expanding to full symbols...done.
Reading symbols from /lib/i386-linux-gnu/libm.so.6...Reading symbols from /usr/lib/debug/.build-id/59/1fca8f9efd1964477652a51e7936f88ce15440.debug...expanding to full symbols...done.
expanding to full symbols...done.
Reading symbols from /usr/lib/i386-linux-gnu/libldap_r-2.4.so.2...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libicui18n.so.60...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libicuuc.so.60...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/libsystemd.so.0...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/libc.so.6...Reading symbols from /usr/lib/debug/.build-id/a2/03af6935d5ab00f79fe12b4098d27d3f70c19f.debug...expanding to full symbols...done.
expanding to full symbols...done.
Reading symbols from /lib/ld-linux.so.2...Reading symbols from /usr/lib/debug/.build-id/d3/4d111ccc131067fcbc126906e01374c678c06e.debug...expanding to full symbols...done.
expanding to full symbols...done.
Reading symbols from /usr/lib/i386-linux-gnu/libicudata.so.60...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/libz.so.1...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/liblzma.so.5...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/libaudit.so.1...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libkrb5.so.3...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libk5crypto.so.3...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/libcom_err.so.2...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libkrb5support.so.0...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/libkeyutils.so.1...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/libresolv.so.2...Reading symbols from /usr/lib/debug/.build-id/53/4400247b7b592cfa37bf02c98cf65dc76d3d14.debug...expanding to full symbols...done.
expanding to full symbols...done.
Reading symbols from /usr/lib/i386-linux-gnu/liblber-2.4.so.2...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libsasl2.so.2...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libgnutls.so.30...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libstdc++.so.6...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/libgcc_s.so.1...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/liblz4.so.1...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/libgcrypt.so.20...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/libcap-ng.so.0...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libp11-kit.so.0...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libidn2.so.0...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libunistring.so.2...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libtasn1.so.6...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libnettle.so.6...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libhogweed.so.4...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libgmp.so.10...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/libgpg-error.so.0...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libffi.so.6...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/libnss_files.so.2...Reading symbols from /usr/lib/debug/.build-id/e3/be7847c1c1019f0d31ca1b90db318f686182b0.debug...expanding to full symbols...done.
expanding to full symbols...done.
Reading symbols from /lib/i386-linux-gnu/libnss_compat.so.2...Reading symbols from /usr/lib/debug/.build-id/5e/b631bb92715d369cdfec79616788a8540b36b2.debug...expanding to full symbols...done.
expanding to full symbols...done.
Reading symbols from /lib/i386-linux-gnu/libnss_nis.so.2...Reading symbols from /usr/lib/debug/.build-id/b6/4644711ae11946ba76b305ce1011f669db3bbe.debug...expanding to full symbols...done.
expanding to full symbols...done.
Reading symbols from /lib/i386-linux-gnu/libnsl.so.1...Reading symbols from /usr/lib/debug/.build-id/4f/deb6b2b96dfb1193dc79e1767de187eeef8516.debug...expanding to full symbols...done.
expanding to full symbols...done.
0xb7ed7d39 in __kernel_vsyscall ()
(gdb) cont
Continuing.
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
trigdata = 0xbfbdaca4
riinfo = 0x2e1d548
fk_rel = 0xb299d1dc
pk_rel = 0xb2990ce4
old_row = 0x0
qkey = {constr_id = 3216878436, constr_queryno = 9517408}
qplan = <optimized out>
i = <optimized out>
__func__ = "RI_FKey_cascade_del"
#3 0x0063e8b2 in ExecCallTriggerFunc (trigdata=0xbfbdaca4, tgindx=0, finfo=<optimized out>, instr=0x0, per_tuple_context=0x2df47a0)
at ./build/../src/backend/commands/trigger.c:2412
save_exception_stack = 0xbfbdae30
save_context_stack = 0x0
local_sigjmp_buf = {{__jmpbuf = {13223472, 13223472, 48187296, -1078088540, -692797736, 1781815719}, __mask_was_saved = 0, __saved_mask = {__val = {1, 5546693,
8091757, 47507332, 224, 8091673, 0, 2998600780, 13636800, 7917197, 13223472, 2998600780, 13636800, 47976380, 7925373, 13223472, 1, 3000602368, 1, 0,
179, 13635968, 400453582, 3216878084, 4294967295, 0, 13223472, 13409292, 3216878080, 47976380, 7924806, 3216878187}}}}
fcinfo = {flinfo = 0x2d6724c, context = 0xbfbdaca4, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 0, arg = {5711397, 5647641, 13645520, 1663,
139580, 111088, 0, 5647590, 13223472, 5647682, 111088, 2996375020, 9580697, 9568578, 127858, 128767, 3029502376, 9568556, 2998600820, 47939524, 3000603476,
9569154, 127858, 47939524, 8065977, 13223472, 0, 6, 47613956, 7916444, 2998600816, 5, 47613956, 5236999, 7916359, 13223472, 3000602412, 5236926, 224, 0,
224, 224, 48080752, 1024, 9513769, 13223472, 47507332, 2998600780, 13407688, 9517076, 9517047, 13223472, 224, 7921538, 47507332, 224, 2998600780, 7921519,
5, 111088, 3000603476, 2255720704, 0, 0, 7921485, 224, 47613956, 13223472, 9513769, 13223472, 47507332, 2998600780, 13407688, 9517076, 9517047, 13223472,
224, 7921538, 47507332, 224, 2998600780, 7921519, 13645520, 224, 0, 2255720704, 7, 9565712, 7921485, 13223472, 47609244, 47613956, 47609244, 6749833, 224,
7, 6749305, 13223472, 6749703, 13223472}, argnull = {164, 116, 214, 2, 249, 196, 104, false, 156, 117, 214, 2, true, false, false, false, 156, 117, 214, 2,
240, 23, 206, false, 240, 23, 206, false, false, false, false, false, 117, 25, 13, 183, 201, 178, 144, false, 160, 71, 223, 2, 213, false, false, false,
192, 255, 200, false, 32, 109, 214, 2, 230, 99, 162, false, 92, 175, 189, 191, 155, 175, 189, 49, false, 145, 115, 134, 188, 172, 189, 191, 28, 172, 189,
191, 75, 100, 10, 183, false, 48, 35, 183, 188, 172, 189, 191, 28, 172, 189, 191, 201, 177, 144, false}}
fcusage = {fs = 0x0, save_f_total_time = {tv_sec = -1266824476, tv_nsec = 4097}, save_total = {tv_sec = 10819056, tv_nsec = -2039246592}, f_start = {
tv_sec = 47976380, tv_nsec = 47523260}}
result = <optimized out>
oldContext = 0x2d66d20
__func__ = "ExecCallTriggerFunc"
#4 0x0063ffbc in AfterTriggerExecute (trigdesc=<optimized out>, trigdesc=<optimized out>, trig_tuple_slot2=<optimized out>, trig_tuple_slot1=<optimized out>,
per_tuple_context=<optimized out>, instr=<optimized out>, finfo=<optimized out>, rel=<optimized out>, event=<optimized out>)
at ./build/../src/backend/commands/trigger.c:4354
tgoid = <optimized out>
LocTriggerData = {type = T_TriggerData, tg_event = 5, tg_relation = 0xb2990ce4, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x2d66f7c,
tg_trigtuplebuf = 0, tg_newtuplebuf = 0, tg_oldtable = 0x0, tg_newtable = 0x0}
tuple2 = {t_len = 0, t_self = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 29828}, t_tableOid = 1, t_data = 0x1f}
buffer1 = 0
tgindx = <optimized out>
evtshared = <optimized out>
tuple1 = {t_len = 7035346, t_self = {ip_blkid = {bi_hi = 29860, bi_lo = 726}, ip_posid = 65535}, t_tableOid = 4, t_data = 0x0}
rettuple = <optimized out>
buffer2 = 0
evtshared = <optimized out>
tgoid = <optimized out>
LocTriggerData = <optimized out>
tuple1 = <optimized out>
tuple2 = <optimized out>
rettuple = <optimized out>
buffer1 = <optimized out>
buffer2 = <optimized out>
tgindx = <optimized out>
__func__ = "AfterTriggerExecute"
fdw_tuplestore = <optimized out>
#5 afterTriggerInvokeEvents (events=<optimized out>, firing_id=<optimized out>, estate=<optimized out>, delete_ok=<optimized out>)
at ./build/../src/backend/commands/trigger.c:4545
evtshared = <optimized out>
event = <optimized out>
all_fired_in_chunk = true
all_fired = <optimized out>
chunk = <optimized out>
per_tuple_context = <optimized out>
local_estate = <optimized out>
rel = <optimized out>
trigdesc = <optimized out>
finfo = <optimized out>
instr = <optimized out>
slot1 = <optimized out>
slot2 = <optimized out>
__func__ = "afterTriggerInvokeEvents"
#6 0x00645d58 in AfterTriggerEndQuery (estate=0x2d66dac) at ./build/../src/backend/commands/trigger.c:4855
firing_id = <optimized out>
oldtail = 0x2dda7fc
qs = 0x2db81bc
#7 0x00665c81 in standard_ExecutorFinish (queryDesc=0x2d47f1c) at ./build/../src/backend/executor/execMain.c:439
estate = 0x2d66dac
oldcontext = 0x2d47e90
#8 0x007c39ad in ProcessQuery (plan=<optimized out>, sourceText=<optimized out>, params=0x0, queryEnv=0x0, dest=0x2d5ff7c, completionTag=0xbfbdaf5c "DELETE 1")
at ./build/../src/backend/tcop/pquery.c:205
queryDesc = 0x2d47f1c
#9 0x007c3baf in PortalRunMulti (portal=0x2d96f9c, isTopLevel=true, setHoldSnapshot=false, dest=0x2d5ff7c, altdest=0x2d5ff7c, completionTag=0xbfbdaf5c "DELETE 1")
at ./build/../src/backend/tcop/pquery.c:1286
pstmt = 0x2d60644
active_snapshot_set = true
stmtlist_item = 0x2d606cc
#10 0x007c4784 in PortalRun (portal=0x2d96f9c, count=2147483647, isTopLevel=true, run_once=true, dest=0x2d5ff7c, altdest=0x2d5ff7c, completionTag=0xbfbdaf5c "DELETE 1")
at ./build/../src/backend/tcop/pquery.c:799
save_exception_stack = 0xbfbdb0d0
save_context_stack = 0x0
local_sigjmp_buf = {{__jmpbuf = {13223472, 1, 47804316, 13223472, -692150568, 1432920487}, __mask_was_saved = 0, __saved_mask = {__val = {47228268, 3602472664,
1432431527, 0, 47812524, 11042853, 11042853, 13223472, 9383301, 47812524, 11042853, 2817148525, 13223472, 60, 47804316, 47225216, 9505010, 47225216, 60,
47804316, 9508318, 47812524, 11042853, 9504969, 13223472, 2, 47804316, 47228268, 5047627, 60, 47939500, 0}}}}
result = <optimized out>
nprocessed = <optimized out>
saveTopTransactionResourceOwner = 0x2d78564
saveTopTransactionContext = 0x2db7f20
saveActivePortal = 0x0
saveResourceOwner = 0x2d78564
savePortalContext = 0x0
saveMemoryContext = 0x2db7f20
__func__ = "PortalRun"
#11 0x007bfec9 in exec_simple_query (query_string=0x2d09a0c "DELETE FROM ref.auto_hint WHERE title = 'Kontrai
Attachments:
[text/plain] gdb.log (15.7K, ../20181101152115.GF2954@hermes.hilbert.loc/2-gdb.log)
download | inline:
Script started on 2018-11-01 16:16:02+01:00
root@hermes:~/tmp/pg# gdb --pid=22367 --readnow
GNU gdb (Debian 8.1-4+b1) 8.1
Copyright (C) 2018 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law. Type "show copying"
and "show warranty" for details.
This GDB was configured as "i686-linux-gnu".
Type "show configuration" for configuration details.
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>.
Find the GDB manual and other documentation resources online at:
<http://www.gnu.org/software/gdb/documentation/>.
For help, type "help".
Type "apropos word" to search for commands related to "word".
Attaching to process 22367
Reading symbols from /usr/lib/postgresql/11/bin/postgres...Reading symbols from /usr/lib/debug/.build-id/c0/e1914ba590a236d6ee6e9ccdf7bee87a5c00da.debug...expanding to full symbols...done.
expanding to full symbols...done.
Reading symbols from /lib/i386-linux-gnu/libpthread.so.0...Reading symbols from /usr/lib/debug/.build-id/9b/6447528b2fffba536afc815a31304adde16f8b.debug...expanding to full symbols...done.
expanding to full symbols...done.
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/i386-linux-gnu/libthread_db.so.1".
Reading symbols from /usr/lib/i386-linux-gnu/libxml2.so.2...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/libpam.so.0...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libssl.so.1.1...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libcrypto.so.1.1...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libgssapi_krb5.so.2...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/librt.so.1...Reading symbols from /usr/lib/debug/.build-id/d1/de1cfe9b8c85c6195a28a26206906acd9083ff.debug...expanding to full symbols...done.
expanding to full symbols...done.
Reading symbols from /lib/i386-linux-gnu/libdl.so.2...Reading symbols from /usr/lib/debug/.build-id/65/c7a119514fa310ef4bd22bbf97f82b30511805.debug...expanding to full symbols...done.
expanding to full symbols...done.
Reading symbols from /lib/i386-linux-gnu/libm.so.6...Reading symbols from /usr/lib/debug/.build-id/59/1fca8f9efd1964477652a51e7936f88ce15440.debug...expanding to full symbols...done.
expanding to full symbols...done.
Reading symbols from /usr/lib/i386-linux-gnu/libldap_r-2.4.so.2...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libicui18n.so.60...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libicuuc.so.60...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/libsystemd.so.0...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/libc.so.6...Reading symbols from /usr/lib/debug/.build-id/a2/03af6935d5ab00f79fe12b4098d27d3f70c19f.debug...expanding to full symbols...done.
expanding to full symbols...done.
Reading symbols from /lib/ld-linux.so.2...Reading symbols from /usr/lib/debug/.build-id/d3/4d111ccc131067fcbc126906e01374c678c06e.debug...expanding to full symbols...done.
expanding to full symbols...done.
Reading symbols from /usr/lib/i386-linux-gnu/libicudata.so.60...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/libz.so.1...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/liblzma.so.5...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/libaudit.so.1...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libkrb5.so.3...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libk5crypto.so.3...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/libcom_err.so.2...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libkrb5support.so.0...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/libkeyutils.so.1...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/libresolv.so.2...Reading symbols from /usr/lib/debug/.build-id/53/4400247b7b592cfa37bf02c98cf65dc76d3d14.debug...expanding to full symbols...done.
expanding to full symbols...done.
Reading symbols from /usr/lib/i386-linux-gnu/liblber-2.4.so.2...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libsasl2.so.2...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libgnutls.so.30...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libstdc++.so.6...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/libgcc_s.so.1...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/liblz4.so.1...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/libgcrypt.so.20...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/libcap-ng.so.0...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libp11-kit.so.0...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libidn2.so.0...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libunistring.so.2...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libtasn1.so.6...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libnettle.so.6...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libhogweed.so.4...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libgmp.so.10...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/libgpg-error.so.0...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /usr/lib/i386-linux-gnu/libffi.so.6...expanding to full symbols...(no debugging symbols found)...done.
Reading symbols from /lib/i386-linux-gnu/libnss_files.so.2...Reading symbols from /usr/lib/debug/.build-id/e3/be7847c1c1019f0d31ca1b90db318f686182b0.debug...expanding to full symbols...done.
expanding to full symbols...done.
Reading symbols from /lib/i386-linux-gnu/libnss_compat.so.2...Reading symbols from /usr/lib/debug/.build-id/5e/b631bb92715d369cdfec79616788a8540b36b2.debug...expanding to full symbols...done.
expanding to full symbols...done.
Reading symbols from /lib/i386-linux-gnu/libnss_nis.so.2...Reading symbols from /usr/lib/debug/.build-id/b6/4644711ae11946ba76b305ce1011f669db3bbe.debug...expanding to full symbols...done.
expanding to full symbols...done.
Reading symbols from /lib/i386-linux-gnu/libnsl.so.1...Reading symbols from /usr/lib/debug/.build-id/4f/deb6b2b96dfb1193dc79e1767de187eeef8516.debug...expanding to full symbols...done.
expanding to full symbols...done.
0xb7ed7d39 in __kernel_vsyscall ()
(gdb) cont
Continuing.
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
trigdata = 0xbfbdaca4
riinfo = 0x2e1d548
fk_rel = 0xb299d1dc
pk_rel = 0xb2990ce4
old_row = 0x0
qkey = {constr_id = 3216878436, constr_queryno = 9517408}
qplan = <optimized out>
i = <optimized out>
__func__ = "RI_FKey_cascade_del"
#3 0x0063e8b2 in ExecCallTriggerFunc (trigdata=0xbfbdaca4, tgindx=0, finfo=<optimized out>, instr=0x0, per_tuple_context=0x2df47a0)
at ./build/../src/backend/commands/trigger.c:2412
save_exception_stack = 0xbfbdae30
save_context_stack = 0x0
local_sigjmp_buf = {{__jmpbuf = {13223472, 13223472, 48187296, -1078088540, -692797736, 1781815719}, __mask_was_saved = 0, __saved_mask = {__val = {1, 5546693,
8091757, 47507332, 224, 8091673, 0, 2998600780, 13636800, 7917197, 13223472, 2998600780, 13636800, 47976380, 7925373, 13223472, 1, 3000602368, 1, 0,
179, 13635968, 400453582, 3216878084, 4294967295, 0, 13223472, 13409292, 3216878080, 47976380, 7924806, 3216878187}}}}
fcinfo = {flinfo = 0x2d6724c, context = 0xbfbdaca4, resultinfo = 0x0, fncollation = 0, isnull = false, nargs = 0, arg = {5711397, 5647641, 13645520, 1663,
139580, 111088, 0, 5647590, 13223472, 5647682, 111088, 2996375020, 9580697, 9568578, 127858, 128767, 3029502376, 9568556, 2998600820, 47939524, 3000603476,
9569154, 127858, 47939524, 8065977, 13223472, 0, 6, 47613956, 7916444, 2998600816, 5, 47613956, 5236999, 7916359, 13223472, 3000602412, 5236926, 224, 0,
224, 224, 48080752, 1024, 9513769, 13223472, 47507332, 2998600780, 13407688, 9517076, 9517047, 13223472, 224, 7921538, 47507332, 224, 2998600780, 7921519,
5, 111088, 3000603476, 2255720704, 0, 0, 7921485, 224, 47613956, 13223472, 9513769, 13223472, 47507332, 2998600780, 13407688, 9517076, 9517047, 13223472,
224, 7921538, 47507332, 224, 2998600780, 7921519, 13645520, 224, 0, 2255720704, 7, 9565712, 7921485, 13223472, 47609244, 47613956, 47609244, 6749833, 224,
7, 6749305, 13223472, 6749703, 13223472}, argnull = {164, 116, 214, 2, 249, 196, 104, false, 156, 117, 214, 2, true, false, false, false, 156, 117, 214, 2,
240, 23, 206, false, 240, 23, 206, false, false, false, false, false, 117, 25, 13, 183, 201, 178, 144, false, 160, 71, 223, 2, 213, false, false, false,
192, 255, 200, false, 32, 109, 214, 2, 230, 99, 162, false, 92, 175, 189, 191, 155, 175, 189, 49, false, 145, 115, 134, 188, 172, 189, 191, 28, 172, 189,
191, 75, 100, 10, 183, false, 48, 35, 183, 188, 172, 189, 191, 28, 172, 189, 191, 201, 177, 144, false}}
fcusage = {fs = 0x0, save_f_total_time = {tv_sec = -1266824476, tv_nsec = 4097}, save_total = {tv_sec = 10819056, tv_nsec = -2039246592}, f_start = {
tv_sec = 47976380, tv_nsec = 47523260}}
result = <optimized out>
oldContext = 0x2d66d20
__func__ = "ExecCallTriggerFunc"
#4 0x0063ffbc in AfterTriggerExecute (trigdesc=<optimized out>, trigdesc=<optimized out>, trig_tuple_slot2=<optimized out>, trig_tuple_slot1=<optimized out>,
per_tuple_context=<optimized out>, instr=<optimized out>, finfo=<optimized out>, rel=<optimized out>, event=<optimized out>)
at ./build/../src/backend/commands/trigger.c:4354
tgoid = <optimized out>
LocTriggerData = {type = T_TriggerData, tg_event = 5, tg_relation = 0xb2990ce4, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x2d66f7c,
tg_trigtuplebuf = 0, tg_newtuplebuf = 0, tg_oldtable = 0x0, tg_newtable = 0x0}
tuple2 = {t_len = 0, t_self = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 29828}, t_tableOid = 1, t_data = 0x1f}
buffer1 = 0
tgindx = <optimized out>
evtshared = <optimized out>
tuple1 = {t_len = 7035346, t_self = {ip_blkid = {bi_hi = 29860, bi_lo = 726}, ip_posid = 65535}, t_tableOid = 4, t_data = 0x0}
rettuple = <optimized out>
buffer2 = 0
evtshared = <optimized out>
tgoid = <optimized out>
LocTriggerData = <optimized out>
tuple1 = <optimized out>
tuple2 = <optimized out>
rettuple = <optimized out>
buffer1 = <optimized out>
buffer2 = <optimized out>
tgindx = <optimized out>
__func__ = "AfterTriggerExecute"
fdw_tuplestore = <optimized out>
#5 afterTriggerInvokeEvents (events=<optimized out>, firing_id=<optimized out>, estate=<optimized out>, delete_ok=<optimized out>)
at ./build/../src/backend/commands/trigger.c:4545
evtshared = <optimized out>
event = <optimized out>
all_fired_in_chunk = true
all_fired = <optimized out>
chunk = <optimized out>
per_tuple_context = <optimized out>
local_estate = <optimized out>
rel = <optimized out>
trigdesc = <optimized out>
finfo = <optimized out>
instr = <optimized out>
slot1 = <optimized out>
slot2 = <optimized out>
__func__ = "afterTriggerInvokeEvents"
#6 0x00645d58 in AfterTriggerEndQuery (estate=0x2d66dac) at ./build/../src/backend/commands/trigger.c:4855
firing_id = <optimized out>
oldtail = 0x2dda7fc
qs = 0x2db81bc
#7 0x00665c81 in standard_ExecutorFinish (queryDesc=0x2d47f1c) at ./build/../src/backend/executor/execMain.c:439
estate = 0x2d66dac
oldcontext = 0x2d47e90
#8 0x007c39ad in ProcessQuery (plan=<optimized out>, sourceText=<optimized out>, params=0x0, queryEnv=0x0, dest=0x2d5ff7c, completionTag=0xbfbdaf5c "DELETE 1")
at ./build/../src/backend/tcop/pquery.c:205
queryDesc = 0x2d47f1c
#9 0x007c3baf in PortalRunMulti (portal=0x2d96f9c, isTopLevel=true, setHoldSnapshot=false, dest=0x2d5ff7c, altdest=0x2d5ff7c, completionTag=0xbfbdaf5c "DELETE 1")
at ./build/../src/backend/tcop/pquery.c:1286
pstmt = 0x2d60644
active_snapshot_set = true
stmtlist_item = 0x2d606cc
#10 0x007c4784 in PortalRun (portal=0x2d96f9c, count=2147483647, isTopLevel=true, run_once=true, dest=0x2d5ff7c, altdest=0x2d5ff7c, completionTag=0xbfbdaf5c "DELETE 1")
at ./build/../src/backend/tcop/pquery.c:799
save_exception_stack = 0xbfbdb0d0
save_context_stack = 0x0
local_sigjmp_buf = {{__jmpbuf = {13223472, 1, 47804316, 13223472, -692150568, 1432920487}, __mask_was_saved = 0, __saved_mask = {__val = {47228268, 3602472664,
1432431527, 0, 47812524, 11042853, 11042853, 13223472, 9383301, 47812524, 11042853, 2817148525, 13223472, 60, 47804316, 47225216, 9505010, 47225216, 60,
47804316, 9508318, 47812524, 11042853, 9504969, 13223472, 2, 47804316, 47228268, 5047627, 60, 47939500, 0}}}}
result = <optimized out>
nprocessed = <optimized out>
saveTopTransactionResourceOwner = 0x2d78564
saveTopTransactionContext = 0x2db7f20
saveActivePortal = 0x0
saveResourceOwner = 0x2d78564
savePortalContext = 0x0
saveMemoryContext = 0x2db7f20
__func__ = "PortalRun"
#11 0x007bfec9 in exec_simple_query (query_string=0x2d09a0c "DELETE FROM ref.auto_hint WHERE title = 'Kontrai
view thread (38+ messages) latest in thread
Message-ID: <20181101152115.GF2954@hermes.hilbert.loc>
Permalink: ../20181101152115.GF2954@hermes.hilbert.loc/
Also on: postgresql.org/message-id/20181101152115.GF2954@hermes.hilbert.loc
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: Karsten.Hilbert@gmx.net, pgsql-general@lists.postgresql.org
Subject: Re: backend crash on DELETE, reproducible locally
In-Reply-To: <20181101152115.GF2954@hermes.hilbert.loc>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox