Unable to Log In After Updating to v2.2.0
Good morning! This morning I updated from v2.1.0 to 2.2.0 and was unhappily surprised to find I can no longer log in to Immich in the browser; additionally, it does not appear that the Android app is connecting to the server. Pulling up the log shows a repeated error showing the following
[Nest] 23 - 10/31/2025, 2:30:17 PM ERROR [Api:GlobalExceptionFilter~qxtsck6c] Unknown error: PostgresError: column session.appVersion does not exist
PostgresError: column session.appVersion does not exist
at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26)
at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6)
at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9)
at Socket.emit (node:events:518:28)
at addChunk (node:internal/streams/readable:561:12)
at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
at Readable.push (node:internal/streams/readable:392:5)
at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
at TCP.callbackTrampoline (node:internal/async_hooks:130:17)
I tried to move back to v2.1.0 by designating that as the version in my .env file; I have restarted my NAS as well. I made sure my docker-compose file is the latest.
My NAS is a QNAP TS-251D running Unraid. Everything else on my NAS seems to be working fine. I'm assuming there's some problem with the postgres database but unfortunately I know basically nothing about databases.
Thank you!35 Replies
:wave: Hey @mark! it's mark!,
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.can you try repull the images? looks like there was migration issue with your database
Repull the images as in update the stack? Unfortunately Unraid has an idiosyncratic way of doing docker compose stuff...
Unfortunately, updating the stack doesn't seem to work.
(still getting the [Nest] 23 - 10/31/2025, 2:59:03 PM ERROR [Api:ErrorInterceptor~97gi4lt5] Unknown error: PostgresError: column "appVersion" of relation "session" does not exist error)
Please run these commands
https://docs.immich.app/FAQ/#how-can-i-verify-the-integrity-of-my-database
datname | checksum_failures | checksum_last_failure
-----------+-------------------+-----------------------
template0 | 0 |
template1 | 0 |
immich | 0 |
postgres | 0 |
(4 rows)
scanning for file structure errors now...
1065/1065 relations (100%), 59130/59130 pages (100%)looks good, I can give you a query to run to create the appVersion column
ALTER TABLE "session" ADD "appVersion" character varying;oh awesome
to run a query, am I just running
docker exec -it immich_postgres psql --dbname=postgres --username=postgres --command="ALTER TABLE "session" ADD "appVersion" character varying;" ?
yes
looks gopod
ERROR: relation "session" does not exist
hm
My assumption is these are things my database SHOULD have, right
is it possible my database got wiped
try that
how so?
"Did not find any relations."
sorry wrtoing command
oh, like - a while ago I tried to install ryot and it overwrote my immich postgres database and I had to restore from the backup. I'm wondering if somehow my postgres database got overwritten with zeroes or something, so it's not showing what it should be showing
"Did not find any relations."
that is also wrong, wth, give me a few
no worries, thank you all so much by the way, both for the help and for bearing with someone who is not very technically savy
ah of course
we put in the wrong database name
--dbname should be
immich
so thisALTER TABLE
looks like it did something!
should I restart the immich_postgres container and see if I can login now?
Yes
I suspect there will be some more migration we will need to perform, but I can walk you through
okay, that is started up again
login brings up the same material - do you want me to paste the logs?
login brings up the same materialdo you mean it works fine?
no, I'm afraid it brings up the same error message and what appears to be the same errors in the logs
Can you show the logs please
Can you double check if the docker exec command was running on a correct database?
could it possible that you have multiple database instsances?
looking at 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=/mnt/disk1/photos/immich
# The location where your database files are stored. Network shares are not supported for the database
DB_DATA_LOCATION=/mnt/user/appdata/postgresql/data
# 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=Etc/UTC
# 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=postgres
# The values below this line do not need to be changed
###################################################################################
DB_USERNAME=postgres
DB_DATABASE_NAME=immich
DB_SKIP_MIGRATIONS=trueSo you are running this in a VM?
Why do you have this flag?
I am running this in a Docker container in Unraid
I genuinely have no idea. I wonder... OHHHH
I wonder if I set that flag when the database got written over the first time, because I was worried about it overwriting the backups?
so if I switch that to false or comment out that line and run it again...
That flag should not be set randomly 😅
yeah let's try that
just remove it altogether
the backup won't be overwritten
it generates new file for each database dump
and we are back!
thank you so much!
no problem
This thread has been closed. To re-open, use the button below.