Debian Codegraph @

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

raw
1 # Test clone error cases with concurrent DDL
2 --source include/have_debug_sync.inc
3 --source include/have_log_bin.inc
4 --source include/count_sessions.inc
5
6 --let $CLONE_DATADIR = $MYSQL_TMP_DIR/data_new
7
8 --replace_result $CLONE_PLUGIN CLONE_PLUGIN
9 --eval INSTALL PLUGIN clone SONAME '$CLONE_PLUGIN'
10
11 --echo # Create test schema
12 --source ../include/create_schema.inc
13 CALL execute_dml(0, 0, 10, 10, 10, 0);
14
15 SET GLOBAL DEBUG = '+d,local_release_clone_file_pin';
16
17 --echo # 1. Truncate same table in various stages of CLONE
18 --echo # In connection DEFAULT
19 SET DEBUG_SYNC = 'clone_before_init_meta SIGNAL start_ddl_0 WAIT_FOR resume_clone_0';
20 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_ddl_1 WAIT_FOR resume_clone_1';
21 SET DEBUG_SYNC = 'clone_file_copy_end_before_ack SIGNAL start_ddl_2 WAIT_FOR resume_clone_2';
22 SET DEBUG_SYNC = 'clone_before_file_ddl_meta SIGNAL start_ddl_3 WAIT_FOR resume_clone_3';
23 SET DEBUG_SYNC = 'clone_page_copy SIGNAL start_ddl_4 WAIT_FOR resume_clone_4';
24 SET DEBUG_SYNC = 'clone_before_page_ddl_meta SIGNAL start_ddl_5 WAIT_FOR resume_clone_5';
25 SET DEBUG_SYNC = 'clone_redo_copy SIGNAL start_ddl_6 WAIT_FOR resume_clone_6';
26 --source ../include/clone_command_send.inc
27
28 --connect (con1,localhost,root,,)
29 --echo # In connection CON1
30
31 --echo # Waiting for clone
32 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_0';
33 --echo # Wait finished
34 TRUNCATE TABLE t1;
35 TRUNCATE TABLE t2;
36 CALL execute_dml(0, 0, 10, 10, 10, 0);
37 SET DEBUG_SYNC = 'now SIGNAL resume_clone_0';
38
39 --echo # Waiting for clone
40 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_1';
41 --echo # Wait finished
42 TRUNCATE TABLE t1;
43 TRUNCATE TABLE t2;
44 CALL execute_dml(0, 0, 10, 10, 10, 0);
45 SET DEBUG_SYNC = 'now SIGNAL resume_clone_1';
46
47 --echo # Waiting for clone
48 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_2';
49 --echo # Wait finished
50 TRUNCATE TABLE t1;
51 TRUNCATE TABLE t2;
52 CALL execute_dml(0, 0, 10, 10, 10, 0);
53 SET DEBUG_SYNC = 'now SIGNAL resume_clone_2';
54
55 --echo # Waiting for clone
56 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_3';
57 --echo # Wait finished
58 TRUNCATE TABLE t1;
59 TRUNCATE TABLE t2;
60 CALL execute_dml(0, 0, 10, 10, 10, 0);
61 SET DEBUG_SYNC = 'now SIGNAL resume_clone_3';
62
63 --echo # Waiting for clone
64 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_4';
65 --echo # Wait finished
66 TRUNCATE TABLE t1;
67 TRUNCATE TABLE t2;
68 CALL execute_dml(0, 0, 10, 10, 10, 0);
69 SET DEBUG_SYNC = 'now SIGNAL resume_clone_4';
70
71 --echo # Waiting for clone
72 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_5';
73 --echo # Wait finished
74 TRUNCATE TABLE t1;
75 TRUNCATE TABLE t2;
76 CALL execute_dml(0, 0, 10, 10, 10, 0);
77 SET DEBUG_SYNC = 'now SIGNAL resume_clone_5';
78
79 --echo # Waiting for clone
80 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_6';
81 --echo # Wait finished
82 TRUNCATE TABLE t1;
83 TRUNCATE TABLE t2;
84 CALL execute_dml(0, 0, 10, 10, 10, 0);
85 SET DEBUG_SYNC = 'now SIGNAL resume_clone_6';
86
87 --connection default
88 --echo # In connection DEFAULT
89
90 --echo # Waiting for clone to complete
91 --reap
92 --echo # Wait finished
93
94 SET GLOBAL DEBUG = '-d,local_release_clone_file_pin';
95
96 disconnect con1;
97
98 SET DEBUG_SYNC = 'RESET';
99 --source include/wait_until_count_sessions.inc
100
101 --echo # Restart cloned database
102 --replace_result $CLONE_DATADIR CLONE_DATADIR
103 --let restart_parameters="restart: --datadir=$CLONE_DATADIR"
104 --source include/restart_mysqld.inc
105
106 select STATE, ERROR_NO, length(BINLOG_FILE) > 0, length(GTID_EXECUTED) > 0,
107 (BINLOG_POSITION > 0) from performance_schema.clone_status;
108
109 # Execute procedure to delete all rows and insert
110 CALL execute_dml(3, 0, 1, 1, 1, 0);
111 CALL execute_dml(0, 0, 10, 10, 10, 0);
112
113 # Check table in cloned database
114 SHOW CREATE TABLE t1;
115 SELECT count(*) from t1;
116 SELECT col1, col2, col3 FROM t1 ORDER BY col1 LIMIT 10;
117 SELECT col1, col2, col3 FROM t1 ORDER BY col1 DESC LIMIT 10;
118
119 SHOW CREATE TABLE t2;
120 SELECT count(*) from t2;
121 SELECT col1, col2, col3 FROM t2 ORDER BY col1 LIMIT 10;
122 SELECT col1, col2, col3 FROM t2 ORDER BY col1 DESC LIMIT 10;
123
124 --echo # Cleanup
125 --let restart_parameters="restart:"
126 --source include/restart_mysqld.inc
127
128 --source ../include/drop_schema.inc
129 --force-rmdir $CLONE_DATADIR
130
131 --echo # Uninstall clone
132 UNINSTALL PLUGIN clone;