MySQL Bugs: #49954: Make test fails for 5.1.41

Bug #49954	Make test fails for 5.1.41
Submitted:	28 Dec 2009 9:57	Modified:	28 Dec 2009 10:55
Reporter:	Dinh Pham	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Tests	Severity:	S7 (Test Cases)
Version:	5.1.41	OS:	Linux (CentOS release 5.3 (Final))
Assigned to:		CPU Architecture:	Any
Tags:	compile, make test, test

Description:
I downloaded MySQL 5.1.41 source code and do a custom build. After executing `make`, I issued `make test` but it failed.

My server info:
===============

+ CentOS release 5.3 (Final)

[root@MobileTV-5 mysql-5.1.41]# uname -a
Linux MobileTV-5 2.6.18-128.el5 #1 SMP Wed Jan 21 10:41:14 EST 2009 x86_64 x86_64 x86_64 GNU/Linux
[root@MobileTV-5 mysql-5.1.41]# free -m
             total       used       free     shared    buffers     cached
Mem:         16044      14106       1938          0        151       6858
-/+ buffers/cache:       7097       8947
Swap:         2047          0       2047

MySQL build configuration 
=========================

CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" \
./configure \
--prefix=/usr/local/mysql51 \
--localstatedir=/usr/local/mysql51/data \
--libexecdir=/usr/local/mysql51/bin \
--libdir=/usr/local/mysql51/lib \
--with-unix-socket-path=/usr/local/mysql51/tmp/mysql.sock \
--with-server-suffix=-max \
--enable-local-infile \
--enable-thread-safe-client \
--enable-assembler \
--with-fast-mutexes \
--enable-shared \
--with-libwrap \
--with-zlib-dir=bundled \
--with-big-tables \
--with-readline \
--with-plugins=innobase,partition \
--with-atomic-ops=smp \
--without-embedded-server \
--with-charset=utf8 \
--with-collation=utf8_general_ci \
--with-client-ldflags=-all-static \
--with-mysqld-ldflags=-all-static \
--with-mysqld-user=mysql

How to repeat:
make
make test

make test log

Attachment: make_test_log.txt (text/plain), 34.54 KiB.

Thank you for the problem report. Please, send the results of:

gcc --version

and then cd to mysql-test subdirectory and run failed test only:

./mysql-test-run.pl mysql_client_test

I'd like to know if it fails alone.

Seems to be duplicate of bug #43347

GCC information
===============

[root@MobileTV-5 mysql51]# gcc -v
Using built-in specs.
Target: x86_64-redhat-linux
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --enable-checking=release --with-system-zlib --enable-__cxa_atexit --disable-libunwind-exceptions --enable-libgcj-multifile --enable-languages=c,c++,objc,obj-c++,java,fortran,ada --enable-java-awt=gtk --disable-dssi --enable-plugin --with-java-home=/usr/lib/jvm/java-1.4.2-gcj-1.4.2.0/jre --with-cpu=generic --host=x86_64-redhat-linux
Thread model: posix
gcc version 4.1.2 20080704 (Red Hat 4.1.2-44)

[root@MobileTV-5 mysql-test]# ./mysql-test-run.pl mysql_client_test
Logging: ./mysql-test-run.pl  mysql_client_test
091228 17:44:17 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

091228 17:44:17 [ERROR] Aborting

MySQL Version 5.1.41
Checking supported features...
 - skipping ndbcluster, mysqld not compiled with ndbcluster
 - skipping SSL, mysqld not compiled with SSL
Collecting tests...
vardir: /usr/local/src/mysql-5.1.41/mysql-test/var
Checking leftover processes...
Removing old var directory...
Creating var directory '/usr/local/src/mysql-5.1.41/mysql-test/var'...
Installing system database...
Using server port 47826

==============================================================================

TEST                                      RESULT   TIME (ms)
------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
worker[1] mysql-test-run: WARNING: running this script as _root_ will cause some tests to be skipped
main.mysql_client_test                   [ fail ]
        Test ended at 2009-12-28 17:44:27

CURRENT_TEST: main.mysql_client_test
mysqltest: At line 14: command "$MYSQL_CLIENT_TEST --getopt-ll-test=25600M >> $MYSQLTEST_VARDIR/log/mysql_client_test.out.log 2>&1" failed

Output from before failure:
exec of '/usr/local/src/mysql-5.1.41/tests/mysql_client_test --defaults-file=/usr/local/src/mysql-5.1.41/mysql-test/var/my.cnf --testcase --vardir=/usr/local/src/mysql-5.1.41/mysql-test/var --getopt-ll-test=25600M >> /usr/local/src/mysql-5.1.41/mysql-test/var/log/mysql_client_test.out.log 2>&1' failed, error: 256, status: 1, errno: 0

The result from queries just before the failure was:
SET @old_general_log= @@global.general_log;

 - saving '/usr/local/src/mysql-5.1.41/mysql-test/var/log/main.mysql_client_test/' to '/usr/local/src/mysql-5.1.41/mysql-test/var/log/main.mysql_client_test/'
------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 10 seconds executing testcases

Failed 1/1 tests, 0.00% were successful.

Failing test(s): main.mysql_client_test

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

mysql-test-run: *** ERROR: there were failing test cases

mysql client test log

Attachment: mysql_client_test.out.log (text/plain), 306.78 KiB.

Thank you for the feedback.

This is duplicate of bug #43347. This is test bug, so you can easily ignore this error or compile MySQL with  --with-charset=all or --with-extra-charsets=complex -