[op5-users] Réf. : Re: Réf. : Re: merlind crash after loosing mysql connection

[Andreas Ericsson]

nicolas.raspail at bnpparibas.com wrote:
> op5-users-bounces at lists.op5.com wrote on 31/08/2009 17:04:24:
> 
>> nicolas.raspail at bnpparibas.com wrote:
>>> p5-users-bounces at lists.op5.com wrote on 31/08/2009 10:38:27:
>>>
> 
> <snip> 
> 
>> Ok. In that case it's not a configuration error. Can you try using the
>> latest git snapshot (download it directly from git for simpler updates)
>> and see if that solves this particular problem?
>>
>> The latest core code changes can be found in v0.6.2-beta11.
>>
>> Thanks for your reports. I really appreciate them :-)
>>
> 
> Hi,
> 
> I have just compiled and installed the tarball from the git commit 
> b0703a40b91d39b57d84d52ddb81a8e34933c362. I have modified the 
> gen-version.sh script to add 
> DEF_VER=v0.6.2-b0703a40b91d39b57d84d52ddb81a8e34933c362 
> 
> * When I start merlind, I get the following messages
> 
> [1251803549] 6: Initializing IPC socket 
> '/bnp/apps/nagios/merlin/ipc.sock' for daemon [1251803549] 6: 
> dbi_conn_query_null(): Failed to run [SELECT host_name, current_state, 
> state_type FROM merlindb.host ORDER BY host_name]: no database 
> connection. Error-code is 7 [1251803549] 3: Attempting to reconnect to 
> database [1251803549] 6: Successfully ran the previously failed query 
> [1251803550] 6: Primed object states for 0 hosts and 14639 services 
> [1251803550] 6: Merlin daemon 
> v0.6.2-b0703a40b91d39b57d84d52ddb81a8e34933c362 successfully initialized 
> [1251803550] 6: Accepting inbound connection on ipc socket 
> 
> * After that, a large number (41) of php importer process are launched
> 
> [1251803550] 6: Executing import command 'php 
> /bnp/apps/nagios/merlin/import.php 
> --nagios-cfg=/bnp/apps/nagios/etc/nagios.cfg 
> --cache=/bnp/apps/nagios/var/objects.cache --db-name=merlindb 
> --db-user=merlin --db-pass=xxx --db-host=eqd-nagios-sql' 
> <40 times>
> [1251803554] 6: Handled 86 ipc events in 4.326 seconds
> [1251803566] 6: Executing import command 'php 
> /bnp/apps/nagios/merlin/import.php 
> --nagios-cfg=/bnp/apps/nagios/etc/nagios.cfg 
> --cache=/bnp/apps/nagios/var/objects.cache --db-name=merlindb 
> --db-user=merlin --db-pass=xxx --db-host=eqd-nagios-sql' 
> [1251803566] 6: Handled 6 ipc events in 0.006 seconds
> [1251803566] 6: Handled 2 ipc events in 0.003 seconds
> [1251803566] 6: Handled 128 ipc events in 0.083 seconds
> [1251803566] 6: Handled 1 ipc events in 0.000 seconds
> 
> I have stopped merlind because the load on the server was very high.
> Several minutes after I have stopped the merlind process, I can see php
> running, but they finally disappeared.
> 
> I did not can test the reconnection after a failover of my mysql server
> because of this new merlind behaviour :)
> 

Can you please send me the log from your eventbroker module as well
(the one call neb.log in the example config file)?

What I think is happening is that your config is simply so large that
the import takes far too much time. I'll add a check to make sure we
aren't running one import while another one's working.

-- 
Andreas Ericsson                   andreas.ericsson at op5.se
OP5 AB                             www.op5.se
Tel: +46 8-230225                  Fax: +46 8-230231

Considering the successes of the wars on alcohol, poverty, drugs and
terror, I think we should give some serious thought to declaring war
on peace.