Debian Codegraph @

mysql-test/suite/rpl/t/rpl_backup_locked_by_applier.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 # 1. Initialization
9 # 2. Trigger log purge on replica
10 # 3. Check backup cannot be held
11 # 4. Unblock applier
12 # 5. Check LOCK INSTANCE FOR BACKUP can be executed
13 #
14 # === References ===
15 # Bug#35342521 Binary log purge should hold IX backup lock
16 #
17 --source include/have_debug.inc
18 --source include/have_debug_sync.inc
19 --source include/have_binlog_format_row.inc
20 --source include/master-slave.inc
21
22 --echo #
23 --echo # Initialization
24 --echo #
25
26 --connection slave
27 --let $debug_point = syncpoint_purge_applied_logs_after_backup_lock
28 --source include/add_debug_point.inc
29
30 --echo #
31 --echo # Trigger log purge on replica
32 --echo #
33
34 --source include/rpl_connection_master.inc
35 FLUSH BINARY LOGS;
36
37 --echo #
38 --echo # Check backup cannot be held
39 --echo #
40
41 --source include/rpl_connection_slave.inc
42
43 ## Wait for applier thread to reach purge_applied_logs_after_backup_lock
44 SET DEBUG_SYNC = 'now WAIT_FOR reached_purge_applied_logs_after_backup_lock';
45
46 SET SESSION lock_wait_timeout = 1;
47 --error ER_LOCK_WAIT_TIMEOUT
48 LOCK INSTANCE FOR BACKUP;
49
50 --echo #
51 --echo # Unblock applier
52 --echo #
53
54 SET DEBUG_SYNC = 'now SIGNAL continue_purge_applied_logs_after_backup_lock';
55
56 --let $debug_point = syncpoint_purge_applied_logs_after_backup_lock
57 --source include/remove_debug_point.inc
58
59 --echo #
60 --echo # Wait for replica to process the rest of the binlog
61 --echo #
62
63 # This is necessary to ensure that the replica doesn't have pending
64 # rotate events at the time we acquire the backup locks. Such pending
65 # rotate events would generate warnings in the log.
66
67 --source include/rpl_connection_master.inc
68 CREATE TABLE t (a INT);
69 DROP TABLE t;
70 --source include/sync_slave_sql_with_master.inc
71
72 --echo #
73 --echo # Check LOCK INSTANCE FOR BACKUP can be executed
74 --echo #
75
76 SET SESSION lock_wait_timeout = 30;
77 LOCK INSTANCE FOR BACKUP;
78 UNLOCK INSTANCE;
79
80 --echo #
81 --echo # Cleanup
82 --echo #
83
84 --source include/rpl_end.inc