This update seems to have deleted my configuration.yaml 
Supervisor doesnât seem to start properly either
Logger: homeassistant.components.recorder.core
Source: components/recorder/core.py:1176
integration: Recorder (documentation, issues)
First occurred: 21:57:14 (156 occurrences)
Last logged: 22:04:22
Error in database connectivity during commit: Error executing query: (sqlite3.OperationalError) unable to open database file (Background on this error at: https://sqlalche.me/e/20/e3q8). (retrying in 3 seconds)
and
Logger: homeassistant
Source: util/loop.py:200
First occurred: 22:00:09 (9 occurrences)
Last logged: 22:04:09
Error doing job: Task exception was never retrieved (None)
Traceback (most recent call last):
File "src/habluetooth/scanner.py", line 514, in _async_restart_scanner
File "src/habluetooth/scanner.py", line 526, in habluetooth.scanner.HaScanner._async_restart_scanner
File "src/habluetooth/scanner.py", line 542, in _async_reset_adapter
File "/usr/local/lib/python3.12/site-packages/habluetooth/util.py", line 13, in async_reset_adapter
File "/usr/local/lib/python3.12/site-packages/bluetooth_auto_recovery/__init__.py", line 24, in recover_adapter
File "/usr/local/lib/python3.12/concurrent/futures/thread.py", line 58, in run
File "/usr/src/homeassistant/homeassistant/util/loop.py", line 200, in protected_loop_func
File "/usr/local/lib/python3.12/importlib/__init__.py", line 90, in import_module
File "<frozen importlib._bootstrap>", line 1387, in _gcd_import
File "<frozen importlib._bootstrap>", line 1360, in _find_and_load
File "<frozen importlib._bootstrap>", line 1322, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 1262, in _find_spec
File "<frozen importlib._bootstrap_external>", line 1528, in find_spec
File "<frozen importlib._bootstrap_external>", line 1502, in _get_spec
File "<frozen importlib._bootstrap_external>", line 1605, in find_spec
File "<frozen importlib._bootstrap_external>", line 1648, in _fill_cache
OSError: [Errno 5] I/O error: '/usr/local/lib/python3.12/site-packages/bluetooth_auto_recovery'
and
Logger: homeassistant.components.recorder.util
Source: components/recorder/util.py:202
integration: Recorder (documentation, issues)
First occurred: 21:57:09 (168 occurrences)
Last logged: 22:04:07
Error executing query: (sqlite3.OperationalError) unable to open database file (Background on this error at: https://sqlalche.me/e/20/e3q8)
and
Logger: homeassistant.components.recorder.core
Source: components/recorder/core.py:882
integration: Recorder (documentation, issues)
First occurred: 21:57:09 (1 occurrences)
Last logged: 21:57:09
Unrecoverable sqlite3 database corruption detected: (sqlite3.DatabaseError) database disk image is malformed [SQL: INSERT INTO states (entity_id, state, attributes, event_id, last_changed, last_changed_ts, last_reported_ts, last_updated, last_updated_ts, old_state_id, attributes_id, context_id, context_user_id, context_parent_id, origin_idx, context_id_bin, context_user_id_bin, context_parent_id_bin, metadata_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) RETURNING state_id] [parameters: (None, '-48', None, None, None, None, None, None, 1733345829.3116176, 39025954, 46266, None, None, None, 0, <memory at 0x7f4c49b7c0>, None, None, 1067)] (Background on this error at: https://sqlalche.me/e/20/4xp6)
Traceback (most recent call last):
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2116, in _exec_insertmany_context
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 924, in do_execute
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/core.py", line 882, in _process_one_task_or_event_or_recover
File "/usr/src/homeassistant/homeassistant/components/recorder/tasks.py", line 297, in run
File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 1174, in _commit_event_session_or_retry
File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 1210, in _commit_event_session
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 2017, in commit
File "<string>", line 2, in commit
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/state_changes.py", line 139, in _go
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 1302, in commit
File "<string>", line 2, in _prepare_impl
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/state_changes.py", line 139, in _go
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 1277, in _prepare_impl
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 4341, in flush
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 4476, in _flush
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 4437, in _flush
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/unitofwork.py", line 466, in execute
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/unitofwork.py", line 642, in execute
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/persistence.py", line 93, in save_obj
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/orm/persistence.py", line 1143, in _emit_insert_statements
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1418, in execute
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/sql/elements.py", line 515, in _execute_on_connection
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1640, in _execute_clauseelement
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1844, in _execute_context
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2124, in _exec_insertmany_context
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2353, in _handle_dbapi_exception
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2116, in _exec_insertmany_context
File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 924, in do_execute
sqlalchemy.exc.DatabaseError: (sqlite3.DatabaseError) database disk image is malformed
[SQL: INSERT INTO states (entity_id, state, attributes, event_id, last_changed, last_changed_ts, last_reported_ts, last_updated, last_updated_ts, old_state_id, attributes_id, context_id, context_user_id, context_parent_id, origin_idx, context_id_bin, context_user_id_bin, context_parent_id_bin, metadata_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) RETURNING state_id]
[parameters: (None, '-48', None, None, None, None, None, None, 1733345829.3116176, 39025954, 46266, None, None, None, 0, <memory at 0x7f4c49b7c0>, None, None, 1067)]
(Background on this error at: https://sqlalche.me/e/20/4xp6)
Among other sensor/integration errors.
Reboot/shutdown via GUI doesnât work. Pulled the power of the rpi5 with no difference.
Canât access backups to restore because supervisor doesnât start (properly?).
Any ideas?
3 replies