Hi ,
after upgrade HA 0.86.3 have some problem with Loggbok No logbook entries found.
Error handling request
19:39 components/recorder/util.py (ERROR)
Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: ‘SELECT events.event_id AS events_event_id, events.event_type AS events_event_type, events.event_data AS events_event_data, events.origin AS events_origin, events.time_fired AS events_time_fired, events.created AS events_created, events.context_id AS events_context_id, events.context_user_id AS events_context_user_id \nFROM events LEFT OUTER JOIN states ON events.event_id = states.event_id \nWHERE events.event_type IN (?, ?, ?, ?, ?, ?, ?, ?) AND events.time_fired > ? AND events.time_fired < ? AND (states.last_updated = states.last_changed AND states.entity_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) OR states.state_id IS NULL) ORDER BY events.time_fired’] [parameters: (‘state_changed’, ‘logbook_entry’, ‘homeassistant_start’, ‘homeassistant_stop’, ‘alexa_smart_home’, ‘homekit_state_change’, ‘automation_triggered’, ‘script_started’, ‘2019-01-26 23:00:00.000000’, ‘2019-01-27 23:00:00.000000’, ‘automation._temp_garden_high’, ‘automation._temp_garden_low’, ‘automation._temp_livingroom_high’, ‘automation._temp_livingroom_low’, ‘automation.grow_off’, ‘automation.grow_off_2’, ‘automation.grow_on’, ‘automation.grow_on_2’, ‘automation.light1_on’, ‘automation.light2_off’, ‘automation.light2_on’, ‘automation.light3_off’, ‘automation.light3_on’, ‘automation.light4_off’, ‘automation.light4_on’, ‘automation.light_off’, ‘automation.light_on’, ‘automation.message_to_pushbullet’, ‘automation.message_to_pushbullet_2’, ‘automation.message_to_pushbullet_3’, ‘automation.super_slow_internet_speed’, ‘automation.temp_garden_high’, ‘automation.temp_garden_low’, ‘automation.turn_off_kitchen_light_10_minutes_after_last_movement’, ‘automation.turn_on_kitchen_light_when_there_is_movement’, ‘binary_sensor.aeotec_zw100_multisensor_6_sensor’, ‘binary_sensor.aeotec_zw100_multisensor_6_sensor_2’, ‘device_tracker.0009342c4c3d’, ‘device_tracker.0011323b556c’, ‘device_tracker.3c1e0438904c’, ‘device_tracker.44d4e0d7c5a0’, ‘device_tracker.48ee0c78f4f4’, ‘device_tracker.54b80a6e6e7d’, ‘device_tracker.54b80a6e6e94’, ‘device_tracker.54b80a7731e2’, ‘device_tracker.54b80a7731e5’, ‘device_tracker.74c63bfac289’, ‘device_tracker.7c1c4e4d1a14’, ‘device_tracker.80d21d210859’, ‘device_tracker.a02c3679ff7e’, ‘device_tracker.accf859ec973’, ‘device_tracker.android2dbc68c134c1cf1c’, ‘device_tracker.android3f53c83a84edd355’, ‘device_tracker.android734cb6ab769e8060’, ‘device_tracker.android9774fcdcaf2b0bd9’, ‘device_tracker.b0c55401ac17’, ‘device_tracker.b0c55401af4e’, ‘device_tracker.c412f5d8ad13’, ‘device_tracker.c44202507cb1’, ‘device_tracker.c4576eba740c’, ‘device_tracker.chromecast’, ‘device_tracker.dcef09f00368’, ‘device_tracker.desktopsquulpp’, ‘device_tracker.devicename’, ‘device_tracker.elenadator’, ‘device_tracker.garage’, ‘device_tracker.garage_2’, ‘device_tracker.garden’, ‘device_tracker.hassio’, ‘device_tracker.hassio_2’, ‘device_tracker.lgwebostv’, ‘device_tracker.oneplus_3’, ‘device_tracker.plkl01cbfed534ce8855a1’, ‘device_tracker.raspberrypi’, ‘device_tracker.systemcentral’, ‘device_tracker.timer’, ‘device_tracker.timer_2’, ‘device_tracker.timer_3’, ‘device_tracker.timer_4’, ‘device_tracker.timer_5’, ‘device_tracker.unknown’, ‘device_tracker.unknown_2’, ‘device_tracker.unknown_3’, ‘device_tracker.unknown_4’, ‘device_tracker.vardagsrummet’, ‘device_tracker.vusolo’, ‘group.aeotec_multisensor_6’, ‘group.all_automations’, ‘group.all_devices’, ‘group.all_switches’, ‘media_player.bd_home_bdh6500’, ‘media_player.chromecast9781’, ‘persistent_notification.1000’, ‘persistent_notification.config_entry_discovery’, ‘persistent_notification.homeassistantcheck_config’, ‘persistent_notification.httplogin’, ‘persistent_notification.invalid_config’, ‘persistent_notification.notification’, ‘sensor.aeotec_zw100_multisensor_6_alarm_level’, ‘sensor.aeotec_zw100_multisensor_6_alarm_level_2’, ‘sensor.aeotec_zw100_multisensor_6_alarm_type’, ‘sensor.aeotec_zw100_multisensor_6_alarm_type_2’, ‘sensor.aeotec_zw100_multisensor_6_burglar’, ‘sensor.aeotec_zw100_multisensor_6_burglar_2’, ‘sensor.aeotec_zw100_multisensor_6_luminance’, ‘sensor.aeotec_zw100_multisensor_6_luminance_2’, ‘sensor.aeotec_zw100_multisensor_6_relative_humidity’, ‘sensor.aeotec_zw100_multisensor_6_relative_humidity_2’, ‘sensor.aeotec_zw100_multisensor_6_sourcenodeid’, ‘sensor.aeotec_zw100_multisensor_6_sourcenodeid_2’, ‘sensor.aeotec_zw100_multisensor_6_temperature’, ‘sensor.aeotec_zw100_multisensor_6_temperature_2’, ‘sensor.aeotec_zw100_multisensor_6_ultraviolet’, ‘sensor.aeotec_zw100_multisensor_6_ultraviolet_2’, ‘sensor.telldus_tzwp102_plugin_switch_current’, ‘sensor.telldus_tzwp102_plugin_switch_energy’, ‘sensor.telldus_tzwp102_plugin_switch_power’, ‘sensor.telldus_tzwp102_plugin_switch_previous_reading’, ‘sensor.telldus_tzwp102_plugin_switch_voltage’, ‘sensor.yr_symbol’, ‘sun.sun’, ‘switch.telldus_tzwp100_plugin_switch_switch’, ‘switch.telldus_tzwp100_plugin_switch_switch_2’, ‘switch.telldus_tzwp100_plugin_switch_switch_3’, ‘switch.telldus_tzwp100_plugin_switch_switch_4’, ‘switch.telldus_tzwp102_plugin_switch_switch’, ‘switch.unknown_node_2_switch’, ‘weather.smhi_home’, ‘zone.home’, ‘zwave.aeotec_zw090_zstick_gen5_eu’, ‘zwave.aeotec_zw100_multisensor_6’, ‘zwave.aeotec_zw100_multisensor_6_2’, ‘zwave.telldus_tzwp100_plugin_switch’, ‘zwave.telldus_tzwp100_plugin_switch_2’, ‘zwave.telldus_tzwp100_plugin_switch_3’, ‘zwave.telldus_tzwp100_plugin_switch_4’, ‘zwave.telldus_tzwp102_plugin_switch’, ‘zwave.unknown_node_2’, ‘zwave.unknown_node_2_2’, ‘zwave.unknown_node_8’, ‘zwave.unknown_node_8_2’)] (Background on this error at: Error Messages — SQLAlchemy 2.0 Documentation)
19:39 components/recorder/util.py (ERROR)
Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: ‘SELECT events.event_id AS events_event_id, events.event_type AS events_event_type, events.event_data AS events_event_data, events.origin AS events_origin, events.time_fired AS events_time_fired, events.created AS events_created, events.context_id AS events_context_id, events.context_user_id AS events_context_user_id \nFROM events LEFT OUTER JOIN states ON events.event_id = states.event_id \nWHERE events.event_type IN (?, ?, ?, ?, ?, ?, ?, ?) AND events.time_fired > ? AND events.time_fired < ? AND (states.last_updated = states.last_changed AND states.entity_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) OR states.state_id IS NULL) ORDER BY events.time_fired’] [parameters: (‘state_changed’, ‘logbook_entry’, ‘homeassistant_start’, ‘homeassistant_stop’, ‘alexa_smart_home’, ‘homekit_state_change’, ‘automation_triggered’, ‘script_started’, ‘2019-01-26 23:00:00.000000’, ‘2019-01-27 23:00:00.000000’, ‘automation._temp_garden_high’, ‘automation._temp_garden_low’, ‘automation._temp_livingroom_high’, ‘automation._temp_livingroom_low’, ‘automation.grow_off’, ‘automation.grow_off_2’, ‘automation.grow_on’, ‘automation.grow_on_2’, ‘automation.light1_on’, ‘automation.light2_off’, ‘automation.light2_on’, ‘automation.light3_off’, ‘automation.light3_on’, ‘automation.light4_off’, ‘automation.light4_on’, ‘automation.light_off’, ‘automation.light_on’, ‘automation.message_to_pushbullet’, ‘automation.message_to_pushbullet_2’, ‘automation.message_to_pushbullet_3’, ‘automation.super_slow_internet_speed’, ‘automation.temp_garden_high’, ‘automation.temp_garden_low’, ‘automation.turn_off_kitchen_light_10_minutes_after_last_movement’, ‘automation.turn_on_kitchen_light_when_there_is_movement’, ‘binary_sensor.aeotec_zw100_multisensor_6_sensor’, ‘binary_sensor.aeotec_zw100_multisensor_6_sensor_2’, ‘device_tracker.0009342c4c3d’, ‘device_tracker.0011323b556c’, ‘device_tracker.3c1e0438904c’, ‘device_tracker.44d4e0d7c5a0’, ‘device_tracker.48ee0c78f4f4’, ‘device_tracker.54b80a6e6e7d’, ‘device_tracker.54b80a6e6e94’, ‘device_tracker.54b80a7731e2’, ‘device_tracker.54b80a7731e5’, ‘device_tracker.74c63bfac289’, ‘device_tracker.7c1c4e4d1a14’, ‘device_tracker.80d21d210859’, ‘device_tracker.a02c3679ff7e’, ‘device_tracker.accf859ec973’, ‘device_tracker.android2dbc68c134c1cf1c’, ‘device_tracker.android3f53c83a84edd355’, ‘device_tracker.android734cb6ab769e8060’, ‘device_tracker.android9774fcdcaf2b0bd9’, ‘device_tracker.b0c55401ac17’, ‘device_tracker.b0c55401af4e’, ‘device_tracker.c412f5d8ad13’, ‘device_tracker.c44202507cb1’, ‘device_tracker.c4576eba740c’, ‘device_tracker.chromecast’, ‘device_tracker.dcef09f00368’, ‘device_tracker.desktopsquulpp’, ‘device_tracker.devicename’, ‘device_tracker.elenadator’, ‘device_tracker.garage’, ‘device_tracker.garage_2’, ‘device_tracker.garden’, ‘device_tracker.hassio’, ‘device_tracker.hassio_2’, ‘device_tracker.lgwebostv’, ‘device_tracker.oneplus_3’, ‘device_tracker.plkl01cbfed534ce8855a1’, ‘device_tracker.raspberrypi’, ‘device_tracker.systemcentral’, ‘device_tracker.timer’, ‘device_tracker.timer_2’, ‘device_tracker.timer_3’, ‘device_tracker.timer_4’, ‘device_tracker.timer_5’, ‘device_tracker.unknown’, ‘device_tracker.unknown_2’, ‘device_tracker.unknown_3’, ‘device_tracker.unknown_4’, ‘device_tracker.vardagsrummet’, ‘device_tracker.vusolo’, ‘group.aeotec_multisensor_6’, ‘group.all_automations’, ‘group.all_devices’, ‘group.all_switches’, ‘media_player.bd_home_bdh6500’, ‘media_player.chromecast9781’, ‘persistent_notification.1000’, ‘persistent_notification.config_entry_discovery’, ‘persistent_notification.homeassistantcheck_config’, ‘persistent_notification.httplogin’, ‘persistent_notification.invalid_config’, ‘persistent_notification.notification’, ‘sensor.aeotec_zw100_multisensor_6_alarm_level’, ‘sensor.aeotec_zw100_multisensor_6_alarm_level_2’, ‘sensor.aeotec_zw100_multisensor_6_alarm_type’, ‘sensor.aeotec_zw100_multisensor_6_alarm_type_2’, ‘sensor.aeotec_zw100_multisensor_6_burglar’, ‘sensor.aeotec_zw100_multisensor_6_burglar_2’, ‘sensor.aeotec_zw100_multisensor_6_luminance’, ‘sensor.aeotec_zw100_multisensor_6_luminance_2’, ‘sensor.aeotec_zw100_multisensor_6_relative_humidity’, ‘sensor.aeotec_zw100_multisensor_6_relative_humidity_2’, ‘sensor.aeotec_zw100_multisensor_6_sourcenodeid’, ‘sensor.aeotec_zw100_multisensor_6_sourcenodeid_2’, ‘sensor.aeotec_zw100_multisensor_6_temperature’, ‘sensor.aeotec_zw100_multisensor_6_temperature_2’, ‘sensor.aeotec_zw100_multisensor_6_ultraviolet’, ‘sensor.aeotec_zw100_multisensor_6_ultraviolet_2’, ‘sensor.telldus_tzwp102_plugin_switch_current’, ‘sensor.telldus_tzwp102_plugin_switch_energy’, ‘sensor.telldus_tzwp102_plugin_switch_power’, ‘sensor.telldus_tzwp102_plugin_switch_previous_reading’, ‘sensor.telldus_tzwp102_plugin_switch_voltage’, ‘sensor.yr_symbol’, ‘sun.sun’, ‘switch.telldus_tzwp100_plugin_switch_switch’, ‘switch.telldus_tzwp100_plugin_switch_switch_2’, ‘switch.telldus_tzwp100_plugin_switch_switch_3’, ‘switch.telldus_tzwp100_plugin_switch_switch_4’, ‘switch.telldus_tzwp102_plugin_switch_switch’, ‘switch.unknown_node_2_switch’, ‘weather.smhi_home’, ‘zone.home’, ‘zwave.aeotec_zw090_zstick_gen5_eu’, ‘zwave.aeotec_zw100_multisensor_6’, ‘zwave.aeotec_zw100_multisensor_6_2’, ‘zwave.telldus_tzwp100_plugin_switch’, ‘zwave.telldus_tzwp100_plugin_switch_2’, ‘zwave.telldus_tzwp100_plugin_switch_3’, ‘zwave.telldus_tzwp100_plugin_switch_4’, ‘zwave.telldus_tzwp102_plugin_switch’, ‘zwave.unknown_node_2’, ‘zwave.unknown_node_2_2’, ‘zwave.unknown_node_8’, ‘zwave.unknown_node_8_2’)] (Background on this error at: Error Messages — SQLAlchemy 2.0 Documentation)
19:39 components/recorder/util.py (ERROR)
Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: ‘SELECT events.event_id AS events_event_id, events.event_type AS events_event_type, events.event_data AS events_event_data, events.origin AS events_origin, events.time_fired AS events_time_fired, events.created AS events_created, events.context_id AS events_context_id, events.context_user_id AS events_context_user_id \nFROM events LEFT OUTER JOIN states ON events.event_id = states.event_id \nWHERE events.event_type IN (?, ?, ?, ?, ?, ?, ?, ?) AND events.time_fired > ? AND events.time_fired < ? AND (states.last_updated = states.last_changed AND states.entity_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) OR states.state_id IS NULL) ORDER BY events.time_fired’] [parameters: (‘state_changed’, ‘logbook_entry’, ‘homeassistant_start’, ‘homeassistant_stop’, ‘alexa_smart_home’, ‘homekit_state_change’, ‘automation_triggered’, ‘script_started’, ‘2019-01-26 23:00:00.000000’, ‘2019-01-27 23:00:00.000000’, ‘automation._temp_garden_high’, ‘automation._temp_garden_low’, ‘automation._temp_livingroom_high’, ‘automation._temp_livingroom_low’, ‘automation.grow_off’, ‘automation.grow_off_2’, ‘automation.grow_on’, ‘automation.grow_on_2’, ‘automation.light1_on’, ‘automation.light2_off’, ‘automation.light2_on’, ‘automation.light3_off’, ‘automation.light3_on’, ‘automation.light4_off’, ‘automation.light4_on’, ‘automation.light_off’, ‘automation.light_on’, ‘automation.message_to_pushbullet’, ‘automation.message_to_pushbullet_2’, ‘automation.message_to_pushbullet_3’, ‘automation.super_slow_internet_speed’, ‘automation.temp_garden_high’, ‘automation.temp_garden_low’, ‘automation.turn_off_kitchen_light_10_minutes_after_last_movement’, ‘automation.turn_on_kitchen_light_when_there_is_movement’, ‘binary_sensor.aeotec_zw100_multisensor_6_sensor’, ‘binary_sensor.aeotec_zw100_multisensor_6_sensor_2’, ‘device_tracker.0009342c4c3d’, ‘device_tracker.0011323b556c’, ‘device_tracker.3c1e0438904c’, ‘device_tracker.44d4e0d7c5a0’, ‘device_tracker.48ee0c78f4f4’, ‘device_tracker.54b80a6e6e7d’, ‘device_tracker.54b80a6e6e94’, ‘device_tracker.54b80a7731e2’, ‘device_tracker.54b80a7731e5’, ‘device_tracker.74c63bfac289’, ‘device_tracker.7c1c4e4d1a14’, ‘device_tracker.80d21d210859’, ‘device_tracker.a02c3679ff7e’, ‘device_tracker.accf859ec973’, ‘device_tracker.android2dbc68c134c1cf1c’, ‘device_tracker.android3f53c83a84edd355’, ‘device_tracker.android734cb6ab769e8060’, ‘device_tracker.android9774fcdcaf2b0bd9’, ‘device_tracker.b0c55401ac17’, ‘device_tracker.b0c55401af4e’, ‘device_tracker.c412f5d8ad13’, ‘device_tracker.c44202507cb1’, ‘device_tracker.c4576eba740c’, ‘device_tracker.chromecast’, ‘device_tracker.dcef09f00368’, ‘device_tracker.desktopsquulpp’, ‘device_tracker.devicename’, ‘device_tracker.elenadator’, ‘device_tracker.garage’, ‘device_tracker.garage_2’, ‘device_tracker.garden’, ‘device_tracker.hassio’, ‘device_tracker.hassio_2’, ‘device_tracker.lgwebostv’, ‘device_tracker.oneplus_3’, ‘device_tracker.plkl01cbfed534ce8855a1’, ‘device_tracker.raspberrypi’, ‘device_tracker.systemcentral’, ‘device_tracker.timer’, ‘device_tracker.timer_2’, ‘device_tracker.timer_3’, ‘device_tracker.timer_4’, ‘device_tracker.timer_5’, ‘device_tracker.unknown’, ‘device_tracker.unknown_2’, ‘device_tracker.unknown_3’, ‘device_tracker.unknown_4’, ‘device_tracker.vardagsrummet’, ‘device_tracker.vusolo’, ‘group.aeotec_multisensor_6’, ‘group.all_automations’, ‘group.all_devices’, ‘group.all_switches’, ‘media_player.bd_home_bdh6500’, ‘media_player.chromecast9781’, ‘persistent_notification.1000’, ‘persistent_notification.config_entry_discovery’, ‘persistent_notification.homeassistantcheck_config’, ‘persistent_notification.httplogin’, ‘persistent_notification.invalid_config’, ‘persistent_notification.notification’, ‘sensor.aeotec_zw100_multisensor_6_alarm_level’, ‘sensor.aeotec_zw100_multisensor_6_alarm_level_2’, ‘sensor.aeotec_zw100_multisensor_6_alarm_type’, ‘sensor.aeotec_zw100_multisensor_6_alarm_type_2’, ‘sensor.aeotec_zw100_multisensor_6_burglar’, ‘sensor.aeotec_zw100_multisensor_6_burglar_2’, ‘sensor.aeotec_zw100_multisensor_6_luminance’, ‘sensor.aeotec_zw100_multisensor_6_luminance_2’, ‘sensor.aeotec_zw100_multisensor_6_relative_humidity’, ‘sensor.aeotec_zw100_multisensor_6_relative_humidity_2’, ‘sensor.aeotec_zw100_multisensor_6_sourcenodeid’, ‘sensor.aeotec_zw100_multisensor_6_sourcenodeid_2’, ‘sensor.aeotec_zw100_multisensor_6_temperature’, ‘sensor.aeotec_zw100_multisensor_6_temperature_2’, ‘sensor.aeotec_zw100_multisensor_6_ultraviolet’, ‘sensor.aeotec_zw100_multisensor_6_ultraviolet_2’, ‘sensor.telldus_tzwp102_plugin_switch_current’, ‘sensor.telldus_tzwp102_plugin_switch_energy’, ‘sensor.telldus_tzwp102_plugin_switch_power’, ‘sensor.telldus_tzwp102_plugin_switch_previous_reading’, ‘sensor.telldus_tzwp102_plugin_switch_voltage’, ‘sensor.yr_symbol’, ‘sun.sun’, ‘switch.telldus_tzwp100_plugin_switch_switch’, ‘switch.telldus_tzwp100_plugin_switch_switch_2’, ‘switch.telldus_tzwp100_plugin_switch_switch_3’, ‘switch.telldus_tzwp100_plugin_switch_switch_4’, ‘switch.telldus_tzwp102_plugin_switch_switch’, ‘switch.unknown_node_2_switch’, ‘weather.smhi_home’, ‘zone.home’, ‘zwave.aeotec_zw090_zstick_gen5_eu’, ‘zwave.aeotec_zw100_multisensor_6’, ‘zwave.aeotec_zw100_multisensor_6_2’, ‘zwave.telldus_tzwp100_plugin_switch’, ‘zwave.telldus_tzwp100_plugin_switch_2’, ‘zwave.telldus_tzwp100_plugin_switch_3’, ‘zwave.telldus_tzwp100_plugin_switch_4’, ‘zwave.telldus_tzwp102_plugin_switch’, ‘zwave.unknown_node_2’, ‘zwave.unknown_node_2_2’, ‘zwave.unknown_node_8’, ‘zwave.unknown_node_8_2’)] (Background on this error at: Error Messages — SQLAlchemy 2.0 Documentation)
19:39 components/recorder/util.py (ERROR)
Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: ‘SELECT events.event_id AS events_event_id, events.event_type AS events_event_type, events.event_data AS events_event_data, events.origin AS events_origin, events.time_fired AS events_time_fired, events.created AS events_created, events.context_id AS events_context_id, events.context_user_id AS events_context_user_id \nFROM events LEFT OUTER JOIN states ON events.event_id = states.event_id \nWHERE events.event_type IN (?, ?, ?, ?, ?, ?, ?, ?) AND events.time_fired > ? AND events.time_fired < ? AND (states.last_updated = states.last_changed AND states.entity_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) OR states.state_id IS NULL) ORDER BY events.time_fired’] [parameters: (‘state_changed’, ‘logbook_entry’, ‘homeassistant_start’, ‘homeassistant_stop’, ‘alexa_smart_home’, ‘homekit_state_change’, ‘automation_triggered’, ‘script_started’, ‘2019-01-26 23:00:00.000000’, ‘2019-01-27 23:00:00.000000’, ‘automation._temp_garden_high’, ‘automation._temp_garden_low’, ‘automation._temp_livingroom_high’, ‘automation._temp_livingroom_low’, ‘automation.grow_off’, ‘automation.grow_off_2’, ‘automation.grow_on’, ‘automation.grow_on_2’, ‘automation.light1_on’, ‘automation.light2_off’, ‘automation.light2_on’, ‘automation.light3_off’, ‘automation.light3_on’, ‘automation.light4_off’, ‘automation.light4_on’, ‘automation.light_off’, ‘automation.light_on’, ‘automation.message_to_pushbullet’, ‘automation.message_to_pushbullet_2’, ‘automation.message_to_pushbullet_3’, ‘automation.super_slow_internet_speed’, ‘automation.temp_garden_high’, ‘automation.temp_garden_low’, ‘automation.turn_off_kitchen_light_10_minutes_after_last_movement’, ‘automation.turn_on_kitchen_light_when_there_is_movement’, ‘binary_sensor.aeotec_zw100_multisensor_6_sensor’, ‘binary_sensor.aeotec_zw100_multisensor_6_sensor_2’, ‘device_tracker.0009342c4c3d’, ‘device_tracker.0011323b556c’, ‘device_tracker.3c1e0438904c’, ‘device_tracker.44d4e0d7c5a0’, ‘device_tracker.48ee0c78f4f4’, ‘device_tracker.54b80a6e6e7d’, ‘device_tracker.54b80a6e6e94’, ‘device_tracker.54b80a7731e2’, ‘device_tracker.54b80a7731e5’, ‘device_tracker.74c63bfac289’, ‘device_tracker.7c1c4e4d1a14’, ‘device_tracker.80d21d210859’, ‘device_tracker.a02c3679ff7e’, ‘device_tracker.accf859ec973’, ‘device_tracker.android2dbc68c134c1cf1c’, ‘device_tracker.android3f53c83a84edd355’, ‘device_tracker.android734cb6ab769e8060’, ‘device_tracker.android9774fcdcaf2b0bd9’, ‘device_tracker.b0c55401ac17’, ‘device_tracker.b0c55401af4e’, ‘device_tracker.c412f5d8ad13’, ‘device_tracker.c44202507cb1’, ‘device_tracker.c4576eba740c’, ‘device_tracker.chromecast’, ‘device_tracker.dcef09f00368’, ‘device_tracker.desktopsquulpp’, ‘device_tracker.devicename’, ‘device_tracker.elenadator’, ‘device_tracker.garage’, ‘device_tracker.garage_2’, ‘device_tracker.garden’, ‘device_tracker.hassio’, ‘device_tracker.hassio_2’, ‘device_tracker.lgwebostv’, ‘device_tracker.oneplus_3’, ‘device_tracker.plkl01cbfed534ce8855a1’, ‘device_tracker.raspberrypi’, ‘device_tracker.systemcentral’, ‘device_tracker.timer’, ‘device_tracker.timer_2’, ‘device_tracker.timer_3’, ‘device_tracker.timer_4’, ‘device_tracker.timer_5’, ‘device_tracker.unknown’, ‘device_tracker.unknown_2’, ‘device_tracker.unknown_3’, ‘device_tracker.unknown_4’, ‘device_tracker.vardagsrummet’, ‘device_tracker.vusolo’, ‘group.aeotec_multisensor_6’, ‘group.all_automations’, ‘group.all_devices’, ‘group.all_switches’, ‘media_player.bd_home_bdh6500’, ‘media_player.chromecast9781’, ‘persistent_notification.1000’, ‘persistent_notification.config_entry_discovery’, ‘persistent_notification.homeassistantcheck_config’, ‘persistent_notification.httplogin’, ‘persistent_notification.invalid_config’, ‘persistent_notification.notification’, ‘sensor.aeotec_zw100_multisensor_6_alarm_level’, ‘sensor.aeotec_zw100_multisensor_6_alarm_level_2’, ‘sensor.aeotec_zw100_multisensor_6_alarm_type’, ‘sensor.aeotec_zw100_multisensor_6_alarm_type_2’, ‘sensor.aeotec_zw100_multisensor_6_burglar’, ‘sensor.aeotec_zw100_multisensor_6_burglar_2’, ‘sensor.aeotec_zw100_multisensor_6_luminance’, ‘sensor.aeotec_zw100_multisensor_6_luminance_2’, ‘sensor.aeotec_zw100_multisensor_6_relative_humidity’, ‘sensor.aeotec_zw100_multisensor_6_relative_humidity_2’, ‘sensor.aeotec_zw100_multisensor_6_sourcenodeid’, ‘sensor.aeotec_zw100_multisensor_6_sourcenodeid_2’, ‘sensor.aeotec_zw100_multisensor_6_temperature’, ‘sensor.aeotec_zw100_multisensor_6_temperature_2’, ‘sensor.aeotec_zw100_multisensor_6_ultraviolet’, ‘sensor.aeotec_zw100_multisensor_6_ultraviolet_2’, ‘sensor.telldus_tzwp102_plugin_switch_current’, ‘sensor.telldus_tzwp102_plugin_switch_energy’, ‘sensor.telldus_tzwp102_plugin_switch_power’, ‘sensor.telldus_tzwp102_plugin_switch_previous_reading’, ‘sensor.telldus_tzwp102_plugin_switch_voltage’, ‘sensor.yr_symbol’, ‘sun.sun’, ‘switch.telldus_tzwp100_plugin_switch_switch’, ‘switch.telldus_tzwp100_plugin_switch_switch_2’, ‘switch.telldus_tzwp100_plugin_switch_switch_3’, ‘switch.telldus_tzwp100_plugin_switch_switch_4’, ‘switch.telldus_tzwp102_plugin_switch_switch’, ‘switch.unknown_node_2_switch’, ‘weather.smhi_home’, ‘zone.home’, ‘zwave.aeotec_zw090_zstick_gen5_eu’, ‘zwave.aeotec_zw100_multisensor_6’, ‘zwave.aeotec_zw100_multisensor_6_2’, ‘zwave.telldus_tzwp100_plugin_switch’, ‘zwave.telldus_tzwp100_plugin_switch_2’, ‘zwave.telldus_tzwp100_plugin_switch_3’, ‘zwave.telldus_tzwp100_plugin_switch_4’, ‘zwave.telldus_tzwp102_plugin_switch’, ‘zwave.unknown_node_2’, ‘zwave.unknown_node_2_2’, ‘zwave.unknown_node_8’, ‘zwave.unknown_node_8_2’)] (Background on this error at: Error Messages — SQLAlchemy 2.0 Documentation)
19:38 components/recorder/util.py (ERROR)
Z-Wave entity Unknown Node 10 Switch (node_id: 10) not ready after 30 seconds, continuing anyway
19:38 components/zwave/init.py (WARNING)
Z-Wave node 10 not ready after 30 seconds, continuing anyway
19:38 components/zwave/init.py (WARNING)
Z-Wave entity Unknown Node 8 Relative Humidity (node_id: 8) not ready after 30 seconds, continuing anyway
19:38 components/zwave/init.py (WARNING)
Z-Wave node 8 not ready after 30 seconds, continuing anyway
19:38 components/zwave/init.py (WARNING)
Z-Wave entity Unknown Node 2 Switch (node_id: 2) not ready after 30 seconds, continuing anyway
19:38 components/zwave/init.py (WARNING)
Z-Wave node 2 not ready after 30 seconds, continuing anyway
19:38 components/zwave/init.py (WARNING)
Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: ‘INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)’] [parameters: (‘service_registered’, ‘{“domain”: “recorder”, “service”: “purge”}’, ‘LOCAL’, ‘2019-01-27 18:37:30.788886’, ‘2019-01-27 18:37:50.425377’, ‘634ca31cf0064d7e9b9633183a632643’, None)] (Background on this error at: Error Messages — SQLAlchemy 2.0 Documentation)
19:37 components/recorder/util.py (ERROR)
Ended unfinished session (id=181 from 2019-01-27 18:11:09.730119)
19:37 components/recorder/init.py (WARNING)
What happening how to make to the normal again?
