Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Bernt M(dot) Johnsen" <Bernt(dot)Johnsen(at)sun(dot)com>, Euler Taveira de Oliveira <euler(at)timbira(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
Date: 2009-10-30 18:26:26
Message-ID: 407d949e0910301126o32af6e9et60190ba6fc2de2d5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Oct 30, 2009 at 11:22 AM, Stefan Kaltenbrunner
<stefan(at)kaltenbrunner(dot)cc> wrote:
> ok I now see why you (and I) failed to reproduce the problem - it only
> causes clusters/databases to crash that were actually generated using the
> upthread mentioned script. it does NOT fail using a dump generated by a
> database that fails(!).
> So the issue must be a bit more complex and somehow relate to some prior
> stuff the script does.

Does it still crash if you compile with CFLAGS='-O0 -g' ? Could you
send a backtrace from that?

--
greg

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stefan Kaltenbrunner 2009-10-30 18:47:49 Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
Previous Message Stefan Kaltenbrunner 2009-10-30 18:22:53 Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault