Thanks for the response. I reverted Opsview to version 3.0 in the meantime (restore DB from backup, and use dpkg to install the previous .deb files).
The installation I tried to upgrade is one I migrated from an older installation to a new one. I used mysqldump to export the database. Perhaps that's the source of the problem? Anyway, tomorrow I'll try to convert the tables to InnoDB and try the upgrade again. Regards, Toni -----Original message----- From: Duncan Ferguson <[email protected]> Sent: Sat 20-06-2009 00:18 To: Opsview Users <[email protected]>; Subject: Re: [opsview-users] Upgrade to 3.1 fails On 19 Jun 2009, at 07:13, Toni Van Remortel wrote: > >> Can you please do the following within mysql and send the output? >> >> show create table roles; > mysql> show create table roles\G > *************************** 1. row *************************** > Table: roles > Create Table: CREATE TABLE `roles` ( > `id` int(11) NOT NULL auto_increment, > `name` varchar(128) NOT NULL, > `fixedname` varchar(16) NOT NULL, > PRIMARY KEY (`id`), > UNIQUE KEY `fixedname` (`fixedname`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1 > 1 row in set (0.10 sec) >> show create table monitoringservers; > > mysql> show create table monitoringservers\G > *************************** 1. row *************************** > Table: monitoringservers > Create Table: CREATE TABLE `monitoringservers` ( > `id` int(11) NOT NULL auto_increment, > `name` varchar(64) NOT NULL, > `host` int(11) default NULL, > `role` enum('Master','Slave') default 'Slave', > `activated` int(11) NOT NULL default '1', > `uncommitted` int(11) NOT NULL default '0', > PRIMARY KEY (`id`), > UNIQUE KEY `name` (`name`), > KEY `monitoringservers_host_fk` (`host`) > ) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1 > 1 row in set (0.01 sec) Ton has already responded to this but his emails are getting stuck somewhere. This is because these tables are MyISAM and not InnoDB - if you can convert them and then rereun the upgrade it should work. Now we have to find out why they weren't converted in the first place. Duncs -- Duncan Ferguson Senior Developer
_______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/listinfo/opsview-users
