Debian Codegraph @

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

raw
1 # === Purpose ===
2 # Check PURGE BINARY LOGS operation is mutually exclusive with BACKUP lock.
3 #
4 # === Requirements ===
5 # R1. PURGE BINARY LOGS must be mutually exclusive with BACKUP operation.
6 #
7 # === Implementation ===
8 #
9 # 1. Create database and tables
10 # 2. Create second connection
11 # 2.1. LOCK INSTANCE FOR BACKUP
12 # 3. Use first connection
13 # 3.1. Check PURGE BINARY LOGS TO/BEFORE cannot proceed
14 # 4. Use second connection
15 # 4.1. UNLOCK INSTANCE
16 # 5. Check PURGE BINARY LOGS TO/BEFORE can proceed
17 # 6. Cleanup
18 #
19 # === References ===
20 #
21 # Bug#35342521 Binary log purge should hold IX backup lock
22 #
23 --source include/have_debug.inc
24 --source include/have_binlog_format_row.inc
25
26 --echo #
27 --echo # Initialization
28 --echo #
29
30 CREATE TABLE t1 (c INT);
31 --let $binlog_file = query_get_value(SHOW MASTER STATUS, File, 1)
32 FLUSH BINARY LOGS;
33
34 --echo #
35 --echo # Lock the instance for backup using con1
36 --echo #
37
38 --connect (con1, localhost, root,,)
39 LOCK INSTANCE FOR BACKUP;
40
41 --echo #
42 --echo # Check errors for purge operations
43 --echo #
44
45 --let $rpl_connection_name = default
46 --source include/rpl_connection.inc
47
48 --replace_result $binlog_file BINLOG_FILE
49 --error ER_CANNOT_PURGE_BINLOG_WITH_BACKUP_LOCK
50 --eval PURGE BINARY LOGS TO '$binlog_file'
51
52 --error ER_CANNOT_PURGE_BINLOG_WITH_BACKUP_LOCK
53 PURGE BINARY LOGS BEFORE '2019-04-02 22:46:26';
54
55 --echo #
56 --echo # Unlock the instance for backup using con1
57 --echo #
58
59 --let $rpl_connection_name = con1
60 --source include/rpl_connection.inc
61 UNLOCK INSTANCE;
62
63 --echo #
64 --echo # Check no errors for purge operations
65 --echo #
66
67 --let $rpl_connection_name = default
68 --source include/rpl_connection.inc
69
70 --replace_result $binlog_file BINLOG_FILE
71 --eval PURGE BINARY LOGS TO '$binlog_file'
72
73 PURGE BINARY LOGS BEFORE '2019-04-02 22:46:26';
74
75 --echo #
76 --echo # Cleanup
77 --echo #
78
79 --let $rpl_connection_name = default
80 --source include/rpl_connection.inc
81
82 DROP TABLE t1;