Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 160284 - dev-db/mysql-5.0.38 - mysql_client_test fails
Summary: dev-db/mysql-5.0.38 - mysql_client_test fails
Status: RESOLVED FIXED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: New packages (show other bugs)
Hardware: All Linux
: High normal (vote)
Assignee: Gentoo Linux MySQL bugs team
URL: http://lists.mysql.com/commits/29168
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-01-05 09:17 UTC by Carsten Lohrke (RETIRED)
Modified: 2007-07-11 09:56 UTC (History)
4 users (show)

See Also:
Package list:
Runtime testing required: ---


Attachments
mysql_client_test.log (mysql_client_test.log,2.05 KB, text/plain)
2007-04-16 10:04 UTC, Carsten Lohrke (RETIRED)
Details
mysql_client_test error log (mysql_client_test.log,456 bytes, text/plain)
2007-04-21 14:19 UTC, John
Details
Client test log (mysql_client_test.log,12.30 KB, text/plain)
2007-04-29 00:32 UTC, John
Details
Fixes the failure during mysql_client_test test. (mysql_client_test-fix.patch,3.92 KB, patch)
2007-06-21 12:04 UTC, Polarina
Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description Carsten Lohrke (RETIRED) gentoo-dev 2007-01-05 09:17:16 UTC
mysql_client_test              [ fail ]

Errors are (from /var/tmp/portage/dev-db/mysql-5.0.26-r2/work/mysql/mysql-test/var/log/mysqltest-time) :
sh: line 1: 11712 Aborted                 /var/tmp/portage/dev-db/mysql-5.0.26-r2/work/mysql/tests/mysql_client_test --no-defaults --testcase --user=root --silent --port=9306 --vardir=/var/tmp/portage/dev-db/mysql-5.0.26-r2/work/mysql/mysql-test/var --socket=/var/tmp/portage/dev-db/mysql-5.0.26-r2/work/mysql/mysql-test/var/tmp/master.sock --getopt-ll-test=25600M >>/var/tmp/portage/dev-db/mysql-5.0.26-r2/work/mysql/mysql-test/var/log/mysql_client_test.log 2>&1
mysqltest: At line 12: command "$MYSQL_CLIENT_TEST --getopt-ll-test=25600M >> $MYSQLTEST_VARDIR/log/mysql_client_test.log 2>&1" failed
(the last lines may be the most important ones)

Killing Possible Leftover Processes
Restoring snapshot of databases
Resuming Tests


looking at the log file, it starts with

/var/tmp/portage/dev-db/mysql-5.0.26-r2/work/mysql/tests/mysql_client_test --no-defaults --testcase --user=root --silent --port=9306 -▒
mysql_client_test.c:3893: check failed: 'rc == 0' 



