mysql_upgrade does not fix "Column last_update in table mysql.innodb_table_stats is BINARY(4) NOT NULL but should be INT UNSIGNED NOT NULL"

I recently upgraded my local db (on macOS) from MySQL 5.7 to MariaDb 10.9. Now when I try to do any ALTER TABLE statements I get a "General error: 1025 Error on rename of ...". A bit of searching indicates this is often due to foreign key errors but disabling foreign key checks doesn't help it, and the things I'm trying to alter don't even have foreign keys on them. Digging in to my error log I see a lot of : "[ERROR] InnoDB: Column last_update in table mysql.innodb_table_stats is BINARY(4) NOT NULL but should be INT UNSIGNED NOT NULL" I have tried running mysql_upgrade several times including as root, as that is the proposed fix I've seen for this error, but the error persists. Any other suggestions for how I can fix this?

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.