* >>> Test phase [test]: dev-db/mysql-4.0.24-r1 cd mysql-test ; ./mysql-test-run Installing Test Databases Removing Stale Files Installing Master Databases running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/master-data --skip-innodb --skip-bdb --skip-warnings --language=../sql/share/english/ 050429 20:20:19 ../sql/mysqld: Shutdown Complete Installing Slave Databases running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/slave-data --skip-innodb --skip-bdb --skip-warnings --language=../sql/share/english/ 050429 20:20:19 ../sql/mysqld: Shutdown Complete Manager disabled, skipping manager start. Loading Standard Test Databases Starting Tests TEST RESULT ------------------------------------------ alias [ pass ] ... lots of passes... some skips... errors [ pass ] explain [ pass ] flush [ fail ] Errors are (from /var/tmp/portage/mysql-4.0.24-r1/work/mysql-4.0.24/mysql-test/var/log/mysqltest-time) : /var/tmp/portage/mysql-4.0.24-r1/work/mysql-4.0.24/client/.libs/mysqltest: At line 67: query 'insert into t1 values (345)' failed: 2013: Lost connection to MySQL server during query ./mysql-test-run: line 615: 1041 Killed $@ >>$CUR_MYERR 2>&1 (wd: /var/tmp/portage/mysql-4.0.24-r1/work/mysql-4.0.24) (the last line(s) may be the ones that caused the die() in mysqltest) Aborting: flush failed. To continue, re-run with '--force'. Ending Tests Shutting-down MySQL daemon master not cooperating with mysqladmin, will try manual kill ./mysql-test-run: line 1138: kill: (1051) - No such process master refused to die. Sending SIGKILL ./mysql-test-run: line 1142: kill: (1051) - No such process Master shutdown finished Slave shutdown finished make: *** [test] Error 1 !!! ERROR: dev-db/mysql-4.0.24-r1 failed. !!! Function src_test, Line 297, Exitcode 2 !!! make test failed !!! If you need support, post the topmost build error, NOT this status message. emerge --info: Portage 2.0.51.20-r5 (default-linux/x86/2004.2/gcc34, gcc-3.4.3-20050110, glibc-2.3.5-r0, 2.6.12-rc1 i686) ================================================================= System uname: 2.6.12-rc1 i686 Intel(R) Pentium(R) 4 CPU 3.00GHz Gentoo Base System version 1.6.9 distcc 2.18.3 i686-pc-linux-gnu (protocols 1 and 2) (default port 3632) [disabled] ccache version 2.3 [disabled] dev-lang/python: 2.2.3-r5, 2.3.5 sys-apps/sandbox: 1.2.2 sys-devel/autoconf: 2.13, 2.59-r6 sys-devel/automake: 1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.5 sys-devel/binutils: 2.15.92.0.2-r8 sys-devel/libtool: 1.5.16 virtual/os-headers: 2.6.11 ACCEPT_KEYWORDS="x86 ~x86" AUTOCLEAN="yes" CBUILD="i686-pc-linux-gnu" CFLAGS="-march=pentium4 -O2 -pipe -g2 -ggdb2" CHOST="i686-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/kde/2/share/config /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/share/config /usr/lib/X11/xkb /usr/share/config /var/qmail/control" CONFIG_PROTECT_MASK="/etc/gconf /etc/terminfo /etc/env.d" CXXFLAGS="-march=pentium4 -O2 -pipe -g2 -ggdb2" DISTDIR="/usr/portage/distfiles" FEATURES="autoconfig collision-protect cvs digest distlocks fixpackages nostrip sandbox sfperms sign strict test userpriv usersandbox" GENTOO_MIRRORS="http://ftp.snt.utwente.nl/pub/os/linux/gentoo http://ftp.gentoo.skynet.be/pub/gentoo/ http://ftp.uni-erlangen.de/pub/mirrors/gentoo http://mirrors.sec.informatik.tu-darmstadt.de/gentoo http://ftp.easynet.nl/mirror/gentoo/" MAKEOPTS="-j4" PKGDIR="/usr/portage/packages" PORTAGE_TMPDIR="/var/tmp" USE="X a52 alsa apache2 avi bitmap-fonts bonobo cdr crypt cscope curl dba debug dedicated dga disablexmb dts dvd emboss encode ethereal faad fam fastcgi fbcon ffmpeg flac font-server freetds freetype gd gdbm gif gpm graphviz gstreamer gtk gtk2 imagemagick imlib ipv6 jikes jpeg libwww mad matroska mcal memlimit mikmod mmx mmxext motif mozilla mp3 mpeg mpi mysql mythtv ncurses nls nocd ogg oggvorbis opengl pam pdflib perl plotutils png pnp qt quicktime readline samba sdl slang snmp sse sse2 ssl svga tcltk tcpd tiff truetype truetype-fonts trusted type1-fonts unicode usb userlocales vorbis wmf wxwindows x86 xml xml2 xmms xosd xv xvid zlib" Unset: ASFLAGS, CTARGET, LANG, LC_ALL, LDFLAGS, LINGUAS, PORTDIR_OVERLAY
flush passed for me, but key_diff failed key_diff [ fail ] Errors are (from /var/tmp/portage/mysql-4.0.24-r1/work/mysql-4.0.24/mysql-test/var/log/mysqltest-time) : /var/tmp/portage/mysql-4.0.24-r1/work/mysql-4.0.24/client/.libs/mysqltest: At line 20: Result content mismatch (the last line(s) may be the ones that caused the die() in mysqltest) Below are the diffs between actual and expected results: ------------------------------------------------------- *** r/key_diff.result Sat Mar 5 03:55:26 2005 --- r/key_diff.reject Sun May 15 00:15:20 2005 *************** *** 35,42 **** a a a a explain select t1.*,t2.* from t1,t1 as t2 where t1.A=t2.B; table type possible_keys key key_len ref rows Extra ! t1 ALL a NULL NULL NULL 5 ! t2 ALL b NULL NULL NULL 4 Using where select t1.*,t2.* from t1,t1 as t2 where t1.A=t2.B order by binary t1.a,t2.a; a b a b A B a a --- 35,42 ---- a a a a explain select t1.*,t2.* from t1,t1 as t2 where t1.A=t2.B; table type possible_keys key key_len ref rows Extra ! t2 ALL b NULL NULL NULL 5 ! t1 ALL a NULL NULL NULL 4 Using where select t1.*,t2.* from t1,t1 as t2 where t1.A=t2.B order by binary t1.a,t2.a; a b a b A B a a ------------------------------------------------------- Please follow the instructions outlined at http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html to find the reason to this problem and how to report this. Test key_diff failed!
I can't reproduce this with identical glibc/gcc. kernel is 2.6.10-gentoo-r4.
Since MySQL 4.0.25 is in the tree. And the addressing of these failures seem difficult. Going to close this. Feel free to reopen if you need specifically this version. In that case we can work toghether to discover/fix the problem.
Confirmed to work with 4.0.25-r1.