Replies: 4 comments 2 replies
-
Please check your database logs. An SQL query cannot crash the immich server unless Postgres is badly damaged. |
Beta Was this translation helpful? Give feedback.
-
You say "the server crashes" without any further detail. Please post logs, error messages, whether the containers are going down or restarting, etc. |
Beta Was this translation helpful? Give feedback.
-
After rebuilding database from scratch, still see server resetting (exiting and starting again) consistently. Sample log file: Logs are on verbose. After exiting, docker restarts and a few minutes later same thing happens. |
Beta Was this translation helpful? Give feedback.
-
Hello, i am having similar issues: uploading photos caused immich_server to crash completely and it even crash my entire docker cluster. |
Beta Was this translation helpful? Give feedback.
Uh oh!
There was an error while loading. Please reload this page.
-
I have searched the existing issues, both open and closed, to make sure this is not a duplicate report.
The bug
Bug is identical symptoms to #9694 and shows the same in log. However, when I try to run the suggested sql queries, the server crashes
sql -t -U postgres immich -c "select "originalPath" FROM assets WHERE id = '31c1ab4f-21e2-4683-b221-8839daf357ec'"
or even
psql -t -U postgres immich -c "select "originalPath" FROM assets"
The OS that Immich Server is running on
Ubuntu 22.10
Version of Immich Server
v1.132.3
Version of Immich Mobile App
v1.132.3
Platform with the issue
Your docker-compose.yml content
Your .env content
Reproduction steps
...
Relevant log output
Additional information
No response
Beta Was this translation helpful? Give feedback.
All reactions