| 1 |
--source include/have_ndb.inc |
| 2 |
|
| 3 |
# Get total number of data nodes |
| 4 |
select count(*) into @nodecnt from ndbinfo.nodes; |
| 5 |
|
| 6 |
# $get_leftcnt counts the data nodes there ndbinfo.membership and |
| 7 |
# ndbinfo.transporter_details agree on left nodes. |
| 8 |
|
| 9 |
let $get_leftcnt = select count(*) into @leftcnt |
| 10 |
from ndbinfo.transporter_details td join ndbinfo.membership ms |
| 11 |
on td.node_id = ms.node_id |
| 12 |
where td.heartbeat_interval is not null and td.remote_node_id = ms.left_node; |
| 13 |
|
| 14 |
--echo # Check that there is agreement on left data nodes on a fresh cluster |
| 15 |
--eval $get_leftcnt |
| 16 |
if (`select @leftcnt <> @nodecnt`) { |
| 17 |
select * from ndbinfo.transporter_details; |
| 18 |
select * from ndbinfo.membership; |
| 19 |
die Some node had wrong left node in ndbinfo.transporter_details; |
| 20 |
} |
| 21 |
--echo Agreement on left nodes between transporter_details and membership tables for fresh cluster. |
| 22 |
--echo |
| 23 |
|
| 24 |
--echo # Check that there is agreement on left data nodes with one node down |
| 25 |
--exec $NDB_MGM -e"2 RESTART -n" |
| 26 |
--exec $NDB_WAITER --nowait-nodes=1,3 --not-started |
| 27 |
|
| 28 |
--eval $get_leftcnt |
| 29 |
if (`select @leftcnt <> @nodecnt - 1`) { |
| 30 |
select * from ndbinfo.transporter_details; |
| 31 |
select * from ndbinfo.membership; |
| 32 |
die Some node had wrong left node in ndbinfo.transporter_details; |
| 33 |
} |
| 34 |
--echo Agreement on left nodes between transporter_details and membership tables with one node down |
| 35 |
--echo |
| 36 |
|
| 37 |
--echo # Check that there is agreement on left data nodes after one node restarted |
| 38 |
--exec $NDB_MGM -e"2 START" |
| 39 |
--exec $NDB_WAITER |
| 40 |
|
| 41 |
--eval $get_leftcnt |
| 42 |
if (`select @leftcnt <> @nodecnt`) { |
| 43 |
select * from ndbinfo.transporter_details; |
| 44 |
select * from ndbinfo.membership; |
| 45 |
die Some node had wrong left node in ndbinfo.transporter_details; |
| 46 |
} |
| 47 |
--echo Agreement on left nodes between transporter_details and membership tables after one node restarted |