Activities

November 2012
M T W T F S S
« Oct   Dec »
 1234
567891011
12131415161718
19202122232425
2627282930  

java.sql.SQLException: Column count of mysql.proc is wrong.

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]

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>