C. Bensend wrote:
> Hmmmmm...  I've been running b9 for a year now, and I haven't
> noticed any issues.  What is the nature of these issues that
> you mention?  Just because I haven't noticed doesn't mean
> something bad isn't happening to my data...
>    

depends on your data being processed. duplicate rows bug in 
servicechecks table e.g. affects historical data processing afterwards.
try a

mysql> show create table nagios_servicechecks;

and check if the unique keys are set correctly. the other way around, 
try selecting several rows from that table, and check for 
start_time/end_time being zero. 2 rows having the unique keys

(`instance_id`,`service_object_id`,`start_time`,`start_time_usec`)

or only one row?


another patch regarding customvariables config is in cvs but never got 
released. basically ndo2db segfaults because of a too small defined array for 
inserting/updating custom variables configuration (this only happens if you 
dump config and use custom vars).

some other changes which affect performance like binary casting for case 
sensitive compares are also there. so if you don't need ssl over tcp, reports 
for 1.4b7 are just more fine then.

read further on that thread: 
http://www.mail-archive.com/nagios-users@lists.sourceforge.net/msg32793.html

Kind regards,
Michael

PS: The proposed patch for the duplicated rows is rather small. but it can't be 
applied on existing installations as mysql will complain about unique 
constraint violation of existing data then. but at least patching that for 
fresh installs would generate more benefit.



-- 
DI (FH) Michael Friedrich

Vienna University Computer Center
Universitaetsstrasse 7 A-1010 Vienna, Austria

email:  michael.friedr...@univie.ac.at
phone:  +43 1 4277 14359
fax:    +43 1 4277 14279
web:    http://www.univie.ac.at/zid

Icinga Core&  IDOUtils Developer
http://www.icinga.org


------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting 
any issue. 
::: Messages without supporting info will risk being sent to /dev/null

Reply via email to