Page 1 of 1

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

Posted: Sun Sep 22, 2024 3:50 pm
by 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 ?

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

Posted: Sun Sep 22, 2024 3:53 pm
by 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