[debian-mysql] Bug#485043: mysql-dfsg-5.0: FTBFS: Test failures (address found for not_existing_host)

[Daniel Schepler]

Package: mysql-dfsg-5.0
Version: 5.0.51a-6
Severity: serious

From my pbuilder build log:

...
/usr/bin/make force=--force test
make[2]: Entering directory `/tmp/buildd/mysql-dfsg-5.0-5.0.51a'
cd mysql-test ; \
        /usr/bin/perl ./mysql-test-run.pl --force
Logging: ./mysql-test-run.pl --force
MySQL Version 5.0.51
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 IM_PORT               = 9312
Using IM_MYSQLD1_PORT       = 9313
Using IM_MYSQLD2_PORT       = 9314
Killing Possible Leftover Processes
Removing Stale Files
Creating Directories
Installing Master Database
Installing Master Database
Installing Slave1 Database
Installing Master Cluster
Saving snapshot of installed databases
=======================================================
Starting Tests in the 'main' suite

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

alias                          [ pass ]             12
alter_table-big                [ skipped ]   Test need 'big-test' option
alter_table                    [ pass ]            224
analyse                        [ pass ]             27
analyze                        [ pass ]             16
ansi                           [ pass ]              7
...
mysql                          [ fail ]

--- /tmp/buildd/mysql-dfsg-5.0-5.0.51a/mysql-test/r/mysql.result        2008-01-11 18:23:39.000000000 
+0300
+++ /tmp/buildd/mysql-dfsg-5.0-5.0.51a/mysql-test/var/log/mysql.reject  2008-06-07 
10:36:04.000000000 +0300
@@ -162,8 +162,8 @@
 ERROR 1049 (42000) at line 1: Unknown database 'invalid'
 Test connect with dbname + hostname
 Test connect with dbname + _invalid_ hostname
-ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'invalid_hostname' (errno)
-ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'invalid_hostname' (errno)
+ERROR 2003 (HY000) at line 1: Can't connect to MySQL server on 'invalid_hostname' (errno)
+ERROR 2003 (HY000) at line 1: Can't connect to MySQL server on 'invalid_hostname' (errno)
 The commands reported in the bug report
 ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'cyril has found a 
bug :)XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX' 
(errno)
 Too long dbname

mysqltest: Result content mismatch

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

mysql_client_test              [ pass ]           9457
mysql_protocols                [ pass ]             87
mysql_upgrade                  [ fail ]

--- /tmp/buildd/mysql-dfsg-5.0-5.0.51a/mysql-test/r/mysql_upgrade.result       2008-01-11 
18:23:39.000000000 +0300
+++ /tmp/buildd/mysql-dfsg-5.0-5.0.51a/mysql-test/var/log/mysql_upgrade.reject 2008-06-07 
10:39:26.000000000 +0300
@@ -58,7 +58,7 @@
 mysql.user                                         OK
 DROP USER mysqltest1@'%';
 Run mysql_upgrade with a non existing server socket
-mysqlcheck: Got error: 2005: Unknown MySQL server host 'not_existing_host' (errno) when trying to 
connect
+mysqlcheck: Got error: 2003: Can't connect to MySQL server on 'not_existing_host' (errno) when 
trying to connect
 FATAL ERROR: Upgrade failed
 set GLOBAL sql_mode='STRICT_ALL_TABLES,ANSI_QUOTES,NO_ZERO_DATE';
 mysql.columns_priv                                 OK

mysqltest: Result content mismatch

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

mysqladmin                     [ pass ]             39
...
xa                             [ pass ]             11
-------------------------------------------------------
Stopping All Servers
Failed 2/484 tests, 99.59% 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://www.mysql.com/doc/en/MySQL_test_suite.html
The servers were restarted 116 times
Spent 1087.922 of 2346 seconds executing testcases

mysql-test-run in default mode: *** Failing the test(s): mysql mysql_upgrade
mysql-test-run: *** ERROR: there were failing test cases
make[2]: *** [test-ns] Error 1
make[2]: Leaving directory `/tmp/buildd/mysql-dfsg-5.0-5.0.51a'
make[1]: *** [test-force] Error 2
make[1]: Leaving directory `/tmp/buildd/mysql-dfsg-5.0-5.0.51a'
make: *** [build-stamp] Error 1
dpkg-buildpackage: failure: debian/rules build gave error exit status 2

On my host, I get:

...
daniel at frobnitz:~$ host not_existing_host
not_existing_host has address 24.28.193.9
Host not_existing_host not found: 3(NXDOMAIN)
Host not_existing_host not found: 3(NXDOMAIN)
daniel at frobnitz:~$ ping not_existing_host
PING not_existing_host (24.28.193.9) 56(84) bytes of data.
^C64 bytes from 24.28.193.9: icmp_seq=1 ttl=41 time=84.4 ms

--- not_existing_host ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 84.424/84.424/84.424/0.000 ms

(On an unrelated note, I can't reproduce the test failures reported in
#474893.)
-- 
Daniel Schepler