Pb installation frigate

Bonjour,

J’ai des pbs au démarrage de frigate.
le processus ne va au bout car, je pense, que ma database est verrouillée
voir ci dessous.

Avez vous des idées?.. merci et bonne année 2024


s6-rc: info: service s6rc-fdholder: starting
s6-rc: info: service s6rc-oneshot-runner: starting
s6-rc: info: service s6rc-oneshot-runner successfully started
s6-rc: info: service fix-attrs: starting
s6-rc: info: service s6rc-fdholder successfully started
s6-rc: info: service fix-attrs successfully started
s6-rc: info: service legacy-cont-init: starting
s6-rc: info: service legacy-cont-init successfully started
s6-rc: info: service log-prepare: starting
s6-rc: info: service log-prepare successfully started
s6-rc: info: service nginx-log: starting
s6-rc: info: service go2rtc-log: starting
s6-rc: info: service frigate-log: starting
s6-rc: info: service nginx-log successfully started
s6-rc: info: service go2rtc-log successfully started
s6-rc: info: service go2rtc: starting
s6-rc: info: service frigate-log successfully started
s6-rc: info: service go2rtc successfully started
s6-rc: info: service go2rtc-healthcheck: starting
s6-rc: info: service frigate: starting
s6-rc: info: service go2rtc-healthcheck successfully started
s6-rc: info: service frigate successfully started
s6-rc: info: service nginx: starting
2024-01-02 10:51:11.578267491 [INFO] Preparing go2rtc config…
2024-01-02 10:51:11.582623520 [INFO] Starting Frigate…
s6-rc: info: service nginx successfully started
s6-rc: info: service legacy-services: starting
2024-01-02 10:51:11.618351815 [INFO] Starting NGINX…
s6-rc: info: service legacy-services successfully started
2024-01-02 10:51:11.755956218 [INFO] Got IP address from supervisor: 192.168.0.50
2024-01-02 10:51:11.925187051 [INFO] Got WebRTC port from supervisor: 8555
2024-01-02 10:51:12.690911017 [INFO] Starting go2rtc…
2024-01-02 10:51:12.894349661 11:51:12.894 INF go2rtc version 1.2.0 linux/arm64
2024-01-02 10:51:12.896390270 11:51:12.896 INF [api] listen addr=:1984
2024-01-02 10:51:12.898375360 11:51:12.898 INF [rtsp] listen addr=:8554
2024-01-02 10:51:12.900276600 11:51:12.900 INF [srtp] listen addr=:8443
2024-01-02 10:51:12.902073896 11:51:12.901 INF [webrtc] listen addr=:8555
2024-01-02 10:51:15.945828119 [2024-01-02 11:51:15] frigate.app INFO : Starting Frigate (0.12.1-367d724)
2024-01-02 10:51:15.987778757 [2024-01-02 11:51:15] frigate.app INFO : Creating directory: /tmp/cache
2024-01-02 10:51:15.996335409 [2024-01-02 11:51:15] peewee_migrate INFO : Starting migrations
2024-01-02 10:51:21.574103736 [INFO] Starting go2rtc healthcheck service…
2024-01-02 10:51:23.276038169 database is locked
2024-01-02 10:51:24.602321577 [INFO] Service Frigate exited with code 1 (by signal 0)
s6-rc: info: service legacy-services: stopping
s6-rc: info: service legacy-services successfully stopped
s6-rc: info: service nginx: stopping
s6-rc: info: service go2rtc-healthcheck: stopping
2024-01-02 10:51:24.652798424 [INFO] The go2rtc-healthcheck service exited with code 256 (by signal 15)
s6-rc: info: service go2rtc-healthcheck successfully stopped
2024-01-02 10:51:24.739120695 [INFO] Service NGINX exited with code 0 (by signal 0)
s6-rc: info: service nginx successfully stopped
s6-rc: info: service nginx-log: stopping
s6-rc: info: service frigate: stopping
s6-rc: info: service frigate successfully stopped
s6-rc: info: service go2rtc: stopping
s6-rc: info: service frigate-log: stopping
2024-01-02 10:51:24.754549091 exit OK
s6-rc: info: service nginx-log successfully stopped
s6-rc: info: service frigate-log successfully stopped
2024-01-02 10:51:24.773144379 [INFO] The go2rtc service exited with code 0 (by signal 0)
s6-rc: info: service go2rtc successfully stopped
s6-rc: info: service go2rtc-log: stopping
s6-rc: info: service go2rtc-log successfully stopped
s6-rc: info: service log-prepare: stopping
s6-rc: info: service s6rc-fdholder: stopping
s6-rc: info: service log-prepare successfully stopped
s6-rc: info: service legacy-cont-init: stopping
s6-rc: info: service s6rc-fdholder successfully stopped
s6-rc: info: service legacy-cont-init successfully stopped
s6-rc: info: service fix-attrs: stopping
s6-rc: info: service fix-attrs successfully stopped
s6-rc: info: service s6rc-oneshot-runner: stopping
s6-rc: info: service s6rc-oneshot-runner successfully stopped

Ma configuration


System Information

version core-2023.12.4
installation_type Home Assistant OS
dev false
hassio true
docker true
user root
virtualenv false
python_version 3.11.6
os_name Linux
os_version 6.1.58-haos-raspi
arch aarch64
timezone Europe/Paris
config_dir /config
Home Assistant Community Store
GitHub API ok
GitHub Content ok
GitHub Web ok
GitHub API Calls Remaining 4974
Installed Version 1.33.0
Stage running
Available Repositories 1441
Downloaded Repositories 19
HACS Data ok
Home Assistant Cloud
logged_in false
can_reach_cert_server ok
can_reach_cloud_auth ok
can_reach_cloud ok
Home Assistant Supervisor
host_os Home Assistant OS 11.2
update_channel stable
supervisor_version supervisor-2023.12.0
agent_version 1.6.0
docker_version 24.0.7
disk_total 146.0 GB
disk_used 8.1 GB
healthy true
supported true
board rpi4-64
supervisor_api ok
version_api ok
installed_addons File editor (5.7.0), Terminal & SSH (9.8.1), Samba share (12.2.0), Hikvision Doorbell (2.1), Network UPS Tools (0.12.2), Mosquitto broker (6.4.0), Frigate (0.12.1)
Dashboards
dashboards 2
resources 16
views 10
mode storage
Recorder
oldest_recorder_run 23 décembre 2023 à 21:20
current_recorder_run 2 janvier 2024 à 11:48
estimated_db_size 225.31 MiB
database_engine sqlite
database_version 3.41.2

t’as fait une install de base ? la vu les quelques recherches avec « frigate database is locked » sur google, on dirait que t’essaye de mettre ta bdd ailleurs que son emplacement par defaut.
Perso, j’ai suivi ce tuto

Merci pour le retour.
J’ai suivi le même tuto par contre j’avais mis une sauvegarde réseau sur les médias avant de configurer frigate. je l’ai supprimé et je n’ai plus le pb de database. un bon point !!

Par contre, mon module complémentaire ne démarre pas malgré un journal clean (pourtant le journal s’arrête au même niveau que makernix) . Du coup je ne peux pas lance frigate dans HA (il me dit que le module n’est pas lancé)…

Merci pour le support.

Bonjour et meilleurs voeux à tous,
J’ai exactement le même problème.
Tout a fonctionné en suivant ce très bon tuto.
J’avais cependant été amené à modifier le port 8555 pour passer au 8550 - mais tout a fonctionné.
Les choses se sont envenimées lorsque j’ai créé une sauvegarde sur un disque de ma Freebox.
Depuis, et malgré avoir supprimé tous les stockages externes, j’ai cette database locked
J’ai désinstallé Frigate, refais une réinitinalisation, rien n’y fait.
Voici mon log si vous voyez une piste :wink:

« s6-rc: info: service s6rc-fdholder: starting
s6-rc: info: service s6rc-oneshot-runner: starting
s6-rc: info: service s6rc-oneshot-runner successfully started
s6-rc: info: service fix-attrs: starting
s6-rc: info: service s6rc-fdholder successfully started
s6-rc: info: service fix-attrs successfully started
s6-rc: info: service legacy-cont-init: starting
s6-rc: info: service legacy-cont-init successfully started
s6-rc: info: service log-prepare: starting
s6-rc: info: service log-prepare successfully started
s6-rc: info: service nginx-log: starting
s6-rc: info: service go2rtc-log: starting
s6-rc: info: service frigate-log: starting
s6-rc: info: service nginx-log successfully started
s6-rc: info: service go2rtc-log successfully started
s6-rc: info: service go2rtc: starting
s6-rc: info: service frigate-log successfully started
s6-rc: info: service go2rtc successfully started
s6-rc: info: service go2rtc-healthcheck: starting
s6-rc: info: service frigate: starting
2024-01-03 11:24:09.422221018 [INFO] Preparing go2rtc config…
s6-rc: info: service go2rtc-healthcheck successfully started
s6-rc: info: service frigate successfully started
s6-rc: info: service nginx: starting
2024-01-03 11:24:09.459173710 [INFO] Starting Frigate…
s6-rc: info: service nginx successfully started
s6-rc: info: service legacy-services: starting
2024-01-03 11:24:09.519159488 [INFO] Starting NGINX…
s6-rc: info: service legacy-services successfully started
2024-01-03 11:24:09.761276302 [INFO] Got IP address from supervisor: 192.168.0.57
2024-01-03 11:24:09.880970296 [INFO] Got WebRTC port from supervisor: 8550
2024-01-03 11:24:10.536030097 [INFO] Starting go2rtc…
2024-01-03 11:24:10.690842567 12:24:10.690 INF go2rtc version 1.2.0 linux/arm64
2024-01-03 11:24:10.691577773 12:24:10.691 INF [api] listen addr=:1984
2024-01-03 11:24:10.692146498 12:24:10.692 INF [rtsp] listen addr=:8554
2024-01-03 11:24:10.692685863 12:24:10.692 INF [srtp] listen addr=:8443
2024-01-03 11:24:10.693358789 12:24:10.693 INF [webrtc] listen addr=:8555
2024-01-03 11:24:13.529556050 [2024-01-03 12:24:13] frigate.app INFO : Starting Frigate (0.12.1-367d724)
2024-01-03 11:24:13.582793848 [2024-01-03 12:24:13] frigate.app INFO : Creating directory: /tmp/cache
2024-01-03 11:24:13.591096763 [2024-01-03 12:24:13] peewee_migrate INFO : Starting migrations
2024-01-03 11:24:18.603080476 database is locked
2024-01-03 11:24:19.446226485 [INFO] Starting go2rtc healthcheck service…
2024-01-03 11:24:20.075896698 [INFO] Service Frigate exited with code 1 (by signal 0)
s6-rc: info: service legacy-services: stopping
s6-rc: info: service legacy-services successfully stopped
s6-rc: info: service nginx: stopping
s6-rc: info: service go2rtc-healthcheck: stopping
2024-01-03 11:24:20.104446234 [INFO] The go2rtc-healthcheck service exited with code 256 (by signal 15)
s6-rc: info: service go2rtc-healthcheck successfully stopped
2024-01-03 11:24:20.139943433 [INFO] Service NGINX exited with code 0 (by signal 0)
s6-rc: info: service nginx successfully stopped
s6-rc: info: service nginx-log: stopping
s6-rc: info: service frigate: stopping
s6-rc: info: service frigate successfully stopped
s6-rc: info: service go2rtc: stopping
s6-rc: info: service frigate-log: stopping
s6-rc: info: service nginx-log successfully stopped
2024-01-03 11:24:20.154878807 exit OK
s6-rc: info: service frigate-log successfully stopped
2024-01-03 11:24:20.166926995 [INFO] The go2rtc service exited with code 0 (by signal 0)
s6-rc: info: service go2rtc successfully stopped
s6-rc: info: service go2rtc-log: stopping
s6-rc: info: service go2rtc-log successfully stopped
s6-rc: info: service log-prepare: stopping
s6-rc: info: service s6rc-fdholder: stopping
s6-rc: info: service log-prepare successfully stopped
s6-rc: info: service legacy-cont-init: stopping
s6-rc: info: service s6rc-fdholder successfully stopped
s6-rc: info: service legacy-cont-init successfully stopped
s6-rc: info: service fix-attrs: stopping
s6-rc: info: service fix-attrs successfully stopped
s6-rc: info: service s6rc-oneshot-runner: stopping
s6-rc: info: service s6rc-oneshot-runner successfully stopped »

Bonsoir,

@Raph26
Pour ma part, j’ai supprimer mon disque réseau (freebox aussi). et réinstallé Frigate. J’ai plus le msg database is locked mais ca ne démarrage pas mieux. voir ci dessus.

Comme j’en ai marre de chercher, je vais partir sur une installe propre ce weekend et je verai ce que ca donne. Au pire si ca plante tjrs, je ferai un restore de mon backup.

Bon courage et bonne soirée

Bonjour,
J’ai créé une issue sur le Github Frigateet j’ai reçu plusieurs réponses intéressantes:

Hello, ça ne pourrait pas être un problème de droit sur le fichier frigate.db dans le répertoire des données frigate ?
Peut-être que lorsque tu as monté la sauvegarde, les droits sur ce fichier ont été modifiés ?

Pour ma part, je fonctionne plutôt avec un container docker externe à homeassistant. Plus facile à maintenir et permet l’utilisation d’un google coral.

Bonsoir et bonne année à tous,
Merci pour ton concours MattG
Effectivement, j’ai modifier les droits en écriture pour le fichier database.
A présent Frigate démarre sans craché mais il n’affiche rien d’autre qu’un cercle qui tourne en permanence. En effet, le journal indique qu’il y a recherche des infos suivantes:
‹ connecting to upstream, client: 172.30.32.2, server: , request: « GET /api/config HTTP/1.1 », upstream: ›
‹ « http://127.0.0.1:5001/config », host: « X.X.X.X:Y », referrer: ›
‹ … ›
XXXX:Y est l’adresse IP locale avec le port de home assistant chez moi.
Si vous avez une idée pour vancer, je vous en serais reconnaissant (logique)
Cordialement

Salut !

De rien :slight_smile:

Tu n’as pas d’autres infos/erreurs dans les logs ?

Peux-tu t’assurer que les droits sont aussi appliqués sur le fichier config.yml ?
En fait, il faudrait t’assurer que frigate ait accès à tout son répertoire. Pas seulement la database.