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

Поиск
Список
Период
Сортировка
От Bernt M. Johnsen
Тема Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
Дата
Msg-id 20091029150957.GA513@atum01.Norway.Sun.COM
обсуждение исходный текст
Ответ на Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault  (Euler Taveira de Oliveira <euler@timbira.com>)
Ответы Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Список 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

Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Small syntax error in fmgr.h
Следующее
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault