Cant reach my server (Immich_Postrgres constantly restarting) | Immich | Page 1

pallid thorn Nov 30, 2024, 8:22 AM

#

I have just upgraded my docker to 4.36.0 and my Immich to v1.121.0 by using docker compose pull && docker compose up -d and when I got to try access my immich server through the browser it says localhost didn’t send any data. When I looked into my containers I saw that immich_postgres is constantly restarting does anyone know why this is or could help out? Would be very much appreciated.

queen patioBOT Nov 30, 2024, 8:22 AM

#

:wave: Hey @pallid thorn,

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...

:ballot_box_with_check: verified I'm on the latest release(note that mobile app releases may take some time).
:ballot_box_with_check: read applicable release notes.
:ballot_box_with_check: reviewed the FAQs for known issues.
:ballot_box_with_check: reviewed Github for known issues.
:ballot_box_with_check: tried accessing Immich via local ip (without a custom reverse proxy).
:blue_square: uploaded the relevant information (see below).
:blue_square: 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.

pallid thorn Nov 30, 2024, 8:23 AM

#

📎 env 📎 docker-compose.yml

#

Sorry I had asked this question I was told to put quotes around something I cant remember what else I hadnt had time to try it and reply and it got closed

unborn oak Nov 30, 2024, 12:51 PM

#

What is the file system postgres is stored on?

meager agate Nov 30, 2024, 12:54 PM

#

other details about your system please

queen patioBOT Nov 30, 2024, 7:20 PM

#

We need more info on your system, please execute the following command (paste it into your terminal), and share the output of it afterwards:

( lsb_release -d && echo -n 'Kernel Version: ' && cat /proc/version && docker -v && docker compose version && echo -n 'Docker-Compose!! (deprecated): ' && docker-compose version && echo -n 'CPU ' && lscpu | grep 'Model name' | tr -s ' ' && lscpu | grep 'Architecture' | tr -s ' ' && cat /proc/meminfo | grep MemTotal | tr -s ' ' && hostnamectl )

versed depot Nov 30, 2024, 7:22 PM

#

@pallid thorn and provide the info schuhbacca asked for (what file system is the postgres db stored on and is it local or remote storage). also provide logs

queen patioBOT Nov 30, 2024, 7:22 PM

#

View container logs by running `docker compose logs`. For further information refer to https://immich.app/docs/guides/docker-help

pallid thorn Dec 1, 2024, 8:29 AM

#

📎 message.txt

#

Here are the docker compose logs

pallid thorn Dec 1, 2024, 8:32 AM

#

