Debian Codegraph @

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

raw
1 --source include/have_ndb.inc
2 --source have_ndb_error_insert.inc
3 --source include/have_ndb.inc
4 --source suite/ndb/include/backup_restore_setup.inc
5
6 --echo "Create tables for backup"
7 --disable_query_log
8 use test;
9
10 create table t0(id int primary key, val int) engine=ndb;
11 create table t1(val int) engine=ndb;
12 create table t2(id int primary key) engine=ndb;
13 create table t3(id int primary key auto_increment, val int) engine=ndb;
14 create table t4(id int primary key, val int default 11001) engine=ndb;
15 create table t5(id int primary key, val text) engine=ndb;
16 create table t6(id int primary key, val int unique) engine=ndb;
17 create table t7(id int auto_increment, val1 int, val2 int, primary key(id,val1)) engine=ndb;
18 create table t8(id int primary key, val varchar(256))engine=ndb;
19 create table t9(
20 auto int(5) unsigned NOT NULL auto_increment,
21 string char(10) default "hello",
22 vstring varchar(10) default "hello",
23 tiny tinyint(4) DEFAULT '0' NOT NULL ,
24 short smallint(6) DEFAULT '1' NOT NULL ,
25 medium mediumint(8) DEFAULT '0' NOT NULL,
26 long_int int(11) DEFAULT '0' NOT NULL,
27 longlong bigint(13) DEFAULT '0' NOT NULL,
28 real_float float(13,1) DEFAULT 0.0 NOT NULL,
29 real_double double(16,4),
30 real_decimal decimal(16,4),
31 utiny tinyint(3) unsigned DEFAULT '0' NOT NULL,
32 ushort smallint(5) unsigned zerofill DEFAULT '00000' NOT NULL,
33 umedium mediumint(8) unsigned DEFAULT '0' NOT NULL,
34 ulong int(11) unsigned DEFAULT '0' NOT NULL,
35 ulonglong bigint(13) unsigned DEFAULT '0' NOT NULL,
36 bits bit(3),
37 options enum('one','two','three') not null,
38 flags set('one','two','three') not null,
39 date_field date,
40 year_field year,
41 time_field time,
42 date_time datetime,
43 PRIMARY KEY (auto),
44 KEY (utiny),
45 KEY (tiny),
46 KEY (short),
47 KEY any_name (medium),
48 KEY (longlong),
49 KEY (real_float),
50 KEY (ushort),
51 KEY (umedium),
52 KEY (ulong),
53 KEY (ulonglong,ulong),
54 KEY (options,flags)
55 )engine=ndb;
56
57 let $i=9;
58 # insert 9 rows
59 while ($i)
60 {
61 eval insert into t0 values($i,$i);
62 eval insert into t1 values($i);
63 eval insert into t2 values($i);
64 eval insert into t3(val) values($i);
65 eval insert into t4(id) values($i);
66 eval insert into t5 values($i,REPEAT('$i', 4000));
67 eval insert into t6 values($i,$i);
68 eval insert into t7(val1,val2) values($i,$i);
69 eval insert into t8 values($i,REPEAT('$i',100));
70 eval insert into t9 (string,vstring,tiny,short,medium,long_int,longlong,
71 real_float,real_double, real_decimal,utiny, ushort, umedium,ulong,ulonglong,
72 bits,options,flags,date_field,year_field,time_field,date_time)
73 values
74 ("$i$i$i$i","$i$i$i$i",-$i,-$i,-$i,-$i,-$i,$i.$i,$i.$i,$i.$i,$i,$i,$i,$i,$i,
75 b'001','one','one', '19$i$i-$i-$i','19$i$i','$i:$i:$i','19$i$i-$i-$i $i:$i:$i');
76 dec $i;
77 }
78 # insert rows with NULL values
79 eval insert into t0 values(10,NULL);
80 eval insert into t1 values(NULL);
81 eval insert into t2 values(10);
82 eval insert into t3(val) values(NULL);
83 eval insert into t4(id) values(10);
84 eval insert into t5 values(10,NULL);
85 eval insert into t6 values(10,NULL);
86 eval insert into t7(val1,val2) values(10,NULL);
87 eval insert into t8 values(10,NULL);
88 eval insert into t9 (string,vstring,tiny,short,medium,long_int,longlong,
89 real_float,real_double, real_decimal,utiny,ushort,umedium,ulong,ulonglong,
90 bits,options,flags,date_field,year_field,time_field,date_time)
91 values
92 (NULL,NULL,10,10,10,10,10,10.1,NULL,NULL,10,10,10,10,10,
93 NULL,'two','two',NULL,NULL,NULL,NULL);
94
95 --exec $NDB_MGM -e "all error 10039"
96
97 --echo "Starting backup as nowait"
98 --source suite/ndb/t/ndb_backup_nowait_start.inc
99
100 --echo "Update tables during backup"
101 --disable_query_log
102 use test;
103 update t0 set val = 12345 where val is null;
104 update t1 set val = 11 where val = 1;
105 update t2 set id = 22 where id = 2;
106 update t3 set val = 33 where id = 3;
107 update t4 set val = 44 where id = 4;
108 update t5 set val = REPEAT("123 $#",1000) where id = 5;
109 update t6 set val = 66 where id = 6;
110 update t7 set val1 = 77 where id = 7;
111 update t8 set val = 88 where id = 8;
112 update t9 set string="bbbb",vstring="bbbb",tiny=-22,short=-22,medium=-22,
113 long_int=-22,longlong=-22,real_float=22.22,real_double=22.22,real_decimal=22.22,
114 utiny=22,ushort=22,umedium=22,ulong=22,ulonglong=22, bits=b'010',
115 options='two',flags='two', date_field='1922-02-22',year_field='1922',
116 time_field='22:22:22',date_time='1922-02-22 22:22:22' where auto=1;
117 --enable_query_log
118
119 --exec $NDB_MGM -e "all error 0"
120
121 --echo "Wait for backup to complete"
122 --source suite/ndb/t/ndb_backup_nowait_wait.inc
123
124 --echo "Drop tables after backup completes"
125 --disable_query_log
126 use test;
127 drop table t0;
128 drop table t1;
129 drop table t2;
130 drop table t3;
131 drop table t4;
132 drop table t5;
133 drop table t6;
134 drop table t7;
135 drop table t8;
136 drop table t9;
137 --enable_query_log
138
139 --source include/ndb_backup_id.inc
140
141 --echo Restore metadata using backup-part 1
142 --exec $NDB_RESTORE -b $the_backup_id -n 1 -m $NDB_BACKUPS-$the_backup_id/BACKUP-$the_backup_id-PART-1-OF-2 >> $NDB_TOOLS_OUTPUT 2>&1
143
144 --echo Restore data by restoring all backup parts serially
145 let $node = 6;
146 let $ldms = 12; # node 6 has 12 ldms, node 5 has 10, node 3 has 8 and so on
147 while ($node)
148 {
149 let $part = $ldms;
150 while ($part)
151 {
152 --echo Restore data of PART-$part-OF-$ldms on node $node
153 --exec $NDB_RESTORE -b $the_backup_id -n $node -r $NDB_BACKUPS-$the_backup_id/BACKUP-$the_backup_id-PART-$part-OF-$ldms >> $NDB_TOOLS_OUTPUT 2>&1
154 dec $part;
155 }
156 dec $node;
157 dec $ldms; # decrement ldms twice to get ldmcount of next lower node
158 dec $ldms;
159 }
160
161 --echo "Print restored rows"
162 use test;
163 select * from t0 order by id;
164 select * from t1 order by val;
165 select * from t2 order by id;
166 select * from t3 order by id;
167 select * from t4 order by id;
168 select id, sha1(val) from t5 order by id;
169 select * from t6 order by id;
170 select * from t7 order by id;
171 select id, sha1(val) from t8 order by id;
172 select * from t9 order by auto;
173
174 --echo Drop all tables
175 --disable_query_log
176 drop table t0;
177 drop table t1;
178 drop table t2;
179 drop table t3;
180 drop table t4;
181 drop table t5;
182 drop table t6;
183 drop table t7;
184 drop table t8;
185 drop table t9;
186 --enable_query_log
187
188 --echo Restore metadata using mt-restore
189 --exec $NDB_RESTORE -b $the_backup_id -n 1 -m $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT 2>&1
190
191 --echo Restore data using mt-restore of all backup parts
192 let $node = 6;
193 while ($node)
194 {
195 --exec $NDB_RESTORE -b $the_backup_id -n $node -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT 2>&1
196 dec $node;
197 }
198
199 --echo "Print restored rows"
200 use test;
201 select * from t0 order by id;
202 select * from t1 order by val;
203 select * from t2 order by id;
204 select * from t3 order by id;
205 select * from t4 order by id;
206 select id, sha1(val) from t5 order by id;
207 select * from t6 order by id;
208 select * from t7 order by id;
209 select id, sha1(val) from t8 order by id;
210 select * from t9 order by auto;
211
212 --disable_query_log
213 use test;
214 drop table t0;
215 drop table t1;
216 drop table t2;
217 drop table t3;
218 drop table t4;
219 drop table t5;
220 drop table t6;
221 drop table t7;
222 drop table t8;
223 drop table t9;
224 --enable_query_log
225
226 --source suite/ndb/include/backup_restore_cleanup.inc
227 --remove_file $NDB_TOOLS_OUTPUT