Portage 2.1.2_rc4-r6 (default-linux/x86/2006.1/desktop, gcc-4.1.1, glibc-2.4-r4, 2.6.18-gentoo-r6 i686)
=================================================================
System uname: 2.6.18-gentoo-r6 i686 AMD Athlon(tm) 64 Processor 3500+
Gentoo Base System version 1.12.6
Last Sync: Fri, 05 Jan 2007 13:50:01 +0000
distcc 2.18.3 i686-pc-linux-gnu (protocols 1 and 2) (default port 3632) [disabled]
ccache version 2.4 [enabled]
dev-java/java-config: 1.3.7, 2.0.30
dev-lang/python:     2.4.3-r4
dev-python/pycrypto: 2.0.1-r5
dev-util/ccache:     2.4-r6
dev-util/confcache:  0.4.2-r1
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.16.1-r3
sys-devel/gcc-config: 1.3.14
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.17-r2
ACCEPT_KEYWORDS="x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-O2 -march=athlon64 -pipe -fforce-addr -mfpmath=sse -funit-at-a-time -msse3 -ftracer"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/share/X11/xkb /usr/share/config"
CONFIG_PROTECT_MASK="/etc/env.d /etc/env.d/java/ /etc/gconf /etc/java-config/vms/ /etc/revdep-rebuild /etc/terminfo /etc/texmf/web2c"
CXXFLAGS="-O2 -march=athlon64 -pipe -fforce-addr -mfpmath=sse -funit-at-a-time -msse3 -ftracer"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig ccache collision-protect cvs digest distlocks fixpackages metadata-transfer parallel-fetch sandbox sfperms splitdebug strict test userfetch userpriv usersandbox"
GENTOO_MIRRORS="ftp://ftp.snt.utwente.nl/pub/os/linux/gentoo http://www.ibiblio.org/pub/Linux/distributions/gentoo"
LANG="de_DE.utf8"
LDFLAGS="-Wl,-O1"
LINGUAS="de"
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                 --exclude-from=/etc/portage/rsync_excludes"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/portage"
SYNC="rsync://rsync.europe.gentoo.org/gentoo-portage"
USE="3dnow 3dnowext X aac acl acpi activefilter alsa apache2 audiofile berkdb bitmap-fonts bzip2 cairo cddb cdparanoia cdr chroot cli cracklib crypt css cups curl dbus dga dlloader doc dvd dvdr eds emacs emboss encode exif faad fam ffmpeg firebird firefox flac fontconfig fortran gcl gd gif glut gphoto2 gpm graphviz hal hbci iconv idl idn imagemagick imap ipv6 isdnlog jack javascript jpeg jpeg2k kde kdehiddenvisibility kipi ladcca lame lcms ldap libg++ lirc lm_sensors lzo mad maildir matroska mbox md5sum mmx mmxext mng mp3 mpeg musepack nas ncurses network nls nptl nptlonly ofx ogg openexr opengl pam pcap pcre perl pg-hier php png postgres ppds pppd python qt3 qt4 quicktime readline reflection rtc ruby samba sasl scanner sdl session skey slp snmp sox spell spl sse sse2 ssl subversion svg svga tcpd tetex theora threads tiff transcode truetype truetype-fonts type1-fonts udev unicode usb vorbis win32codecs wmf x264 x86 xcomposite xerces xine xml xml2 xorg xv xvid yaz zeroconf zlib" ALSA_CARDS="intel8x0" 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" LINGUAS="de" USERLAND="GNU" VIDEO_CARDS="fbdev nvidia vesa"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LC_ALL, PORTAGE_RSYNC_EXTRA_OPTS
Comment 1 Francesco R. (RETIRED) gentoo-dev 2007-01-05 14:24:08 UTC
Hi Carsten,
tried with:
dev-db/mysql-5.0.26-r2  USE="big-tables extraengine perl -berkdb -cluster -debug -embedded -latin1 -max-idx-128 -minimal (-selinux) -ssl -static"
my emerge --info is very similar to your.

Could not reproduce, /var/tmp/portage/dev-db/mysql-5.0.26-r2/work/mysql/tests/mysql_client_test.c
at row 3893 is executing in loop a prepared statment

    rc= mysql_stmt_fetch(stmt);
    check_execute(stmt, rc);

this simple (piece of the) test must not fail .dot.

could you post the exact USE flags used ? I'll try a bit more harder
Comment 2 Carsten Lohrke (RETIRED) gentoo-dev 2007-01-07 18:53:03 UTC
"berkdb perl ssl" are the use flags I have set. Looking at the output again, I suspected --user=root under userpriv might be the problem, so I tried it with FEATURES="-userpriv -usersandbox", but got the same error.
Comment 3 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2007-04-15 13:13:54 UTC
please retest on 5.0.38 and reopen if needed.
Comment 4 Carsten Lohrke (RETIRED) gentoo-dev 2007-04-16 08:08:35 UTC
exactly the same test failure in .38
Comment 5 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2007-04-16 08:32:00 UTC
@carlo: please try saner CFLAGS and CXXFLAGS?

when it fails again, attach the output files from that test? ${WORKDIR}/mysql/mysql-test*/r/mysql_client_test*
Comment 6 Carsten Lohrke (RETIRED) gentoo-dev 2007-04-16 10:04:45 UTC
Created attachment 116412 [details]
mysql_client_test.log

Same with -O2 -pipe, Rob. And there is nothing relevant in the log file I haven't posted in my initial comment already, but well, here it is.
Comment 7 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2007-04-16 10:57:57 UTC
Here's my emerge --info on my core2duo box where it works.
mysql built with "berkdb perl ssl" normally, but it does pass with the full set of USE="cluster extraengine berkdb perl ssl big-table" as well.

