Environment: MariaDB = 10.6.5
NOT using pymysql
With sqlalchemy
Does NOT occur when using SQLite, anyone have any ideas?
Recorder Config:
db_url: mysql://hass:--password omitted--@localhost/hass?unix_socket=/var/run/mysqld/mysqld.sock&charset=utf8mb4
purge_keep_days: 30
commit_interval: 30
include:
domains:
- binary_sensor
- sensor
- switch
- cover
- climate
- light
exclude:
entities:
- binary_sensor.main_motion
- binary_sensor.basement_motion
- sensor.last_boot
- sensor.date
- sensor.hacs
- sensor.monthly_usage
- sensor.yearly_usage
- sensor.processor_use
- sensor.server_ups_info
- light.dining_room_light
- light.office_lights
- light.bedroom_lights
- light.kitchen_lights
Error: ( Occurs every couple seconds )
Logger: homeassistant.components.recorder
Source: components/recorder/statistics.py:518
Integration: Recorder (documentation, issues)
First occurred: November 27, 2021, 23:40:10 (562 occurrences)
Last logged: 22:25:10
Error while processing event StatisticsTask(start=datetime.datetime(2021, 11, 30, 6, 0, tzinfo=datetime.timezone.utc)): TypeError: tuple indices must be integers or slices, not str
Error while processing event StatisticsTask(start=datetime.datetime(2021, 11, 30, 6, 5, tzinfo=datetime.timezone.utc)): TypeError: tuple indices must be integers or slices, not str
Error while processing event StatisticsTask(start=datetime.datetime(2021, 11, 30, 6, 10, tzinfo=datetime.timezone.utc)): TypeError: tuple indices must be integers or slices, not str
Error while processing event StatisticsTask(start=datetime.datetime(2021, 11, 30, 6, 15, tzinfo=datetime.timezone.utc)): TypeError: tuple indices must be integers or slices, not str
Error while processing event StatisticsTask(start=datetime.datetime(2021, 11, 30, 6, 20, tzinfo=datetime.timezone.utc)): TypeError: tuple indices must be integers or slices, not str
Traceback (most recent call last):
File "/usr/lib/python3.9/site-packages/homeassistant/components/recorder/__init__.py", line 681, in _run_event_loop
self._process_one_event_or_recover(event)
File "/usr/lib/python3.9/site-packages/homeassistant/components/recorder/__init__.py", line 690, in _process_one_event_or_recover
self._process_one_event(event)
File "/usr/lib/python3.9/site-packages/homeassistant/components/recorder/__init__.py", line 803, in _process_one_event
self._run_statistics(event.start)
File "/usr/lib/python3.9/site-packages/homeassistant/components/recorder/__init__.py", line 779, in _run_statistics
if statistics.compile_statistics(self, start):
File "/usr/lib/python3.9/site-packages/homeassistant/components/recorder/util.py", line 424, in wrapper
return job(instance, *args, **kwargs)
File "/usr/lib/python3.9/site-packages/homeassistant/components/recorder/statistics.py", line 407, in compile_statistics
platform_stat = platform.compile_statistics(instance.hass, start, end)
File "/usr/lib/python3.9/site-packages/homeassistant/components/sensor/recorder.py", line 404, in compile_statistics
result = _compile_statistics(hass, session, start, end)
File "/usr/lib/python3.9/site-packages/homeassistant/components/sensor/recorder.py", line 419, in _compile_statistics
old_metadatas = statistics.get_metadata_with_session(
File "/usr/lib/python3.9/site-packages/homeassistant/components/recorder/statistics.py", line 517, in get_metadata_with_session
return {
File "/usr/lib/python3.9/site-packages/homeassistant/components/recorder/statistics.py", line 518, in <dictcomp>
meta["statistic_id"]: (
File "/usr/lib/python3.9/site-packages/sqlalchemy/engine/result.py", line 63, in _raise_for_nonint
raise TypeError(
TypeError: TypeError: tuple indices must be integers or slices, not str