Hi there, I’m seeing an issue on my docker install. It’s on Linode on Ubuntu 14.04. Postgres is using 100% of the CPU. The forum itself is working just fine, version v1.6.0.beta7 +156. Doesn’t seem any slower or anything. Here’s a screen capture from “htop”: [画像] Any pointers on how I can di…

Replying to my own post, because I realized my mistake :slight_smile: VACUUM VERBOSE ANALYZE only works if I select the discourse database, of course :slight_smile:

Are there any jobs running? Try opening the following URL for your site: /sidekiq

Doesn’t look like anything else is running. [画像] [画像] [画像] [画像]

Ok, there is one job in the “scheduler” tab that is running. Jobs::EnsureDbConsistency 41 minutes ago RUNNING -1ms _scheduler_localhost-app:29119:1:29c83b7cc82551f6a2b801e82a1acb38 [画像] Should I just wait that out? Seems like it’s checking the database?

To see exactly what queries are being executed you can run something like the following from the console: cd /var/discourse/ ./launcher enter app sudo -u postgres psql -c "select * from pg_stat_activity WHERE state='active'"; Try running this a couple of times with a 3/4 minute wait in-between, ca…

Ok, looks like it’s running 3 copies of this query (with 3 different pids) DELETE FROM user_actions USING user_actions ua2 WHERE ( user_actions.action_type = ua2.action_type AND user_actions.user_id = ua2.user_id AND user_actions.acting_user_id = ua2.acting_user_id AND user_actions.target_p…

Yes, you’ll need to let those queries run, because otherwise the scheduler will just keep spawning them and you’ll be playing whack-a-mole with them forever.

Do they start every x minutes or something like that? I currently have 5 of them running … Up from 3 a few hours ago.

Well, this morning we’re up to a load average of 12 :slight_smile: [画像] But it does appear to have moved on from the “DELETE” queries, and is running others. I assume this is some sort of database check. The forum is still responsive with this load, so I’ll let it proceed for a while. Seems a …

Are you running on our latest docker image? How many posts does your forum have?

Yes, I updated the docker image yesterday, which is when this started happening. I did git pull ./launcher cleanup ./launcher rebuild app ./launcher cleanup As for posts and topics, it has 17001 topics, with 178297 posts. They were imported from a phpBB install last year. Anyway, it eventually …

Postgres using 100% of CPU

サポートインストール

MiG 2018 年 8 月 25 日午後 5:34 17

自分の投稿に返信します。自分のミスを気づいたからです

VACUUM VERBOSE ANALYZE は、もちろん Discourse データベースを選択した場合にのみ機能します

「いいね！」 3

トピック		返信	表示
Postgres has 100% CPU for large databases, Discourse 2.7.7 Self-hosting server-resources	4	755	2021 年 8 月 30 日
Some queries that don't finish Support	18	943	2022 年 6 月 18 日
Primary Postgres database process (postmaster) eating all CPU Self-hosting server-resources	13	4112	2020 年 5 月 28 日
Slow Sidekiq + Postmaster using 95%+ CPU (32 cores) after Postgresql Version Upgrade Self-hosting server-resources	23	3014	2020 年 6 月 28 日
Unusually high CPU usage Self-hosting	32	490	2026 年 3 月 20 日

Postgres using 100% of CPU

関連トピック