Debian Codegraph @

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

raw
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