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

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

From: "Bernt M(dot) Johnsen" <Bernt(dot)Johnsen(at)Sun(dot)COM>
To: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5145: Complex query with lots of LEFT JOIN causessegfault
Date: 2009-10-29 15:09:57
Message-ID: 20091029150957.GA513@atum01.Norway.Sun.COM (view raw or flat)
Thread:
Lists: pgsql-bugs
>>>>>>>>>>>> Euler Taveira de Oliveira wrote (2009-10-29 12:17:36):
> Bernt Marius Johnsen escreveu:
> > The below query generated by the Random Query Generator
> > (https://launchpad.net/randgen) causes a segfault. It was caused running
> > 

Checkout the latest RQG from launchpad and run ./gentest.pl as shown
above (The lastest tarball misses a feature you need). xx.yy is
attached.

Run like this:
./gentest.pl --dsn=dbi:Pg:user=xxxx --gendata --queries=100000 --threads=1 --grammar=/path/to/xx.yy



> Could you get a core dump and post the gdb backtrace?
> 
> $ ulimit -c unlimited
> $ pg_ctl start
> $ psql -c "<my query goes here>" mydb
> $ gdb /path/to/postgres $PGDATA/core
> (gdb) bt
> .
> .
> .
> (gdb) quit

We'll see next week If I can spare some time.

> 
> 
> -- 
>   Euler Taveira de Oliveira
>   http://www.timbira.com/

-- 
Bernt Marius Johnsen, Staff Engineer
Database Technology Group, Sun Microsystems, Trondheim, Norway

In response to

Responses

pgsql-bugs by date

Next:From: Stefan KaltenbrunnerDate: 2009-10-29 21:14:30
Subject: Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
Previous:From: Alvaro HerreraDate: 2009-10-29 14:36:51
Subject: Re: Small syntax error in fmgr.h

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