Debian Codegraph @

mysql-test/suite/rpl/r/rpl_show_slave_status_deadlock.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 # Let master and slave synced with t1 table created
7 CREATE TABLE t1 (f INT) ENGINE= INNODB;
8 include/sync_slave_sql_with_master.inc
9 # Setup GLOBAL.DEBUG at slave to reach commit
10 [connection slave]
11 # Adding debug point 'dbug.reached_commit' to @@GLOBAL.debug
12 # Do some DML operation on master so that it will be blocked on
13 # slave as global read lock is in place.
14 [connection master]
15 INSERT INTO t1 VALUES (10);
16 # Issue FLUSH TABLES WITH READ LOCK after Reached is signaled
17 [connection slave]
18 SET DEBUG_SYNC='now WAIT_FOR Reached';
19 FLUSH TABLES WITH READ LOCK;
20 # Let sql thread continue to try to obtain commit lock
21 SET DEBUG_SYNC= 'now SIGNAL signal.commit_continue';
22 # Wait until sql thread enters "Waiting for commit lock" state
23 [connection slave]
24 SHOW SLAVE STATUS;
25 UNLOCK TABLES;
26 # Removing debug point 'dbug.reached_commit' from @@GLOBAL.debug
27 # Restart SQL thread so that it notices debug has changed
28 include/restart_slave.inc
29 [connection master]
30 include/sync_slave_sql_with_master.inc
31 include/diff_tables.inc [master:t1, slave:t1]
32 [connection master]
33 DROP TABLE t1;
34 include/sync_slave_sql_with_master.inc
35 include/rpl_end.inc