From: Andrei Elkin
Date: October 13 2011 12:13pm
Subject: bzr push into mysql-trunk branch (andrei.elkin:3490 to 3491) Bug#13033076
List-Archive: http://lists.mysql.com/commits/141427
X-Bug: 13033076
Message-Id: <201110131213.p9DCDhNj022636@mysql1000.dsl.inet.fi>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit

 3491 Andrei Elkin	2011-10-13
      Bug#13033076 - OCCASIONAL CRASH OF RPL.RPL_PARALLEL_DDL
      
      refining the test once more to print out all files in db dir right
      befre the db is drop-ed.

    modified:
      mysql-test/suite/rpl/r/rpl_parallel_ddl.result
      mysql-test/suite/rpl/t/rpl_parallel_ddl.test
 3490 Tor Didriksen	2011-10-13 [merge]
      merge opt-team => trunk

    modified:
      mysql-test/include/subquery_sj.inc
      mysql-test/r/subquery_all.result
      mysql-test/r/subquery_all_bka.result
      mysql-test/r/subquery_all_bka_nixbnl.result
      mysql-test/r/subquery_sj_all.result
      mysql-test/r/subquery_sj_all_bka.result
      mysql-test/r/subquery_sj_all_bka_nixbnl.result
      mysql-test/r/subquery_sj_all_bkaunique.result
      mysql-test/r/subquery_sj_dupsweed.result
      mysql-test/r/subquery_sj_dupsweed_bka.result
      mysql-test/r/subquery_sj_dupsweed_bka_nixbnl.result
      mysql-test/r/subquery_sj_dupsweed_bkaunique.result
      mysql-test/r/subquery_sj_firstmatch.result
      mysql-test/r/subquery_sj_firstmatch_bka.result
      mysql-test/r/subquery_sj_firstmatch_bka_nixbnl.result
      mysql-test/r/subquery_sj_firstmatch_bkaunique.result
      mysql-test/r/subquery_sj_loosescan.result
      mysql-test/r/subquery_sj_loosescan_bka.result
      mysql-test/r/subquery_sj_loosescan_bka_nixbnl.result
      mysql-test/r/subquery_sj_loosescan_bkaunique.result
      mysql-test/r/subquery_sj_mat.result
      mysql-test/r/subquery_sj_mat_bka.result
      mysql-test/r/subquery_sj_mat_bka_nixbnl.result
      mysql-test/r/subquery_sj_mat_bkaunique.result
      mysql-test/r/subquery_sj_mat_nosj.result
      mysql-test/r/subquery_sj_none.result
      mysql-test/r/subquery_sj_none_bka.result
      mysql-test/r/subquery_sj_none_bka_nixbnl.result
      mysql-test/r/subquery_sj_none_bkaunique.result
      sql/item.cc
      sql/item.h
      sql/sql_select.cc
      sql/table.cc
      sql/table.h
=== modified file 'mysql-test/suite/rpl/r/rpl_parallel_ddl.result'
--- a/mysql-test/suite/rpl/r/rpl_parallel_ddl.result	2011-10-12 19:23:12 +0000
+++ b/mysql-test/suite/rpl/r/rpl_parallel_ddl.result	2011-10-13 12:12:19 +0000
@@ -1002,5 +1002,747 @@ t7.frm
 t8.MYD
 t8.MYI
 t8.frm
+"database d32:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d31:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t4.MYD
+t4.MYI
+t4.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d30:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d29:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d28:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d27:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d26:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d25:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d24:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d23:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d22:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d21:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d20:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d19:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d18:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d17:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d16:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d15:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d14:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d13:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d12:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d11:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d10:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d9:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d8:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d7:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d6:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d5:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d4:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d3:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d2:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
+"database d1:"
+db.opt
+t1.MYD
+t1.MYI
+t1.frm
+t2.MYD
+t2.MYI
+t2.frm
+t3.MYD
+t3.MYI
+t3.frm
+t4.MYD
+t4.MYI
+t4.frm
+t5.MYD
+t5.MYI
+t5.frm
+t6.MYD
+t6.MYI
+t6.frm
+t7.MYD
+t7.MYI
+t7.frm
+t8.MYD
+t8.MYI
+t8.frm
 set @@global.slave_parallel_workers= @save.slave_parallel_workers;
 include/rpl_end.inc

=== modified file 'mysql-test/suite/rpl/t/rpl_parallel_ddl.test'
--- a/mysql-test/suite/rpl/t/rpl_parallel_ddl.test	2011-10-12 19:23:12 +0000
+++ b/mysql-test/suite/rpl/t/rpl_parallel_ddl.test	2011-10-13 12:12:19 +0000
@@ -232,6 +232,7 @@ eval rename table $tables_2_rename d$n.t
 --enable_query_log
 
 #
+# DEBUG output (to remove)
 # Hunting after bug#13033076.
 # Let's see if rename leaves any garbage after its run
 #
@@ -256,12 +257,20 @@ connection master;
 let $n= $dbs;
 while ($n)
 {
+  # DEBUG (to remove) bug#13033076
+  --connection slave
+  --echo "database d$n:"
+  --list_files $MYSQLD_DATADIR/d$n
+
+  --connection master
   eval drop database d$n;
+  sync_slave_with_master;
   dec $n;
 }
 
 --enable_query_log
 
+--connection master
 sync_slave_with_master;
 
 set @@global.slave_parallel_workers= @save.slave_parallel_workers;

No bundle (reason: useless for push emails).