R: Ndoutils block nagios

[Michael Friedrich]

On 2010-06-03 08:38, Abdessamad BARAKAT wrote:
> Before this crash , all works like a charm. Do you think I really need
> to upgrade ?
>    

I would just recommend it on performance purpose but if it worked for 
you, stay at 1.4b7 - 1.4b8 is shipping with several bugs which are not 
all resolved in 1.4b9 (from what I can tell looking at the code and 
comparing to Icinga IDOUtils).

Regarding your problem I would run a sanity check on the database, 
checking if there's anything broken and ndo2db just fails on inserting 
data (long lasting connections to the rdbms slow down the overall 
sequential inserts).

You might also use a little trick to remove the 5k items from buffer - 
you can set that in your ndomod.cfg - set it to 1, restart the core, 
change back and restart again. Never tried that, but at least those 
buffered items should be dropped out of the way.

But I think the electrical incident harmed sth else, like the rdbms.

Kind regards,
Michael

>
> Michael Friedrich a écrit :
>    
>> Abdessamad BARAKAT wrote:
>>      
>>> buffer_file=/var/cache/nagios3/ndoutils_mod.tmp
>>>        
>> Try to remove this from disk in order to drop the waiting 5k items being
>> put on the socket.
>>
>> Having a fresh startup of nagios and ndoutils, the config waits to be
>> written, before some more realtime/config cleanups and after that, the
>> historical cleanups leading from ndo2db.cfg might also interfere the
>> normal insert/update procedure. this is when the socket gets blocking
>> and ndomod is buffed with data it can't even send to the socket.
>>
>> Regarding 1.4b7 - consider getting the latest cvs head and patch the
>> unique constraint bugfix on nagios-devel yourself onto mysql.sql
>>
>> It's not "the latest and greatest" ndoutils, just "the latest" though.
>>
>> Kind regards,
>> Michael
>>
>>      
>>> file_rotation_interval=14400
>>> file_rotation_timeout=60
>>> reconnect_interval=15
>>> reconnect_warning_interval=15
>>> data_processing_options=-1
>>> config_output_options=3
>>>
>>>
>>> Thanks again for your help
>>>
>>> Bertinelli Massimo a écrit :
>>>        
>>>> I risolve the same problem using this method:
>>>> stop ndo and nagios
>>>> deleting the file ndo.sock on nagios/var directory
>>>> Start ndo and nagios
>>>>    Bye
>>>> Max
>>>>
>>>> ----- Messaggio originale -----
>>>> Da: Abdessamad BARAKAT<abdessamad at barakat.fr>
>>>> A: nagios-users at lists.sourceforge.net<nagios-users at lists.sourceforge.net>
>>>> Inviato: Wed Jun 02 13:42:12 2010
>>>> Oggetto: [Nagios-users] Ndoutils block nagios
>>>>
>>>> Hi,
>>>>
>>>> After a electrical crash, I have a problem with ndoutils, nagios start
>>>> and works correctly when ndo2db isn't started .
>>>>
>>>> When I start ndo2db, nagios blocks.
>>>>
>>>> When ndo2db is started , nagios connect to ndo2db:
>>>>
>>>> [1275478646] ndomod: Successfully reconnected to data sink!  113098
>>>> items lost, 5000 queued items to flush.
>>>>
>>>> I see this activity on the process nagios with strace:
>>>>
>>>> [pid 18603] write(7, "\n400:\n4=1275477698.622212\n174=MAW"..., 588
>>>> <unfinished ...>
>>>> [pid 18604]<... poll resumed>   )        = 0 (Timeout)
>>>> [pid 18604] poll([{fd=4, events=POLLIN}], 1, 500) = 0 (Timeout)
>>>> [pid 18604] poll([{fd=4, events=POLLIN}], 1, 500) = 0 (Timeout)
>>>> [pid 18604] poll([{fd=4, events=POLLIN}], 1, 500) = 0 (Timeout)
>>>> [pid 18604] poll([{fd=4, events=POLLIN}], 1, 500) = 0 (Timeout)
>>>>
>>>> Before the electrical crash , all is ok.
>>>>
>>>> I use :
>>>>
>>>> - nagios 3.0.6
>>>> - NDOMOD 1.4b7 (10-31-2007)
>>>>
>>>> Many thanks for any help / information
>>>>
>>>>
>>>>
>>>>
>>>> ------------------------------------------------------------------------------
>>>>
>>>> _______________________________________________
>>>> Nagios-users mailing list
>>>> Nagios-users at lists.sourceforge.net
>>>> https://lists.sourceforge.net/lists/listinfo/nagios-users
>>>> ::: Please include Nagios version, plugin version (-v) and OS when
>>>> reporting any issue.
>>>> ::: Messages without supporting info will risk being sent to /dev/null
>>>>
>>>>
>>>> ------------------------------------------------------------------------
>>>>
>>>> ------------------------------------------------------------------------------
>>>>
>>>>
>>>>
>>>> ------------------------------------------------------------------------
>>>>
>>>> _______________________________________________
>>>> Nagios-users mailing list
>>>> Nagios-users at lists.sourceforge.net
>>>> https://lists.sourceforge.net/lists/listinfo/nagios-users
>>>> ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue.
>>>> ::: Messages without supporting info will risk being sent to /dev/null
>>>>          
>>> ------------------------------------------------------------------------------
>>>
>>> _______________________________________________
>>> Nagios-users mailing list
>>> Nagios-users at lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/nagios-users
>>> ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue.
>>> ::: Messages without supporting info will risk being sent to /dev/null
>>>        
>>
>>      
>
> ------------------------------------------------------------------------------
> ThinkGeek and WIRED's GeekDad team up for the Ultimate
> GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
> lucky parental unit.  See the prize list and enter to win:
> http://p.sf.net/sfu/thinkgeek-promo
> _______________________________________________
> Nagios-users mailing list
> Nagios-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-users
> ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue.
> ::: Messages without supporting info will risk being sent to /dev/null


------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null