rpl.rpl_heartbeat_basic fails intermittently on amd64 buildds

Bug #894146 reported by Clint Byrum on 2011-11-23
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
mysql-5.5 (Ubuntu)
High
Unassigned

Bug Description

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.

Changed in mysql-5.5 (Ubuntu):
assignee: nobody → Clint Byrum (clint-fewbar)
milestone: none → precise-alpha-2
importance: Undecided → High
status: New → Confirmed
Martin Pitt (pitti) on 2012-02-06
Changed in mysql-5.5 (Ubuntu):
milestone: precise-alpha-2 → ubuntu-12.04-beta-1
Changed in mysql-5.5 (Ubuntu):
milestone: ubuntu-12.04-beta-1 → ubuntu-12.04-beta-2
tags: added: rls-mgr-p-tracking
Changed in mysql-5.5 (Ubuntu):
milestone: ubuntu-12.04-beta-2 → ubuntu-12.04
Changed in mysql-5.5 (Ubuntu):
milestone: ubuntu-12.04 → none
assignee: Clint Byrum (clint-fewbar) → nobody
Changed in mysql-5.5 (Ubuntu):
status: Confirmed → Fix Committed
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers