I got this error on Tomcat error log while after I switched the server whcih is installed with MySQL latest version. I used full backup using mysqldump to restore the data. This was the issue I think since new mysql version have diff. table structure in mysql database or changes in engine level.
The error is java.sql.SQLException: Column count of mysql.proc is wrong.
Solution is to execute mysql-upgrade command from the terminal. It will correct the table structure to use the latest engine.
[root@host102]# mysql_upgrade --force
database.xacnts OK
database.xagents OK
database.xcities OK
database.xpaymenttype OK
database.xplan OK
database.xstatus OK
database.xstock OK
database.xx OK
database.zcontrol OK
Running 'mysql_fix_privilege_tables'...
OK
[root@host102]
database.xacnts OK
database.xagents OK
database.xcities OK
database.xpaymenttype OK
database.xplan OK
database.xstatus OK
database.xstock OK
database.xx OK
database.zcontrol OK
Running 'mysql_fix_privilege_tables'...
OK
[root@host102]
Leave a Reply