PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15489
PG Version11.0
OSDebian 9
Opened2018-11-07 05:01:56+00
Reported byKanwei Li
StatusNew

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 [60606] LOG:  server process (PID 66881) was
terminated by signal 11: Segmentation fault
2018-11-06 21:02:07.553 UTC [60606] 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.

Messages

DateAuthorSubject
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+00Amit LangoteRe: BUG #15489: Segfault on DELETE
2018-11-07 07:14:09+00Michael PaquierRe: 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+00Tom LaneRe: BUG #15489: Segfault on DELETE
2018-11-08 01:33:39+00Amit LangoteRe: 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+00Kanwei LiRe: BUG #15489: Segfault on DELETE