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