<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv=Content-Type content="text/html; charset=iso-8859-1"> <meta name=Generator content="Microsoft Word 12 (filtered medium)"> <style>  </style>  </head> <body bgcolor=white lang=IT link=blue vlink=purple> <div class=Section1> Hi,<o:p></o:p> I think is not a correct behavior because visualization software as nagvis and others uses the table programstatus to check if nagios is running.<o:p></o:p> I saw that often this table is empty. Code calculates the difference between now() and status_update_time. If the record is null this difference is far more than the configurable interval, tipical 180 sec.<o:p></o:p> The problem is that this difference suddenly vary from near 0 to infinity.<o:p></o:p> Perhaps this is a problem in my ndo setup, and those deletes normally occurs rarely. But I saw them every 60 seconds.<o:p></o:p> Here ndo2db log:<o:p></o:p> [1253268542.667382] [002.0] [pid=22380] DELETE FROM nagios_hoststatus WHERE instance_id='1'<o:p></o:p> [1253268542.669377] [002.0] [pid=22380] DELETE FROM nagios_servicestatus WHERE instance_id='1'<o:p></o:p> [1253268542.702713] [002.0] [pid=22380] DELETE FROM nagios_contactstatus WHERE instance_id='1'<o:p></o:p> [1253268542.714290] [002.0] [pid=22380] DELETE FROM nagios_timedeventqueue WHERE instance_id='1'<o:p></o:p> [1253268542.721312] [002.0] [pid=22380] DELETE FROM nagios_comments WHERE instance_id='1'<o:p></o:p> [1253268542.722317] [002.0] [pid=22380] DELETE FROM nagios_scheduleddowntime WHERE instance_id='1'<o:p></o:p> [1253268542.723311] [002.0] [pid=22380] DELETE FROM nagios_runtimevariables WHERE instance_id='1'<o:p></o:p> [1253268542.724306] [002.0] [pid=22380] DELETE FROM nagios_customvariablestatus WHERE instance_id='1'<o:p></o:p> [1253268542.725313] [002.0] [pid=22380] DELETE FROM nagios_configfiles WHERE instance_id='1'<o:p></o:p> [1253268542.726695] [002.0] [pid=22380] DELETE FROM nagios_configfilevariables WHERE instance_id='1'<o:p></o:p> [1253268542.773375] [002.0] [pid=22380] DELETE FROM nagios_customvariables WHERE instance_id='1'<o:p></o:p> [1253268542.779765] [002.0] [pid=22380] DELETE FROM nagios_commands WHERE instance_id='1'<o:p></o:p> [1253268542.780387] [002.0] [pid=22380] DELETE FROM nagios_timeperiods WHERE instance_id='1'<o:p></o:p> [1253268542.780387] [002.0] [pid=22380] DELETE FROM nagios_timeperiod_timeranges WHERE instance_id='1'<o:p></o:p> [1253268542.780387] [002.0] [pid=22380] DELETE FROM nagios_contactgroups WHERE instance_id='1'<o:p></o:p> [1253268542.780387] [002.0] [pid=22380] DELETE FROM nagios_contactgroup_members WHERE instance_id='1'<o:p></o:p> [1253268542.780387] [002.0] [pid=22380] DELETE FROM nagios_hostgroups WHERE instance_id='1'<o:p></o:p> [1253268542.780387] [002.0] [pid=22380] DELETE FROM nagios_hostgroup_members WHERE instance_id='1'<o:p></o:p> [1253268542.780387] [002.0] [pid=22380] DELETE FROM nagios_servicegroups WHERE instance_id='1'<o:p></o:p> [1253268542.780387] [002.0] [pid=22380] DELETE FROM nagios_servicegroup_members WHERE instance_id='1'<o:p></o:p> [1253268542.780387] [002.0] [pid=22380] DELETE FROM nagios_hostescalations WHERE instance_id='1'<o:p></o:p> [1253268542.780387] [002.0] [pid=22380] DELETE FROM nagios_hostescalation_contacts WHERE instance_id='1'<o:p></o:p> [1253268542.780387] [002.0] [pid=22380] DELETE FROM nagios_serviceescalations WHERE instance_id='1'<o:p></o:p> [1253268542.780387] [002.0] [pid=22380] DELETE FROM nagios_serviceescalation_contacts WHERE instance_id='1'<o:p></o:p> [1253268542.780387] [002.0] [pid=22380] DELETE FROM nagios_hostdependencies WHERE instance_id='1'<o:p></o:p> [1253268542.780387] [002.0] [pid=22380] DELETE FROM nagios_servicedependencies WHERE instance_id='1'<o:p></o:p> [1253268542.780387] [002.0] [pid=22380] DELETE FROM nagios_contacts WHERE instance_id='1'<o:p></o:p> [1253268542.780387] [002.0] [pid=22380] DELETE FROM nagios_contact_addresses WHERE instance_id='1'<o:p></o:p> [1253268542.781384] [002.0] [pid=22380] DELETE FROM nagios_contact_notificationcommands WHERE instance_id='1'<o:p></o:p> [1253268542.781385] [002.0] [pid=22380] DELETE FROM nagios_hosts WHERE instance_id='1'<o:p></o:p> [1253268542.782384] [002.0] [pid=22380] DELETE FROM nagios_host_parenthosts WHERE instance_id='1'<o:p></o:p> [1253268542.782384] [002.0] [pid=22380] DELETE FROM nagios_host_contacts WHERE instance_id='1'<o:p></o:p> [1253268542.782384] [002.0] [pid=22380] DELETE FROM nagios_services WHERE instance_id='1'<o:p></o:p> [1253268542.784370] [002.0] [pid=22380] DELETE FROM nagios_service_contacts WHERE instance_id='1<o:p></o:p> <o:p> </o:p> [….]<o:p></o:p> <o:p> </o:p> [1253268601.894373] [002.0] [pid=22671] DELETE FROM nagios_hoststatus WHERE instance_id='1'<o:p></o:p> [1253268601.897396] [002.0] [pid=22671] DELETE FROM nagios_servicestatus WHERE instance_id='1'<o:p></o:p> [1253268601.906408] [002.0] [pid=22671] DELETE FROM nagios_contactstatus WHERE instance_id='1'<o:p></o:p> [1253268601.907455] [002.0] [pid=22671] DELETE FROM nagios_timedeventqueue WHERE instance_id='1'<o:p></o:p> [1253268601.911438] [002.0] [pid=22671] DELETE FROM nagios_comments WHERE instance_id='1'<o:p></o:p> [1253268601.912334] [002.0] [pid=22671] DELETE FROM nagios_scheduleddowntime WHERE instance_id='1'<o:p></o:p> [1253268601.913350] [002.0] [pid=22671] DELETE FROM nagios_runtimevariables WHERE instance_id='1'<o:p></o:p> [1253268601.914454] [002.0] [pid=22671] DELETE FROM nagios_customvariablestatus WHERE instance_id='1'<o:p></o:p> [1253268601.915378] [002.0] [pid=22671] DELETE FROM nagios_configfiles WHERE instance_id='1'<o:p></o:p> [1253268601.916336] [002.0] [pid=22671] DELETE FROM nagios_configfilevariables WHERE instance_id='1'<o:p></o:p> [1253268601.918447] [002.0] [pid=22671] DELETE FROM nagios_customvariables WHERE instance_id='1'<o:p></o:p> [1253268601.919356] [002.0] [pid=22671] DELETE FROM nagios_commands WHERE instance_id='1'<o:p></o:p> [1253268601.921328] [002.0] [pid=22671] DELETE FROM nagios_timeperiods WHERE instance_id='1'<o:p></o:p> [1253268601.922388] [002.0] [pid=22671] DELETE FROM nagios_timeperiod_timeranges WHERE instance_id='1'<o:p></o:p> [1253268601.923332] [002.0] [pid=22671] DELETE FROM nagios_contactgroups WHERE instance_id='1'<o:p></o:p> [1253268601.924317] [002.0] [pid=22671] DELETE FROM nagios_contactgroup_members WHERE instance_id='1'<o:p></o:p> [1253268601.925318] [002.0] [pid=22671] DELETE FROM nagios_hostgroups WHERE instance_id='1'<o:p></o:p> [1253268601.926308] [002.0] [pid=22671] DELETE FROM nagios_hostgroup_members WHERE instance_id='1'<o:p></o:p> [1253268601.927392] [002.0] [pid=22671] DELETE FROM nagios_servicegroups WHERE instance_id='1'<o:p></o:p> [1253268601.928311] [002.0] [pid=22671] DELETE FROM nagios_servicegroup_members WHERE instance_id='1'<o:p></o:p> [1253268601.930321] [002.0] [pid=22671] DELETE FROM nagios_hostescalations WHERE instance_id='1'<o:p></o:p> [1253268601.932344] [002.0] [pid=22671] DELETE FROM nagios_hostescalation_contacts WHERE instance_id='1'<o:p></o:p> [1253268601.933312] [002.0] [pid=22671] DELETE FROM nagios_serviceescalations WHERE instance_id='1'<o:p></o:p> [1253268601.934299] [002.0] [pid=22671] DELETE FROM nagios_serviceescalation_contacts WHERE instance_id='1'<o:p></o:p> [1253268601.935316] [002.0] [pid=22671] DELETE FROM nagios_hostdependencies WHERE instance_id='1'<o:p></o:p> [1253268601.936415] [002.0] [pid=22671] DELETE FROM nagios_servicedependencies WHERE instance_id='1'<o:p></o:p> [1253268601.937305] [002.0] [pid=22671] DELETE FROM nagios_contacts WHERE instance_id='1'<o:p></o:p> [1253268601.938296] [002.0] [pid=22671] DELETE FROM nagios_contact_addresses WHERE instance_id='1'<o:p></o:p> [1253268601.939302] [002.0] [pid=22671] DELETE FROM nagios_contact_notificationcommands WHERE instance_id='1'<o:p></o:p> [1253268601.940374] [002.0] [pid=22671] DELETE FROM nagios_hosts WHERE instance_id='1'<o:p></o:p> [1253268601.941320] [002.0] [pid=22671] DELETE FROM nagios_host_parenthosts WHERE instance_id='1'<o:p></o:p> [1253268601.943300] [002.0] [pid=22671] DELETE FROM nagios_host_contacts WHERE instance_id='1'<o:p></o:p> [1253268601.944362] [002.0] [pid=22671] DELETE FROM nagios_services WHERE instance_id='1'<o:p></o:p> [1253268601.948335] [002.0] [pid=22671] DELETE FROM nagios_service_contacts WHERE instance_id='1'<o:p></o:p> <o:p> </o:p> 1253268542 – 1253268601 = 59<o:p></o:p> <o:p> </o:p> As you can see the ndo2db pid varies, I think that when it has no more data the child exits, an a new one is forked. The new child then deletes records in db.<o:p></o:p> <o:p> </o:p> Thanks<o:p></o:p> <o:p> </o:p> Marco<o:p></o:p> <o:p> </o:p> <div> <div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'> From: Michael Friedrich [mailto:michael.friedrich@univie.ac.at] Sent: gioved� 17 settembre 2009 17.53 To: Nagios Developers List Subject: Re: [Nagios-devel] NDO utils bug/explanation<o:p></o:p> </div> </div> <o:p> </o:p> <tt>Hi,</tt> <tt>Frassinelli, Marco wrote the following on 17.09.2009 17:11:</tt> <o:p></o:p> <div> <tt> </tt><o:p></o:p> <tt> ndo2db_db_clear_table(idi,ndo2db_db_tablenames[NDO2DB_DBTABLE_PROGRAMSTATUS]);</tt><o:p></o:p> <tt> ndo2db_db_clear_table(idi,ndo2db_db_tablenames[NDO2DB_DBTABLE_HOSTSTATUS]);</tt><o:p></o:p> <tt> ndo2db_db_clear_table(idi,ndo2db_db_tablenames[NDO2DB_DBTABLE_SERVICESTATUS]);</tt><o:p></o:p> </div> <tt>What makes you believe that this cleanup is wrong? Did you do a deeper look at the conditional statement above which makes sure that old data compared to real time data won't stay in the database?</tt> <tt>Of course, it causes a heavy load on the database throwing big delete statements. Worst case scenario, that the queries take too long and everythings screws up. </tt> <tt>Kind regards,</tt> <tt>Michael</tt> <o:p></o:p> <pre style='margin-left:35.4pt'><tt>-- <o:p></o:p></tt></pre><pre style='margin-left:35.4pt'><tt>DI (FH) Michael Friedrich<o:p></o:p></tt></pre><pre style='margin-left:35.4pt'><tt><a href="mailto:michael.friedrich@univie.ac.at">michael.friedrich@univie.ac.at</a><o:p></o:p></tt></pre><pre style='margin-left:35.4pt'><tt>Tel: +43 1 4277 14359<o:p></o:p></tt></pre><pre style='margin-left:35.4pt'><tt><o:p> </o:p></tt></pre><pre style='margin-left:35.4pt'><tt>Vienna University Computer Center<o:p></o:p></tt></pre><pre style='margin-left:35.4pt'><tt>Universitaetsstrasse 7 <o:p></o:p></tt></pre><pre style='margin-left:35.4pt'><tt>A-1010 Vienna, Austria� <o:p></o:p></tt></pre></div> </body> </html>