Debian Codegraph @

mysql-test/suite/binlog/t/binlog_purge_binary_logs_backup_lock.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 when
6 # LOCK INSTANCE FOR BACKUP statement is executed.
7 #
8 # === Implementation ===
9 #
10 # 1. Create database and tables
11 # 2. Create second connection
12 # 2.1. Execute PURGE BINARY LOGS but stop it on a sync point
13 # 3. Use first connection
14 # 3.1. Check LOCK INSTANCE FOR BACKUP cannot proceed
15 # 4. Use second connection
16 # 4.1. Finish PURGE BINARY LOGS
17 # 5. Check LOCK INSTANCE FOR BACKUP can proceed
18 # 6. Cleanup
19 #
20 # === References ===
21 #
22 # Bug#35342521 Binary log purge should hold IX backup lock
23 #
24 --source include/have_debug_sync.inc
25 --source include/have_binlog_format_row.inc
26
27 --echo #
28 --echo # Initialization
29 --echo #
30
31 RESET MASTER;
32 CREATE TABLE t1 (c INT);
33
34 --let $binlog_file = query_get_value(SHOW MASTER STATUS, File, 1)
35 FLUSH BINARY LOGS;
36 --replace_column 2 SIZE
37 SHOW BINARY LOGS;
38
39 --connect (con1, localhost, root,,)
40
41 --echo #
42 --echo # Execute PURGE BINARY LOGS but stop on a sync point
43 --echo #
44
45 --let $rpl_connection_name = default
46 --source include/rpl_connection.inc
47
48 --eval PURGE BINARY LOGS TO '$binlog_file'
49 --let $statement_connection = con1
50 --let $statement = PURGE BINARY LOGS TO '$binlog_file'
51 --let $sync_point = before_purge_logs
52 --source include/execute_to_sync_point.inc
53
54 --echo #
55 --echo # Check errors for LOCK INSTANCE FOR BACKUP operation
56 --echo #
57
58 SET SESSION lock_wait_timeout = 1;
59 --error ER_LOCK_WAIT_TIMEOUT
60 LOCK INSTANCE FOR BACKUP;
61
62 --echo #
63 --echo # Continue PURGE BINARY LOGS operation
64 --echo #
65
66 # Resume PURGE LOGS
67 --source include/execute_from_sync_point.inc
68
69 --echo #
70 --echo # Check no errors for LOCK INSTANCE FOR BACKUP operation
71 --echo #
72
73 LOCK INSTANCE FOR BACKUP;
74 UNLOCK INSTANCE;
75
76 --echo #
77 --echo # Cleanup
78 --echo #
79
80 --let $rpl_connection_name = default
81 --source include/rpl_connection.inc
82
83 DROP TABLE t1;