Cant Connect to Database after Update
Hi Guys im using Portainer with docker i updated my OMV system and now i immich cant connect with the immich_postgres database server?!
Error Log on immich_server:
https://prnt.sc/r8zJb_4C3pr9
https://prnt.sc/Y6p45IkC2P7r
immich_postgres:
https://prnt.sc/SDNSOUQ2SEPY
https://prnt.sc/PslEN1TPcUCg
17 Replies
:wave: Hey @Anubis,
Thanks for reaching out to us. Please follow the recommended actions below; 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 compose ps docs
- Reverse Proxy: https://immich.app/docs/administration/reverse-proxy
Checklist
1. :ballot_box_with_check: I have verified I'm on the latest release(note that mobile app releases may take some time).
2. :ballot_box_with_check: I have read applicable release notes.
3. :ballot_box_with_check: I have reviewed the FAQs for known issues.
4. :ballot_box_with_check: I have reviewed Github for known issues.
5. :ballot_box_with_check: I have tried accessing Immich via local ip (without a custom reverse proxy).
6. :ballot_box_with_check: I have uploaded the relevant logs, docker compose, and .env files using the buttons below or the /upload command.
7. :ballot_box_with_check: I have 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)
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:Looks like wherever postgres is, is out of space according to the logs
ok now i have space left... error still the same on immich_Server
What do the postgres logs say now?
Looks better. Did you attempt to bring the entire stack down and back up?
still the same error
Can you try logging into sql using the credentials specified in your env file?
Assuming the server log still says attempting to connect?
yea but im little nooby ... what are the commands to login into sql ?
yea
immi server
Go into the postgres container and try typing in
psql immich <DB_USERNAME> (DB username from env file)Okay so can connect. Did you change your password at all for the DB?
Also what is an OMS system?
i didnt change anything
sry i mean OMV (open media vault)not OMS
i recreated the container now it works
This thread has been closed. To re-open, use the button below.
please make a new ticket, you have replied to a nearly year old message