| 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 causes segfault |
| Date: | 2009-10-29 15:09:57 |
| Message-ID: | 20091029150957.GA513@atum01.Norway.Sun.COM |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| Attachment | Content-Type | Size |
|---|---|---|
| xx.yy | text/plain | 715 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stefan Kaltenbrunner | 2009-10-29 21:14:30 | Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault |
| Previous Message | Alvaro Herrera | 2009-10-29 14:36:51 | Re: Small syntax error in fmgr.h |