Skip Menu |

This queue is for tickets about the DBD-mysql CPAN distribution.

Report information
The Basics
Id: 23256
Status: resolved
Priority: 0/
Queue: DBD-mysql

People
Owner: Nobody in particular
Requestors: william.geldhof [...] nss.be
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



CC: "William Geldhof" <william.geldhof [...] nss.be>
Subject: DBD make test gives dubious and program gives segmentation fault on solaris 10 intel
Date: Tue, 14 Nov 2006 17:23:07 +0100
To: <bug-DBD-mysql [...] rt.cpan.org>
From: "William Geldhof" <william.geldhof [...] nss.be>
hello, I have following problem while installing DBD module. Thank you very much for your time and efforts. regards, William Geldhof 1. Distribution name and version (For example, "DBIx-SearchBuilder-0.46") DBI-1.49 DBD-mysql-3.0002 also tested DBD-mysql-3.0008 perl 5.8.8 operating system : uname -a -> SunOS 5.10 Generic_118844-26 i86pc i386 i86pc shortest code test.pl more test.pl use DBI; use DBD::mysql; /usr/local/bin/perl test.pl Segmentation Fault (core dumped) /usr/local/bin/gcc -v Reading specs from /usr/local/lib/gcc-lib/i386-pc-solaris2.10/3.3.2/specs Configured with: ../configure --with-as=/usr/ccs/bin/as --with-ld=/usr/ccs/bin/ld --disable-nls Thread model: posix gcc version 3.3.2 /usr/local/bin/make -v GNU Make 3.80 Copyright (C) 2002 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. 2. error message : bash-3.00# /usr/local/bin/make test PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/00base.............dubious Test returned status 0 (wstat 139, 0x8b) t/10dsnlist..........dubious Test returned status 0 (wstat 139, 0x8b) t/20createdrop.......dubious Test returned status 0 (wstat 139, 0x8b) t/30insertfetch......dubious Test returned status 0 (wstat 139, 0x8b) t/35limit............dubious Test returned status 0 (wstat 139, 0x8b) t/40bindparam........dubious Test returned status 0 (wstat 139, 0x8b) t/40blobs............dubious Test returned status 0 (wstat 139, 0x8b) t/40listfields.......dubious Test returned status 0 (wstat 139, 0x8b) t/40nulls............dubious Test returned status 0 (wstat 139, 0x8b) t/40numrows..........dubious Test returned status 0 (wstat 139, 0x8b) t/41blobs_prepare....dubious Test returned status 0 (wstat 139, 0x8b) t/50chopblanks.......dubious Test returned status 0 (wstat 139, 0x8b) t/50commit...........dubious Test returned status 0 (wstat 139, 0x8b) t/60leaks............skipped all skipped: $ENV{SLOW_TESTS} is not set or Proc::ProcessTable not installed t/ak-dbd.............dubious Test returned status 0 (wstat 139, 0x8b) DIED. FAILED tests 1-90 Failed 90/90 tests, 0.00% okay t/akmisc.............dubious Test returned status 0 (wstat 139, 0x8b) t/dbdadmin...........dubious Test returned status 0 (wstat 139, 0x8b) DIED. FAILED tests 1-21 Failed 21/21 tests, 0.00% okay t/insertid...........dubious Test returned status 0 (wstat 139, 0x8b) t/mysql..............dubious Test returned status 0 (wstat 139, 0x8b) t/mysql2.............dubious Test returned status 0 (wstat 139, 0x8b) Failed Test Stat Wstat Total Fail Failed List of Failed ------------------------------------------------------------------------------- t/00base.t 0 139 ?? ?? % ?? t/10dsnlist.t 0 139 ?? ?? % ?? t/20createdrop.t 0 139 ?? ?? % ?? t/30insertfetch.t 0 139 ?? ?? % ?? t/35limit.t 0 139 ?? ?? % ?? t/40bindparam.t 0 139 ?? ?? % ?? t/40blobs.t 0 139 ?? ?? % ?? t/40listfields.t 0 139 ?? ?? % ?? t/40nulls.t 0 139 ?? ?? % ?? t/40numrows.t 0 139 ?? ?? % ?? t/41blobs_prepare.t 0 139 ?? ?? % ?? t/50chopblanks.t 0 139 ?? ?? % ?? t/50commit.t 0 139 ?? ?? % ?? t/ak-dbd.t 0 139 90 180 200.00% 1-90 t/akmisc.t 0 139 ?? ?? % ?? t/dbdadmin.t 0 139 21 42 200.00% 1-21 t/insertid.t 0 139 ?? ?? % ?? t/mysql.t 0 139 ?? ?? % ?? t/mysql2.t 0 139 ?? ?? % ?? 1 test skipped. Failed 19/20 test scripts, 5.00% okay. 111/111 subtests failed, 0.00% okay. make: *** [test_dynamic] Error 255 3. ./configure and such i used following LD_LIBRARY_PATH en PATH settings because i know it works for solaris 10 sparc. LD_LIBRARY_PATH=/usr/local/lib:/usr/lib:/usr/local/BerkeleyDB.4.2/lib;export LD_LIBRARY_PATH bash-3.00# PATH=/usr/local/bin:/usr/ccs/bin:/usr/sbin:/sbin:/usr/bin:/usr/local/mysql/bin;export PATH /usr/local/bin/perl Makefile.PL --cflags=-I/usr/local/mysql/include I will use the following settings for compiling and testing: cflags (User's choice) = -I/usr/local/mysql/include embedded (mysql_config ) = libs (mysql_config ) = -L/usr/local/mysql/lib -lmysqlclient -lz -lposix4 -lgen -lsocket -lnsl -lm mysql_config (guessed ) = mysql_config nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ssl (guessed ) = 0 testdb (default ) = test testhost (default ) = testpassword (default ) = testsocket (default ) = testuser (default ) = To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'. Using DBI 1.49 (for perl 5.008008 on i86pc-solaris) installed in /usr/local/lib/perl5/site_perl/5.8.8/i86pc-solaris/auto/DBI/ Writing Makefile for DBD::mysql bash-3.00# make cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm cp lib/Mysql.pm blib/lib/Mysql.pm cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm gcc -B/usr/ccs/bin/ -c -I/usr/local/lib/perl5/site_perl/5.8.8/i86pc-solaris/auto/DBI/ -I/usr/local/mysql/include -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPERL_USE_SAFE_PUTENV -O -DVERSION=\"3.0002\" -DXS_VERSION=\"3.0002\" -fPIC "-I/usr/local/lib/perl5/5.8.8/i86pc-solaris/CORE" dbdimp.c In file included from /usr/local/lib/perl5/site_perl/5.8.8/i86pc-solaris/auto/DBI/DBIXS.h:31, from dbdimp.h:20, from dbdimp.c:20: /usr/local/lib/perl5/site_perl/5.8.8/i86pc-solaris/auto/DBI/dbipport.h:227:1: warning: "PERL_UNUSED_DECL" redefined In file included from /usr/local/lib/perl5/site_perl/5.8.8/i86pc-solaris/auto/DBI/DBIXS.h:19, from dbdimp.h:20, from dbdimp.c:20: /usr/local/lib/perl5/5.8.8/i86pc-solaris/CORE/perl.h:163:1: warning: this is the location of the previous definition /usr/local/bin/perl -p -e "s/~DRIVER~/mysql/g" /usr/local/lib/perl5/site_perl/5.8.8/i86pc-solaris/auto/DBI//Driver.xst > mysql.xsi /usr/local/bin/perl /usr/local/lib/perl5/5.8.8/ExtUtils/xsubpp -typemap /usr/local/lib/perl5/5.8.8/ExtUtils/typemap mysql.xs > mysql.xsc && mv mysql.xsc mysql.c Warning: duplicate function definition 'do' detected in mysql.xs, line 224 Warning: duplicate function definition 'rows' detected in mysql.xs, line 559 gcc -B/usr/ccs/bin/ -c -I/usr/local/lib/perl5/site_perl/5.8.8/i86pc-solaris/auto/DBI/ -I/usr/local/mysql/include -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPERL_USE_SAFE_PUTENV -O -DVERSION=\"3.0002\" -DXS_VERSION=\"3.0002\" -fPIC "-I/usr/local/lib/perl5/5.8.8/i86pc-solaris/CORE" mysql.c In file included from /usr/local/lib/perl5/site_perl/5.8.8/i86pc-solaris/auto/DBI/DBIXS.h:31, from dbdimp.h:20, from mysql.xs:14: /usr/local/lib/perl5/site_perl/5.8.8/i86pc-solaris/auto/DBI/dbipport.h:227:1: warning: "PERL_UNUSED_DECL" redefined In file included from /usr/local/lib/perl5/site_perl/5.8.8/i86pc-solaris/auto/DBI/DBIXS.h:19, from dbdimp.h:20, from mysql.xs:14: /usr/local/lib/perl5/5.8.8/i86pc-solaris/CORE/perl.h:163:1: warning: this is the location of the previous definition Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs rm -f blib/arch/auto/DBD/mysql/mysql.so LD_RUN_PATH="/usr/lib" /usr/local/bin/perl myld gcc -B/usr/ccs/bin/ -G -L/usr/local/lib dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so \ -L/usr/local/mysql/lib -lmysqlclient -lz -lposix4 -lgen -lsocket -lnsl -lm \ chmod 755 blib/arch/auto/DBD/mysql/mysql.so cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs chmod 644 blib/arch/auto/DBD/mysql/mysql.bs Manifying blib/man3/DBD::mysql.3 Manifying blib/man3/DBD::mysql::INSTALL.3 Manifying blib/man3/Mysql.3 Manifying blib/man3/Bundle::DBD::mysql.3

