Debian Codegraph @

mysql-test/suite/events/events_stress.test

raw
1 # Can't test with embedded server that doesn't support grants
2 --source include/not_embedded.inc
3 --source include/big_test.inc
4
5 CREATE DATABASE IF NOT EXISTS events_test;
6 #
7 # DROP DATABASE test start (bug #16406)
8 #
9 CREATE DATABASE events_conn1_test2;
10 # BUG#20676: MySQL in debug mode has a limit of 100 waiters
11 # (in mysys/thr_lock.c), so use three different tables to insert into.
12 CREATE TABLE events_test.fill_it1(test_name varchar(20), occur datetime);
13 CREATE TABLE events_test.fill_it2(test_name varchar(20), occur datetime);
14 CREATE TABLE events_test.fill_it3(test_name varchar(20), occur datetime);
15 CREATE USER event_user2@localhost;
16 CREATE DATABASE events_conn2_db;
17 GRANT ALL ON *.* TO event_user2@localhost;
18 CREATE USER event_user3@localhost;
19 CREATE DATABASE events_conn3_db;
20 GRANT ALL ON *.* TO event_user3@localhost;
21 connect (conn2,localhost,event_user2,,events_conn2_db);
22 --echo "In the second connection we create some events which won't be dropped till the end"
23 --disable_query_log
24 --disable_warnings
25 let $1= 50;
26 while ($1)
27 {
28 eval CREATE EVENT conn2_ev$1 ON SCHEDULE EVERY 1 SECOND DO INSERT INTO events_test.fill_it1 VALUES("conn2_ev$1", NOW());
29 dec $1;
30 }
31 --enable_query_log
32 connect (conn3,localhost,event_user3,,events_conn3_db);
33 --echo "In the second connection we create some events which won't be dropped till the end"
34 --disable_query_log
35 let $1= 50;
36 while ($1)
37 {
38 eval CREATE EVENT conn3_ev$1 ON SCHEDULE EVERY 1 SECOND DO INSERT INTO events_test.fill_it1 VALUES("conn3_ev$1", NOW());
39 dec $1;
40 }
41 --enable_query_log
42 connection default;
43 USE events_conn1_test2;
44 CREATE EVENT ev_drop1 ON SCHEDULE EVERY 10 MINUTE DISABLE DO SELECT 1;
45 CREATE EVENT ev_drop2 ON SCHEDULE EVERY 10 MINUTE DISABLE DO SELECT 1;
46 CREATE EVENT ev_drop3 ON SCHEDULE EVERY 10 MINUTE DISABLE DO SELECT 1;
47 USE events_test;
48 --disable_service_connection
49 SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS;
50 SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_SCHEMA='events_conn1_test2';
51 DROP DATABASE events_conn1_test2;
52 SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_SCHEMA='events_conn1_test2';
53 --enable_service_connection
54
55 --echo "Now testing stability - dropping db -> events while they are running"
56 CREATE DATABASE events_conn1_test2;
57 USE events_conn1_test2;
58 --disable_query_log
59 let $1= 50;
60 while ($1)
61 {
62 eval CREATE EVENT conn1_round1_ev$1 ON SCHEDULE EVERY 1 SECOND DO INSERT INTO events_test.fill_it2 VALUES("conn1_round1_ev$1", NOW());
63 dec $1;
64 }
65 --enable_query_log
66 SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_SCHEMA='events_conn1_test2';
67 SET @old_event_scheduler=@@event_scheduler;
68 SET GLOBAL event_scheduler=on;
69 --sleep 2.5
70 DROP DATABASE events_conn1_test2;
71
72 SET GLOBAL event_scheduler=off;
73 SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_SCHEMA='events_conn1_test2';
74 CREATE DATABASE events_conn1_test3;
75 USE events_conn1_test3;
76 --disable_query_log
77 let $1= 50;
78 while ($1)
79 {
80 eval CREATE EVENT conn1_round2_ev$1 ON SCHEDULE EVERY 1 SECOND DO INSERT INTO events_test.fill_it2 VALUES("conn1_round2_ev$1", NOW());
81 dec $1;
82 }
83 --enable_query_log
84 SET GLOBAL event_scheduler=on;
85 SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_SCHEMA='events_conn1_test3';
86 CREATE DATABASE events_conn1_test4;
87 USE events_conn1_test4;
88 --disable_query_log
89 let $1= 50;
90 while ($1)
91 {
92 eval CREATE EVENT conn1_round3_ev$1 ON SCHEDULE EVERY 1 SECOND DO INSERT INTO events_test.fill_it3 VALUES("conn1_round3_ev$1", NOW());
93 dec $1;
94 }
95 --enable_query_log
96
97 CREATE DATABASE events_conn1_test2;
98 USE events_conn1_test2;
99 --disable_query_log
100 let $1= 50;
101 while ($1)
102 {
103 eval CREATE EVENT ev_round4_drop$1 ON SCHEDULE EVERY 1 SECOND DO INSERT INTO events_test.fill_it3 VALUES("conn1_round4_ev$1", NOW());
104 dec $1;
105 }
106 --enable_query_log
107 SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_SCHEMA='events_conn1_test2';
108 --sleep 2.5
109 connection conn2;
110 --send
111 DROP DATABASE events_conn2_db;
112 connection conn3;
113 --send
114 DROP DATABASE events_conn3_db;
115 connection default;
116 # --send
117 DROP DATABASE events_conn1_test2;
118 DROP DATABASE events_conn1_test3;
119 SET GLOBAL event_scheduler=off;
120 DROP DATABASE events_conn1_test4;
121 SET GLOBAL event_scheduler=on;
122 connection conn2;
123 reap;
124 disconnect conn2;
125 connection conn3;
126 reap;
127 disconnect conn3;
128 connection default;
129 USE events_test;
130 DROP TABLE fill_it1;
131 DROP TABLE fill_it2;
132 DROP TABLE fill_it3;
133 --disable_query_log
134 DROP USER event_user2@localhost;
135 DROP USER event_user3@localhost;
136 --enable_query_log
137 #
138 # DROP DATABASE test end (bug #16406)
139 #
140
141 DROP DATABASE events_test;
142
143 # Cleanup
144 SET GLOBAL event_scheduler=@old_event_scheduler;
145 --source include/check_events_off.inc