-
-
Notifications
You must be signed in to change notification settings - Fork 641
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[BUG] System freezing after attachment download #1042
Comments
I've seen similar reports before, but I honestly don't know how to reproduce. I've hosted Fider for 5 years and I never seen that issue. |
Unfortunately it's quite random :( I have an automatic restart when it freezes and I got more than 50 restarts in a few months. I don't think my users are doing anything special, it's mostly PNG screenshots as attachments. |
Hello, I'm having the same problem. It seems to be random and always when displaying images. I can reproduce sometimes using a specific topic with some PNG attachments and then refreshing the entire page with the cache disabled.
|
When that happens, could you please check if there are any open transactions on Postgres? I believe this could be connection exhaustion, but it'd be useful to have more data. |
I'm almost sure it's not connection exhaustion because I have another app using the same database (so a shared max connections) and it doesn't have connection pool issues. |
Fider has its own connection pool, that's the one I think could be exhausted. You could also try increasing the pool to see if this reduces how often it happens Line 63 in d107cbb
I suspect this could be the reason because I only use S3 to store attachments. |
@goenning I managed to catch the pg_stat_activity table when the issue happens and I have 4 opened connections in the "idle in transaction" state and query |
Nice one! Thanks for now! |
Fider Cloud or Self Hosted
Fider self hoster 0.19.1
Describe the bug
Each time a user downloads an attachment through the
static/images/attachments
endpoint any following HTTP request hangs and timeouts with abegin_error
error in logs (nothing else). The only way to fix that is by restarting the app.I disabled SQL logs thinking it would be somehow linked but it didn't solve the issue.
The text was updated successfully, but these errors were encountered: