Bug #45108 Slave skip counter not working as expected on debian platform
Submitted: 26 May 2009 21:26 Modified: 25 Jun 2009 15:32
Reporter: Chuck Bell Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:6.0.11 OS:Any
Assigned to: Chuck Bell CPU Architecture:Any
Triage: Triaged: D3 (Medium)

[26 May 2009 21:26] Chuck Bell
Description:
The test rpl_backup_block is failing in pushbuild for the debian platform in the mysql-6.0-backup tree(s). The test failure is because the incident report is not being skipped by the SET global sql_slave_skip_counter=1; statement in the rpl_backup_block test.

The test works as expected on all other platforms.

Notes
-----
* The test passes on subsequent retry attempts.
* This may be a timing/performance issue.
* Test case 4 has been disabled in the test. See lines #171-205 (only).
  Please enable when this bug is fixed

How to repeat:
Observe 'debx86-b' 'double whopper' in pushbuild:

rpl.rpl_backup_block                     [ fail ]
        Test ended at 2009-05-23 01:05:39

CURRENT_TEST: rpl.rpl_backup_block
--- /data0/pushbuild/pb2/pb/bzr_mysql-6.0-backup/259/mysql-6.0.11-alpha-pb259/mysql-test/suite/rpl/r/rpl_backup_block.result	2009-05-23 00:25:47.000000000 +0300
+++ /data0/pushbuild/pb2/pb/bzr_mysql-6.0-backup/259/mysql-6.0.11-alpha-pb259/mysql-test/suite/rpl/r/rpl_backup_block.reject	2009-05-23 02:05:39.754056990 +0300
@@ -163,8 +163,8 @@
 Replicate_Ignore_Table	#
 Replicate_Wild_Do_Table	
 Replicate_Wild_Ignore_Table	
-Last_Errno	0
-Last_Error	
+Last_Errno	1590
+Last_Error	The incident RESTORE_ON_MASTER occured on the master. Message: A restore operation was initiated on the master.
 Skip_Counter	#
 Exec_Master_Log_Pos	#
 Relay_Log_Space	#
@@ -181,13 +181,13 @@
 Master_SSL_Verify_Server_Cert	No
 Last_IO_Errno	#
 Last_IO_Error	#
-Last_SQL_Errno	0
-Last_SQL_Error	
+Last_SQL_Errno	1590
+Last_SQL_Error	The incident RESTORE_ON_MASTER occured on the master. Message: A restore operation was initiated on the master.
 Replicate_Ignore_Server_Ids	
 Master_Server_Id	1
 # Show the slave started without an error.
 Last_SQL_Error
-
+The incident RESTORE_ON_MASTER occured on the master. Message: A restore operation was initiated on the master.
 SELECT * FROM rpl_backup_block.t1;
 a
 1

mysqltest: Result content mismatch

 - saving '/dev/shm/var-n_mix-110/log/rpl.rpl_backup_block/' to '/dev/shm/var-n_mix-110/log/rpl.rpl_backup_block/'

Retrying test, attempt(2/3)...

rpl.rpl_backup_block                     [ retry-pass ]    601

Retrying test, attempt(3/3)...

rpl.rpl_backup_block                     [ retry-pass ]    403

Suggested fix:
Unknown
[26 May 2009 21:29] 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/74994

2813 Chuck Bell	2009-05-26
      BUG#45108 : Slave skip counter not working as expected on debian platform
      
      This patch disables test case 4 until the bug is fixed.
      modified:
        mysql-test/suite/rpl/r/rpl_backup_block.result
        mysql-test/suite/rpl/t/rpl_backup_block.test
[26 May 2009 21:31] Chuck Bell
Changed back to open since last patch was only to disable the offending test case.
[27 May 2009 18:47] Sveta Smirnova
Thank you for the report.

I can not repeat described behavior.

But if it is pushbuild it is documented already, so can be verified by default. Could you please provide link to logs and set bug to "Verified"?
[27 May 2009 18:58] Chuck Bell
https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-backup&order=260
[27 May 2009 20:15] 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/75082

2817 Chuck Bell	2009-05-27
      BUG#45108 : Slave skip counter not working as expected on debian platform
      
      This patch attempts to fix the problem by removing the STOP SLAVE
      call prior to the restart.
      modified:
        mysql-test/suite/rpl/r/rpl_backup_block.result
        mysql-test/suite/rpl/t/rpl_backup_block.test
[28 May 2009 13:50] 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/75153

2818 Chuck Bell	2009-05-28
      BUG#45108 : Slave skip counter not working as expected on debian platform
      
      This patch removes the bug comment from the test.
      The previous patch corrected the problem described in the
      bug report.
      modified:
        mysql-test/suite/rpl/t/rpl_backup_block.test
[28 May 2009 13:50] Chuck Bell
The solution suggested by Mats has worked in PB. The previous patch contained the correction to the test. A new patch is needed to remove the bug comment from the test and finalize this bug report.
[28 May 2009 13:54] Jørgen Løland
Good to push.
[25 Jun 2009 14:39] Bugs System
Pushed into 5.4.4-alpha (revid:alik@sun.com-20090625143727-9gqcfzh7ajuk66oj) (version source revid:charles.bell@sun.com-20090528134935-ozbakmin8zu7y2nd) (merge vers: 6.0.12-alpha) (pib:11)
[25 Jun 2009 15:32] Jon Stephens
Test change only, no user-facing changes to document. Closed.