The only thing that looks like a direct posibility to me is your glibc-2.4 vs. my glibc-2.5.

Portage 2.1.2.4 (default-linux/amd64/2006.1, gcc-4.1.2, glibc-2.5-r1, 2.6.20-rc4-g9f307859 x86_64)
=================================================================
System uname: 2.6.20-rc4-g9f307859 x86_64 Intel(R) Core(TM)2 CPU 6400 @ 2.13GHz
Gentoo Base System release 1.13.0_alpha12
Timestamp of tree: Unknown
ccache version 2.4 [enabled]
dev-lang/python:     2.4.4
dev-python/pycrypto: 2.0.1-r5
dev-util/ccache:     2.4-r6
sys-apps/sandbox:    1.2.18.1
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.6.20-r2
ACCEPT_KEYWORDS="amd64 ~amd64"
AUTOCLEAN="yes"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-march=nocona -O2 -pipe"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /var/bind"
CONFIG_PROTECT_MASK="/etc/env.d /etc/gconf /etc/php/apache1-php5/ext-active/ /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/terminfo"
CXXFLAGS="-march=nocona -O2 -pipe"
DISTDIR="/home/gentoo/distfiles"
FEATURES="assume-digests autoaddcvs buildpkg ccache collision-protect cvs digest distlocks metadata-transfer mirror parallel-fetch sandbox sfperms splitdebug strict userpriv"
GENTOO_MIRRORS="http://distfiles.gentoo.org http://distro.ibiblio.org/pub/linux/distributions/gentoo"
LINGUAS="en en_CA en_US en_GB en_ZA"
MAKEOPTS="-j4"
PKGDIR="/home/gentoo/packages/grubb-int/"
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="/dev/shm"
PORTDIR="/usr/gentoo-cvs/gentoo-x86"
PORTDIR_OVERLAY="/usr/local/portage"
SYNC=""
USE="aalib acl acpi adns aio alsa amd amd64 apache2 apm berkdb bitmap-fonts cairo cdr cgi clearpasswd cli cracklib crypt cups curl divx4linux dri dvd dvdr encode f77 fam foomaticdb fortran frxp gcj gd gdbm geoip gif glitz gpgme hpn iconv idn imap innodb ipalias ipv6 isdnlog jikes jpeg junit libwww logrotate mad maildir mailwrapper mcal md5sum midi mikmod mp3 mpeg mpm-prefork multicall mysql ncurses nptl nptlonly objc offensive ogg pam pcap pcre pdf pdflib perl pic plotutils png pnp ppds pppd python qmail readline reflection samba scanner session slp smime snmp socks5 spell spl ssl svg tetex tiff truetype truetype-fonts type1 type1-fonts udev ungif unicode usb userlocales v4l v4l2 vhosts vim-syntax vorbis xml xml2 xorg xvid zlib" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci 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="evdev keyboard mouse void" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="en en_CA en_US en_GB en_ZA" USERLAND="GNU" VIDEO_CARDS="dummy fbdev nv v4l vga vesa i810"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS

Comment 8 Dustin Polke 2007-04-17 15:32:53 UTC
I had the same prob. Solved this by adding FEATURES="-userpriv" to emerge this package. This solved it for 5.0.26-r2 and 5.0.38.

BR,
Dustin
Comment 9 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2007-04-17 22:04:55 UTC
wierd that nobody else in the stabilization bug reported mysql_client_test failing with FEATURES=-userpriv, when they did definetly report other ones that I had to change for it.
Comment 10 John 2007-04-21 14:16:30 UTC
I can confirm that 5.0.38 fails on mysql_client_test with and without FEATURES="-userpriv". Attached are emerge --info and error log.


