Debian Codegraph @

mysql-test/suite/events/events_restart.result

raw
1 set global event_scheduler=off;
2 create database events_test;
3 use events_test;
4 create table execution_log(name char(10));
5 create event abc1 on schedule every 1 second do
6 insert into execution_log value('abc1');
7 Warnings:
8 Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it.
9 create event abc2 on schedule every 1 second do
10 insert into execution_log value('abc2');
11 Warnings:
12 Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it.
13 create event abc3 on schedule every 1 second do
14 insert into execution_log value('abc3');
15 Warnings:
16 Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it.
17 create table event_like like mysql.event;
18 insert into event_like select * from mysql.event;
19 alter table mysql.event
20 change column body body longtext character set utf8 collate utf8_bin;
21 # Now we restart the server
22 call mtr.add_suppression("Incorrect definition of table mysql.event:.*");
23 # restart
24 use events_test;
25 select @@event_scheduler;
26 @@event_scheduler
27 OFF
28 show events;
29 ERROR HY000: Cannot proceed, because event scheduler is disabled
30 select event_name from information_schema.events;
31 ERROR HY000: Cannot proceed, because event scheduler is disabled
32 show create event intact_check;
33 ERROR HY000: Cannot proceed, because event scheduler is disabled
34 drop event no_such_event;
35 ERROR HY000: Cannot proceed, because event scheduler is disabled
36 create event intact_check_1 on schedule every 5 hour do select 5;
37 ERROR HY000: Cannot proceed, because event scheduler is disabled
38 alter event intact_check_1 on schedule every 8 hour do select 8;
39 ERROR HY000: Cannot proceed, because event scheduler is disabled
40 alter event intact_check_1 rename to intact_check_2;
41 ERROR HY000: Cannot proceed, because event scheduler is disabled
42 drop event intact_check_1;
43 ERROR HY000: Cannot proceed, because event scheduler is disabled
44 drop event intact_check_2;
45 ERROR HY000: Cannot proceed, because event scheduler is disabled
46 drop event intact_check;
47 ERROR HY000: Cannot proceed, because event scheduler is disabled
48 set global event_scheduler=on;
49 ERROR HY000: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
50 set global event_scheduler=off;
51 ERROR HY000: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
52 show variables like 'event_scheduler';
53 Variable_name Value
54 event_scheduler OFF
55 # Make sure that we still can create and drop databases,
56 # and no warnings are produced.
57 drop database if exists mysqltest_database_not_exists;
58 Warnings:
59 Note 1008 Can't drop database 'mysqltest_database_not_exists'; database doesn't exist
60 create database mysqltest_db1;
61 drop database mysqltest_db1;
62 Warnings:
63 Error 1545 Failed to open mysql.event
64 # Restore the original mysql.event table
65 drop table mysql.event;
66 rename table event_like to mysql.event;
67 # check that we can now enable events without restart
68 set global event_scheduler=original;
69 Warnings:
70 Note 1408 Event Scheduler: Loaded 3 events
71 select @@global.event_scheduler;
72 @@global.event_scheduler
73 ON
74 set global event_scheduler=on;
75 select @@global.event_scheduler;
76 @@global.event_scheduler
77 ON
78 show events;
79 Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
80 events_test abc1 root@localhost SYSTEM RECURRING # 1 SECOND # # ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci
81 events_test abc2 root@localhost SYSTEM RECURRING # 1 SECOND # # ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci
82 events_test abc3 root@localhost SYSTEM RECURRING # 1 SECOND # # ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci
83 # Now let's restart the server again
84 # restart
85 use events_test;
86 select @@event_scheduler;
87 @@event_scheduler
88 ON
89 drop table execution_log;
90 drop database events_test;
91 #
92 # Test for bug#11748899 -- EVENT SET TO DISABLED AND ON COMPLETION
93 # NOT PRESERVE IS DELETED AT SERVER
94 #
95 SELECT @@event_scheduler;
96 @@event_scheduler
97 ON
98 USE test;
99 DROP EVENT IF EXISTS e1;
100 CREATE EVENT e1 ON SCHEDULE EVERY 1 SECOND DISABLE DO SELECT 1;
101 SHOW EVENTS;
102 Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
103 test e1 root@localhost SYSTEM RECURRING # 1 SECOND # # DISABLED 1 latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
104 # Now we restart the server
105 # restart
106 USE test;
107 SELECT @@event_scheduler;
108 @@event_scheduler
109 ON
110 SHOW EVENTS;
111 Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
112 test e1 root@localhost SYSTEM RECURRING # 1 SECOND # # DISABLED 1 latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
113 DROP EVENT e1;
114 # end test for bug#11748899
115 #
116 # Test for MDEV-21758 Events switched randomly to SLAVESIDE_DISABLED
117 #
118 create event ev on schedule every 1 minute do set @a= 1;
119 select name, originator, status from mysql.event;
120 name originator status
121 ev 1 ENABLED
122 #
123 # Restarting server with server_id=100
124 #
125 # restart: --server-id=100
126 select @@global.server_id;
127 @@global.server_id
128 100
129 select name, originator, status from mysql.event;
130 name originator status
131 ev 1 ENABLED
132 set global server_id= 1;
133 #
134 # Restarting server with the original server_id=1
135 #
136 # restart
137 select @@global.server_id;
138 @@global.server_id
139 1
140 select name, originator, status from mysql.event;
141 name originator status
142 ev 1 ENABLED
143 drop event ev;