[2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: Legacy timeperiod update returned 0 segments. [2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: ParseTimeRange: 'friday' => 1471557600 -> 1471644000, stride: 1 [2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: ParseTimeRange: 'monday' => 1471816800 -> 1471903200, stride: 1 [2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: ParseTimeRange: 'friday' => 1471557600 -> 1471644000, stride: 1 [2016-08-17 12:24:56 +0200] debug/TimePeriod: Removing segment 'Wed Aug 17 12:24:56 2016' <-> 'Thu Aug 18 12:24:56 2016' from TimePeriod 'never' [2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: ParseTimeRange: 'saturday' => 1471644000 -> 1471730400, stride: 1 [2016-08-17 12:24:56 +0200] debug/TimePeriod: Dumping TimePeriod 'never' [2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: ParseTimeRange: 'sunday' => 1471730400 -> 1471816800, stride: 1 [2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: ParseTimeRange: 'monday' => 1471816800 -> 1471903200, stride: 1 [2016-08-17 12:24:56 +0200] debug/TimePeriod: Valid from 'Wed Aug 17 11:19:25 2016' until 'Thu Aug 18 12:24:56 2016 [2016-08-17 12:24:56 +0200] debug/TimePeriod: --- [2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: ParseTimeRange: 'thursday' => 1471471200 -> 1471557600, stride: 1 [2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: ParseTimeRange: 'thursday' => 1471471200 -> 1471557600, stride: 1 [2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: ParseTimeRange: 'tuesday' => 1471903200 -> 1471989600, stride: 1 [2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: ParseTimeRange: 'tuesday' => 1471903200 -> 1471989600, stride: 1 [2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: ParseTimeRange: 'wednesday' => 1471384800 -> 1471471200, stride: 1 [2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: ParseTimeRange: 'wednesday' => 1471384800 -> 1471471200, stride: 1 [2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: ParseTimeRange: 'friday' => 1471557600 -> 1471644000, stride: 1 [2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: ParseTimeRange: 'monday' => 1471816800 -> 1471903200, stride: 1 [2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: ParseTimeRange: 'saturday' => 1471644000 -> 1471730400, stride: 1 [2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: ParseTimeRange: 'sunday' => 1471730400 -> 1471816800, stride: 1 [2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: ParseTimeRange: 'thursday' => 1471471200 -> 1471557600, stride: 1 [2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: ParseTimeRange: 'friday' => 1471557600 -> 1471644000, stride: 1 [2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: ParseTimeRange: 'monday' => 1471816800 -> 1471903200, stride: 1 [2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: ParseTimeRange: 'tuesday' => 1471903200 -> 1471989600, stride: 1 [2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: ParseTimeRange: 'thursday' => 1471471200 -> 1471557600, stride: 1 [2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: ParseTimeRange: 'wednesday' => 1471989600 -> 1472076000, stride: 1 [2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: Legacy timeperiod update returned 2 segments. [2016-08-17 12:24:56 +0200] debug/TimePeriod: Removing segment 'Wed Aug 17 12:24:56 2016' <-> 'Thu Aug 18 12:24:56 2016' from TimePeriod '24x7' [2016-08-17 12:24:56 +0200] debug/TimePeriod: Dumping TimePeriod '24x7' [2016-08-17 12:24:56 +0200] debug/TimePeriod: Valid from 'Wed Aug 17 11:19:25 2016' until 'Fri Aug 19 00:00:00 2016 [2016-08-17 12:24:56 +0200] debug/TimePeriod: Segment: Tue Aug 2 00:00:00 2016 <-> Wed Aug 17 12:24:56 2016 [2016-08-17 12:24:56 +0200] debug/TimePeriod: Segment: Thu Aug 18 12:24:56 2016 <-> Fri Aug 19 00:00:00 2016 [2016-08-17 12:24:56 +0200] debug/TimePeriod: --- [2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: ParseTimeRange: 'tuesday' => 1471903200 -> 1471989600, stride: 1 [2016-08-17 12:24:56 +0200] debug/TimePeriod: Adding segment 'Wed Aug 17 00:00:00 2016' <-> 'Thu Aug 18 00:00:00 2016' to TimePeriod '24x7' [2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: ParseTimeRange: 'wednesday' => 1471989600 -> 1472076000, stride: 1 [2016-08-17 12:24:56 +0200] debug/TimePeriod: Adding segment 'Thu Aug 18 00:00:00 2016' <-> 'Fri Aug 19 00:00:00 2016' to TimePeriod '24x7' [2016-08-17 12:24:56 +0200] debug/LegacyTimePeriod: Legacy timeperiod update returned 2 segments. [2016-08-17 12:24:56 +0200] debug/TimePeriod: Dumping TimePeriod '24x7' [2016-08-17 12:24:56 +0200] debug/TimePeriod: Removing segment 'Wed Aug 17 12:24:56 2016' <-> 'Thu Aug 18 12:24:56 2016' from TimePeriod '9to5' [2016-08-17 12:24:56 +0200] debug/TimePeriod: Valid from 'Wed Aug 17 00:00:00 2016' until 'Fri Aug 19 00:00:00 2016 [2016-08-17 12:24:56 +0200] debug/TimePeriod: Segment: Tue Aug 2 00:00:00 2016 <-> Fri Aug 19 00:00:00 2016 [2016-08-17 12:24:56 +0200] debug/TimePeriod: Dumping TimePeriod '9to5' [2016-08-17 12:24:56 +0200] debug/TimePeriod: Segment: Thu Aug 18 12:24:56 2016 <-> Fri Aug 19 00:00:00 2016 [2016-08-17 12:24:56 +0200] debug/TimePeriod: --- [2016-08-17 12:24:56 +0200] debug/TimePeriod: Valid from 'Wed Aug 17 11:19:25 2016' until 'Thu Aug 18 17:00:00 2016 [2016-08-17 12:24:56 +0200] debug/TimePeriod: Segment: Wed Aug 17 09:00:00 2016 <-> Wed Aug 17 12:24:56 2016 [2016-08-17 12:24:56 +0200] debug/TimePeriod: Segment: Thu Aug 18 12:24:56 2016 <-> Thu Aug 18 17:00:00 2016 [2016-08-17 12:24:56 +0200] debug/TimePeriod: --- [2016-08-17 12:24:56 +0200] debug/TimePeriod: Adding segment 'Wed Aug 17 09:00:00 2016' <-> 'Wed Aug 17 17:00:00 2016' to TimePeriod '9to5' [2016-08-17 12:24:56 +0200] debug/TimePeriod: Adding segment 'Thu Aug 18 09:00:00 2016' <-> 'Thu Aug 18 17:00:00 2016' to TimePeriod '9to5' [2016-08-17 12:24:56 +0200] debug/TimePeriod: Dumping TimePeriod '9to5' [2016-08-17 12:24:56 +0200] debug/TimePeriod: Valid from 'Wed Aug 17 09:00:00 2016' until 'Thu Aug 18 17:00:00 2016 [2016-08-17 12:24:56 +0200] debug/TimePeriod: Segment: Wed Aug 17 09:00:00 2016 <-> Wed Aug 17 17:00:00 2016 [2016-08-17 12:24:56 +0200] debug/TimePeriod: Segment: Thu Aug 18 09:00:00 2016 <-> Thu Aug 18 17:00:00 2016 [2016-08-17 12:24:56 +0200] debug/TimePeriod: --- [2016-08-17 12:25:01 +0200] notice/WorkQueue: #5 (IdoMysqlConnection, ido-mysql) tasks: 0 [2016-08-17 12:25:01 +0200] notice/DbConnection: Updating programstatus table. [2016-08-17 12:25:01 +0200] notice/WorkQueue: Spawning WorkQueue threads for 'IdoMysqlConnection, ido-mysql' [2016-08-17 12:25:02 +0200] information/ConfigItem: Activated all objects. [2016-08-17 12:25:02 +0200] notice/WorkQueue: Stopped WorkQueue threads for 'DaemonCommand::Run' [2016-08-17 12:25:02 +0200] information/DbConnection: Resuming IDO connection: ido-mysql [2016-08-17 12:25:02 +0200] debug/IdoMysqlConnection: Query: SELECT @@global.max_allowed_packet AS max_allowed_packet [2016-08-17 12:25:02 +0200] debug/IdoMysqlConnection: Query: SELECT version FROM icinga_dbversion WHERE name='idoutils' [2016-08-17 12:25:02 +0200] debug/IdoMysqlConnection: Query: SELECT instance_id FROM icinga_instances WHERE instance_name = '***' [2016-08-17 12:25:02 +0200] information/IdoMysqlConnection: MySQL IDO instance id: 1 (schema version: '1.14.1') [2016-08-17 12:25:02 +0200] debug/IdoMysqlConnection: Query: SET SESSION TIME_ZONE='+00:00' [2016-08-17 12:25:02 +0200] debug/IdoMysqlConnection: Query: BEGIN [2016-08-17 12:25:02 +0200] notice/DbConnection: Updating programstatus table. [2016-08-17 12:25:02 +0200] debug/IdoMysqlConnection: Query: UPDATE icinga_programstatus SET active_host_checks_enabled = '1', active_service_checks_enabled = '1', daemon_mode = '1', endpoint_name = 'the_addr', event_handlers_enabled = '1', flap_detection_enabled = '1', instance_id = 1, is_currently_running = '1', last_command_check = FROM_UNIXTIME(1471429502), notifications_enabled = '1', passive_host_checks_enabled = '1', passive_service_checks_enabled = '1', process_id = '32569', process_performance_data = '1', program_start_time = FROM_UNIXTIME(1471429401), program_version = 'v2.4.10-699-gb26b3a4', status_update_time = FROM_UNIXTIME(1471429502) WHERE instance_id = 1 [2016-08-17 12:25:02 +0200] debug/IdoMysqlConnection: Query: COMMIT [2016-08-17 12:25:02 +0200] debug/IdoMysqlConnection: Query: BEGIN [2016-08-17 12:25:02 +0200] debug/IdoMysqlConnection: Query: DELETE FROM icinga_runtimevariables WHERE instance_id = 1 [2016-08-17 12:25:02 +0200] debug/IdoMysqlConnection: Query: INSERT INTO icinga_runtimevariables (instance_id, varname, varvalue) VALUES (1, 'total_services', '141593') [2016-08-17 12:25:02 +0200] debug/IdoMysqlConnection: Query: INSERT INTO icinga_runtimevariables (instance_id, varname, varvalue) VALUES (1, 'total_scheduled_services', '141593') [2016-08-17 12:25:02 +0200] debug/IdoMysqlConnection: Query: INSERT INTO icinga_runtimevariables (instance_id, varname, varvalue) VALUES (1, 'total_hosts', '3080') [2016-08-17 12:25:02 +0200] debug/IdoMysqlConnection: Query: INSERT INTO icinga_runtimevariables (instance_id, varname, varvalue) VALUES (1, 'total_scheduled_hosts', '3080') [2016-08-17 12:25:02 +0200] debug/IdoMysqlConnection: 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', 'v2.4.10-699-gb26b3a4', 'INITIAL', NOW()) [2016-08-17 12:25:02 +0200] debug/IdoMysqlConnection: Query: SELECT contactgroup_object_id AS object_id, contactgroup_id, config_hash FROM icinga_contactgroups [2016-08-17 12:25:02 +0200] critical/IdoMysqlConnection: Error "Unknown column 'config_hash' in 'field list'" when executing query "SELECT contactgroup_object_id AS object_id, contactgroup_id, config_hash FROM icinga_contactgroups" Context: (0) Reconnecting to MySQL IDO database 'ido-mysql' [2016-08-17 12:25:02 +0200] critical/IdoMysqlConnection: Exception during database operation: Verify that your database is operational! [2016-08-17 12:25:02 +0200] debug/IdoMysqlConnection: Exception during database operation: Error: std::exception (0) libdb_ido_mysql.so: void boost::throw_exception(icinga::database_error const&) (+0xa7) [0x7fecb073efc7] (1) libdb_ido_mysql.so: void boost::exception_detail::throw_exception_(icinga::database_error const&, char const*, char const*, int) (+0x50) [0x7fecb073f080] (2) libdb_ido_mysql.so: icinga::IdoMysqlConnection::Query(icinga::String const&) (+0x3ab) [0x7fecb072a59b] (3) libdb_ido_mysql.so: icinga::IdoMysqlConnection::FillIDCache(boost::intrusive_ptr const&) (+0x23a) [0x7fecb072bb0a] (4) libdb_ido.so: icinga::DbConnection::PrepareDatabase() (+0xec) [0x7fecabd7758c] (5) libdb_ido_mysql.so: icinga::IdoMysqlConnection::Reconnect() (+0x1725) [0x7fecb0731125] (6) libbase.so: icinga::WorkQueue::WorkerThreadProc() (+0x4a2) [0x7fecb88e15d2] (7) libboost_thread-mt.so.1.53.0: (+0xd24a) [0x7fecb935e24a] (8) libpthread.so.0: (+0x7dc5) [0x7fecb5f71dc5] (9) libc.so.6: clone (+0x6d) [0x7fecb5c9f28d] [2016-08-17 12:25:02 +0200] debug/IcingaApplication: In IcingaApplication::Main() [2016-08-17 12:25:02 +0200] notice/ConfigCompiler: Compiling config file: /var/lib/icinga2/modified-attributes.conf [2016-08-17 12:25:09 +0200] notice/ThreadPool: Pool #1: Pending tasks: 0; Average latency: 0ms; Threads: 4; Pool utilization: 0.00245433% [2016-08-17 12:25:11 +0200] notice/WorkQueue: #5 (IdoMysqlConnection, ido-mysql) tasks: 0 [2016-08-17 12:25:11 +0200] notice/DbConnection: Updating programstatus table. [2016-08-17 12:25:12 +0200] debug/IdoMysqlConnection: Query: SELECT @@global.max_allowed_packet AS max_allowed_packet [2016-08-17 12:25:12 +0200] debug/IdoMysqlConnection: Query: SELECT version FROM icinga_dbversion WHERE name='idoutils' [2016-08-17 12:25:12 +0200] debug/IdoMysqlConnection: Query: SELECT instance_id FROM icinga_instances WHERE instance_name = '***' [2016-08-17 12:25:12 +0200] information/IdoMysqlConnection: MySQL IDO instance id: 1 (schema version: '1.14.1') [2016-08-17 12:25:12 +0200] debug/IdoMysqlConnection: Query: SET SESSION TIME_ZONE='+00:00' [2016-08-17 12:25:12 +0200] debug/IdoMysqlConnection: Query: BEGIN [2016-08-17 12:25:12 +0200] notice/DbConnection: Updating programstatus table. [2016-08-17 12:25:12 +0200] debug/IdoMysqlConnection: Query: UPDATE icinga_programstatus SET active_host_checks_enabled = '1', active_service_checks_enabled = '1', daemon_mode = '1', endpoint_name = 'the_addr', event_handlers_enabled = '1', flap_detection_enabled = '1', instance_id = 1, is_currently_running = '1', last_command_check = FROM_UNIXTIME(1471429512), notifications_enabled = '1', passive_host_checks_enabled = '1', passive_service_checks_enabled = '1', process_id = '32569', process_performance_data = '1', program_start_time = FROM_UNIXTIME(1471429401), program_version = 'v2.4.10-699-gb26b3a4', status_update_time = FROM_UNIXTIME(1471429512) WHERE instance_id = 1 [2016-08-17 12:25:12 +0200] debug/IdoMysqlConnection: Query: COMMIT [2016-08-17 12:25:12 +0200] debug/IdoMysqlConnection: Query: BEGIN [2016-08-17 12:25:12 +0200] debug/IdoMysqlConnection: Query: DELETE FROM icinga_runtimevariables WHERE instance_id = 1 [2016-08-17 12:25:12 +0200] debug/IdoMysqlConnection: Query: INSERT INTO icinga_runtimevariables (instance_id, varname, varvalue) VALUES (1, 'total_services', '141593') [2016-08-17 12:25:12 +0200] debug/IdoMysqlConnection: Query: INSERT INTO icinga_runtimevariables (instance_id, varname, varvalue) VALUES (1, 'total_scheduled_services', '141593') [2016-08-17 12:25:12 +0200] debug/IdoMysqlConnection: Query: INSERT INTO icinga_runtimevariables (instance_id, varname, varvalue) VALUES (1, 'total_hosts', '3080') [2016-08-17 12:25:12 +0200] debug/IdoMysqlConnection: Query: INSERT INTO icinga_runtimevariables (instance_id, varname, varvalue) VALUES (1, 'total_scheduled_hosts', '3080') [2016-08-17 12:25:12 +0200] debug/IdoMysqlConnection: 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', 'v2.4.10-699-gb26b3a4', 'INITIAL', NOW()) [2016-08-17 12:25:12 +0200] debug/IdoMysqlConnection: Query: SELECT contactgroup_object_id AS object_id, contactgroup_id, config_hash FROM icinga_contactgroups [2016-08-17 12:25:12 +0200] critical/IdoMysqlConnection: Error "Unknown column 'config_hash' in 'field list'" when executing query "SELECT contactgroup_object_id AS object_id, contactgroup_id, config_hash FROM icinga_contactgroups" Context: (0) Reconnecting to MySQL IDO database 'ido-mysql' [2016-08-17 12:25:12 +0200] critical/IdoMysqlConnection: Exception during database operation: Verify that your database is operational! [2016-08-17 12:25:12 +0200] debug/IdoMysqlConnection: Exception during database operation: Error: std::exception (0) libdb_ido_mysql.so: void boost::throw_exception(icinga::database_error const&) (+0xa7) [0x7fecb073efc7] (1) libdb_ido_mysql.so: void boost::exception_detail::throw_exception_(icinga::database_error const&, char const*, char const*, int) (+0x50) [0x7fecb073f080] (2) libdb_ido_mysql.so: icinga::IdoMysqlConnection::Query(icinga::String const&) (+0x3ab) [0x7fecb072a59b] (3) libdb_ido_mysql.so: icinga::IdoMysqlConnection::FillIDCache(boost::intrusive_ptr const&) (+0x23a) [0x7fecb072bb0a] (4) libdb_ido.so: icinga::DbConnection::PrepareDatabase() (+0xec) [0x7fecabd7758c] (5) libdb_ido_mysql.so: icinga::IdoMysqlConnection::Reconnect() (+0x1725) [0x7fecb0731125] (6) libbase.so: icinga::WorkQueue::WorkerThreadProc() (+0x4a2) [0x7fecb88e15d2] (7) libboost_thread-mt.so.1.53.0: (+0xd24a) [0x7fecb935e24a] (8) libpthread.so.0: (+0x7dc5) [0x7fecb5f71dc5] (9) libc.so.6: clone (+0x6d) [0x7fecb5c9f28d] [2016-08-17 12:25:21 +0200] notice/WorkQueue: #5 (IdoMysqlConnection, ido-mysql) tasks: 0 [2016-08-17 12:25:21 +0200] notice/DbConnection: Updating programstatus table. [2016-08-17 12:25:22 +0200] debug/IdoMysqlConnection: Query: SELECT @@global.max_allowed_packet AS max_allowed_packet [2016-08-17 12:25:22 +0200] debug/IdoMysqlConnection: Query: SELECT version FROM icinga_dbversion WHERE name='idoutils' [2016-08-17 12:25:22 +0200] debug/IdoMysqlConnection: Query: SELECT instance_id FROM icinga_instances WHERE instance_name = '***' [2016-08-17 12:25:22 +0200] information/IdoMysqlConnection: MySQL IDO instance id: 1 (schema version: '1.14.1') [2016-08-17 12:25:22 +0200] debug/IdoMysqlConnection: Query: SET SESSION TIME_ZONE='+00:00' [2016-08-17 12:25:22 +0200] debug/IdoMysqlConnection: Query: BEGIN [2016-08-17 12:25:22 +0200] notice/DbConnection: Updating programstatus table. [2016-08-17 12:25:22 +0200] debug/IdoMysqlConnection: Query: UPDATE icinga_programstatus SET active_host_checks_enabled = '1', active_service_checks_enabled = '1', daemon_mode = '1', endpoint_name = 'the_addr', event_handlers_enabled = '1', flap_detection_enabled = '1', instance_id = 1, is_currently_running = '1', last_command_check = FROM_UNIXTIME(1471429522), notifications_enabled = '1', passive_host_checks_enabled = '1', passive_service_checks_enabled = '1', process_id = '32569', process_performance_data = '1', program_start_time = FROM_UNIXTIME(1471429401), program_version = 'v2.4.10-699-gb26b3a4', status_update_time = FROM_UNIXTIME(1471429522) WHERE instance_id = 1 [2016-08-17 12:25:22 +0200] debug/IdoMysqlConnection: Query: COMMIT [2016-08-17 12:25:22 +0200] debug/IdoMysqlConnection: Query: BEGIN [2016-08-17 12:25:22 +0200] debug/IdoMysqlConnection: Query: DELETE FROM icinga_runtimevariables WHERE instance_id = 1 [2016-08-17 12:25:22 +0200] debug/IdoMysqlConnection: Query: INSERT INTO icinga_runtimevariables (instance_id, varname, varvalue) VALUES (1, 'total_services', '141593') [2016-08-17 12:25:22 +0200] debug/IdoMysqlConnection: Query: INSERT INTO icinga_runtimevariables (instance_id, varname, varvalue) VALUES (1, 'total_scheduled_services', '141593') [2016-08-17 12:25:22 +0200] debug/IdoMysqlConnection: Query: INSERT INTO icinga_runtimevariables (instance_id, varname, varvalue) VALUES (1, 'total_hosts', '3080') [2016-08-17 12:25:22 +0200] debug/IdoMysqlConnection: Query: INSERT INTO icinga_runtimevariables (instance_id, varname, varvalue) VALUES (1, 'total_scheduled_hosts', '3080') [2016-08-17 12:25:22 +0200] debug/IdoMysqlConnection: 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', 'v2.4.10-699-gb26b3a4', 'INITIAL', NOW()) [2016-08-17 12:25:22 +0200] debug/IdoMysqlConnection: Query: SELECT contactgroup_object_id AS object_id, contactgroup_id, config_hash FROM icinga_contactgroups