Bug #52972 upgrading to 5.5
Submitted: 20 Apr 2010 8:53 Modified: 20 Apr 2010 9:23
Reporter: Claudiu Cc Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Installing Severity:S2 (Serious)
Version:5.5.3 OS:Linux
Assigned to: CPU Architecture:Any
Tags: upgrade

[20 Apr 2010 8:53] Claudiu Cc 
Description:
I have installed 5.5.3 over a 5.1.45 /var/lib/mysql dir. Worked, but running mysql_upgrade I get this error.

Running 'mysql_fix_privilege_tables'...
ERROR 1548 (HY000) at line 167: Cannot load from mysql.proc. The table is probably corrupted
ERROR 1548 (HY000) at line 168: Cannot load from mysql.proc. The table is probably corrupted
ERROR 1548 (HY000) at line 181: Cannot load from mysql.proc. The table is probably corrupted
FATAL ERROR: Upgrade failed

From logs:
[ERROR] Incorrect definition of table mysql.proc: expected column 'comment' at position 15 to have type text, found type char(64).

It worked second time though. Maybe a fix should be added for this.

How to repeat:
upgrade from 5.1 to 5.5
[20 Apr 2010 9:23] Sveta Smirnova 
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

Duplicate of bug #52444