ERROR 1805 (HY000): Column count of mysql.proc is wrong

open4biz

Verified User
Joined
Mar 22, 2009
Messages
103
I updated to the latest version of MariaDB (10.2.24) but the mysql.proc table didn't come along for the ride. When I ran

Code:
mysql_upgrade --force --verbose --verbose other-options -u root -p
I see the following issues at the end of the process:

Code:
Phase 4/7: Running 'mysql_fix_privilege_tables'
ERROR 1805 (HY000) at line 579: Column count of mysql.proc is wrong. Expected 20, found 21. The table is probably corrupted
ERROR 1805 (HY000) at line 581: Column count of mysql.proc is wrong. Expected 20, found 21. The table is probably corrupted
ERROR 1805 (HY000) at line 589: Column count of mysql.proc is wrong. Expected 20, found 21. The table is probably corrupted
ERROR 1805 (HY000) at line 591: Column count of mysql.proc is wrong. Expected 20, found 21. The table is probably corrupted
FATAL ERROR: Upgrade failed
cp: '/usr/lib/libmysqlclient.so' and '/usr/lib/mysql/libmysqlclient.so' are the same file
Restarting MySQL.
I've scoured the internets and tried the following fix with no success:

Anyone else have some hot tip(s) to fix this issue?

Cheers
 

zEitEr

Super Moderator
Joined
Apr 11, 2005
Messages
13,934
Location
GMT +7.00
Hello,

I believe, it should be fixed now. The error as far as I can say occurred because of an In-Place Downgrade of MariaDB from 10.3 to 10.2.
 
Top