Re: Query Core Dumping

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Query Core Dumping
Дата
Msg-id 15446.1297209524@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Query Core Dumping  (Sam Stearns <samtstearns@gmail.com>)
Список pgsql-performance
Sam Stearns <samtstearns@gmail.com> writes:
> I have a SELECT query that runs no problem standalone but when running
> within a perl script it intermittently core dumps.  Random, no pattern
> to the timing of the core dumps.  The perl script processes the rows
> from the query, if the rows satisfy  a condition then the perl script
> adds the rows to another table.  When the script works it runs for
> about a minute.  If the script fails, it runs for about 5 minutes and
> core dumps.  The core dump is in the perl error handling routines.  We
> suspect the bug is related to how the perl postgres libraries interact
> with postgres.

Can you get a stack trace from one of the core dumps?

Also, exactly which perl version are you using, and with what build
options?  ("perl -V" output would be a good answer here.)

BTW, this seems pretty off-topic for pgsql-performance.

            regards, tom lane

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

Предыдущее
От: Sam Stearns
Дата:
Сообщение: Query Core Dumping
Следующее
От: Vitalii Tymchyshyn
Дата:
Сообщение: Re: Bad query plan when the wrong data type is used