MichaelRios
Contributor
Contributor

Failed 4.1.0 -> 4.1.1 upgrade

Jump to solution
I seem to be having the same general problem with our production Hyperic install, but with a twist...this error is occurring on the very first update attempt even AFTER having the new db-upgrade.xml file in place. If I'm reading all the other threads correctly, this seems to indicate a corrupt schema. What are my options at this point?

Thanks!
mike

--------------------
hyperic@hypersrv:~/packages/hyperic-hq-installer$ ./setup.sh -upgrade
Unpacking JRE to temporary directory /tmp/jre
Initializing Hyperic HQ 4.1.1 Installation...
Loading taskdefs...
Taskdefs loaded
Enter full path of HQ server to upgrade: [default '']:
/opt/hyperic/hq/server
HQ server installation path [default '/opt/hyperic/hq']:

Loading install configuration...
Install configuration loaded.
Preparing to install...
Validating server install configuration...
Checking server webapp port...
Checking server secure webapp port...
Checking server JRMP port...
Checking server JNP port...
Checking database permissions...
Validating server DB configuration...
Upgrading the server...
Unpacking server to: /opt/hyperic/hq/server-4.1.1...
Creating server configuration files...
Copying binaries and libraries to server installation...
Copying server configuration file...
Copying server control file...
Copying server binaries...
Copying server libs...
Setting up server database...
Upgrading database...
--------------------------------------------------------------------------------
An ERROR occurred, the installation cannot continue.
FATAL EXCEPTION at /opt/hyperic/packages/hyperic-hq-installer/installer-4.1.1/data/setup.xml:402: : The following error occurred while executing this line:
/opt/hyperic/packages/hyperic-hq-installer/installer-4.1.1/data/setup.xml:416: The following error occurred while executing this line:
/opt/hyperic/packages/hyperic-hq-installer/installer-4.1.1/data/setup.xml:531: The following error occurred while executing this line:
/opt/hyperic/packages/hyperic-hq-installer/installer-4.1.1/data/setup-db-MySQL.xml:21: The following error occurred while executing this line:
/opt/hyperic/packages/hyperic-hq-installer/installer-4.1.1/data/setup-db-common.xml:95: The following error occurred while executing this line:
/opt/hyperic/packages/hyperic-hq-installer/installer-4.1.1/data/db-upgrade.xml:28: DBUpgrader: Database schema is in an inconsistent state: version=3.137 *** UPGRADE IN PROGRESS: migrating to version 3.138
--------------------------------------------------------------------------------
Deleting temporary JRE
0 Kudos
1 Solution

Accepted Solutions
admin
Immortal
Immortal
This means that your database upgrade was aborted at some point in the
past during the 3.138 schema version. What you might do is to crack
open the db-upgrade.xml and see what statements are in <schemaSpec
version="3.138"> that apply to your database and try to complete
those. If things fail to drop, it's fine. Then after you have done
that, you'll want to update your EAM_CONFIG_PROP table to schema
version 3.138 so that the installer will continue:

UPDATE EAM_CONFIG_PROPS SET PROPVALUE = '3.138' WHERE PROPKEY =
'CAM_SCHEMA_VERSION';

Charles


View solution in original post

0 Kudos
1 Reply
admin
Immortal
Immortal
This means that your database upgrade was aborted at some point in the
past during the 3.138 schema version. What you might do is to crack
open the db-upgrade.xml and see what statements are in <schemaSpec
version="3.138"> that apply to your database and try to complete
those. If things fail to drop, it's fine. Then after you have done
that, you'll want to update your EAM_CONFIG_PROP table to schema
version 3.138 so that the installer will continue:

UPDATE EAM_CONFIG_PROPS SET PROPVALUE = '3.138' WHERE PROPKEY =
'CAM_SCHEMA_VERSION';

Charles


0 Kudos