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

            Assignee:
            Unassigned Unassigned
            Reporter:
            sjon sjon
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration