Hello,
Yesterday I installed a HassOs (2021.12.4) on my RPI-4 (4Gb of RAM) on kingston SSD drive. The system successfully booted and working until today. The log file shows a lot of error regarding SQL.
Before booting HassOs i’ve updated RPI eeprom to allow boot from usb drives
Some of errors:
Logger: homeassistant.components.recorder
Source: components/recorder/__init__.py:940
Integration: Recorder (documentation, issues)
First occurred: 13:17:31 (279 occurrences)
Last logged: 14:38:31
Error in database connectivity during commit: Error executing query: (sqlite3.OperationalError) disk I/O error (Background on this error at: https://sqlalche.me/e/14/e3q8). (retrying in 3 seconds)
Logger: homeassistant.components.recorder
Source: components/recorder/__init__.py:963
Integration: Recorder (documentation, issues)
First occurred: 13:17:34 (278 occurrences)
Last logged: 14:38:27
SQLAlchemyError error processing event <Event time_changed[L]: now=2021-12-23T14:37:01.002018+02:00>: This connection is on an inactive transaction. Please rollback() fully before proceeding. (Background on this error at: https://sqlalche.me/e/14/8s2a)
SQLAlchemyError error processing event <Event time_changed[L]: now=2021-12-23T14:37:31.001136+02:00>: This connection is on an inactive transaction. Please rollback() fully before proceeding. (Background on this error at: https://sqlalche.me/e/14/8s2a)
SQLAlchemyError error processing event <Event time_changed[L]: now=2021-12-23T14:38:01.001942+02:00>: This connection is on an inactive transaction. Please rollback() fully before proceeding. (Background on this error at: https://sqlalche.me/e/14/8s2a)
SQLAlchemyError error processing event <Event time_changed[L]: now=2021-12-23T14:38:17.001634+02:00>: This connection is on an inactive transaction. Please rollback() fully before proceeding. (Background on this error at: https://sqlalche.me/e/14/8s2a)
SQLAlchemyError error processing event <Event time_changed[L]: now=2021-12-23T14:38:24.000903+02:00>: This connection is on an inactive transaction. Please rollback() fully before proceeding. (Background on this error at: https://sqlalche.me/e/14/8s2a)
Traceback (most recent call last):
File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 707, in _process_one_event_or_recover
File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 874, in _process_one_event
File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 937, in _commit_event_session_or_retry
File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 963, in _commit_event_session
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1428, in commit
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 836, in commit
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2361, in commit
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2560, in _do_commit
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 549, in _invalid_transaction
sqlalchemy.exc.PendingRollbackError: This connection is on an inactive transaction. Please rollback() fully before proceeding. (Background on this error at: https://sqlalche.me/e/14/8s2a)
Before HassOs I had installation of HASS on RaspberryPi Os in docker container. Everything was installed on SD Card and there wasn’t any errors.
So I have question, does HassOs can be installed on SSD, or there limitation?