| Bug #59494 | rpl.rpl_heartbeat_2slaves fails intermittently in PB2 | ||
|---|---|---|---|
| Submitted: | 14 Jan 2011 8:40 | Modified: | 9 Feb 2011 21:17 |
| Reporter: | Jørgen Løland | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S3 (Non-critical) |
| Version: | 5.5 | OS: | Any |
| Assigned to: | Serge Kozlov | CPU Architecture: | Any |
[14 Jan 2011 8:40]
Jørgen Løland
[14 Jan 2011 11:59]
Luis Soares
Symptom:
rpl.rpl_heartbeat_2slaves w5 [ exp-fail ]
Test ended at 2011-01-11 17:24:43
CURRENT_TEST: rpl.rpl_heartbeat_2slaves
mysqltest: In included file "./include/wait_for_status_var.inc": At line 68:
The result from queries just before the failure was:
< snip >
Slave has received heartbeat event
slave_2 has received heartbeat event
slave_1 has received more heartbeats than slave_2 (1 means 'yes'): 0
include/rpl_stop_slaves.inc
include/rpl_change_topology.inc [new topology=1->3->2]
include/rpl_start_slaves.inc
**** 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
2 root localhost:43789 test Sleep 60 NULL
3 root localhost:43790 test Sleep 181 NULL
6 root localhost:43806 test Query 0 NULL SHOW PROCESSLIST
7 system user NULL Connect 60 Waiting for master to send event NULL
8 system user NULL Connect 60 Slave has read all relay log; waiting for the slave I/O thread to update it NULL
The excerpt was taken from:
http://pb2.norway.sun.com/web.py?template=mysql_show_test_failure&search=yes&push_id=18951...
[14 Jan 2011 12:02]
Luis Soares
This might be the same problem as described in BUG#58525 (which is already fixed and pushed).
[2 Feb 2011 20:49]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/130278 3298 Serge Kozlov 2011-02-02 Bug#43828, Bug#59494. After introducing new way of initialization of replication the setting different heartbeat periods for slaves was missed. The patch fix it.
[4 Feb 2011 11:00]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/130388 3301 Serge Kozlov 2011-02-04 Bug#43828, Bug#59494. After introducing new way of initialization of replication the setting different heartbeat periods for slaves was missed. Added asserts
[4 Feb 2011 15:26]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/130440 3301 Serge Kozlov 2011-02-04 Bug#43828, Bug#59494. After introducing new way of initialization of replication the setting different heartbeat periods for slaves was missed. Added asserts
[4 Feb 2011 16:37]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/130458 3301 Serge Kozlov 2011-02-04 Bug#43828, Bug#59494. After introducing new way of initialization of replication the setting different heartbeat periods for slaves was missed. Added asserts
[4 Feb 2011 19:09]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/130477 3303 Serge Kozlov 2011-02-04 Bug#43828, Bug#59494. After introducing new way of initialization of replication the setting different heartbeat periods for slaves was missed. Added asserts
[4 Feb 2011 19:44]
Bugs System
Pushed into mysql-trunk 5.6.2 (revid:serge.kozlov@oracle.com-20110204194042-uyruc8dx9maxhrun) (version source revid:serge.kozlov@oracle.com-20110204194042-uyruc8dx9maxhrun) (merge vers: 5.6.2) (pib:24)
[4 Feb 2011 19:45]
Bugs System
Pushed into mysql-5.5 5.5.10 (revid:serge.kozlov@oracle.com-20110204190748-7klee4l972ybtxri) (version source revid:serge.kozlov@oracle.com-20110204190748-7klee4l972ybtxri) (merge vers: 5.5.10) (pib:24)
[5 Feb 2011 9:39]
Jon Stephens
Test change only, nothing to document for users. Closed without further action.
[9 Feb 2011 21:17]
Jon Stephens
Set back to Closed; see my previous comment.
