Debian Codegraph @

mysql-test/suite/ndb/r/server_lifecycle.result

raw
1 CREATE TABLE t1 (
2 a INT PRIMARY KEY,
3 b VARCHAR(32)
4 ) engine=ndb;
5 INSERT INTO t1 VALUES (1, "row 1");
6 SELECT a FROM t1;
7 a
8 1
9 #
10 # 1. stop/start
11 #
12 # Restart MySQL Server
13 # restart
14 SELECT a FROM t1;
15 a
16 1
17 #
18 # 2. stop/start without NDB
19 #
20 call mtr.add_suppression("Tables not available after [0-9]* seconds");
21 # Stop data nodes
22 Executing RESTART on all nodes.
23 Starting shutdown. This may take a while. Please wait...
24 All DB nodes are being restarted.
25
26 # Error since data nodes are down
27 SELECT a FROM t1;
28 ERROR HY000: Got error 4009 'Cluster Failure' from NDBCLUSTER
29 # Restart MySQL Server (with data nodes in no start)
30 # restart
31 # Error since data nodes are still down
32 SELECT a FROM t1;
33 ERROR HY000: Got error 4009 'Cluster Failure' from NDBCLUSTER
34 # Start data nodes again
35 NDB Cluster is being started.
36 NDB Cluster is being started.
37
38 SELECT a FROM t1;
39 a
40 1
41 DROP TABLE t1;