Hi everyone, we’re trying to troubleshoot the issues our Discourse installation has been having in the last few days. We’re running a Contabo cloud vps, 8 cores/32gb/nvme, for a userbase of ~150 people; we’ve had few issues in the last 2 and a half years. Since last weekend, the instance is having…

[圖片] char: This is definitely a memory issue: I’m seeing some huge queries here. Have you rebooted recently? It looks like there are a bunch of idle postgres processes eating a bunch of memory, I think. How much memory did you give postgres in your app.yml? Did you change the defaults? Als…

From my experience, this kind of CPU behavior is more likely caused by a server infection or security issue, rather than Discourse itself. I’ve run into a similar situation before, and replacing the server eventually solved the problem.

In my opinion, migration is probably necessary. You could set up a new server and install Discourse to test it—if everything runs normally, there’s a high chance the issue is caused by a server infection or security problem. Also, may I ask whether this server has been regularly updated? Has it bee…

This wasn’t in my bingo card, to be honest. We’re on Ubuntu Server 22, there are some minor updates to do, it won’t hurt to force an upgrade now anyway. Let’s see what happens.

[圖片] char: This wasn’t in my bingo card, to be honest. We’re on Ubuntu Server 22, there are some minor updates to do, it won’t hurt to force an upgrade now anyway. Let’s see what happens. My concern is that upgrading now may not completely eliminate any malware that already exists in the sy…

There seems to be no malware, we ran chrootkit and rkhunter and there are no rootkits, no malware. As an information, the server is not a homelab, it is a Contabo VPS, and it only hosts a Discourse container and a Prometheus/Grafana container. The situation has gotten even worse since yesterday, t…

[圖片] char: Is there any kind of “low intensity” setup wrt stat recalculation? I’m still looking at Sidekiq and I’m not seeing any specific pattern in the job names, it seems any process is at a risk of taking >2 seconds. I’m starting to think looking at the scheduler isn’t very helpful. Tha…

Sadly, that isn’t a course of action we can take right now. It’s not out of the question, but if we choose to undergo this it will mean we’ll consider other hosting options as well -a choice that will take long. Anyway, we’re trying to understand another key metric. Grafana and Prometheus are worki…

One last tidbit of information, then I think I’ll be out for a few hours. root@discourse_app:/# ps aux --sort=-%mem | head -20 USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND postgres 4398 17.0 22.0 8216352 6797764 ? Ss 11:14 9:53 postgres: 15/main: discourse d…

Have you tried tweaking the postgres memory settings? If moving to a new vm would fix anything, it’s not a big deal and can be done with zero downtime and just a bit of read only time.

Yes, we already did once because we had a kinda similar issue - it was clearly Postgres running out of memory. This time, the symptoms are different - this doesn’t mean we’re excluding the possibility of having a similar issue, though. Right now many clues point to having some thread structures be…

异常高的 CPU 使用率

支持安装

pfaffman (Jay Pfaffman) 2026年二月7日 13:47 22

您尝试调整过 postgres 的内存设置吗？

如果迁移到新的虚拟机能解决任何问题，那也不是什么大问题，可以在零停机时间和一点点只读时间的情况下完成。

話題		回覆	觀看
Discourse installation has been getting slower and slower and slower Self-hosting server-resources	36	2048	2023年四月15日
Due to extreme load, this is temporarily being shown to everyone... when it's not really the case Self-hosting server-resources	19	1954	2023年七月21日
Discourse Docker HW reserved/used (CPU, RAM, Disk) and how to manage it Self-hosting server-resources	5	955	2023年五月16日
Memory creep in last couple of updates Self-hosting hosting	27	3058	2019年五月21日
High CPU & Disk Usage After Restore from a Failed Update Self-hosting	14	1016	2024年三月30日

异常高的 CPU 使用率

相關主題