Internal error message, probably some images without correct date loaded
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
12 Replies
These metadata extraction errors should be fixed with https://github.com/immich-app/immich/pull/4210
And those map issues should be fixed with https://github.com/immich-app/immich/pull/4221
thanks, then it looks like everything will be fixed some day 🙂
got any clues about face not being able to run?
yup, eagerly awaiting those fixes too xD
uh no, do you have correspondending logfiles for that? Or how do you know that facial recognition job does not run?
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)
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
hmh ok. Have you changed the facial recognition values? min detection score/max recognition distance?
yes, several times
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...
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
the tables asset_faces and person seem to be related with facial recognition...
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
The recognize faces job started successfully now
Many thanks for both clearing up the app errors and guiding me trough the facial recognize job 🙂