Bonjour,
j’ai effectué la mise à jour de HomeAssistant vers la version 2022.8.6 (Supervisor 2022.8.3) depuis quelques jours et mon installation n’arrête pas de redemarrer ( Connexion perdue → rechargement de tous les modules) toutes les 2mns environs. Je viens d’essayer d’effectuer une restauration de ma dernière configuration mais impossible… reboot entre temps.
Je viens de voir dans les logs l’erreur suivante :
Logger: homeassistant.components.recorder.util
Source: components/recorder/util.py:95
Integration: Recorder (documentation, issues)
First occurred: 11:23:26 (1 occurrences)
Last logged: 11:23:26
Error executing query: (sqlite3.IntegrityError) UNIQUE constraint failed: statistics.metadata_id, statistics.start [SQL: CREATE UNIQUE INDEX ix_statistics_statistic_id_start ON statistics (metadata_id, start)] (Background on this error at: https://sqlalche.me/e/14/gkpj)
mes problèmes peuvent ils venir de la ?
Ma configuration
System Information
version | core-2022.8.7
-- | --
installation_type | Home Assistant Supervised
dev | false
hassio | true
docker | true
user | root
virtualenv | false
python_version | 3.10.5
os_name | Linux
os_version | 5.10.11-v7+
arch | armv7l
timezone | Europe/Paris
config_dir | /config
<details><summary>Home Assistant Cloud</summary>
logged_in | false
-- | --
can_reach_cert_server | ok
can_reach_cloud_auth | ok
can_reach_cloud | failed to load: timeout
</details>
<details><summary>Home Assistant Supervisor</summary>
host_os | Raspbian GNU/Linux 10 (buster)
-- | --
update_channel | stable
supervisor_version | supervisor-2022.08.3
agent_version | null
docker_version | 20.10.3
disk_total | 72.6 GB
disk_used | 9.4 GB
healthy | true
supported | failed to load: Unsupported
supervisor_api | ok
version_api | ok
installed_addons | File editor (5.3.0), Mosquitto broker (5.1.1), Terminal & SSH (9.0.1), Node-RED (8.1.2), RPC Shutdown (2.2), Samba Backup (4.4), Samba share (9.3.0), deCONZ (6.15.0), tydom2mqtt (2.2.0)
</details>
<details><summary>Dashboards</summary>
dashboards | 1
-- | --
resources | 0
views | 1
mode | storage
</details>
<details><summary>Recorder</summary>
error | failed to load: unknown
-- | --
</details>
___
Merci pour votre aide.