issues adding machine learning data to postgres
Setup - unraid using official immich container, spaceinvaderone postres and official redis
so i have it up and running, even with distributed machine learning. however once it completes i hit 'missing' to make sure everything got processed but it wants to process everything again. When i check the logs i see
im guessing the data isnt written to the database so thats why it always wants to reprocess everything
so i have it up and running, even with distributed machine learning. however once it completes i hit 'missing' to make sure everything got processed but it wants to process everything again. When i check the logs i see
[Nest] 240 - 08/30/2025, 8:36:26 PM ERROR [Microservices:{"source":"upload","id":"3ff72644-2bab-4c38-82d1-f53316877438"}] Unable to run job handler (SmartSearch): PostgresError: pgvecto.rs: Bad literal.
INFORMATION: hint = Bad character at position 0
PostgresError: pgvecto.rs: Bad literal.
INFORMATION: hint = Bad character at position 0
at ErrorResponse (/app/immich/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26)
at handle (/app/immich/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6)
at Socket.data (/app/immich/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)
im guessing the data isnt written to the database so thats why it always wants to reprocess everything
