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

Incorrect definition of table mysql.event: Multiple bugs

    XMLWordPrintable

Details

    Description

      My MariaDB instance currently logs the following message:

      [ERROR] Incorrect definition of table mysql.event: expected column 'definer' at position 3 to have type varchar(, found type char(141).
      [ERROR] mariadbd: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.

      I have multiple issues with this:

      • I've always properly executed mysql_upgrade so the definition should be correct
      • The expected type of the column is displayed truncated / incorrect: varchar(
      • The actual type of the column is also wrong: mysql mysql --execute 'describe `event`;' shows definer having Type varchar(384), not char(141)

      Imo all three of these issues should be fixed

      Attachments

        Activity

          People

            Unassigned Unassigned
            sjon sjon
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.