List:Commits« Previous MessageNext Message »
From:Andrei Elkin Date:December 2 2008 2:59pm
Subject:bzr commit into mysql-5.1 branch (aelkin:2703) Bug#41173
View as plain text  
#At file:///home/andrei/MySQL/BZR/FIXES/5.1-rpl-bug41173-rpl_packet-slave_star_not_synched/

 2703 Andrei Elkin	2008-12-02
      bug#41173 rpl_packet fails sporadically on pushbuild: query 'DROP TABLE t1' failed 
      
      The problem is most probably is missing synchronization in mtr with the slave io thread state.
      The io thread is not guaranteed to be connected by the end of `start slave'.
      
      Fixed with deploying wait_for_slave_to_start.inc macro invocation.
modified:
  mysql-test/include/wait_for_slave_to_start.inc
  mysql-test/suite/rpl/t/rpl_packet.test

per-file messages:
  mysql-test/include/wait_for_slave_to_start.inc
    Added an important piece to the specification.
  mysql-test/suite/rpl/t/rpl_packet.test
    Invoked a necessary synchronization macro.
    The slave IO is not guaranteed to be connected by the end of `start slave' but the macro does.
=== modified file 'mysql-test/include/wait_for_slave_to_start.inc'
--- a/mysql-test/include/wait_for_slave_to_start.inc	2008-07-10 16:09:39 +0000
+++ b/mysql-test/include/wait_for_slave_to_start.inc	2008-12-02 14:59:44 +0000
@@ -1,7 +1,8 @@
 # ==== Purpose ====
 #
 # Waits until both the IO and SQL threads of the current connection
-# have started, or until a timeout is reached.
+# have started, the IO thread has connected to the master 
+# or until a timeout is reached.
 #
 # ==== Usage ====
 #
@@ -13,6 +14,10 @@
 
 let $slave_error_message= Failed while waiting for slave to start;
 
+#
+# The running status YES designates the slave IO thread has connected
+# to the master
+#
 let $slave_param= Slave_IO_Running;
 let $slave_param_value= Yes;
 source include/wait_for_slave_param.inc;

=== modified file 'mysql-test/suite/rpl/t/rpl_packet.test'
--- a/mysql-test/suite/rpl/t/rpl_packet.test	2008-11-13 19:19:00 +0000
+++ b/mysql-test/suite/rpl/t/rpl_packet.test	2008-12-02 14:59:44 +0000
@@ -22,6 +22,7 @@ SET @@global.net_buffer_length=1024;
 connection slave;
 source include/stop_slave.inc;
 source include/start_slave.inc;
+source include/wait_for_slave_to_start.inc; 
 
 # Reconnect to master for new setting to take effect
 disconnect master;

Thread
bzr commit into mysql-5.1 branch (aelkin:2703) Bug#41173Andrei Elkin2 Dec