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 1gIFOM-0001GS-P2 for pgsql-general@arkaria.postgresql.org; Thu, 01 Nov 2018 16:00:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gIFOK-0001T5-6q for pgsql-general@arkaria.postgresql.org; Thu, 01 Nov 2018 16:00:16 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gIFOJ-0001Sm-UK for pgsql-general@lists.postgresql.org; Thu, 01 Nov 2018 16:00:15 +0000 Received: from mout.gmx.net ([212.227.15.15]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gIFOH-0003x7-Te for pgsql-general@lists.postgresql.org; Thu, 01 Nov 2018 16:00:15 +0000 Received: from hermes ([84.165.111.43]) by mail.gmx.com (mrgmx002 [212.227.17.190]) with ESMTPSA (Nemesis) id 0M0y47-1fPk5l1YQ3-00v9fr; Thu, 01 Nov 2018 17:00:10 +0100 Received: from hermes ([84.165.111.43]) by mail.gmx.com (mrgmx002 [212.227.17.190]) with ESMTPSA (Nemesis) id 0M0y47-1fPk5l1YQ3-00v9fr; Thu, 01 Nov 2018 17:00:10 +0100 Received: from ncq by hermes with local (Exim 4.91) (envelope-from ) id 1gIFOB-0006Ny-Rf; Thu, 01 Nov 2018 17:00:07 +0100 Date: Thu, 1 Nov 2018 17:00:07 +0100 From: Karsten Hilbert To: Tom Lane Cc: Alvaro Herrera , pgsql-general@lists.postgresql.org Subject: Re: backend crash on DELETE, reproducible locally Message-ID: <20181101160007.GJ2954@hermes.hilbert.loc> References: <20181101152723.zq2dtcgntmcmr4br@alvherre.pgsql> <18072.1541087036@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <18072.1541087036@sss.pgh.pa.us> 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:civ2kuetk/wX+Cva9hUrE1Gn/2fhLxpTDGdGSRgeHUDOKQtOE3u /Ms+tiSgC0onln5RN2yDk46RXe3JS8X6U6FeAD7Cm9VzrTADOVft0Tlp559Icsip63BJgHh DcwaKckJxkthPX7qqLs/brX6PsCLkpiNa12hV+4d7jIK3v6rvInw8dsG/0jG1uMfJ0z4sr+ qRYtEY6bFVcPJEUv9oprA== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V01:K0:oUQhE82eotQ=:73m6zbsrnCC+CraVV140Q8 yN7J+Ia8Y9Ai3KX8rm4+YJgIqXMAp5SaD6G9jKKpRRq9tKKJvvCSYUZcXTmB4NOPeZ+8C4et3 k8+FZKy4cKrMPl9r12T6Y2ZQNjlsgz+Rw3ry2bO9Iz9YIgGlUf7Uf+QFdkKv2wJhxUPB9oOHJ //qLcLFOZfmVE7OUQRUZnM3jEopn5OdnrR8KOxqEoaALhT4RU1vim9J8Qu5tGmCxDAS/YtfO2 cQYqLNq+m1giuVOpCBUuuieLUCBp28CyUPNlqojscJb6oshFteryXF26DqxfRg7u89EPQ4bQa pRn3IokdxnGTWWA0wUhApOGcwyuyTGZDo/6k1Q41Kn5qc1R8QBUTZndL/KyRzBdUoge40kPQ8 ABaei+Ec6bojigg0/mrW74il1mZF9HzAqt4AnMw/w43KCHC+sz9bMQTp9hw8X6ln4UzTD98Cq JO+T0UqhOGjrbd+xLUBNIkdIIrsqpzjb/seWzplchhx1TxqLmN8oMILAJA4YAjGTe5xwXUOLu AFIxv6jtzaAduNAxgOapQOlNQHhj2A6D/bgfX+s1edmtFGexgSdqaAgYRqY36Q1Uoe7GrEFiY h5k6PaLUyJaz7xPyLQH9jDLQG0MXF47TDYVoSoHKvjifMSKzF2nF1hrDIWyx+lIp1z++h3hSv l3FqgSzwKmbIVspO7Oqi6a01bURGxZwjMcFi68THWLYxs/Ih/3JovzNgLXKp97YAYO91p8N6L LjOL3joW1SY6DCWzb02soZmls1Ph0951GCoPHPDd03elbkuNd3kQ0eB2F8KTjqy9kVUWoS67Z qINjnGl9YWPVNpfl9ww+aP86qESdA== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Thu, Nov 01, 2018 at 11:43:56AM -0400, Tom Lane wrote: > Alvaro Herrera writes: > > 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. > > Yeah, apparently we've passed a null OLD tuple to an RI_FKey_cascade_del > trigger, which surely shouldn't happen. It'd be interesting to look at > the set of triggers on this table. I don't entirely trust psql's \d > to show us reality if there's something screwed up about the triggers, > so in addition to \d output, could we see > > select * from pg_trigger where tgrelid = 'ref.auto_hint'::regclass; Ausgabeformat ist »wrapped«. tgrelid | tgname | tgfoid | tgtype | tgenabled | tgisinternal | tgconstrrelid | tgconstrindid | tgconstraint | tgdeferrable | tginitdeferred | tgnargs | tgattr | tgargs | tgqual | tgoldtable | tgnewtable ---------+-------------------------------+--------+--------+-----------+--------------+---------------+---------------+--------------+--------------+----------------+---------+--------+--------+--------+------------+------------ 111088 | RI_ConstraintTrigger_a_116970 | 1646 | 9 | O | t | 116789 | 111099 | 116969 | f | f | 0 | | \x | | | 111088 | RI_ConstraintTrigger_a_116971 | 1649 | 17 | O | t | 116789 | 111099 | 116969 | f | f | 0 | | \x | | | 111088 | zt_ins_auto_hint | 141652 | 7 | O | f | 0 | 0 | 0 | f | f | 0 | | \x | | | 111088 | zt_upd_auto_hint | 141654 | 19 | O | f | 0 | 0 | 0 | f | f | 0 | | \x | | | 111088 | zt_del_auto_hint | 141656 | 11 | O | f | 0 | 0 | 0 | f | f | 0 | | \x | | | (5 Zeilen) BTW, do you want me to attach text files or include into the body (potential wrapping issues on display) ? Thanks, Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B