segfault while oading DBD::Pg on Fedora Core 2

hi. i'm trying to develop a perl app, which uses PostgreSQL for te
database. the app works fine, however i can't get it to run on client's
machine.

he's got fedora core 2 running there. i had to install PostgreSQL and
DBD::Pg myself (through 'yum' since it's fedora).
the problem i get is:

DBD::Pg installs itself in /usr/lib/perl5/vendor_perl which is not in
@INC by default.

if i modify @INC before including DBI (either by "use lib ..." or by
manually adding the path to @INC) i get an error:

/usr/bin/perl: error while loading shared libraries:
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/aut o/DBI/DBI.so:
undefined symbol: Perl_Gthr_key_ptr

i tried changing the include path after loading DBI. DBI loads fine, but
when loading DBD::Pg, my app segfaults.

it doesn't matter if i "use DBD::Pg" or let DBI load the module implicitly.

does anybody know what could be the cause of the problem? i'd be
grateful for any support.

program versions are (as returned by rpm -qa):
perl-5.8.3-18
perl-DBI-1.40-4
perl-DBD-Pg-1.31-5
postgresql-7.4.7-3.FC2.1


thanks in advance
Jakub Łukomski


--
-- Jakub Łukomski - Blackmoon Development s.c. ---
--------- e-mail: qba@blackmoondev.com ----------
------ gg: 1359526 ------- icq: 21239043 -------
-------- jabber & msn: qba@best.net.pl ----------
------------- aim & tlen: qbalukom ---------------

Re: segfault while oading DBD::Pg on Fedora Core 2

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> /usr/bin/perl: error while loading shared libraries:
> /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/aut o/DBI/DBI.so:
> undefined symbol: Perl_Gthr_key_ptr

Sounds like something is out of sync. You might try reinstalling DBI, or
even Perl, and then installing DBD::Pg. A similar thread suggested
making sure all of these are the same version: perl, perl-base, and
perl-modules.

> program versions are (as returned by rpm -qa):
> perl-5.8.3-18
> perl-DBI-1.40-4
> perl-DBD-Pg-1.31-5
> postgresql-7.4.7-3.FC2.1

Those are all a little old. You might want to check if anything newer is
available via yum. Move to postgres 8.1 if you can. The latest DBI is
1.50, the latest DBD::Pg is 1.49, and the latest Perl is 5.8.8. Try to get
as close to those numbers as you can. Since it's FC 2, that might not be
possible, but a forced reinstall of all the above should at least get them
in sync enough to avoid that error.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200605082316
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B90 6714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFEYAmjvJuQZxSWSsgRAjSTAJ41WXS31D2I7yQd2DMUvxoRvmz4TACg iDoA
Ed015HaGgUL63fA0uWjzEtw=
=wk6Z
-----END PGP SIGNATURE-----

Re: segfault while oading DBD::Pg on Fedora Core 2

Greg Sabino Mullane wrote:
>> /usr/bin/perl: error while loading shared libraries:
>> /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/aut o/DBI/DBI.so:
>> undefined symbol: Perl_Gthr_key_ptr
>
> Sounds like something is out of sync. You might try reinstalling DBI, or
> even Perl, and then installing DBD::Pg. A similar thread suggested
> making sure all of these are the same version: perl, perl-base, and
> perl-modules.
actually it seems Fedora 2 hast only one rpm "perl" for all three of
above, so it's not possible for them to be out of synch.

>> program versions are (as returned by rpm -qa):
>> perl-5.8.3-18
>> perl-DBI-1.40-4
>> perl-DBD-Pg-1.31-5
>> postgresql-7.4.7-3.FC2.1
>
> Those are all a little old. You might want to check if anything newer is
> available via yum. Move to postgres 8.1 if you can. The latest DBI is
> 1.50, the latest DBD::Pg is 1.49, and the latest Perl is 5.8.8. Try to get
> as close to those numbers as you can. Since it's FC 2, that might not be
> possible, but a forced reinstall of all the above should at least get them
> in sync enough to avoid that error.
actually i checked on rpm.pbone.net - the versions i listed are the
newest versions of this software available for Fedora 2.
however i downloaded the rpms from fedora ftp (same versions) and just
force-upgraded them and it seems to work.

thanks for all the help
Jakub Łukomski

--
-- Jakub Łukomski - Blackmoon Development s.c. ---
--------- e-mail: qba@blackmoondev.com ----------
------ gg: 1359526 ------- icq: 21239043 -------
-------- jabber & msn: qba@best.net.pl ----------
------------- aim & tlen: qbalukom ---------------