| 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: | |
| 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: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.
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