Home assistant after upgrade

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: http://sqlalche.me/e/4xp6)

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: http://sqlalche.me/e/4xp6)

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: http://sqlalche.me/e/4xp6)

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: http://sqlalche.me/e/4xp6)

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: http://sqlalche.me/e/4xp6)

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?



Someone who can answer?

looks like your database is corrupt

HI,
this problem is if I have on browser 192.168.1.15:8123/lovelace/default_view
but not in …:8123/states.
this appear after the last upgrade of HA 0.86.3

OK?

have you tried deleting the database and restart home assistant?

no, how do you do?

Just delete the .DB file

Is this : home-assistant_v2.db (on config/)

yes. the .db indicates database

is not sure, I attach a picture

YES!

The .db file IS the database…

We are telling you, it IS

Thanks, i will do it.

Thanks again, it works