The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

mysql_upgrade failed during update from mysql

Hi, I inherited an older system with a history to somewhere around mysql 5.1 or 5.2. I upgraded from mariadb 5.5 to 10.0.10, but encountered an error during mysql_upgrade

Phase 3/3: Running 'mysql_fix_privilege_tables'... ERROR 1178 (42000) at line 285: The storage engine for the table doesn't support nullable columns FATAL ERROR: Upgrade failed

I expect that this might be due to some previous upgrade with a forgotten mysql_upgrade call, nonetheless, I'm at the dark on how to pinpoint / resolve this.

Would you be so kind and help? Thanks in advance, Pavel

Answer Answered by Ian Gilfillan in this comment.

In MySQL 5.1, some log files were created with NULL fields, so perhaps it's related to this, and you have a null value lurking. See MySQL Bug 49823 for suggestions.

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.