Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!

Bug 308999

Summary: dev-db/mysql-5.0.90-r2 fails tests alter_table fulltext2 ps sp
Product: Gentoo Linux Reporter: Myckel Habets (work) <m.e.j.habets>
Component: [OLD] ServerAssignee: Gentoo Linux MySQL bugs team <mysql-bugs>
Status: RESOLVED FIXED    
Severity: normal CC: bugs.gentoo.devel
Priority: High    
Version: unspecified   
Hardware: x86   
OS: Linux   
Whiteboard:
Package list:
Runtime testing required: ---
Attachments: emerge log file (bzip2 compressed since text file >1000KB)

Description Myckel Habets (work) 2010-03-11 16:16:01 UTC
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
Comment 1 Kevin F. Quinn 2010-03-15 22:45:40 UTC
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
Comment 2 Kevin F. Quinn 2010-03-15 22:49:45 UTC
Created attachment 223809 [details]
emerge log file (bzip2 compressed since text file >1000KB)
Comment 3 Joshua Pettett 2010-03-21 01:50:54 UTC
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.
Comment 4 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2010-03-23 23:51:24 UTC
upstream fixed in the 5.1 series, i'll see about a backport maybe
Comment 5 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2010-03-24 03:39:40 UTC
5.0.90-r2 has a newer patchset with this now, thanks for tracing it.