NODutils: Duplicate lines in servicechecks table for each service check

[Julien Mathis]

Hi

I've already reported this bug 6 months ago, but it still not fixed. You can
find information in the tracker :

http://tracker.nagios.org/view.php?id=4

Any information from devel team ?

Regards
--
Julien  MATHIS | Directeur Technique

jmathis at merethis.com
Tél : +33(0)1.78.12.00.23
Mobile  : +33(0)6.85.43.88.38

MERETHIS est éditeur du logiciel Centreon.


2009/11/2 Øyvind Nordang <oyvind.nordang at gmail.com>

> Hi
>
> OS: Ubuntu 8.10 64bit
> Nagios 3.2.0
> NDOutils: 1.4b9
>
> When I check the servicechecks table each check of a service is listed
> twice, but not with the same information in both rows.
>
> I've pasted two sample rows from my database here. They are both from
> the same service check. All fields before start_time is identical, so
> I didn't paste them. service_object_id is the same for both rows.
>
> start_time | start_time_usec | end_time | end_time_usec |
> command_object_id | command_args | command_line | timeout |
> early_timeout | execution_time | latency | return_code output |
> long_output | perfdata
> 2009-11-02 12:53:28 | 124478 | 1970-01-01 01:00:00 | 0 | 21 |
> 250!400!RSZDT | /usr/local/nagios/libexec/check_procs -w 250 -c 40...
> | 60 | 0 | 0 | 0.124 | 0 | PROCS OK: 13 processes with STATE = RSZDT
> 2009-11-02 12:53:28 | 124478 | 2009-11-02 12:53:28 | 139766 | 0 | | |
> 60 | 0 | 0.01529 | 0.124 | 0 | PROCS OK: 13 processes with STATE =
> RSZDT
>
>
> In dbhandlers.c on line 1518 all I can think of is that ON DUPLICATE
> KEY UPDATE does not work as it should. I haven't had time to look at
> the code and programming isn't my strong side.
>
>        if(asprintf(&buf,"INSERT INTO %s SET %s, command_object_id='%lu',
> command_args='%s', command_line='%s' ON DUPLICATE KEY UPDATE %s"
>                    ,ndo2db_db_tablenames[NDO2DB_DBTABLE_SERVICECHECKS]
>                    ,buf1
>                    ,command_id
>                    ,es[0]
>                    ,es[1]
>                    ,buf1
>                   )==-1)
>                buf=NULL;
>
> Hope someone can clarify this for me, is this a bug in nagios, ndoutil
> or have I done something wrong...
>
> Thanks in advance.
>
> --
> Øyvind Nordang
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Nagios-devel mailing list
> Nagios-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/developers/attachments/20091102/0c91ab6e/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
-------------- next part --------------
_______________________________________________
Nagios-devel mailing list
Nagios-devel at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-devel