Debian Codegraph @

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

raw
1 --source include/have_ndb.inc
2 --source include/have_multi_ndb.inc
3
4 --echo # Execute a DDL and verify the participant list in the servers
5
6 --connection server1
7 create table t1 (a int) engine ndb;
8
9 --let $assert_text= Found two participants in Server 1
10 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.1.1.err
11 # MySQL Server prints the connected participants in the format :
12 # [NDB] Participants [<participant1 node id>,<participant2 node id>..]
13 --let $assert_select= \[NDB\] Participants: \[[0-9]+,[0-9]+\]
14 --let $assert_count= 1
15 --source include/assert_grep.inc
16
17 --connection server2
18 drop table t1;
19
20 --let $assert_text= Found two participants in Server 2
21 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.2.1.err
22 --let $assert_select= \[NDB\] Participants: \[[0-9]+,[0-9]+\]
23 --let $assert_count= 1
24 --source include/assert_grep.inc
25
26 --echo # Restart all nodes one by one
27 --echo Restart data node 1
28 --exec $NDB_MGM -e "1 RESTART -n"
29 --exec $NDB_WAITER --nowait-nodes=2 --not-started > /dev/null
30
31 --echo # Verify the participants again to confirm that they were not lost after node 1 stopped
32 --connection server1
33 create table t1 (a int) engine ndb;
34
35 --let $assert_text= Found two participants in Server 1
36 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.1.1.err
37 --let $assert_select= \[NDB\] Participants: \[[0-9]+,[0-9]+\]
38 --let $assert_count= 2
39 --source include/assert_grep.inc
40
41 --connection server2
42 drop table t1;
43
44 --let $assert_text= Found two participants in Server 2
45 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.2.1.err
46 --let $assert_select= \[NDB\] Participants: \[[0-9]+,[0-9]+\]
47 --let $assert_count= 2
48 --source include/assert_grep.inc
49
50 --exec $NDB_MGM -e "1 START"
51 --exec $NDB_WAITER > /dev/null
52 --echo Node 1 restarted
53
54 --echo # Verify the participants again to confirm that they were not lost after node 1 restart
55 --connection server1
56 create table t1 (a int) engine ndb;
57
58 --let $assert_text= Found two participants in Server 1
59 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.1.1.err
60 --let $assert_select= \[NDB\] Participants: \[[0-9]+,[0-9]+\]
61 --let $assert_count= 3
62 --source include/assert_grep.inc
63
64 --connection server2
65 drop table t1;
66
67 --let $assert_text= Found two participants in Server 2
68 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.2.1.err
69 --let $assert_select= \[NDB\] Participants: \[[0-9]+,[0-9]+\]
70 --let $assert_count= 3
71 --source include/assert_grep.inc
72
73 --echo Restart data node 2
74 --exec $NDB_MGM -e "2 RESTART -n"
75 --exec $NDB_WAITER --nowait-nodes=1 --not-started > /dev/null
76
77 --echo # Verify the participants again to confirm that they were not lost after node 2 stopped
78 --connection server1
79 create table t1 (a int) engine ndb;
80
81 --let $assert_text= Found two participants in Server 1
82 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.1.1.err
83 --let $assert_select= \[NDB\] Participants: \[[0-9]+,[0-9]+\]
84 --let $assert_count= 4
85 --source include/assert_grep.inc
86
87 --connection server2
88 drop table t1;
89
90 --let $assert_text= Found two participants in Server 2
91 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.2.1.err
92 --let $assert_select= \[NDB\] Participants: \[[0-9]+,[0-9]+\]
93 --let $assert_count= 4
94 --source include/assert_grep.inc
95
96 --exec $NDB_MGM -e "2 START"
97 --exec $NDB_WAITER > /dev/null
98 --echo Node 1 restarted
99
100 --echo # Verify the participants again to confirm that they were not lost after node 2 restart
101 --connection server1
102 create table t1 (a int) engine ndb;
103
104 --let $assert_text= Found two participants in Server 1
105 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.1.1.err
106 --let $assert_select= \[NDB\] Participants: \[[0-9]+,[0-9]+\]
107 --let $assert_count= 5
108 --source include/assert_grep.inc
109
110 --connection server2
111 drop table t1;
112
113 --let $assert_text= Found two participants in Server 2
114 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.2.1.err
115 --let $assert_select= \[NDB\] Participants: \[[0-9]+,[0-9]+\]
116 --let $assert_count= 5
117 --source include/assert_grep.inc