Immich not loading anymore after CLIP change
Hello, thanks for reading and trying to help. It's really important for me to fix this issue as soon as possible to get my immich running properly again to view my photos.
WHAT I WANTED TO DO:
- change smart search clip model to ViT-H-14-378-quickgeludfn5b
- rerun scan for smart search: i clicked on run and it said active 3 and pending 16k. i searched for photos meanwhile it was scanning, but then it was stuck on active 3 so i tried to stop it. didn't work. then I restarted the immich container.
after that following occured when i tried to access my immich webapp: Failed to fetch () Stacktrace.... blablabla (see screenshot)
Then i restarted my ubuntu system, but didn't fix anything
PROBLEM NOW
Immich doesn't load not at all anymore. Browser says: ERR_CONNECTION_REFUSED
If I enter docker logs 5af820055625 --tail=50 --follow into my ubuntu command terminal, following comes:
```[Microservices:SmartInfoService] Dimension size of model ViT-H-14-378-quickgeludfn5b is 1024, but database expects 640.
[Microservices:SmartInfoService] Updating database CLIP dimension size to 1024.``` and some longer error code saying "query failed PostgresError: relation "clip_index" does not exist" and "PostgresError: relation "clip_index" does not exist". For detailed error log, just ask.
Thanks for taking time to trying to fix my issue!
37 Replies
:wave: Hey @Temal,
Thanks for reaching out to us. Please carefully read this message and follow the recommended actions. This will help us be more effective in our support effort and leave more time for building Immich :immich:.
References
- Container Logs:
docker compose logs docs
- Container Status: docker ps -a docs
- Reverse Proxy: https://immich.app/docs/administration/reverse-proxy
- Code Formatting https://support.discord.com/hc/en-us/articles/210298617-Markdown-Text-101-Chat-Formatting-Bold-Italic-Underline#h_01GY0DAKGXDEHE263BCAYEGFJA
Checklist
I have...
1. :ballot_box_with_check: verified I'm on the latest release(note that mobile app releases may take some time).
2. :ballot_box_with_check: read applicable release notes.
3. :ballot_box_with_check: reviewed the FAQs for known issues.
4. :ballot_box_with_check: reviewed Github for known issues.
5. :ballot_box_with_check: tried accessing Immich via local ip (without a custom reverse proxy).
6. :ballot_box_with_check: uploaded the relevant information (see below).
7. :ballot_box_with_check: tried an incognito window, disabled extensions, cleared mobile app cache, logged out and back in, different browsers, etc. as applicable
(an item can be marked as "complete" by reacting with the appropriate number)
Information
In order to be able to effectively help you, we need you to provide clear information to show what the problem is. The exact details needed vary per case, but here is a list of things to consider:
- Your docker-compose.yml and .env files.
- Logs from all the containers and their status (see above).
- All the troubleshooting steps you've tried so far.
- Any recent changes you've made to Immich or your system.
- Details about your system (both software/OS and hardware).
- Details about your storage (filesystems, type of disks, output of commands like fdisk -l and df -h).
- The version of the Immich server, mobile app, and other relevant pieces.
- Any other information that you think might be relevant.
Please paste files and logs with proper code formatting, and especially avoid blurry screenshots.
Without the right information we can't work out what the problem is. Help us help you ;)
If this ticket can be closed you can use the /close command, and re-open it later if needed.
Successfully submitted, a tag has been added to inform contributors. :white_check_mark:Sounds like your DB is borked and you just need to restore
restore from a db backup?
the newest sql file right?
yes
ok i’ll try
i've done the things on https://immich.app/docs/administration/backup-and-restore but the error is still there
No you've copy pasted all of the instructions without reading or understanding
You're supposed to execute the commands, and especially the "delete the database location" is crucial for a good restore
oops sorry
but as i said in #immich
how can i see or view my db data location?
It's in your .env file
ok ill check it thx
probably ~/immich-app/postgres
DB_DATA_LOCATION=./postgres
yep
either delete that or just
mv ~/immich-app/postgres ~/immich-app/postgres_old/home/temal/immich-app/postgres
You also need to fill in the command, username is
postgres if you've left it default
not <DB_USERNAME>ah
good?
You are again pasting it all in one block, one command at a time please
fine boss
also for windows putting it on one line might be best:
cat < "imich-db-backup-1739235600022. sql. gz" | sed "s/SELECT pg_catalog.set_config('search_path', '', false);/SELECT pg_catalog.set_config('search_path', 'public, pg_catalog', true);/g" | psql --dbname=postgres --username=postgres1. docker compose down -v # CAUTION! Deletes all Immich data to start from scratch
2. rm -rf /home/temal/immich-app/postgres
3. docker compose pull
4. docker compose create
5. docker start immich_postgres
6. sleep 5
7. cat < "imich-db-backup-1739235600022.sql. gz" | sed "s/SELECT pg_catalog.set_config('search_path', '', false);/SELECT pg_catalog.set_config('search_path', 'public, pg_catalog', true);/g" | psql --dbname=postgres --username=postgres
8. docker compose up -d
good?
yes
command 7
problem
ah
space between sql and gz
but psql also not found
should i do apt install postgresql-client-common?
and retry
Missed one crucial step
Mounting the restore to the postgres container
You should be reading the windows restore instructions on windows 👀
wait
you thought i use immich on my windows machine?
But you're in WSL 🤔
nahhh
bro
not wsl
ssh into ubuntu server
i just tried the normal command with gzip blablabla and it worked fine
now immich is working again!!
😄
yay
oops
write ur ms
g
ok then not
bbye
thankx
This thread has been closed. To re-open, use the button below.