[MDEV-16582] mysqldump: Couldn't execute 'show events': Cannot proceed because system tables used by Event Scheduler were found damaged at server start (1577) Created: 2018-06-25  Updated: 2019-01-04  Resolved: 2018-07-31

Status: Closed
Project: MariaDB Server
Component/s: Scripts & Clients
Affects Version/s: 10.1.19, 10.1.32
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Michael Rempel Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: None
Environment:

Centos 6 running as a VM on Azure


Issue Links:
Relates
relates to MDEV-17718 Setting event_scheduler to DISABLED c... Closed

 Description   

Backup refuses to run on the command line. Error is the summary
mysqldump --user=myuser --password=mypassword --host=127.0.0.1 --default-character-set=utf8 --single-transaction=TRUE --routines --events "mydb" > mydb.sql

Permissions are correct, this is from a batch job that runs nightly. Has worked in the past. Both the source backup db and the destination test db are having this issue.



 Comments   
Comment by Elena Stepanova [ 2018-07-02 ]

What happens if you connect to mydb using the client and run SHOW EVENTS directly?

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