[CLOSED] Re: R: Ndoutils block nagios

[Abdessamad BARAKAT]

I have  created a new database and now it's ok...it's seems to block on 
the old database(LOCK,..), mysqlcheck on the old database show "OK"

Thanks a lot for your help

Michael Friedrich a écrit :
> 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


------------------------------------------------------------------------------
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