core: recorder error every few seconds
The problem
Every few seconds an error like this occurs
Environment
| arch | armv7l |
|---|---|
| chassis | |
| dev | false |
| docker | true |
| docker_version | 19.03.12 |
| hassio | true |
| host_os | Raspbian GNU/Linux 10 (buster) |
| installation_type | Home Assistant Supervised |
| os_name | Linux |
| os_version | 5.4.51-v7l+ |
| python_version | 3.8.5 |
| supervisor | 247 |
| timezone | Europe/Bucharest |
| version | 0.116.0 |
| virtualenv | false |
Problem-relevant configuration.yaml
Traceback/Error logs
File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 497, in _commit_event_session
self.event_session.expunge(dbstate)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1854, in expunge
raise sa_exc.InvalidRequestError(
sqlalchemy.exc.InvalidRequestError: Instance is not present in this Session
Traceback (most recent call last):
File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 442, in _commit_event_session_or_retry
self._commit_event_session()
File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 497, in _commit_event_session
self.event_session.expunge(dbstate)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1854, in expunge
raise sa_exc.InvalidRequestError(
sqlalchemy.exc.InvalidRequestError: Instance is not present in this Session
2020-10-07 21:40:29 ERROR (Recorder) [homeassistant.components.recorder] Error saving events: Instance <States at 0xadc72e68> is not present in this Session
Traceback (most recent call last):
File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 442, in _commit_event_session_or_retry
self._commit_event_session()
File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 497, in _commit_event_session
self.event_session.expunge(dbstate)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1854, in expunge
raise sa_exc.InvalidRequestError(
sqlalchemy.exc.InvalidRequestError: Instance is not present in this Session
2020-10-07 21:40:29 ERROR (Recorder) [homeassistant.components.recorder] Error executing query: Instance <States at 0xadc72e68> is not present in this Session
Traceback (most recent call last):
File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 442, in _commit_event_session_or_retry
self._commit_event_session()
File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 497, in _commit_event_session
self.event_session.expunge(dbstate)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1854, in expunge
raise sa_exc.InvalidRequestError(
sqlalchemy.exc.InvalidRequestError: Instance is not present in this Session
Traceback (most recent call last):
File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 442, in _commit_event_session_or_retry
self._commit_event_session()
File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 497, in _commit_event_session
self.event_session.expunge(dbstate)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1854, in expunge
raise sa_exc.InvalidRequestError(
sqlalchemy.exc.InvalidRequestError: Instance is not present in this Session
2020-10-07 21:40:30 ERROR (Recorder) [homeassistant.components.recorder] Error saving events: Instance <States at 0xadc72e68> is not present in this Session
Traceback (most recent call last):
File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 442, in _commit_event_session_or_retry
self._commit_event_session()
File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 497, in _commit_event_session
self.event_session.expunge(dbstate)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1854, in expunge
raise sa_exc.InvalidRequestError(
sqlalchemy.exc.InvalidRequestError: Instance is not present in this Session
2020-10-07 21:40:30 ERROR (Recorder) [homeassistant.components.recorder] Error executing query: Instance <States at 0xadc72e68> is not present in this Session
Traceback (most recent call last):
File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 442, in _commit_event_session_or_retry
self._commit_event_session()
File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 497, in _commit_event_session
self.event_session.expunge(dbstate)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1854, in expunge
raise sa_exc.InvalidRequestError(
sqlalchemy.exc.InvalidRequestError: Instance is not present in this Session
Traceback (most recent call last):
File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 442, in _commit_event_session_or_retry
self._commit_event_session()
File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 497, in _commit_event_session
self.event_session.expunge(dbstate)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1854, in expunge
raise sa_exc.InvalidRequestError(
sqlalchemy.exc.InvalidRequestError: Instance is not present in this Session
2020-10-07 21:40:31 ERROR (Recorder) [homeassistant.components.recorder] Error executing query: Instance <States at 0xadc72e68> is not present in this Session
2020-10-07 21:40:31 ERROR (Recorder) [homeassistant.components.recorder] Error saving events: Instance <States at 0xadc72e68> is not present in this Session
Traceback (most recent call last):
File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 442, in _commit_event_session_or_retry
self._commit_event_session()
File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 497, in _commit_event_session
self.event_session.expunge(dbstate)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1854, in expunge
raise sa_exc.InvalidRequestError(
sqlalchemy.exc.InvalidRequestError: Instance is not present in this Session
Traceback (most recent call last):
File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 442, in _commit_event_session_or_retry
self._commit_event_session()
File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 497, in _commit_event_session
self.event_session.expunge(dbstate)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1854, in expunge
raise sa_exc.InvalidRequestError(
sqlalchemy.exc.InvalidRequestError: Instance is not present in this Session
2020-10-07 21:40:32 ERROR (Recorder) [homeassistant.components.recorder] Error executing query: Instance <States at 0xadc72e68> is not present in this Session
2020-10-07 21:40:32 ERROR (Recorder) [homeassistant.components.recorder] Error saving events: Instance <States at 0xadc72e68> is not present in this Session
Traceback (most recent call last):
File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 442, in _commit_event_session_or_retry
self._commit_event_session()
File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 497, in _commit_event_session
self.event_session.expunge(dbstate)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1854, in expung
Additional information
About this issue
- Original URL
- State: closed
- Created 4 years ago
- Comments: 28 (21 by maintainers)
It seems to be solved with
db_url: mysql://db_user:db_pass@core-mariadb/homeassistant?charset=utf8mb4
It looks like we may need to update the recorder docs https://www.home-assistant.io/integrations/recorder/#custom-database-engines