Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-16582

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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.1.19, 10.1.32
    • N/A
    • Scripts & Clients
    • None
    • Centos 6 running as a VM on Azure

    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.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              michaelrempel Michael Rempel
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.