Am running homeassistant supervised on Debian (now already for several years). I use the standard MariaDB as database and this setup has been running very well since a long time. I do have to admit that I run quite a heavy installation with over a 1.000 sensors, but am running it on a pretty decent NUC i3 with 32 gigabytes of memory…
Since recently I am starting to experience issues (especially after updates). If I connect to the database with phpMyAdmin everything looks fine. I also tried the usual (restarting addons, restarting homeassistant, restarting host) but I have not yet found a solution to the problem (except rolling back a backup which solves it until the next upgrade).
Can anyone point me into the right direction to solving this issue?
The relevant log entries:
Supervisor:
2024-06-10 15:30:12.976 ERROR (MainThread) [supervisor.homeassistant.core] No Home Assistant Core response, assuming a fatal startup error
Homeassistant log:
2024-06-10 15:27:28.227 WARNING (MainThread) [homeassistant.setup] Setup of recorder is taking over 10 seconds.
2024-06-10 15:28:17.586 WARNING (MainThread) [homeassistant.bootstrap] Waiting on integrations to complete setup: {('recorder', None): 628.777099981}
2024-06-10 15:29:17.662 WARNING (MainThread) [homeassistant.bootstrap] Waiting on integrations to complete setup: {('recorder', None): 628.777099981}
2024-06-10 15:30:17.739 WARNING (MainThread) [homeassistant.bootstrap] Waiting on integrations to complete setup: {('recorder', None): 628.777099981}
2024-06-10 15:31:17.812 WARNING (MainThread) [homeassistant.bootstrap] Waiting on integrations to complete setup: {('recorder', None): 628.777099981}
2024-06-10 15:32:17.891 WARNING (MainThread) [homeassistant.bootstrap] Waiting on integrations to complete setup: {('recorder', None): 628.777099981}
2024-06-10 15:32:18.227 ERROR (MainThread) [homeassistant.setup] Setup of 'recorder' is taking longer than 300 seconds. Startup will proceed without waiting any longer
2024-06-10 15:32:19.589 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of 'history_stats'. Setup failed for dependencies: ['recorder']
2024-06-10 15:32:19.590 ERROR (MainThread) [homeassistant.setup] Unable to prepare setup for platform 'history_stats.sensor': Could not setup dependencies: recorder
2024-06-10 15:32:19.590 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of 'history_stats'. Setup failed for dependencies: ['recorder']
2024-06-10 15:32:19.590 ERROR (MainThread) [homeassistant.setup] Unable to prepare setup for platform 'history_stats.sensor': Could not setup dependencies: recorder
2024-06-10 15:32:19.590 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of 'history_stats'. Setup failed for dependencies: ['recorder']
2024-06-10 15:32:19.591 ERROR (MainThread) [homeassistant.setup] Unable to prepare setup for platform 'history_stats.sensor': Could not setup dependencies: recorder
2024-06-10 15:32:19.591 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of 'history_stats'. Setup failed for dependencies: ['recorder']
2024-06-10 15:32:19.591 ERROR (MainThread) [homeassistant.setup] Unable to prepare setup for platform 'history_stats.sensor': Could not setup dependencies: recorder
2024-06-10 15:32:19.591 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of 'history_stats'. Setup failed for dependencies: ['recorder']
2024-06-10 15:32:19.591 ERROR (MainThread) [homeassistant.setup] Unable to prepare setup for platform 'history_stats.sensor': Could not setup dependencies: recorder
MariaDB log:
[15:21:13] INFO: Ensuring internal database upgrades are performed
[15:21:13] INFO: Ensure databases exists
[15:21:13] INFO: Create database homeassistant
[15:21:13] INFO: Ensure users exists and are updated
[15:21:13] INFO: Update user homeassistant
[15:21:13] INFO: Init/Update rights
[15:21:13] INFO: Granting all privileges to homeassistant on homeassistant
[15:21:14] INFO: Sending service information to Home Assistant
s6-rc: info: service mariadb-post successfully started
s6-rc: info: service legacy-services: starting
s6-rc: info: service legacy-services successfully started