Message-ID: <2779.212.6.96.243.1297324662.squirrel@webmail.uni-oldenburg.de>
In-Reply-To: <AANLkTiku-t-c3SMr-oLz=oO15BDnhgFngs26hcM79SaU@mail.gmail.com>
References: <AANLkTiku-t-c3SMr-oLz=oO15BDnhgFngs26hcM79SaU@mail.gmail.com>
Date: Thu, 10 Feb 2011 08:57:42 +0100 (CET)
Subject: Re: Perl Libraries and Postgres
From: "Norbert Zacharias" <zac@uni-oldenburg.de>
To: "Sam Stearns" <samtstearns@gmail.com>
Cc: pgsql-admin@postgresql.org
User-Agent: SquirrelMail/1.4.8-5.el5_4.10
MIME-Version: 1.0
Content-Type: text/plain;charset=utf-8
Content-Transfer-Encoding: 8bit
Importance: Normal

Moin,

> Howdy,
>
> Environment:
>
> Postgres 8.3.13
> Solaris 10
>
> 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.

This might be more a question for a perl group.

>> perl -V
> Summary of my perl5 (revision 5 version 8 subversion 8) configuration:

May be an upgrade to 5.10 will solve the problem ?

> Anyone have any ideas?

see above ;-)

Regards
Norbert