Debian Codegraph @

mysql-test/suite/binlog/t/binlog_purge_not_blocked_by_alter_table.test

raw
1 # === Purpose ===
2 # Check PURGE BINARY LOGS operation can be executed with ALTER TABLE.
3 #
4 # === Requirements ===
5 # R1. PURGE BINARY LOGS can be executed in parallel with ALTER TABLE statement.
6 #
7 # === Implementation ===
8 # 1. Create table
9 # 2. Run ALTER TABLE statement but stop on a sync point
10 # 3. Check PURGE BINARY LOGS statement can be executed in parallel
11 # with ALTER TABLE
12 # 4. Cleanup
13 #
14 # === References ===
15 #
16 # Bug#35342521 Binary log purge should hold IX backup lock
17 #
18 --source include/have_debug_sync.inc
19 --source include/have_binlog_format_row.inc
20
21 --echo #
22 --echo # Initialization
23 --echo #
24
25 RESET MASTER;
26 CREATE TABLE t1 (c1 INT PRIMARY KEY) SECONDARY_ENGINE rapid;
27
28 --let $binlog_file = query_get_value(SHOW MASTER STATUS, File, 1)
29 FLUSH BINARY LOGS;
30 --replace_column 2 SIZE
31 SHOW BINARY LOGS;
32
33 --echo #
34 --echo # Run ALTER TABLE in separate connection
35 --echo #
36
37 --connect (con1, localhost, root,,)
38
39 --let $rpl_connection_name = default
40 --source include/rpl_connection.inc
41
42 --let $statement_connection = con1
43 --let $statement = ALTER TABLE t1 SECONDARY_LOAD
44 --let $sync_point = before_secondary_engine_load_table
45 --source include/execute_to_sync_point.inc
46
47 --echo #
48 --echo # Check PURGE BINARY LOGS can be executed
49 --echo #
50
51 --replace_result $binlog_file BINLOG_FILE
52 --eval PURGE BINARY LOGS TO '$binlog_file'
53
54 --echo #
55 --echo # Continue ALTER TABLE statement
56 --echo #
57
58 --disable_warnings
59 --source include/execute_from_sync_point.inc
60 --enable_warnings
61
62 --echo #
63 --echo # Cleanup
64 --echo #
65
66 DROP TABLE t1;