Pages

Monday 1 September 2014

Plesk Upgrade failed : `Cannot load from mysql.proc. The table is probably corrupted`

Error while Upgrading Plesk,
ERROR 1548 (HY000) at line 67: Cannot load from mysql.proc. The table is probably corrupted

1. Make sure mysql tables are not corrupted. You can use mysqlcheck  utility to do so.
mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow`

If everything looks fine here, go for alternative solutions like repair table (repair table mysql.proc) or;
enable mysql debug log and find the exact error in logs.

Also please make sure that you have checked mysqld.log file,
if you find something like "Incorrect definition of table mysql.proc: expected column 'comment' at position 15 to have type text, found type char(64)."  in mysqld.log file, then you need to ad the missing column in proc table.

Login to mysql and run:
mysql> alter table proc change comment comment text;

No comments:

Post a Comment