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
<<inline: image001.gif>>
Opsera Limited | Unit 69 Suttons Business Park Reading | Berkshire | RG6 1AZ | UK Phone: +44 (0) 845 057 7887 Mobile: +44 (0) 7968 148 748 Skype: duncan_j_ferguson Email: [email protected] www.opsera.comOpsera Limited is registered in the UK under Company Number 5396532. Our registered office is Gorse View, Horsell Rise, Woking, Surrey, GU21 4RB.
_______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/listinfo/opsview-users
