I dropped the Opsview database and restored the backup from this night, but it results in the same error:
Reading package lists... Done Building dependency tree Reading state information... Done 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 3 not fully installed or removed. After this operation, 0B of additional disk space will be used. Setting up opsview-core (3.1.0.2553-1hardy1) ... Database opsview detected - upgrading ... Thu Jun 18 16:40:29 2009: Starting for opsview Thu Jun 18 16:40:29 2009: DB at version 3.1.0 New ACLs DBD::mysql::db do failed: Can't create table './opsview/roles_monitoringservers.frm' (errno: 150) [for Statement " CREATE TABLE roles_monitoringservers ( roleid INT, monitoringserverid INT, PRIMARY KEY (roleid, monitoringserverid), INDEX (roleid), CONSTRAINT roles_monitoringservers_role_fk FOREIGN KEY (roleid) REFERENCES roles(id) ON DELETE CASCADE, INDEX (monitoringserverid), CONSTRAINT roles_monitoringservers_monitoringserver_fk FOREIGN KEY (monitoringserverid) REFERENCES monitoringservers(id) ) ENGINE=InnoDB; "] at /usr/local/nagios/installer/upgradedb_opsview.pl line 1424. Thu Jun 18 16:40:29 2009: Finished for opsview dpkg: error processing opsview-core (--configure): subprocess post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of opsview-web: opsview-web depends on opsview-core (>= 3.1.0.2553); however: Package opsview-core is not configured yet. dpkg: error processing opsview-web (--configure): dependency problems - leaving unconfigured dpkg: dependency problems prevent configuration of opsview: opsview depends on opsview-core (>= 3.1.0.2553); however: Package opsview-core is not configured yet. opsview depends on opsview-web (>= 3.1.0.2553); however: Package opsview-web is not configured yet. dpkg: error processing opsview (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: opsview-core opsview-web opsview E: Sub-process /usr/bin/dpkg returned an error code (1) -- Toni Van Remortel System Engineer @ Precision Operations NV +32 3 451 92 20 - [email protected] From:[email protected] [mailto:[email protected]] On Behalf Of Toni Van Remortel Sent:Thursday, June 18, 2009 4:13 PM To:Opsview Users Subject:Re: [opsview-users] Upgrade to 3.1 fails Duncan Ferguson wrote: On 18 Jun 2009, at 14:45, Toni Van Remortel wrote: I could manually solve the error of the access table which could not be created, but now I face this: What error of the access table being created? What was the mysql error number and the error message at the time? DBD::mysql::db do failed: Table 'access' already exists [for Statement " CREATE TABLE access ( id int AUTO_INCREMENT, name varchar(128) NOT NULL, PRIMARY KEY (id), UNIQUE (name) ) ENGINE=InnoDB "] at /usr/local/nagios/installer/upgradedb_opsview.pl line 1404. Because it was already created by the first try (which also stopped on the error below). Setting up opsview-core (3.1.0.2553-1hardy1) ... Database opsview detected - upgrading ... Thu Jun 18 15:39:55 2009: Starting for opsview Thu Jun 18 15:39:55 2009: DB at version 3.1.0 New ACLs DBD::mysql::db do failed: Can't create table './opsview/roles_monitoringservers.frm' (errno: 150) [for Statement " CREATE TABLE roles_monitoringservers ( roleid INT, monitoringserverid INT, PRIMARY KEY (roleid, monitoringserverid), INDEX (roleid), CONSTRAINT roles_monitoringservers_role_fk FOREIGN KEY (roleid) REFERENCES roles(id) ON DELETE CASCADE, INDEX (monitoringserverid), CONSTRAINT roles_monitoringservers_monitoringserver_fk FOREIGN KEY (monitoringserverid) REFERENCES monitoringservers(id) ) ENGINE=InnoDB; "] at /usr/local/nagios/installer/upgradedb_opsview.pl line 1424. Thu Jun 18 15:39:55 2009: Finished for opsview dpkg: error processing opsview-core (--configure): What version of MySQL are you using and what OS/arch is this on? Looks like Ubuntu Hardy? Duncs Ubuntu Hardy indeed. Default installation. I saw too late that my MySQL config didn't had 'innodb_file_per_table=1', so I added it. Thanks, Toni
_______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/listinfo/opsview-users
