SQL Dump Restore Problems
Hey, I started off with a weird problem with geo location data being messed up for the database so I decided to just do a restore from backup, but once I have done this I am getting a different but similar problem as before where it looks like theres something wrong with my postgres?
30 Replies
:wave: Hey @[μ] DH-Shuvi (shu!),
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:Heres a full dump of stuff
Running on Windows 10 Pro,
Docker Desktop: v28.1.1
Immich version: v1.132.3
This issue happens if I try to delete, upload or change any files
I can only manage to so far view my files.
Please read https://immich.app/docs/install/requirements/#special-requirements-for-windows-users
Likely your database is (slightly) corrupted
Best bet would be restoring to the volume from a backup
Added the change for db location.
Gonna try using a even older backup since last backup still had this issue
Be aware that images uploaded since the backup will not show, but you can locate them at the repair page https://my.immich.app/admin/repair
They would be "files not tracked by Immich"
I see, thanks alot for the info!
Side question from this one, I don't know if I should open another support ticket for it, but is there a way to get hardware transcoding working in WSL currently?
Using intel I7-7700k with IGPU HD graphics 630, and it would be nice to offload some of the video transcoding that happens to the igpu over all cpu.
I tried using quicksync and also vaapi in the past, but to no luck
WSL2 can support NVENC and VAAPI but not QSV
I see. Trying VAAPI, I get that there is no device mounted in the consol but I was sure that they were mounted .
Not sure if I have setup something wrong here
group add 226 was video/render I assume?
Yes
mmm wait
you have an iGPU
There's no additional GPU right?
no additional gpu currently in the server
Only Igpu
What does
/usr/lib/jellyfin-ffmpeg/vainfo from within the immich_server container say?
docker exec -it immich_server /bin/bash
and
ls -l /dev/dri (From container) ?
no such file or directory
ah interesting
Yeah, i've tried moving over to ubuntu in wsl to see if it resolves it but same problem with no such directory
Then that clashed with not being port forwarded for some reason so I stuck on back with docker again
https://github.com/microsoft/WSL/issues/12633
Does this match your versions perhaps?
little bit behind but I can try their solution
I will be honest, reading through I get the idea to find and load vgem, but damn I cant figure out what they are saying to get to that point
:KEKW:
alright might be getting somewhere now
Ok yeah, tried out such fix and still same issue with the directory not existing