Been running for 20 minutes now and still donât have access to my History or recorder. Think the DB migration failed, or at least the logs think it did:
Database error during schema migration
10:44:35 AM â (ERROR) Recorder
Error executing query: (MySQLdb._exceptions.OperationalError) (1054, "Unknown column 'statistics_meta.name' in 'field list'") [SQL: SELECT statistics_meta.id AS statistics_meta_id, statistics_meta.statistic_id AS statistics_meta_statistic_id, statistics_meta.source AS statistics_meta_source, statistics_meta.unit_of_measurement AS statistics_meta_unit_of_measurement, statistics_meta.has_mean AS statistics_meta_has_mean, statistics_meta.has_sum AS statistics_meta_has_sum, statistics_meta.name AS statistics_meta_name FROM statistics_meta WHERE statistics_meta.has_sum = true] (Background on this error at: https://sqlalche.me/e/14/e3q8)
10:44:35 AM â (ERROR) Recorder
Error executing query: (MySQLdb._exceptions.OperationalError) (1054, "Unknown column 'statistics_meta.name' in 'field list'") [SQL: SELECT statistics_meta.id AS statistics_meta_id, statistics_meta.statistic_id AS statistics_meta_statistic_id, statistics_meta.source AS statistics_meta_source, statistics_meta.unit_of_measurement AS statistics_meta_unit_of_measurement, statistics_meta.has_mean AS statistics_meta_has_mean, statistics_meta.has_sum AS statistics_meta_has_sum, statistics_meta.name AS statistics_meta_name FROM statistics_meta WHERE statistics_meta.has_sum = true] (Background on this error at: https://sqlalche.me/e/14/e3q8)
10:44:35 AM â (ERROR) Recorder - message first occurred at 10:44:35 AM and shows up 3 times
media_player.plex_plex_web_chrome_osx_3 does not support any media_player features
10:44:35 AM â (ERROR) HomeKit - message first occurred at 10:44:35 AM and shows up 17 times
Updating character set and collation of table events to utf8mb4. Note: this can take several minutes on large databases and slow computers. Please be patient!
10:44:35 AM â (WARNING) Recorder - message first occurred at 10:44:35 AM and shows up 3 times
Database is about to upgrade. Schema version: 20
10:44:35 AM â (WARNING) Recorder
UPDATE: Looks like all of my custom sensors are failing to update:
2021-11-04 13:49:40 ERROR (MainThread) [homeassistant.helpers.entity] Update for sensor.ac_run_time_today fails
Traceback (most recent call last):
File "/usr/src/homeassistant/homeassistant/helpers/entity.py", line 468, in async_update_ha_state
await self.async_device_update()
File "/usr/src/homeassistant/homeassistant/helpers/entity.py", line 658, in async_device_update
raise exc
File "/usr/src/homeassistant/homeassistant/components/history_stats/sensor.py", line 221, in async_update
await self.hass.async_add_executor_job(
File "/usr/local/lib/python3.9/concurrent/futures/thread.py", line 52, in run
result = self.fn(*self.args, **self.kwargs)
File "/usr/src/homeassistant/homeassistant/components/history_stats/sensor.py", line 227, in _update
history_list = history.state_changes_during_period(
File "/usr/src/homeassistant/homeassistant/components/recorder/history.py", line 147, in state_changes_during_period
with session_scope(hass=hass) as session:
File "/usr/local/lib/python3.9/contextlib.py", line 119, in __enter__
return next(self.gen)
File "/usr/src/homeassistant/homeassistant/components/recorder/util.py", line 73, in session_scope
session = hass.data[DATA_INSTANCE].get_session()
TypeError: 'NoneType' object is not callable
Update 2:
Reverted to 2021.10.7 without issue. Will stay here until I hear any updates