Hi Ton, Thanks for the reply dropping the table helped with the upgrade completing.
As for the history, the original implementation was on 2.14.0 since it was first released then upgraded to 3.0.3.xxxx about few months back and was trying to upgrade to 3.0.4.2486 when this happened. As for the migration I did that on the same server this time the only time I went to new hardware was when I migrated from 2.14 to 3.0 Thank you again, On 2009-06-08 07:15, Ton Voon wrote: > > On 5 Jun 2009, at 22:25, Nick Akl wrote: > > > Fri Jun 5 14:22:53 2009: Starting for runtime-opsview > > Fri Jun 5 14:22:53 2009: DB at version 3.0.0 > > Renaming hostgroups to opsview_hostgroups > > DBD::mysql::db do failed: Table 'opsview_hostgroups' already exists > > [for Statement "RENAME TABLE hostgroups TO opsview_hostgroups"] at / > > usr/local/nagios/installer/upgradedb_runtime.pl line 696. > > Fri Jun 5 14:22:53 2009: Finished for runtime-opsview > > What is the history of the runtime database on this server? Did you do > a migration of the runtime database from a different server? Did you > do a test upgrade and the restore the database? > > To fix, you can drop the table first (mysql> DROP TABLE > opsview_hostgroups) and rerun the installation. > > I'm just trying to work out why you had a problem, if it is widespread > and if we need to delete the table before we do the rename. > > Ton > >
_______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/listinfo/opsview-users
