Bug #64773 Build tests failing
Submitted: 27 Mar 2012 6:18 Modified: 27 Mar 2012 6:37
Reporter: Nicholas Bamber (OCA) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Compiling Severity:S3 (Non-critical)
Version:5.5.20 OS:Linux (Debian)
Assigned to: CPU Architecture:Any
Tags: ssl mysqlcheck upgrade tests

[27 Mar 2012 6:18] Nicholas Bamber
Description:
Some time ago 5.5.20 was building fine on Debian. On the 22nd of March or possibly a bit earlier a number of tests started to fail. I have not been able to isolate precisely what triggers this. Most of the test failures refer either to failing to run mysqlcheck or SSL issues. If I downgrade the SSL libraries from 1.0.1-2 to 1.0.0h-1 the problem does not go away. If I build in a Wheezy schroot (which currently still has libssl-dev 1.0.0h-1) I still get the issue. I had a machine where it was working but started to fail after I upgraded all the packages to the latest version. The list of failing tests  seems to be consistent for a particular build run - but varies slightly between scenarios.

A list of tests that have failed with the likely looking error follows:

rpl.rpl_mysql_upgrade:
FATAL ERROR: Can't execute '/home/nicholas/debian/svn/pkg-mysql/mysql-5.5/branches/experimental/builddir/client//mysqlcheck'

main.plugin_auth:
FATAL ERROR: Can't execute '/home/nicholas/debian/svn/pkg-mysql/mysql-5.5/branches/experimental/builddir/client//mysqlcheck'

main.ssl_8k_key:
 Variable_name  Value
 -Ssl_cipher     DHE-RSA-AES256-SHA
 +Ssl_cipher     DHE-RSA-AES256-SHA256
 mysqltest: Result length mismatch

main.log_tables_upgrade:
FATAL ERROR: Can't execute '/home/nicholas/debian/svn/pkg-mysql/mysql-5.5/branches/experimental/builddir/client//mysqlcheck'

main.mysql_upgrade:
FATAL ERROR: Can't execute '/home/nicholas/debian/svn/pkg-mysql/mysql-5.5/branches/experimental/builddir/client//mysqlcheck'

main.mysql_upgrade_ssl
FATAL ERROR: Can't execute '/home/nicholas/debian/svn/pkg-mysql/mysql-5.5/branches/experimental/builddir/client//mysqlcheck'

main.mysqladmin:
exec of '/home/nicholas/debian/svn/pkg-mysql/mysql-5.5/branches/experimental/builddir/client//mysqladmin -u root -S /tmp/XyxBqZ8TIw/mysqld.1.sock -P 13000 --sleep=1 --count=2 ping > /home/nicholas/debian/svn/pkg-mysql/mysql-5.5/branches/experimental/builddir/mysql-test/var/tmp/mysqladmin.tmp' failed, error: 1792, status: 7, errno: 2

main.openssl_1:
120326 10:24:29 [Note] X509 ciphers mismatch: should be 'DHE-RSA-AES256-SHA' but is 'DHE-RSA-AES256-SHA256'

perfschema.pfs_upgrade:
-FATAL ERROR: Upgrade failed
+FATAL ERROR: Can't execute '/home/nicholas/debian/svn/pkg-mysql/mysql-5.5/branches/experimental/builddir/client//mysqlcheck'

How to repeat:
Take the 5.5.20 source tarball. Build  including running make test-bt. There may be dependencies on particular versions of related software but I have not identified which.

Suggested fix:
I will be disabling all the failing tests for now.
[27 Mar 2012 6:26] Valeriy Kravchuk
This is a duplicate of Bug #64461.
[27 Mar 2012 6:37] Nicholas Bamber
I don't think this is a duplicate. I can easily work round those SSL issues by running mysql-test-run --record main.openssl_1 . And it appears not actually to be related to the version of SSL - although that is surprising.