Immich•2y ago

Internal error server

I got a notification on web interface top right popup with red interal error server

49 Replies

Latest version 1.8.2.1

In server log I see this [Nest] 8 - 10/18/2023, 8:37:01 PM ERROR [ExceptionsHandler] time zone displacement out of range: "+234459-03-01T00:00:00.000Z" I server web log stack: 'Error: connect ECONNREFUSED 172.20.0.8:3001\n' + [hooks.server.ts]:handle connect ECONNREFUSED 172.20.0.8:3001 [hooks.server.ts]:handleError connect ECONNREFUSED 172.20.0.8:3001 [hooks.server.ts] Unable to get my user { code: 'ECONNREFUSED', message: 'connect ECONNREFUSED 172.20.0.8:3001', ' at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1595:16)' } In client I noticed this strange behaviour since last update

spupuz | loveOP•2y ago

Can this be related To internal error server?

jrasm91•2y ago

looks like you have some asset with bad exif that is causing the timeline to crash.

spupuz | loveOP•2y ago

Yeah removed the previous video solved

EnochPrime•2y ago

I'm having this issue, but with many many assets.

Alex Tran•2y ago

Thank you for reporting this, it is very helpful! It looks like the issue causes the web not able to render anything, correct? But it renders in the mobile app Hey do you mind grabbing one of the error assets, zip it up and send it to us for troubleshooting?

EnochPrime•2y ago

I'll try to locate some.

EnochPrime•2y ago

This is what mobile looks like.

EnochPrime•2y ago

At first glance they are all videos. I found a video that is 13s and less than 5MB. How should I send it? All these videos also appear to be from the external libraries. I wonder if something corrupted because files are still being processed from the library, but I had multiple crashes of the microservices and server when I updated because they consumed more RAM than before.

jrasm91•2y ago

A lot of these types of problems have come from Whatsapp storing bad metadata. Is that the case here?

EnochPrime•2y ago

Negative, not from what's app.

Input #0, mov,mp4,m4a,3gp,3g2,mj2, from '20161125_212220.mp4':
  Metadata:
    major_brand     : mp42
    minor_version   : 0
    compatible_brands: isommp42
    creation_time   : 2036-01-01T23:59:59.000000Z
  Duration: 00:00:13.00, start: 0.000000, bitrate: 2994 kb/s
  Stream #0:0(und): Video: h264 (High) (avc1 / 0x31637661), yuv420p(tv, bt709), 1080x1920 [SAR 1:1 DAR 9:16], 2876 kb/s, 29.89 fps, 29.92 tbr, 90k tbn, 59.78 tbc (default)
    Metadata:
      creation_time   : 2019-05-26T16:02:10.000000Z
      handler_name    : ISO Media file produced by Google Inc. Created on: 05/26/2019.
      vendor_id       : [0][0][0][0]
  Stream #0:1(und): Audio: aac (LC) (mp4a / 0x6134706D), 44100 Hz, stereo, fltp, 125 kb/s (default)
    Metadata:
      creation_time   : 2019-05-26T16:02:10.000000Z
      handler_name    : ISO Media file produced by Google Inc. Created on: 05/26/2019.
      vendor_id       : [0][0][0][0]

Input #0, mov,mp4,m4a,3gp,3g2,mj2, from '20161125_212220.mp4':
  Metadata:
    major_brand     : mp42
    minor_version   : 0
    compatible_brands: isommp42
    creation_time   : 2036-01-01T23:59:59.000000Z
  Duration: 00:00:13.00, start: 0.000000, bitrate: 2994 kb/s
  Stream #0:0(und): Video: h264 (High) (avc1 / 0x31637661), yuv420p(tv, bt709), 1080x1920 [SAR 1:1 DAR 9:16], 2876 kb/s, 29.89 fps, 29.92 tbr, 90k tbn, 59.78 tbc (default)
    Metadata:
      creation_time   : 2019-05-26T16:02:10.000000Z
      handler_name    : ISO Media file produced by Google Inc. Created on: 05/26/2019.
      vendor_id       : [0][0][0][0]
  Stream #0:1(und): Audio: aac (LC) (mp4a / 0x6134706D), 44100 Hz, stereo, fltp, 125 kb/s (default)
    Metadata:
      creation_time   : 2019-05-26T16:02:10.000000Z
      handler_name    : ISO Media file produced by Google Inc. Created on: 05/26/2019.
      vendor_id       : [0][0][0][0]

jrasm91•2y ago

Hmm Is it a normal video? Like normal size? Can you share the exif tool output?

EnochPrime•2y ago

Appears so, immich even plays it fine from Mobile. Do you have the command handy to do that?

jrasm91•2y ago

Just exiftool and then the filename

EnochPrime•2y ago

https://pastebin.com/JmHmBeW9

Pastebin

ExifTool Version Number : 12.40File Name ...

Pastebin.com is the number one paste tool since 2002. Pastebin is a website where you can store text online for a set period of time.

EnochPrime•2y ago