Portage 2.1.2.2 (default-linux/x86/2006.0, gcc-4.1.1, glibc-2.5-r0, 2.6.18-ck1 i686)
=================================================================
System uname: 2.6.18-ck1 i686 Unknown CPU Typ
Gentoo Base System release 1.12.9
Timestamp of tree: Sat, 21 Apr 2007 05:50:01 +0000
dev-java/java-config: 1.3.7, 2.0.31-r5
dev-lang/python:     2.3.5-r3, 2.4.3-r4
dev-python/pycrypto: 2.0.1-r5
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.16.1-r3
sys-devel/gcc-config: 1.3.14
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.8.1-r1, 2.6.17-r2
ACCEPT_KEYWORDS="x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-O2 -march=athlon-xp -mtune=athlon-xp -fomit-frame-pointer -fno-ident -pipe"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/3.3/env /usr/kde/3.3/share/config /usr/kde/3.3/shutdown /usr/kde/3.4/env /usr/kde/3.4/share/config /usr/kde/3.4/shutdown /usr/kde/3.5/env /usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/share/X11/xkb /usr/share/config"
CONFIG_PROTECT_MASK="/etc/env.d /etc/env.d/java/ /etc/gconf /etc/java-config/vms/ /etc/revdep-rebuild /etc/splash /etc/terminfo /etc/texmf/web2c"
CXXFLAGS="-O2 -march=athlon-xp -mtune=athlon-xp -fomit-frame-pointer -fno-ident -pipe -fvisibility-inlines-hidden"
DISTDIR="/usr/portage/distfiles"
FEATURES="distlocks metadata-transfer parallel-fetch sandbox sfperms strict test"
GENTOO_MIRRORS="http://gentoo.osuosl.org/ http://csociety-ftp.ecn.purdue.edu/pub/gentoo/ ftp://ftp.gtlib.cc.gatech.edu/pub/gentoo http://gentoo.netnitco.net http://adelie.polymtl.ca/"
LINGUAS="en"
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://rsync.namerica.gentoo.org/gentoo-portage"
USE="3dnow 3dnowext X aim alsa bash-completion bitmap-fonts boost bzip2 cddb cdr cli cpudetection cracklib cscope css cups dbus dga divx4linux dri dvd dvdr dvdread eds emboss encode expat ffmpeg flac foomaticdb fortran gdbm ggi gif gimpprint gstreamer gtk gtk2 iconv id3 imagemagick imlib isdnlog jbig jpeg jpeg2k kdeenablefinal kdgraphics lame ldap libwww lzo mad memlimit midi mikmod mmx mmx2 mmxext motif mp3 mpeg mpeg2 mudflap musicbrainz ncurses network nls nptl nptlonly nsplugin nvidia offensive ogg opengl oscar pam pcre pdf perl png pppd python qt3 qt4 quicktime readline real reflection ruby sdl session spell spl sse ssl tcltk tcpd test tetex theora truetype truetype-fonts type1-fonts usb userlocales videos vorbis win32codecs x86 xml xorg xprint xv xvid 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" LINGUAS="en" USERLAND="GNU" VIDEO_CARDS="nvidia vesa"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS
Comment 11 John 2007-04-21 14:19:22 UTC
Created attachment 116901 [details]
mysql_client_test error log
Comment 12 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2007-04-21 20:19:15 UTC
John: in your attachment there it didn't even run the test.

So now we have the following results:
With FEATURES=-userpriv, we have 1 report that the bug goes away, and two reports that it's still there.
Comment 13 Dustin Polke 2007-04-21 21:02:20 UTC
I see that this seems to be a bit more complicated than I have expected. So I post my emerge --info. Maybe this helps to track down the bug.

