This is a multi-part message in MIME format.
------_=_NextPart_001_01CA384A.6BA58E97
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
I think is not a correct behavior because visualization software as =
nagvis and others uses the table programstatus to check if nagios is =
running.
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.
The problem is that this difference suddenly vary from near 0 to =
infinity.
Perhaps this is a problem in my ndo setup, and those deletes normally =
occurs rarely. But I saw them every 60 seconds.
Here ndo2db log:
[1253268542.667382] [002.0] [pid=3D22380] DELETE FROM nagios_hoststatus =
WHERE instance_id=3D'1'
[1253268542.669377] [002.0] [pid=3D22380] DELETE FROM =
nagios_servicestatus WHERE instance_id=3D'1'
[1253268542.702713] [002.0] [pid=3D22380] DELETE FROM =
nagios_contactstatus WHERE instance_id=3D'1'
[1253268542.714290] [002.0] [pid=3D22380] DELETE FROM =
nagios_timedeventqueue WHERE instance_id=3D'1'
[1253268542.721312] [002.0] [pid=3D22380] DELETE FROM nagios_comments =
WHERE instance_id=3D'1'
[1253268542.722317] [002.0] [pid=3D22380] DELETE FROM =
nagios_scheduleddowntime WHERE instance_id=3D'1'
[1253268542.723311] [002.0] [pid=3D22380] DELETE FROM =
nagios_runtimevariables WHERE instance_id=3D'1'
[1253268542.724306] [002.0] [pid=3D22380] DELETE FROM =
nagios_customvariablestatus WHERE instance_id=3D'1'
[1253268542.725313] [002.0] [pid=3D22380] DELETE FROM nagios_configfiles =
WHERE instance_id=3D'1'
[1253268542.726695] [002.0] [pid=3D22380] DELETE FROM =
nagios_configfilevariables WHERE instance_id=3D'1'
[1253268542.773375] [002.0] [pid=3D22380] DELETE FROM =
nagios_customvariables WHERE instance_id=3D'1'
[1253268542.779765] [002.0] [pid=3D22380] DELETE FROM nagios_commands =
WHERE instance_id=3D'1'
[1253268542.780387] [002.0] [pid=3D22380] DELETE FROM nagios_timeperiods =
WHERE instance_id=3D'1'
[1253268542.780387] [002.0] [pid=3D22380] DELETE FROM =
nagios_timeperiod_timeranges WHERE instance_id=3D'1'
[1253268542.780387] [002.0] [pid=3D22380] DELETE FROM =
nagios_contactgroups WHERE instance_id=3D'1'
[1253268542.780387] [002.0] [pid=3D22380] DELETE FROM =
nagios_contactgroup_members WHERE instance_id=3D'1'
[1253268542.780387] [002.0] [pid=3D22380] DELETE FROM nagios_hostgroups =
WHERE instance_id=3D'1'
[1253268542.780387] [002.0] [pid=3D22380] DELETE FROM =
nagios_hostgroup_members WHERE instance_id=3D'1'
[1253268542.780387] [002.0] [pid=3D22380] DELETE FROM =
nagios_servicegroups WHERE instance_id=3D'1'
[1253268542.780387] [002.0] [pid=3D22380] DELETE FROM =
nagios_servicegroup_members WHERE instance_id=3D'1'
[1253268542.780387] [002.0] [pid=3D22380] DELETE FROM =
nagios_hostescalations WHERE instance_id=3D'1'
[1253268542.780387] [002.0] [pid=3D22380] DELETE FROM =
nagios_hostescalation_contacts WHERE instance_id=3D'1'
[1253268542.780387] [002.0] [pid=3D22380] DELETE FROM =
nagios_serviceescalations WHERE instance_id=3D'1'
[1253268542.780387] [002.0] [pid=3D22380] DELETE FROM =
nagios_serviceescalation_contacts WHERE instance_id=3D'1'
[1253268542.780387] [002.0] [pid=3D22380] DELETE FROM =
nagios_hostdependencies WHERE instance_id=3D'1'
[1253268542.780387] [002.0] [pid=3D22380] DELETE FROM =
nagios_servicedependencies WHERE instance_id=3D'1'
[1253268542.780387] [002.0] [pid=3D22380] DELETE FROM nagios_contacts =
WHERE instance_id=3D'1'
[1253268542.780387] [002.0] [pid=3D22380] DELETE FROM =
nagios_contact_addresses WHERE instance_id=3D'1'
[1253268542.781384] [002.0] [pid=3D22380] DELETE FROM =
nagios_contact_notificationcommands WHERE instance_id=3D'1'
[1253268542.781385] [002.0] [pid=3D22380] DELETE FROM nagios_hosts WHERE =
instance_id=3D'1'
[1253268542.782384] [002.0] [pid=3D22380] DELETE FROM =
nagios_host_parenthosts WHERE instance_id=3D'1'
[1253268542.782384] [002.0] [pid=3D22380] DELETE FROM =
nagios_host_contacts WHERE instance_id
...[email truncated]...
This post was automatically imported from historical nagios-devel mailing list archives
Original poster: ichael Friedrich [mailto:[email protected]]=2