Source: components/recorder/core.py:906
integration: Recorder ([documentation](https://www.home-assistant.io/integrations/recorder), [issues](https://github.com/home-assistant/core/issues?q=is%3Aissue+is%3Aopen+label%3A%22integration%3A+recorder%22))
First occurred: 12:25:10 PM (15 occurrences)
Last logged: 12:30:47 PM
SQLAlchemyError error processing task StatisticsTask(start=datetime.datetime(2025, 8, 27, 10, 20, tzinfo=datetime.timezone.utc), fire_events=True)
SQLAlchemyError error processing task ImportStatisticsTask(metadata={'has_sum': True, 'name': 'Historical Consumption Statistics', 'source': 'recorder', 'statistic_id': 'sensor.es0021000012996697bs_historical_consumption', 'unit_of_measurement': <UnitOfEnergy.KILO_WATT_HOUR: 'kWh'>, 'mean_type': <StatisticMeanType.NONE: 0>}, statistics=[{'start': datetime.datetime(2025, 8, 20, 11, 0, tzinfo=datetime.timezone.utc), 'state': 1.393, 'sum': 156.43200000000007}, {'start': datetime.datetime(2025, 8, 20, 12, 0, tzinfo=datetime.timezone.utc), 'state': 0.504, 'sum': 156.93600000000006}, {'start': datetime.datetime(2025, 8, 20, 13, 0, tzinfo=datetime.timezone.utc), 'state': 0.97, 'sum': 157.90600000000006}, {'start': datetime.datetime(2025, 8, 20, 14, 0, tzinfo=datetime.timezone.utc), 'state': 1.948, 'sum': 159.85400000000007}, {'start': datetime.datetime(2025, 8, 20, 15, 0, tzinfo=datetime.timezone.utc), 'state': 1.263, 'sum': 161.11700000000008}, {'start': datetime.datetime(2025, 8, 20, 16, 0, tzinfo=datetime.timezone.utc), 'state': 0.26, 'sum': 161.37700000000007}, {'start': datetime.datetime(2025, 8, 20, 17, 0, tzinfo=datetime.timezone.utc), 'state': 0.241, 'sum': 161.61800000000008}, {'start': datetime.datetime(2025, 8, 20, 18, 0, tzinfo=datetime.timezone.utc), 'state': 0.404, 'sum': 162.02200000000008}, {'start': datetime.datetime(2025, 8, 20, 19, 0, tzinfo=datetime.timezone.utc), 'state': 3.41, 'sum': 165.43200000000007}, {'start': datetime.datetime(2025, 8, 20, 20, 0, tzinfo=datetime.timezone.utc), 'state': 2.449, 'sum': 167.88100000000009}, {'start': datetime.datetime(2025, 8, 20, 21, 0, tzinfo=datetime.timezone.utc), 'state': 1.251, 'sum': 169.1320000000001}, {'start': datetime.datetime(2025, 8, 20, 22, 0, tzinfo=datetime.timezone.utc), 'state': 0.288, 'sum': 169.4200000000001}, {'start': datetime.datetime(2025, 8, 20, 23, 0, tzinfo=datetime.timezone.utc), 'state': 0.217, 'sum': 169.6370000000001}, {'start': datetime.datetime(2025, 8, 21, 0, 0, tzinfo=datetime.timezone.utc), 'state': 0.222, 'sum': 169.85900000000012}, {'start': datetime.datetime(2025, 8, 21, 1, 0, tzinfo=datetime.timezone.utc), 'state': 0.212, 'sum': 170.0710000000001}, {'start': datetime.datetime(2025, 8, 21, 2, 0, tzinfo=datetime.timezone.utc), 'state': 0.208, 'sum': 170.2790000000001}, {'start': datetime.datetime(2025, 8, 21, 3, 0, tzinfo=datetime.timezone.utc), 'state': 0.197, 'sum': 170.4760000000001}, {'start': datetime.datetime(2025, 8, 21, 4, 0, tzinfo=datetime.timezone.utc), 'state': 0.202, 'sum': 170.6780000000001}, {'start': datetime.datetime(2025, 8, 21, 5, 0, tzinfo=datetime.timezone.utc), 'state': 0.265, 'sum': 170.9430000000001}, {'start': datetime.datetime(2025, 8, 21, 6, 0, tzinfo=datetime.timezone.utc), 'state': 0.666, 'sum': 171.6090000000001}, {'start': datetime.datetime(2025, 8, 21, 7, 0, tzinfo=datetime.timezone.utc), 'state': 0.54, 'sum': 172.1490000000001}, {'start': datetime.datetime(2025, 8, 21, 8, 0, tzinfo=datetime.timezone.utc), 'state': 1.24, 'sum': 173.3890000000001}, {'start': datetime.datetime(2025, 8, 21, 9, 0, tzinfo=datetime.timezone.utc), 'state': 1.291, 'sum': 174.6800000000001}, {'start': datetime.datetime(2025, 8, 21, 10, 0, tzinfo=datetime.timezone.utc), 'state': 0.447, 'sum': 175.1270000000001}, {'start': datetime.datetime(2025, 8, 21, 11, 0, tzinfo=datetime.timezone.utc), 'state': 0.28, 'sum': 175.4070000000001}, {'start': datetime.datetime(2025, 8, 21, 12, 0, tzinfo=datetime.timezone.utc), 'state': 0.967, 'sum': 176.3740000000001}, {'start': datetime.datetime(2025, 8, 21, 13, 0, tzinfo=datetime.timezone.utc), 'state': 0.741, 'sum': 177.11500000000012}, {'start': datetime.datetime(2025, 8, 21, 14, 0, tzinfo=datetime.timezone.utc), 'state': 0.782, 'sum': 177.89700000000013}, {'start': datetime.datetime(2025, 8, 21, 15, 0, tzinfo=datetime.timezone.utc), 'state': 1.1, 'sum': 178.99700000000013}, {'start': datetime.datetime(2025, 8, 21, 16, 0, tzinfo=datetime.timezone.utc), 'state': 0.234, 'sum': 179.23100000000014}, {'start': datetime.datetime(2025, 8, 21, 17, 0, tzinfo=datetime.timezone.utc), 'state': 0.259, 'sum': 179.49000000000012}, {'start': datetime.datetime(2025, 8, 21, 18, 0, tzinfo=datetime.timezone.utc), 'state': 0.16, 'sum': 179.65000000000012}, {'start': datetime.datetime(2025, 8, 21, 19, 0, tzinfo=datetime.timezone.utc), 'state': 1.519, 'sum': 181.16900000000012}, {'start': datetime.datetime(2025, 8, 21, 20, 0, tzinfo=datetime.timezone.utc), 'state': 2.542, 'sum': 183.71100000000013}, {'start': datetime.datetime(2025, 8, 21, 21, 0, tzinfo=datetime.timezone.utc), 'state': 0.914, 'sum': 184.6250000000001}, {'start': datetime.datetime(2025, 8, 21, 22, 0, tzinfo=datetime.timezone.utc), 'state': 3.635, 'sum': 188.2600000000001}, {'start': datetime.datetime(2025, 8, 21, 23, 0, tzinfo=datetime.timezone.utc), 'state': 3.479, 'sum': 191.73900000000012}, {'start': datetime.datetime(2025, 8, 22, 0, 0, tzinfo=datetime.timezone.utc), 'state': 3.566, 'sum': 195.30500000000012}, {'start': datetime.datetime(2025, 8, 22, 1, 0, tzinfo=datetime.timezone.utc), 'state': 3.295, 'sum': 198.6000000000001}, {'start': datetime.datetime(2025, 8, 22, 2, 0, tzinfo=datetime.timezone.utc), 'state': 3.29, 'sum': 201.8900000000001}, {'start': datetime.datetime(2025, 8, 22, 3, 0, tzinfo=datetime.timezone.utc), 'state': 3.276, 'sum': 205.1660000000001}, {'start': datetime.datetime(2025, 8, 22, 4, 0, tzinfo=datetime.timezone.utc), 'state': 3.274, 'sum': 208.4400000000001}, {'start': datetime.datetime(2025, 8, 22, 5, 0, tzinfo=datetime.timezone.utc), 'state': 2.659, 'sum': 211.0990000000001}, {'start': datetime.datetime(2025, 8, 22, 6, 0, tzinfo=datetime.timezone.utc), 'state': 0.279, 'sum': 211.3780000000001}, {'start': datetime.datetime(2025, 8, 22, 7, 0, tzinfo=datetime.timezone.utc), 'state': 0.499, 'sum': 211.8770000000001}, {'start': datetime.datetime(2025, 8, 22, 8, 0, tzinfo=datetime.timezone.utc), 'state': 0.891, 'sum': 212.7680000000001}, {'start': datetime.datetime(2025, 8, 22, 9, 0, tzinfo=datetime.timezone.utc), 'state': 1.26, 'sum': 214.02800000000008}, {'start': datetime.datetime(2025, 8, 22, 10, 0, tzinfo=datetime.timezone.utc), 'state': 0.949, 'sum': 214.9770000000001}, {'start': datetime.datetime(2025, 8, 22, 11, 0, tzinfo=datetime.timezone.utc), 'state': 0.268, 'sum': 215.2450000000001}, {'start': datetime.datetime(2025, 8, 22, 12, 0, tzinfo=datetime.timezone.utc), 'state': 0.34, 'sum': 215.5850000000001}, {'start': datetime.datetime(2025, 8, 22, 13, 0, tzinfo=datetime.timezone.utc), 'state': 1.12, 'sum': 216.7050000000001}, {'start': datetime.datetime(2025, 8, 22, 14, 0, tzinfo=datetime.timezone.utc), 'state': 1.005, 'sum': 217.7100000000001}, {'start': datetime.datetime(2025, 8, 22, 15, 0, tzinfo=datetime.timezone.utc), 'state': 0.319, 'sum': 218.02900000000008}, {'start': datetime.datetime(2025, 8, 22, 16, 0, tzinfo=datetime.timezone.utc), 'state': 0.164, 'sum': 218.19300000000007}, {'start': datetime.datetime(2025, 8, 22, 17, 0, tzinfo=datetime.timezone.utc), 'state': 0.172, 'sum': 218.36500000000007}, {'start': datetime.datetime(2025, 8, 22, 18, 0, tzinfo=datetime.timezone.utc), 'state': 0.151, 'sum': 218.51600000000008}, {'start': datetime.datetime(2025, 8, 22, 19, 0, tzinfo=datetime.timezone.utc), 'state': 0.23, 'sum': 218.74600000000007}, {'start': datetime.datetime(2025, 8, 22, 20, 0, tzinfo=datetime.timezone.utc), 'state': 0.331, 'sum': 219.07700000000006}, {'start': datetime.datetime(2025, 8, 22, 21, 0, tzinfo=datetime.timezone.utc), 'state': 0.233, 'sum': 219.31000000000006}, {'start': datetime.datetime(2025, 8, 22, 22, 0, tzinfo=datetime.timezone.utc), 'state': 0.219, 'sum': 219.52900000000005}, {'start': datetime.datetime(2025, 8, 22, 23, 0, tzinfo=datetime.timezone.utc), 'state': 0.202, 'sum': 219.73100000000005}, {'start': datetime.datetime(2025, 8, 23, 0, 0, tzinfo=datetime.timezone.utc), 'state': 0.197, 'sum': 219.92800000000005}, {'start': datetime.datetime(2025, 8, 23, 1, 0, tzinfo=datetime.timezone.utc), 'state': 0.221, 'sum': 220.14900000000006}, {'start': datetime.datetime(2025, 8, 23, 2, 0, tzinfo=datetime.timezone.utc), 'state': 0.199, 'sum': 220.34800000000007}, {'start': datetime.datetime(2025, 8, 23, 3, 0, tzinfo=datetime.timezone.utc), 'state': 0.201, 'sum': 220.54900000000006}, {'start': datetime.datetime(2025, 8, 23, 4, 0, tzinfo=datetime.timezone.utc), 'state': 0.231, 'sum': 220.78000000000006}, {'start': datetime.datetime(2025, 8, 23, 5, 0, tzinfo=datetime.timezone.utc), 'state': 0.268, 'sum': 221.04800000000006}, {'start': datetime.datetime(2025, 8, 23, 6, 0, tzinfo=datetime.timezone.utc), 'state': 0.308, 'sum': 221.35600000000005}, {'start': datetime.datetime(2025, 8, 23, 7, 0, tzinfo=datetime.timezone.utc), 'state': 0.269, 'sum': 221.62500000000006}, {'start': datetime.datetime(2025, 8, 23, 8, 0, tzinfo=datetime.timezone.utc), 'state': 0.278, 'sum': 221.90300000000005}, {'start': datetime.datetime(2025, 8, 23, 9, 0, tzinfo=datetime.timezone.utc), 'state': 0.22, 'sum': 222.12300000000005}, {'start': datetime.datetime(2025, 8, 23, 10, 0, tzinfo=datetime.timezone.utc), 'state': 0.243, 'sum': 222.36600000000004}, {'start': datetime.datetime(2025, 8, 23, 11, 0, tzinfo=datetime.timezone.utc), 'state': 2.125, 'sum': 224.49100000000004}, {'start': datetime.datetime(2025, 8, 23, 12, 0, tzinfo=datetime.timezone.utc), 'state': 2.781, 'sum': 227.27200000000005}, {'start': datetime.datetime(2025, 8, 23, 13, 0, tzinfo=datetime.timezone.utc), 'state': 2.045, 'sum': 229.31700000000004}, {'start': datetime.datetime(2025, 8, 23, 14, 0, tzinfo=datetime.timezone.utc), 'state': 0.826, 'sum': 230.14300000000003}, {'start': datetime.datetime(2025, 8, 23, 15, 0, tzinfo=datetime.timezone.utc), 'state': 0.306, 'sum': 230.44900000000004}, {'start': datetime.datetime(2025, 8, 23, 16, 0, tzinfo=datetime.timezone.utc), 'state': 0.232, 'sum': 230.68100000000004}, {'start': datetime.datetime(2025, 8, 23, 17, 0, tzinfo=datetime.timezone.utc), 'state': 0.185, 'sum': 230.86600000000004}, {'start': datetime.datetime(2025, 8, 23, 18, 0, tzinfo=datetime.timezone.utc), 'state': 2.8, 'sum': 233.66600000000005}, {'start': datetime.datetime(2025, 8, 23, 19, 0, tzinfo=datetime.timezone.utc), 'state': 3.402, 'sum': 237.06800000000004}, {'start': datetime.datetime(2025, 8, 23, 20, 0, tzinfo=datetime.timezone.utc), 'state': 2.863, 'sum': 239.93100000000004}, {'start': datetime.datetime(2025, 8, 23, 21, 0, tzinfo=datetime.timezone.utc), 'state': 1.9, 'sum': 241.83100000000005}, {'start': datetime.datetime(2025, 8, 23, 22, 0, tzinfo=datetime.timezone.utc), 'state': 3.363, 'sum': 245.19400000000005}, {'start': datetime.datetime(2025, 8, 23, 23, 0, tzinfo=datetime.timezone.utc), 'state': 3.341, 'sum': 248.53500000000005}, {'start': datetime.datetime(2025, 8, 24, 0, 0, tzinfo=datetime.timezone.utc), 'state': 3.339, 'sum': 251.87400000000005}, {'start': datetime.datetime(2025, 8, 24, 1, 0, tzinfo=datetime.timezone.utc), 'state': 3.287, 'sum': 255.16100000000006}, {'start': datetime.datetime(2025, 8, 24, 2, 0, tzinfo=datetime.timezone.utc), 'state': 3.283, 'sum': 258.4440000000001}, {'start': datetime.datetime(2025, 8, 24, 3, 0, tzinfo=datetime.timezone.utc), 'state': 3.283, 'sum': 261.7270000000001}, {'start': datetime.datetime(2025, 8, 24, 4, 0, tzinfo=datetime.timezone.utc), 'state': 3.276, 'sum': 265.0030000000001}, {'start': datetime.datetime(2025, 8, 24, 5, 0, tzinfo=datetime.timezone.utc), 'state': 3.267, 'sum': 268.2700000000001}, {'start': datetime.datetime(2025, 8, 24, 6, 0, tzinfo=datetime.timezone.utc), 'state': 3.361, 'sum': 271.6310000000001}, {'start': datetime.datetime(2025, 8, 24, 7, 0, tzinfo=datetime.timezone.utc), 'state': 4.342, 'sum': 275.97300000000007}, {'start': datetime.datetime(2025, 8, 24, 8, 0, tzinfo=datetime.timezone.utc), 'state': 3.368, 'sum': 279.34100000000007}, {'start': datetime.datetime(2025, 8, 24, 9, 0, tzinfo=datetime.timezone.utc), 'state': 3.439, 'sum': 282.7800000000001}, {'start': datetime.datetime(2025, 8, 24, 10, 0, tzinfo=datetime.timezone.utc), 'state': 3.142, 'sum': 285.9220000000001}, {'start': datetime.datetime(2025, 8, 24, 11, 0, tzinfo=datetime.timezone.utc), 'state': 0.433, 'sum': 286.3550000000001}, {'start': datetime.datetime(2025, 8, 24, 12, 0, tzinfo=datetime.timezone.utc), 'state': 1.696, 'sum': 288.0510000000001}, {'start': datetime.datetime(2025, 8, 24, 13, 0, tzinfo=datetime.timezone.utc), 'state': 1.921, 'sum': 289.9720000000001}, {'start': datetime.datetime(2025, 8, 24, 14, 0, tzinfo=datetime.timezone.utc), 'state': 2.56, 'sum': 292.5320000000001}, {'start': datetime.datetime(2025, 8, 24, 15, 0, tzinfo=datetime.timezone.utc), 'state': 1.321, 'sum': 293.8530000000001}, {'start': datetime.datetime(2025, 8, 24, 16, 0, tzinfo=datetime.timezone.utc), 'state': 0.881, 'sum': 294.7340000000001}, {'start': datetime.datetime(2025, 8, 24, 17, 0, tzinfo=datetime.timezone.utc), 'state': 1.046, 'sum': 295.7800000000001}, {'start': datetime.datetime(2025, 8, 24, 18, 0, tzinfo=datetime.timezone.utc), 'state': 0.7, 'sum': 296.4800000000001}, {'start': datetime.datetime(2025, 8, 24, 19, 0, tzinfo=datetime.timezone.utc), 'state': 3.165, 'sum': 299.6450000000001}, {'start': datetime.datetime(2025, 8, 24, 20, 0, tzinfo=datetime.timezone.utc), 'state': 1.397, 'sum': 301.0420000000001}, {'start': datetime.datetime(2025, 8, 24, 21, 0, tzinfo=datetime.timezone.utc), 'state': 1.379, 'sum': 302.4210000000001}], table=<class 'homeassistant.components.recorder.db_schema.Statistics'>)
SQLAlchemyError error processing task SynchronizeTask(future=<Future pending cb=[Task.task_wakeup()]>)
SQLAlchemyError error processing task StatisticsTask(start=datetime.datetime(2025, 8, 27, 10, 25, tzinfo=datetime.timezone.utc), fire_events=True)
Traceback (most recent call last):
File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 906, in _process_one_task_or_event_or_recover
self._commit_event_session_or_retry()
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^
File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 1206, in _commit_event_session_or_retry
self._commit_event_session()
~~~~~~~~~~~~~~~~~~~~~~~~~~^^
File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 1232, in _commit_event_session
session.execute(
~~~~~~~~~~~~~~~^
update(States),
^^^^^^^^^^^^^^^
...<6 lines>...
],
^^
)
^
File "/usr/local/lib/python3.13/site-packages/sqlalchemy/orm/session.py", line 2365, in execute
return self._execute_internal(
~~~~~~~~~~~~~~~~~~~~~~^
statement,
^^^^^^^^^^
...<4 lines>...
_add_event=_add_event,
^^^^^^^^^^^^^^^^^^^^^^
)
^
File "/usr/local/lib/python3.13/site-packages/sqlalchemy/orm/session.py", line 2251, in _execute_internal
result: Result[Any] = compile_state_cls.orm_execute_statement(
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
self,
^^^^^
...<4 lines>...
conn,
^^^^^
)
^
File "/usr/local/lib/python3.13/site-packages/sqlalchemy/orm/bulk_persistence.py", line 1627, in orm_execute_statement
result = _bulk_update(
mapper,
...<8 lines>...
enable_check_rowcount=enable_check_rowcount,
)
File "/usr/local/lib/python3.13/site-packages/sqlalchemy/orm/bulk_persistence.py", line 357, in _bulk_update
persistence._emit_update_statements(
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
base_mapper,
^^^^^^^^^^^^
...<6 lines>...
enable_check_rowcount=enable_check_rowcount,
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
)
^
File "/usr/local/lib/python3.13/site-packages/sqlalchemy/orm/persistence.py", line 948, in _emit_update_statements
raise orm_exc.StaleDataError(
...<3 lines>...
)
sqlalchemy.orm.exc.StaleDataError: UPDATE statement on table 'states' expected to update 15 row(s); 13 were matched.```
Describe the bug
The integration loads correctly and I can sign in, but no data is registered in the sensors. It seems the data is obtained from I-DE, but there's an error storing data in the DB (check last line in logs)
Logs