[ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type'

[chris]

Hello

I get the following error in the logs of mariadb/mysql

Code: Select all

mariadbd[721379]: 2024-09-22 17:48:04 1693 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type' at position 9 to have type e…UBLE_PREC_HB').
mariadbd[721379]: 2024-09-22 17:48:04 1693 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type …varbinary(255)

What happend ?

[chris]

found a solution.
Apparently something went wrong or was incomplete with the latest update
to mysql Ver 15.1 Distrib 10.11.6-MariaDB

running the upgrade command solved a lot of problems:

Code: Select all

mysql_upgrade -u root -p