iOS Upload/Backup freezes / immich shows date/time field value out of range: "0000-12-30T00:00:00.000Z" #5871

Closed
opened 2026-02-05 11:49:00 +03:00 by OVERLORD · 1 comment
Owner

Originally created by @jkoopmann on GitHub (Apr 22, 2025).

I have searched the existing issues, both open and closed, to make sure this is not a duplicate report.

  • Yes

The bug

I notice that my iOS Backup freezes. Even after restart etc. in immich log I can see

[Nest] 273  - 04/22/2025, 6:18:37 PM   ERROR [Api:AssetMediaService~3ga3hkkl] Error uploading file PostgresError: date/time field value out of range: "0000-12-30T00:00:00.000Z"
PostgresError: date/time field value out of range: "0000-12-30T00:00:00.000Z"
    at ErrorResponse (/app/immich/server/node_modules/postgres/cjs/src/connection.js:790:26)
    at handle (/app/immich/server/node_modules/postgres/cjs/src/connection.js:476:6)
    at Socket.data (/app/immich/server/node_modules/postgres/cjs/src/connection.js:315:9)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
    at Readable.push (node:internal/streams/readable:392:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:191:23)
    at TCP.callbackTrampoline (node:internal/async_hooks:130:17)

At the same time. The timestamp DOES look strange. But either the iOS app and/or the immich server should compensate (maybe by simple omitting the value). And even if the upload of this particular asset is a problem, the upload should continue should it not?

Issue #16998 reports something similar but is closed as duplicate of #6173 which I believe is incorrect.

Might be a duplicate to #15912 which is still open. I believe there are two issues:

  1. why is this producing an error instead of overwriting the date?
  2. why Is this freezing the upload?

The OS that Immich Server is running on

Unraid

Version of Immich Server

v1.131.3

Version of Immich Mobile App

1.131.3 build 201

Platform with the issue

  • Server
  • Web
  • Mobile

Your docker-compose.yml content

non / Community app in unraid

Your .env content

non / Community app in unraid

Reproduction steps

  1. Backup from iOS with a file with incorrect date

Relevant log output

[Nest] 273  - 04/22/2025, 6:18:37 PM   ERROR [Api:AssetMediaService~3ga3hkkl] Error uploading file PostgresError: date/time field value out of range: "0000-12-30T00:00:00.000Z"
PostgresError: date/time field value out of range: "0000-12-30T00:00:00.000Z"
    at ErrorResponse (/app/immich/server/node_modules/postgres/cjs/src/connection.js:790:26)
    at handle (/app/immich/server/node_modules/postgres/cjs/src/connection.js:476:6)
    at Socket.data (/app/immich/server/node_modules/postgres/cjs/src/connection.js:315:9)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
    at Readable.push (node:internal/streams/readable:392:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:191:23)
    at TCP.callbackTrampoline (node:internal/async_hooks:130:17)

Additional information

No response

Originally created by @jkoopmann on GitHub (Apr 22, 2025). ### I have searched the existing issues, both open and closed, to make sure this is not a duplicate report. - [x] Yes ### The bug I notice that my iOS Backup freezes. Even after restart etc. in immich log I can see ``` [Nest] 273 - 04/22/2025, 6:18:37 PM ERROR [Api:AssetMediaService~3ga3hkkl] Error uploading file PostgresError: date/time field value out of range: "0000-12-30T00:00:00.000Z" PostgresError: date/time field value out of range: "0000-12-30T00:00:00.000Z" at ErrorResponse (/app/immich/server/node_modules/postgres/cjs/src/connection.js:790:26) at handle (/app/immich/server/node_modules/postgres/cjs/src/connection.js:476:6) at Socket.data (/app/immich/server/node_modules/postgres/cjs/src/connection.js:315:9) at Socket.emit (node:events:524:28) at addChunk (node:internal/streams/readable:561:12) at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) at Readable.push (node:internal/streams/readable:392:5) at TCP.onStreamRead (node:internal/stream_base_commons:191:23) at TCP.callbackTrampoline (node:internal/async_hooks:130:17) ``` At the same time. The timestamp DOES look strange. But either the iOS app and/or the immich server should compensate (maybe by simple omitting the value). And even if the upload of this particular asset is a problem, the upload should continue should it not? Issue #16998 reports something similar but is closed as duplicate of #6173 which I believe is incorrect. Might be a duplicate to #15912 which is still open. I believe there are two issues: 1) why is this producing an error instead of overwriting the date? 2) why Is this freezing the upload? ### The OS that Immich Server is running on Unraid ### Version of Immich Server v1.131.3 ### Version of Immich Mobile App 1.131.3 build 201 ### Platform with the issue - [x] Server - [ ] Web - [x] Mobile ### Your docker-compose.yml content ```YAML non / Community app in unraid ``` ### Your .env content ```Shell non / Community app in unraid ``` ### Reproduction steps 1. Backup from iOS with a file with incorrect date ### Relevant log output ```shell [Nest] 273 - 04/22/2025, 6:18:37 PM ERROR [Api:AssetMediaService~3ga3hkkl] Error uploading file PostgresError: date/time field value out of range: "0000-12-30T00:00:00.000Z" PostgresError: date/time field value out of range: "0000-12-30T00:00:00.000Z" at ErrorResponse (/app/immich/server/node_modules/postgres/cjs/src/connection.js:790:26) at handle (/app/immich/server/node_modules/postgres/cjs/src/connection.js:476:6) at Socket.data (/app/immich/server/node_modules/postgres/cjs/src/connection.js:315:9) at Socket.emit (node:events:524:28) at addChunk (node:internal/streams/readable:561:12) at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) at Readable.push (node:internal/streams/readable:392:5) at TCP.onStreamRead (node:internal/stream_base_commons:191:23) at TCP.callbackTrampoline (node:internal/async_hooks:130:17) ``` ### Additional information _No response_
Author
Owner

@bo0tzz commented on GitHub (Apr 22, 2025):

Please post in the existing issue.

@bo0tzz commented on GitHub (Apr 22, 2025): Please post in the existing issue.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: immich-app/immich#5871