Portage 2.1.2.2 (default-linux/x86/2007.0, gcc-4.1.1, glibc-2.5-r0, 2.6.18-gentoo-r6.agp3 i686)
=================================================================
System uname: 2.6.18-gentoo-r6.agp3 i686 mobile AMD Athlon(tm) XP 1500+
Gentoo Base System release 1.12.9
Timestamp of tree: Sat, 21 Apr 2007 11:20:01 +0000
ccache version 2.4 [enabled]
dev-java/java-config: 1.3.7, 2.0.31-r5
dev-lang/python:     2.4.3-r4
dev-python/pycrypto: 2.0.1-r5
dev-util/ccache:     2.4-r6
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.16.1-r3
sys-devel/gcc-config: 1.3.15-r1
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.17-r2
ACCEPT_KEYWORDS="x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-march=athlon-xp -O2 -pipe -m3dnow -msse -mmmx"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/share/X11/xkb"
CONFIG_PROTECT_MASK="/etc/env.d /etc/env.d/java/ /etc/gconf /etc/java-config/vms/ /etc/php/apache1-php5/ext-active/ /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/splash /etc/terminfo /etc/texmf/web2c"
CXXFLAGS="-march=athlon-xp -O2 -pipe -m3dnow -msse -mmmx"
DISTDIR="/usr/portage/distfiles"
FEATURES="ccache collision-protect distlocks fixpackages metadata-transfer parallel-fetch sandbox sfperms strict test userfetch usersandbox"
GENTOO_MIRRORS="ftp://ftp-stud.fht-esslingen.de/pub/Mirrors/gentoo/ ftp://pandemonium.tiscali.de/pub/gentoo/ ftp://linux.rz.ruhr-uni-bochum.de/gentoo-mirror/ ftp://gd.tuwien.ac.at/opsys/linux/gentoo/ ftp://gentoo.inode.at/source/"
LANG="en_US.UTF-8"
LINGUAS="en de"
MAKEOPTS="-j3"
PKGDIR="/usr/portage/packages"
PORTAGE_COMPRESS=""
PORTAGE_RSYNC_EXTRA_OPTS="--timeout=500"
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/modified /usr/local/portage/own /usr/local/portage/layman/webapps-experimental /usr/local/portage/layman/science /usr/local/portage/layman/pda"
SYNC="rsync://rsync.europe.gentoo.org/gentoo-portage"
USE="3dnow 3dnowext X Xaw3d a52 aac aalib acpi alsa amr amrr apache2 apm asf async audacious audiofile bash-completion bindist bl bonobo bzip2 cap cardbus cjk cli cracklib crypt ctype cups dba dbus dga dlloader dri dvd dvdread eds encode evo exif expat extensions fam fbcon ffmpeg flac foomaticdb force-cgi-redirect fortran ftp gd gdbm gif gimpprint glibc-omitfp glut gs gstreamer gtk gtk2 gtkhtml guile hal icq idn imagemagick imap imlib iproute2 java javascript jikes jpeg jpeg2k kerberos lcms ldap libcaca libg++ libwww live lm_sensors logrotate lzo mad madwifi memlimit mikmod mime mjpeg mmx mmxext mng motif moznocompose moznoirc moznomail moznoroaming mp3 mp4 mpeg musepack mysql nas ncurses nls nntp nptl nptlonly nsplugin ogg opengl pam pam_timestamp pcmcia pcre pda pdf perl php plotutils png posix postgres print python qt3support qt4 quicktime readline real ruby samba sasl sdl seamonkey server session simplexml slang smbkrb5passwd sndfile soap sockets sox speex spell spl sse ssl suhosin svga swat symlink syslog tcltk tcpd test tetex theora tiff truetype unicode usb userlocales vcd vim-with-x vorbis wifi win32codecs winbind wma wmf x264 x86 xanim xine xinetd xml xorg xosd xpm xsl xv xvid zlib" ALSA_CARDS="via82xx via82xx-modem mpu401" 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" LINGUAS="en de" USERLAND="GNU" VIDEO_CARDS="savage"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LC_ALL, LDFLAGS, PORTAGE_COMPRESS_FLAGS
Comment 14 John 2007-04-21 21:47:39 UTC
Seems I posted the wrong file...  What is the correct path to the error log?

