Collected from the PG bugs email list.
|Reported by||Kanwei Li|
Body of first available message related to this bug follows.
The following bug has been logged on the website: Bug reference: 15489 Logged by: Kanwei Li Email address: (redacted) PostgreSQL version: 11.0 Operating system: Debian 9 Description: We started seeing a segfault crash on our postgresql 11 server instance today when attempting to delete certain rows in the database: 2018-11-06 21:02:07.553 UTC  LOG: server process (PID 66881) was terminated by signal 11: Segmentation fault 2018-11-06 21:02:07.553 UTC  DETAIL: Failed process was running: delete from integration_account where partner_id = 24 Attempting to delete certain rows were causing this segfault, and attempting to delete other rows did not. There didn't seem to be a pattern, and because this was on production we couldn't risk playing around too much. Doing a SELECT on the rows that couldn't be deleted worked fine. There didn't seem to be data corruption since all the data could be read. However, attempting to DELETE certain rows would crash it. pg_dump also worked fine. What fixed it was performing a VACUUM ANALYZE on the database. After that, the deletes worked again. I'm sorry I can no longer list steps to reproduce this, since the VACUUM fixed it, but I figured I should report it in case others have seen it, or if anyone can maybe guess what the problem is.
|2018-11-07 05:01:56+00||=?utf-8?q?PG_Bug_reporting_form?=||BUG #15489: Segfault on DELETE|
|2018-11-07 05:34:12+00||Amit Langote||Re: BUG #15489: Segfault on DELETE|
|2018-11-07 07:14:09+00||Michael Paquier||Re: BUG #15489: Segfault on DELETE|
|2018-11-08 01:10:18+00||=?UTF-8?Q?Frederico_Costa_Galv=c3=a3o?=||Re: Re: BUG #15489: Segfault on DELETE|
|2018-11-08 01:28:43+00||Tom Lane||Re: BUG #15489: Segfault on DELETE|
|2018-11-08 01:33:39+00||Amit Langote||Re: BUG #15489: Segfault on DELETE|
|2018-11-08 04:40:25+00||=?UTF-8?Q?Frederico_Galv=C3=A3o?=||Re: BUG #15489: Segfault on DELETE|
|2018-11-08 16:29:35+00||Kanwei Li||Re: BUG #15489: Segfault on DELETE|