Debian Codegraph @

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

raw
1 #
2 # Initialization
3 #
4 RESET MASTER;
5 CREATE TABLE t1 (c INT);
6 FLUSH BINARY LOGS;
7 SHOW BINARY LOGS;
8 Log_name File_size Encrypted
9 binlog.000001 SIZE No
10 binlog.000002 SIZE No
11 #
12 # Execute FLUSH BINARY LOGS but stop on 'at_purge_logs_before_date' sync point
13 #
14 [connection default]
15 [START] FLUSH BINARY LOGS;
16 #
17 # Check errors for LOCK INSTANCE FOR BACKUP operation
18 #
19 SET SESSION lock_wait_timeout = 1;
20 LOCK INSTANCE FOR BACKUP;
21 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
22 #
23 # Continue FLUSH BINARY LOGS operation
24 #
25 [END] FLUSH BINARY LOGS;
26 #
27 # Check no errors for LOCK INSTANCE FOR BACKUP operation
28 #
29 LOCK INSTANCE FOR BACKUP;
30 UNLOCK INSTANCE;
31 #
32 # Cleanup
33 #
34 [connection default]
35 DROP TABLE t1;