Bug #50767 Some RPL tests started to fail in next-mr-merge on Linux x86_64 debug
Submitted: 31 Jan 2010 11:50 Modified: 4 Aug 2010 12:14
Reporter: Alexander Nozdrin Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Replication Severity:S3 (Non-critical)
Version:Celosia (M3) OS:Linux (x86_64, debug)
Assigned to: Luis Soares CPU Architecture:Any

[31 Jan 2010 11:50] Alexander Nozdrin
Description:
The following RPL tests started to fail after merge
from 5.1-bugteam into mysql-next-mr-merge:
  - rpl.rpl_stm_binlog_direct
  - rpl.rpl_misc_functions
  - rpl.rpl_nondeterministic_functions
  - rpl.rpl_heartbeat_basic

The symptoms are:

  - rpl.rpl_heartbeat_basic:

@@ -289,7 +289,7 @@
 2	on slave
 Heartbeat event received on master
 Heartbeat event received on slave
-Slave has received more events than master (1 means 'yes'): 1
+Slave has received more events than master (1 means 'yes'): 0

  - rpl.rpl_stm_binlog_direct
  - rpl.rpl_misc_functions
  - rpl.rpl_nondeterministic_functions

100131  2:58:29 [Warning] Unsafe statement binlogged in statement format since BINLOG_FORMAT = STATEMENT. Reason for unsafeness: Non-transactional reads or writes are unsafe if they occur after transactional reads or writes inside a transaction. Statement: INSERT INTO nt_1(trans_id, stmt_id) VALUES (7, 4)
....

How to repeat:
Run test cases on Linux x86_64 on the tree built in debug mode.
[31 Jan 2010 21:20] Valeriy Kravchuk
I can not repeat this with recent mysql-next-mr-merge tree on 32-bit Linux.
[1 Feb 2010 8:09] Sveta Smirnova
Thank you for the report.

Verified as described on 64-bit Linux.
[1 Feb 2010 18:32] 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/98842

2985 Luis Soares	2010-02-01
      BUG#50767: Some RPL tests started to fail in next-mr-merge on Linux 
      x86_64 debug
      
      Three test cases either missed the suppression for unsafe
      statement or were using the older message in the suppression. The
      heartbeat test failed because patch for BUG@50397 removed the
      CHANGE MASTER in the slave that would set it's period to 1/10 of
      the master. This would cause the test assertion to fail.
      
      The fixes are:
      
       - rpl_misc_functions - updated suppression message
       - rpl_nondeterministic_functions - updated suppression message
       - rpl_stm_binlog_direct - added suppression (warnings were
                                 already in result file)
       - rpl_heartbeat_basic - deployed instruction: 
         CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD=0.1;
[1 Feb 2010 21:53] 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/98868

2985 Luis Soares	2010-02-01
      BUG#50767: Some RPL tests started to fail in next-mr-merge on
      Linux x86_64 debug
      
      Two test cases fail because the suppression for the unsafe
      warning needs to be updated (BUG@39934 refactored this part and
      these changes are only in mysql-next-mr - this is why we notice
      them now when merging in next-mr). This is the case for
      rpl_nondeterministic_functions and rpl_misc_functions test
      cases. rpl_stm_binlog_direct test case is not needed in version >
      5.1. The rpl_heartbeat_basic test case fails because patch for
      BUG@50397 removed the CHANGE MASTER in the slave that would set
      it's period to 1/10 of the master. This would cause the test
      assertion to fail.
      
      The fixes for the issues described above are:
      
       - rpl_misc_functions - updated suppression message
       - rpl_nondeterministic_functions - updated suppression message
       - rpl_stm_binlog_direct - removed the test case (it is not 
                                 needed in versions > 5.1)
       - rpl_heartbeat_basic - deployed instruction: 
         CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD=0.1;
[2 Feb 2010 9:05] Andrei Elkin
Restoring of slave hb period of the pre-bug#50397 logics is correct.
The patch is approved.
[2 Feb 2010 9: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/98906

2988 Alexander Nozdrin	2010-02-02
      BUG#50767: Some RPL tests started to fail in next-mr-merge on
      Linux x86_64 debug
      
      Two test cases fail because the suppression for the unsafe
      warning needs to be updated (BUG@39934 refactored this part and
      these changes are only in mysql-next-mr - this is why we notice
      them now when merging in next-mr). This is the case for
      rpl_nondeterministic_functions and rpl_misc_functions test
      cases. rpl_stm_binlog_direct test case is not needed in version >
      5.1. The rpl_heartbeat_basic test case fails because patch for
      BUG@50397 removed the CHANGE MASTER in the slave that would set
      it's period to 1/10 of the master. This would cause the test
      assertion to fail.
      
      The fixes for the issues described above are:
      
       - rpl_misc_functions - updated suppression message
       - rpl_nondeterministic_functions - updated suppression message
       - rpl_stm_binlog_direct - removed the test case (it is not 
                                 needed in versions > 5.1)
       - rpl_heartbeat_basic - deployed instruction: 
         CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD=0.1;
[2 Feb 2010 9:48] Alexander Nozdrin
Pushed into mysql-next-mr-merge,
merged into mysql-6.0-codebase-merge.
[5 Feb 2010 11:50] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100204063540-9czpdmpixi3iw2yb) (version source revid:alik@sun.com-20100202092628-ddyr2iic91h910b1) (pib:16)
[5 Feb 2010 11:56] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100205113942-oqovjy0eoqbarn7i) (version source revid:alik@sun.com-20100204105539-5h6k0s1jxofqaait) (merge vers: 6.0.14-alpha) (pib:16)
[5 Feb 2010 13:29] Jon Stephens
No user-facing changes to document. Closed without further action.
[14 Feb 2010 0:38] 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/100262

3170 Luis Soares	2010-02-14
      Fixes for rpl_heartbeat_basic test case. Ported BUG#50397 and BUG#50767
      csets (the former one was fully ported, the latter only partially ported).
[6 Mar 2010 10:54] Bugs System
Pushed into 5.5.3-m3 (revid:alik@sun.com-20100306103849-hha31z2enhh7jwt3) (version source revid:vvaintroub@mysql.com-20100206161342-o8lwhz2sy303krau) (merge vers: 5.5.99-m3) (pib:16)
[8 Mar 2010 20:26] Jon Stephens
Changes in test code only. No end-user changes to document.

Closed.
[24 Mar 2010 8:15] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100324081249-yfwol7qtcek6dh7w) (version source revid:alik@sun.com-20100324081113-kc7x1iytnplww91u) (merge vers: 6.0.14-alpha) (pib:16)
[24 Mar 2010 8:18] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100324081159-5b8juv8ldiqwce8v) (version source revid:alik@sun.com-20100324081105-y72rautcea375zxm) (pib:16)
[24 Mar 2010 16:57] Paul DuBois
No changelog entry needed.
[4 Aug 2010 8:04] Bugs System
Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804080001-bny5271e65xo34ig) (version source revid:alik@sun.com-20100324081105-y72rautcea375zxm) (merge vers: 5.6.99-m4) (pib:18)
[4 Aug 2010 8:20] Bugs System
Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804081533-c1d3rbipo9e8rt1s) (version source revid:alik@sun.com-20100324081105-y72rautcea375zxm) (merge vers: 5.6.99-m4) (pib:18)
[4 Aug 2010 12:14] Jon Stephens
Closed without further action; see previous comments from Paul and me.