Storage migration not moving some photos
I am having an issue where all of my screenshots are not being moved by the storage migration job.
Here is the error I am getting:
[Nest] 7 - 06/30/2023, 6:26:56 PM WARN [StorageTemplateService] Unable to save new originalPath to database, undoing move for path upload/library/a2b3ad97-2791-4054-917b-b04c19796d85/2023/June/FullSizeRender+3.jpg - filename FullSizeRender - id 46a9fdd3-d9d8-47ce-843b-b1c3ca3b28b2
[Nest] 7 - 06/30/2023, 6:26:56 PM WARN [StorageTemplateService] QueryFailedError: duplicate key value violates unique constraint "UQ_4ed4f8052685ff5b1e7ca1058ba"
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:84:24)
at async StorageTemplateService.moveAsset (/usr/src/app/dist/domain/storage-template/storage-template.service.js:111:21)
Here is the error I am getting:
[Nest] 7 - 06/30/2023, 6:26:56 PM WARN [StorageTemplateService] Unable to save new originalPath to database, undoing move for path upload/library/a2b3ad97-2791-4054-917b-b04c19796d85/2023/June/FullSizeRender+3.jpg - filename FullSizeRender - id 46a9fdd3-d9d8-47ce-843b-b1c3ca3b28b2
[Nest] 7 - 06/30/2023, 6:26:56 PM WARN [StorageTemplateService] QueryFailedError: duplicate key value violates unique constraint "UQ_4ed4f8052685ff5b1e7ca1058ba"
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:84:24)
at async StorageTemplateService.moveAsset (/usr/src/app/dist/domain/storage-template/storage-template.service.js:111:21)
