Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 294136 - dev-db/mysql-5.0.84-r1 fails test mysql_client_test
Summary: dev-db/mysql-5.0.84-r1 fails test mysql_client_test
Status: RESOLVED FIXED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: [OLD] Unspecified (show other bugs)
Hardware: x86 Linux
: High normal
Assignee: Gentoo Linux MySQL bugs team
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-11-23 07:37 UTC by Kevin F. Quinn
Modified: 2010-03-24 02:32 UTC (History)
0 users

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


Attachments
Build log (dev-db:mysql-5.0.84-r1:20091123-020605.log,1.30 MB, text/plain)
2009-11-23 07:39 UTC, Kevin F. Quinn
Details
mysql_client_test.out.log referred to by test failure (mysql_client_test.out.log,300.37 KB, text/plain)
2009-11-23 07:41 UTC, Kevin F. Quinn
Details
mysql_client_test.log referred to by test failure (mysql_client_test.log,461 bytes, text/plain)
2009-11-23 07:43 UTC, Kevin F. Quinn
Details
emerge log, USE=latin1 (dev-db:mysql-5.0.84-r1:20100131-154103.log,1.30 MB, text/plain)
2010-01-31 22:17 UTC, Kevin F. Quinn
Details
mysql_client_test.out.log referred to by first test failure (mysql_client_test.out.log,307.33 KB, text/plain)
2010-01-31 22:18 UTC, Kevin F. Quinn
Details
mysql_client_test.log referred to by first test failure (mysql_client_test.log,461 bytes, text/plain)
2010-01-31 22:19 UTC, Kevin F. Quinn
Details
openssl_1.log referred to by second test failure (openssl_1.log,731 bytes, text/plain)
2010-01-31 22:20 UTC, Kevin F. Quinn
Details
output of emerge --info (emerge-info.txt,4.09 KB, text/plain)
2010-01-31 22:21 UTC, Kevin F. Quinn
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Kevin F. Quinn 2009-11-23 07:37:10 UTC
Test summary is:

Failed 1/461 tests, 99.78% were successful.

The log files in var/log may give you some hint
of what went wrong.
If you want to report this error, please read first the documentation at
http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html
The servers were restarted 116 times
Spent 581.253 of 1050 seconds executing testcases

mysql-test-run in ps-protocol mode: *** Failing the test(s): mysql_client_test
mysql-test-run: *** ERROR: there were failing test cases
make: *** [test-ps] Error 1


Snippet from build log:

mysql_client_test              [ fail ]

mysqltest: At line 12: command "$MYSQL_CLIENT_TEST --getopt-ll-test=25600M >> $MYSQLTEST_VARDIR/log/mysql_client_test.out.log 2>&1" failed

The result from queries just before the failure was:
exec of '/var/tmp/portage/dev-db/mysql-5.0.84-r1/work/mysql/tests/mysql_client_test --no-defaults --testcase --user=root --port=10800 --socket=/var/tmp/portage/dev-db/mysql-5.0.84-r1/temp/pV61NT2OxM/master.sock --vardir=/var/tmp/portage/dev-db/mysql-5.0.84-r1/work/mysql/mysql-test/var-ps --getopt-ll-test=25600M >> /var/tmp/portage/dev-db/mysql-5.0.84-r1/work/mysql/mysql-test/var-ps/log/mysql_client_test.out.log 2>&1' failed, error: 256, status: 1, errno: 0

More results from queries before failure can be found in /var/tmp/portage/dev-db/mysql-5.0.84-r1/work/mysql/mysql-test/var-ps/log/mysql_client_test.log


build log & test log to follow

Reproducible: Always




