Bug #57555 mtr finds a new unsuppressed error after rpl.rpl_server_uuid
Submitted: 19 Oct 2010 9:00 Modified: 30 Nov 2010 22:25
Reporter: Andrei Elkin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Andrei Elkin CPU Architecture:Any

[19 Oct 2010 9:00] Andrei Elkin 
Description:
101015 16:59:26 [ERROR] Slave I/O: The slave I/O thread stops because a fatal error is encountered when it tried to SET @master_binlog_checksum on master. Error: , Error_code: 1593
^ Found warnings in /export/home/pb2/test/sb_0-2393668-1287140068.45/mysql-5.6.99-m5-solaris10-sparc-64bit-test/mysql-test/var-n_mix/log/mysqld.2.err

This happens on mysql-next-mr-wl2540 tree.
The reason is STOP SLAVE or shutdown that mtr executes sometimes catch
the slave at querying master.

How to repeat:
see PB2 on solaris in particular.

Suggested fix:
Add a suppression directive to mtr.
[19 Oct 2010 19:03] 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/121198

3181 Andrei Elkin	2010-10-19
      Bug #57555  	mtr finds a new unsuppressed error after rpl.rpl_server_uuid 
      
      The reason is STOP SLAVE or shutdown that mtr executes sometimes catch
      the slave at querying master.
      
      Fixed by adding the error suppression directive to mtr.
     @ mysql-test/include/mtr_warnings.sql
        a new error suppression directive to mtr is added to the family of get_master_clock() errors.
     @ mysql-test/suite/rpl/t/rpl_checksum_cache.test
        Warned with comments that big value of the main test's loop limit can cause
        a timeout. The limit was shrunk twice in other patch since the last time the test timed out on solaris.
[19 Oct 2010 19:27] 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/121202

3182 Andrei Elkin	2010-10-19
      Bug #57555 
      
      The Cset contains only forgotten to update results file.
[19 Oct 2010 19:27] 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/121203

3183 Andrei Elkin	2010-10-19
      Bug #57555 
      
      Similar to the reported warning is suppressed:
      Slave I/O: Get master BINLOG_CHECKSUM failed with error
[20 Oct 2010 19:20] 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/121402

3184 Andrei Elkin	2010-10-20
      Bug #57555 
      
      Similar to the reported warning is suppressed:
      Slave I/O: Notifying master by SET @master_binlog_checksum= @@global.binlog_checksum failed with error.
[22 Oct 2010 12:20] 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/121682

3180 Andrei Elkin	2010-10-22
      Bug #57555  	mtr finds a new unsuppressed error after rpl.rpl_server_uuid 
      
      The reason is STOP SLAVE or shutdown that mtr executes sometimes catch
      the slave at querying master.
      
      Fixed by adding the error suppression directive to mtr.
      
      Similar to the reported warnings are suppressed as well:
      Slave I/O: Get master BINLOG_CHECKSUM failed with error
      Slave I/O: Notifying master by SET @master_binlog_checksum= @@global.binlog_checksum failed with error.
      
      Small fixes to tests:
      solaris' failure was caused by long exec time of rpl_checksum_cache.
      Decreasing the main loop of the test param as twice.
     @ mysql-test/include/mtr_warnings.sql
        a new error suppression directive to mtr is added to the family of get_master_clock() errors.
     @ mysql-test/suite/rpl/t/rpl_checksum_cache.test
        Warned with comments that big value of the main test's loop limit can cause
        a timeout. The limit was shrunk twice in other patch since the last time the test timed out on solaris.
[25 Oct 2010 15:39] Andrei Elkin 
Queued to next-mr-wl2540 staging tree.
Nothing to document since the patches aim at wl#2540 testing.
[26 Oct 2010 14:02] 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/121932

3181 Andrei Elkin	2010-10-25
      Bug #57555
      
      renewing mysqld--help-win.result due to the checksum new user vars
[29 Nov 2010 11:11] Bugs System 
Pushed into mysql-trunk 5.6.1-m5 (revid:alexander.nozdrin@oracle.com-20101129111021-874if2qsp0i8d5ze) (version source revid:alexander.nozdrin@oracle.com-20101129111021-874if2qsp0i8d5ze) (merge vers: 5.6.1-m5) (pib:23)
[30 Nov 2010 22:25] Jon Stephens 
No changelog entry needed; see comment of [25 Oct 17:39] from Andrei Elkin. Closed.