I just updated to Nagios 5.8.1 and have similar problem, however it already occurs during startup of Nagios
It is also a log entry about query failure it looks like there is a negative value in there: FROM_UNIXTIME(-192526097)
Code: Select all
[1611299613] NDO-3: The following query failed while MySQL appears to be connected:
[1611299613] NDO-3: INSERT INTO nagios_scheduleddowntime (instance_id, downtime_type, object_id, entry_time, author_name, comment_data, internal_downtime_id, triggered_by_id, is_fixed, duration, scheduled_start_time, scheduled_end_time) VALUES (1,1,43525,FROM_UNIXTIME(1606744751),'Martijn Stol','Zero is nog niet geinstalleerd',3312,0,1,-1799270792,FROM_UNIXTIME(1606744695),FROM_UNIXTIME(-192526097)) ON DUPLICATE KEY UPDATE instance_id = VALUES(instance_id), downtime_type = VALUES(downtime_type), object_id = VALUES(object_id), entry_time = VALUES(entry_time), author_name = VALUES(author_name), comment_data = VALUES(comment_data), internal_downtime_id = VALUES(internal_downtime_id), triggered_by_id = VALUES(triggered_by_id), is_fixed = VALUES(is_fixed), duration = VALUES(duration), scheduled_start_time = VALUES(scheduled_start_time), scheduled_end_time = VALUES(scheduled_end_time)
[1611299613] NDO-3: The following query failed while MySQL appears to be connected:
[1611299613] NDO-3: INSERT INTO nagios_downtimehistory (instance_id, downtime_type, object_id, entry_time, author_name, comment_data, internal_downtime_id, triggered_by_id, is_fixed, duration, scheduled_start_time, scheduled_end_time) VALUES (1,1,43525,FROM_UNIXTIME(1606744751),'Martijn Stol','Zero is nog niet geinstalleerd',3312,0,1,-1799270792,FROM_UNIXTIME(1606744695),FROM_UNIXTIME(-192526097)) ON DUPLICATE KEY UPDATE instance_id = VALUES(instance_id), downtime_type = VALUES(downtime_type), object_id = VALUES(object_id), entry_time = VALUES(entry_time), author_name = VALUES(author_name), comment_data = VALUES(comment_data), internal_downtime_id = VALUES(internal_downtime_id), triggered_by_id = VALUES(triggered_by_id), is_fixed = VALUES(is_fixed), duration = VALUES(duration), scheduled_start_time = VALUES(scheduled_start_time), scheduled_end_time = VALUES(scheduled_end_time)
[1611299613] NDO-3: The following query failed while MySQL appears to be connected:
[1611299613] NDO-3: INSERT INTO nagios_scheduleddowntime (instance_id, downtime_type, object_id, entry_time, author_name, comment_data, internal_downtime_id, triggered_by_id, is_fixed, duration, scheduled_start_time, scheduled_end_time) VALUES (1,1,43512,FROM_UNIXTIME(1606744776),'Martijn Stol','Zero is nog niet geinstalleerd',3313,0,1,-1799270793,FROM_UNIXTIME(1606744696),FROM_UNIXTIME(-192526097)) ON DUPLICATE KEY UPDATE instance_id = VALUES(instance_id), downtime_type = VALUES(downtime_type), object_id = VALUES(object_id), entry_time = VALUES(entry_time), author_name = VALUES(author_name), comment_data = VALUES(comment_data), internal_downtime_id = VALUES(internal_downtime_id), triggered_by_id = VALUES(triggered_by_id), is_fixed = VALUES(is_fixed), duration = VALUES(duration), scheduled_start_time = VALUES(scheduled_start_time), scheduled_end_time = VALUES(scheduled_end_time)
[1611299613] NDO-3: The following query failed while MySQL appears to be connected:
[1611299613] NDO-3: INSERT INTO nagios_downtimehistory (instance_id, downtime_type, object_id, entry_time, author_name, comment_data, internal_downtime_id, triggered_by_id, is_fixed, duration, scheduled_start_time, scheduled_end_time) VALUES (1,1,43512,FROM_UNIXTIME(1606744776),'Martijn Stol','Zero is nog niet geinstalleerd',3313,0,1,-1799270793,FROM_UNIXTIME(1606744696),FROM_UNIXTIME(-192526097)) ON DUPLICATE KEY UPDATE instance_id = VALUES(instance_id), downtime_type = VALUES(downtime_type), object_id = VALUES(object_id), entry_time = VALUES(entry_time), author_name = VALUES(author_name), comment_data = VALUES(comment_data), internal_downtime_id = VALUES(internal_downtime_id), triggered_by_id = VALUES(triggered_by_id), is_fixed = VALUES(is_fixed), duration = VALUES(duration), scheduled_start_time = VALUES(scheduled_start_time), scheduled_end_time = VALUES(scheduled_end_time)
[1611299613] NDO-3: The following query failed while MySQL appears to be connected:
[1611299613] NDO-3: INSERT INTO nagios_scheduleddowntime (instance_id, downtime_type, object_id, entry_time, author_name, comment_data, internal_downtime_id, triggered_by_id, is_fixed, duration, scheduled_start_time, scheduled_end_time) VALUES (1,1,43490,FROM_UNIXTIME(1606744800),'Martijn Stol','Zerto is nog niet geinstalleerd',3314,0,1,-1799270799,FROM_UNIXTIME(1606744702),FROM_UNIXTIME(-192526097)) ON DUPLICATE KEY UPDATE instance_id = VALUES(instance_id), downtime_type = VALUES(downtime_type), object_id = VALUES(object_id), entry_time = VALUES(entry_time), author_name = VALUES(author_name), comment_data = VALUES(comment_data), internal_downtime_id = VALUES(internal_downtime_id), triggered_by_id = VALUES(triggered_by_id), is_fixed = VALUES(is_fixed), duration = VALUES(duration), scheduled_start_time = VALUES(scheduled_start_time), scheduled_end_time = VALUES(scheduled_end_time)
[1611299613] NDO-3: The following query failed while MySQL appears to be connected:
[1611299613] NDO-3: INSERT INTO nagios_downtimehistory (instance_id, downtime_type, object_id, entry_time, author_name, comment_data, internal_downtime_id, triggered_by_id, is_fixed, duration, scheduled_start_time, scheduled_end_time) VALUES (1,1,43490,FROM_UNIXTIME(1606744800),'Martijn Stol','Zerto is nog niet geinstalleerd',3314,0,1,-1799270799,FROM_UNIXTIME(1606744702),FROM_UNIXTIME(-192526097)) ON DUPLICATE KEY UPDATE instance_id = VALUES(instance_id), downtime_type = VALUES(downtime_type), object_id = VALUES(object_id), entry_time = VALUES(entry_time), author_name = VALUES(author_name), comment_data = VALUES(comment_data), internal_downtime_id = VALUES(internal_downtime_id), triggered_by_id = VALUES(triggered_by_id), is_fixed = VALUES(is_fixed), duration = VALUES(duration), scheduled_start_time = VALUES(scheduled_start_time), scheduled_end_time = VALUES(scheduled_end_time)
[1611299613] NDO-3: The following query failed while MySQL appears to be connected:
[1611299613] NDO-3: INSERT INTO nagios_scheduleddowntime (instance_id, downtime_type, object_id, entry_time, author_name, comment_data, internal_downtime_id, triggered_by_id, is_fixed, duration, scheduled_start_time, scheduled_end_time) VALUES (1,1,43462,FROM_UNIXTIME(1606744821),'Martijn Stol','Zerto is nog niet geinstalleerd',3315,0,1,-1799270800,FROM_UNIXTIME(1606744703),FROM_UNIXTIME(-192526097)) ON DUPLICATE KEY UPDATE instance_id = VALUES(instance_id), downtime_type = VALUES(downtime_type), object_id = VALUES(object_id), entry_time = VALUES(entry_time), author_name = VALUES(author_name), comment_data = VALUES(comment_data), internal_downtime_id = VALUES(internal_downtime_id), triggered_by_id = VALUES(triggered_by_id), is_fixed = VALUES(is_fixed), duration = VALUES(duration), scheduled_start_time = VALUES(scheduled_start_time), scheduled_end_time = VALUES(scheduled_end_time)
[1611299613] NDO-3: The following query failed while MySQL appears to be connected:
[1611299613] NDO-3: INSERT INTO nagios_downtimehistory (instance_id, downtime_type, object_id, entry_time, author_name, comment_data, internal_downtime_id, triggered_by_id, is_fixed, duration, scheduled_start_time, scheduled_end_time) VALUES (1,1,43462,FROM_UNIXTIME(1606744821),'Martijn Stol','Zerto is nog niet geinstalleerd',3315,0,1,-1799270800,FROM_UNIXTIME(1606744703),FROM_UNIXTIME(-192526097)) ON DUPLICATE KEY UPDATE instance_id = VALUES(instance_id), downtime_type = VALUES(downtime_type), object_id = VALUES(object_id), entry_time = VALUES(entry_time), author_name = VALUES(author_name), comment_data = VALUES(comment_data), internal_downtime_id = VALUES(internal_downtime_id), triggered_by_id = VALUES(triggered_by_id), is_fixed = VALUES(is_fixed), duration = VALUES(duration), scheduled_start_time = VALUES(scheduled_start_time), scheduled_end_time = VALUES(scheduled_end_time)
[1611299613] NDO-3: Ended acknowledgement thread
[1611299613] NDO-3: Ended flapping thread
[1611299613] NDO-3: Ended notification thread
[1611299613] Caught SIGSEGV, shutting down...
And then Nagios just stops.