Article ID: 117103, created on Sep 4, 2013, last review on Sep 10, 2014

  • Applies to:
  • Operations Automation 5.4

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.

ac82ce33439a9c1feec4ff4f2f638899 caea8340e2d186a540518d08602aa065 5356b422f65bdad1c3e9edca5d74a1ae 2554725ed606193dd9bbce21365bed4e e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF