Nagios Support Forum

Hello,

I tried to repair database first of all as I readed that somewhere as possible solution...but It didn't help.

It does not coincide with anyone using nagiosql, at fact, most of times are during night:...but problem appeared more or less 2 days after installing it...so make sense what you say... Anyway...nagiosql and nagios are using differents db (but in same server), with differents users, who has not adqin...

It is getting worst , now it is failing more frequently...

I am not sure, but I think this is a clue...first error in log, coming from pop_from_queue in queue.c is always:
Identifier removed...who removed my queue??? is it possible to know?

now it is failing again...I think event faster than with tcp socket....

Ok, I have set up both of your suggestions. (also changed ndo2db to unix socket...obviously). I will let you know something in some hours (it used to fail after 10-12 hours)... Anyway, It was running like this previously and it was failing in the same way... As I said in my first post...Nagios was r...

Attached!

thanks for your help.

Hello!

yes, it solves the problem. At fact, just restarting nagios solves the problem too.

But after some hours it is crashing again...

Currently, I have a crontab that restart nagios every hour...but I think it is not an elegant solution...

Yes, I do.

Ok, now it is crashing: ndo2db.debug: [1467361331.389468] [002.0] [pid=10649] DELETE FROM nagios_timedeventqueue WHERE instance_id='1' AND event_type='12' AND scheduled_time=FROM_UNIXTIME(1467361331) AND recurring_event='0' AND object_id='398' [1467361335.403985] [002.0] [pid=10649] DELETE FROM nagi...

Ok, I will do that. Meanwhile, I observed in ndo2db log that I have LOTS (like 10 or 15 times more than another query) queries similar to: DELETE FROM nagios_timedeventqueue WHERE instance_id='1' AND event_type='8' AND scheduled_time=FROM_UNIXTIME(1467305288) AND recurring_event='1' AND object_id='0...