Debian Codegraph @

mysql-test/suite/clone/t/local_insert.test

raw
1 # Test clone with insert
2
3 --source include/have_debug.inc
4 --source include/have_debug_sync.inc
5 --source include/count_sessions.inc
6
7 connect (con1,localhost,root,,);
8 connect (con2,localhost,root,,);
9 connect (con3,localhost,root,,);
10
11 --let $CLONE_DATADIR = $MYSQL_TMP_DIR/data_new
12 --let $MYSQLD_DATADIR = `SELECT @@datadir`
13
14 --replace_result $CLONE_PLUGIN CLONE_PLUGIN
15 --eval INSTALL PLUGIN clone SONAME '$CLONE_PLUGIN'
16
17 DELIMITER |;
18 CREATE PROCEDURE prepare_data(IN val INT)
19 BEGIN
20 DECLARE i INT DEFAULT 1;
21
22 WHILE i <= val DO
23 INSERT INTO t1 (b,c) VALUES (REPEAT(a,600), REPEAT(b,600));
24 INSERT INTO t2 (b,c) VALUES (REPEAT(a,600), REPEAT(b,600));
25 SET i = i + 1;
26 END WHILE;
27 END|
28 DELIMITER ;|
29
30 --echo # Case 1 - Normal page archiving process using clone client.
31
32 CREATE TABLE t1 (a INT AUTO_INCREMENT, b LONGBLOB, c LONGBLOB, key k1(a));
33 CREATE TABLE t2 (a INT PRIMARY KEY AUTO_INCREMENT, b LONGBLOB, c LONGBLOB);
34
35 --connection con1
36 SET DEBUG_SYNC = 'clone_file_copy SIGNAL page_signal WAIT_FOR go_page';
37 SET DEBUG_SYNC = 'clone_page_copy SIGNAL redo_signal WAIT_FOR go_redo';
38
39 if (!$remote_clone) {
40 SET DEBUG_SYNC = 'clone_donor_after_saving_dynamic_metadata SIGNAL meta_signal WAIT_FOR go_meta';
41 }
42 --source ../include/clone_command_send.inc
43
44 --connection con2
45 SET DEBUG_SYNC = 'now WAIT_FOR page_signal';
46 CALL prepare_data(50);
47 SET DEBUG_SYNC = 'now SIGNAL go_page';
48
49 SET DEBUG_SYNC = 'now WAIT_FOR redo_signal';
50 CALL prepare_data(10);
51 SET DEBUG_SYNC = 'now SIGNAL go_redo';
52
53 if (!$remote_clone) {
54 SET DEBUG_SYNC = 'now WAIT_FOR meta_signal';
55 SET GLOBAL debug="+d,periodical_checkpoint_disabled";
56 CALL prepare_data(10);
57 UPDATE t1 SET a = 100 where a = 1;
58 UPDATE t2 SET a = 200 where a = 1;
59 SET DEBUG_SYNC = 'now SIGNAL go_meta';
60 }
61
62 --connection con1
63 --reap
64
65 select count(*) from t1;
66 select count(*) from t2;
67
68 # Restart server on cloned data directory
69 --replace_result $CLONE_DATADIR CLONE_DATADIR
70 --let restart_parameters="restart: --datadir=$CLONE_DATADIR"
71 --source include/restart_mysqld.inc
72
73 INSERT INTO t1 (b,c) VALUES (REPEAT(a,600), REPEAT(b,600));
74 INSERT INTO t2 (b,c) VALUES (REPEAT(a,600), REPEAT(b,600));
75
76 select count(*), max(a) from t1;
77 select count(*), max(a) from t2;
78
79 #Cleanup
80 --let restart_parameters="restart:"
81 --source include/restart_mysqld.inc
82
83 --connection con1
84 DROP TABLE t1;
85 DROP TABLE t2;
86
87 SET DEBUG_SYNC = 'RESET';
88
89 --force-rmdir $CLONE_DATADIR
90
91 DROP PROCEDURE prepare_data;
92
93 UNINSTALL PLUGIN clone;
94
95 --disconnect con1
96 --disconnect con2
97 --disconnect con3