| 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 |
# TC1. Lock instance for backup while `STOP SLAVE` executes |
| 8 |
# |
| 9 |
[connection slave] |
| 10 |
SET DEBUG = "+d,stop_replica_dont_release_backup_lock"; |
| 11 |
[connection slave1] |
| 12 |
CALL mtr.add_suppression("Lock wait timeout exceeded; try restarting transaction"); |
| 13 |
SET DEBUG = "+d,stop_replica_dont_release_backup_lock"; |
| 14 |
[connection slave] |
| 15 |
STOP SLAVE; |
| 16 |
[connection slave1] |
| 17 |
SET DEBUG_SYNC = "now WAIT_FOR replica_acquired_backup_lock"; |
| 18 |
LOCK INSTANCE FOR BACKUP; |
| 19 |
ERROR HY000: Lock wait timeout exceeded; try restarting transaction |
| 20 |
SET DEBUG_SYNC = "now SIGNAL tried_to_lock_instance_for_backup"; |
| 21 |
[connection slave] |
| 22 |
Warnings: |
| 23 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 24 |
START SLAVE; |
| 25 |
Warnings: |
| 26 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 27 |
[connection slave] |
| 28 |
SET DEBUG = "-d,stop_replica_dont_release_backup_lock"; |
| 29 |
[connection slave1] |
| 30 |
SET DEBUG = "-d,stop_replica_dont_release_backup_lock"; |
| 31 |
# |
| 32 |
# TC2. Lock instance for backup while `STOP SLAVE SQL_THREAD` executes |
| 33 |
# |
| 34 |
[connection slave] |
| 35 |
SET DEBUG = "+d,stop_replica_dont_release_backup_lock"; |
| 36 |
[connection slave1] |
| 37 |
CALL mtr.add_suppression("Lock wait timeout exceeded; try restarting transaction"); |
| 38 |
SET DEBUG = "+d,stop_replica_dont_release_backup_lock"; |
| 39 |
[connection slave] |
| 40 |
STOP SLAVE SQL_THREAD; |
| 41 |
[connection slave1] |
| 42 |
SET DEBUG_SYNC = "now WAIT_FOR replica_acquired_backup_lock"; |
| 43 |
LOCK INSTANCE FOR BACKUP; |
| 44 |
ERROR HY000: Lock wait timeout exceeded; try restarting transaction |
| 45 |
SET DEBUG_SYNC = "now SIGNAL tried_to_lock_instance_for_backup"; |
| 46 |
[connection slave] |
| 47 |
Warnings: |
| 48 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 49 |
START SLAVE; |
| 50 |
Warnings: |
| 51 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 52 |
[connection slave] |
| 53 |
SET DEBUG = "-d,stop_replica_dont_release_backup_lock"; |
| 54 |
[connection slave1] |
| 55 |
SET DEBUG = "-d,stop_replica_dont_release_backup_lock"; |
| 56 |
include/rpl_end.inc |