[debian-mysql] Bug#672535: mysql-testsuite-5.5: child process mysql utilities picking up local config files causes test failure

[Nicholas Bamber]

Package: mysql-client-5.5
Version: 5.5.23-2
Severity: minor
Tags: upstream

Dear Maintainer,
*** Please consider answering these questions, where appropriate ***

    * What led up to the situation?
I removed the Debian patches disabling various tests to
investigate those the test failures.

    * What exactly did you do (or not do) that was effective (or
      ineffective)?
Five tests failed one of them being: main.plugin_auth
I reran that test and inspected the log file.
Based upon that I captured the output of

strace -f 
/home/nicholas/debian/svn/pkg-mysql/mysql-5.5/branches/unstable/builddir/client//mysql_upgrade 
--defaults-file=/home/nicholas/debian/svn/pkg-mysql/mysql-5.5/branches/unstable/builddir/mysql-test/var/my.cnf

The output is attached. It shows that mysql_upgrade forks a
mysqlcheck process and as far as mysql_upgrade goes everything is in
order. However inspection of the trace log coming from the
child process shows that it is reading locally stored config files
as opposed to test specific config files. Hence it is not surprising 
that we get test failures.

This is the most juicy extract from the strace log:
[pid 16994] stat64("/usr/etc/my.cnf", 0xbfd4c290) = -1 ENOENT (No such 
file or directory)
[pid 16994] stat64("/home/nicholas/.my.cnf", {st_mode=S_IFREG|0644, 
st_size=100, ...}) = 0
[pid 16994] open("/home/nicholas/.my.cnf", O_RDONLY|O_LARGEFILE) = 4

Although I view this as essentially a minor build test failure, I 
believe it could affect end users depending on how they are trying to 
manage their config files.


*** End of the template - remove these lines ***


-- System Information:
Debian Release: wheezy/sid
   APT prefers unstable
   APT policy: (500, 'unstable'), (500, 'testing'), (1, 'experimental')
Architecture: i386 (i686)

Kernel: Linux 3.2.0-1-686-pae (SMP w/1 CPU core)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages mysql-testsuite-5.5 depends on:
ii  libc6                            2.13-32
ii  libgcc1                          1:4.6.2-16
ii  libstdc++6                       4.6.2-16
ii  mysql-client                     5.5.23-2
ii  mysql-client-5.5 [mysql-client]  5.5.23-2
ii  mysql-server                     5.5.23-2

mysql-testsuite-5.5 recommends no packages.

mysql-testsuite-5.5 suggests no packages.

-- no debconf information
-------------- next part --------------
A non-text attachment was scrubbed...
Name: strace-f.log
Type: text/x-log
Size: 47870 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20120511/a28f756d/attachment-0001.bin>