I believe the file name is the correct date. 2016 11 25 Everything else appears to be wrong.

EnochPrime•2y ago

This one is worse on the date. https://pastebin.com/gvRZPWEK

Pastebin

ExifTool Version Number : 12.40File Name ...

Pastebin.com is the number one paste tool since 2002. Pastebin is a website where you can store text online for a set period of time.

Alex Tran•2y ago

Can you zip it up and send it here? Or maybe share over GDrive or something?

EnochPrime•2y ago

2nd file has both, ignore first

Alex Tran•2y ago

Thanks

jrasm91•2y ago

Are these from Google takeout?

EnochPrime•2y ago

Likely

jrasm91•2y ago

Do you happen to have the file from the takeout still?

EnochPrime•2y ago

I don't, but the file may still be on Google.

Alex Tran•2y ago

So we use the createDate some how the year is 2036

Alex Tran•2y ago

And the other one has the year out of wack

Alex Tran•2y ago

u from the future? :HVCsurprisedtanaka: I deleted the files to protect your privacy @jrasm91 for this issue, I am thinking of having a job or just a service that get called when the server is succesfully init-ed to search for file that has year greater than the current year and overwrite the year to the current date so that the user can know and fix the issue

jrasm91•2y ago

What do you think about just putting a filter in the time bucket query to exclude these? We could have another table for problematic records or something and flag it

Alex Tran•2y ago

yeah that works too

jrasm91•2y ago

I have seen this exact same bug several times and it is always in the same form. There must be some library or code out there with a bug that's being used to write exif data. The year is 218 and then the hours are 02:18. It's always the same. Soooo I think I figured it out. https://github.com/mattwilson1024/google-photos-exif/blob/master/src/helpers/read-photo-taken-time-from-google-json.ts#L15-L21 I think it is a takeout file and the famous metadata fixer script gets the date by doing new date of this timestamp x 1000. I think if the value is multiplied by another 1000 it basically becomes a 6 digit year.

Alex Tran•2y ago

Hmm, why would the day get multiplied by 1000?

jrasm91•2y ago

It is multiplying by 1000 to convert it to milliseconds, so maybe some values were already stored in milliseconds or something. My guess is a bug related to Google takeout and created date on videos

ddshd•2y ago

I used that script and I see a similar issue on a couple of photos Maybe a fork of that, someone has been maintaining it more recently

jrasm91•2y ago

It would be interesting to see the original json file for the video And what date it has now

Alex Tran•2y ago

@jrasm91, thank you for the quick diagnosis, you are amazing <#

ddshd•2y ago

Hm lemme request another takeout

jrasm91•2y ago

Well let's see if I'm right first 😁

ddshd•2y ago

@jrasm91 can i DM it to you? There is personal info in it

{ "title": "IMG_3337.MOV", "description": "", "imageViews": "48", "creationTime": { "timestamp": "1480554920", "formatted": "Dec 1, 2016, 1:15:20 AM UTC" }, "photoTakenTime": { "timestamp": "1480038442", "formatted": "Nov 25, 2016, 1:47:22 AM UTC" }, ...

Here is the part that matters for anyone else

File Modification Date/Time : 2016:11:24 20:47:22-05:00 File Access Date/Time : 2023:08:19 22:42:10-04:00 File Inode Change Date/Time : 2016:11:24 20:47:22-05:00

Create Date : 2036:01:01 23:59:59 Modify Date : 2019:08:18 14:44:22 Time Scale : 90000 Duration : 22.29 s

Track Create Date : 2019:08:18 14:44:22 Track Modify Date : 2019:08:18 14:44:22

Media Create Date : 2019:08:18 14:44:22 Media Modify Date : 2019:08:18 14:44:22

Exif after processing Idk why only this file it would mess up on I used this, https://github.com/MrYakobo/exif-wrapper, which in itself has been unmaintained and forked LOLLL

spupuz | loveOP•2y ago

Render everything except the video with wrong date, and gives internal error, I removed it and it does work now.

ddshd•2y ago

@spupuz | love @EnochPrime I’m assuming y’all got these files from Google Photos, if so can you download it from the GP UI (not takeout) and check the exif data on it?

spupuz | loveOP•2y ago

need to check as soon i have the time... busy with work righ now

ddshd•2y ago

No worries https://github.com/immich-app/immich/discussions/1340#discussioncomment-5944757 looks like someone else saw a 2036 a while ago too

luofu•2y ago

connect ECONNREFUSED 172.18.0.7:3001 (ECONNREFUSED)

bo0tzz•2y ago

Can you open a new thread and post the logs of the containers etc?

luofu•2y ago

Thanks! I've solved it refer to https://discord.com/channels/979116623879368755/1129047619923103794/1129048795917860914:yum:

Discord

Discord - A New Way to Chat with Friends & Communities

Discord is the easiest way to communicate over voice, video, and text. Chat, hang out, and stay close with your friends and communities.

Gaming

Programming

Internal error server

Did you find this page helpful?