1.133.1 crash loop
Howdy all .. first off this program is absoutly amazing and thank you to the devs for it!
I am having an issue with 1.133.1 with a crash loop on immich_server. All the dependancies are up but server runs for 10s then reloads. Here is the docker log: missing 'error' handler on this Redis client Query failed : { durationMs: 4.528843000000052, error: PostgresError: function array_length(vector, integer) does not exist at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26) at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6) at Socket.data (/usr/src/app/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) { severity_local: 'ERROR', severity: 'ERROR', code: '42883', hint: 'No function matches the given name and argument types. You might need to add explicit type casts.', file: 'parse_func.c', line: '629', routine: 'ParseFuncOrColumn' }, sql: '\n' + ' ALTER TABLE smart_search\n' + ' ALTER COLUMN embedding\n' + ' SET DATA TYPE vector(512)', params: [] } Postgres log says similar: 2025-05-25 01:02:34.261 UTC [777] ERROR: function array_length(vector, integer) does not exist 2025-05-25 01:02:34.261 UTC [777] HINT: No function matches the given name and argument types. You might need to add explicit type casts. 2025-05-25 01:02:34.261 UTC [777] STATEMENT:
ALTER TABLE smart_search ALTER COLUMN embedding SET DATA TYPE vector(512) I checked and made sure my docker_compose is of the latest version and can't get this to come out of the issue. Any hints would be great. Tks in adv.
I am having an issue with 1.133.1 with a crash loop on immich_server. All the dependancies are up but server runs for 10s then reloads. Here is the docker log: missing 'error' handler on this Redis client Query failed : { durationMs: 4.528843000000052, error: PostgresError: function array_length(vector, integer) does not exist at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26) at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6) at Socket.data (/usr/src/app/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) { severity_local: 'ERROR', severity: 'ERROR', code: '42883', hint: 'No function matches the given name and argument types. You might need to add explicit type casts.', file: 'parse_func.c', line: '629', routine: 'ParseFuncOrColumn' }, sql: '\n' + ' ALTER TABLE smart_search\n' + ' ALTER COLUMN embedding\n' + ' SET DATA TYPE vector(512)', params: [] } Postgres log says similar: 2025-05-25 01:02:34.261 UTC [777] ERROR: function array_length(vector, integer) does not exist 2025-05-25 01:02:34.261 UTC [777] HINT: No function matches the given name and argument types. You might need to add explicit type casts. 2025-05-25 01:02:34.261 UTC [777] STATEMENT:
ALTER TABLE smart_search ALTER COLUMN embedding SET DATA TYPE vector(512) I checked and made sure my docker_compose is of the latest version and can't get this to come out of the issue. Any hints would be great. Tks in adv.
13 Replies
:wave: Hey @Cody Newman,
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.
Successfully submitted, a tag has been added to inform contributors. :white_check_mark:please attach your compose and env file.
and clarify what platform you are using
Running on Docker version 28.1.1, build 4eba377 using an Alma 9.6 host in my homelab server.
I am also proxying with jwilder/nginx-proxy.
Docker Compose Logs:
did you try restarting ?
docker compose down && docker compose up -d --pull ?I have done, ive also taking it down and done a full docker system prune and then up to force everything to re-pull. No lucf
where you in pg14 before the upgrade ?
Yes I was, I did the db upgrade steps to 1.133.0 and it was working okay on 1.133.0. I was up for a while on 1.133.1 today after updating -- but I think a background job kicked off and it ate itself
do you have a DB backup to start clean? everything in the config looks fine, but it behaves as if the extension wasn't installed
what about disk space? is the partition full?
I do have backups of the DB. I did run out of space on the upgrade to 1.133.0 but expanded the system drive to get it done.
I’ll try swapping out the db
followed https://immich.app/docs/administration/backup-and-restore/
Now getting:
immich_server | Error: getaddrinfo EAI_AGAIN redis
immich_server | at GetAddrInfoReqWrap.onlookup [as oncomplete] (node:dns:109:26) {
immich_server | errno: -3001,
immich_server | code: 'EAI_AGAIN',
immich_server | syscall: 'getaddrinfo',
immich_server | hostname: 'redis'
immich_server | }
immich_server | missing 'error' handler on this Redis client
Oh, this is unlucky. You seem to have changed the model and it crashed during the model change, and the startup checks that separately decided to reindex don’t consider this. Try running
alter table smart_search drop constraint dim_size_constraint;
We should patch this so it’s handled automatically@NoMachine and @mertalev
Thanks for the help. I could not get anything to work - even wiping out the entire postgres folder to force it to start clean would give me that EAI_AGAIN error.
So what I ended up doing was creating a net new compose folder with the stock docker-compose and .env files just to see if I could get immich to start. When immich did start on a clean instance I bought my postgres folder over from the old project and et voila i'm running again.
Thanks again for all the great work on this!
I'm glad you were able to make it work