Immich•2y ago

thumbnails not loading

[Nest] 7  - 09/25/2023, 9:24:34 PM   ERROR [JobService] QueryFailedError: invalid input syntax for type timestamp with time zone: "0NaN-NaN-NaNTNaN:NaN:NaN.NaN+NaN:NaN"
    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 InsertQueryBuilder.execute (/usr/src/app/node_modules/typeorm/query-builder/InsertQueryBuilder.js:106:33)
    at async AssetRepository.upsertExif (/usr/src/app/dist/infra/repositories/asset.repository.js:37:9)
    at async MetadataExtractionProcessor.handleMetadataExtraction (/usr/src/app/dist/microservices/processors/metadata-extraction.processor.js:154:9)
    at async /usr/src/app/dist/domain/job/job.service.js:107:37
    at async Worker.processJob (/usr/src/app/node_modules/bullmq/dist/cjs/classes/worker.js:346:28)
    at async Worker.retryIfFailed (/usr/src/app/node_modules/bullmq/dist/cjs/classes/worker.js:531:24)
[Nest] 7  - 09/25/2023, 9:24:34 PM   ERROR [JobService] Object:
{
  "id": "ad0a9d7f-c72c-4896-bea6-5cd62f05fdd1",
  "source": "upload"

[Nest] 7  - 09/25/2023, 9:24:34 PM   ERROR [JobService] QueryFailedError: invalid input syntax for type timestamp with time zone: "0NaN-NaN-NaNTNaN:NaN:NaN.NaN+NaN:NaN"
    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 InsertQueryBuilder.execute (/usr/src/app/node_modules/typeorm/query-builder/InsertQueryBuilder.js:106:33)
    at async AssetRepository.upsertExif (/usr/src/app/dist/infra/repositories/asset.repository.js:37:9)
    at async MetadataExtractionProcessor.handleMetadataExtraction (/usr/src/app/dist/microservices/processors/metadata-extraction.processor.js:154:9)
    at async /usr/src/app/dist/domain/job/job.service.js:107:37
    at async Worker.processJob (/usr/src/app/node_modules/bullmq/dist/cjs/classes/worker.js:346:28)
    at async Worker.retryIfFailed (/usr/src/app/node_modules/bullmq/dist/cjs/classes/worker.js:531:24)
[Nest] 7  - 09/25/2023, 9:24:34 PM   ERROR [JobService] Object:
{
  "id": "ad0a9d7f-c72c-4896-bea6-5cd62f05fdd1",
  "source": "upload"

14 Replies

Onelots.OP•2y ago

what do you think @jrasm91 ? uh u disconnected sorry for the ping :/

[Nest] 7  - 09/25/2023, 9:11:31 PM    WARN [AssetService] WebP thumbnail requested but not found for asset ce973f01-e2c5-4790-be19-58382fdf4b43, falling back to JPEG
[Nest] 7  - 09/25/2023, 9:11:31 PM   ERROR [AssetService] Cannot create read stream for asset ce973f01-e2c5-4790-be19-58382fdf4b43
getAssetThumbnail
[Nest] 7  - 09/25/2023, 9:11:35 PM    WARN [AssetService] WebP thumbnail requested but not found for asset 01bde279-6632-4422-a9e3-551362873fde, falling back to JPEG
[Nest] 7  - 09/25/2023, 9:11:35 PM   ERROR [AssetService] Cannot create read stream for asset 01bde279-6632-4422-a9e3-551362873fde
getAssetThumbnail

[Nest] 7  - 09/25/2023, 9:11:31 PM    WARN [AssetService] WebP thumbnail requested but not found for asset ce973f01-e2c5-4790-be19-58382fdf4b43, falling back to JPEG
[Nest] 7  - 09/25/2023, 9:11:31 PM   ERROR [AssetService] Cannot create read stream for asset ce973f01-e2c5-4790-be19-58382fdf4b43
getAssetThumbnail
[Nest] 7  - 09/25/2023, 9:11:35 PM    WARN [AssetService] WebP thumbnail requested but not found for asset 01bde279-6632-4422-a9e3-551362873fde, falling back to JPEG
[Nest] 7  - 09/25/2023, 9:11:35 PM   ERROR [AssetService] Cannot create read stream for asset 01bde279-6632-4422-a9e3-551362873fde
getAssetThumbnail

it comes from here :bonhomme: in immich-server not cool bro

Onelots.OP•2y ago

aaaand here we go. I'll let you know if it worked.

Onelots.OP•2y ago

:jerry:

Onelots.OP•2y ago

someone is not enjoying it wait what it's coming down 40800 => 39400 and then up 39k => 41200 :RSPepeGlasses:

jrasm91•2y ago

Here is what happened

Onelots.OP•2y ago

I'm listening to you :prayge:

jrasm91•2y ago

There is a metadata bug, which is where those NaN bugs come from. When the metadata fails the thumbnail didn't get generated so they were "missing". There are actually 3 thumbnails for each asset and the other two are only queued after the first one completes successfully. So that is why the count goes up

Onelots.OP•2y ago

uh okay, thanks for taking your time to explain me it makes sense so to get it working, what should I do ? (one day if I see you I'll have to pay you a beer :bonhomme: )

jrasm91•2y ago

Lol It sounds like this is all Google photos import, so ideally fix the metadata then import/re-import.

Onelots.OP•2y ago

:Think: I don't have the metadata files the jsons provided while takeout

jrasm91•2y ago

Does your mom still have her files uploaded to Google photos ? If so your can do another takeout

Onelots.OP•2y ago

(nope I wiped everything) (I was young) :Lavie_estdure: uh it looks like it worked a bit

Onelots.OP•2y ago

I can have some thumbnails now

Onelots.OP•2y ago

maybe at the end it works with some magic ? :issou: (I stopped the generation but I will re launch it) @jrasm91 it worked After a lot of efforts from my server

Gaming

Programming

thumbnails not loading

Did you find this page helpful?