Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gIFGL-0000rq-G0 for pgsql-general@arkaria.postgresql.org; Thu, 01 Nov 2018 15:52:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gIFGJ-0003L8-4g for pgsql-general@arkaria.postgresql.org; Thu, 01 Nov 2018 15:51:59 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gIFGI-0003L0-PT for pgsql-general@lists.postgresql.org; Thu, 01 Nov 2018 15:51:58 +0000 Received: from mout.gmx.net ([212.227.15.18]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gIFGF-0001Vo-Tc for pgsql-general@lists.postgresql.org; Thu, 01 Nov 2018 15:51:57 +0000 Received: from hermes ([84.165.111.43]) by mail.gmx.com (mrgmx003 [212.227.17.190]) with ESMTPSA (Nemesis) id 0MRFwV-1g7ZNJ3meN-00UebH for ; Thu, 01 Nov 2018 16:51:51 +0100 Received: from hermes ([84.165.111.43]) by mail.gmx.com (mrgmx003 [212.227.17.190]) with ESMTPSA (Nemesis) id 0MRFwV-1g7ZNJ3meN-00UebH for ; Thu, 01 Nov 2018 16:51:51 +0100 Received: from ncq by hermes with local (Exim 4.91) (envelope-from ) id 1gIFG9-0006JV-T1 for pgsql-general@lists.postgresql.org; Thu, 01 Nov 2018 16:51:49 +0100 Date: Thu, 1 Nov 2018 16:51:49 +0100 From: Karsten Hilbert To: pgsql-general@lists.postgresql.org Subject: Re: backend crash on DELETE, reproducible locally Message-ID: <20181101155149.GI2954@hermes.hilbert.loc> References: <20181101152115.GF2954@hermes.hilbert.loc> <20181101152723.zq2dtcgntmcmr4br@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20181101152723.zq2dtcgntmcmr4br@alvherre.pgsql> Ma_X_il-Followup-to: d Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri_X_ority: 2 (High) User-Agent: Mutt/1.10.1 (2018-07-13) Sender: X-Provags-ID: V03:K1:KpRFci0nfbxjWw0wqz2iiVIiXYkKT17gSytWi4ba/Ize36FluGm eSQyB+cKyksPi+HGStjgXPWOqFp/kAYeMXJKBdIDRGnG5cTt9yw47P4qu1x0MGaTfpXw3Xm ycGeBE9QxhcvNx8HWph3R7XJuku6pOjEYLy8Uu7TpstSo1vi2+ekwHnaai8qBISlWnLGPWG EpbqZaaOhiTMdlKj66LPw== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V01:K0:oysiTtXcMAI=:X5HpFTY4HqTH8wMcvpalOa nAIg5JvSpj0gEgSzN2M5KjVVCinnUbd2BSRlIlQJXVclu9i4EHScS+Uj++9wYg0bfR8SWTh2q XVLV6GQez//9Tha7sfnkrwKpReF76ZNJ2jnoFK+CClOcbSPzRuMvRp+tel+jmges90JLOa/Cm 8XZwEJ4kNUj1/hki/z2zXneeSNG7eeQHB5Dr+/9eWBrMt8xadhj77T8t8L3064BzBuD16QDaA 5VKzrkwugTqqIdQKdYBkwEjO9EZM+ZgLuwwBtfU7TpX1XGz1cKnG5yoquLP3XIHMTQfUNwknB MgEw1nfHTjBpyhKGtygAsZBKCUHzHyWJSRb3ZvbLFoRWK+bZx4N68DjSHhjMT8EWTJFa+Y8nN d8us8RfvffhV1DeobqNFslF+5GulNqYAkMoJxMQGr9VS1kufEF3W1u2+g/7zVM/fpQgICzfaW 6hm+bolYT9hMRP6pyqNiecnftxYuhYGgf8cnWevdIdAS3NL9X3ojcPHof3g07PNtQpVlocbH/ gP1E3nzTAvGVjj3vtLhHyA/vpE091bPqO4T3Q7Kow/cY8uslyCKkfyPtCsOLp4kWtZD92jngb lI1xRmhhQnN005nwSGPkAYL9xgVNCKSe3WHqw95XwhkaMMhPGjbFCs0wEhbhDs0sXD2rEZVMe ms6M9YEc+PKVmLbw4QDtF9nR9wUDosbgPzVzVjSfMG0GxX/0oX9Ofhz09IXVI4bjs3f96qPb6 K7dtCjYrK6EB8R+YqS80A2bYgkWvs4cLbZHRdkKOW5NIhmJawaqzFmMlgO44mt/izxMfGTIzO vwP4UDTf4xvGJ9FoQnrQhevisIz8KMoqdCMyealGok2eleahe4GR7NZImKz1WaTGWRis02G46 00GjJESKe/4ZVYq0f+nxJow6ihoXNDot8Fzwf+1wtvaA69/FD5fCtwAFHb8fvh List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Thu, Nov 01, 2018 at 12:27:23PM -0300, Alvaro Herrera 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 > > Can you 'print trigdata' in frame 2? Does this help at all ? (gdb) frame 2 #2 0x00879bf7 in RI_FKey_cascade_del (fcinfo=0xbfbda9e4) at ./build/../src/backend/utils/adt/ri_triggers.c:917 917 ./build/../src/backend/utils/adt/ri_triggers.c: Datei oder Verzeichnis nicht gefunden. (gdb) print trigdata $1 = (TriggerData *) 0xbfbdaca4 It is from another run, however. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B