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: 4602.1302705756@sss.pgh.pa.us (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group