After updating to the latest version of Discourse we now have a strange issue with ngix posting error 502. Some users get Error 502 when posting, some don’t. Some profiles get 502, some don’t. CPU usage is around 10 to 25%, RAM usage is about 20% as well. I tried disabling our 5 plugins, same result. What logs do I look at to find out what is producing these 502 errors?

You can check the postgres version at /var/discourse/shared/standalone/postgres_data/PG_VERSION – If you did a command line upgrade, it’s possible that it did the upgrade and you didn’t notice (but you’d have to have run the rebuild twice). If you upgraded from the web interface, you should probably go ahead and do a command line rebuild if your OS and docker are recent versions.

Looking in I /var/log/nginx/error.log I seem to randomly get a lot of these, which produces the 502 I assume. Its just timing out or what? 2025/04/29 18:11:50 [error] 617#617: *419 upstream prematurely closed connection while reading response header from upstream, client: , server: _, request: "POST /posts HTTP/2.0", upstream: "http://127.0.0.1:3000/posts", host: "forum.domain.com", referrer: "https://forum.domain.com/"

What was the version prior to the update?

Really old, like a year old or more. Is there a log somewhere I can see what I upgraded from?

Also getting some of these *2 connect() failed (111: Connection refused) while connecting to upstream, ... upstream: "http://127.0.0.1:3000/message-bus/92fd28cbf742... It seems random, suddenly everything is fast and I can post again, and then it goes slow and 502’s start popping up again.

Looking inside the postgres/current log 2025-04-29 18:48:24.709 UTC [1746] discourse@discourse LOG: duration: 606789.911 ms execute : SELECT COUNT(*) FROM "posts" WHERE "posts"."deleted_at" IS NULL duration: 606789.911 ms We do have a lot of posts, few users.. why is it using 600k ms on this?

Might it be problems with indexing or such, that makes the queries slow?

I selected the discourse table in postgres and did a REINDEX DATABASE discourse; in the hope of that making things faster. I assume it will take a very long time.

Did you follow the advice in PostgreSQL 15 update? You might also vaccuum the database.

I did not, I do have the postgres_data_old folder (Albeit in a different directory than in that post). But then the post goes to say; “If you are running a setup with a dedicated data container”, which I assume means postgre is running in a dedicated Docker container? Ours run in the same instance as the forum. So not sure how to progress from there doesn’t seem to be a “if not then” clause? Does the prescence of the folder means the conversion was okay or?

[图片] pfaffman: /var/discourse/shared/standalone/postgres_data/PG_VERSION Verson is 15. It seems things are a lot better after I ran the vaccuum command. Posting works fine and seems to be fast, but when admin try clicking user profiles, go into their profiles, it still 502’s, time out it seems like? Is there something I can do to speed up that portion of the db?

升级到最新版本后出现502 Bad Gateway

产品支持

pfaffman (Jay Pfaffman) 2025 年4 月 29 日 19:39 10

您是否遵循了PostgreSQL 15 更新中的建议？您也可以对数据库进行 VACUUM 操作。

话题		回复	浏览量
Discourse Install 502 Bad Gateway Self-hosting	7	344	2026 年2 月 14 日
Is there a step by step diagnostic for when a Discourse site is found in a 502 Bad Gateway? Self-hosting	8	755	2024 年3 月 30 日
"502 bad gateway" Nginx Error Self-hosting	3	4371	2017 年1 月 11 日
Brand new install, shows only "502 Bad Gateway" Product Support	2	153	2025 年3 月 17 日
502 bad gateway Self-hosting	4	1081	2024 年1 月 29 日

升级到最新版本后出现502 Bad Gateway

相关话题