Skip site navigation (1) Skip section navigation (2)

Re: Perl Libraries and Postgres

From: Sam Stearns <samtstearns(at)gmail(dot)com>
To: Norbert Zacharias <zac(at)uni-oldenburg(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Perl Libraries and Postgres
Date: 2011-02-10 10:24:26
Message-ID: AANLkTimdH-k1JH0nTKWjpXhGUqAkrAqPZ8xrhyqBY+bs@mail.gmail.com (view raw or flat)
Thread:
Lists: 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(at)uni-oldenburg(dot)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
>
>

In response to

Responses

pgsql-admin by date

Next:From: Marc MaminDate: 2011-02-10 10:54:01
Subject: FILLFACTOR Tuning
Previous:From: Devrim GÜNDÜZDate: 2011-02-10 08:43:40
Subject: Re: Cross Platform Continous Archiving and Replication

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group