Lews
IImmich
•Created by Lews on 1/13/2025 in #help-desk-support
Problems regarding smart_search, face_asset, person
Hello, I faced some weird errors lately (Attached)
this kind of error is spammed over and over, slowing down the system during the startup
I have truncated smart_search, face_assets, person and this error disappeared so the server started in a few seconds, then I ran the jobs again so that I would get a clean database.
However, this didn't happen and the errors happen to show up again, slowing the startup very badly. How can I deal with this error? Is it due to a recent update fail?
Thank you
18 replies
IImmich
•Created by Lews on 1/3/2025 in #help-desk-support
I am not being able to restore a backup
Hello.
I had to backup my previous database as my hard disk failed, so i dumped it into "backup.sql"
and copied the library folder as well.
The problem occurs right now as I have to restore It, I have been trying everything but still can't stort this out.
I haven't modified anything (.env and docker-compose.yml) they're brand new from github.
These are the commands i'm executing on Windows (I have Immich on D: )
docker compose down -v docker compose pull docker compose create docker start immich_postgresThen i copy the backup file to immich_postgress
docker cp backup.sql immich_postgres:/tmp/backup.sqlI get into it
docker exec -it immich_postgres bash cat "backup.sql" \ | sed "s/SELECT pg_catalog.set_config('search_path', '', false);/SELECT pg_catalog.set_config('search_path', 'public, pg_catalog', true);/g" \ | psql --username=postgresEverything looks fine so far, It starts to copy rows, alter tables, create others etc... Eventually, these errors show up (I attached the whole log) I tried everything I could, but there's no way to get those foreign key errors out of the way. I seriously hope you can help me, I've been using Immich for a month and It has been amazing, I would lose 150gb of media.. Thank you
7 replies