Hi <br><br>I've already reported this bug 6 months ago, but it still not fixed. You can find information in the tracker :<br><br><a href="http://tracker.nagios.org/view.php?id=4">http://tracker.nagios.org/view.php?id=4</a><br clear="all">
<br>Any information from devel team ?<br><br>Regards<br>--<br>Julien MATHIS | Directeur Technique<br><br><a href="mailto:jmathis@merethis.com">jmathis@merethis.com</a><br>Tél : +33(0)1.78.12.00.23<br>Mobile : +33(0)6.85.43.88.38<br>
<br>MERETHIS est éditeur du logiciel Centreon.<br>
<br><br><div class="gmail_quote">2009/11/2 Øyvind Nordang <span dir="ltr"><<a href="mailto:oyvind.nordang@gmail.com">oyvind.nordang@gmail.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi<br>
<br>
OS: Ubuntu 8.10 64bit<br>
Nagios 3.2.0<br>
NDOutils: 1.4b9<br>
<br>
When I check the servicechecks table each check of a service is listed<br>
twice, but not with the same information in both rows.<br>
<br>
I've pasted two sample rows from my database here. They are both from<br>
the same service check. All fields before start_time is identical, so<br>
I didn't paste them. service_object_id is the same for both rows.<br>
<br>
start_time | start_time_usec | end_time | end_time_usec |<br>
command_object_id | command_args | command_line | timeout |<br>
early_timeout | execution_time | latency | return_code output |<br>
long_output | perfdata<br>
2009-11-02 12:53:28 | 124478 | 1970-01-01 01:00:00 | 0 | 21 |<br>
250!400!RSZDT | /usr/local/nagios/libexec/check_procs -w 250 -c 40...<br>
| 60 | 0 | 0 | 0.124 | 0 | PROCS OK: 13 processes with STATE = RSZDT<br>
2009-11-02 12:53:28 | 124478 | 2009-11-02 12:53:28 | 139766 | 0 | | |<br>
60 | 0 | 0.01529 | 0.124 | 0 | PROCS OK: 13 processes with STATE =<br>
RSZDT<br>
<br>
<br>
In dbhandlers.c on line 1518 all I can think of is that ON DUPLICATE<br>
KEY UPDATE does not work as it should. I haven't had time to look at<br>
the code and programming isn't my strong side.<br>
<br>
if(asprintf(&buf,"INSERT INTO %s SET %s, command_object_id='%lu',<br>
command_args='%s', command_line='%s' ON DUPLICATE KEY UPDATE %s"<br>
,ndo2db_db_tablenames[NDO2DB_DBTABLE_SERVICECHECKS]<br>
,buf1<br>
,command_id<br>
,es[0]<br>
,es[1]<br>
,buf1<br>
)==-1)<br>
buf=NULL;<br>
<br>
Hope someone can clarify this for me, is this a bug in nagios, ndoutil<br>
or have I done something wrong...<br>
<br>
Thanks in advance.<br>
<br>
--<br>
Øyvind Nordang<br>
<br>
------------------------------------------------------------------------------<br>
Come build with us! The BlackBerry(R) Developer Conference in SF, CA<br>
is the only developer event you need to attend this year. Jumpstart your<br>
developing skills, take BlackBerry mobile applications to market and stay<br>
ahead of the curve. Join us from November 9 - 12, 2009. Register now!<br>
<a href="http://p.sf.net/sfu/devconference" target="_blank">http://p.sf.net/sfu/devconference</a><br>
_______________________________________________<br>
Nagios-devel mailing list<br>
<a href="mailto:Nagios-devel@lists.sourceforge.net">Nagios-devel@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/nagios-devel" target="_blank">https://lists.sourceforge.net/lists/listinfo/nagios-devel</a><br>
</blockquote></div><br>