| 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 |