I just seen my /var/log/message queue and I'm very surprised to see this message.
I try to decode FROM_UNIXTIME Value, but I don't know what exactly means.
Code: Select all
Dec 6 15:20:28 nagios2 ndo2db: Error: mysql_query() failed for 'DELETE FROM npc_timedevents WHERE instance_id='1' AND scheduled_time<FROM_UNIXTIME(1354738777)'
Dec 6 15:20:30 nagios2 ndo2db: Error: mysql_query() failed for 'DELETE FROM npc_timedevents WHERE instance_id='1' AND scheduled_time<FROM_UNIXTIME(1354738779)'
Dec 6 15:20:32 nagios2 ndo2db: Error: mysql_query() failed for 'DELETE FROM npc_timedevents WHERE instance_id='1' AND scheduled_time<FROM_UNIXTIME(1354738781)'
Dec 6 15:20:34 nagios2 ndo2db: Error: mysql_query() failed for 'DELETE FROM npc_timedevents WHERE instance_id='1' AND scheduled_time<FROM_UNIXTIME(1354738783)'
Dec 6 15:20:37 nagios2 ndo2db: Error: mysql_query() failed for 'DELETE FROM npc_timedevents WHERE instance_id='1' AND scheduled_time<FROM_UNIXTIME(1354738786)'
Dec 6 15:20:37 nagios2 nagios: Warning: The check of host 'Webmed' looks like it was orphaned (results never came back). I'm scheduling an immediate check of the host...
My log is full about thisn kind of messages.
In other hand the database backup I dump today is about of 1.3Gb.
I only have 100/150 Servers running in Cacti and actually no one in the section of npc.
But I don't think 100+ Servers will make a BD have 1.3 GB in less than a month.
I really hope you can share your opinions about the log message to try to fix my Cacti.
best Regards.