Bug #57514 rpl_delayed_slave fails sporadically in pb
Submitted: 18 Oct 2010 10:26
Reporter: Alfranio Junior Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.6.x OS:Any
Assigned to: Assigned Account CPU Architecture:Any
Tags: experimental, replication

[18 Oct 2010 10:26] Alfranio Junior
Description:
rpl_delayed_slave fails sporadically in pb:

. http://tinyurl.com/2cf73xz

Assertion text: 'Status should be 'Has read all relay log...''
Assertion condition: '"[SHOW SLAVE STATUS, Slave_SQL_Running_State, 1]" LIKE "Slave has read all relay log%"'
Assertion condition, interpolated: '"Reading event from the relay log" LIKE "Slave has read all relay log%"'
Assertion result: '0'

.  http://tinyurl.com/24znfj8

-Slave_SQL_Running_State='Slave has read all relay log; waiting for the slave I/O thread to update it'; SQL_Remaining_Delay is NULL; SQL thread is in sync with IO thread
+Slave_SQL_Running_State='Reading event from the relay log'; SQL_Remaining_Delay is NULL; SQL thread is in sync with IO thread
 Checking that both slave threads are running.

The output is a little bit different because the test case was redesigned in BUG#56442. However, in both cases, the status returned by the "SHOW SLAVE STATUS" should be 'Slave has read all relay log' but 'Reading event from the relay log' is returned.

How to repeat:
See 
  . http://tinyurl.com/2cf73xz
  .  http://tinyurl.com/24znfj8
[13 Nov 2010 16:23] Bugs System
Pushed into mysql-trunk 5.6.99-m5 (revid:alexander.nozdrin@oracle.com-20101113155825-czmva9kg4n31anmu) (version source revid:vasil.dimov@oracle.com-20100629074804-359l9m9gniauxr94) (merge vers: 5.6.99-m4) (pib:21)
[13 Nov 2010 16:32] Bugs System
Pushed into mysql-next-mr (revid:alexander.nozdrin@oracle.com-20101113160336-atmtmfb3mzm4pz4i) (version source revid:vasil.dimov@oracle.com-20100629074804-359l9m9gniauxr94) (pib:21)