From: | Alex Hunsaker <badalex(at)gmail(dot)com> |
---|---|
To: | Sam Stearns <samtstearns(at)gmail(dot)com> |
Cc: | Norbert Zacharias <zac(at)uni-oldenburg(dot)de>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Perl Libraries and Postgres |
Date: | 2011-02-11 16:58:15 |
Message-ID: | AANLkTinERUw9ZeSKHe2ZEzj6zArN3kQho3eL983R-twJ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Thu, Feb 10, 2011 at 03:24, Sam Stearns <samtstearns(at)gmail(dot)com> wrote:
> 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:
>>>> perl -V
>>> Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
>>
>> May be an upgrade to 5.10 will solve the problem ?
Doubtful :-(
>> From gdb:
>> #0 0x080bf4ef in Perl_sv_vcatpvfn ()
>> #1 0x080bdb30 in Perl_sv_vsetpvfn ()
>> #2 0x080a1363 in Perl_vmess ()
>> #3 0x080a1d06 in Perl_vwarn ()
>> #4 0x080a1fde in Perl_warn ()
>> #5 0xfe7f9d58 in pg_warn () from /usr/local/stow/perl-5.8.8/lib/site_perl/5.8.8/i86pc-solaris/auto/DBD/Pg/Pg.so
>> #6 0xfe7c704e in defaultNoticeReceiver () from /usr/local/lib/libpq.so.4
>> #7 0xfe7cf0bc in pqGetErrorNotice3 () from /usr/local/lib/libpq.so.4
....
So it looks like it you are receiving a notice and DBD::Pg is trying
to warn() it.
What versions of DBD::Pg and DBI are you using? I'd look at
http://cpansearch.perl.org/src/TURNSTEP/DBD-Pg-2.17.2/Changes and
http://search.cpan.org/~timb/DBI-1.616/Changes for any known bugs you
might be hitting.
If upgrading those do not fix it, the next step would be to try and
make a reproducible test case. I'd start by by cranking up the
postgres log level so you can find out what the notice is. From there
you might be able to find a way to trigger it reliably.
If all else fails it never hurts to run it under valgrind to see if it
can pinpoint some obvious memory corruption.
From | Date | Subject | |
---|---|---|---|
Next Message | Frederiko Costa | 2011-02-11 17:09:48 | Re: Postgres on NAS/NFS |
Previous Message | Arnold, Sandra | 2011-02-11 15:32:39 | Vulnerability Scanning for PostgreSQL |