Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 5.5.34
-
Fix Version/s: 5.5.35
-
Component/s: None
-
Labels:None
Description
Copying host.frm from and old system to MariaDB gave the following error one access, check or repair:
Incorrect key file for table 'host'; try to repair it
This error doesn't tell what is wrong or how to fix it.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
In addition mysql_upgrade doesn't provide any usable error message if used with a not privileged user:
./client/mysql_upgrade --upgrade-system-tables --user=xxx
The --upgrade-system-tables option was used, databases won't be touched.
FATAL ERROR: Upgrade failed
After my changes it now looks like this:
./client/mysql_upgrade --upgrade-system-tables --user=test --password=test --silent
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 1044 (42000): Access denied for user 'test'@'localhost' to database 'mysql'
FATAL ERROR: Upgrade failed
All issues fixed and pushed into 5.5
I have fixed this by adding a new handler error message when the .frm and storage engine definition differs:
Incompatible key or row definition between the MariaDB .frm file and the information in the storage engine. You have to dump and restore the table to fix this
In addition I fixed that REPAIR TABLE .. USE_FRM will fix old tables with same storage format between versions (no VARCHAR fields).