(In reply to comment #12)
> John: in your attachment there it didn't even run the test.
> 
> So now we have the following results:
> With FEATURES=-userpriv, we have 1 report that the bug goes away, and two
> reports that it's still there.
> 

Comment 15 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2007-04-21 22:23:16 UTC
correct path is:
${WORKDIR}/mysql/mysql-test*/r/mysql_client_test*

compare it to files in /t/ with diff if you want.
Comment 16 John 2007-04-29 00:32:53 UTC
Created attachment 117609 [details]
Client test log

Test log.
Comment 17 John 2007-04-29 00:36:27 UTC
Link to build log.

http://johnis.boldlygoingnowhere.org/build.log
Comment 18 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2007-05-11 08:40:09 UTC
please retest on 5.0.40
Comment 19 Carsten Lohrke (RETIRED) gentoo-dev 2007-05-11 20:38:56 UTC
.40 fails too, content of r/mysql_client_test.log is

exec of '/var/tmp/portage/dev-db/mysql-5.0.40/work/mysql/tests/mysql_client_test --no-defaults --testcase --user=root --port=10450 --socket=/var/tmp/portage/dev-db/mysql-5.0.40/work/mysql/mysql-test/var/tmp/master.sock --vardir=/var/tmp/portage/dev-db/mysql-5.0.40/work/mysql/mysql-test/var --getopt-ll-test=25600M >> /var/tmp/portage/dev-db/mysql-5.0.40/work/mysql/mysql-test/var/log/mysql_client_test.log 2>&1 failed, error: 34304, status: 134, errno: 0
Comment 20 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2007-05-13 01:05:37 UTC
ok, I reproduced it after I borrowed access to a friend's x86 system.
That's the only arch it seems to exist on of the ones that I have access to.
I'll try to trace it more.
Comment 21 Christian Faulhammer (RETIRED) gentoo-dev 2007-06-11 09:04:07 UTC
Even with your change applied (line 3893: add "fprintf(stderr,"stmt:%x sqlstate:%s\n",stmt,mysql_stmt_sqlstate(stmt));"), I get the following error message in test-ns:

mysql_client_test              [ fail ]

Errors are (from /var/tmp/portage/dev-db/mysql-5.0.42/work/mysql/mysql-test/var/log/mysqltest-time) :
sh: line 1: 17246 Aborted                 /var/tmp/portage/dev-db/mysql-5.0.42/work/mysql/tests/mysql_client_test --no-defaults --testcase --user=root --port=10860 --socket=/var/tmp/portage/dev-db/mysql-5.0.42/work/mysql/mysql-test/var/tmp/master.sock --vardir=/var/tmp/portage/dev-db/mysql-5.0.42/work/mysql/mysql-test/var --getopt-ll-test=25600M >> /var/tmp/portage/dev-db/mysql-5.0.42/work/mysql/mysql-test/var/log/mysql_client_test.log 2>&1
mysqltest: At line 12: command "$MYSQL_CLIENT_TEST --getopt-ll-test=25600M >> $MYSQLTEST_VARDIR/log/mysql_client_test.log 2>&1" failed

And in ps-test:


mysql_client_test              [ fail ]

Errors are (from /var/tmp/portage/dev-db/mysql-5.0.42/work/mysql/mysql-test/var/log/mysqltest-time) :
sh: line 1:  7082 Aborted                 /var/tmp/portage/dev-db/mysql-5.0.42/work/mysql/tests/mysql_client_test --no-defaults
 --testcase --user=root --port=10860 --socket=/var/tmp/portage/dev-db/mysql-5.0.42/work/mysql/mysql-test/var/tmp/master.sock --
vardir=/var/tmp/portage/dev-db/mysql-5.0.42/work/mysql/mysql-test/var --getopt-ll-test=25600M >> /var/tmp/portage/dev-db/mysql-
5.0.42/work/mysql/mysql-test/var/log/mysql_client_test.log 2>&1
mysqltest: At line 12: command "$MYSQL_CLIENT_TEST --getopt-ll-test=25600M >> $MYSQLTEST_VARDIR/log/mysql_client_test.log 2>&1"
 failed

tarball to be found at http://dev.gentoo.org/~opfer/mysql.tar.bz2
Comment 22 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2007-06-11 09:08:57 UTC
The change was to add more useful debugging output, not a fix.
Comment 23 Polarina 2007-06-21 12:04:54 UTC
Created attachment 122688 [details, diff]
Fixes the failure during mysql_client_test test.

Tada.! The patch is done, tested and working. :)
Comment 24 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2007-06-21 12:14:54 UTC
Official upstream patch here:
http://lists.mysql.com/commits/29168
Comment 25 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2007-07-11 09:56:04 UTC
Patch that Polarina backported is now applied for 5.0.44.
It should be in the upstream 5.0.46 as well.