On 22 Jun 2009, at 15:34, Nick Akl wrote: Hi Duncs,
Here are the outputs of each query respectively:
SELECT UNIX_TIMESTAMP(status_update_time) FROM nagios_programstatus;
+------------------------------------+ | UNIX_TIMESTAMP(status_update_time) | +------------------------------------+ | 1245106276 | | 1245706326 | +------------------------------------+
I am concerned there are two timestamps returned here - there should only be one for the active nagios that is running. Can you shut down opsview, clear out that table and restart it again? Let it run for a few minutes and then try the import_runtime again. It would also be worth checking to ensure there are no extra nagios processes running after you have shut opsview down.
Duncs
-- Duncan Ferguson
Senior Developer 
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.com
Opsera 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
