Debian Codegraph @

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

raw
1 ##############################################################################
2 # ==== Purpose ====
3 # The purpose of this test is to verify that with "LOCK INSTANCE FOR BACKUP"
4 # taken explicit purge implied by "PURGE BINARY LOGS" is blocked i.e expired
5 # binary logs are not removed
6 #
7 # ==== Requirement ====
8 # R1. With "LOCK INSTANCE FOR BACKUP" taken "PURGE BINARY LOGS TO" should not
9 # remove binary logs.
10 # R2. With "LOCK INSTANCE FOR BACKUP" taken "PURGE BINARY LOGS BEFORE" should
11 # not remove binary logs.
12 #
13 # ==== Implementation ====
14 # 1. Save current binlog file name
15 # 2. Generate new binlogs
16 # 3. Case1: Purge binlogs using 'PURGE BINARY LOGS TO'
17 # 3.1 Lock instance for backup
18 # 3.2 Purge binlogs
19 # 3.3 Verify that binlogs are not purged
20 # 3.4 Unlock instance
21 # 4. Case2: Purge binlogs using 'PURGE BINARY LOGS BEFORE'
22 # 4.1 Lock instance for backup
23 # 4.2 Purge binlogs
24 # 4.3 Verify that binlogs are not purged
25 # 4.4 Unlock instance
26 #
27 # ==== References ====
28 # BUG#33437026: BINARY LOGS ARE GETTING REMOVED WHEN PURGE BINARY LOGS
29 # WITH 'BACKUP LOCK'
30 ###############################################################################
31
32 --source include/have_binlog_format_row.inc
33
34 --disable_query_log
35 CALL mtr.add_suppression("Could not purge binary logs since another session is executing LOCK INSTANCE FOR BACKUP. Wait for that session to release the lock.");
36 --enable_query_log
37
38 RESET MASTER;
39
40 --echo #
41 --echo # 1. Save current binlog file name
42 --source include/save_binlog_position.inc
43 --let $first_binlog_file = $binlog_file
44
45 --echo #
46 --echo # 2. Generate new binlogs
47 FLUSH BINARY LOGS;
48 FLUSH BINARY LOGS;
49
50 --echo #
51 --echo # 3. Case1: Purge binlogs using 'PURGE BINARY LOGS TO'
52 --echo #
53 --echo # 3.1 Lock instance for backup
54 LOCK INSTANCE FOR BACKUP;
55
56 --echo #
57 --echo # 3.2 Purge binlogs
58 --source include/save_binlog_position.inc
59
60 FLUSH BINARY LOGS;
61
62 --replace_result $binlog_file BINLOG_FILE
63 --error ER_CANNOT_PURGE_BINLOG_WITH_BACKUP_LOCK
64 --eval PURGE BINARY LOGS TO '$binlog_file'
65
66 --echo #
67 --echo # 3.3 Verify that binlogs are not purged
68 --let $binlog_name = query_get_value(SHOW MASTER LOGS, Log_name, 1)
69 --let $assert_text = Expected binary log file
70 --let $assert_cond = "$binlog_name" = "$first_binlog_file"
71 --source include/assert.inc
72
73 --echo #
74 --echo # 3.4 Unlock instance for backup
75 UNLOCK INSTANCE;
76
77 --echo #
78 --echo # 4. Case2: Purge binlogs using 'PURGE BINARY LOGS BEFORE'
79 --echo #
80 --echo # 4.1 Lock instance for backup
81 LOCK INSTANCE FOR BACKUP;
82
83 --echo #
84 --echo # 4.2 Purge binlogs
85 let $date = `select NOW()`;
86
87 FLUSH BINARY LOGS;
88
89 --disable_query_log
90 --error ER_CANNOT_PURGE_BINLOG_WITH_BACKUP_LOCK
91 --eval PURGE BINARY LOGS BEFORE '$date'
92 --enable_query_log
93
94 --echo #
95 --echo # 4.3 Verify that binlogs are not purged
96 --let $binlog_name = query_get_value(SHOW MASTER LOGS, Log_name, 1)
97 --let $assert_text = Expected binary log file
98 --let $assert_cond = "$binlog_name" = "$first_binlog_file"
99 --source include/assert.inc
100
101 --echo #
102 --echo # 4.4 Unlock instance
103 UNLOCK INSTANCE;