Symptoms

When upgrading POA-managed MySQL4 database hosting server to MySQL5 via the 'Mysql_ctl' utility, the following error is thrown:

Execution failed with code: 3, and message: Unexpected error, (<class exceptions.ValueError at 0xb748db0c>, <exceptions.ValueError instance at 0xb7271dec>, <traceback object at 0xb721402c>)

Cause

One of the upgrade scripts cannot be executed.

Resolution

  1. Check the POA Agent log file poa.log on the MySQL server on which upgrade is performed for HCL request being received when upgrade is being run. The HCL request should contain the following line:

    <ARG protected="no" value="/usr/local/pem/bin/MySQL/PYTHON_SCRIPT"/>

    where PYTHON_SCRIPT is the name of a particular script to be executed during the upgrade.

  2. Edit the file /usr/local/pem/bin/MySQL/PYTHON_SCRIPT found on the previous step - replace the line

    if c['Type'].lower().find("decimal") == -1:

    with 

    if c['Type'].lower().find("decimal") != 0:
  3. Run the upgrade once again.

Internal content