Article ID: 128717, created on Apr 21, 2016, last review on Nov 4, 2016

  • Applies to:
  • Odin Business Automation Standard 4.5

Symptoms

The following error appears on attempt to connect databases on OBAS server remotely:

15:13:11 Error loading schema content Error Code: 1558 Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50166, now running 50173. Please use mysql_upgrade to fix this error.   

Cause

Table mysql.proc has incorrect schema (was not upgraded during MySQL upgrade).

Resolution

  1. Create databases backups:

    # mkdir /root/mysql_backups/
    # mysql  -Ne"show databases"|grep -v information_schema|while read db;do mysqldump $db > /root/mysql_backups/$db.`date +%F_%H.%M`.sql;done
    
  2. Run mysql_upgrade

    #mysql_upgrade
    
  3. Make sure that mysql.proc was upgraded and has 20 columns:

    # mysql mysql -Nse "desc proc" | wc -l
    20
    

624ca542e40215e6f1d39170d8e7ec75 caea8340e2d186a540518d08602aa065 400e18f6ede9f8be5575a475d2d6b0a6 70a5401e8b9354cd1d64d0346f2c4a3e

Email subscription for changes to this article
Save as PDF