thumbnails not loading | Immich | Page 1

arctic magnet Sep 25, 2023, 9:29 PM

#

[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"```

#

what do you think @knotty holly ?

#

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```

#

it comes from here

#

bonhomme

#

in immich-server

#

not cool bro

#

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

Capture_decran_2023-09-25_a_23.35.36.png

#

jerry

Capture_decran_2023-09-25_a_23.36.04.png

#

someone is not enjoying it

#

wait

#

what

#

it's coming down

#

40800 => 39400

#

and then up

#

39k => 41200

#

RSPepeGlasses

knotty holly Sep 25, 2023, 9:41 PM

#

Here is what happened

arctic magnet Sep 25, 2023, 9:41 PM

#

I'm listening to you prayge

knotty holly Sep 25, 2023, 9:43 PM

#

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

arctic magnet Sep 25, 2023, 9:44 PM

#

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 )

knotty holly Sep 25, 2023, 9:46 PM

#

Lol

#

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

arctic magnet Sep 25, 2023, 9:49 PM

#

knotty holly It sounds like this is all Google photos import, so ideally fix the metadata the...

Think

#

I don't have the metadata files

#

the jsons provided while takeout

knotty holly Sep 25, 2023, 9:51 PM

#

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

arctic magnet Sep 25, 2023, 9:51 PM

#

knotty holly Does your mom still have her files uploaded to Google photos ? If so your can do...

(nope I wiped everything)

#

(I was young)

#

Lavie_estdure

#

uh it looks like it worked a bit

#

I can have some thumbnails now

Capture_decran_2023-09-25_a_23.52.10.png

#

maybe at the end it works with some magic ?

#

issou

#

(I stopped the generation but I will re launch it)

#thumbnails not loading