|
|
小米空气净化器就是不显示啊，哭了，疯了
2018-02-08 13:36:02 ERROR (MainThread) [homeassistant.components.fan] xiaomi_miio: Error on device update!Traceback (most recent call last): File "/usr/lib/python3.6/site-packages/homeassistant/helpers/entity_component.py", line 397, in _async_add_entity yield from entity.async_device_update(warning=False) File "/usr/lib/python3.6/site-packages/homeassistant/helpers/entity.py", line 306, in async_device_update yield from self.async_update() File "/config/custom_components/fan/xiaomi_miio.py", line 256, in async_update ATTR_AVERAGE_AIR_QUALITY_INDEX: state.average_aqi,AttributeError: 'AirPurifierStatus' object has no attribute 'average_aqi'2018-02-08 13:36:02 ERROR (MainThread) [homeassistant.core] Error doing job: Task exception was never retrievedTraceback (most recent call last): File "/usr/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context context) File "/usr/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute cursor.execute(statement, parameters)sqlite3.DatabaseError: database disk image is malformedThe above exception was the direct cause of the following exception:Traceback (most recent call last): File "/usr/lib/python3.6/asyncio/tasks.py", line 182, in _step result = coro.throw(exc) File "/usr/lib/python3.6/site-packages/homeassistant/components/device_tracker/__init__.py", line 368, in async_init_single_device yield from dev.async_added_to_hass() File "/usr/lib/python3.6/site-packages/homeassistant/components/device_tracker/__init__.py", line 590, in async_added_to_hass state = yield from async_get_last_state(self.hass, self.entity_id) File "/usr/lib/python3.6/site-packages/homeassistant/helpers/restore_state.py", line 82, in async_get_last_state _load_restore_cache, hass) File "/usr/lib/python3.6/asyncio/futures.py", line 332, in __iter__ yield self # This tells Task to wait for completion. File "/usr/lib/python3.6/asyncio/tasks.py", line 250, in _wakeup future.result() File "/usr/lib/python3.6/asyncio/futures.py", line 245, in result raise self._exception File "/usr/lib/python3.6/concurrent/futures/thread.py", line 56, in run result = self.fn(*self.args, **self.kwargs) File "/usr/lib/python3.6/site-packages/homeassistant/helpers/restore_state.py", line 44, in _load_restore_cache states = get_states(hass, last_end_time, run=last_run) File "/usr/lib/python3.6/site-packages/homeassistant/components/history.py", line 191, in get_states return [state for state in execute(query) File "/usr/lib/python3.6/site-packages/homeassistant/components/recorder/util.py", line 64, in execute (row.to_native() for row in qry) File "/usr/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/usr/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 948, in execute return meth(self, multiparams, params) File "/usr/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement compiled_sql, distilled_params File "/usr/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context context) File "/usr/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception exc_info File "/usr/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=cause) File "/usr/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 186, in reraise raise value.with_traceback(tb) File "/usr/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context context) File "/usr/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute cursor.execute(statement, parameters)sqlalchemy.exc.DatabaseError: (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 JOIN (SELECT max(states.state_id) AS max_state_id \nFROM states JOIN (SELECT states.entity_id AS max_entity_id, max(states.last_updated) AS max_last_updated \nFROM states \nWHERE states.last_updated >= ? AND states.last_updated < ? GROUP BY states.entity_id) AS anon_2 ON states.entity_id = anon_2.max_entity_id AND states.last_updated = anon_2.max_last_updated GROUP BY states.entity_id) AS anon_1 ON states.state_id = anon_1.max_state_id \nWHERE states.domain NOT IN (?, ?)'] [parameters: ('2018-02-08 04:53:13.755522', '2018-02-08 05:35:40.234347', 'zone', 'scene')] (Background on this error at: http://sqlalche.me/e/4xp6)2018-02-08 13:36:02 ERROR (MainThread) [homeassistant.core] Error doing job: Task exception was never retrievedTraceback (most recent call last): File "/usr/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context context) File "/usr/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute cursor.execute(statement, parameters)sqlite3.DatabaseError: database disk image is malformedThe above exception was the direct cause of the following exception:Traceback (most recent call last): File "/usr/lib/python3.6/asyncio/tasks.py", line 182, in _step result = coro.throw(exc) File "/usr/lib/python3.6/site-packages/homeassistant/components/device_tracker/__init__.py", line 368, in async_init_single_device yield from dev.async_added_to_hass() File "/usr/lib/python3.6/site-packages/homeassistant/components/device_tracker/__init__.py", line 590, in async_added_to_hass state = yield from async_get_last_state(self.hass, self.entity_id) File "/usr/lib/python3.6/site-packages/homeassistant/helpers/restore_state.py", line 82, in async_get_last_state _load_restore_cache, hass) File "/usr/lib/python3.6/asyncio/futures.py", line 332, in __iter__ yield self # This tells Task to wait for completion. File "/usr/lib/python3.6/asyncio/tasks.py", line 250, in _wakeup future.result() File "/usr/lib/python3.6/asyncio/futures.py", line 245, in result raise self._exception File "/usr/lib/python3.6/concurrent/futures/thread.py", line 56, in run result = self.fn(*self.args, **self.kwargs) File "/usr/lib/python3.6/site-packages/homeassistant/helpers/restore_state.py", line 44, in _load_restore_cache states = get_states(hass, last_end_time, run=last_run) File "/usr/lib/python3.6/site-packages/homeassistant/components/history.py", line 191, in get_states return [state for state in execute(query) File "/usr/lib/python3.6/site-packages/homeassistant/components/recorder/util.py", line 64, in execute (row.to_native() for row in qry) File "/usr/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/usr/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 948, in execute return meth(self, multiparams, params) File "/usr/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement compiled_sql, distilled_params File "/usr/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context context) File "/usr/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception exc_info File "/usr/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=cause) File "/usr/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 186, in reraise raise value.with_traceback(tb) File "/usr/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context context) File "/usr/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute cursor.execute(statement, parameters)sqlalchemy.exc.DatabaseError: (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 JOIN (SELECT max(states.state_id) AS max_state_id \nFROM states JOIN (SELECT states.entity_id AS max_entity_id, max(states.last_updated) AS max_last_updated \nFROM states \nWHERE states.last_updated >= ? AND states.last_updated < ? GROUP BY states.entity_id) AS anon_2 ON states.entity_id = anon_2.max_entity_id AND states.last_updated = anon_2.max_last_updated GROUP BY states.entity_id) AS anon_1 ON states.state_id = anon_1.max_state_id \nWHERE states.domain NOT IN (?, ?)'] [parameters: ('2018-02-08 04:53:13.755522', '2018-02-08 05:35:40.234347', 'zone', 'scene')] (Background on this error at: http://sqlalche.me/e/4xp6)
|
|
发表于 2018-2-8 22:29:11
