Debian Codegraph @

mysql-test/suite/rpl/t/rpl_semi_sync_event.test

raw
1 --source include/not_group_replication_plugin.inc
2 source include/have_semisync_plugin.inc;
3 source include/set_privilege_checks_user_as_system_user.inc;
4 source include/master-slave.inc;
5
6 let $engine_type= InnoDB;
7
8 # Suppress warnings that might be generated during the test
9 disable_query_log;
10 connection master;
11 call mtr.add_suppression("Timeout waiting for reply of binlog");
12 call mtr.add_suppression("Semi-sync source .* waiting for replica reply");
13 call mtr.add_suppression("Read semi-sync reply");
14 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.");
15 call mtr.add_suppression(".*Got an error reading communication packets.*");
16 connection slave;
17 call mtr.add_suppression("Source server does not support semi-sync");
18 call mtr.add_suppression("Semi-sync replica .* reply");
19 call mtr.add_suppression("Replica SQL.*Request to stop replica SQL Thread received while applying a group that has non-transactional changes; waiting for completion of the group");
20 enable_query_log;
21
22 connection master;
23 disable_query_log;
24 let $value = query_get_value(show variables like 'rpl_semi_sync_source_enabled', Value, 1);
25 if ($value == No such row)
26 {
27 set sql_log_bin=0;
28 eval INSTALL PLUGIN rpl_semi_sync_source SONAME '$SEMISYNC_SOURCE_PLUGIN';
29 SET GLOBAL rpl_semi_sync_source_enabled = 1;
30 set sql_log_bin=1;
31 }
32 enable_query_log;
33
34 connection slave;
35 source include/stop_slave.inc;
36
37 disable_query_log;
38 let $value= query_get_value(show variables like 'rpl_semi_sync_replica_enabled', Value, 1);
39 if ($value == No such row)
40 {
41 set sql_log_bin=0;
42 eval INSTALL PLUGIN rpl_semi_sync_replica SONAME '$SEMISYNC_REPLICA_PLUGIN';
43 SET GLOBAL rpl_semi_sync_replica_enabled = 1;
44 set sql_log_bin=1;
45 }
46 enable_query_log;
47
48 source include/start_slave.inc;
49
50 connection master;
51 SET GLOBAL event_scheduler = ON;
52
53 replace_result $engine_type ENGINE_TYPE;
54 eval CREATE TABLE t1 (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, f varchar(8)) ENGINE=$engine_type;
55 INSERT INTO t1 (f) VALUES ('a'),('a'),('a'),('a'),('a');
56 --disable_warnings
57 INSERT INTO t1 SELECT i+5, f FROM t1;
58 INSERT INTO t1 SELECT i+10, f FROM t1;
59 --enable_warnings
60 CREATE EVENT ev1 ON SCHEDULE EVERY 1 SECOND
61 DO INSERT INTO t1 VALUES (SLEEP(5),CONCAT('ev1_',CONNECTION_ID()));
62 CREATE EVENT ev2 ON SCHEDULE EVERY 1 SECOND
63 DO INSERT INTO t1 VALUES (SLEEP(5),CONCAT('ev2_',CONNECTION_ID()));
64
65 connection slave;
66 STOP SLAVE IO_THREAD;
67
68 connection master;
69 let $run = 20;
70 while ($run)
71 {
72 connect (m$run,localhost,root,,);
73 connection m$run;
74 send;
75 eval UPDATE t1 SET f = CONCAT('up_',CONNECTION_ID()) WHERE i = $run;
76 connection master;
77 dec $run;
78 }
79
80 connection master;
81 SET @old_event_scheduler= @@global.event_scheduler;
82 SET GLOBAL event_scheduler = OFF;
83
84 let $run = 20;
85 while ($run)
86 {
87 connection m$run;
88 reap;
89 disconnect m$run;
90 dec $run;
91 }
92
93 #
94 # Clean up
95 #
96 connection slave;
97 source include/stop_slave.inc;
98
99 disable_warnings;
100 UNINSTALL PLUGIN rpl_semi_sync_replica;
101
102 connection master;
103 source include/stop_dump_threads.inc;
104 UNINSTALL PLUGIN rpl_semi_sync_source;
105 enable_warnings;
106
107 connection slave;
108 source include/start_slave.inc;
109
110 connection master;
111 DROP EVENT ev1;
112 DROP EVENT ev2;
113 DROP TABLE t1;
114 SET @@global.event_scheduler= @old_event_scheduler;
115 --source include/sync_slave_sql_with_master.inc
116 --source include/rpl_end.inc