Debian Codegraph @

mysql-test/suite/binlog/r/binlog_backup_lock_purge_binary_logs.result

raw
1 #
2 # Initialization
3 #
4 CREATE TABLE t1 (c INT);
5 FLUSH BINARY LOGS;
6 #
7 # Lock the instance for backup using con1
8 #
9 LOCK INSTANCE FOR BACKUP;
10 #
11 # Check errors for purge operations
12 #
13 [connection default]
14 PURGE BINARY LOGS TO 'BINLOG_FILE';
15 ERROR HY000: Could not purge binary logs since another session is executing LOCK INSTANCE FOR BACKUP. Wait for that session to release the lock.
16 PURGE BINARY LOGS BEFORE '2019-04-02 22:46:26';
17 ERROR HY000: Could not purge binary logs since another session is executing LOCK INSTANCE FOR BACKUP. Wait for that session to release the lock.
18 #
19 # Unlock the instance for backup using con1
20 #
21 [connection con1]
22 UNLOCK INSTANCE;
23 #
24 # Check no errors for purge operations
25 #
26 [connection default]
27 PURGE BINARY LOGS TO 'BINLOG_FILE';
28 PURGE BINARY LOGS BEFORE '2019-04-02 22:46:26';
29 #
30 # Cleanup
31 #
32 [connection default]
33 DROP TABLE t1;