After using immich-go: Internal server error (Immich Server Error)
Hi all.
I was up and running and everything looked great. Until I imported all my Google Photos from takeout using immich-go.
Whenever I click Photos in the immich web gui, I no longer see any photos in this view, but I am spammed with "Internal server error (Immich Server Error)" down the right of the page.
If I enter explore I see People and Places.
If I click into a place or person I see lots of photos. Sometimes I still get the errors also, but can still see photos.
Containers;
immich_machine_learning - No errors
immich_microservices - No errors
immich_proxy - No errors
immich_web - No errors
Immich_redis - Error but not sure if relevant.
1:M 07 Oct 2023 19:43:14.545 # WARNING Memory overcommit must be enabled! Without it, a background save or replication may fail under low memory condition. Being disabled, it can can also cause failures without low memory condition, see https://github.com/jemalloc/jemalloc/issues/1328. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
Immich_server - This seems relevant? Issues with photo import?
[Nest] 7 - 10/07/2023, 7:57:24 PM ERROR [ExceptionsHandler] time zone displacement out of range: "+198764-03-01T00:00:00.000Z"
immich_typesense - A couple of these document fetch errors. Not many.
E20231007 11:22:56.997400 177 collection.cpp:1472] Document fetch error. Could not locate the JSON document for sequence ID: 15483
E20231007 19:45:08.986982 639 raft_server.h:62] Peer refresh failed, error: Doing another configuration change
I found a similar error and cause, but the recommendation to find and delete the offending files with bad metadata is difficult since I can't browse them... https://github.com/immich-app/immich/issues/4264GitHub
[BUG] time zone displacement out of range · Issue #4264 · immich-ap...
The bug After moving to v1.79.1, I started getting a generic "Error - Internal server error (Immich server error)" messages. The logs are as follows, and my deployment strategy has been t...
11 Replies
Do you have additional logs for immich-server regarding the error?
Actually, sorry if I scroll down for a while I do see photos eventually!
Hi Alex 🙂 how's it going.
It is these repeating.
at async /usr/src/app/node_modules/@nestjs/core/router/router-proxy.js:9:17
at async /usr/src/app/node_modules/@nestjs/core/router/router-execution-context.js:46:28
at async AssetService.getByTimeBucket (/usr/src/app/dist/domain/asset/asset.service.js:166:24)
at async SelectQueryBuilder.getMany (/usr/src/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:750:25)
at async SelectQueryBuilder.getRawAndEntities (/usr/src/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:684:29)
at async SelectQueryBuilder.executeEntitiesAndRawResults (/usr/src/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:2034:26)
at async SelectQueryBuilder.loadRawResults (/usr/src/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:2183:25)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:211:19)
QueryFailedError: time zone displacement out of range: "+014195-08-01T00:00:00.000Z"
[Nest] 7 - 10/07/2023, 8:06:39 PM ERROR [ExceptionsHandler] time zone displacement out of range: "+014195-08-01T00:00:00.000Z"
Some photos I found when scrolling down have some crazy dates. I'll download and delete these now.
I removed the weird dated ones, but it feels like I have invisible photos above these ones that cause the errors
The errors are happening because of some files that have even crazier dates
Did you have anything in your instance before you did this big import? If not, it might be easiest to wipe the whole thing and start again, but making sure to fix the dates first
Yeah quite a lot unfortunately. Big drag and drop import, 2 user syncs, and then 2 google photo imports to cause this. Damn
I'll do some manual work on the photo library and see if I can figure anything out.
Google takeout 😐
Thanks for the support
I think I fixed this;
Opened library and checked directories for weird dates. Deleted but didn't fix issue.
I opened the photos app on my ios and wife's android, could see all the strange dates here even though the files were gone. Selected all these and deleted.
It appears that has solved my issue.
sorry to be late on this! I have exactly 2 iphone videos that produce this on my server. Now, I have finished to refactor the google photo import. I have more bandwidth for this
@MoNk Fell free to open an issue on the project https://github.com/simulot/immich-go
GitHub
GitHub - simulot/immich-go
Contribute to simulot/immich-go development by creating an account on GitHub.
I have reproduced the problem with an fresh database, simply by drag and drop the video on the webpage.
the exiftool output show the create date
174510:04:28 00:49:44
this matches also the SQL error
The database field contains the invalid value. So int insert was possible, not the select.
I'm not sure this will be fixed on immich server side. The issue
[BUG] time zone displacement out of range #4264 is closed.
I have applied the following method to get rid of error messages and re-upload files with correct dates:
1/ Open the phone app, delete faulty images
2/ Re-import your takeout archive with immich-go with the -force-sidecar=TRUE option.
immich-go will ignore all images present on the immich server and will upload missing one with an ad-hoc XMP file with correct dates.
Immich will use the xmp file instead of trying to get the date from the exif data.
the full command line would be:
@miknzau fyi, this is related to your issue I believe
Yes I saw this issue today