#Internal error message, probably some images without correct date loaded

1 messages · Page 1 of 1 (latest)

silver talon
#

Problem: error messages pops up when opening immich in the browser, scrolling trough images work when landing on the front page - see picture of error popups, database logs kinda move in the same rate
frontend stops working after clicking around, wont go back to pictures from map etc. (sveltekit-invalidated=01 response)
facial recognition job will not run (this is another issue i think, that i have had for some days before)

Running extract metadata job gives these errors in the microservices container
[Nest] 7 - 09/27/2023, 2:06:57 PM ERROR [JobService] QueryFailedError: invalid input syntax for type timestamp with time zone: "0NaN-NaN-NaNTNaN:NaN:NaN.NaN+NaN:NaN"
Added printscreen of textblock, where there is an ID, probably for an image that is missing said info
if i refresh the immich app in the web browser and search for one of these ID's i get alot of blue similar looking pictures in return, different ID's kind of result in similar-ish images

refreshing the main /photos page and giving it a little scroll-action gives these errors in the database container
2023-09-27 12:09:12.010 UTC [977] ERROR: time zone displacement out of range: "+232472-01-01T00:00:00.000Z"
2023-09-27 12:10:48.383 UTC [1152] ERROR: invalid input syntax for type timestamp with time zone: "0NaN-NaN-NaNTNaN:NaN:NaN.NaN+NaN:NaN"

Probably an image with some wrong tags or date

Any sollutions to fix the problems? it seems the frontend is bugging it self after a while when doing these steps: From photos, go to map, then the links in the menu does not work, or the gear icon for settings in map locks the modal.
both fresh chrome and firefox with and without plugins, network response seems to be sveltekit-invalidated=01 and 001, pingpong and server-info is going i see

90567 photos 6806 videos 403gb (lots of group photos)
immich pulled fresh
v1.79.1

image.png image.png
acoustic moat
silver talon
#

thanks, then it looks like everything will be fixed some day 🙂

#

got any clues about face not being able to run?

acoustic moat
acoustic moat
silver talon
#

i can start it and see if there is any log action now, but there is pretty much nothing happening (got the same fault as another discord post here)

#

1151802681166401606 this is the thread ID of the other discord post, or search for "Cannot rerun Facial Recognition" seems to be the same problem

#

Currently running the extract metadata job, so there is much going on in the logs.

this is the end of the log output as started in the image:
3, $68614, $68615, $68616, $68617, $68618)

image.png
#

counting up and then it stops it seems, clicking both all or missing on the recognize faces job shows 1 active, with the green indicator above and then it just stops. repeat for same result

#

counting from $1 to 68618

#

clicking the all or missing on the recognize network response is showing "recognizeFaces" with active: 1, then 1 jobs response with recognizeFaces active:1
then another with active: 0

acoustic moat
#

hmh ok. Have you changed the facial recognition values? min detection score/max recognition distance?

silver talon
#

yes, several times

acoustic moat
#

in the other thread there was mentioned that maybe one component cannot handle that much faces. but I really don't know. As a workaround you could try clearing faces table in your immich DB...

silver talon
#

yes, that might be it, the new setting "MIN FACES DETECTED" will be valuable for me

#

im going to search the docs for clearing the faces table

acoustic moat
#

the tables asset_faces and person seem to be related with facial recognition...

silver talon
#

68618 deleted lines from the person table, the asset_faces table was empty on its own after i emptied the person table. before asset_faces had 10957 lines

DELETE FROM person;

The recognize faces job started successfully now