Re: [Nagios-devel] NODutils: Duplicate lines in servicechecks table

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
Locked
Guest

Re: [Nagios-devel] NODutils: Duplicate lines in servicechecks table

Post by Guest »

--00032555b93ae2f8b70477632cc6
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi

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

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

Any information from devel team ?

Regards
--
Julien MATHIS | Directeur Technique

[email protected]
T=E9l : +33(0)1.78.12.00.23
Mobile : +33(0)6.85.43.88.38

MERETHIS est =E9diteur du logiciel Centreon.


2009/11/2 =D8yvind Nordang

> 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 =3D 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 =3D
> 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=3D'%lu'=
,
> command_args=3D'%s', command_line=3D'%s' ON DUPLICATE KEY UPDATE %s"
> ,ndo2db_db_tablenames[NDO2DB_DBTABLE_SERVICECHECKS]
> ,buf1
> ,command_id
> ,es[0]
> ,es[1]
> ,buf1
> )=3D=3D-1)
> buf=3DNULL;
>
> Hope someone can clarify this for me, is this a bug in nagios, ndoutil
> or have I done something wrong...
>
> Thanks in advance.
>
> --
> =D8yvind 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
> [email protected]
> https://lists.sourceforge.net/lists/lis ... gios-devel
>

--00032555b93ae2f8b70477632cc6
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi I've already reported this bug 6 months ago, but it still no=
t fixed. You can find information in the tracker :http://tracker.nagios.org/view.php?id=
=3D4

Any information from devel team ?Regards--Julien =A0MAT=
HIS | Directeur Techniquejm=
[email protected]=E9l : +33(0)1.78.12.00.23Mobile =A0: +33(0)=
6.85.43.88.38

MERETHIS est =E9diteur du logiciel Centreon.
2009/11/2 =D8yvind Nordang <[email protected]=
om>

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 inform

...[email truncated]...


This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]
Locked