Re: BUG #5977: Crash on delete - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5977: Crash on delete
Date
Msg-id 4602.1302705756@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5977: Crash on delete  ("Anton Kuznetsov" <antosha86@mail.ru>)
List pgsql-bugs
"Anton Kuznetsov" <antosha86@mail.ru> writes:
> Server crases on delete and than automatically restarts;
> Log message was:

> TRAP: FailesAssertion("!(outerstartsel <= outerendsel)",  File:
> "costsize.c", String: 1540)

That's pretty interesting ... can you put together a self-contained test
case?  That might be a bit difficult because this is probably dependent
on data statistics.  But it should at least be possible to determine
which join clause is causing the problem, and then show us the pg_stats
entries for the columns used in the join.  This isn't going to be
dependent on whether the command is a DELETE or not, just the table join
conditions.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Anton Kuznetsov"
Date:
Subject: BUG #5977: Crash on delete
Next
From: Tim Wallace
Date:
Subject: Make fails if env var U set