Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_sql_thread_killed_waiting_commit_lock.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 call mtr.add_suppression("Query execution was interrupted.");
7 call mtr.add_suppression("The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state");
8 # Let master and slave synced with t1 table created
9 CREATE TABLE t1 (f INT) ENGINE= INNODB;
10 include/sync_slave_sql_with_master.inc
11 # Setup GLOBAL.DEBUG at slave to reach commit
12 [connection slave]
13 SET @@GLOBAL.DEBUG= '+d,dbug.reached_commit';
14 # Do some DML operation on master so that it will be blocked on
15 # slave as global read lock is in place.
16 [connection master]
17 INSERT INTO t1 VALUES (10);
18 # Issue FLUSH TABLES WITH READ LOCK after Reached is signaled
19 [connection slave]
20 SET DEBUG_SYNC='now WAIT_FOR Reached';
21 FLUSH TABLES WITH READ LOCK;
22 # Let sql thread continue to try to obtain commit lock
23 SET DEBUG_SYNC= 'now SIGNAL signal.commit_continue';
24 # Wait until sql thread enters "Waiting for commit lock" state
25 # Kill sql thread
26 include/wait_for_slave_sql_error.inc [errno=1317]
27 # Restart sql thread to let it finish the replication
28 SET @@GLOBAL.DEBUG= '-d,dbug.reached_commit';
29 UNLOCK TABLES;
30 include/assert.inc [Exec_Master_Log_Pos in SHOW SLAVE STATUS must be equal to mater_log_pos in slave's repository]
31 include/start_slave_sql.inc
32 [connection master]
33 include/sync_slave_sql_with_master.inc
34 include/diff_tables.inc [master:t1, slave:t1]
35 [connection master]
36 DROP TABLE t1;
37 include/rpl_end.inc