Debian Codegraph @

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

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