Portage 2.1.6.13 (default/linux/x86/10.0, gcc-4.3.4, glibc-2.9_p20081201-r2, 2.6.30-gentoo-r7 i686)
=================================================================                                  
System uname: Linux-2.6.30-gentoo-r7-i686-AMD_Athlon-tm-_XP_2500+-with-gentoo-1.12.13              
Timestamp of tree: Sun, 22 Nov 2009 16:30:01 +0000                                                 
app-shells/bash:     4.0_p28                                                                       
dev-java/java-config: 2.1.9-r1                                                                     
dev-lang/python:     2.4.6, 2.5.4-r3, 2.6.2-r1                                                     
dev-python/pycrypto: 2.0.1-r6                                                                      
dev-util/cmake:      2.6.4-r3                                                                      
sys-apps/baselayout: 1.12.13                                                                       
sys-apps/sandbox:    1.6-r2                                                                        
sys-devel/autoconf:  2.13, 2.63-r1                                                                 
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.2                      
sys-devel/binutils:  2.18-r3                                                                       
sys-devel/gcc-config: 1.4.1                                                                        
sys-devel/libtool:   2.2.6a                                                                        
virtual/os-headers:  2.6.27-r2                                                                     
ACCEPT_KEYWORDS="x86"                                                                              
CBUILD="i686-pc-linux-gnu"                                                                         
CFLAGS="-O2 -march=athlon-xp -pipe -ggdb2"                                                         
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/config /var/lib/hsqldb"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/env.d/java/ /etc/fonts/fonts.conf /etc/gconf /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo /etc/texmf/language.dat.d /etc/texmf/language.def.d /etc/texmf/updmap.d /etc/texmf/web2c /etc/udev/rules.d"
CXXFLAGS="-O2 -march=athlon-xp -pipe -ggdb2"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoaddcvs collision-protect cvs distlocks fixpackages parallel-fetch pax protect-owned sandbox sfperms sign splitdebug strict test unmerge-orphans userfetch userpriv"
GENTOO_MIRRORS="http://www.mirrorservice.org/sites/www.ibiblio.org/gentoo/ http://gentoo.virginmedia.com/ http://mirror.qubenet.net/mirror/gentoo/"
LANG="en_GB"
LDFLAGS="-Wl,-O1"
LINGUAS="en_GB en it de es fr"
MAKEOPTS="-j1"
PKGDIR="/usr/portage/packages"
PORTAGE_CONFIGROOT="/"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/overlays/tree"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="3dnow X a52 aac acl acpi alsa apache2 audiofile berkdb bluetooth bzip2 cairo caps cdparanoia cdr cli cracklib crypt cups cvs dbus dri dts dv dvb dvd dvdr encode fam ffmpeg firefox flac foomaticdb fortran gcj gdbm gif gnutls gpm gstreamer gtk hal iconv imagemagick imap imlib ipod ipv6 jack java javascript jbig jpeg jpeg2k kde ldap mad mime mmap mmx mng modules mp3 mpeg mplayer mudflap nas ncurses nls nptl nptlonly nsplugin offensive ogg opengl openmp pam pcre pda pdf perl png pppd python qt3 qt4 quicktime readline reflection ruby samba sdl session speex spell spl sse ssl subversion svg sysfs tcl tcpd test theora threads tidy tiff tk truetype unicode usb v4l v4l2 vcd vim-syntax vorbis wifi win32codecs wmf x264 x86 xcomposite xine xinerama xml xmlrpc xorg xulrunner 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 mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="actions alias auth_basic auth_digest authn_anon authn_dbd authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache cgi cgid dav dav_fs dav_lock dbd deflate dir disk_cache env expires ext_filter file_cache filter headers ident imagemap include info log_config logio mem_cache mime mime_magic negotiation proxy proxy_ajp proxy_balancer proxy_connect proxy_http rewrite setenvif so speling status unique_id userdir usertrack vhost_alias" ELIBC="glibc" INPUT_DEVICES="evdev mouse keyboard" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="en_GB en it de es fr" USERLAND="GNU" VIDEO_CARDS="radeon vesa vga radeonhd"
Unset:  CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, LC_ALL, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS
Comment 1 Kevin F. Quinn 2009-11-23 07:39:12 UTC
Created attachment 210953 [details]
Build log
Comment 2 Kevin F. Quinn 2009-11-23 07:41:19 UTC
Created attachment 210955 [details]
mysql_client_test.out.log referred to by test failure
Comment 3 Kevin F. Quinn 2009-11-23 07:43:12 UTC
Created attachment 210956 [details]
mysql_client_test.log referred to by test failure
Comment 4 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2010-01-31 04:45:47 UTC
This slipped away.
Can you try to run it again, w/ USE=latin1.
Also, please test newer ebuilds and see if it persists for you.
Comment 5 Kevin F. Quinn 2010-01-31 22:15:43 UTC
Retried 5.0.84-r1 (latest in my tree - haven't synced for a few days) with USE=latin1.  Two failures; mysql_client_test and openssl_1.

mysql_client_test              [ fail ]
 
mysqltest: At line 12: command "$MYSQL_CLIENT_TEST --getopt-ll-test=25600M >> $MYSQLTEST_VARDIR/log/mysql_client_test.out.log 2>&1" failed

The result from queries just before the failure was:
exec of '/var/tmp/portage/dev-db/mysql-5.0.84-r1/work/mysql/tests/mysql_client_test --no-defaults --testcase --user=root --port=10600 --socket=/var/tmp/portage/dev-db/mysql-5.0.84-r1/temp/MQYTWSELbl/master.sock --vardir=/var/tmp/portage/dev-db/mysql-5.0.84-r1/work/mysql/mysql-test/var-ns --getopt-ll-test=25600M >> /var/tmp/portage/dev-db/mysql-5.0.84-r1/work/mysql/mysql-test/var-ns/log/mysql_client_test.out.log 2>&1' failed, error: 256, status: 1, errno: 0

More results from queries before failure can be found in /var/tmp/portage/dev-db/mysql-5.0.84-r1/work/mysql/mysql-test/var-ns/log/mysql_client_test.log


and

openssl_1                      [ fail ]

mysqltest: At line 24: query 'connect  con2,localhost,ssl_user2,,,,,SSL' failed: 1045: Access denied for user 'ssl_user2'@'localhost' (using password: NO)

The result from queries just before the failure was:
drop table if exists t1;
create table t1(f1 int);
insert into t1 values (5);
grant select on test.* to ssl_user1@localhost require SSL;
grant select on test.* to ssl_user2@localhost require cipher "DHE-RSA-AES256-SHA";
grant select on test.* to ssl_user3@localhost require cipher "DHE-RSA-AES256-SHA" AND SUBJECT "/C=SE/ST=Uppsala/O=MySQL AB/emailAddress=abstract.mysql.developer@mysql.com";
grant select on test.* to ssl_user4@localhost require cipher "DHE-RSA-AES256-SHA" AND SUBJECT "/C=SE/ST=Uppsala/O=MySQL AB/emailAddress=abstract.mysql.developer@mysql.com" ISSUER "/C=SE/ST=Uppsala/L=Uppsala/O=MySQL AB";
grant select on test.* to ssl_user5@localhost require cipher "DHE-RSA-AES256-SHA" AND SUBJECT "xxx";
flush privileges;

More results from queries before failure can be found in /var/tmp/portage/dev-db/mysql-5.0.84-r1/work/mysql/mysql-test/var-ns/log/openssl_1.log


log files to follow.
Comment 6 Kevin F. Quinn 2010-01-31 22:17:37 UTC
Created attachment 218035 [details]
emerge log, USE=latin1
Comment 7 Kevin F. Quinn 2010-01-31 22:18:36 UTC
Created attachment 218037 [details]
mysql_client_test.out.log referred to by first test failure
Comment 8 Kevin F. Quinn 2010-01-31 22:19:27 UTC
Created attachment 218038 [details]
mysql_client_test.log referred to by first test failure
Comment 9 Kevin F. Quinn 2010-01-31 22:20:29 UTC
Created attachment 218040 [details]
openssl_1.log referred to by second test failure
Comment 10 Kevin F. Quinn 2010-01-31 22:21:48 UTC
Created attachment 218042 [details]
output of emerge --info
Comment 11 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2010-01-31 22:25:26 UTC
openssl_1 is a known failure. Upstream's certs expired.

In the old mysql_client_test, subtest #174: test_bug9735:
mysql_client_test.c:785: check failed: 'field->length == expected_field_length'

In the new mysql_client_test, subtest #212: test_bug36326  
mysql_client_test.c:16426: check failed: 'sql_big_selects_5 == sql_big_selects_orig'

So that does confirm that they are doing a bad length estimation where the latin1 length != the utf8 length. But I'm not sure what's with the new failure. Care to poke deeper at that one? You'll probably need to instrument the C w/ printf statements or take a debugger to it.

But I'm strongly considering just disabling that test.
Comment 12 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2010-03-24 02:32:08 UTC
that test is disabled as of 5.0.90* now as a false positive.