Re: Query Core Dumping

Sam Stearns <samtstearns(at)gmail(dot)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