Message body is not shown because it is too large.

CC: undisclosed-recipients:;
Subject: Re: [rt.cpan.org #23256] DBD make test gives dubious and program gives segmentation fault on solaris 10 intel
Date: Tue, 14 Nov 2006 16:03:40 -0500
To: bug-DBD-mysql [...] rt.cpan.org
From: Patrick Galbraith <patg [...] mysql.com>

Message body is not shown because it is too large.

Subject: Re: [rt.cpan.org #23256] DBD make test gives dubious and program gives segmentation fault on solaris 10 intel
Date: Wed, 15 Nov 2006 08:53:17 +0100
To: bug-DBD-mysql [...] rt.cpan.org
From: william geldhof <william.geldhof [...] nss.be>

Message body is not shown because it is too large.

Subject: [rt.cpan.org #23256] DBD make test gives dubious and program gives segmentation fault on solaris 10
Date: Thu, 16 Nov 2006 16:05:04 +0100
To: bug-DBD-mysql [...] rt.cpan.org
From: william geldhof <william.geldhof [...] nss.be>
Hi, Is there a way i can help testing this ? Are there any options i could give in makefile and configure to debug this ? regards, -- William Geldhof NSS
CC: undisclosed-recipients:;
Subject: Re: [rt.cpan.org #23256] DBD make test gives dubious and program gives segmentation fault on solaris 10
Date: Thu, 16 Nov 2006 10:23:54 -0500
To: bug-DBD-mysql [...] rt.cpan.org
From: Patrick Galbraith <patg [...] mysql.com>
william.geldhof@nss.be via RT wrote: Show quoted text
> Queue: DBD-mysql > Ticket <URL: http://rt.cpan.org/Ticket/Display.html?id=23256 > > >Hi, > >Is there a way i can help testing this ? >Are there any options i could give in makefile and configure to debug this ? > >regards, > > >
The whole problem is not that with DBD::mysql, but the fact that they are using a binary distribution of MySQL, which was built with different compile flags/link flags (flags from the machine the binary was built on) than is on their system that they are trying to build DBD::mysql on. DBD::mysql uses mysql_config which is part of the MySQL server package, and it too gives build flags for how the binary was built and not for what their machine can use, hence the failure. This works for 95% of the users out there. What is needed, if I get time, is to come up with a configure script that can determine the build flags for the user's machine. Kind regards, Patrick
Subject: Re: [rt.cpan.org #23256] DBD make test gives dubious and program gives segmentation fault on solaris 10
Date: Fri, 17 Nov 2006 11:42:06 +0100
To: bug-DBD-mysql [...] rt.cpan.org
From: william geldhof <william.geldhof [...] nss.be>
hi, i downloaded the mysql-5.0.27 (source package) from the mysql site i installed version 3.4.6 of gcc of the sunfreeware.com site. I first tried with 3.3.2 of the gcc package, but to no avail. i compiled mysql with following options, also mentioned on the mysql site on page dev.mysql.com/doc/refman/5.0/en/solaris.html#solaris-x86 CC=gcc CFLAGS="-03 -fomit-frame-pointer -DHAVE_CURSES_H" \ CXX=gcc \ CXXFLAGS="-03 -fomit-frame-pointer -felide-constructors \ -fno-exceptions -fno-rtti -DHAVE_CURSES_H" \ ./configure --prefix=/usr/local/mysql i manage to launch mysqld , but i get the same dubious errors when i try to "make test" on the DBD package. Thank you for your time and efforts. William
Subject: [rt.cpan.org #23256] DBD make test gives dubious and program gives segmentation fault on solaris 10
Date: Mon, 20 Nov 2006 21:38:22 +0100
To: bug-DBD-mysql [...] rt.cpan.org
From: wg <william.geldhof [...] scarlet.be>
DBD works if i compile mysql5.0.27 with options mentioned in my previous mail. nothing has to be mentioned about --libs etc while making the DBD bundle. perl Makefile.PL make make install does the trick thank you for your hint building the mysql from source.
This is the fault of mysql_config not giving us good information on how to link to the mysql client library. This is a bug on that side, tracked here: http://bugs.mysql.com/11492