Skip site navigation (1) Skip section navigation (2)

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: (view raw or whole 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

			regards, tom lane

In response to


pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group