[debian-mysql] Bug#554207: mysql-dfsg-5.1: FTBFS with gcc-4.4: binlog tests fail

[Daniel Schepler]

Package: mysql-dfsg-5.1
Version: 5.1.40-1
Severity: important

From my pbuilder build log, using a custom pbuilder chroot with gcc-defaults
changed to point to gcc-4.4:

...
main.xa                                  [ pass ]   1048
main.xa 'InnoDB plugin'                  [ pass ]   1055
binlog.binlog_innodb                     [ fail ]
        Test ended at 2009-11-02 19:12:44

CURRENT_TEST: binlog.binlog_innodb
mysqltest: In included file "./include/show_binlog_events.inc": At line 10: query 'show binlog events from $binlog_start' failed: 1220: Error when executing command SHOW BINLOG EVENTS: Wrong offset or I/O error

The result from queries just before the failure was:
< snip >
SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE;
UPDATE t1 SET b = 4*a WHERE a > 4;
COMMIT;
SET BINLOG_FORMAT=ROW;
BEGIN;
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
UPDATE t1 SET b = 1*a WHERE a > 1;
COMMIT;
BEGIN;
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
UPDATE t1 SET b = 2*a WHERE a > 2;
COMMIT;
BEGIN;
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
UPDATE t1 SET b = 3*a WHERE a > 3;
COMMIT;
BEGIN;
SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE;
UPDATE t1 SET b = 4*a WHERE a > 4;
COMMIT;

More results from queries before failure can be found in /tmp/buildd/mysql-dfsg-5.1-5.1.40/builddir/mysql-test/var/log/binlog_innodb.log

 - saving '/tmp/buildd/mysql-dfsg-5.1-5.1.40/builddir/mysql-test/var/log/binlog.binlog_innodb/' to '/tmp/buildd/mysql-dfsg-5.1-5.1.40/builddir/mysql-test/var/log/binlog.binlog_innodb/'

Retrying test, attempt(2/3)...

binlog.binlog_innodb                     [ retry-fail ]
...
main.multi_update                        [ fail ]
        Test ended at 2009-11-02 19:20:49

CURRENT_TEST: main.multi_update
--- /tmp/buildd/mysql-dfsg-5.1-5.1.40/builddir/mysql-test/r/multi_update.result	2009-11-02 21:59:14.000000000 +0300
+++ /tmp/buildd/mysql-dfsg-5.1-5.1.40/builddir/mysql-test/r/multi_update.reject	2009-11-02 22:20:49.000000000 +0300
@@ -604,7 +604,7 @@
 4	4
 show master status /* there must be the UPDATE query event */;
 File	Position	Binlog_Do_DB	Binlog_Ignore_DB
-master-bin.000001	206		
+master-bin.000001	203		
 delete from t1;
 delete from t2;
 insert into t1 values (1,2),(3,4),(4,4);
@@ -614,7 +614,7 @@
 ERROR 23000: Duplicate entry '4' for key 'PRIMARY'
 show master status /* there must be the UPDATE query event */;
 File	Position	Binlog_Do_DB	Binlog_Ignore_DB
-master-bin.000001	221		
+master-bin.000001	218		
 drop table t1, t2;
 set @@session.binlog_format= @sav_binlog_format;
 drop table if exists t1, t2, t3;

mysqltest: Result content mismatch

 - saving '/tmp/buildd/mysql-dfsg-5.1-5.1.40/builddir/mysql-test/var/log/main.multi_update/' to '/tmp/buildd/mysql-dfsg-5.1-5.1.40/builddir/mysql-test/var/log/main.multi_update/'
The servers were restarted 223 times
Spent 604.757 of 1290 seconds executing testcases

Failed 10/520 tests, 98.08% were successful.

Failing test(s): binlog.binlog_innodb binlog.binlog_killed main.sp_trans_log main.mysql_client_test main.mysqlbinlog main.mysqlbinlog-cp932 main.multi_update

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://dev.mysql.com/doc/mysql/en/mysql-test-suite.html

Too many tests(10) failed! Terminating...
mysql-test-run: *** ERROR: Test suite aborted
make[2]: *** [test-ns] Error 1
make[2]: Leaving directory `/tmp/buildd/mysql-dfsg-5.1-5.1.40/builddir'
make[1]: *** [test-force] Error 2
make[1]: Leaving directory `/tmp/buildd/mysql-dfsg-5.1-5.1.40/builddir'
make: *** [build-stamp] Error 1
dpkg-buildpackage: error: debian/rules build gave error exit status 2

(Also, if I put nocheck in DEB_BUILD_OPTIONS, dpkg-gensymbols fails because
some of the template instantiations have disappeared.)
-- 
Daniel Schepler