#################################
# Author: Leonard
# Org Date: 2008-02-20
# Purpose: Advance test for data node restart
#################################

-- source include/have_ndb.inc
-- source include/ndb_default_cluster.inc
-- source include/not_embedded.inc

--disable_warnings
USE test;
DROP TABLE IF EXISTS t1;
--enable_warnings

##################################
# Advance System Failure and Recovery testing
# Mysqld lost connect with ndbd (bug#31934)
##################################
CREATE TABLE t1 (
   a INT NOT NULL,
   b BIGINT NOT NULL,
   c BIGINT NOT NULL ,
   PRIMARY KEY (a)
) ENGINE NDB;

--exec ../storage/ndb/test/tools/hugoLoad -r 700 -b 100 -d test t1 >> $NDB_TOOLS_OUTPUT 2>&1

SELECT a, b, c FROM t1 ORDER BY a LIMIT 5;
SHOW CREATE TABLE t1;

--system killall ndbd
--exec $NDB_TOOLS_DIR/ndb_waiter --no-defaults --no-contact>> $NDB_TOOLS_OUTPUT
--exec ../storage/ndb/src/kernel/ndbd --no-defaults -c localhost:9311 & >> $NDB_TOOLS_OUTPUT 2>&1
--exec ../storage/ndb/src/kernel/ndbd --no-defaults -c localhost:9311 & >> $NDB_TOOLS_OUTPUT 2>&1
--exec $NDB_TOOLS_DIR/ndb_waiter --no-defaults >> $NDB_TOOLS_OUTPUT

SELECT a, b, c FROM t1 ORDER BY a LIMIT 5;
SHOW CREATE TABLE t1;

--system killall ndbd
--exec $NDB_TOOLS_DIR/ndb_waiter --no-defaults --no-contact>> $NDB_TOOLS_OUTPUT
--exec ../storage/ndb/src/kernel/ndbd --no-defaults -c localhost:9311 & >> $NDB_TOOLS_OUTPUT 2>&1
--exec ../storage/ndb/src/kernel/ndbd --no-defaults -c localhost:9311 & >> $NDB_TOOLS_OUTPUT 2>&1
--exec $NDB_TOOLS_DIR/ndb_waiter --no-defaults >> $NDB_TOOLS_OUTPUT

SELECT a, b, c FROM t1 ORDER BY a LIMIT 5;
SHOW CREATE TABLE t1;

DROP TABLE t1;