You are here

Error message when upgrading database

1 post / 0 new
mholmes_88140
mholmes_88140's picture
Error message when upgrading database

Hi all, I am attempted to migrate one opsview-appliance database to another.  I can get as far as upgrading the database and then restarting the server.

This is the error I get when attempted to upgrade the database with 

nagios@opsview-appliance:~$ /usr/local/nagios/installer/upgradedb.pl

 

Mon Nov 10 19:57:57 2014: Starting for opsview

Mon Nov 10 19:57:57 2014: DB at version 3.15.5
Shared notification profiles
DBD::mysql::db do failed: Cannot delete or update a parent row: a foreign key constraint fails [for Statement "DROP TABLE IF EXISTS sharednotificationprofiles"] at /usr/local/nagios/installer/upgradedb_opsview.pl line 4470.
Mon Nov 10 19:57:57 2014: Finished for opsview
upgrade failed at /usr/local/nagios/installer/upgradedb.pl line 38.