MySQL Bugs: #25343: Various test failures when running the ./mysql-test-run

Bug #25343	Various test failures when running the ./mysql-test-run
Submitted:	31 Dec 2006 16:19	Modified:	13 Jun 2009 12:28
Reporter:	Joerg Behrens	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Server: Tests	Severity:	S7 (Test Cases)
Version:	4.1.22, 4.1.24, 5.1.24	OS:	Other (IRIX 6.5.30)
Assigned to:		CPU Architecture:	Any
Tags:	IRIX, Tests, testsuite, timestamp

Description:
The testsuite reports various test failures. I have attached the output from runnning the mysql-test-run script.

Failed 11/340 tests, 96.76% were successful.
mysql-test-run in default mode: *** Failing the test(s): func_time func_timestamp mysqlbinlog2 ps_2myisam ps_3innodb ps_4heap ps_5merge ps_7ndb rpl000002 timezone type_timestamp

What is the reason for skipping tests like func_des_encrypt, func_encrypt, lowercase_table2 + 3, replace and some more?

How to repeat:
Compile 4.1.22 and run "./mysql-test-run --force > test.log"

$ uname -Ra
IRIX64 o2k 6.5 6.5.30m 07202013 IP27
$ cc -v
MIPSpro Compilers: Version 7.4.4m

export CC=c99
export CFLAGS='-O3 -mips4 -Wl,-rpath -Wl,/usr/nekoware/lib -I/usr/nekoware/include -OPT:Olimit=0:roundoff=3  -TARG:platform=IP27:proc=r10000'
export CXXFLAGS="$CFLAGS -LANG:exceptions=OFF -LANG:std=OFF -LANG:libc_in_namespace_std=OFF"
export CPPFLAGS='-I/usr/nekoware/include'
export CXX=CC
export F77=f77
export LDFLAGS='-L/usr/nekoware/lib '
export PKG_CONFIG=/usr/nekoware/bin/pkg-config
export PKG_CONFIG_PATH='/usr/nekoware/lib/pkgconfig'
export PKG_CONFIG_LIBDIR='/usr/nekoware/lib'
export LD_LIBRARY_PATH='/usr/nekoware/lib'
export LD_LIBRARYN32_PATH='/usr/nekoware/lib'
export LD_LIBRARY64_PATH='/usr/nekoware/lib64'
export GNOME2_DIR='/usr/nekoware'
export GNUMAKE='/usr/nekoware/bin/make'
export PATH=/usr/nekoware/bin:$PATH

./configure --with-extra-charsets=complex --enable-thread-safe-client --with-unix-socket-path=/tmp/mysql-4.1.22.sock --without-extra-tools --disable-dependency-tracking --prefix=/tmp/mysql-4.1.22 --with-ndbcluster
gmake -j30 && gmake install
chcap "CAP_SCHED_MGT+epi" /tmp/mysql-4.1.22/libexec/mysqld

Current Timezone on this hosts is:
TZ=:Europe/Berlin
LC_ALL=de_DE

Output from mysql-test-run script

Attachment: test.log (application/octet-stream, text), 71.08 KiB.

Thank you for the report.

Verified as described.

Can you reproduce these errors on any other platform?  We no longer support Irix.

Use mysql-test-run.pl script instead of the default mysql-test-run.sh.

Does the mysql-test-run.pl have a need for DBI and other perl modules or what are the requirements?

regards
Joerg

When running ./mysql-test-run.pl the following tests report an error.

mysql-test-run in default mode: *** Failing the test(s): func_time func_timestamp mysqlbinlog2 ps_2myisam ps_3innodb ps_4heap ps_5merge ps_7ndb rpl000002 timezone type_timestamp
Failed 11/340 tests, 96.76% were successful.

regards
Joerg

Output from Perl Version mysql-test-run.pl

Attachment: results.txt (text/plain), 63.76 KiB.

Joerg, do you think that these problems are just caused by the tests assuming that a particular timezone or are they real bugs? Tested to change TZ to "GMT+3" or are you already in that?

Joerg,

We still need your feedback on TZ. Please, send the results of:

env

from your test environment.

Sorry for the late answer....

[fuel]:/usr/nekoware/mysql4/mysql-test $ export TZ="GMT+3"
echo $TZ                    
GMT+3
mysql-test-run in default mode: *** Failing the test(s): func_time func_timestamp kill mysqlbinlog2 ps_2myisam ps_3innodb ps_4heap ps_5merge rpl000002 timezone type_timestamp

It doesnt matter which TZ is configurated. My default is 

cat /etc/TIMEZONE
#ident  "@(#)sadmin:etc/TIMEZONE        1.2"
#ident  "$Revision: 1.6 $"
#       Set timezone environment to default for the machine
TZ=:Europe/Berlin

Same bad result with some original settings like
SGI_TZ_TAG=cet
TZ=CET-1CEST-2,M3.5.0/2,M10.5.0/3

Please, try to repeat with a newer version, 4.1.23, and inform about the results.

Tested with MySQL Version 4.1.24

Failed 12/317 tests, 96.21% were successful.
mysql-test-run in default mode: *** Failing the test(s): func_time func_timestamp mysqlbinlog2 ps_2myisam ps_3innodb ps_4heap ps_5merge rpl000002 timezone timezone4 type_float type_timestamp

[o3k]:/usr/nekoware-build/mysql4/mysql-test $ echo $TZ
:Europe/Berlin

Testing a recent version which was compiled with GCC instead MipsPro.

Stopping All Servers
Failed 20/835 tests, 97.60% 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 286 times
Spent 3519.371 of 5878 seconds executing testcases

mysql-test-run in default mode: *** Failing the test(s): main.mysql main.mysql_upgrade main.mysqlbinlog2 main.mysqldump main.openssl_1 main.ps_2myisam main.ps_3innodb main.ps_4heap main.ps_5merge main.read_many_rows_innodb main.system_mysql_db_fix50030 main.system_mysql_db_fix50117 main.timezone main.timezone4 main.variables-big rpl.rpl_truncate_7ndb_2 rpl.rpl_mixed_ddl_dml rpl.rpl_truncate_7ndb_2 rpl.rpl_mixed_ddl_dml rpl.rpl_truncate_7ndb_2
mysql-test-run: *** ERROR: there were failing test cases

Complete outout is available under http://www.irixworld.net/mysql/tests/5.1.24_gcc.txt

IRIX is not supprted.