没有传感器的历史记录，怎么解决[已解决]

sert12

查看homeassistant的历史记录提示：

Error handling request
下午12:46 components/recorder/util.py (ERROR)

Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'SELECT states.state_id AS states_state_id, states.domain AS states_domain, states.entity_id AS states_entity_id, states.state AS states_state, states.attributes AS states_attributes, states.event_id AS states_event_id, states.last_changed AS states_last_changed, states.last_updated AS states_last_updated, states.created AS states_created \nFROM states \nWHERE (states.domain IN (?, ?) OR states.last_changed = states.last_updated) AND states.last_updated > ? AND states.entity_id IN (?) AND states.last_updated < ? ORDER BY states.last_updated'] [parameters: ('thermostat', 'climate', '2018-06-12 04:46:21.195000', 'sensor.humidity_158d000239acc0', '2018-06-13 04:46:21.195000')] (Background on this error at: http://sqlalche.me/e/4xp6)
下午12:46 components/recorder/util.py (ERROR)


Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'SELECT states.state_id AS states_state_id, states.domain AS states_domain, states.entity_id AS states_entity_id, states.state AS states_state, states.attributes AS states_attributes, states.event_id AS states_event_id, states.last_changed AS states_last_changed, states.last_updated AS states_last_updated, states.created AS states_created \nFROM states \nWHERE (states.domain IN (?, ?) OR states.last_changed = states.last_updated) AND states.last_updated > ? AND states.entity_id IN (?) AND states.last_updated < ? ORDER BY states.last_updated'] [parameters: ('thermostat', 'climate', '2018-06-12 04:46:21.195000', 'sensor.humidity_158d000239acc0', '2018-06-13 04:46:21.195000')] (Background on this error at: http://sqlalche.me/e/4xp6)
下午12:46 components/recorder/util.py (ERROR)

Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'SELECT states.state_id AS states_state_id, states.domain AS states_domain, states.entity_id AS states_entity_id, states.state AS states_state, states.attributes AS states_attributes, states.event_id AS states_event_id, states.last_changed AS states_last_changed, states.last_updated AS states_last_updated, states.created AS states_created \nFROM states \nWHERE (states.domain IN (?, ?) OR states.last_changed = states.last_updated) AND states.last_updated > ? AND states.entity_id IN (?) AND states.last_updated < ? ORDER BY states.last_updated'] [parameters: ('thermostat', 'climate', '2018-06-12 04:46:21.195000', 'sensor.humidity_158d000239acc0', '2018-06-13 04:46:21.195000')] (Background on this error at: http://sqlalche.me/e/4xp6)
下午12:46 components/recorder/util.py (ERROR)


Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'SELECT states.state_id AS states_state_id, states.domain AS states_domain, states.entity_id AS states_entity_id, states.state AS states_state, states.attributes AS states_attributes, states.event_id AS states_event_id, states.last_changed AS states_last_changed, states.last_updated AS states_last_updated, states.created AS states_created \nFROM states \nWHERE (states.domain IN (?, ?) OR states.last_changed = states.last_updated) AND states.last_updated > ? AND states.entity_id IN (?) AND states.last_updated < ? ORDER BY states.last_updated'] [parameters: ('thermostat', 'climate', '2018-06-12 04:46:21.195000', 'sensor.humidity_158d000239acc0', '2018-06-13 04:46:21.195000')] (Background on this error at: http://sqlalche.me/e/4xp6)
下午12:46 components/recorder/util.py (ERROR)

Mirukuteii

不懂，原因不会分析，但是对策应该是要么修复旧数据库要么导入新数据库

sert12

Mirukuteii 发表于 2018-6-13 17:29
不懂，原因不会分析，但是对策应该是要么修复旧数据库要么导入新数据库

数据库在哪里，要怎么修复

囧

停止hass运行，删除home-assistant_v2.db，重新启动hass。

sert12

Jones 发表于 2018-6-13 18:46
停止hass运行，删除home-assistant_v2.db，重新启动hass。

谢谢，解决问题。文件位置：/usr/share/hassio/homeassistant/home-assistant_v2.db

jc78256

Jones 发表于 2018-6-13 18:46
停止hass运行，删除home-assistant_v2.db，重新启动hass。

谢谢~字数补丁

ounce

我在 /usr/share/ 下没有 /hassio/homeassistant/home-assistant_v2.db