Re: BUG #5977: Crash on delete

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Anton Kuznetsov" <antosha86(at)mail(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5977: Crash on delete
Date: 2011-04-13 14:42:36
Message-ID: 4602.1302705756@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Anton Kuznetsov" <antosha86(at)mail(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2011-04-13 17:20:51 Re: Make fails if env var U set
Previous Message Tim Wallace 2011-04-13 14:26:21 Make fails if env var U set