Debian Codegraph @

mysql-test/suite/group_replication/r/gr_concurrent_events_insert_with_select.result

raw
1 include/group_replication.inc [rpl_server_count=3]
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 server1]
6 #
7 # Create the test table on server 1
8 #
9 [connection server1]
10 CREATE TABLE IF NOT EXISTS t1 (a INT PRIMARY KEY);
11 include/rpl_sync.inc
12 #
13 # Create the events in each member.
14 #
15 SET @old_event_scheduler= @@global.event_scheduler;
16 SET SESSION sql_log_bin= 0;
17 SET GLOBAL event_scheduler=on|
18 CREATE EVENT IF NOT EXISTS test.event1
19 ON SCHEDULE
20 EVERY 1 SECOND
21 STARTS CURRENT_TIMESTAMP + INTERVAL 1 SECOND
22 ENDS CURRENT_TIMESTAMP + INTERVAL 30 SECOND
23 ON COMPLETION PRESERVE
24 DISABLE
25 COMMENT 'Test with events'
26 DO
27 BEGIN
28 DECLARE v INTEGER;
29 DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
30 SET v=0;
31 WHILE v < 1000
32 DO
33 SELECT max(a) + 1 INTO v FROM t1;
34 INSERT INTO t1 values (v);
35 SET v = v+1;
36 END WHILE;
37 END|
38 SET SESSION sql_log_bin= 1;
39 [connection server2]
40 SET @old_event_scheduler= @@global.event_scheduler;
41 SET SESSION sql_log_bin= 0;
42 SET GLOBAL event_scheduler=on|
43 CREATE EVENT IF NOT EXISTS test.event2
44 ON SCHEDULE
45 EVERY 1 SECOND
46 STARTS CURRENT_TIMESTAMP + INTERVAL 1 SECOND
47 ENDS CURRENT_TIMESTAMP + INTERVAL 30 SECOND
48 ON COMPLETION PRESERVE
49 DISABLE
50 COMMENT 'Test with events'
51 DO
52 BEGIN
53 DECLARE v INTEGER;
54 DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
55 SET v=0;
56 WHILE v < 1000
57 DO
58 SELECT max(a) + 1 INTO v FROM t1;
59 INSERT INTO t1 values (v);
60 SET v = v+1;
61 END WHILE;
62 END|
63 SET SESSION sql_log_bin= 1;
64 [connection server3]
65 SET @old_event_scheduler= @@global.event_scheduler;
66 SET SESSION sql_log_bin= 0;
67 SET GLOBAL event_scheduler=on|
68 CREATE EVENT IF NOT EXISTS test.event3
69 ON SCHEDULE
70 EVERY 1 SECOND
71 STARTS CURRENT_TIMESTAMP + INTERVAL 1 SECOND
72 ENDS CURRENT_TIMESTAMP + INTERVAL 30 SECOND
73 ON COMPLETION PRESERVE
74 DISABLE
75 COMMENT 'Test with events'
76 DO
77 BEGIN
78 DECLARE v INTEGER;
79 DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
80 SET v=0;
81 WHILE v < 1000
82 DO
83 SELECT max(a) + 1 INTO v FROM t1;
84 INSERT INTO t1 values (v);
85 SET v = v+1;
86 END WHILE;
87 END|
88 SET SESSION sql_log_bin= 1;
89 #
90 # Start the events in each member.
91 #
92 [connection server1]
93 SET GLOBAL event_scheduler=on;
94 SET SESSION sql_log_bin= 0;
95 ALTER EVENT event1 ENABLE;
96 SET SESSION sql_log_bin= 1;
97 [connection server2]
98 SET GLOBAL event_scheduler=on;
99 SET SESSION sql_log_bin= 0;
100 ALTER EVENT event2 ENABLE;
101 SET SESSION sql_log_bin= 1;
102 [connection server3]
103 SET GLOBAL event_scheduler=on;
104 SET SESSION sql_log_bin= 0;
105 ALTER EVENT event3 ENABLE;
106 SET SESSION sql_log_bin= 1;
107 #
108 # Wait for the events to be disabled
109 #
110 [connection server1]
111 [connection server2]
112 [connection server3]
113 #
114 # Check the members are still operational
115 #
116 [connection server1]
117 include/assert.inc ['The group replication applier channel is ON']
118 [connection server2]
119 include/assert.inc ['The group replication applier channel is ON']
120 [connection server3]
121 include/assert.inc ['The group replication applier channel is ON']
122 #
123 # Remove the events and the data
124 #
125 [connection server1]
126 SET SESSION sql_log_bin= 0;
127 DROP EVENT IF EXISTS test.event1;
128 SET SESSION sql_log_bin= 1;
129 SET GLOBAL event_scheduler= @old_event_scheduler;
130 [connection server2]
131 SET SESSION sql_log_bin= 0;
132 DROP EVENT IF EXISTS test.event2;
133 SET SESSION sql_log_bin= 1;
134 SET GLOBAL event_scheduler= @old_event_scheduler;
135 [connection server3]
136 SET SESSION sql_log_bin= 0;
137 DROP EVENT IF EXISTS test.event3;
138 SET SESSION sql_log_bin= 1;
139 SET GLOBAL event_scheduler= @old_event_scheduler;
140 [connection server1]
141 DROP TABLE t1;
142 include/group_replication_end.inc