After I upgraded from 2021.1.5 to 2021.2.1 I lost all binary sensors that connect through a Eps8266 and two mcp23017 multiplexers. I restored my last backup an all is good again.
Anyone know what happened?
After I upgraded from 2021.1.5 to 2021.2.1 I lost all binary sensors that connect through a Eps8266 and two mcp23017 multiplexers. I restored my last backup an all is good again.
Anyone know what happened?
Come on, logs?
I was trying to figure it out and used the backup before I looked at the logs.
Is there any tutorial availalbe on how to get the logs?
I’ve been struggling to find one to guide me.
cat /config/home-assistant.log
This is part of my log, it’s 74 mb’s so I copied the first error. Can you tell me how to fix this, it seems to be a corrupt file or database.
2021-03-20 19:18:32 WARNING (MainThread) [homeassistant.loader] You are using a custom integration for hacs which has not been tested by Home Assistant. This component might cause stability problems, be sure to disable it if you experience issues with Home Assistant.
2021-03-20 19:18:43 WARNING (MainThread) [homeassistant.setup] Setup of recorder is taking over 10 seconds.
2021-03-20 19:19:32 WARNING (MainThread) [homeassistant.bootstrap] Waiting on integrations to complete setup: recorder
2021-03-20 19:19:33 WARNING (Recorder) [homeassistant.components.recorder] Ended unfinished session (id=187 from 2021-03-19 01:49:53.890240)
2021-03-20 19:19:42 ERROR (MainThread) [homeassistant.components.binary_sensor] Platform esphome does not generate unique IDs. ID sensorbinary_sensormoving already exists - ignoring binary_sensor.moving
2021-03-20 19:19:42 ERROR (MainThread) [homeassistant.components.sensor] Platform esphome does not generate unique IDs. ID sensorsensorwaynes_room_temperature already exists - ignoring sensor.wayne_s_room_temperature
2021-03-20 19:19:42 ERROR (MainThread) [homeassistant.components.sensor] Platform esphome does not generate unique IDs. ID sensorsensorbme280-1_temperature already exists - ignoring sensor.bme280_1_temperature
2021-03-20 19:19:42 ERROR (MainThread) [homeassistant.components.sensor] Platform esphome does not generate unique IDs. ID sensorsensorwaynes_room_humidity already exists - ignoring sensor.wayne_s_room_humidity
2021-03-20 19:19:42 ERROR (MainThread) [homeassistant.components.sensor] Platform esphome does not generate unique IDs. ID sensorsensorbme280-1_pressure already exists - ignoring sensor.bme280_1_pressure
2021-03-20 19:19:42 ERROR (MainThread) [homeassistant.components.sensor] Platform esphome does not generate unique IDs. ID sensorsensorbmp280-1_humidity already exists - ignoring sensor.bmp280_1_humidity
2021-03-20 19:19:47 ERROR (Recorder) [homeassistant.components.recorder] 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, context_parent_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)]
[parameters: (‘service_registered’, ‘{“domain”: “recorder”, “service”: “purge”}’, ‘LOCAL’, ‘2021-03-21 00:18:33.023034’, ‘2021-03-21 00:18:33.023034’, ‘c0f9e8da5edd88d3232c86d75b67511c’, None, None)]
(Background on this error at: Error Messages — SQLAlchemy 1.3 Documentation)
2021-03-20 19:19:47 ERROR (Recorder) [homeassistant.components.recorder] Error saving events: (sqlite3.DatabaseError) database disk image is malformed
[SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id, context_parent_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)]
[parameters: (‘service_registered’, ‘{“domain”: “recorder”, “service”: “purge”}’, ‘LOCAL’, ‘2021-03-21 00:18:33.023034’, ‘2021-03-21 00:18:33.023034’, ‘c0f9e8da5edd88d3232c86d75b67511c’, None, None)]
(Background on this error at: Error Messages — SQLAlchemy 1.3 Documentation)
Traceback (most recent call last):
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py”, line 1276, in _execute_context
self.dialect.do_execute(
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py”, line 593, in do_execute
cursor.execute(statement, parameters)
sqlite3.DatabaseError: database disk image is malformed
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File “/usr/src/homeassistant/homeassistant/components/recorder/init.py”, line 454, in _commit_event_session_or_retry
self._commit_event_session()
File “/usr/src/homeassistant/homeassistant/components/recorder/init.py”, line 509, in _commit_event_session
self.event_session.flush()
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py”, line 2536, in flush
self._flush(objects)
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py”, line 2678, in flush
transaction.rollback(capture_exception=True)
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py”, line 68, in exit
compat.raise(
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py”, line 182, in raise
raise exception
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py”, line 2638, in flush
flush_context.execute()
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/unitofwork.py”, line 419, in execute
n.execute_aggregate(self, set)
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/unitofwork.py”, line 521, in execute_aggregate
self.execute(uow)
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/unitofwork.py”, line 586, in execute
persistence.save_obj(
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/persistence.py”, line 239, in save_obj
_emit_insert_statements(
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/persistence.py”, line 1135, in _emit_insert_statements
result = cached_connections[connection].execute(
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py”, line 1011, in execute
return meth(self, multiparams, params)
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/sql/elements.py”, line 298, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py”, line 1124, in _execute_clauseelement
ret = self._execute_context(
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py”, line 1316, in _execute_context
self.handle_dbapi_exception(
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py”, line 1510, in handle_dbapi_exception
util.raise(
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py”, line 182, in raise
raise exception
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py”, line 1276, in _execute_context
self.dialect.do_execute(
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py”, line 593, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.DatabaseError: (sqlite3.DatabaseError) database disk image is malformed