Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
icinga-migration opened this issue Dec 10, 2015 · 3 comments
Closed

Comments

@icinga-migration
Copy link
Member

@icinga-migration icinga-migration commented Dec 10, 2015

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
Copy link
Member Author

@icinga-migration icinga-migration commented Dec 10, 2015

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
Copy link
Member Author

@icinga-migration icinga-migration commented Dec 15, 2015

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
Copy link
Member Author

@icinga-migration icinga-migration commented Feb 23, 2016

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

  • Backport? changed from Not yet backported to Already backported
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant
You can’t perform that action at this time.