queen patio We need more info on your system, please execute the following command (paste it...

When I paste this into my CMD it just gives a bunch of syntax errors

pallid thorn Dec 1, 2024, 8:33 AM

#

unborn oak What is the file system postgres is stored on?

Uhhh I dont understand the question sorry. I used docker compose downloaded onto windows and followed the immich site instructions to download so I guess the default file system?

pallid thorn Dec 1, 2024, 8:34 AM

#

versed depot <@228474591171969024> and provide the info schuhbacca asked for (what file syste...

Postgres is stored in the immich-app folder inside of my user on my main disc inside of docker?

versed depot Dec 1, 2024, 7:10 PM

#

uh oh, just noticed you are running docker desktop on windows...
so postgres is running on an NTFS file system I assume, this usually causes problems.
I recommend to install docker engine on a linux system, not on windows to avoid unnecessary incompatibilities and issues

pallid thorn Dec 1, 2024, 11:13 PM

#

Is this really the issue it was running fine for months?

graceful blaze Dec 1, 2024, 11:29 PM

#

Hmm, can you try docker compose down then “docker compose up”?

pallid thorn Dec 1, 2024, 11:35 PM

#

I had tried docker compose down then docker compose up -d whats the difference? is it just that I see the logs in my terminal?

graceful blaze Dec 1, 2024, 11:35 PM

#

Yes

pallid thorn Dec 1, 2024, 11:36 PM

#

Yeah Postgres is just still restarting did you want me to send the logs for that?

graceful blaze Dec 1, 2024, 11:36 PM

#

Yes please

pallid thorn Dec 1, 2024, 11:37 PM

#

📎 message.txt

graceful blaze Dec 1, 2024, 11:40 PM

#

Your docker-compose file is out of date

#

can you put quote around that line in the volumes section

#

and for the port, change to 2283:2283?

pallid thorn Dec 1, 2024, 11:40 PM

#

Will do thanks for the help Ill let you know if it works

pallid thorn Dec 1, 2024, 11:49 PM

#

graceful blaze can you put quote around that line in the volumes section

I made the fix and postgres is still just restarting?

📎 docker-compose.yml

#

Unless I put the quotes in wrong or something

graceful blaze Dec 1, 2024, 11:51 PM

#

No you got it right

#

somethings seem to be wrong with the database

#

Do you have the backups folder at the UPLOAD_LOCATION?

#

For the last trial, can you copy the entire content of this docker-compose.yml file and replace yours with it? https://github.com/immich-app/immich/blob/main/docker/docker-compose.yml

pallid thorn Dec 2, 2024, 12:00 AM

#

is the upload location just the - "D:/Documents/Photos & Videos:/usr/src/app/photos"

graceful blaze Dec 2, 2024, 12:00 AM

#

here is the path to your UPLOAD_LOCATION

#

UPLOAD_LOCATION=D:\Immich\Backup-assets

#

Can you navigate there D:\Immich\Backup-assets and see if there are any folder called backups?

pallid thorn Dec 2, 2024, 12:02 AM

#

Yeah in the backup-assets folder there is a folder called backups D:\Immich\Backup-assets\backups

#

the only thing in it is a .immich file

pallid thorn Dec 2, 2024, 12:02 AM

#

graceful blaze For the last trial, can you copy the entire content of this docker-compose.yml f...

Should I do this now?

graceful blaze Dec 2, 2024, 12:08 AM

#

ah so you must have update from a version that didn't have that backup feature yet

graceful blaze Dec 2, 2024, 12:08 AM

#

pallid thorn Should I do this now?

yes

pallid thorn Dec 2, 2024, 12:09 AM

#

Done will I need to go in and edit it so that it still knows where my photos and stuff are or is it fine just to run it and see if it works?

graceful blaze Dec 2, 2024, 12:10 AM

#

you should just change the docker-compose file to the default one

#

not the .env file

#

Ah

#

hmm

pallid thorn Dec 2, 2024, 12:11 AM

#

Yeah so I copy and pasted the txt you sent me to replace my docker-compose.yml file but in my original one I had the - "D:/Documents/Photos & Videos:/usr/src/app/photos" so was just unsure if that will mess anything up

#

I copied the original file to my desktop first incase

graceful blaze Dec 2, 2024, 12:12 AM

#

Can you check your .env file and make sure there is no space here

#

You already have DB_DATA_LOCATION above so you can remove the line below

pallid thorn Dec 2, 2024, 12:13 AM

#

There was space behind all of them so what part am I removing?

#

I removed the spaces

graceful blaze Dec 2, 2024, 12:13 AM

#

Remove the space please

#

then run docker compose down and docker compose up again

#

can you post the content of your .env again. after editing them?

pallid thorn Dec 2, 2024, 12:14 AM

#

yup

#

📎 env 📎 docker-compose.yml

graceful blaze Dec 2, 2024, 12:15 AM

#

You can remove these two lines as well

#

#

Then run docker compose down and docker compose up

pallid thorn Dec 2, 2024, 12:18 AM

#

📎 message.txt

#

Still looks to be having an issue

graceful blaze Dec 2, 2024, 12:20 AM

#

So it is likely that the database has corrupted so it cannot start up

#

let's try starting with a new database by changing this line to DB_DATA_LOCATION=./postgres-test

pallid thorn Dec 2, 2024, 12:22 AM

#

as in paste that where I removed it before?

#

oh oops

#

nah I know what you mean

#

I assume once I have done that I just re do docker down then docker up

graceful blaze Dec 2, 2024, 12:25 AM

#

Yes

pallid thorn Dec 2, 2024, 12:26 AM

#

This means Ill need to reupload everything and re name every face and all of that again right? it looks like I can access the server now

graceful blaze Dec 2, 2024, 12:28 AM

#

Alright, so it means the previous database has corrupted somehow

#

Do you have any Linux system that you can run Immich on?

#

running Immich on Windows can be unreliable due to Docker on Windows is not the greatest

pallid thorn Dec 2, 2024, 12:29 AM

#

I dont have any computer running linux can I run it within the same computer or is that also unstable

graceful blaze Dec 2, 2024, 12:32 AM

#

I assume this is your main workstation?

pallid thorn Dec 2, 2024, 12:33 AM

#

Yeah

graceful blaze Dec 2, 2024, 12:34 AM

#

the location of the drive where you have your docker-compose.yml stored at, is it a local hard drive or network hard drive?

pallid thorn Dec 2, 2024, 12:35 AM

#

Its my local disk

#

I have immich and docker and everything installed on my main ssd that has windows and everything on it and then I have my location that my photos and videos are kept on my seperate m.2 storage because it is larger

graceful blaze Dec 2, 2024, 12:37 AM

#

okay, that is good

#

hmm maybe it is better to run docker in the wsl context

#

fwiw, starting the last two release, we now have automatic database dump to save you in situation like this

#

but sorry man, looks like you will have to start over

pallid thorn Dec 2, 2024, 12:38 AM

#

That is so completely fine

#

so now if this were to happen its saved somewhere?

#

what happens then I make a new database then what?

graceful blaze Dec 2, 2024, 12:41 AM

#

then you run the restore command

queen patioBOT Dec 2, 2024, 12:41 AM

#

https://immich.app/docs/administration/backup-and-restore

pallid thorn Dec 2, 2024, 12:41 AM

#

Gotcha so if same thing ends up happening I can just do that and I should be all good again

graceful blaze Dec 2, 2024, 12:41 AM

#

Correct

#

please look into running Immich in at least wsl context

#

all your files should still in the library folder

pallid thorn Dec 2, 2024, 12:44 AM

#

graceful blaze please look into running Immich in at least wsl context

I will have a look thanks for your help

pallid thorn Dec 2, 2024, 12:45 AM

#

graceful blaze all your files should still in the `library` folder

what does this do for me? Are you talking about now or if it were to be corrupted again

#

It is still however giving me this?

#

2024-12-02 11:27:37 [Nest] 19 - 12/02/2024, 12:27:37 AM LOG [Api:EventRepository] Websocket Connect: ZrgzunOoWjT1gfokAAAB
2024-12-02 11:24:21 [Nest] 7 - 12/02/2024, 12:24:21 AM ERROR [Microservices:TypeOrmModule] Unable to connect to the database. Retrying (1)...
2024-12-02 11:24:21 Error: connect ECONNREFUSED 172.18.0.4:5432
2024-12-02 11:24:21 at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1610:16)
2024-12-02 11:24:21 [Nest] 7 - 12/02/2024, 12:24:21 AM ERROR [Microservices:TypeOrmModule] Unable to connect to the database. Retrying (2)...
2024-12-02 11:24:21 Error: connect ECONNREFUSED 172.18.0.4:5432
2024-12-02 11:24:21 at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1610:16)
2024-12-02 11:24:21 [Nest] 7 - 12/02/2024, 12:24:21 AM ERROR [Microservices:TypeOrmModule] Unable to connect to the database. Retrying (3)...
2024-12-02 11:24:21 Error: connect ECONNREFUSED 172.18.0.4:5432

#

But regardless immich still seems to be working

#

maybe ill just fresh install on wsl

solar gulch Dec 2, 2024, 9:51 AM

#

Option 1: restore old DB
Run the DB-restore from the website and re-use your old upload folder
Option 2: full fresh install
Just install a fresh immich instance and use immich-cli or immich-go on your OLD UPLOAD_LOCATION/library folder, which will re-import the files there

#Cant reach my server (Immich_Postrgres constantly restarting)

References

Checklist

Information