List:Commits« Previous MessageNext Message »
From:Martin Skold Date:April 26 2010 9:08am
Subject:bzr commit into mysql-5.1-telco-6.3 branch (Martin.Skold:3180)
View as plain text  
#At file:///home/marty/MySQL/mysql-5.1-telco-6.3/

 3180 Martin Skold	2010-04-26
      Add test case to print the error messages under the following situations when create table:
      1)after ndb_mgmd and ndbd started , then stoped
      2)after mysqld restarted
      added:
        mysql-test/suite/ndb/r/ndb_disconnect_ddl.result
        mysql-test/suite/ndb/t/ndb_disconnect_ddl.test

=== added file 'mysql-test/suite/ndb/r/ndb_disconnect_ddl.result'
--- a/mysql-test/suite/ndb/r/ndb_disconnect_ddl.result	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/ndb/r/ndb_disconnect_ddl.result	2010-04-26 09:08:48 +0000
@@ -0,0 +1,10 @@
+DROP TABLE IF EXISTS t1;
+"testing the bug#31853"
+use test;
+create table t1(i int primary key) engine=ndb;
+create table t2(i int primary key) engine=ndb;
+ERROR HY000: Could not connect to storage engine
+create table t3(i int primary key) engine=ndb;
+ERROR HY000: Could not connect to storage engine
+drop table t1;
+"end of test the bug#31853"

=== added file 'mysql-test/suite/ndb/t/ndb_disconnect_ddl.test'
--- a/mysql-test/suite/ndb/t/ndb_disconnect_ddl.test	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/ndb/t/ndb_disconnect_ddl.test	2010-04-26 09:08:48 +0000
@@ -0,0 +1,51 @@
+--source include/have_ndb.inc
+
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+--enable_warnings
+
+--echo "testing the bug#31853"
+
+disable_query_log;
+call mtr.add_suppression("Could not acquire global schema lock");
+call mtr.add_suppression("Tables not available after 60 seconds.");
+enable_query_log;
+
+use test;
+create table t1(i int primary key) engine=ndb;
+
+# Restart cluster nodes "nostart"
+--exec $NDB_MGM --no-defaults --ndb-connectstring="$NDB_CONNECTSTRING" -e "all restart -n" >> $NDB_TOOLS_OUTPUT
+# Wait for all nodes to enter "nostart"
+--exec $NDB_TOOLS_DIR/ndb_waiter --no-defaults --ndb-connectstring="$NDB_CONNECTSTRING" --not-started >> $NDB_TOOLS_OUTPUT
+
+--error 157
+create table t2(i int primary key) engine=ndb;
+
+let $mysqld_name=mysqld.1.1;
+--source include/restart_mysqld.inc
+
+--error 157
+create table t3(i int primary key) engine=ndb;
+
+# Start cluster nodes again
+--exec $NDB_MGM --no-defaults --ndb-connectstring="$NDB_CONNECTSTRING" -e "all start" >> $NDB_TOOLS_OUTPUT
+# Wait for all nodes to enter "started"
+--exec $NDB_TOOLS_DIR/ndb_waiter --no-defaults --ndb-connectstring="$NDB_CONNECTSTRING" >> $NDB_TOOLS_OUTPUT
+
+
+#
+# Wait until the connection to the
+# cluster has been restored or timeout occurs
+#
+connection default;
+--disable_result_log
+--disable_query_log
+--source include/ndb_not_readonly.inc
+--enable_result_log
+--enable_query_log
+
+# cleanup
+drop table t1;
+
+--echo "end of test the bug#31853"

Thread
bzr commit into mysql-5.1-telco-6.3 branch (Martin.Skold:3180) Martin Skold26 Apr