Database on external server issue
Hi there! 🙂
I am on Proxmox, created a specific VM for Immich and linked an external server for my photos. Everything's fine. I can access the GUI and map the external folder into the GUI. I can as well access, from inside the container, my paths /mnt/immich/data and /mnt/Photos
What I am trying to achieve it to move/create (as I havent started the jobs) all the Database to the same external server in which I have my Photos.
But as soon as I map the location into .env file and do a docker compose up, I cannot access the GUI anymore and have error in my logs
Here are some files. What am I missing here?
Thank you in advance for the support 🙂
29 Replies
:wave: Hey @zigjack,
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.I'm not sure what you're trying exactly, but the database folder cannot be stored on a network mount
Thanks sir. But indeed; this is exactly what I am trying to do.
I do believe this is possible as I dit it the first time I tried Immich, but deleted everything in the meantime for other reasons and cant figure out how I did... 😅
Even if you get it to work, it's heavily discouraged and you'd probably run into database corruption eventually
Oh ok. The issue I am facing when my batabase is at the same place, into my VM, the database is taking 100GB++ and cannot finish the jobs as I am running out of space (I am very limited in space on my Proxmox... whereas I have plenty of space on my external server)
No other options or idea then?
The database is taking 100GB+???
How many assets do you have?
Around 140k photos and videos for 1.4To. Do you think there is an issue?
And where are you seeing that the database is that large?
In the bottom left of the GUI, before the jobs I had 11 GB out of 110GB used, after some hours of jobs running it is stating almost full with a red bar and crashing... I assume that was the database indeed, but what else could it be?
It sounds like your remote mount isn't mounting rll folders and it's storing thumbs and transcodes locally
I'd check the mapped folders, can you check the size of each?
That's not the database, it's the UPLOAD_LOCATION folder
Which is mounted locally at
./libraryI am mounting that way, not sure if this is the right thing to do, but this is working well for the photos...
I dont have it anymore to check, I have restarted from scratch 😕
I dont get. What is uploading? There is nothing to upload, all my pictures are stored on the external server?
Thumbnails are
Transcodes
That's easily 10% of your library in size
When you start again, take a peek
Generated files are stored in there
Ok, thanks. Then my questions turns into "how can I store those generated files into my external server?"
With a network mount :P
Just tried that, still same issue:
The database should still be on a local disk
How then can I split and keep the DB locally and put the generated files on the server? I don't see where I can do that?
The db and the generated files are completely separate things
In the .env file I've done that, but still the issue...
This should work
Did you
up the stack after?
What errors are you getting now?Yes I up it. The logs:
I dont get which folder it is talking about... I havent touched that
Right, this is a different error
It's talking about the generated video files
You need to either move the existing files over, or delete the database to start completely from scratch
Looks like that was the right way! 🥳
Scan has started and now I have my plenty of space I needed
Thank you very much for your quick support and kindness, much appreciated ♥️