Closed d0ougal closed 2 days ago
Can you find one of the files that cause this issue and post the full output of running exiftool
on it?
I had a similar issue:
[Nest] 7 - 09/10/2024, 4:29:07 AM ERROR [Microservices:JobService] Unable to run job handler (metadataExtraction/metadata-extraction): QueryFailedError: value "4294967295" is out of range for type integer [Nest] 7 - 09/10/2024, 4:29:07 AM ERROR [Microservices:JobService] QueryFailedError: value "4294967295" is out of range for type integer at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19) at process.processTicksAndRejections (node:internal/process/task_queues:95:5) at async InsertQueryBuilder.execute (/usr/src/app/node_modules/typeorm/query-builder/InsertQueryBuilder.js:106:33) at async AssetRepository.upsertExif (/usr/src/app/dist/repositories/asset.repository.js:49:9) at async MetadataService.handleMetadataExtraction (/usr/src/app/dist/services/metadata.service.js:201:9) at async /usr/src/app/dist/services/job.service.js:148:36 at async Worker.processJob (/usr/src/app/node_modules/bullmq/dist/cjs/classes/worker.js:394:28) at async Worker.retryIfFailed (/usr/src/app/node_modules/bullmq/dist/cjs/classes/worker.js:581:24) [Nest] 7 - 09/10/2024, 4:29:07 AM ERROR [Microservices:JobService] Object: { "id": "36876711-e48d-45ca-8816-4e7130663341" }
Looking at exif tool, the Rating field is probably the problem
Rating : 4294967295
Thanks! Dupe of #12476
The bug
metadata extraction fails per logs due to number being too big to be an integer
The OS that Immich Server is running on
Ubuntu 24.04 LTS
Version of Immich Server
v1.112.1
Version of Immich Mobile App
1.112.1
Platform with the issue
Your docker-compose.yml content
Your .env content
Reproduction steps
Relevant log output
Additional information
No response