Problem Upgrading from 11.0.9 to 11.5.29

[mendip_discovery]

[FIXED] Problem Upgrading from 11.0.9 to 11.5.29

Evening all

I have tried through both web based and ssh based upgrade options. I get the same error.

 MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.11.0.9-11.5.29.20130615-220241.dump.gz
 Trying to upgrade APS controller database...
===> Cumulative APS controller database (apsc) upgrade has been started.
 Trying to backup MySQL database... done
 MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.apsc.11.0.9-11.5.29.20130615-220243.dump.gz
ERROR 1548 (HY000) at line 67: Cannot load from mysql.proc. The table is probably corrupted

MySQL: 5.5.32 and I am running PHP: 5.4.16. On a CentOS system.

The apsc database is running as a InnoDB and I have tried a check etc on it and its fine.

Thanks in advance for any advice.€

 

[Nikolay.]

Running mysql_upgrade script might fix your problem.

 

[InderS]

Yes, mysql_upgrade script will fix your issue. Please check it http://blog.servertechsupport.com/mysql-cannot-load-from-mysql-proc-the-table-is-probably-corrupted

 

[GravuTrad]

mysql_upgrade -uadmin -p` cat /etc/psa/.psa.shadow

 

[mendip_discovery]

Well that fixed it. Thanks.

What is strange is that I run this after I do any mysql updates.

mysqlcheck --all-databases --check-upgrade --auto-repair

 

[GravuTrad]

mysql_upgrade -uadmin -p` cat /etc/psa/.psa.shadow

It's: mysql_upgrade -uadmin -p` cat /etc/psa/.psa.shadow`

Didn't fix my problem.