The discussion revolves around Server Performance Issues Due to High CPU Usage. chulapo initially reported random issues with users being unable to post or create topics, which seemed to be related to high CPU usage on the server. The issue occurred every hour, coinciding with a specific postgres command running.
After upgrading the server, the issue was minimized, but the same errors still occurred every hour chulapo. Erzgebirge shared a similar experience, with a “502 error” appearing almost every hour.
Andrew_Rowe suggested that a recent upgrade might be the cause and shared links to threads discussing high CPU usage. Erzgebirge confirmed a recent upgrade and thanked Andrew_Rowe for the threads.
The issue was eventually identified by chulapo as being caused by the Discourse reactions like sync setting. A potential solution is to disable this setting, as discussed in a related thread.
I’ve received some complaints from users who occasionally can’t post or create topics. This issue seems to occur randomly, but it may be related to high CPU usage on the server.
Here’s a snapshot from htop showing the CPU usage during one of these spikes.
Could this be a memory or CPU limitation on the server? If anyone has insights into diagnosing or resolving this, I would greatly appreciate your help. Thank you in advance!
However, the sames errors still occur every hour while the postgres:13/main: discourse discourse [local] UPDATE command is running, which corresponds to the spikes in the chart.
Does anyone have suggestions on what might be causing this and how to resolve it?
We have identified the issue. It was caused by the Discourse reactions like sync setting. I don’t know if there is a way to avoid it other than disabling it.
