MySQL Bugs: #59728: MySql test suite failed

Bug #59728	MySql test suite failed
Submitted:	25 Jan 2011 21:42	Modified:	1 Feb 2011 11:15
Reporter:	Alex Galitsky	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: Tests	Severity:	S3 (Non-critical)
Version:	5.5.8	OS:	Other (CentOS 5.5 (Final))
Assigned to:		CPU Architecture:	Any

Description:
Good day

I had build MySql 5.5.8 from the source code and ran test suite with --force option. It had failed several tests and after 475 tests failed due to timeout issue
I will attach file with log tests messages
Could you take a look, please

Thank you

How to repeat:
I am not sure if it is possible to replicate in your environment
I ran that test suite twice and got same result each time

Hardware is Dell Dimension E521 with 250 GB HD and 2 GM RAM
OS is CentOS 5.5 with all latest updates and patches

Results of "perl mysql-test-run.pl --force | tee testResults.txt" command

Attachment: testResults.txt (text/plain), 197.75 KiB.

Please, check if these tests

rpl.rpl_innodb_bug28430 
rpl.rpl_typeconv

also fail when run individually:

./mtr rpl.rpl_typeconv

File with 2 failed tests

Attachment: MySql - two failed tests.txt (text/plain), 66.26 KiB.

Hi Valeriy,

just add file with 2 test results
Both had filed :-(

Please, send the output of:

gcc --version

Also, how exactly you built from source? I'd like to see all commands used.

# gcc --version
gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-48)
Copyright (C) 2006 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

How I build the database:

Installing m4 Macro Processor 
You should do it before installing Bison

wget ftp://ftp.gnu.org/gnu/m4/m4-1.4.15.tar.gz
tar -xvzf m4-1.4.15.tar.gz
cd m4-1.4.15
./configure --prefix=/usr/local/m4
make
make install

---
Installing Bison (GNU Parser Generator). Install m4 Macro Processor before it. 

wget http://ftp.gnu.org/gnu/bison/bison-2.4.tar.gz
tar -xvzf bison-2.4.tar.gz
cd bison-2.4
export PATH=$PATH:/usr/local/m4/bin/
./configure --prefix=/usr/local/bison
make
make install

---
Install CMake

wget http://www.cmake.org/files/v2.8/cmake-2.8.3.tar.gz
tar -xvzf cmake-2.8.3.tar.gz
cd cmake-2.8.3
./configure --prefix=/opt/cmake

make
make test
24/173 Test  #24: FindPackageTest ........................***Failed    1.86 sec
        Start  25: FindModulesExecuteAll

make install

---
Install libaio

It is already installed

---
Instaling MySql

wget http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.8.tar.gz/from/http://mysql.llarian....
tar xvzf mysql-5.5.8.tar.gz
cd mysql-5.5.8

/opt/cmake/bin/cmake . 	-DMYSQL_DATADIR=/mysql/mysql-5.5.8/data/ \
	-DCMAKE_INSTALL_PREFIX=/mysql/mysql-5.5.8 \
	-DWITH_DEBUG=OFF

make
make test
make install

cd /mysql/mysql-5.5.8/mysql-test

nohup perl mysql-test-run.pl --force |  tee testResults.txt

I can not repeat this neither on Mac OS X (same gcc version) nor on 32-bit Ubuntu 10.04. Looks like something CentOS/RedHat-specific.

Funny thing is - I build MySql from source code on another CentOS box and ran test suite there - all tests completed successfully 
That other box is HP Proliant 585 though

Could it be hardware-related. May be Dell Dimension E521 is having some hardware limitations?

Anyhow, it is one of our test boxes, so if you can not recreate such scenario please close the case

Thank you for quick response and good job you had done

Alex Galitsky

Looks like something related to CPUs (AMD Opteron in HP and, probably, Athlon in Dell) and gcc version used. 

I can surely close this as "Can't repeat" now, but for other users who may have similar problem would you, please, send the output of

cat /proc/cpuinfo

from the Dell box where you see test suite failures.

# cat /proc/cpuinfo

processor       : 0
vendor_id       : AuthenticAMD
cpu family      : 15
model           : 107
model name      : AMD Athlon(tm) 64 X2 Dual Core Processor 3600+
stepping        : 1
cpu MHz         : 1000.000
cache size      : 512 KB
physical id     : 0
siblings        : 2
core id         : 0
cpu cores       : 2
apicid          : 0
fpu             : yes
fpu_exception   : yes
cpuid level     : 1
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt rdtscp lm 3dnowext 3dnow pni cx16 lahf_lm cmp_legacy svm extapic cr8_legacy misalignsse
bogomips        : 2004.17
TLB size        : 1024 4K pages
clflush size    : 64
cache_alignment : 64
address sizes   : 40 bits physical, 48 bits virtual
power management: ts fid vid ttp tm stc 100mhzsteps

processor       : 1
vendor_id       : AuthenticAMD
cpu family      : 15
model           : 107
model name      : AMD Athlon(tm) 64 X2 Dual Core Processor 3600+
stepping        : 1
cpu MHz         : 1000.000
cache size      : 512 KB
physical id     : 0
siblings        : 2
core id         : 1
cpu cores       : 2
apicid          : 1
fpu             : yes
fpu_exception   : yes
cpuid level     : 1
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt rdtscp lm 3dnowext 3dnow pni cx16 lahf_lm cmp_legacy svm extapic cr8_legacy misalignsse
bogomips        : 8607882.99
TLB size        : 1024 4K pages
clflush size    : 64
cache_alignment : 64
address sizes   : 40 bits physical, 48 bits virtual
power management: ts fid vid ttp tm stc 100mhzsteps

gcc version on both servers is the same

       gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-48)

May I ask - what scenario are those failed scripts testing?

I couldn't repeat on Ubuntu/Windows with source tree.