Immich•3y ago

Metadata Extraction Errors

Hi, I recently used the admin panel to rerun metadata extraction on all assets. The immich_microservices container is littered with the following:

[Nest] 1  - 03/01/2023, 3:34:50 PM   ERROR [MetadataExtractionProcessor] Error extracting EXIF QueryFailedError: invalid input syntax for type uuid: "VIDEO"
QueryFailedError: invalid input syntax for type uuid: "VIDEO"
    at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:211:19)
    at runMicrotasks (<anonymous>)
    at processTicksAndRejections (node:internal/process/task_queues:96:5)
    at async SelectQueryBuilder.loadRawResults (/usr/src/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:2132:25)
    at async SelectQueryBuilder.getRawMany (/usr/src/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:629:29)
    at async SelectQueryBuilder.executeEntitiesAndRawResults (/usr/src/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:1936:26)
    at async SelectQueryBuilder.getRawAndEntities (/usr/src/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:667:29)
    at async SelectQueryBuilder.getOne (/usr/src/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:694:25)
    at async MetadataExtractionProcessor.extractExifInfo (/usr/src/app/dist/apps/microservices/apps/microservices/src/processors/metadata-extraction.processor.js:138:37)

[Nest] 1  - 03/01/2023, 3:34:50 PM   ERROR [MetadataExtractionProcessor] Error extracting EXIF QueryFailedError: invalid input syntax for type uuid: "VIDEO"
QueryFailedError: invalid input syntax for type uuid: "VIDEO"
    at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:211:19)
    at runMicrotasks (<anonymous>)
    at processTicksAndRejections (node:internal/process/task_queues:96:5)
    at async SelectQueryBuilder.loadRawResults (/usr/src/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:2132:25)
    at async SelectQueryBuilder.getRawMany (/usr/src/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:629:29)
    at async SelectQueryBuilder.executeEntitiesAndRawResults (/usr/src/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:1936:26)
    at async SelectQueryBuilder.getRawAndEntities (/usr/src/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:667:29)
    at async SelectQueryBuilder.getOne (/usr/src/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:694:25)
    at async MetadataExtractionProcessor.extractExifInfo (/usr/src/app/dist/apps/microservices/apps/microservices/src/processors/metadata-extraction.processor.js:138:37)

3 Replies

HummingbirdOP•3y ago

In the postgres container I see the corresponding error:

message.txt

MicheI•3y ago

Submitted a PR for it https://github.com/immich-app/immich/pull/1914

GitHub

fix(server): exif extraction swapped params by michelheusschen · Pu...

The parameters for AssetRepository.findLivePhotoMatch were swapped in #1787, but not in IAssetRepository. This causes metadata extraction to fail for all videos and based on the code also for the p...

HummingbirdOP•3y ago

Amazing, thank you!

Gaming

Programming

Metadata Extraction Errors

Did you find this page helpful?