From: Tom Lane <tgl@sss.pgh.pa.us>
To: Sam Stearns <samtstearns@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Query Core Dumping
Date: Tue, 08 Feb 2011 18:58:44 -0500
Message-ID: <15446.1297209524@sss.pgh.pa.us> (raw)
In-Reply-To: <AANLkTinXfe3z5bansRTUyQCZvKRcxWD_rJQbETHL_V6K@mail.gmail.com>
References: <AANLkTinXfe3z5bansRTUyQCZvKRcxWD_rJQbETHL_V6K@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, samtstearns@gmail.com
Subject: Re: Query Core Dumping
In-Reply-To: <15446.1297209524@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox