Public bug reported:

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.

** Affects: mysql-5.5 (Ubuntu)
     Importance: High
     Assignee: Clint Byrum (clint-fewbar)
         Status: Confirmed

** Changed in: mysql-5.5 (Ubuntu)
     Assignee: (unassigned) => Clint Byrum (clint-fewbar)

** Changed in: mysql-5.5 (Ubuntu)
    Milestone: None => precise-alpha-2

** Changed in: mysql-5.5 (Ubuntu)
   Importance: Undecided => High

** Changed in: mysql-5.5 (Ubuntu)
       Status: New => Confirmed

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/894146

Title:
  rpl.rpl_heartbeat_basic fails intermittently on amd64 buildds

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.5/+bug/894146/+subscriptions

-- 
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to