Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Debugging error when enabling Event Scheduler

Tags:

mysql

mariadb

I am trying to set up IDE (PHPStorm) to use schema Introspection. To do this I need to enable Event Scheduler. I used this script :

    SET GLOBAL event_scheduler = ON;

Unfortunately I am getting an error :

Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.

I am not sure how to debug this. The error message contains too little information for my knowledge. What cloud be the reason for failed initialization of system tables? I am using 10.4.8-MariaDB

like image 324
sanjihan Avatar asked Feb 20 '26 18:02

sanjihan


1 Answers

Run mysql_upgrade a second time.

https://jira.mariadb.org/browse/MDEV-18788

like image 56
Rick James Avatar answered Feb 22 '26 11:02

Rick James



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!