Results 1 to 2 of 2

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

  1. #1
    Join Date
    Mar 2009
    Posts
    103

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

    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

  2. #2
    Join Date
    Apr 2005
    Location
    GMT +7.00
    Posts
    13,601
    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.
    Regards, Alex G.

    - Get the best commercial DirectAdmin support and hire me on poralix.com
    - Follow and like @Poralix on Facebook

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •