[debian-mysql] Bug#411672: mysql-server-5.0: Incorrect file format 'host'

Sat Jul 7 17:37:17 UTC 2007

"mysqld --skip-grants" works in a console.

But when I run "mysql_upgrade", I get the following errors:

# mysql_upgrade
ERROR 130 (HY000) at line 74: Incorrect file format 'user'
ERROR 130 (HY000) at line 78: Incorrect file format 'user'
ERROR 130 (HY000) at line 80: Incorrect file format 'user'
ERROR 130 (HY000) at line 81: Incorrect file format 'host'
ERROR 130 (HY000) at line 82: Incorrect file format 'db'
ERROR 130 (HY000) at line 85: Incorrect file format 'user'
ERROR 130 (HY000) at line 86: Incorrect file format 'db'
ERROR 130 (HY000) at line 87: Incorrect file format 'host'
ERROR 130 (HY000) at line 93: Incorrect file format 'user'
ERROR 130 (HY000) at line 98: Incorrect file format 'user'
ERROR 130 (HY000) at line 104: Incorrect file format 'tables_priv'
ERROR 130 (HY000) at line 107: Incorrect file format 'tables_priv'
ERROR 130 (HY000) at line 116: Incorrect file format 'tables_priv'
ERROR 130 (HY000) at line 130: Incorrect file format 'columns_priv'
ERROR 130 (HY000) at line 134: Incorrect file format 'columns_priv'
ERROR 130 (HY000) at line 144: Incorrect file format 'columns_priv'
ERROR 130 (HY000) at line 152: Incorrect file format 'func'
ERROR 130 (HY000) at line 160: Incorrect file format 'user'
ERROR 130 (HY000) at line 162: Incorrect file format 'user'
ERROR 130 (HY000) at line 173: Incorrect file format 'user'
ERROR 130 (HY000) at line 179: Incorrect file format 'user'
ERROR 130 (HY000) at line 189: Incorrect file format 'db'
ERROR 130 (HY000) at line 192: Incorrect file format 'host'
ERROR 130 (HY000) at line 196: Incorrect file format 'user'
ERROR 130 (HY000) at line 199: Incorrect file format 'db'
ERROR 130 (HY000) at line 200: Incorrect file format 'host'
ERROR 130 (HY000) at line 201: Incorrect file format 'user'
ERROR 130 (HY000) at line 202: Incorrect file format 'func'
ERROR 130 (HY000) at line 206: Incorrect file format 'user'
ERROR 130 (HY000) at line 210: Incorrect file format 'user'
ERROR 130 (HY000) at line 235: Incorrect file format 'db'
ERROR 130 (HY000) at line 240: Incorrect file format 'db'
ERROR 130 (HY000) at line 254: Incorrect file format 'host'
ERROR 130 (HY000) at line 258: Incorrect file format 'host'
ERROR 130 (HY000) at line 272: Incorrect file format 'func'
ERROR 130 (HY000) at line 274: Incorrect file format 'func'
ERROR 130 (HY000) at line 281: Incorrect file format 'user'
ERROR 130 (HY000) at line 286: Incorrect file format 'db'
ERROR 130 (HY000) at line 287: Incorrect file format 'db'
ERROR 130 (HY000) at line 289: Incorrect file format 'host'
ERROR 130 (HY000) at line 290: Incorrect file format 'host'
ERROR 130 (HY000) at line 292: Incorrect file format 'user'
ERROR 130 (HY000) at line 293: Incorrect file format 'user'
ERROR 130 (HY000) at line 298: Incorrect file format 'db'
ERROR 130 (HY000) at line 299: Incorrect file format 'db'
ERROR 130 (HY000) at line 301: Incorrect file format 'host'
ERROR 130 (HY000) at line 302: Incorrect file format 'host'
ERROR 130 (HY000) at line 304: Incorrect file format 'user'
ERROR 130 (HY000) at line 305: Incorrect file format 'user'
ERROR 130 (HY000) at line 310: Incorrect file format 'user'
ERROR 130 (HY000) at line 316: Incorrect file format 'user'
ERROR 130 (HY000) at line 321: Incorrect file format 'db'
ERROR 130 (HY000) at line 322: Incorrect file format 'db'
ERROR 130 (HY000) at line 324: Incorrect file format 'host'
ERROR 130 (HY000) at line 325: Incorrect file format 'host'
ERROR 130 (HY000) at line 327: Incorrect file format 'user'
ERROR 130 (HY000) at line 328: Incorrect file format 'user'
ERROR 130 (HY000) at line 333: Incorrect file format 'db'
ERROR 130 (HY000) at line 334: Incorrect file format 'db'
ERROR 130 (HY000) at line 336: Incorrect file format 'host'
ERROR 130 (HY000) at line 337: Incorrect file format 'host'
ERROR 130 (HY000) at line 339: Incorrect file format 'user'
ERROR 130 (HY000) at line 340: Incorrect file format 'user'
ERROR 130 (HY000) at line 342: Incorrect file format 'db'
ERROR 130 (HY000) at line 343: Incorrect file format 'db'
ERROR 130 (HY000) at line 345: Incorrect file format 'host'
ERROR 130 (HY000) at line 346: Incorrect file format 'host'
ERROR 130 (HY000) at line 351: Incorrect file format 'user'
ERROR 130 (HY000) at line 352: Incorrect file format 'db'
ERROR 130 (HY000) at line 353: Incorrect file format 'host'
ERROR 130 (HY000) at line 358: Incorrect file format 'user'
ERROR 130 (HY000) at line 365: Incorrect file format 'user'
ERROR 130 (HY000) at line 367: Incorrect file format 'user'
ERROR 130 (HY000) at line 368: Incorrect file format 'user'
ERROR 130 (HY000) at line 369: Incorrect file format 'user'
ERROR 130 (HY000) at line 377: Incorrect file format 'procs_priv'
ERROR 130 (HY000) at line 381: Incorrect file format 'procs_priv'
ERROR 130 (HY000) at line 385: Incorrect file format 'procs_priv'
ERROR 130 (HY000) at line 389: Incorrect file format 'procs_priv'
ERROR 130 (HY000) at line 397: Incorrect file format 'proc'
ERROR 130 (HY000) at line 441: Incorrect file format 'proc'
ERROR 130 (HY000) at line 443: Incorrect file format 'proc'

