Debian Codegraph @

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

raw
1 --source include/have_multi_ndb.inc
2 --source include/have_binlog_format_mixed_or_row.inc
3 --source suite/ndb/include/backup_restore_setup.inc
4
5 ##
6 ## ndb_restart_restore
7 ##
8
9 --connect(s1,127.0.0.1,root,,test,$MASTER_MYPORT,)
10 --connect(s2,127.0.0.1,root,,test,$MASTER_MYPORT1,)
11
12 --echo "[connection mysqld 1]"
13 --connection s1
14
15 CREATE USER 'user'@'host';
16 GRANT NDB_STORED_USER ON *.* TO 'user'@'host';
17
18 CREATE TABLE t1 (k INT PRIMARY KEY, str VARCHAR(255), bin VARBINARY(1024)) ENGINE = NDB;
19 --save_master_pos
20
21 --disable_query_log
22 call mtr.add_suppression("mysqld startup An incident");
23 call mtr.add_suppression("Detected an empty ndb_schema table in NDB");
24
25 let $i=1024;
26 while ($i > 0)
27 {
28 eval SET @i = $i;
29 INSERT INTO t1 VALUES (@i, CONCAT("insert n=", @i), repeat(x'494E53455254', 128));
30 if (`SELECT ($i % 16) = 0`)
31 {
32 save_master_pos;
33 }
34 dec $i;
35 }
36 --enable_query_log
37
38 # just to be sure
39 SELECT COUNT(*) FROM t1;
40
41 # just to check
42 --exec $NDB_SELECT_COUNT -d mysql ndb_sql_metadata
43
44 --source include/ndb_backup.inc
45
46 # Check ids. should be 11,12,13,14,15,16
47 # Only need to shut 11 and 12 (rest is on the conn pool)
48 # --exec $NDB_MGM -e show >> $NDB_TOOLS_OUTPUT
49
50 --connection s1
51 --echo "[shutting down mysqld 1]"
52 --let $mysqld_name=mysqld.1.1
53 --source include/shutdown_mysqld.inc
54 --let $expect_mysqld1_file_name= $_expect_file_name
55
56 --connection s2
57 --echo "[shutting down mysqld 2]"
58 --let $mysqld_name=mysqld.2.1
59 --source include/shutdown_mysqld.inc
60 --let $expect_mysqld2_file_name= $_expect_file_name
61
62 --connection default
63 --exec $NDB_MGM -e "ALL RESTART -i"
64 --exec $NDB_WAITER --wait-nodes="1-3" >> $NDB_TOOLS_OUTPUT
65
66 # just to check
67 # --exec $NDB_MGM -e show >> $NDB_TOOLS_OUTPUT
68
69 --let $test_opts= --include-stored-grants --disable-indexes
70 --exec $NDB_RESTORE $test_opts -b $the_backup_id -n 1 -m -r --print_meta $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
71 --exec $NDB_RESTORE --include-stored-grants --rebuild-indexes -b $the_backup_id -n 1 --print_meta $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
72
73 --exec $NDB_RESTORE --include-stored-grants -b $the_backup_id -n 2 -r --print_meta $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
74
75 --exec $NDB_INDEX_STAT --sys-create-if-not-exist >> $NDB_TOOLS_OUTPUT
76 --exec $NDB_SELECT_COUNT -d mysql ndb_sql_metadata
77
78 --let $_expect_file_name= $expect_mysqld1_file_name
79 --let $mysqld_name=mysqld.1.1
80 --source include/start_mysqld.inc
81
82 --let $_expect_file_name= $expect_mysqld2_file_name
83 --let $mysqld_name=mysqld.2.1
84 --source include/start_mysqld.inc
85
86 --exec $NDB_SELECT_COUNT -d mysql ndb_sql_metadata
87 SELECT COUNT(*) FROM t1;
88 DROP TABLE t1;
89 DROP USER 'user'@'host';
90 --source suite/ndb/include/backup_restore_cleanup.inc
91 --remove_file $NDB_TOOLS_OUTPUT