I recently ran an update and saw a bunch of Perl modules were upgraded. I have a script that uses the DBD module that is now broken (Im using DBI in the script). Now when I run the script I get this error right about when I try to execute a SQL query: /usr/bin/perl: symbol lookup error: /usr/lib/perl5/vendor_perl/5.8.8/i686-linux-thread-multi/auto/DBD/mysql/mysql.so: undefined symbol: mysql_warning_count I tried rebuilding DBI and the DBD-mysql module without any change. I even tried rebuilding perl, then DBI then DBD-mysql. I also ran perl-cleaner after updates. So far I have been unable to figure this one out. Reproducible: Always Steps to Reproduce: Run the execute() method on a prepared query handle in my script. Actual Results: /usr/bin/perl: symbol lookup error: /usr/lib/perl5/vendor_perl/5.8.8/i686-linux-thread-multi/auto/DBD/mysql/mysql.so: undefined symbol: mysql_warning_count I am running perl 5.8.8. DBI is at 1.56. And DBD-mysql is at 4.00.4-r1. Here is the output from emerge --info: Portage 2.1.2.9 (default-linux/x86/2006.1/server, gcc-3.4.6, glibc-2.5-r4, 2.6.12-gentoo-r10 i686)=================================================================System uname: 2.6.12-gentoo-r10 i686 AMD Athlon(tm) MP 1600+Gentoo Base System release 1.12.9Timestamp of tree: Sat, 07 Jul 2007 06:50:01 +0000dev-java/java-config: 1.2.11-r1dev-lang/python: 2.4.4-r4dev-python/pycrypto: 2.0.1-r5sys-apps/sandbox: 1.2.17sys-devel/autoconf: 2.13, 2.61sys-devel/automake: 1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10sys-devel/binutils: 2.17sys-devel/gcc-config: 1.3.16sys-devel/libtool: 1.5.23bvirtual/os-headers: 2.6.17-r2ACCEPT_KEYWORDS="x86"AUTOCLEAN="yes"CBUILD="i686-pc-linux-gnu"CFLAGS="-march=athlon -ggdb -O2 -pipe"CHOST="i686-pc-linux-gnu"CONFIG_PROTECT="/etc"CONFIG_PROTECT_MASK="/etc/env.d /etc/gconf /etc/php/apache1-php4/ext-active/ /etc/php/apache2-php4/ext-active/ /etc/php/cgi-php4/ext-active/ /etc/php/cli-php4/ext-active/ /etc/revdep-rebuild /etc/terminfo"CXXFLAGS="-march=athlon -ggdb -O2 -pipe"DISTDIR="/usr/portage/distfiles"FEATURES="distlocks metadata-transfer sandbox sfperms strict"GENTOO_MIRRORS="http://distfiles.gentoo.org http://www.ibiblio.org/pub/Linux/distributions/gentoo"MAKEOPTS="-j3"PKGDIR="/usr/portage/packages"PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages --filter=H_**/files/digest-*"PORTAGE_TMPDIR="/var/tmp"PORTDIR="/usr/portage"PORTDIR_OVERLAY="/usr/local/portage"SYNC="rsync://rsync.namerica.gentoo.org/gentoo-portage"USE="berkdb bitmap-fonts cli cracklib crypt dri gdbm iconv ipv6 isdnlog ithreads libg++ mailwrapper midi mudflap mysql ncurses nls nptl nptlonly openmp pam pcre perl ppds pppd python readline reflection session snmp spl ssl tcpd threads truetype truetype-fonts type1-fonts unicode vhosts x86 xml xorg zlib" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1 emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mulaw multi null plug rate route share shm softvol" ELIBC="glibc" INPUT_DEVICES="keyboard mouse evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" USERLAND="GNU" VIDEO_CARDS="apm ark chips cirrus cyrix dummy fbdev glint i128 i740 i810 imstt mach64 mga neomagic nsc nv r128 radeon rendition s3 s3virge savage siliconmotion sis sisusb tdfx tga trident tseng v4l vesa vga via vmware voodoo"Unset: CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS, LINGUAS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS
Forgot to mention, Im running MySQL 4.0.27.
Please, state exactly which ebuild and version is this about; reopen then.
Somewhere above I wrote this: "I am running perl 5.8.8. DBI is at 1.56. And DBD-mysql is at 4.00.4-r1." Those are ebuild version numbers. Is that what you mean?
Re-opening so someone can read my last comment.
I unmerged DBD-mysql-4.00.4-r1 and downgraded back to DBD-mysql-3.0008. The problem went away so it looks like the latest version breaks DBI.
I have the same problem. My Bugzilla install was complaining. dev-lang/perl-5.8.8-r2 dev-perl/DBI-1.56 dev-perl/DBD-mysql-4.00.4-r1 Portage 2.1.2.9 (default-linux/x86/no-nptl/2.4, gcc-3.4.6, glibc-2.5-r4, 2.4.34.4 i686) ================================================================= System uname: 2.4.34.4 i686 AMD Athlon(tm) XP 3200+ Gentoo Base System release 1.12.9 Timestamp of tree: Mon, 09 Jul 2007 14:50:01 +0000 ccache version 2.4 [enabled] dev-java/java-config: 1.3.7, 2.0.33-r1 dev-lang/python: 2.3.5-r3, 2.4.4-r4 dev-python/pycrypto: 2.0.1-r5 dev-util/ccache: 2.4-r7 sys-apps/sandbox: 1.2.17 sys-devel/autoconf: 2.13, 2.61 sys-devel/automake: 1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10 sys-devel/binutils: 2.17 sys-devel/gcc-config: 1.3.16 sys-devel/libtool: 1.5.23b virtual/os-headers: 2.4.26-r1 ACCEPT_KEYWORDS="x86" AUTOCLEAN="yes" CBUILD="i686-pc-linux-gnu" CFLAGS="-march=athlon-xp -O2 -pipe -fomit-frame-pointer" CHOST="i686-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/share/X11/xkb /var/bind" CONFIG_PROTECT_MASK="/etc/env.d /etc/env.d/java/ /etc/gconf /etc/php/apache2-php4/ext-active/ /etc/php/cgi-php4/ext-active/ /etc/php/cli-php4/ext-active/ /etc/revdep-rebuild /etc/terminfo" CXXFLAGS="-O2 -mcpu=i686 -pipe" DISTDIR="/usr/portage/distfiles" FEATURES="ccache distlocks fixpackages metadata-transfer parallel-fetch sandbox sfperms strict userfetch userpriv usersandbox" GENTOO_MIRRORS="http://gentoo.osuosl.org/ http://distro.ibiblio.org/gentoo http://www.ibiblio.org/pub/Linux/distributions/gentoo ftp://csociety-ftp.ecn.purdue.edu/pub/gentoo" MAKEOPTS="-j2" PKGDIR="/usr/portage/packages" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages --filter=H_**/files/digest-*" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/usr/local/portage" SYNC="rsync://orby.orb.com/gentoo-portage" USE="3dnow acpi apache2 bash-completion berkdb bitmap-fonts bzip2 chroot clamav clamd cli cracklib crypt ctype curl dri emacs expat fastbuild force-cgi-redirect ftp gd gdbm gif gmp gpm iconv idn imagemagick imap imlib innodb isdnlog java jpeg ldap libg++ libwww logrotate maildir memlimit mhash midi mudflap mule mysql ncurses nls old-linux openmp pam pam_chroot pcre pdo-external pear-db perl php png posix pppd python qt3 qt4 readline reflection samba sasl session sockets spell spl sse ssl tcpd tiff tokenizer truetype truetype-fonts type1 type1-fonts unicode userlocales x86 xml xml2 xorg xsl zlib" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1 emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mulaw multi null plug rate route share shm softvol" ELIBC="glibc" INPUT_DEVICES="keyboard mouse" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" USERLAND="GNU" VIDEO_CARDS="vesa" Unset: CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS, LINGUAS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS
Which versions of mysql are being used to compile against? (I've got DBI-1.56, and DBD-mysql-4.00.4-r1 compiled and passed tests without issue). Adding mysql team to this bug in case they have thoughts.
dev-db/mysql-4.0.27-r1
Would you be willing to try DBD-mysql-4.00.5? I see in the ChangeLog: * Fixed mysql_warning issue < 4.1 (reminers, patches, help from ROAM, (issue 25713) If that works, we can get a stable bug going pretty fast (how fast the arch's stable depends on the arch, but they're usually pretty responsive). Thanks!
Cool, with DBD-mysql-4.00.5, Bugzilla's checksetup doesn't complain.
adding dep to the stable bug, removing mysql-bugs folks since they don't need the extra chatter
DBD-mysql-4.00.5 stable now, closing.