Could this be a leftover from the transition from MySQL 4, or could it be
because I had a hard reboot on an XFS partition?  A Google search provided no
answers.

"mysql_fix_privilege_tables" shows up "done", but in the console running
mysqld I get: "[ERROR] Fatal error: Can't open and lock privilege tables:
Incorrect file format 'host".

I tried myisamchk -re on /var/lib/mysql/mysql/help*.MYI, but that didn't help.

# for i in help*.MYI; do myisamchk -re $i; done
- recovering (with sort) MyISAM-table 'help_category.MYI'
Data records: 36
- Fixing index 1
- Fixing index 2
- recovering (with sort) MyISAM-table 'help_keyword.MYI'
Data records: 385
- Fixing index 1
- Fixing index 2
- recovering (with sort) MyISAM-table 'help_relation.MYI'
Data records: 747
- Fixing index 1
- recovering (with sort) MyISAM-table 'help_topic.MYI'
Data records: 466
- Fixing index 1
Found block with too small length at 12156; Skipped
Found block with too small length at 33824; Skipped
Found link that points at 5918012441908967790 (outside data file) at 39704
Found link that points at 8391086046918615080 (outside data file) at 61892
Found block with too small length at 78908; Skipped
Found block with too small length at 88136; Skipped
Found block with too small length at 108612; Skipped
Found block with too small length at 126372; Skipped
Found link that points at 5566814568808536876 (outside data file) at 137296
Found link that points at 6350357284598806894 (outside data file) at 164984
Found block with too small length at 186860; Skipped
Found block with too small length at 215784; Skipped
Found block with too small length at 226548; Skipped
Found link that points at 4981263500389349742 (outside data file) at 248576
Found link that points at 4909205141864020334 (outside data file) at 312548
Found block that points outside data file at 315892
Found block that points outside data file at 316404
Found block that points outside data file at 316948
Found block that points outside data file at 328316
Found block that points outside data file at 329204
- Fixing index 2

I'm not sure if that last one is serious or not.

Best regards

-- 
Danai SAE-HAN (韓達耐)
--
題目:《泊船瓜洲》
作者:王安石（１０２１－１０８６）

京口瓜洲一水間，鐘山只隔數重山。
春風又綠江南岸，明月何時照我還。

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 252 bytes
Desc: OpenPGP digital signature
Url : http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20070707/65a5dda0/attachment.pgp 