Bug #49985 MySQL 5.1 Compile on Debian 5.0 64 bit fails make test
Submitted: 30 Dec 2009 4:52 Modified: 20 Jun 2011 12:15
Reporter: Michael Pelletier Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Tests Severity:S7 (Test Cases)
Version:5.1 OS:Linux (Debian 5.0 64 bit)
Assigned to: CPU Architecture:Any

[30 Dec 2009 4:52] Michael Pelletier
Description:
After compiling MySQL 5.1 on debian 5.0 on a 64 bit OS fails "make test". I see other people had this problem but I can not find the fix. Could someone help?

main.information_schema_chmod            [ fail ]
        Test ended at 2009-12-29 23:21:14

CURRENT_TEST: main.information_schema_chmod
--- /usr/local/Source/MySQL/mysql-5.1.41/mysql-test/r/information_schema_chmod.result	2009-11-04 22:01:14.000000000 +0300
+++ /usr/local/Source/MySQL/mysql-5.1.41/mysql-test/r/information_schema_chmod.reject	2009-12-30 07:21:14.000000000 +0300
@@ -2,4 +2,5 @@
 create table mysqltest.t1(a int);
 select table_schema from information_schema.tables where table_schema='mysqltest';
 table_schema
+mysqltest
 drop database mysqltest;

mysqltest: Result length mismatch

 - saving '/usr/local/Source/MySQL/mysql-5.1.41/mysql-test/var/log/main.information_schema_chmod/' to '/usr/local/Source/MySQL/mysql-5.1.41/mysql-test/var/log/main.information_schema_chmod/'

Only  587  of 920 completed.
mysql-test-run: *** ERROR: Not all tests completed
make: *** [test-ns] Error 1

How to repeat:
On Debian 5.0 64 bit run:

#!/bin/sh

BUILD_DIR=/usr/local/Servers/MySQL

CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti"  ./configure --prefix=$BUILD_DIR \
    --enable-assembler \
    --with-mysqld-ldflags=-all-static

make

make test

make test will fail with the info above.
[30 Dec 2009 4:53] Michael Pelletier
Interestingly, building MySQL 5.0 on the same system passes the "make test" tests.
[30 Dec 2009 7:59] Sveta Smirnova
Thank you for the report.

I can not repeat described behavior. Please run this test alone (cd mysql-test; ./mtr information_schema_chmod ), then if it fails send us directory mysql-test/var compressed.

Please also indicate if you run tests as root.
[31 Jan 2010 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[23 Jun 2010 10:50] Joerg Bruehe
For the record:

Unless the bug reporter confirms he was working as a normal user,
I suspect this is just another case of bug#51271:
This test *must* fail if the suite is run by the root user.

All other failures of this test I have seen were either more general server/machine problems,
or they were specific to i5/OS (bug#48952).
[20 Jun 2011 12:15] Joerg Bruehe
No comment on this for almost a year, so I must assume the test was really run as "root" user.
As I wrote in my last comment, this will cause the test to fail.

So this is "Not a Bug".

For further information, see the comments with bug#51271.