Re: Query Core Dumping

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