On 27 Aug 2009, at 16:08, Toni Van Remortel wrote:
It seems that the upgrade procedure fails again on the database:
Setting up opsview-core (3.3.0.2987-1hardy1) ...
Database opsview detected - upgrading ...
Thu Aug 27 17:00:49 2009: Starting for opsview
Thu Aug 27 17:00:49 2009: DB at version 2.14.5
DBD::mysql::db do failed: Error on rename of './opsview/
servicecheckdependencies' to './opsview/#sql2-130a-5a67e' (errno:
152) [for Statement "ALTER TABLE servicecheckdependencies DROP
FOREIGN KEY servicecheckdependencies_dependencyid_fk"] at /usr/local/
nagios/installer/upgradedb_opsview.pl line 1338.
Thu Aug 27 17:00:49 2009: Finished for opsview
dpkg: error processing opsview-core (--configure):
subprocess post-installation script returned error exit status 1
Database at version 2.14.5 ??? I'm upgrading from 3.1 !!
If this upgrade step never passed, then future upgrades will try to
run this step again.
What does 'show create table servicecheckdependencies' say? Mysql docs
say an error 152 is an incorrect foreign key name.
Ton
_______________________________________________
Opsview-users mailing list
[email protected]
http://lists.opsview.org/lists/listinfo/opsview-users
