Debian Codegraph @

mysql-test/suite/binlog/t/binlog_flush_logs_blocked_by_backup.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 skip purge operation when executed
6 # with LOCK INSTANCE FOR BACKUP statement
7 #
8 # === Implementation ===
9 # 1. Initialize
10 # 2. Lock instance for backup
11 # 3. Flush binary logs so replay log is purged
12 # 4. Check that relay logs have not been purged
13 # 5. Unlock instance
14 # 6. Generate log purge
15 # 7. Check relay logs have been purged
16 #
17 # === References ===
18 # Bug#35342521 Binary log purge should hold IX backup lock
19 #
20 --source include/have_debug.inc
21 --source include/have_debug_sync.inc
22 --source include/have_binlog_format_row.inc
23
24 --echo #
25 --echo # Initialize
26 --echo #
27
28 --let $MYSQLD_DATADIR = `SELECT @@datadir`
29
30 --let $binlog_expire_logs_seconds_saved = `SELECT @@global.binlog_expire_logs_seconds`
31 SET @@global.binlog_expire_logs_seconds = 1;
32
33 RESET MASTER;
34
35 FLUSH BINARY LOGS;
36 FLUSH BINARY LOGS;
37
38 --echo #
39 --echo # Lock instance for backup
40 --echo #
41
42 --connect (con1, localhost, root,,)
43
44 --let $rpl_connection_name = con1
45 --source include/rpl_connection.inc
46
47 LOCK INSTANCE FOR BACKUP;
48
49 --echo #
50 --echo # Flush binary logs so binary logs are purged
51 --echo #
52
53 --let $rpl_connection_name = default
54 --source include/rpl_connection.inc
55
56 --source include/save_error_log_position.inc
57
58 --let $before_flush = query_get_value(SHOW BINARY LOGS, Log_name, 1)
59 # wait longer than binlog_expire_logs_seconds
60 --sleep 2
61 FLUSH BINARY LOGS;
62 --let $after_flush = query_get_value(SHOW BINARY LOGS, Log_name, 1)
63
64 --echo #
65 --echo # Check that binary logs have not been purged
66 --echo #
67
68 --assert($before_flush == $after_flush)
69
70 --let $error_pattern = Could not purge binary logs since another session is executing LOCK INSTANCE FOR BACKUP. Wait for that session to release the lock.
71 --source include/assert_error_log.inc
72
73 --echo #
74 --echo # Unlock instance
75 --echo #
76
77 --let $rpl_connection_name = con1
78 --source include/rpl_connection.inc
79
80 UNLOCK INSTANCE;
81
82 --echo #
83 --echo # Generate log purge
84 --echo #
85
86 --let $rpl_connection_name = default
87 --source include/rpl_connection.inc
88
89 --source include/save_error_log_position.inc
90
91 --let $before_flush = query_get_value(SHOW BINARY LOGS, Log_name, 1)
92 FLUSH BINARY LOGS;
93 --let $after_flush = query_get_value(SHOW BINARY LOGS, Log_name, 1)
94
95 --echo #
96 --echo # Check relay logs have been purged
97 --echo #
98
99 --assert($before_flush != $after_flush)
100
101 --let $error_pattern = NONE
102 --source include/assert_error_log.inc
103
104 --echo #
105 --echo # Cleanup
106 --echo #
107
108 --replace_result $binlog_expire_logs_seconds_saved BINLOG_EXPIRE_LOGS_SECONDS_SAVED
109 --eval SET @@global.binlog_expire_logs_seconds = $binlog_expire_logs_seconds_saved