Regarding perls db connectivity issue

gagan2914 has asked for the wisdom of the Perl Monks concerning the following question:

Hi All We are using perl module(i.e 5.8) in our project which reads the data from the file and insert the data in to database (i.e mysql). Now we have upgraded the linux OS from 32 bit to 64 bit and the perl module from 5.8 to 5.10. We have made the significant changes in the perl-mysql DBD file also. Now we are able to create the connection with database from perl test program but we are getting following error from our project perl script: pos1 Assertion ((svtype)((_svi)->sv_flags & 0xff)) >= SVt_PV failed: file "DBI.xs", line 2327 at lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/DBI.pm line 569. Assertion ((svtype)((_svi)->sv_flags & 0xff)) >= SVt_PV failed: file "DBI.xs", line 2327 at lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/DBI.pm line 657. END failed--call queue aborted at ./cdrserver.pl line 569. I am a beginner to perl. Can any one please let me know about the significance of this error as I am unable to get much help about this problem google also. Thanks Gagan

Comment on Regarding perls db connectivity issue

Replies are listed 'Best First'.
Re: Regarding perls db connectivity issue by moritz (Cardinal) on Jun 28, 2011 at 08:27 UTC
So, your group has made significant changes to DBD::mysql, and now it doesn't work anymore, and you expect us to diagnose the error, even though we don't know what changes you made? That won't work, at least my magic crystal ball isn't good enough for that. Perl 6 - second systems done right	[reply]
Re: Regarding perls db connectivity issue by locked_user sundialsvc4 (Abbot) on Jun 28, 2011 at 13:35 UTC
It is a very reasonable guess that you need to use CPAN to re-install the various modules involved, including the MySQL driver. “XS” code is the underlying C/C++ software that glues Perl to the drivers. When you change from 32-bit to 64, those drivers are going to change too, and that means that new glue is required.
Re: Regarding perls db connectivity issue by Anonymous Monk on Jun 28, 2011 at 09:10 UTC
SVt_PV failed: file "DBI.xs" ► http://www.zimbra.com/forums/installation/42822-zimbra-install-under-opensuse-11-3-a.html In short, don't mix perls	[reply]
Re: Regarding perls db connectivity issue by Anonymous Monk on Jun 28, 2011 at 08:01 UTC
Now we have upgraded the linux OS from 32 bit to 64 bit and .... When you were upgrading and installing perl and the modules, did you run the test suite for each, and did it pass?	[reply]