[MDEV-26342] Incorrect definition of table mysql.event: Multiple bugs Created: 2021-08-11  Updated: 2022-10-25  Resolved: 2021-09-12

Status: Closed
Project: MariaDB Server
Component/s: Events, Upgrades
Affects Version/s: 10.6.3
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: sjon Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback
Environment:

archlinux


 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

 Comments   
Comment by Sergei Golubchik [ 2021-08-14 ]

what does SHOW CREATE TABLE mysql.event return?

Comment by Simon Avery [ 2022-10-25 ]

(This is old and closed, but still appearing as a top google search so for the benefit of others who may get directed here)

This occurs after mariadb has been upgraded between point versions and before mysql_upgrade has been run. Running *mysql_upgrade *after 10.5 to 10.6 upgrade resolved it for me.

Generated at Thu Feb 08 09:44:34 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.