Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_semi_sync_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 include/install_semisync.inc
7 # Initialization
8 SET @debug_save= @@GLOBAL.DEBUG;
9 SET GLOBAL rpl_semi_sync_source_timeout= 6000000;
10 #
11 # Verify no deadlock at AFTER_SYNC
12 #
13 SET GLOBAL debug= 'd,semi_sync_3-way_deadlock';
14 SET GLOBAL debug= '+d,dump_thread_before_read_event';
15 SET DEBUG_SYNC= "before_process_commit_stage_queue WAIT_FOR signal.continue no_clear_event";
16 # Build 10 connections to master server
17 # Execute INSERT statement on these 10 connections in parallel
18 SET DEBUG_SYNC= "before_rotate_binlog SIGNAL signal.continue";
19 # Rotate binlog file
20 FLUSH LOGS;
21 #
22 # Verify no deadlock at AFTER_COMMIT
23 #
24 SET GLOBAL rpl_semi_sync_source_wait_point= AFTER_COMMIT;
25 SET GLOBAL debug= 'd,semi_sync_3-way_deadlock';
26 SET GLOBAL debug= '+d,dump_thread_before_read_event';
27 SET DEBUG_SYNC= "before_process_commit_stage_queue WAIT_FOR signal.continue no_clear_event";
28 # Build 10 connections to master server
29 # Execute INSERT statement on these 10 connections in parallel
30 SET DEBUG_SYNC= "before_rotate_binlog SIGNAL signal.continue";
31 # Rotate binlog file
32 FLUSH LOGS;
33 # Cleanup
34 SET GLOBAL rpl_semi_sync_source_timeout= 600000;
35 include/sync_slave_sql_with_master.inc
36 SET GLOBAL debug= '+d,semi_sync_3-way_deadlock';
37 SET DEBUG_SYNC= "before_process_commit_stage_queue WAIT_FOR signal.rotate_finished";
38 # Build 10 connections to master server
39 # Execute INSERT statement on these 10 connections in parallel
40 SET DEBUG_SYNC= "before_rotate_binlog SIGNAL signal.rotate_finished";
41 # Rotate binlog file
42 FLUSH LOGS;
43 SET DEBUG_SYNC= 'RESET';
44 SET @@GLOBAL.DEBUG= @debug_save;
45 SET GLOBAL rpl_semi_sync_source_wait_point= AFTER_SYNC;
46 include/sync_slave_sql_with_master.inc
47 include/uninstall_semisync.inc
48 include/rpl_end.inc