Re: Perl Libraries and Postgres - Mailing list pgsql-admin

From Sam Stearns
Subject Re: Perl Libraries and Postgres
Date
Msg-id AANLkTimdH-k1JH0nTKWjpXhGUqAkrAqPZ8xrhyqBY+bs@mail.gmail.com
Whole thread Raw
In response to Re: Perl Libraries and Postgres  ("Norbert Zacharias" <zac@uni-oldenburg.de>)
Responses Re: Perl Libraries and Postgres  (Alex Hunsaker <badalex@gmail.com>)
List pgsql-admin
Thanks, Norbert!

I'll run the perl 5.10 upgrade past the guys.

Sam

On Thu, Feb 10, 2011 at 6:27 PM, Norbert Zacharias <zac@uni-oldenburg.de> wrote:
> 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
>
>

pgsql-admin by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: Cross Platform Continous Archiving and Replication
Next
From: "Marc Mamin"
Date:
Subject: FILLFACTOR Tuning