Debian Codegraph @

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

raw
1 CREATE LOGFILE GROUP lg1
2 ADD UNDOFILE 'lg1_undofile.dat'
3 INITIAL_SIZE 16M
4 UNDO_BUFFER_SIZE 1M
5 ENGINE NDB;
6 CREATE TABLESPACE ts1
7 ADD DATAFILE 'ts1_datafile.dat'
8 USE LOGFILE GROUP lg1
9 INITIAL_SIZE 16M
10 ENGINE NDB;
11 CREATE TABLESPACE ts2
12 ADD DATAFILE 'ts2_datafile.dat'
13 USE LOGFILE GROUP lg1
14 INITIAL_SIZE 16M
15 ENGINE NDB;
16 CREATE TABLE t1 (
17 a INT PRIMARY KEY,
18 b INT
19 ) ENGINE NDB;
20 INSERT INTO t1 VALUES (1, 2);
21 CREATE TABLE t2 (
22 a INT PRIMARY KEY,
23 b INT
24 ) ENGINE NDB
25 TABLESPACE ts1
26 STORAGE DISK;
27 INSERT INTO t2 VALUES (1, 1);
28 Node 1 is being restarted
29
30 Node 1: NOT_STARTED
31 Database node 1 is being started.
32
33 Node 1: STARTED
34 Node 2: STARTED
35 SELECT TABLESPACE_NAME, LOGFILE_GROUP_NAME
36 FROM INFORMATION_SCHEMA.FILES
37 WHERE ENGINE = "NDBCLUSTER";
38 TABLESPACE_NAME LOGFILE_GROUP_NAME
39 lg1 lg1
40 ts1 lg1
41 ts2 lg1
42 SHOW TABLES;
43 Tables_in_test
44 t1
45 t2
46 INSERT INTO t1 VALUES (2, 3);
47 SELECT * FROM t1;
48 a b
49 1 2
50 2 3
51 INSERT INTO t2 VALUES (2, 3);
52 SELECT * FROM t2;
53 a b
54 1 1
55 2 3
56 Node 1 is being restarted
57
58 Node 1: NOT_STARTED
59 Database node 1 is being started.
60
61 Node 1: STARTED
62 Node 2: STARTED
63 SELECT TABLESPACE_NAME, LOGFILE_GROUP_NAME
64 FROM INFORMATION_SCHEMA.FILES
65 WHERE ENGINE = "NDBCLUSTER";
66 TABLESPACE_NAME LOGFILE_GROUP_NAME
67 lg1 lg1
68 ts1 lg1
69 ts2 lg1
70 SHOW TABLES;
71 Tables_in_test
72 t1
73 t2
74 INSERT INTO t1 VALUES (3, 4);
75 SELECT * FROM t1;
76 a b
77 1 2
78 2 3
79 3 4
80 INSERT INTO t2 VALUES (5, 8);
81 SELECT * FROM t2;
82 a b
83 1 1
84 2 3
85 5 8
86 Executing RESTART on all nodes.
87 Starting shutdown. This may take a while. Please wait...
88 All DB nodes are being restarted.
89
90 Node 1: NOT_STARTED
91 Node 2: NOT_STARTED
92 NDB Cluster is being started.
93 NDB Cluster is being started.
94
95 Node 1: STARTED
96 Node 2: STARTED
97 # verify that the mysqld detected the restart
98 include/assert_grep.inc [Detect normal restart in MySQL Server 1]
99 include/assert_grep.inc [Detect normal restart in MySQL Server 2]
100 SELECT TABLESPACE_NAME, LOGFILE_GROUP_NAME
101 FROM INFORMATION_SCHEMA.FILES
102 WHERE ENGINE = "NDBCLUSTER";
103 TABLESPACE_NAME LOGFILE_GROUP_NAME
104 lg1 lg1
105 ts1 lg1
106 ts2 lg1
107 SHOW TABLES;
108 Tables_in_test
109 t1
110 t2
111 INSERT INTO t1 VALUES (4, 5);
112 SELECT * FROM t1;
113 a b
114 1 2
115 2 3
116 3 4
117 4 5
118 INSERT INTO t2 VALUES (13, 21);
119 SELECT * FROM t2 ORDER BY a;
120 a b
121 1 1
122 2 3
123 5 8
124 13 21
125 Executing RESTART on all nodes.
126 Starting shutdown. This may take a while. Please wait...
127 All DB nodes are being restarted.
128
129 Node 1: NOT_STARTED
130 Node 2: NOT_STARTED
131 NDB Cluster is being started.
132 NDB Cluster is being started.
133
134 Node 1: STARTED
135 Node 2: STARTED
136 # verify that the mysqld detected the initial restart
137 include/assert_grep.inc [Detect initial restart in MySQL Server 1]
138 include/assert_grep.inc [Detect initial restart in MySQL Server 2]
139 SELECT TABLESPACE_NAME, LOGFILE_GROUP_NAME
140 FROM INFORMATION_SCHEMA.FILES
141 WHERE ENGINE = "NDBCLUSTER";
142 TABLESPACE_NAME LOGFILE_GROUP_NAME
143 SHOW TABLES;
144 Tables_in_test