I tried upgrading my CentOS 5.4 host running Opsview 2.14 to 3.7.0 Community Edition and it failed because of incorrect key file for table './runtime/nagios_hostchecks.MYI'. I tried running upgradedb.pl manually as the nagios user and got the same error. Any ideas? Below is the output from the upgrade process: Downloading Packages: (1/5): opsview-web-3.7.0.4272-1.ct5.noarch.rpm | 487 kB 00:00 (2/5): opsview-core-3.7.0.4272-1.ct5.noarch.rpm | 2.1 MB 00:03 (3/5): opsview-base-3.7.0.4272-1.ct5.i386.rpm | 6.3 MB 00:11 (4/5): opsview-reports-2.2.3.255-1.ct5.noarch.rpm | 15 MB 00:27 (5/5): opsview-perl-3.7.0.318-1.ct5.i386.rpm | 17 MB 00:30 ------------------------------------------------------------------------ -------- Total 551 kB/s | 40 MB 01:15 Running rpm_check_debug Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction Updating : opsview-base 1/10 Updating : opsview-perl 2/10 Updating : opsview-reports 3/10 Stopping opsview... done Updating : opsview-core 4/10 Thu Apr 29 11:54:23 2010: Starting for opsview Thu Apr 29 11:54:23 2010: DB at version 2.14.5 Updated database to version 2.14.6 Thu Apr 29 11:54:23 2010: DB at version 2.14.6 Updated database to version 2.14.7 Thu Apr 29 11:54:23 2010: DB at version 2.14.7 Updated database to version 2.14.8 Thu Apr 29 11:54:23 2010: DB at version 2.14.8 Converting all <> in host and hostgroup information to escaped HTML characters Updated database to version 2.14.9 Thu Apr 29 11:54:23 2010: DB at version 3.0.0 Updated database to version 3.0.1 Thu Apr 29 11:54:23 2010: DB at version 3.0.1 Updating all auditlog entries to UTC - this may take some time Updated database to version 3.0.2 Thu Apr 29 11:54:23 2010: DB at version 3.0.2 Updating RRDs - running this in the background. Check /tmp/migrate_rrds.log for status When migration has finished, you will need to do an Opsview reload to get all the associated performance icons Updated database to version 3.0.3 Thu Apr 29 11:54:23 2010: DB at version 3.0.3 Updated database to version 3.0.4 Thu Apr 29 11:54:23 2010: DB at version 3.1.0 New ACLs Updated database to version 3.1.1 Thu Apr 29 11:54:24 2010: DB at version 3.1.1 Updated database to version 3.1.2 Thu Apr 29 11:54:24 2010: DB at version 3.1.2 Checking for hostgroup constraint No problems with hostgroup hierarchy names Updated database to version 3.1.3 Thu Apr 29 11:54:25 2010: DB at version 3.1.3 Adding extra host configuration values Updated database to version 3.1.4 Thu Apr 29 11:54:25 2010: DB at version 3.3.0 Updated database to version 3.3.1 Thu Apr 29 11:54:25 2010: DB at version 3.3.1 Updated database to version 3.3.2 Thu Apr 29 11:54:25 2010: DB at version 3.3.2 Updated database to version 3.3.3 Thu Apr 29 11:54:25 2010: DB at version 3.3.3 Updated database to version 3.3.4 Thu Apr 29 11:54:25 2010: DB at version 3.3.4 Adding language settings to contacts Updated database to version 3.3.5 Thu Apr 29 11:54:25 2010: DB at version 3.3.5 Adding rancid_autoenable to hosts Updated database to version 3.3.6 Thu Apr 29 11:54:25 2010: DB at version 3.3.6 Adding keywords to contacts table Updated database to version 3.3.7 Thu Apr 29 11:54:25 2010: DB at version 3.3.7 Adding netdisco URL Updated database to version 3.3.8 Thu Apr 29 11:54:26 2010: DB at version 3.3.8 Increasing useragent id column width Updated database to version 3.3.9 Thu Apr 29 11:54:26 2010: DB at version 3.5.0 Increasing contact's mobile field Updated database to version 3.5.1 Thu Apr 29 11:54:26 2010: DB at version 3.5.1 Adding freshness interval options to service checks Updated database to version 3.5.2 Thu Apr 29 11:54:26 2010: DB at version 3.5.2 Adding markdown filter Updated database to version 3.5.3 Thu Apr 29 11:54:26 2010: DB at version 3.5.3 Adding modules table Updated database to version 3.5.4 Thu Apr 29 11:54:26 2010: DB at version 3.6.0 Creating CONFIGUREVIEW and CONFIGURESAVE access and adding to all roles with ADMINACCESS Updated database to version 3.6.1 Thu Apr 29 11:54:26 2010: DB at version 3.7.0 Adding extra columns to notificationmethods Updated database to version 3.7.1 Thu Apr 29 11:54:26 2010: DB at version 3.7.1 Adding new notification profile tables Updated database to version 3.7.2 Thu Apr 29 11:54:26 2010: DB at version 3.7.2 Adding flap detection field for hosts Updated database to version 3.7.3 Thu Apr 29 11:54:26 2010: DB at version 3.7.3 Adding namespace to notificationmethods Updated database to version 3.7.4 Thu Apr 29 11:54:26 2010: DB at version 3.7.4 Adding notificationmethod variables table Updated database to version 3.7.5 Thu Apr 29 11:54:26 2010: DB at version 3.7.5 Removing redundant system preferences Updated database to version 3.7.6 Thu Apr 29 11:54:26 2010: DB at version 3.7.6 Adding constraint to notificationprofiles Updated database to version 3.7.7 Finished updating Opsview database Thu Apr 29 11:54:27 2010: Finished for opsview Upgrading Nagios part of Runtime database Thu Apr 29 11:54:27 2010: Starting for runtime-nagios Thu Apr 29 11:54:27 2010: DB at version 3.0.0 Converting tables to Innodb - this could take a long time DBD::mysql::db do failed: Incorrect key file for table './runtime/nagios_hostchecks.MYI'; try to repair it [for Statement "DELETE FROM `nagios_hostchecks` WHERE start_time <= ?"] at /usr/local/nagios/installer/upgradedb_runtime.pl line 121. Thu Apr 29 11:54:43 2010: Finished for runtime-nagios upgrade failed at /usr/local/nagios/installer/upgradedb.pl line 35. Upgrading database failed, you will have to perform this step manually (run '/usr/local/nagios/installer/upgradedb.pl' as nagios) error: %post(opsview-core-3.7.0.4272-1.ct5.noarch) scriptlet failed, exit status 1 Stopping opsview-web: done Updating : opsview-web 5/10 Starting opsview-web: You can connect to your server at http://opsview.xxx.xxx <http://opsview.xxx.xxx> Cleanup : opsview-perl 6/10 Cleanup : opsview-web 7/10 Cleanup : opsview-reports 8/10 NRPE stopped Cleanup : opsview-base 9/10 Updated: opsview-base.i386 0:3.7.0.4272-1.ct5 opsview-core.noarch 0:3.7.0.4272-1.ct5 opsview-perl.i386 0:3.7.0.318-1.ct5 opsview-reports.noarch 0:2.2.3.255-1.ct5 opsview-web.noarch 0:3.7.0.4272-1.ct5 Complete!
---------------------------- Gordon Terrell Systems Administrator Health Communications, Inc. 1400 Key Blvd, Suite 700 Arlington, VA 22209-1547 (P): 703-524-1200 x326 (P): 800-438-8477 (F): 703-524-1487 www.gettips.com
_______________________________________________ Opsview-users mailing list Opsview-users@lists.opsview.org http://lists.opsview.org/lists/listinfo/opsview-users
