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 1gIyOV-0008FK-Q9 for pgsql-general@arkaria.postgresql.org; Sat, 03 Nov 2018 16:03:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gIyOU-0005Xv-1A for pgsql-general@arkaria.postgresql.org; Sat, 03 Nov 2018 16:03:26 +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 1gIyOT-0005Xi-Lo for pgsql-general@lists.postgresql.org; Sat, 03 Nov 2018 16:03:25 +0000 Received: from mout.gmx.net ([212.227.15.15]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gIyOQ-0001Kw-79 for pgsql-general@lists.postgresql.org; Sat, 03 Nov 2018 16:03:24 +0000 Received: from hermes ([84.165.101.9]) by mail.gmx.com (mrgmx003 [212.227.17.190]) with ESMTPSA (Nemesis) id 0MYx2x-1g61xP3qJX-00Vj7b; Sat, 03 Nov 2018 17:03:17 +0100 Received: from hermes ([84.165.101.9]) by mail.gmx.com (mrgmx003 [212.227.17.190]) with ESMTPSA (Nemesis) id 0MYx2x-1g61xP3qJX-00Vj7b; Sat, 03 Nov 2018 17:03:17 +0100 Received: from ncq by hermes with local (Exim 4.91) (envelope-from ) id 1gIyOI-0003BQ-4I; Sat, 03 Nov 2018 17:03:14 +0100 Date: Sat, 3 Nov 2018 17:03:14 +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: <20181103160314.GD3885@hermes.hilbert.loc> References: <20181101152723.zq2dtcgntmcmr4br@alvherre.pgsql> <18072.1541087036@sss.pgh.pa.us> <20181101160007.GJ2954@hermes.hilbert.loc> <32192.1541217418@sss.pgh.pa.us> <20181103121419.GA3885@hermes.hilbert.loc> <30594.1541259589@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <30594.1541259589@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:eAE20+u+4GtQeMSXaJLEAQO82e/C46iIbV8JAhmDp2nb473AaKu /hPweTWt8gChQgzjjQrEW0ICa2S1WUlObYn7y+LlmKnTTHX/ndz5aCHL3kTjCEoxrDjCZY5 WCmYM0nAmkYcmM67B2EvtAThZlMBx9Xo8nBniMsd87Gqt/qmZ3k+DHOhTYjeZDcJhmkx48V oc/VzX6QiJX/QTG2FHBnw== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V01:K0:pYZUowBt+Ag=:IxfhVnbYeXR2BsY/fQ5HSb 23YaLLcdkfBXdqPpEswP14pwf0R/mtfW8CB6G1NkslyG2oiDWzMmxmFsGvOP3lT1kAtuvcCI0 40RqAmZdLjBAlI05yqsAaekRdGC6JLka+fR8TSRlFERpsc5f2z0RYgOpXYHww9nLNrFUk9j2U IYKCniNp9gNAmWEXSFi36rG8WYBZrC2bWxWtV8g7OnQq7a21OWFyaQrSIMfUGsNv1L/j8m7UQ f7EX8v9TTvrATT4WN6dgh5cZ1R64xxM9p4w5LDl6wp9R9vkcMFYE01mcOY/AJjRlKO2/CTg0M We1ekGFDUopo10KGh4CXWJMIxF2fwZCtr+LAe/0fszRLzicCLYB+5htPoO/FDDvr4x0dbSsa0 T8fmiHclrE5PTYubZ0ItU4TYzlPNl0aOD6aYxLrzp4O6G328VkAxc/EttwJ9mce2LA3CwANGS /CziouTmzIIB55ETfuAUWpPFa/dQ0ANZVyKTuMLOy+Xvan+09XXtdPBOEFfZ5N81PoYay3xzS PY4WrPr0A8vvF61UQiNynMfPZTke37Rqp3Yp2sqYjjhniV1FuCfBMGoZ3vr3hE5H3bvEogWic UEjKpP/Zi6GopCQkrsSosTMJM9jKjOcGlEYCun1rXD7FiP6ee9iGSlEkeW31L6EkVztqUN6Ki Xolv9yB5NhIHasFTW4epIsu3qtmy7MLLAdIN52uZJ8Yv8wHP2JQ+rGDjSZcoNEkuPdp6koyQf 0VZjj4tMOeuQHdzqKMAoHGhOHA66mQBjymAHWHZw76qIvMbyCkLCtxastr6gOCxrFUzg63QVI b8agWWxzntp7mChOpEyMGxJMKnZog== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Sat, Nov 03, 2018 at 11:39:49AM -0400, Tom Lane wrote: > Karsten Hilbert writes: > > On Fri, Nov 02, 2018 at 11:56:58PM -0400, Tom Lane wrote: > >> I was feeling baffled about this, but it suddenly occurs to me that maybe > >> the bug fixed in 040a1df61/372102b81 explains this. > > > So, I guess I can work around the issue by the above > > manoeuvre and report back once 040a1df61/372102b81 is > > released. > > Anything else you'd want me to look into ? > > Don't suppose you'd want to build a server with 372102b81 applied > and see if it works? Yeah, I feared that answer ;-) However, I lack the skills and the machine(s) to do so ... I will, at any rate, report back when the existing fix is released. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B