2
select @@event_scheduler;
6
ERROR HY000: Cannot proceed because system tables used by Event Scheduler were found damaged at server start
7
select event_name from information_schema.events;
8
ERROR HY000: Cannot proceed because system tables used by Event Scheduler were found damaged at server start
9
show create event intact_check;
10
ERROR HY000: Cannot proceed because system tables used by Event Scheduler were found damaged at server start
11
drop event no_such_event;
12
ERROR HY000: Cannot proceed because system tables used by Event Scheduler were found damaged at server start
13
create event intact_check_1 on schedule every 5 hour do select 5;
14
ERROR HY000: Cannot proceed because system tables used by Event Scheduler were found damaged at server start
15
alter event intact_check_1 on schedule every 8 hour do select 8;
16
ERROR HY000: Cannot proceed because system tables used by Event Scheduler were found damaged at server start
17
alter event intact_check_1 rename to intact_check_2;
18
ERROR HY000: Cannot proceed because system tables used by Event Scheduler were found damaged at server start
19
drop event intact_check_1;
20
ERROR HY000: Cannot proceed because system tables used by Event Scheduler were found damaged at server start
21
drop event intact_check_2;
22
ERROR HY000: Cannot proceed because system tables used by Event Scheduler were found damaged at server start
23
drop event intact_check;
24
ERROR HY000: Cannot proceed because system tables used by Event Scheduler were found damaged at server start
25
set global event_scheduler=on;
26
ERROR HY000: Cannot proceed because system tables used by Event Scheduler were found damaged at server start
27
set global event_scheduler=off;
28
ERROR HY000: Cannot proceed because system tables used by Event Scheduler were found damaged at server start
29
show variables like 'event_scheduler';
31
event_scheduler DISABLED
32
Make sure that we still can create and drop databases,
33
and no warnings are produced.
34
drop database if exists mysqltest_database_not_exists;
36
Note 1008 Can't drop database 'mysqltest_database_not_exists'; database doesn't exist
37
create database mysqltest_db1;
38
drop database mysqltest_db1;
39
Restore the original mysql.event table
40
drop table mysql.event;
41
rename table event_like to mysql.event;
42
Now let's restart the server again