I
Immich2y ago
C

Pixel motion photos borked

Recently updated to the v1.81.0 and now all my motion photos no longer play. They display fine statically, but when you try to play them, it throws you an error. I am on Firefox 118.0.1
4 Replies
C
COP2y ago
The phone I use is a Pixel 6a These logs appeared in the microservices container:
[Nest] 7 - 10/05/2023, 2:11:05 AM ERROR [MetadataService] Failed to extract live photo upload/library/08a76527-077f-4889-afdc-82c891242791/2023/2023-04-02/IMG_20230402_182620574_BURST001.jpg: QueryFailedError: duplicate key value violates unique constraint "UQ_16294b83fa8c0149719a1f631ef"

QueryFailedError: duplicate key value violates unique constraint "UQ_16294b83fa8c0149719a1f631ef"

at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:211:19)

at process.processTicksAndRejections (node:internal/process/task_queues:95:5)

at async UpdateQueryBuilder.execute (/usr/src/app/node_modules/typeorm/query-builder/UpdateQueryBuilder.js:83:33)

at async updateSubject (/usr/src/app/node_modules/typeorm/persistence/SubjectExecutor.js:380:38)

at async Promise.all (index 0)

at async SubjectExecutor.executeUpdateOperations (/usr/src/app/node_modules/typeorm/persistence/SubjectExecutor.js:422:9)

at async SubjectExecutor.execute (/usr/src/app/node_modules/typeorm/persistence/SubjectExecutor.js:99:9)

at async EntityPersistExecutor.execute (/usr/src/app/node_modules/typeorm/persistence/EntityPersistExecutor.js:140:21)

at async AssetRepository.save (/usr/src/app/dist/infra/repositories/asset.repository.js:152:24)

at async MetadataService.applyMotionPhotos (/usr/src/app/dist/domain/metadata/metadata.service.js:269:13)
[Nest] 7 - 10/05/2023, 2:11:05 AM ERROR [MetadataService] Failed to extract live photo upload/library/08a76527-077f-4889-afdc-82c891242791/2023/2023-04-02/IMG_20230402_182620574_BURST001.jpg: QueryFailedError: duplicate key value violates unique constraint "UQ_16294b83fa8c0149719a1f631ef"

QueryFailedError: duplicate key value violates unique constraint "UQ_16294b83fa8c0149719a1f631ef"

at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:211:19)

at process.processTicksAndRejections (node:internal/process/task_queues:95:5)

at async UpdateQueryBuilder.execute (/usr/src/app/node_modules/typeorm/query-builder/UpdateQueryBuilder.js:83:33)

at async updateSubject (/usr/src/app/node_modules/typeorm/persistence/SubjectExecutor.js:380:38)

at async Promise.all (index 0)

at async SubjectExecutor.executeUpdateOperations (/usr/src/app/node_modules/typeorm/persistence/SubjectExecutor.js:422:9)

at async SubjectExecutor.execute (/usr/src/app/node_modules/typeorm/persistence/SubjectExecutor.js:99:9)

at async EntityPersistExecutor.execute (/usr/src/app/node_modules/typeorm/persistence/EntityPersistExecutor.js:140:21)

at async AssetRepository.save (/usr/src/app/dist/infra/repositories/asset.repository.js:152:24)

at async MetadataService.applyMotionPhotos (/usr/src/app/dist/domain/metadata/metadata.service.js:269:13)
I did try to re-run extract metadata task for all images but it didn't change anything. in previous versions it worked flawlessly. Could be a potential regression?
Deemo
Deemo2y ago
I've been having pseudo issues with the immich android app specifically (using motion photos via gcam)
Deemo
Deemo2y ago
GitHub
[BUG] Google Motion Photos not playing back correctly on immich and...
The bug The immich android app seems to be having trouble playing back google motion photos. It seems to skip through the video. Some samples bellow. Android app (issue present): screen-20231002-13...
Deemo
Deemo2y ago
I'm not sure if this is related For me I have no issues viewing motion photos from firefox/ios but the android app can't seem to view them

Did you find this page helpful?