Hello, my dears,
I changed the database backend to postgresql in Home Assistant. It seems an old problem is coming up again? I get the following error message.
2022-12-20 20:28:45.407 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (psycopg2.errors.NotNullViolation) FEHLER: NULL-Wert in Spalte »id« verletzt Not-Null-Constraint
This post tells about it:
#59117
What can I do?
Greetings from Stefan Harbich
My Home Assistant Version - 2022.12.6
There are other problems with the installation. Even the OpenWeather app cannot be activated. Fails with the following error message.
2022-12-20 23:59:19.302 WARNING (MainThread) [homeassistant.setup] Setup of recorder is taking over 10 seconds.
2022-12-21 00:00:08.366 WARNING (MainThread) [homeassistant.bootstrap] Waiting on integrations to complete setup: recorder
2022-12-21 00:00:53.162 ERROR (MainThread) [homeassistant.config_entries] Error occurred loading configuration flow for integration openweathermap: No module named '_bz2'
2022-12-21 00:01:06.135 ERROR (MainThread) [homeassistant.config_entries] Error occurred loading configuration flow for integration openweathermap: No module named '_bz2'
2022-12-21 00:01:08.902 WARNING (MainThread) [homeassistant.bootstrap] Waiting on integrations to complete setup: recorder
2022-12-21 00:02:08.994 WARNING (MainThread) [homeassistant.bootstrap] Waiting on integrations to complete setup: recorder
2022-12-21 00:03:09.087 WARNING (MainThread) [homeassistant.bootstrap] Waiting on integrations to complete setup: recorder
2022-12-21 00:04:09.172 WARNING (MainThread) [homeassistant.bootstrap] Waiting on integrations to complete setup: recorder
2022-12-21 00:04:09.303 ERROR (MainThread) [homeassistant.setup] Setup of recorder is taking longer than 300 seconds. Startup will proceed without waiting any longer
2022-12-21 00:04:11.291 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of logbook. Setup failed for dependencies: recorder
2022-12-21 00:04:11.291 ERROR (MainThread) [homeassistant.setup] Setup failed for logbook: (DependencyError(...), 'Could not setup dependencies: recorder')
2022-12-21 00:04:11.295 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of history. Setup failed for dependencies: recorder
2022-12-21 00:04:11.296 ERROR (MainThread) [homeassistant.setup] Setup failed for history: (DependencyError(...), 'Could not setup dependencies: recorder')
2022-12-21 00:04:11.411 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of energy. Setup failed for dependencies: history, recorder
2022-12-21 00:04:11.411 ERROR (MainThread) [homeassistant.setup] Setup failed for energy: (DependencyError(...), 'Could not setup dependencies: history, recorder')
2022-12-21 00:04:11.820 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of default_config. Setup failed for dependencies: energy, history, logbook
2022-12-21 00:04:11.821 ERROR (MainThread) [homeassistant.setup] Setup failed for default_config: (DependencyError(...), 'Could not setup dependencies: energy, history, logbook')
I’m about to switch the whole Projet Home Assistant to OpenHab.
A lot of problems in Home Assistant.