Bug #50984 check_testcase fails for rpl_tmp_table_and_DDL

• Submitted: 8 Feb 2010 10:09
• Modified: 13 Feb 2010 8:42
• Reporter: Alexander Nozdrin
• Status: Closed
• Category: Tests: Replication
• Severity: S7 (Test Cases)
• Version: Celosia (M3)
• OS: Any
• Assigned to: Luis Soares
• CPU Architecture: Any

[8 Feb 2010 10:09] Alexander Nozdrin

Description:
Check test case fails for rpl_tmp_table_and_DDL:
@@ -257,6 +257,7 @@
 def    performance_schema      utf8    utf8_general_ci NULL
 def    test    latin1  latin1_swedish_ci       NULL
 tables_in_test
+t2
 tables_in_mysql
 mysql.columns_priv
 mysql.db

How to repeat:
Run test case.

[8 Feb 2010 10:30] Sveta Smirnova

Thank you for the report.

Verified as described.

[9 Feb 2010 16: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/99752

2993 Luis Soares	2010-02-09
      BUG#50984: check_testcase fails for rpl_tmp_table_and_DDL
      
      We found that there are some tests that are not cleaning
      up properly:
      
        1. rpl_tmp_table_and_DDL
        2. rpl_do_grant
        3. rpl_sync
      
      For #1 and #2 we found that the slave would not, for some
      cases, replicate all the instructions the master processed 
      in the cleanup section. We fix these by deploying some 
      synchronization commands in the test cases so that slave 
      processes all clean up instructions.
      
      As for #3, this is tracked as part of another bug 
      (BUG@50442).

[10 Feb 2010 12:11] Luis Soares

I find this in mysql-trunk as well (currently Betony - M2).

[10 Feb 2010 12:13] 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/99807

2939 Luis Soares	2010-02-10
      BUG#50984: check_testcase fails for rpl_tmp_table_and_DDL
            
      We found that there are some tests that are not cleaning
      up properly:
            
        1. rpl_tmp_table_and_DDL
        2. rpl_do_grant
        3. rpl_sync
            
      For #1 and #2 we found that the slave would not, for some
      cases, replicate all the instructions the master processed 
      in the cleanup section. We fix these by deploying some 
      synchronization commands in the test cases so that slave 
      processes all clean up instructions.
            
      As for #3, this is tracked as part of another bug 
      (BUG@50442).

[12 Feb 2010 17:41] Bugs System

Pushed into 5.5.2-m2 (revid:[e-mail]-20100212164100-jnurxdw5z88m472s) (version source revid:[e-mail]-20100212164100-jnurxdw5z88m472s) (merge vers: 5.5.2-m2) (pib:16)

[13 Feb 2010 8:37] Bugs System

Pushed into 6.0.14-alpha (revid:[e-mail]-20100213083436-9pesg4h55w1mekxc) (version source revid:[e-mail]-20100211135109-t63avry9fqpgyh78) (merge vers: 6.0.14-alpha) (pib:16)

[13 Feb 2010 8:39] Bugs System

Pushed into mysql-next-mr (revid:[e-mail]-20100213083327-cee4ao3jpg33eggv) (version source revid:[e-mail]-20100211135018-1f9dbghg0itszigo) (pib:16)

[13 Feb 2010 8:42] Jon Stephens

Changes in test code only, no end-user changes to document.

Closed.