The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

Couldn't execute 'show events': Cannot proceed because system tables used by Event Scheduler were found damaged at server start (1577)

Hi!

Being new to MariaDB, I'm unsure if this is the correct forum to pose my question. Please forgive and forward me in the right direction if it is not :)

I've recently upgraded from MySQL to MariaDB on my QNAP TS-410 server and commenced using. I've recently attempted to backup my tables and have been faced with a "Couldn't execute 'show events': Cannot proceed because system tables used by Event Scheduler were found damaged at server start (1577)".

I've browsed the web and the "mysql_upgrade" command is regularly touted; however, this doesn't appear to be on my TS-410. I've also attempted restarting the server via the TS-410 web interface. I approached QNAP who responded they were unable to assist. Which leads me here.

Has anyone encountered a similar or same scenario? And able to provide assistance in resolving?

Thanks in advance

Answer

If you don't have mysql_upgrade, you can manually load the relevant part of mysql_system_tables_fix.sql file. You can simply run it as

# mysql -uroot -f < mysql_system_tables_fix.sql

Make sure you use mysql_system_tables_fix.sql that matches your MariaDB version.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.