[dev.icinga.com #10817] Failed IDO query for icinga_downtimehistory

[icinga-migration]

This issue has been migrated from Redmine: https://dev.icinga.com/issues/10817

Created by gbeutner on 2015-12-10 13:56:54 +00:00

Assignee: mfriedrich
Status: Closed (closed on 2015-12-15 11:09:32 +00:00)
Target Version: 2.4.2
Last Update: 2016-02-23 09:58:24 +00:00 (in Redmine)

Icinga Version: 2.4.1
Backport?: Already backported
Include in Changelog: 0

---

[2015-12-10 14:55:48 +0100] critical/IdoMysqlConnection: Error "Duplicate entry '1-171-2015-12-10 13:55:24-6' for key 'instance_id'" when executing query "UPDATE icinga_hoststatus SET acknowledgement_type = '0',  active_checks_enabled = '1',  check_command = 'null',  check_source = 'acheron.beutner.name',  check_type = '0',  current_check_attempt = '1',  current_notification_number = '0',  current_state = '0',  endpoint_object_id = 1,  event_handler = '',  event_handler_enabled = '1',  execution_time = '0.0054390430450439453',  flap_detection_enabled = '0',  has_been_checked = '1',  host_object_id = 42526,  instance_id = 1,  is_flapping = '0',  is_reachable = '1',  last_check = FROM_UNIXTIME(1449755726),  last_hard_state = '0',  last_hard_state_change = FROM_UNIXTIME(1449755158),  last_state_change = FROM_UNIXTIME(1449755158),  last_time_up = FROM_UNIXTIME(1449755726),  latency = '0',  long_output = '',  max_check_attempts = '5',  next_check = FROM_UNIXTIME(1449755736),  normal_check_interval = '0.166667',  notifications_enabled = '1',  original_attributes = 'null',  output = 'Hello from acheron',  passive_checks_enabled = '1',  percent_state_change = '0',  perfdata = 'time=1449755726.5671029',  problem_has_been_acknowledged = '0',  process_performance_data = '1',  retry_check_interval = '0.166667',  scheduled_downtime_depth = '0',  should_be_scheduled = '1',  state_type = '1',  status_update_time = FROM_UNIXTIME(1449755726) WHERE host_object_id = 42526;UPDATE icinga_hoststatus SET next_check = FROM_UNIXTIME(1449755736) WHERE host_object_id = 47639 AND instance_id = 1;UPDATE icinga_hoststatus SET acknowledgement_type = '0',  active_checks_enabled = '1',  check_command = 'null',  check_source = 'acheron.beutner.name',  check_type = '0',  current_check_attempt = '1',  current_notification_number = '0',  current_state = '0',  endpoint_object_id = 1,  event_handler = '',  event_handler_enabled = '1',  execution_time = '0.0055429935455322266',  flap_detection_enabled = '0',  has_been_checked = '1',  host_object_id = 42597,  instance_id = 1,  is_flapping = '0',  is_reachable = '1',  last_check = FROM_UNIXTIME(1449755726),  last_hard_state = '0',  last_hard_state_change = FROM_UNIXTIME(1449755159),  last_state_change = FROM_UNIXTIME(1449755159),  last_time_up = FROM_UNIXTIME(1449755726),  latency = '0',  long_output = '',  max_check_attempts = '5',  next_check = FROM_UNIXTIME(1449755736),  normal_check_interval = '0.166667',  notifications_enabled = '1',  original_attributes = 'null',  output = 'Hello from acheron',  passive_checks_enabled = '1',  percent_state_change = '0',  perfdata = 'time=1449755726.567045',  problem_has_been_acknowledged = '0',  process_performance_data = '1',  retry_check_interval = '0.166667',  scheduled_downtime_depth = '0',  should_be_scheduled = '1',  state_type = '1',  status_update_time = FROM_UNIXTIME(1449755726) WHERE host_object_id = 42597;UPDATE icinga_hoststatus SET next_check = FROM_UNIXTIME(1449755736) WHERE host_object_id = 45662 AND instance_id = 1;UPDATE icinga_hoststatus SET acknowledgement_type = '0',  active_checks_enabled = '1',  check_command = 'null',  check_source = 'acheron.beutner.name',  check_type = '0',  current_check_attempt = '1',  current_notification_number = '0',  current_state = '0',  endpoint_object_id = 1,  event_handler = '',  event_handler_enabled = '1',  execution_time = '0.0053739547729492188',  flap_detection_enabled = '0',  has_been_checked = '1',  host_object_id = 48264,  instance_id = 1,  is_flapping = '0',  is_reachable = '1',  last_check = FROM_UNIXTIME(1449755726),  last_hard_state = '0',  last_hard_state_change = FROM_UNIXTIME(1449755168),  last_state_change = FROM_UNIXTIME(1449755168),  last_time_up = FROM_UNIXTIME(1449755726),  latency = '0',  long_output = '',  max_check_attempts = '5',  next_check = FROM_UNIXTIME(1449755736),  normal_check_interval = '0.166667',  notifications_enabled = '1',  original_attributes = 'null',  output = 'Hello from acheron',  passive_checks_enabled = '1',  percent_state_change = '0',  perfdata = 'time=1449755726.5668039',  problem_has_been_acknowledged = '0',  process_performance_data = '1',  retry_check_interval = '0.166667',  scheduled_downtime_depth = '0',  should_be_scheduled = '1',  state_type = '1',  status_update_time = FROM_UNIXTIME(1449755726) WHERE host_object_id = 48264;UPDATE icinga_hoststatus SET next_check = FROM_UNIXTIME(1449755735) WHERE host_object_id = 47550 AND instance_id = 1;INSERT INTO icinga_downtimehistory (author_name, comment_data, downtime_type, duration, endpoint_object_id, entry_time, instance_id, internal_downtime_id, is_fixed, is_in_effect, name, object_id, scheduled_end_time, scheduled_start_time, was_started) VALUES ('icingaadmin', 'Scheduled downtime for backup', '1', '0', 1, FROM_UNIXTIME(1449755724), 1, '6', '1', '0', 'acheron.beutner.name!load!acheron-1449755724-0', 171, FROM_UNIXTIME(1449799200), FROM_UNIXTIME(1449795600), '0');INSERT INTO icinga_scheduleddowntime (author_name, comment_data, downtime_type, duration, endpoint_object_id, entry_time, instance_id, internal_downtime_id, is_fixed, is_in_effect, name, object_id, scheduled_end_time, scheduled_start_time, was_started) VALUES ('icingaadmin', 'Scheduled downtime for backup', '1', '0', 1, FROM_UNIXTIME(1449755724), 1, '6', '1', '0', 'acheron.beutner.name!load!acheron-1449755724-0', 171, FROM_UNIXTIME(1449799200), FROM_UNIXTIME(1449795600), '0');UPDATE icinga_servicestatus SET scheduled_downtime_depth = '0' WHERE instance_id = 1 AND service_object_id = 171;UPDATE icinga_downtimehistory SET actual_end_time = FROM_UNIXTIME(1449755726),  actual_end_time_usec = '564856',  was_cancelled = '0' WHERE entry_time = FROM_UNIXTIME(1449755724) AND instance_id = 1 AND internal_downtime_id = '6' AND object_id = 171;DELETE FROM icinga_scheduleddowntime WHERE instance_id = 1 AND internal_downtime_id = '6' AND object_id = 171"

Changesets

2015-12-10 14:24:28 +00:00 by mfriedrich 0813e69

Fix DB IDO events for next_check, etc. updates

refs #10817

2016-02-23 08:13:21 +00:00 by mfriedrich e1ac078

Fix DB IDO events for next_check, etc. updates

refs #10817

[icinga-migration]

Updated by gbeutner on 2015-12-10 14:03:14 +00:00

Another failed query:

[2015-12-10 15:02:05 +0100] critical/IdoMysqlConnection: Error "Duplicate entry '0' for key 'object_id'" when executing query "INSERT INTO icinga_hoststatus (next_check) VALUES (FROM_UNIXTIME(1449756128));UPDATE icinga_hoststatus SET next_check = FROM_UNIXTIME(1449756128) WHERE host_object_id = 58124 AND instance_id = 1;UPDATE icinga_hoststatus SET acknowledgement_type = '0',  active_checks_enabled = '1',  check_command = 'null',  check_source = 'acheron.beutner.name',  check_type = '0',  current_check_attempt = '1',  current_notification_number = '0',  current_state = '0',  endpoint_object_id = 1,  event_handler = '',  event_handler_enabled = '1',  execution_time = '0.058646917343139648',  flap_detection_enabled = '0',  has_been_checked = '1',  host_object_id = 43883,  instance_id = 1,  is_flapping = '0',  is_reachable = '1',  last_check = FROM_UNIXTIME(1449756124),  last_hard_state = '0',  last_hard_state_change = FROM_UNIXTIME(1449755163),  last_state_change = FROM_UNIXTIME(1449755163),  last_time_up = FROM_UNIXTIME(1449756124),  latency = '0',  long_output = '',  max_check_attempts = '5',  next_check = FROM_UNIXTIME(1449756128),  normal_check_interval = '0.166667',  notifications_enabled = '1',  original_attributes = 'null',  output = 'Hello from acheron',  passive_checks_enabled = '1',  percent_state_change = '0',  perfdata = 'time=1449756124.991003',  problem_has_been_acknowledged = '0',  process_performance_data = '1',  retry_check_interval = '0.166667',  scheduled_downtime_depth = '0',  should_be_scheduled = '1',  state_type = '1',  status_update_time = FROM_UNIXTIME(1449756124) WHERE host_object_id = 43883;UPDATE icinga_hoststatus SET next_check = FROM_UNIXTIME(1449756128) WHERE host_object_id = 48400 AND instance_id = 1;UPDATE icinga_hoststatus SET acknowledgement_type = '0',  active_checks_enabled = '1',  check_command = 'null',  check_source = 'acheron.beutner.name',  check_type = '0',  current_check_attempt = '1',  current_notification_number = '0',  current_state = '0',  endpoint_object_id = 1,  event_handler = '',  event_handler_enabled = '1',  execution_time = '0.058502912521362305',  flap_detection_enabled = '0',  has_been_checked = '1',  host_object_id = 40661,  instance_id = 1,  is_flapping = '0',  is_reachable = '1',  last_check = FROM_UNIXTIME(1449756124),  last_hard_state = '0',  last_hard_state_change = FROM_UNIXTIME(1449755162),  last_state_change = FROM_UNIXTIME(1449755162),  last_time_up = FROM_UNIXTIME(1449756124),  latency = '0',  long_output = '',  max_check_attempts = '5',  next_check = FROM_UNIXTIME(1449756128),  normal_check_interval = '0.166667',  notifications_enabled = '1',  original_attributes = 'null',  output = 'Hello from acheron',  passive_checks_enabled = '1',  percent_state_change = '0',  perfdata = 'time=1449756124.9909849',  problem_has_been_acknowledged = '0',  process_performance_data = '1',  retry_check_interval = '0.166667',  scheduled_downtime_depth = '0',  should_be_scheduled = '1',  state_type = '1',  status_update_time = FROM_UNIXTIME(1449756124) WHERE host_object_id = 40661;UPDATE icinga_hoststatus SET acknowledgement_type = '0',  active_checks_enabled = '1',  check_command = 'null',  check_source = 'acheron.beutner.name',  check_type = '0',  current_check_attempt = '1',  current_notification_number = '0',  current_state = '0',  endpoint_object_id = 1,  event_handler = '',  event_handler_enabled = '1',  execution_time = '0.05834197998046875',  flap_detection_enabled = '0',  has_been_checked = '1',  host_object_id = 48241,  instance_id = 1,  is_flapping = '0',  is_reachable = '1',  last_check = FROM_UNIXTIME(1449756124),  last_hard_state = '0',  last_hard_state_change = FROM_UNIXTIME(1449755162),  last_state_change = FROM_UNIXTIME(1449755162),  last_time_up = FROM_UNIXTIME(1449756124),  latency = '0',  long_output = '',  max_check_attempts = '5',  next_check = FROM_UNIXTIME(1449756128),  normal_check_interval = '0.166667',  notifications_enabled = '1',  original_attributes = 'null',  output = 'Hello from acheron',  passive_checks_enabled = '1',  percent_state_change = '0',  perfdata = 'time=1449756124.990948',  problem_has_been_acknowledged = '0',  process_performance_data = '1',  retry_check_interval = '0.166667',  scheduled_downtime_depth = '0',  should_be_scheduled = '1',  state_type = '1',  status_update_time = FROM_UNIXTIME(1449756124) WHERE host_object_id = 48241;UPDATE icinga_hoststatus SET next_check = FROM_UNIXTIME(1449756128) WHERE host_object_id = 39923 AND instance_id = 1;UPDATE icinga_hoststatus SET acknowledgement_type = '0',  active_checks_enabled = '1',  check_command = 'null',  check_source = 'acheron.beutner.name',  check_type = '0',  current_check_attempt = '1',  current_notification_number = '0',  current_state = '0',  endpoint_object_id = 1,  event_handler = '',  event_handler_enabled = '1',  execution_time = '0.058226108551025391',  flap_detection_enabled = '0',  has_been_checked = '1',  host_object_id = 61060,  instance_id = 1,  is_flapping = '0',  is_reachable = '1',  last_check = FROM_UNIXTIME(1449756124),  last_hard_state = '0',  last_hard_state_change = FROM_UNIXTIME(1449756104),  last_state_change = FROM_UNIXTIME(1449756104),  last_time_up = FROM_UNIXTIME(1449756124),  latency = '0',  long_output = '',  max_check_attempts = '5',  next_check = FROM_UNIXTIME(1449756128),  normal_check_interval = '0.166667',  notifications_enabled = '1',  original_attributes = 'null',  output = 'Hello from acheron',  passive_checks_enabled = '1',  percent_state_change = '0',  perfdata = 'time=1449756124.990886',  problem_has_been_acknowledged = '0',  process_performance_data = '1',  retry_check_interval = '0.166667',  scheduled_downtime_depth = '0',  should_be_scheduled = '1',  state_type = '1',  status_update_time = FROM_UNIXTIME(1449756124) WHERE host_object_id = 61060;UPDATE icinga_hoststatus SET next_check = FROM_UNIXTIME(1449756128) WHERE host_object_id = 60788 AND instance_id = 1;UPDATE icinga_hoststatus SET acknowledgement_type = '0',  active_checks_enabled = '1',  check_command = 'null',  check_source = 'acheron.beutner.name',  check_type = '0',  current_check_attempt = '1',  current_notification_number = '0',  current_state = '0',  endpoint_object_id = 1,  event_handler = '',  event_handler_enabled = '1',  execution_time = '0.058050155639648438',  flap_detection_enabled = '0',  has_been_checked = '1',  host_object_id = 56907,  instance_id = 1,  is_flapping = '0',  is_reachable = '1',  last_check = FROM_UNIXTIME(1449756124),  last_hard_state = '0',  last_hard_state_change = FROM_UNIXTIME(1449756104),  last_state_change = FROM_UNIXTIME(1449756104),  last_time_up = FROM_UNIXTIME(1449756124),  latency = '0',  long_output = '',  max_check_attempts = '5',  next_check = FROM_UNIXTIME(1449756128),  normal_check_interval = '0.166667',  notifications_enabled = '1',  original_attributes = 'null',  output = 'Hello from acheron',  passive_checks_enabled = '1',  percent_state_change = '0',  perfdata = 'time=1449756124.9907939',  problem_has_been_acknowledged = '0',  process_performance_data = '1',  retry_check_interval = '0.166667',  scheduled_downtime_depth = '0',  should_be_scheduled = '1',  state_type = '1',  status_update_time = FROM_UNIXTIME(1449756124) WHERE host_object_id = 56907"

[icinga-migration]

Updated by mfriedrich on 2015-12-15 11:09:32 +00:00

• Status changed from New to Closed
• Assigned to set to mfriedrich
• Include in Changelog changed from 1 to 0

[icinga-migration]

Updated by gbeutner on 2016-02-23 09:58:24 +00:00

• Backport? changed from Not yet backported to Already backported