Debian Codegraph @

mysql-test/suite/ndb/r/ndb_mt_backup_parts.result

raw
1 create table all_data (id int primary key, val int) engine=ndb;
2 create table part_data (id int primary key, val int) engine=ndb;
3 create table all_logs (txt varchar(512)) engine=ndb;
4 create table part_logs (txt varchar(512)) engine=ndb;
5 create table txt (a varchar(512)) engine=ndb;
6 insert into part_data values (1,1), (2,2), (3,3), (4,4), (5,5), (6,6), (7,7), (8,8);
7
8 Starting backup
9 Backup started
10 update part_data set val = 0;
11
12 Waiting for backup to complete
13 Backup completed
14 delete from part_data;
15 Restore data of part 4 on node 2
16 Check that part data does not overlap with already restored data
17 select count(*) from part_data join all_data where part_data.id = all_data.id;
18 count(*)
19 0
20 Capture backup logs of part 4 on node 2
21 Check that part logs do not overlap with logs from other parts
22 select count(*) from part_logs join all_logs where part_logs.txt = all_logs.txt;
23 count(*)
24 0
25 Restore data of part 3 on node 2
26 Check that part data does not overlap with already restored data
27 select count(*) from part_data join all_data where part_data.id = all_data.id;
28 count(*)
29 0
30 Capture backup logs of part 3 on node 2
31 Check that part logs do not overlap with logs from other parts
32 select count(*) from part_logs join all_logs where part_logs.txt = all_logs.txt;
33 count(*)
34 0
35 Restore data of part 2 on node 2
36 Check that part data does not overlap with already restored data
37 select count(*) from part_data join all_data where part_data.id = all_data.id;
38 count(*)
39 0
40 Capture backup logs of part 2 on node 2
41 Check that part logs do not overlap with logs from other parts
42 select count(*) from part_logs join all_logs where part_logs.txt = all_logs.txt;
43 count(*)
44 0
45 Restore data of part 1 on node 2
46 Check that part data does not overlap with already restored data
47 select count(*) from part_data join all_data where part_data.id = all_data.id;
48 count(*)
49 0
50 Capture backup logs of part 1 on node 2
51 Check that part logs do not overlap with logs from other parts
52 select count(*) from part_logs join all_logs where part_logs.txt = all_logs.txt;
53 count(*)
54 0
55 Restore data of part 4 on node 1
56 Check that part data does not overlap with already restored data
57 select count(*) from part_data join all_data where part_data.id = all_data.id;
58 count(*)
59 0
60 Capture backup logs of part 4 on node 1
61 Check that part logs do not overlap with logs from other parts
62 select count(*) from part_logs join all_logs where part_logs.txt = all_logs.txt;
63 count(*)
64 0
65 Restore data of part 3 on node 1
66 Check that part data does not overlap with already restored data
67 select count(*) from part_data join all_data where part_data.id = all_data.id;
68 count(*)
69 0
70 Capture backup logs of part 3 on node 1
71 Check that part logs do not overlap with logs from other parts
72 select count(*) from part_logs join all_logs where part_logs.txt = all_logs.txt;
73 count(*)
74 0
75 Restore data of part 2 on node 1
76 Check that part data does not overlap with already restored data
77 select count(*) from part_data join all_data where part_data.id = all_data.id;
78 count(*)
79 0
80 Capture backup logs of part 2 on node 1
81 Check that part logs do not overlap with logs from other parts
82 select count(*) from part_logs join all_logs where part_logs.txt = all_logs.txt;
83 count(*)
84 0
85 Restore data of part 1 on node 1
86 Check that part data does not overlap with already restored data
87 select count(*) from part_data join all_data where part_data.id = all_data.id;
88 count(*)
89 0
90 Capture backup logs of part 1 on node 1
91 Check that part logs do not overlap with logs from other parts
92 select count(*) from part_logs join all_logs where part_logs.txt = all_logs.txt;
93 count(*)
94 0
95 drop table txt;
96 drop table part_data;
97 drop table part_logs;
98 drop table all_data;
99 drop table all_logs;