Well the problem got fixed by Father Time…. A week has passed and the corrupting perfdata entry got scrapped J
That’s good news for me because nagios_servicechecks table is over 1,5 GB in size. BTW: I noticed that SELECT command in runtime database is working very slow. For instance: mysql> SELECT output,perfdata FROM nagios_servicechecks WHERE start_time LIKE '2009-08-05%' LIMIT 10; Empty set (1 min 26.67 sec) Is that how it supposed to be? OpsView itself generates reports quite quickly. Regards Michal Zyzak Administrator img_CCNA_1 +48 71 3761 689 +48 665 351 639 TIM S.A. ul. E. Kwiatkowskiego 24 55-011 Siechnice Poland ------------------------------------------------------------------------------------ This email and any attachments are intended only for the named recipient and may contain confidential and/or privileged material. Any unauthorized copying, dissemination or other use by a person other than the named recipient of this communication is prohibited. If you received this in error or are not named as a recipient, please notify the sender and destroy all copies of this email immediately. ------------------------------------------------------------------------------------ From: [email protected] [mailto:[email protected]] On Behalf Of Duncan Ferguson Sent: Thursday, August 13, 2009 5:25 PM To: Opsview Users Subject: Re: [opsview-users] FW: ODW dataimport error On 12 Aug 2009, at 07:39, Michał Zyzak wrote: It probably has something to do with me tinkering with map.local file. I think the file is ok now I would say it is yes - I would suggest you have to look through the runtime database at the nagios_servicechecks table for the specific rows and fix the perfdata in there - this will allow the import to continue 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 <http://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.
<<image001.gif>>
<<image002.jpg>>
_______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
