Debian Codegraph @

mysql-test/suite/ndb/t/ndb_stop_on_error.test

raw
1 -- source include/have_ndb.inc
2 -- source have_ndb_error_insert.inc
3
4 # Ignore the warning generated by ndbcluster's binlog thread
5 # when cluster is restarted
6 --disable_query_log ONCE
7 call mtr.add_suppression("cluster disconnect An incident event has been written");
8
9 # Ignore the warning generated by ndbcluster's binlog thread
10 # when cluster is restarted - also on the second mysqld
11 connect(mysqld2,127.0.0.1,root,,test,$MASTER_MYPORT1);
12 connection mysqld2;
13 --disable_query_log ONCE
14 call mtr.add_suppression("cluster disconnect An incident event has been written");
15
16 connection default;
17
18 --exec $NDB_CONFIG -q NodeId,StopOnError
19
20 CREATE DATABASE mysqltest;
21 USE mysqltest;
22 CREATE TABLE t1 (
23 pk INT NOT NULL PRIMARY KEY,
24 attr1 INT NOT NULL,
25 attr2 INT,
26 attr3 VARCHAR(10)
27 ) ENGINE=ndbcluster;
28
29 INSERT INTO t1 VALUES
30 (0,0,NULL,'0'),
31 (1,1,1,'1'),
32 (2,2,2,'2'),
33 (3,3,3,'3'),
34 (4,4,4,'4'),
35 (5,5,5,'5'),
36 (6,6,6,'6'),
37 (7,7,7,'7'),
38 (8,8,8,'8'),
39 (9,9,9,'9'),
40 (10,10,NULL,'10'),
41 (11,11,11,'11'),
42 (12,12,12,'12'),
43 (13,13,13,'13'),
44 (14,14,14,'14'),
45 (15,15,15,'15'),
46 (16,16,16,'16'),
47 (17,17,17,'17'),
48 (18,18,18,'18'),
49 (19,19,19,'19'),
50 (20,20,NULL,'20'),
51 (21,21,21,'21'),
52 (22,22,22,'22'),
53 (23,23,23,'23'),
54 (24,24,24,'24'),
55 (25,25,25,'25'),
56 (26,26,26,'26'),
57 (27,27,27,'27'),
58 (28,28,28,'28'),
59 (29,29,29,'29'),
60 (30,30,NULL,'30'),
61 (31,31,31,'31'),
62 (32,32,32,'32'),
63 (33,33,33,'33'),
64 (34,34,34,'34'),
65 (35,35,35,'35'),
66 (36,36,36,'36'),
67 (37,37,37,'37'),
68 (38,38,38,'38'),
69 (39,39,39,'39'),
70 (40,40,NULL,'40'),
71 (41,41,41,'41'),
72 (42,42,42,'42'),
73 (43,43,43,'43'),
74 (44,44,44,'44'),
75 (45,45,45,'45'),
76 (46,46,46,'46'),
77 (47,47,47,'47'),
78 (48,48,48,'48'),
79 (49,49,49,'49'),
80 (50,50,NULL,'50'),
81 (51,51,51,'51'),
82 (52,52,52,'52'),
83 (53,53,53,'53'),
84 (54,54,54,'54'),
85 (55,55,55,'55'),
86 (56,56,56,'56'),
87 (57,57,57,'57'),
88 (58,58,58,'58'),
89 (59,59,59,'59'),
90 (60,60,NULL,'60'),
91 (61,61,61,'61'),
92 (62,62,62,'62'),
93 (63,63,63,'63'),
94 (64,64,64,'64'),
95 (65,65,65,'65'),
96 (66,66,66,'66'),
97 (67,67,67,'67'),
98 (68,68,68,'68'),
99 (69,69,69,'69'),
100 (70,70,NULL,'70'),
101 (71,71,71,'71'),
102 (72,72,72,'72'),
103 (73,73,73,'73'),
104 (74,74,74,'74'),
105 (75,75,75,'75'),
106 (76,76,76,'76'),
107 (77,77,77,'77'),
108 (78,78,78,'78'),
109 (79,79,79,'79'),
110 (80,80,NULL,'80'),
111 (81,81,81,'81'),
112 (82,82,82,'82'),
113 (83,83,83,'83'),
114 (84,84,84,'84'),
115 (85,85,85,'85'),
116 (86,86,86,'86'),
117 (87,87,87,'87'),
118 (88,88,88,'88'),
119 (89,89,89,'89'),
120 (90,90,NULL,'90'),
121 (91,91,91,'91'),
122 (92,92,92,'92'),
123 (93,93,93,'93'),
124 (94,94,94,'94'),
125 (95,95,95,'95'),
126 (96,96,96,'96'),
127 (97,97,97,'97'),
128 (98,98,98,'98'),
129 (99,99,99,'99');
130
131 --echo "Run DUMP commands to start LCP"
132 --exec $NDB_MGM -e "all dump 7099" >> $NDB_TOOLS_OUTPUT
133
134 --echo "Sleep 10s so that LCP can complete"
135 sleep 10;
136
137 --echo "Insert ERROR command to crash nodes with SEGV"
138 --exec $NDB_MGM -e "all error 9006" >> $NDB_TOOLS_OUTPUT
139
140 --echo "Wait till nodes started"
141 --exec $NDB_WAITER
142
143 --exec $NDB_SELECT_ALL -d mysqltest t1 -o PRIMARY
144
145 # Wait for MySQLD to reconnect to cluster...
146 --source include/ndb_not_readonly.inc
147
148 DROP TABLE t1;
149 DROP DATABASE mysqltest;
150 --remove_file $NDB_TOOLS_OUTPUT