I set up discourse on a instance that contains 8GB of memory and a quad-core processor on Microsoft Azure, and I run into HTTP 502 problems these days. Especially when there are about 200 to 300 registered users visiting at the same time, the server goes wrong with HTTP 502 error. The server logs s…

How was the server built? Did you use an image, or follow the cloud install guide ?

How big is your database? You should have enough ram to hold the entire database in cache. There are settings in the yml file for tuning memory usage. If you run discourse-setup it attempts to set them but you might need to tweak them. Were you running Discourse somewhere else with similar traffic…

[image] pfaffman: You should have enough ram to hold the entire database in cache. If it is a very large database, that advice changes to “most” of the database in cache. At least half.

i built the sever by following the guide

I have not tried to build another server, but when I switch the server’s ram to 4GB, things get worse.

What happens if you have 16gb of ram?

My purse would explode, I guess. :smile: What yml files do I need to modify to improve this situation ?

It’s impossible to tell with no information about the size or your database or how much traffic you have. If you run ./discourse-setup it will attempt to set the various memory tweaks sanely. or, you can read what’s in app.yml and do it by hand. There are other things you can do, like enable CDN a…

@pfaffman Thanks for your advice. I have set ‘db_shared_buffers’ to 4096MB in app.yml and rebuild. The problem seems to occur less frequently after making that change, but still remains unsolved. postgres=# select pg_database_size('discourse'); pg_database_size ------------------ 104335907…

At this scale I recommend dedicated PG resources, any reason you are not running your database on a dedicated instance or managed PG?

How to resolve HTTP 502 error?

Support

codinghorror (Jeff Atwood) February 14, 2019, 10:40pm 4

If it is a very large database, that advice changes to “most” of the database in cache. At least half.

Topic		Replies	Views
Discourse site with very large database gives error 502 frequently Support	10	1528	February 19, 2017
"Random" 502 Errors Self-hosting	4	618	June 26, 2019
Bursts of 502 Service Unavailable, pointers to debug Self-hosting	15	1809	February 18, 2018
502 error while opening some user profiles Bug	18	762	May 27, 2024
Forum giving 502 Bad Gateway Error Self-hosting	7	945	November 3, 2020

How to resolve HTTP 502 error?

Related topics