Debian Codegraph @

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

raw
1 # === Purpose ===
2 # Check FLUSH BINARY LOGS operation is mutually exclusive with BACKUP lock.
3 #
4 # === Requirements ===
5 # R1. FLUSH BINARY LOGS must be mutually exclusive with BACKUP operation.
6 #
7 # === Implementation ===
8 # 1. Initialize
9 # 2. Execute FLUSH BINARY LOGS but stop on 'at_purge_logs_before_date' sync point
10 # 3. Check errors for LOCK INSTANCE FOR BACKUP operation
11 # 4. Continue FLUSH BINARY LOGS operation
12 # 5. Check no errors for LOCK INSTANCE FOR BACKUP operation
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
27 CREATE TABLE t1 (c INT);
28
29 --let $binlog_file = query_get_value(SHOW MASTER STATUS, File, 1)
30 FLUSH BINARY LOGS;
31 --replace_column 2 SIZE
32 SHOW BINARY LOGS;
33
34 --connect (con1, localhost, root,,)
35
36 --echo #
37 --echo # Execute FLUSH BINARY LOGS but stop on 'at_purge_logs_before_date' sync point
38 --echo #
39
40 --let $rpl_connection_name = default
41 --source include/rpl_connection.inc
42
43 --let $statement_connection = con1
44 --let $statement = FLUSH BINARY LOGS
45 --let $sync_point = at_purge_logs_before_date
46 --source include/execute_to_sync_point.inc
47
48 --echo #
49 --echo # Check errors for LOCK INSTANCE FOR BACKUP operation
50 --echo #
51
52 SET SESSION lock_wait_timeout = 1;
53 --error ER_LOCK_WAIT_TIMEOUT
54 LOCK INSTANCE FOR BACKUP;
55
56 --echo #
57 --echo # Continue FLUSH BINARY LOGS operation
58 --echo #
59
60 # Resume FLUSH LOGS
61 --source include/execute_from_sync_point.inc
62
63 --echo #
64 --echo # Check no errors for LOCK INSTANCE FOR BACKUP operation
65 --echo #
66
67 LOCK INSTANCE FOR BACKUP;
68 UNLOCK INSTANCE;
69
70 --echo #
71 --echo # Cleanup
72 --echo #
73
74 --let $rpl_connection_name = default
75 --source include/rpl_connection.inc
76
77 DROP TABLE t1;