Debian Codegraph @

mysql-test/suite/rpl/r/rpl_backup_locked_by_applier.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 #
7 # Initialization
8 #
9 # Adding debug point 'syncpoint_purge_applied_logs_after_backup_lock' to @@GLOBAL.debug
10 #
11 # Trigger log purge on replica
12 #
13 [connection master]
14 FLUSH BINARY LOGS;
15 #
16 # Check backup cannot be held
17 #
18 [connection slave]
19 SET DEBUG_SYNC = 'now WAIT_FOR reached_purge_applied_logs_after_backup_lock';
20 SET SESSION lock_wait_timeout = 1;
21 LOCK INSTANCE FOR BACKUP;
22 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
23 #
24 # Unblock applier
25 #
26 SET DEBUG_SYNC = 'now SIGNAL continue_purge_applied_logs_after_backup_lock';
27 # Removing debug point 'syncpoint_purge_applied_logs_after_backup_lock' from @@GLOBAL.debug
28 #
29 # Wait for replica to process the rest of the binlog
30 #
31 [connection master]
32 CREATE TABLE t (a INT);
33 DROP TABLE t;
34 include/sync_slave_sql_with_master.inc
35 #
36 # Check LOCK INSTANCE FOR BACKUP can be executed
37 #
38 SET SESSION lock_wait_timeout = 30;
39 LOCK INSTANCE FOR BACKUP;
40 UNLOCK INSTANCE;
41 #
42 # Cleanup
43 #
44 include/rpl_end.inc