rpl.rpl_heartbeat_basic fails intermittently on amd64 buildds

[Clint Byrum]

rpl.rpl_heartbeat_2slaves 'stmt' [ pass ] 7278
rpl.rpl_heartbeat_basic 'mix' [ fail ]
        Test ended at 2011-11-23 19:02:44

CURRENT_TEST: rpl.rpl_heartbeat_basic
mysqltest: In included file "./include/wait_for_status_var.inc":
included from ./include/wait_for_status_var.inc at line 88:
At line 88:

The result from queries just before the failure was:
< snip >
SELECT * FROM t1 ORDER BY a;
a b
1 on master
2 on slave
**** ERROR: failed while waiting for slave_received_heartbeats > 0 ****
Note: the following output may have changed since the failure was detected
**** Showing STATUS, PROCESSLIST ****
SHOW STATUS LIKE 'slave_received_heartbeats';
Variable_name Value
Slave_received_heartbeats 0
SHOW PROCESSLIST;
Id User Host db Command Time State Info
1 root localhost test Sleep 78 NULL
2 root localhost:47917 test Query 0 NULL SHOW PROCESSLIST
3 root localhost:47918 test Sleep 77 NULL
4 root localhost:47919 test Sleep 60 NULL
5 root localhost:47920 test Sleep 77 NULL
8 system user NULL Connect 60 Waiting for master to send event NULL
9 system user NULL Connect 60 Slave has read all relay log; waiting for the slave I/O thread to update it NULL
10 root localhost:47954 NULL Binlog Dump 60 Master has sent all binlog to slave; waiting for binlog to be updated NULL

More results from queries before failure can be found in /build/buildd/mysql-5.5-5.5.17/builddir/mysql-test/var/log/rpl_heartbeat_basic.log

 - saving '/build/buildd/mysql-5.5-5.5.17/builddir/mysql-test/var/log/rpl.rpl_heartbeat_basic-mix/' to '/build/buildd/mysql-5.5-5.5.17/builddir/mysql-test/var/log/rpl.rpl_heartbeat_basic-mix/'

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

rpl.rpl_heartbeat_basic 'mix' [ retry-fail ]
        Test ended at 2011-11-23 19:04:38

CURRENT_TEST: rpl.rpl_heartbeat_basic
mysqltest: In included file "./include/wait_for_status_var.inc":
included from ./include/wait_for_status_var.inc at line 88:
At line 88:

The result from queries just before the failure was:
< snip >
SELECT * FROM t1 ORDER BY a;
a b
1 on master
2 on slave
**** ERROR: failed while waiting for slave_received_heartbeats > 0 ****
Note: the following output may have changed since the failure was detected
**** Showing STATUS, PROCESSLIST ****
SHOW STATUS LIKE 'slave_received_heartbeats';
Variable_name Value
Slave_received_heartbeats 0
SHOW PROCESSLIST;
Id User Host db Command Time State Info
1 root localhost test Sleep 77 NULL
2 root localhost:48013 test Query 0 NULL SHOW PROCESSLIST
3 root localhost:48014 test Sleep 77 NULL
4 root localhost:48015 test Sleep 60 NULL
5 root localhost:48016 test Sleep 76 NULL
8 system user NULL Connect 60 Waiting for master to send event NULL
9 system user NULL Connect 60 Slave has read all relay log; waiting for the slave I/O thread to update it NULL
10 root localhost:48020 NULL Binlog Dump 60 Master has sent all binlog to slave; waiting for binlog to be updated NULL

More results from queries before failure can be found in /build/buildd/mysql-5.5-5.5.17/builddir/mysql-test/var/log/rpl_heartbeat_basic.log

 - saving '/build/buildd/mysql-5.5-5.5.17/builddir/mysql-test/var/log/rpl.rpl_heartbeat_basic-mix/' to '/build/buildd/mysql-5.5-5.5.17/builddir/mysql-test/var/log/rpl.rpl_heartbeat_basic-mix/'

Test rpl.rpl_heartbeat_basic has failed 2 times, no more retries!

rpl.rpl_heartbeat_basic 'row' [ skipped ] Doesn't support --binlog-format='row'

Test will remain disabled in the build until the problem is identified, though I suspect timeouts need to be raised.