search

Icinga / icinga2

The core of our monitoring platform with a powerful configuration language and REST API.
https://icinga.com/docs/icinga2/latest
GNU General Public License v2.0
2.03k stars 579 forks source link

[dev.icinga.com #6024] if application is stopped, db_ido reconnect forces config dump #1469

Closed icinga-migration closed 10 years ago

icinga-migration commented 10 years ago

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

Created by mfriedrich on 2014-04-16 09:32:00 +00:00

Assignee: (none) Status: Rejected (closed on 2014-04-16 13:37:16 +00:00) Target Version: (none) Last Update: 2014-09-16 09:19:47 +00:00 (in Redmine)

Icinga Version: 0.0.9

Which then leads into a hanging process.

^C[2014-04-16 11:13:47 +0200]  information/base: Shutting down Icinga...
[2014-04-16 11:13:47 +0200]  information/checker: Checker stopped.
[2014-04-16 11:13:47 +0200]  debug/db_ido_mysql: Query: COMMIT
[2014-04-16 11:13:48 +0200]  debug/base: Thread pool; current: 2; adjustment: 0
[2014-04-16 11:13:48 +0200]  debug/base: Thread pool; current: 2; adjustment: 0
[2014-04-16 11:13:48 +0200]  debug/base: Thread pool; current: 2; adjustment: 0
[2014-04-16 11:13:48 +0200]  debug/base: Thread pool; current: 2; adjustment: 0
[2014-04-16 11:13:48 +0200]  information/base: Pool #1: Pending tasks: 0; Average latency: 0ms; Threads: 8; Pool utilization: 0.000130203%
[2014-04-16 11:13:48 +0200]  debug/base: Thread pool; current: 2; adjustment: 0
[2014-04-16 11:13:48 +0200]  debug/base: Thread pool; current: 2; adjustment: 0
[2014-04-16 11:13:48 +0200]  debug/base: Thread pool; current: 2; adjustment: 0
[2014-04-16 11:13:48 +0200]  debug/base: Thread pool; current: 2; adjustment: 0
[2014-04-16 11:13:48 +0200]  information/base: Pool #2: Pending tasks: 0; Average latency: 0ms; Threads: 8; Pool utilization: 12.2858%
[2014-04-16 11:13:53 +0200]  information/base: WQ #5 items: 0
[2014-04-16 11:13:53 +0200]  debug/base: Thread pool; current: 2; adjustment: 0
[2014-04-16 11:13:53 +0200]  debug/base: Thread pool; current: 2; adjustment: 0
[2014-04-16 11:13:53 +0200]  debug/base: Thread pool; current: 2; adjustment: 0
[2014-04-16 11:13:53 +0200]  debug/base: Thread pool; current: 2; adjustment: 0
[2014-04-16 11:13:53 +0200]  information/base: Pool #1: Pending tasks: 0; Average latency: 0ms; Threads: 8; Pool utilization: 4.66545e-05%
[2014-04-16 11:13:53 +0200]  debug/base: Thread pool; current: 2; adjustment: 0
[2014-04-16 11:13:53 +0200]  debug/base: Thread pool; current: 2; adjustment: 0
[2014-04-16 11:13:53 +0200]  debug/base: Thread pool; current: 2; adjustment: 0
[2014-04-16 11:13:53 +0200]  debug/base: Thread pool; current: 2; adjustment: 0
[2014-04-16 11:13:53 +0200]  information/base: Pool #2: Pending tasks: 0; Average latency: 0ms; Threads: 8; Pool utilization: 12.4256%
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: SELECT version FROM icinga_dbversion WHERE name='idoutils'
[2014-04-16 11:13:53 +0200]  information/db_ido_mysql: MySQL IDO instance id: 1 (schema version: '1.11.0')
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: SET SESSION TIME_ZONE='+00:00'
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: INSERT INTO icinga_conninfo (instance_id, connect_time, last_checkin_time, agent_name, agent_version, connect_type, data_start_time) VALUES (1, NOW(), NOW(), 'icinga2 db_ido_mysql', 'v0.0.9-171-gbbcf470', 'INITIAL', NOW())
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: DELETE FROM icinga_comments WHERE instance_id = 1
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: DELETE FROM icinga_contact_addresses WHERE instance_id = 1
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: DELETE FROM icinga_contact_notificationcommands WHERE instance_id = 1
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: DELETE FROM icinga_contactgroup_members WHERE instance_id = 1
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: DELETE FROM icinga_customvariables WHERE instance_id = 1
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: DELETE FROM icinga_customvariablestatus WHERE instance_id = 1
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: DELETE FROM icinga_endpoints WHERE instance_id = 1
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: DELETE FROM icinga_endpointstatus WHERE instance_id = 1
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: DELETE FROM icinga_host_contactgroups WHERE instance_id = 1
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: DELETE FROM icinga_host_contacts WHERE instance_id = 1
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: DELETE FROM icinga_host_parenthosts WHERE instance_id = 1
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: DELETE FROM icinga_hostdependencies WHERE instance_id = 1
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: DELETE FROM icinga_hostgroup_members WHERE instance_id = 1
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: DELETE FROM icinga_programstatus WHERE instance_id = 1
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: DELETE FROM icinga_scheduleddowntime WHERE instance_id = 1
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: DELETE FROM icinga_servicedependencies WHERE instance_id = 1
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: SELECT object_id AS object_id, command_id FROM icinga_commands
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: SELECT endpoint_object_id AS object_id, endpoint_id FROM icinga_endpoints
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: SELECT host_object_id AS object_id, host_id FROM icinga_hosts
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: SELECT hostgroup_object_id AS object_id, hostgroup_id FROM icinga_hostgroups
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: SELECT service_object_id AS object_id, service_id FROM icinga_services
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: SELECT servicegroup_object_id AS object_id, servicegroup_id FROM icinga_servicegroups
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: SELECT timeperiod_object_id AS object_id, timeperiod_id FROM icinga_timeperiods
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: SELECT contact_object_id AS object_id, contact_id FROM icinga_contacts
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: SELECT contactgroup_object_id AS object_id, contactgroup_id FROM icinga_contactgroups
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: SELECT object_id, objecttype_id, name1, name2, is_active FROM icinga_objects WHERE instance_id = 1
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: BEGIN
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_commands SET command_line = '',  config_type = '1',  instance_id = 1,  object_id = 1 WHERE object_id = 1
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_commands SET command_line = ' \"/usr/lib/nagios/plugins/check_disk\" \"-w\" \"$wfree$%\" \"-c\" \"$cfree$%\"',  config_type = '1',  instance_id = 1,  object_id = 2 WHERE object_id = 2
[2014-04-16 11:13:53 +0200]  debug/db_ido: Dumping command vars for 'disk'
[2014-04-16 11:13:53 +0200]  debug/db_ido: command customvar key: 'cfree' value: '10'
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: INSERT INTO icinga_customvariables (config_type, has_been_modified, instance_id, object_id, varname, varvalue) VALUES ('1', '0', 1, 2, 'cfree', '10')
[2014-04-16 11:13:53 +0200]  debug/db_ido: command customvar key: 'wfree' value: '20'
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: INSERT INTO icinga_customvariables (config_type, has_been_modified, instance_id, object_id, varname, varvalue) VALUES ('1', '0', 1, 2, 'wfree', '20')
[2014-04-16 11:13:53 +0200]  debug/db_ido: Updating object vars for 'disk'
[2014-04-16 11:13:53 +0200]  debug/db_ido: object customvar key: 'cfree' value: '10' overridden: 0
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_customvariablestatus SET has_been_modified = '0',  instance_id = 1,  object_id = 2,  status_update_time = FROM_UNIXTIME(1397639633),  varname = 'cfree',  varvalue = '10' WHERE object_id = 2
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: INSERT INTO icinga_customvariablestatus (has_been_modified, instance_id, object_id, status_update_time, varname, varvalue) VALUES ('0', 1, 2, FROM_UNIXTIME(1397639633), 'cfree', '10')
[2014-04-16 11:13:53 +0200]  debug/db_ido: object customvar key: 'wfree' value: '20' overridden: 0
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_customvariablestatus SET has_been_modified = '0',  instance_id = 1,  object_id = 2,  status_update_time = FROM_UNIXTIME(1397639633),  varname = 'wfree',  varvalue = '20' WHERE object_id = 2
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_commands SET command_line = ' \"/usr/lib/nagios/plugins/check_apt\"',  config_type = '1',  instance_id = 1,  object_id = 137 WHERE object_id = 137
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_commands SET command_line = '',  config_type = '1',  instance_id = 1,  object_id = 136 WHERE object_id = 136
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_commands SET command_line = ' \"/usr/lib/nagios/plugins/check_http\" \"-H\" \"$address$\"',  config_type = '1',  instance_id = 1,  object_id = 3 WHERE object_id = 3
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_commands SET command_line = ' \"/usr/lib/nagios/plugins/check_dummy\" \"$state$\" \"$text$\"',  config_type = '1',  instance_id = 1,  object_id = 18 WHERE object_id = 18
[2014-04-16 11:13:53 +0200]  debug/db_ido: Dumping command vars for 'dummy'
[2014-04-16 11:13:53 +0200]  debug/db_ido: command customvar key: 'state' value: '0'
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: INSERT INTO icinga_customvariables (config_type, has_been_modified, instance_id, object_id, varname, varvalue) VALUES ('1', '0', 1, 18, 'state', '0')
[2014-04-16 11:13:53 +0200]  debug/db_ido: command customvar key: 'text' value: 'Check was successful.'
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: INSERT INTO icinga_customvariables (config_type, has_been_modified, instance_id, object_id, varname, varvalue) VALUES ('1', '0', 1, 18, 'text', 'Check was successful.')
[2014-04-16 11:13:53 +0200]  debug/db_ido: Updating object vars for 'dummy'
[2014-04-16 11:13:53 +0200]  debug/db_ido: object customvar key: 'state' value: '0' overridden: 0
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_customvariablestatus SET has_been_modified = '0',  instance_id = 1,  object_id = 18,  status_update_time = FROM_UNIXTIME(1397639633),  varname = 'state',  varvalue = '0' WHERE object_id = 18
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: INSERT INTO icinga_customvariablestatus (has_been_modified, instance_id, object_id, status_update_time, varname, varvalue) VALUES ('0', 1, 18, FROM_UNIXTIME(1397639633), 'state', '0')
[2014-04-16 11:13:53 +0200]  debug/db_ido: object customvar key: 'text' value: 'Check was successful.' overridden: 0
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_customvariablestatus SET has_been_modified = '0',  instance_id = 1,  object_id = 18,  status_update_time = FROM_UNIXTIME(1397639633),  varname = 'text',  varvalue = 'Check was successful.' WHERE object_id = 18
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_commands SET command_line = '',  config_type = '1',  instance_id = 1,  object_id = 5 WHERE object_id = 5
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_commands SET command_line = 'echo \"action_url resolved: $host.action_url$\"',  config_type = '1',  instance_id = 1,  object_id = 139 WHERE object_id = 139
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_commands SET command_line = ' \"/usr/lib/nagios/plugins/check_http\" \"-I\" \"$address$\" \"-S\"',  config_type = '1',  instance_id = 1,  object_id = 4 WHERE object_id = 4
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_commands SET command_line = ' \"/usr/lib/nagios/plugins/check_http\" \"-H\" \"$vhost$\"',  config_type = '1',  instance_id = 1,  object_id = 14 WHERE object_id = 14
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_commands SET command_line = ' \"/usr/lib/nagios/plugins/check_ping\" \"-4\" \"-H\" \"$address$\" \"-w\" \"$wrta$,$wpl$%\" \"-c\" \"$crta$,$cpl$%\" \"-p\" \"$packets$\" \"-t\" \"$timeout$\"',  config_type = '1',  instance_id = 1,  object_id = 126 WHERE object_id = 126
[2014-04-16 11:13:53 +0200]  debug/db_ido: Dumping command vars for 'hostalive'
[2014-04-16 11:13:53 +0200]  debug/db_ido: command customvar key: 'cpl' value: '100'
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: INSERT INTO icinga_customvariables (config_type, has_been_modified, instance_id, object_id, varname, varvalue) VALUES ('1', '0', 1, 126, 'cpl', '100')
[2014-04-16 11:13:53 +0200]  debug/db_ido: command customvar key: 'crta' value: '5000'
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: INSERT INTO icinga_customvariables (config_type, has_been_modified, instance_id, object_id, varname, varvalue) VALUES ('1', '0', 1, 126, 'crta', '5000')
[2014-04-16 11:13:53 +0200]  debug/db_ido: command customvar key: 'packets' value: '5'
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: INSERT INTO icinga_customvariables (config_type, has_been_modified, instance_id, object_id, varname, varvalue) VALUES ('1', '0', 1, 126, 'packets', '5')
[2014-04-16 11:13:53 +0200]  debug/db_ido: command customvar key: 'timeout' value: '0'
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: INSERT INTO icinga_customvariables (config_type, has_been_modified, instance_id, object_id, varname, varvalue) VALUES ('1', '0', 1, 126, 'timeout', '0')
[2014-04-16 11:13:53 +0200]  debug/db_ido: command customvar key: 'wpl' value: '80'
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: INSERT INTO icinga_customvariables (config_type, has_been_modified, instance_id, object_id, varname, varvalue) VALUES ('1', '0', 1, 126, 'wpl', '80')
[2014-04-16 11:13:53 +0200]  debug/db_ido: command customvar key: 'wrta' value: '3000'
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: INSERT INTO icinga_customvariables (config_type, has_been_modified, instance_id, object_id, varname, varvalue) VALUES ('1', '0', 1, 126, 'wrta', '3000')
[2014-04-16 11:13:53 +0200]  debug/db_ido: Updating object vars for 'hostalive'
[2014-04-16 11:13:53 +0200]  debug/db_ido: object customvar key: 'cpl' value: '100' overridden: 0
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_customvariablestatus SET has_been_modified = '0',  instance_id = 1,  object_id = 126,  status_update_time = FROM_UNIXTIME(1397639633),  varname = 'cpl',  varvalue = '100' WHERE object_id = 126
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: INSERT INTO icinga_customvariablestatus (has_been_modified, instance_id, object_id, status_update_time, varname, varvalue) VALUES ('0', 1, 126, FROM_UNIXTIME(1397639633), 'cpl', '100')
[2014-04-16 11:13:53 +0200]  debug/db_ido: object customvar key: 'crta' value: '5000' overridden: 0
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_customvariablestatus SET has_been_modified = '0',  instance_id = 1,  object_id = 126,  status_update_time = FROM_UNIXTIME(1397639633),  varname = 'crta',  varvalue = '5000' WHERE object_id = 126
[2014-04-16 11:13:53 +0200]  debug/db_ido: object customvar key: 'packets' value: '5' overridden: 0
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_customvariablestatus SET has_been_modified = '0',  instance_id = 1,  object_id = 126,  status_update_time = FROM_UNIXTIME(1397639633),  varname = 'packets',  varvalue = '5' WHERE object_id = 126
[2014-04-16 11:13:53 +0200]  debug/db_ido: object customvar key: 'timeout' value: '0' overridden: 0
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_customvariablestatus SET has_been_modified = '0',  instance_id = 1,  object_id = 126,  status_update_time = FROM_UNIXTIME(1397639633),  varname = 'timeout',  varvalue = '0' WHERE object_id = 126
[2014-04-16 11:13:53 +0200]  debug/db_ido: object customvar key: 'wpl' value: '80' overridden: 0
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_customvariablestatus SET has_been_modified = '0',  instance_id = 1,  object_id = 126,  status_update_time = FROM_UNIXTIME(1397639633),  varname = 'wpl',  varvalue = '80' WHERE object_id = 126
[2014-04-16 11:13:53 +0200]  debug/db_ido: object customvar key: 'wrta' value: '3000' overridden: 0
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_customvariablestatus SET has_been_modified = '0',  instance_id = 1,  object_id = 126,  status_update_time = FROM_UNIXTIME(1397639633),  varname = 'wrta',  varvalue = '3000' WHERE object_id = 126
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_commands SET command_line = ' \"sudo\" \"/etc/icinga2/scripts/check_kernel\"',  config_type = '1',  instance_id = 1,  object_id = 138 WHERE object_id = 138
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_commands SET command_line = ' \"/usr/lib/nagios/plugins/check_ping\" \"-6\" \"-H\" \"$address6$\" \"-w\" \"$wrta$,$wpl$%\" \"-c\" \"$crta$,$cpl$%\" \"-p\" \"$packets$\" \"-t\" \"$timeout$\"',  config_type = '1',  instance_id = 1,  object_id = 10 WHERE object_id = 10
[2014-04-16 11:13:53 +0200]  debug/db_ido: Dumping command vars for 'ping6'
[2014-04-16 11:13:53 +0200]  debug/db_ido: command customvar key: 'cpl' value: '15'
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: INSERT INTO icinga_customvariables (config_type, has_been_modified, instance_id, object_id, varname, varvalue) VALUES ('1', '0', 1, 10, 'cpl', '15')
[2014-04-16 11:13:53 +0200]  debug/db_ido: command customvar key: 'crta' value: '200'
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: INSERT INTO icinga_customvariables (config_type, has_been_modified, instance_id, object_id, varname, varvalue) VALUES ('1', '0', 1, 10, 'crta', '200')
[2014-04-16 11:13:53 +0200]  debug/db_ido: command customvar key: 'packets' value: '5'
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: INSERT INTO icinga_customvariables (config_type, has_been_modified, instance_id, object_id, varname, varvalue) VALUES ('1', '0', 1, 10, 'packets', '5')
[2014-04-16 11:13:53 +0200]  debug/db_ido: command customvar key: 'timeout' value: '0'
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: INSERT INTO icinga_customvariables (config_type, has_been_modified, instance_id, object_id, varname, varvalue) VALUES ('1', '0', 1, 10, 'timeout', '0')
[2014-04-16 11:13:53 +0200]  debug/db_ido: command customvar key: 'wpl' value: '5'
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: INSERT INTO icinga_customvariables (config_type, has_been_modified, instance_id, object_id, varname, varvalue) VALUES ('1', '0', 1, 10, 'wpl', '5')
[2014-04-16 11:13:53 +0200]  debug/db_ido: command customvar key: 'wrta' value: '100'
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: INSERT INTO icinga_customvariables (config_type, has_been_modified, instance_id, object_id, varname, varvalue) VALUES ('1', '0', 1, 10, 'wrta', '100')
[2014-04-16 11:13:53 +0200]  debug/db_ido: Updating object vars for 'ping6'
[2014-04-16 11:13:53 +0200]  debug/db_ido: object customvar key: 'cpl' value: '15' overridden: 0
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_customvariablestatus SET has_been_modified = '0',  instance_id = 1,  object_id = 10,  status_update_time = FROM_UNIXTIME(1397639633),  varname = 'cpl',  varvalue = '15' WHERE object_id = 10
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: INSERT INTO icinga_customvariablestatus (has_been_modified, instance_id, object_id, status_update_time, varname, varvalue) VALUES ('0', 1, 10, FROM_UNIXTIME(1397639633), 'cpl', '15')
[2014-04-16 11:13:53 +0200]  debug/db_ido: object customvar key: 'crta' value: '200' overridden: 0
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_customvariablestatus SET has_been_modified = '0',  instance_id = 1,  object_id = 10,  status_update_time = FROM_UNIXTIME(1397639633),  varname = 'crta',  varvalue = '200' WHERE object_id = 10
[2014-04-16 11:13:53 +0200]  debug/db_ido: object customvar key: 'packets' value: '5' overridden: 0
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_customvariablestatus SET has_been_modified = '0',  instance_id = 1,  object_id = 10,  status_update_time = FROM_UNIXTIME(1397639633),  varname = 'packets',  varvalue = '5' WHERE object_id = 10
[2014-04-16 11:13:53 +0200]  debug/db_ido: object customvar key: 'timeout' value: '0' overridden: 0
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_customvariablestatus SET has_been_modified = '0',  instance_id = 1,  object_id = 10,  status_update_time = FROM_UNIXTIME(1397639633),  varname = 'timeout',  varvalue = '0' WHERE object_id = 10
[2014-04-16 11:13:53 +0200]  debug/db_ido: object customvar key: 'wpl' value: '5' overridden: 0
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_customvariablestatus SET has_been_modified = '0',  instance_id = 1,  object_id = 10,  status_update_time = FROM_UNIXTIME(1397639633),  varname = 'wpl',  varvalue = '5' WHERE object_id = 10
[2014-04-16 11:13:53 +0200]  debug/db_ido: object customvar key: 'wrta' value: '100' overridden: 0
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_customvariablestatus SET has_been_modified = '0',  instance_id = 1,  object_id = 10,  status_update_time = FROM_UNIXTIME(1397639633),  varname = 'wrta',  varvalue = '100' WHERE object_id = 10
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_commands SET command_line = ' \"/usr/lib/nagios/plugins/check_ntp_time\" \"-H\" \"$address$\"',  config_type = '1',  instance_id = 1,  object_id = 20 WHERE object_id = 20
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_commands SET command_line = ' \"/usr/lib/nagios/plugins/check_http\" \"-H\" \"$vhost$\" \"-S\"',  config_type = '1',  instance_id = 1,  object_id = 19 WHERE object_id = 19
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_commands SET command_line = ' \"/usr/lib/nagios/plugins/check_dummy\" \"$state$\" \"$text$\"',  config_type = '1',  instance_id = 1,  object_id = 6 WHERE object_id = 6
[2014-04-16 11:13:53 +0200]  debug/db_ido: Dumping command vars for 'passive'
[2014-04-16 11:13:53 +0200]  debug/db_ido: command customvar key: 'state' value: '3'
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: INSERT INTO icinga_customvariables (config_type, has_been_modified, instance_id, object_id, varname, varvalue) VALUES ('1', '0', 1, 6, 'state', '3')
[2014-04-16 11:13:53 +0200]  debug/db_ido: command customvar key: 'text' value: 'No Passive Check Result Received.'
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: INSERT INTO icinga_customvariables (config_type, has_been_modified, instance_id, object_id, varname, varvalue) VALUES ('1', '0', 1, 6, 'text', 'No Passive Check Result Received.')
[2014-04-16 11:13:53 +0200]  debug/db_ido: Updating object vars for 'passive'
[2014-04-16 11:13:53 +0200]  debug/db_ido: object customvar key: 'state' value: '3' overridden: 0
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_customvariablestatus SET has_been_modified = '0',  instance_id = 1,  object_id = 6,  status_update_time = FROM_UNIXTIME(1397639633),  varname = 'state',  varvalue = '3' WHERE object_id = 6
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: INSERT INTO icinga_customvariablestatus (has_been_modified, instance_id, object_id, status_update_time, varname, varvalue) VALUES ('0', 1, 6, FROM_UNIXTIME(1397639633), 'state', '3')
[2014-04-16 11:13:53 +0200]  debug/db_ido: object customvar key: 'text' value: 'No Passive Check Result Received.' overridden: 0
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_customvariablestatus SET has_been_modified = '0',  instance_id = 1,  object_id = 6,  status_update_time = FROM_UNIXTIME(1397639633),  varname = 'text',  varvalue = 'No Passive Check Result Received.' WHERE object_id = 6
[2014-04-16 11:13:53 +0200]  debug/db_ido_mysql: Query: UPDATE icinga_commands SET command_line = ' \"/usr/lib/nagios/plugins/check_snmp\" \"-H\" \"$address$\" \"-o\" \"$oid$\" \"-C\" \"$community$\"',  config_type = '1',  instance_id = 1,  object_id = 12 WHERE object_id = 12
icinga-migration commented 10 years ago

Updated by mfriedrich on 2014-04-16 13:37:16 +00:00

duplicated object lock, thread hangs, application waits, db_ido thread reconnects. doesn't happen with fixed code.

icinga-migration commented 10 years ago

Updated by mfriedrich on 2014-09-16 09:19:47 +00:00