Bug #57514 rpl_delayed_slave fails sporadically in pb

• Submitted: 18 Oct 2010 10:26
• Reporter: Alfranio Tavares Correia Junior
• Status: Verified
• 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 Tavares Correia 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:[e-mail]-20101113155825-czmva9kg4n31anmu) (version source revid:[e-mail]-20100629074804-359l9m9gniauxr94) (merge vers: 5.6.99-m4) (pib:21)

[13 Nov 2010 16:32] Bugs System

Pushed into mysql-next-mr (revid:[e-mail]-20101113160336-atmtmfb3mzm4pz4i) (version source revid:[e-mail]-20100629074804-359l9m9gniauxr94) (pib:21)