Skip Menu |

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

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

People
Owner: Nobody in particular
Requestors: GAAS [...] cpan.org
Cc:
AdminCc:

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



Subject: t/29warnings.t fails with DBD-mysql-4.025
perl Makefile.PL
I will use the following settings for compiling and testing:
  cflags        (mysql_config ) = -I/usr/include/mysql -DBIG_JOINS=1  -fno-strict-aliasing  -g
  embedded      (mysql_config ) = 
  libs          (User's choice) = -L/usr/lib/x86_64-linux-gnu -lmysqlclient ../openssl/libssl.a ../openssl/libcrypto.a ../zlib/libz.a -lpthread -lm -lrt -ldl
  mysql_config  (guessed      ) = mysql_config
  nocatchstderr (default      ) = 0
  nofoundrows   (default      ) = 0
  ssl           (guessed      ) = 1
  testdb        (default      ) = test
  testhost      (User's choice) = plow.activestate.com
  testpassword  (default      ) = 
  testport      (User's choice) = 3308
  testsocket    (default      ) = 
  testuser      (User's choice) = test

To change these settings, see 'perl Makefile.PL --help' and
'perldoc DBD::mysql::INSTALL'.

Checking if your kit is complete...
Warning: the following files are missing in your kit:
	META.json
	t/mem_leak.pl
Please inform the author.
Using DBI 1.63 (for perl 5.016003 on x86_64-linux-thread-multi) installed in /tmp/perl-vxmqxpesljqoqhtmwzppymtxgcecsxrdmbycxuphwjvxepuxmfhxahluthuekagjssvpqrcqdqhhemnajpkkktnqbeirrzyhdrtabwgvqaefqtywmauvwf/lib/auto/DBI/
Generating a Unix-style Makefile
Writing Makefile for DBD::mysql
Writing MYMETA.yml and MYMETA.json
>>> cd DBD-mysql && make POD2HTML='$(NOOP)'
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp README.pod blib/lib/DBD/README.pod
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
gcc -c  -I/tmp/perl-vxmqxpesljqoqhtmwzppymtxgcecsxrdmbycxuphwjvxepuxmfhxahluthuekagjssvpqrcqdqhhemnajpkkktnqbeirrzyhdrtabwgvqaefqtywmauvwf/lib/auto/DBI -I/usr/include/mysql -DBIG_JOINS=1  -fno-strict-aliasing  -g -DDBD_MYSQL_WITH_SSL -DDBD_MYSQL_INSERT_ID_IS_GOOD -g  -D_REENTRANT -D_GNU_SOURCE -DUSE_SITECUSTOMIZE -DPERL_RELOCATABLE_INCPUSH -fno-merge-constants -fno-strict-aliasing -pipe -fstack-protector -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2   -DVERSION=\"4.025\" -DXS_VERSION=\"4.025\" -fPIC "-I/tmp/perl-vxmqxpesljqoqhtmwzppymtxgcecsxrdmbycxuphwjvxepuxmfhxahluthuekagjssvpqrcqdqhhemnajpkkktnqbeirrzyhdrtabwgvqaefqtywmauvwf/lib/CORE"   dbdimp.c
dbdimp.c: In function 'mysql_describe':
dbdimp.c:3661:22: warning: assignment from incompatible pointer type [enabled by default]
/tmp/perl-vxmqxpesljqoqhtmwzppymtxgcecsxrdmbycxuphwjvxepuxmfhxahluthuekagjssvpqrcqdqhhemnajpkkktnqbeirrzyhdrtabwgvqaefqtywmauvwf/bin/perl-static -p -e "s/~DRIVER~/mysql/g" /tmp/perl-vxmqxpesljqoqhtmwzppymtxgcecsxrdmbycxuphwjvxepuxmfhxahluthuekagjssvpqrcqdqhhemnajpkkktnqbeirrzyhdrtabwgvqaefqtywmauvwf/lib/auto/DBI/Driver.xst > mysql.xsi
/tmp/perl-vxmqxpesljqoqhtmwzppymtxgcecsxrdmbycxuphwjvxepuxmfhxahluthuekagjssvpqrcqdqhhemnajpkkktnqbeirrzyhdrtabwgvqaefqtywmauvwf/bin/perl-static /tmp/perl-vxmqxpesljqoqhtmwzppymtxgcecsxrdmbycxuphwjvxepuxmfhxahluthuekagjssvpqrcqdqhhemnajpkkktnqbeirrzyhdrtabwgvqaefqtywmauvwf/lib/ExtUtils/xsubpp  -typemap /tmp/perl-vxmqxpesljqoqhtmwzppymtxgcecsxrdmbycxuphwjvxepuxmfhxahluthuekagjssvpqrcqdqhhemnajpkkktnqbeirrzyhdrtabwgvqaefqtywmauvwf/lib/ExtUtils/typemap  mysql.xs > mysql.xsc && mv mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs, line 242
Warning: duplicate function definition 'rows' detected in mysql.xs, line 754
gcc -c  -I/tmp/perl-vxmqxpesljqoqhtmwzppymtxgcecsxrdmbycxuphwjvxepuxmfhxahluthuekagjssvpqrcqdqhhemnajpkkktnqbeirrzyhdrtabwgvqaefqtywmauvwf/lib/auto/DBI -I/usr/include/mysql -DBIG_JOINS=1  -fno-strict-aliasing  -g -DDBD_MYSQL_WITH_SSL -DDBD_MYSQL_INSERT_ID_IS_GOOD -g  -D_REENTRANT -D_GNU_SOURCE -DUSE_SITECUSTOMIZE -DPERL_RELOCATABLE_INCPUSH -fno-merge-constants -fno-strict-aliasing -pipe -fstack-protector -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2   -DVERSION=\"4.025\" -DXS_VERSION=\"4.025\" -fPIC "-I/tmp/perl-vxmqxpesljqoqhtmwzppymtxgcecsxrdmbycxuphwjvxepuxmfhxahluthuekagjssvpqrcqdqhhemnajpkkktnqbeirrzyhdrtabwgvqaefqtywmauvwf/lib/CORE"   mysql.c
rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/usr/lib/x86_64-linux-gnu" /tmp/perl-vxmqxpesljqoqhtmwzppymtxgcecsxrdmbycxuphwjvxepuxmfhxahluthuekagjssvpqrcqdqhhemnajpkkktnqbeirrzyhdrtabwgvqaefqtywmauvwf/bin/perl-static myld gcc  -shared -O2 -fstack-protector dbdimp.o mysql.o  -o blib/arch/auto/DBD/mysql/mysql.so 	\
	   -L/usr/lib/x86_64-linux-gnu -lmysqlclient ../openssl/libssl.a ../openssl/libcrypto.a ../zlib/libz.a -lpthread -lm -lrt -ldl  	\
	  
chmod 755 blib/arch/auto/DBD/mysql/mysql.so
/tmp/perl-vxmqxpesljqoqhtmwzppymtxgcecsxrdmbycxuphwjvxepuxmfhxahluthuekagjssvpqrcqdqhhemnajpkkktnqbeirrzyhdrtabwgvqaefqtywmauvwf/bin/perl-static -MExtUtils::Command::MM -e 'cp_nonempty' -- mysql.bs blib/arch/auto/DBD/mysql/mysql.bs 644
Manifying blib/man3/DBD::README.3
Manifying blib/man3/Bundle::DBD::mysql.3
Manifying blib/man3/DBD::mysql.3
Manifying blib/man3/DBD::mysql::INSTALL.3
Use of uninitialized value $skip_test in lc at /home/gecko/lib/ActivePerl/Build/Build.pm line 926.
>>> cd DBD-mysql && make test
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
PERL_DL_NONLAZY=1 /tmp/perl-vxmqxpesljqoqhtmwzppymtxgcecsxrdmbycxuphwjvxepuxmfhxahluthuekagjssvpqrcqdqhhemnajpkkktnqbeirrzyhdrtabwgvqaefqtywmauvwf/bin/perl-static "-MExtUtils::Command::MM" "-MTest::Harness" "-e" "undef *Test::Harness::Switches; test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base.t ........................... ok
t/10connect.t ........................ ok
t/15reconnect.t ...................... ok
t/20createdrop.t ..................... ok
t/25lockunlock.t ..................... ok

#   Failed test at t/29warnings.t line 59.
#          got: '1'
#     expected: '2'
# Looks like you failed 1 test of 14.
t/29warnings.t ....................... 
Dubious, test returned 1 (wstat 256, 0x100)
Failed 1/14 subtests 
t/30insertfetch.t .................... ok
t/31insertid.t ....................... ok
[...]
From: dsteinbrunner [...] pobox.com
On Thu Dec 05 16:41:50 2013, GAAS wrote: Show quoted text
> $ perl Makefile.PL > I will use the following settings for compiling and testing:
Having this same issue with these settings: cflags (mysql_config ) = -I/usr/include/mysql -DBIG_JOINS=1 -fno-strict-aliasing -DUNIV_LINUX -DUNIV_LINUX embedded (mysql_config ) = ldflags (mysql_config ) = -rdynamic libs (mysql_config ) = -L/usr/lib/mysql -lmysqlclient mysql_config (guessed ) = mysql_config nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ssl (guessed ) = 0 using perl 5.16.3 on debian 6.0.8
From: d.thomas [...] its.uq.edu.au
also happens for me RHEL6 but my own non-threaded build of 5.16.3 mysql 5.1.69 info is "Records: 3 Duplicates: 0 Warnings: 1" possibly new in 4.025 because of https://rt.cpan.org/Public/Bug/Display.html?id=29363
I'm getting the same test failure on CentOS 6 x86_64 with plenv running Perl 5.18.1. The previous DBD::mysql version 4.024 builds fine there.
Thanks for reporting; apparently the test passes on MySQL 5.5.31 and later, and it fails on 5.1.(whichever version in RHEL). I'm not sure exactly which versions are affected, and because it's a server-side issue more than a client-side issue, I decided just to comment out the test. See here: https://github.com/perl5-dbi/DBD-mysql/commit/90acd3ed475a3e08f12119b291df37c499b77cf1 -- Mike.