'ERROR [TypeOrmModule] Unable to connect to the database. Error [ExceptionHandler]'
Hi Everybody. Had my server running immich doing just fine the other day. Took a power hit and the server went down. After starting back up, now getting this error message. Running Windows 10 on an intel cpu through Docker. Server was needing an update before the outage, so tried that first using docker-compose pull, down, then up -d. Did not solve the issue.
Saw a discussion where someone suggested deleting all of the relevant images and containers for immich in docker, then getting all new .env and .yml files and comparing line by line from old to new. That did not work either, same error logs. I believe I attached the error logs. Not entirely sure how to format things properly within discord.
Any help is appreciated!
8 Replies
:wave: Hey @Armyguy325,
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_01GY0DAKGXDEHE263BCAYEGFJAChecklist
I have...
1. :blue_square: verified I'm on the latest release(note that mobile app releases may take some time).
2. :blue_square: read applicable release notes.
3. :blue_square: reviewed the FAQs for known issues.
4. :blue_square: reviewed Github for known issues.
5. :blue_square: tried accessing Immich via local ip (without a custom reverse proxy).
6. :blue_square: uploaded the relevant information (see below).
7. :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.GitHub
immich-app immich · Discussions
Explore the GitHub Discussions forum for immich-app immich. Discuss code, ask questions & collaborate with the developer community.
FAQ | Immich
User
GitHub
Issues · immich-app/immich
High performance self-hosted photo and video management solution. - Issues · immich-app/immich
my .env file
``
# You can find documentation for all the supported env variables at https://immich.app/docs/install/environment-variables
# The location where your uploaded files are stored
UPLOAD_LOCATION=D:/Immich/library
# The location where your database files are stored
DB_DATA_LOCATION=D:/Immich/postgres
# To set a timezone, uncomment the next line and change Etc/UTC to a TZ identifier from this list: https://en.wikipedia.org/wiki/List_of_tz_database_time_zones#List
# TZ=US/Eastern
# The Immich version to use. You can pin this to a specific version like "v1.71.0"
IMMICH_VERSION=release
# Connection secret for postgres. You should change it to a random password
# Please use only the characters A-Za-z0-9`, without special characters or spaces
DB_PASSWORD=**
The values below this line do not need to be changed
###################################################################################
DB_USERNAME=postgres
DB_DATABASE_NAME=immich
...my .yml file
Is your database on an NTFS partition?
If yes, then it's probably broken as heck.
Best bet is to add a pgdata volume instead of DB_DATA_LOCATION (see https://immich.app/docs/install/requirements#special-requirements-for-windows-users ) and use the backup-restore guide to restore the last automated DB dump
Ive seen that reply on other similar issue posts. If that were the case, then why would it have worked just fine for a few months prior? Not to say that couldn’t be the cause, but that would be odd for it to just stop working suddenly
I would guess it probably wasn't
At least not how you expect
like, maybe things ended up on the docker VM's internal disk or such, idk
Docker on windows has weird issues around disk mounts
And yet there is one common denominator for these very random "suddenly stops working after being fine for x period".
We even recommend it in the documentation to not put it on NTFS, precisely for this reason.
If you can figure out the exact cause please do tell us so we can document something other than "AVOID THIS", but for now this is the best we have.