emerging dev-db/mysql-5.0.90-r2 with FEATURE="test" fails at 4 tests: alter_table fulltext2 ps sp Reproducible: Always Steps to Reproduce: 1. emerge -u --deep mysql Actual Results: Test fail with following output: --- /var/tmp/portage/dev-db/mysql-5.0.90-r2/work/mysql/mysql-test/r/alter_table.result 2010-01-15 13:13:39.000000000 +0300 +++ /var/tmp/portage/dev-db/mysql-5.0.90-r2/work/mysql/mysql-test/r/alter_table.reject 2010-03-11 15:18:28.000000000 +0300 @@ -84,7 +84,7 @@ UNLOCK TABLES; OPTIMIZE TABLE t1; Table Op Msg_type Msg_text -test.t1 optimize status OK +test.t1 optimize status Table is already up to date DROP TABLE t1; create table t1 (i int unsigned not null auto_increment primary key); insert into t1 values (null),(null),(null),(null); @@ -291,11 +291,11 @@ t1 1 b 1 b A 100 NULL NULL YES BTREE analyze table t1; Table Op Msg_type Msg_text -test.t1 analyze status OK +test.t1 analyze status Table is already up to date show keys from t1; Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment -t1 0 a 1 a A 3 NULL NULL YES BTREE -t1 0 a 2 b A 300 NULL NULL YES BTREE +t1 0 a 1 a A NULL NULL NULL YES BTREE +t1 0 a 2 b A NULL NULL NULL YES BTREE t1 1 b 1 b A 100 NULL NULL YES BTREE drop table t1; CREATE TABLE t1 (i int(10), index(i) ); mysqltest: Result content mismatch --- /var/tmp/portage/dev-db/mysql-5.0.90-r2/work/mysql/mysql-test/r/fulltext2.result 2010-01-15 13:13:39.000000000 +0300 +++ /var/tmp/portage/dev-db/mysql-5.0.90-r2/work/mysql/mysql-test/r/fulltext2.reject 2010-03-11 15:21:41.000000000 +0300 @@ -12,7 +12,7 @@ test.t1 check status OK optimize table t1; Table Op Msg_type Msg_text -test.t1 optimize status OK +test.t1 optimize status Table is already up to date check table t1; Table Op Msg_type Msg_text test.t1 check status OK mysqltest: Result content mismatch --- /var/tmp/portage/dev-db/mysql-5.0.90-r2/work/mysql/mysql-test/r/ps.result 2010-01-15 13:13:40.000000000 +0300 +++ /var/tmp/portage/dev-db/mysql-5.0.90-r2/work/mysql/mysql-test/r/ps.reject 2010-03-11 15:31:07.000000000 +0300 @@ -1337,7 +1337,7 @@ prepare stmt from "optimize table t1"; execute stmt; Table Op Msg_type Msg_text -test.t1 optimize status OK +test.t1 optimize status Table is already up to date execute stmt; Table Op Msg_type Msg_text test.t1 optimize status Table is already up to date @@ -1362,9 +1362,9 @@ prepare stmt from "optimize table t1, t2, t3"; execute stmt; Table Op Msg_type Msg_text -test.t1 optimize status OK -test.t2 optimize status OK -test.t3 optimize status OK +test.t1 optimize status Table is already up to date +test.t2 optimize status Table is already up to date +test.t3 optimize status Table is already up to date execute stmt; Table Op Msg_type Msg_text test.t1 optimize status Table is already up to date @@ -1397,8 +1397,8 @@ prepare stmt from "optimize table t1, t3, t4"; execute stmt; Table Op Msg_type Msg_text -test.t1 optimize status OK -test.t3 optimize status OK +test.t1 optimize status Table is already up to date +test.t3 optimize status Table is already up to date test.t4 optimize Error Table 'test.t4' doesn't exist test.t4 optimize status Operation failed execute stmt; mysqltest: Result content mismatch --- /var/tmp/portage/dev-db/mysql-5.0.90-r2/work/mysql/mysql-test/r/sp.result 2010-01-15 13:13:40.000000000 +0300 +++ /var/tmp/portage/dev-db/mysql-5.0.90-r2/work/mysql/mysql-test/r/sp.reject 2010-03-11 15:38:05.000000000 +0300 @@ -4371,9 +4371,9 @@ test.v1 repair Error 'test.v1' is not BASE TABLE test.v1 repair error Corrupt Table Op Msg_type Msg_text -test.t1 optimize status OK -test.t2 optimize status OK -test.t3 optimize status OK +test.t1 optimize status Table is already up to date +test.t2 optimize status Table is already up to date +test.t3 optimize status Table is already up to date test.v1 optimize Error 'test.v1' is not BASE TABLE test.v1 optimize error Corrupt Table Op Msg_type Msg_text @@ -4390,9 +4390,9 @@ test.v1 repair Error 'test.v1' is not BASE TABLE test.v1 repair error Corrupt Table Op Msg_type Msg_text -test.t1 optimize status OK -test.t2 optimize status OK -test.t3 optimize status OK +test.t1 optimize status Table is already up to date +test.t2 optimize status Table is already up to date +test.t3 optimize status Table is already up to date test.v1 optimize Error 'test.v1' is not BASE TABLE test.v1 optimize error Corrupt Table Op Msg_type Msg_text @@ -4409,9 +4409,9 @@ test.v1 repair Error 'test.v1' is not BASE TABLE test.v1 repair error Corrupt Table Op Msg_type Msg_text -test.t1 optimize status OK -test.t2 optimize status OK -test.t3 optimize status OK +test.t1 optimize status Table is already up to date +test.t2 optimize status Table is already up to date +test.t3 optimize status Table is already up to date test.v1 optimize Error 'test.v1' is not BASE TABLE test.v1 optimize error Corrupt Table Op Msg_type Msg_text mysqltest: Result content mismatch Expected Results: mysql installed/upgraded without failed tests. # emerge --info Portage 2.1.7.17 (default/linux/x86/10.0, gcc-4.3.4, glibc-2.10.1-r1, 2.6.33-rc8-co-0.8.0 i686) ================================================================= System uname: Linux-2.6.33-rc8-co-0.8.0-i686-Intel-R-_Pentium-R-_4_CPU_3.20GHz-with-gentoo-1.12.13 Timestamp of tree: Thu, 11 Mar 2010 11:15:02 +0000 app-shells/bash: 4.0_p35 dev-lang/python: 2.6.4-r1, 3.1.1-r1 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.9.6-r2, 1.10.3, 1.11.1 sys-devel/binutils: 2.18-r3 sys-devel/gcc: 4.3.4 sys-devel/gcc-config: 1.4.1 sys-devel/libtool: 2.2.6b virtual/os-headers: 2.6.30-r1 ACCEPT_KEYWORDS="x86" ACCEPT_LICENSE="* -@EULA" CBUILD="i686-pc-linux-gnu" CFLAGS="-O2 -mtune=i686 -pipe" CHOST="i686-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/share/X11/xkb" CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/fonts/fonts.conf /etc/gconf /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo" CXXFLAGS="-O2 -mtune=i686 -pipe" DISTDIR="/usr/portage/distfiles" FEATURES="assume-digests collision-protect distlocks fixpackages news parallel-fetch protect-owned sandbox sfperms strict test unmerge-logs unmerge-orphans userfetch userpriv" GENTOO_MIRRORS="ftp://ftp.ucsb.edu/pub/mirrors/linux/gentoo/ ftp://mirror.datapipe.net/gentoo" LDFLAGS="-Wl,-O1,--as-needed" 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/portage" SYNC="rsync://rsync.europe.gentoo.org/gentoo-portage" USE="X berkdb bzip2 cgi cleartype cli cracklib crypt cxx dbus dri fastcgi fortran gdbm gpm hal iconv ipv6 jpeg libnotify logrotate mmx modules mudflap mysql ncurses nptl nptlonly openmp pam pcre pdf perl php pic png posix pppd python readline reflection session spl sqlite sse sse2 ssl startup-notification svg sysfs tcpd threads thunar tiff truetype unicode x86 xcb xcomposite 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 mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="actions alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias" ELIBC="glibc" INPUT_DEVICES="keyboard mouse evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" RUBY_TARGETS="ruby18" USERLAND="GNU" VIDEO_CARDS="vesa" Unset: CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, LANG, LC_ALL, LINGUAS, MAKEOPTS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS
me too # emerge --info Portage 2.1.7.17 (default/linux/x86/10.0, gcc-4.3.4, glibc-2.10.1-r1, 2.6.31-gentoo-r6 i686) ================================================================= System uname: Linux-2.6.31-gentoo-r6-i686-AMD_Athlon-tm-_XP_2500+-with-gentoo-1.12.13 Timestamp of tree: Sat, 13 Mar 2010 12:00:23 +0000 app-shells/bash: 4.0_p35 dev-java/java-config: 2.1.10 dev-lang/python: 2.4.6, 2.5.4-r3, 2.6.4-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-r3, 1.10.3, 1.11.1 sys-devel/binutils: 2.18-r3 sys-devel/gcc: 3.3.6-r1, 3.4.6-r2, 4.1.2, 4.3.4 sys-devel/gcc-config: 1.4.1 sys-devel/libtool: 2.2.6b virtual/os-headers: 2.6.30-r1 ACCEPT_KEYWORDS="x86" ACCEPT_LICENSE="* -@EULA dlj-1.1 sun-bcla-java-vm" CBUILD="i686-pc-linux-gnu" CFLAGS="-O2 -march=athlon-xp -pipe" CHOST="i686-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/share/X11/xkb /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" DISTDIR="/usr/portage/distfiles" FEATURES="assume-digests autoaddcvs collision-protect cvs distlocks fixpackages news parallel-fetch pax protect-owned sandbox sfperms sign strict test unmerge-logs 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 arts audiofile berkdb bluetooth bzip2 cairo caps cdparanoia cdr cli cracklib crypt cups cvs cxx 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 jadetex 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 qt4 quicktime readline reflection ruby samba sdl semantic-desktop 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" RUBY_TARGETS="ruby18" 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
Created attachment 223809 [details] emerge log file (bzip2 compressed since text file >1000KB)
Though it was on a different version and OS, this problem seems to have appeared elsewhere: http://bugs.mysql.com/bug.php?id=31171 I don't know if the fix from that bug report (i.e. removing the bool typecast for state->changed from myisam/mi_open.c) is correct, but manually implementing it allowed all of the tests in mysql-5.0.90-r2 to pass on my system.
upstream fixed in the 5.1 series, i'll see about a backport maybe
5.0.90-r2 has a newer patchset with this now, thanks for tracing it.