🇩🇪 Deutsch

24 Oct 2024

MySQL/MariaDB: Incorrect definition of table mysql.column_stats

Fehler, die beim Upgrade der MySQL-Version immmer wieder auftreten, und ihre Behebung



  • Incorrect Definition of column_stats
 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type varbinary(255), found type longblob.
  • Behebung
 ALTER TABLE mysql.column_stats MODIFY histogram varbinary(255);
  • Incorrect Definition of event
 [ERROR] Incorrect definition of table mysql.event: expected column 'definer' at position 3 to have type char(, found type varchar(384).
 [ERROR] Incorrect definition of table mysql.event: expected column 'collation_connection' at position 19 to have type char(32), found type char(64).
 [ERROR] Incorrect definition of table mysql.event: expected column 'db_collation' at position 20 to have type char(32), found type char(64).
  • Behebung
 ALTER TABLE mysql.event MODIFY definer char;
 ALTER TABLE mysql.event MODIFY collation_connection char(32);
 ALTER TABLE mysql.event MODIFY db_collation char(32);