Bug #57950 rpl_stm_start_stop_slave can't finish on solaris if rpl checksum is active
Submitted: 3 Nov 2010 10:13 Modified: 30 Nov 2010 22:27
Reporter: Andrei Elkin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.6-next-mr-wl2540 OS:Any
Assigned to: Andrei Elkin CPU Architecture:Any
Tags: wl2540

[3 Nov 2010 10:13] Andrei Elkin
Description:
As PB2 reports in
https://central.sun.net/http://pb2.norway.sun.com/?template=mysql_show_test_failure&search...

the test gets stuck in the middle of applying master's binary log.
The post-failure typical slave status does not indicate anything wrong but
rather large Seconds_Behind_Master, and is like the following

rpl_checksum.rpl_stm_start_stop_slave 'stmt' [ fail ]
        Test ended at 2010-11-02 00:07:23

CURRENT_TEST: rpl_checksum.rpl_stm_start_stop_slave
=== SHOW MASTER STATUS ===
---- 1. ----
File	slave-bin.000001
Position	715057
Binlog_Do_DB	
Binlog_Ignore_DB	
==========================

=== SHOW SLAVE STATUS ===
---- 1. ----
Slave_IO_State	Waiting for master to send event
Master_Host	127.0.0.1
Master_User	root
Master_Port	13000
Connect_Retry	1
Master_Log_File	master-bin.000001
Read_Master_Log_Pos	984511
Relay_Log_File	slave-relay-bin.000005
Relay_Log_Pos	591272
Relay_Master_Log_File	master-bin.000001
Slave_IO_Running	Yes
Slave_SQL_Running	Yes
Replicate_Do_DB	
Replicate_Ignore_DB	
Replicate_Do_Table	
Replicate_Ignore_Table	
Replicate_Wild_Do_Table	
Replicate_Wild_Ignore_Table	
Last_Errno	0
Last_Error	
Skip_Counter	0
Exec_Master_Log_Pos	748824
Relay_Log_Space	984490
Until_Condition	None
Until_Log_File	
Until_Log_Pos	0
Master_SSL_Allowed	No
Master_SSL_CA_File	
Master_SSL_CA_Path	
Master_SSL_Cert	
Master_SSL_Cipher	
Master_SSL_Key	
Seconds_Behind_Master	386
Master_SSL_Verify_Server_Cert	No
Last_IO_Errno	0
Last_IO_Error	
Last_SQL_Errno	0
Last_SQL_Error	
Replicate_Ignore_Server_Ids	
Master_Server_Id	1
Master_UUID	bf8744ef-e60a-11df-8998-b67e5635057b
Master_Info_File	/export/home/pb2/test/sb_0-2477158-1288638896.96/mysql-5.6.99-m5-solaris10-sparc-64bit-test/mysql-test/var-rpl_binlog_checksum/mysqld.2/data/master.info
SQL_Delay	0
SQL_Remaining_Delay	
Slave_SQL_Running_State	Reading event from the relay log
Master_Retry_Count	10

How to repeat:
https://central.sun.net/http://pb2.norway.sun.com/?template=mysql_show_test_failure&search...
[4 Nov 2010 21:01] 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/122882

3191 Andrei Elkin	2010-11-04
      Bug #57950 rpl_stm_start_stop_slave can't finish on solaris if rpl checksum is active
      
      This is an experimental commit to the wl2540 feature tree solely.
      A possible issue is the test duration. Lowering load size to sort out this possibility.
     @ mysql-test/collections/mysql-next-mr.push
        switching to a standard way of testing to run the entire suite with checksum.
        Two rpl, binlog are choosen to run with checksum per push.
     @ mysql-test/extra/rpl_tests/rpl_start_stop_slave.test
        Decreasing load twice.
[5 Nov 2010 13:21] 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/122950

3192 Andrei Elkin	2010-11-05
      Bug #57950
      
      restoring the default value of master_verify_checksum at server startup. The earlier changed aimed at getting more evidence to rpl_stm_start_stop_slave.
[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:27] Jon Stephens
No changelog entry required; did not appear in a release version.

Closed without further action.