Debian Codegraph @

mysql-test/suite/rpl/r/rpl_applier_blocked_by_backup.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 # Lock replica for backup
8 #
9 [connection slave]
10 include/save_error_log_position.inc
11 LOCK INSTANCE FOR BACKUP;
12 #
13 # Flush binary logs so relay log is tried to be purged
14 #
15 [connection master]
16 FLUSH BINARY LOGS;
17 #
18 # Check that relay logs have not been purged on replica
19 #
20 include/sync_slave_sql_with_master.inc
21 ./slave-relay-bin.000001
22 ./slave-relay-bin.000002
23 ./slave-relay-bin.000003
24 ./slave-relay-bin.000004
25 include/assert_error_log.inc [server: 2, pattern: Could not purge binary logs since another session is executing LOCK INSTANCE FOR BACKUP. Wait for that session to release the lock.
26 Could not purge binary logs since another session is executing LOCK INSTANCE FOR BACKUP. Wait for that session to release the lock.]
27 #
28 # Unblock backup on replica
29 #
30 include/save_error_log_position.inc
31 UNLOCK INSTANCE;
32 #
33 # Generate log purge from source onto replica
34 #
35 [connection master]
36 FLUSH BINARY LOGS;
37 #
38 # Check relay logs have been purged on replica
39 #
40 include/sync_slave_sql_with_master.inc
41 ./slave-relay-bin.000005
42 ./slave-relay-bin.000006
43 include/assert_error_log.inc [server: 2, pattern: NONE]
44 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.");
45 #
46 # Cleanup
47 #
48 [connection master]
49 include/rpl_end.inc