[MDEV-17718] Setting event_scheduler to DISABLED causes bogus corruption errors Created: 2018-11-14  Updated: 2020-02-19  Resolved: 2020-02-19

Status: Closed
Project: MariaDB Server
Component/s: Events, Variables
Affects Version/s: 10.0, 10.1, 10.2, 10.3, 10.4
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Vladislav Vaintroub
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-19262 Server error message is unclear if ev... Closed
Relates
relates to MDEV-15426 Event scheduler disabled on a slave p... Closed
relates to MDEV-16582 mysqldump: Couldn't execute 'show eve... Closed

 Description   

When event_scheduler is set to DISABLED, event-related activities produce ER_EVENTS_DB_ERROR:

MariaDB [test]> show events;
ERROR 1577 (HY000): Cannot proceed because system tables used by Event Scheduler were found damaged at server start

At the same time, trying to change the value at runtime produces a different error:

MariaDB [test]> set global event_scheduler=on;
ERROR 1290 (HY000): The MariaDB server is running with the --event-scheduler=DISABLED or --skip-grant-tables option so it cannot execute this statement

This is confusing, especially when it comes to investigation of real-life problems.
If we can't distinguish real corruption from the user setting, which is probably the case, maybe it would be best to disallow user to set the option to DISABLED and keep it an internal-only value.



 Comments   
Comment by Geoff Montee (Inactive) [ 2020-02-19 ]

wlad, isn't this one a duplicate of MDEV-19262, which you have already fixed?

Comment by Vladislav Vaintroub [ 2020-02-19 ]

right, this is a duplicate of MDEV-19262,

Generated at Thu Feb 08 08:38:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.