Debian Codegraph @

mysql-test/suite/rpl/t/rpl_mark_optimize_tbl_ddl.test

raw
1 # ==== Purpose ====
2 #
3 # Test verifies that there is no deadlock or assertion in
4 # slave_parallel_mode=optimistic configuration while applying admin command
5 # like 'OPTIMIZE TABLE', 'REPAIR TABLE' and 'ANALYZE TABLE'.
6 #
7 # ==== Implementation ====
8 #
9 # Steps:
10 # 0 - Create a table, execute OPTIMIZE TABLE command on the table followed
11 # by some DMLS.
12 # 1 - No assert should happen on slave server.
13 # 2 - Assert that 'OPTIMIZE TABLE', 'REPAIR TABLE' and 'ANALYZE TABLE' are
14 # marked as 'DDL' in the binary log.
15 #
16 # ==== References ====
17 #
18 # MDEV-17515: GTID Replication in optimistic mode deadlock
19 #
20 --source include/have_partition.inc
21 --source include/have_innodb.inc
22 --let $rpl_topology=1->2
23 --source include/rpl_init.inc
24
25 --disable_query_log
26 call mtr.add_suppression("InnoDB: Transaction was aborted due to ");
27 --enable_query_log
28
29 --connection server_1
30 FLUSH TABLES;
31 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
32
33 --connection server_2
34 SET @save_slave_parallel_threads= @@GLOBAL.slave_parallel_threads;
35 SET @save_slave_parallel_mode= @@GLOBAL.slave_parallel_mode;
36 --source include/stop_slave.inc
37 SET GLOBAL slave_parallel_threads=2;
38 SET GLOBAL slave_parallel_mode=optimistic;
39 --source include/start_slave.inc
40
41 --connection server_1
42 CREATE TABLE t1(a INT) ENGINE=INNODB;
43 OPTIMIZE TABLE t1;
44 INSERT INTO t1 VALUES(1);
45 INSERT INTO t1 SELECT 1+a FROM t1;
46 INSERT INTO t1 SELECT 2+a FROM t1;
47 --save_master_pos
48
49 --connection server_2
50 --sync_with_master
51
52 --echo #
53 --echo # Verify that following admin commands are marked as ddl
54 --echo # 'OPTIMIZE TABLE', 'REPAIR TABLE' and 'ANALYZE TABLE'
55 --echo #
56 --connection server_1
57
58 OPTIMIZE TABLE t1;
59 --let optimize_gtid= `SELECT @@GLOBAL.gtid_binlog_pos`
60
61 REPAIR TABLE t1;
62 --let repair_gtid= `SELECT @@GLOBAL.gtid_binlog_pos`
63
64 ANALYZE TABLE t1;
65 --let analyze_gtid= `SELECT @@GLOBAL.gtid_binlog_pos`
66
67 let $binlog_file= query_get_value(SHOW MASTER STATUS, File, 1);
68 FLUSH LOGS;
69
70 --let $MYSQLD_DATADIR= `select @@datadir`
71 --exec $MYSQL_BINLOG $MYSQLD_DATADIR/$binlog_file > $MYSQLTEST_VARDIR/tmp/mysqlbinlog.out
72
73 --let SEARCH_PATTERN= GTID $optimize_gtid ddl
74 --let SEARCH_FILE= $MYSQLTEST_VARDIR/tmp/mysqlbinlog.out
75 --source include/search_pattern_in_file.inc
76
77 --let SEARCH_PATTERN= GTID $repair_gtid ddl
78 --let SEARCH_FILE= $MYSQLTEST_VARDIR/tmp/mysqlbinlog.out
79 --source include/search_pattern_in_file.inc
80
81 --let SEARCH_PATTERN= GTID $analyze_gtid ddl
82 --let SEARCH_FILE= $MYSQLTEST_VARDIR/tmp/mysqlbinlog.out
83 --source include/search_pattern_in_file.inc
84
85 --echo #
86 --echo # Clean up
87 --echo #
88 DROP TABLE t1;
89 --remove_file $MYSQLTEST_VARDIR/tmp/mysqlbinlog.out
90 --save_master_pos
91
92 --connection server_2
93 --sync_with_master
94 FLUSH LOGS;
95
96 --echo #
97 --echo # Check that ALTER TABLE commands with ANALYZE, OPTIMIZE and REPAIR on
98 --echo # partitions will be marked as DDL in binary log.
99 --echo #
100 --connection server_1
101 CREATE TABLE t1(id INT) PARTITION BY RANGE (id) (PARTITION p0 VALUES LESS THAN (100),
102 PARTITION pmax VALUES LESS THAN (MAXVALUE));
103 INSERT INTO t1 VALUES (1), (10), (100), (1000);
104
105 ALTER TABLE t1 ANALYZE PARTITION p0;
106 --let analyze_gtid= `SELECT @@GLOBAL.gtid_binlog_pos`
107
108 ALTER TABLE t1 OPTIMIZE PARTITION p0;
109 --let optimize_gtid= `SELECT @@GLOBAL.gtid_binlog_pos`
110
111 ALTER TABLE t1 REPAIR PARTITION p0;
112 --let repair_gtid= `SELECT @@GLOBAL.gtid_binlog_pos`
113
114 let $binlog_file= query_get_value(SHOW MASTER STATUS, File, 1);
115 FLUSH LOGS;
116
117 --exec $MYSQL_BINLOG $MYSQLD_DATADIR/$binlog_file > $MYSQLTEST_VARDIR/tmp/mysqlbinlog.out
118
119 --let SEARCH_PATTERN= GTID $analyze_gtid ddl
120 --let SEARCH_FILE= $MYSQLTEST_VARDIR/tmp/mysqlbinlog.out
121 --source include/search_pattern_in_file.inc
122
123 --let SEARCH_PATTERN= GTID $optimize_gtid ddl
124 --let SEARCH_FILE= $MYSQLTEST_VARDIR/tmp/mysqlbinlog.out
125 --source include/search_pattern_in_file.inc
126
127 --let SEARCH_PATTERN= GTID $repair_gtid ddl
128 --let SEARCH_FILE= $MYSQLTEST_VARDIR/tmp/mysqlbinlog.out
129 --source include/search_pattern_in_file.inc
130
131 --echo #
132 --echo # Clean up
133 --echo #
134 DROP TABLE t1;
135 --remove_file $MYSQLTEST_VARDIR/tmp/mysqlbinlog.out
136 --save_master_pos
137
138 --connection server_2
139 --sync_with_master
140
141 --source include/stop_slave.inc
142 SET GLOBAL slave_parallel_threads= @save_slave_parallel_threads;
143 SET GLOBAL slave_parallel_mode= @save_slave_parallel_mode;
144 --source include/start_slave.inc
145
146 --source include/rpl_end.inc