Re: Mysql-5.1.23-alpha all tests fail

From: David Favor <david(at)davidfavor.com>
Date: Fri Sep 07 2007 - 15:13:00 EDT

Chad MILLER wrote:

> 
> On 7 Sep 2007, at 10:07, David Favor wrote:
> 
>> Chad MILLER wrote:

>>> On 7 Sep 2007, at 00:01, David Favor wrote:

>>>> I've been wrestling with this all day... tracing scripts...
>>>> and have yet to figure out the problem.
>>>>
>>>> I suspect 'make test' is just broken and requires additional
>>>> parameters passed to mysql-test-run.
>>>>
>>>> Suggestions appreciated.

>>> Hi David. I don't know of any problems. The first thing I'd do is
>>> check the log files in directory "mysql-test/var/log/". There's
>>> bound to be some useful information there. Tell us what you discover
>>> the problem is, in any case. We could possibly improve something, at
>>> least in giving better reasons why it failed or anticipating problems.
>>> - chad

Ah... My confusion was between setting mysqld user and actually running the tests as root vs. non-root using su.

I removed my tree, did a fresh clone + autorun.sh and the following commands and did get farther and now have a new set of errors.

cd /build/work/mysql-5.23-alpha
unset CDPATH
export CC='gcc'
export CXX='gcc'
export CFLAGS='-pipe -O6 -g -fno-strict-aliasing -fwrapv -fomit-frame-pointer' export CXXFLAGS='-pipe -O6 -g -fno-strict-aliasing -fwrapv -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'
export LDFLAGS='-L/lib64 -L/usr/lib64 -ltermcap' make distclean
bkf pull
./configure --prefix=/common/pkgs/mysql-5.23-alpha --with-mysqld-user=mysql

--with-unix-socket-path=/common/pkgs/mysql-5.23-alpha/mysql.sock --enable-shared 
--enable-thread-safe-client --with-assembler --with-plugins=all --with-comment=mysql-5.23-alpha 
--without-docs --with-server --with-embedded-server --with-bench --with-extra-tools 
--enable-local-infile --with-pstack --with-fast-mutexes --with-libwrap --with-ssl --with-readline 
--with-extra-charsets=all --enable-largefile --with-big-tables

make
export MTR_BUILD_THREAD=7
su -c 'cd ./mysql-test && ./mysql-test-run.pl --mem' mysql

... produces the following errors ...

net1#su -c 'cd ./mysql-test && ./mysql-test-run.pl --mem' mysql Logging: ./mysql-test-run.pl --mem
070907 13:51:16 [ERROR] Can't find messagefile '/build/work/mysql-5.23-alpha/sql/share/english/errmsg.sys' 070907 13:51:16 [Warning] Can't create test file /build/work/mysql-5.23-alpha/sql/share/english/net1.lower-test 070907 13:51:16 [Warning] Can't create test file /build/work/mysql-5.23-alpha/sql/share/english/net1.lower-test /build/work/mysql-5.23-alpha/sql/mysqld: Can't change dir to '/build/work/mysql-5.23-alpha/sql/share/english/' (Errcode: 13) MySQL Version 5.1.23
Using binlog format 'mixed'
Using tmpfs in /dev/shm
Using ndbcluster when necessary, mysqld supports it Setting mysqld to support SSL connections

Using MTR_BUILD_THREAD      = 0
Using MASTER_MYPORT         = 9306
Using MASTER_MYPORT1        = 9307
Using SLAVE_MYPORT          = 9308
Using SLAVE_MYPORT1         = 9309
Using SLAVE_MYPORT2         = 9310
Using NDBCLUSTER_PORT       = 9310
Using NDBCLUSTER_PORT_SLAVE = 9311
Using IM_PORT               = 9312
Using IM_MYSQLD1_PORT       = 9313
Using IM_MYSQLD2_PORT       = 9314

mysql-test-run: *** ERROR: can't open file "/build/work/mysql-5.23-alpha/mysql-test/suite/rpl/t/rpl_invoked_features-master.opt": Permission denied

... and forcing a run as root dies the same way ...

net1#su -c 'cd ./mysql-test && ./mysql-test-run.pl --mem --user=root' mysql Logging: ./mysql-test-run.pl --mem --user=root 070907 13:51:48 [ERROR] Can't find messagefile '/build/work/mysql-5.23-alpha/sql/share/english/errmsg.sys' 070907 13:51:48 [Warning] Can't create test file /build/work/mysql-5.23-alpha/sql/share/english/net1.lower-test 070907 13:51:48 [Warning] Can't create test file /build/work/mysql-5.23-alpha/sql/share/english/net1.lower-test /build/work/mysql-5.23-alpha/sql/mysqld: Can't change dir to '/build/work/mysql-5.23-alpha/sql/share/english/' (Errcode: 13) MySQL Version 5.1.23
Using binlog format 'mixed'
Using tmpfs in /dev/shm
Using ndbcluster when necessary, mysqld supports it Setting mysqld to support SSL connections

Using MTR_BUILD_THREAD      = 0
Using MASTER_MYPORT         = 9306
Using MASTER_MYPORT1        = 9307
Using SLAVE_MYPORT          = 9308
Using SLAVE_MYPORT1         = 9309
Using SLAVE_MYPORT2         = 9310
Using NDBCLUSTER_PORT       = 9310
Using NDBCLUSTER_PORT_SLAVE = 9311
Using IM_PORT               = 9312
Using IM_MYSQLD1_PORT       = 9313
Using IM_MYSQLD2_PORT       = 9314

mysql-test-run: *** ERROR: can't open file "/build/work/mysql-5.23-alpha/mysql-test/suite/rpl/t/rpl_invoked_features-master.opt": Permission denied

net1#ll /build/work/mysql-5.23-alpha/mysql-test/suite/rpl/t/rpl_invoked_features-master.opt -r--r----- 1 nfsnobody nfsnobody 9 2007-06-27 07:44 /build/work/mysql-5.23-alpha/mysql-test/suite/rpl/t/rpl_invoked_features-master.opt net1#id nfsnobody
uid=4294967294(nfsnobody) gid=4294967294(nfsnobody) groups=4294967294(nfsnobody)

The problem appears to be some file permissions being set to nfsnobody.

Can you post the exact commands you use to compile and test as this seems so broken some other set of commands must be required to run the test suite.

Thanks.

-- 
Love feeling your best ever, all day, every day?
Email join@RadicalHealth.com for the easy way.

-- 
MySQL Internals Mailing List
For list archives: 
http://lists.mysql.com/internals
To unsubscribe:    
http://lists.mysql.com/internals?unsub=lists@pantek.com

Received on Fri Sep 7 15:13:57 2007