502 错误 - 可能是因为调整浏览器窗口大小

zogstrip · 2025 年12 月 29 日 17:43

在聊天组序列化器中，有一个错误的查询被用来返回启用了聊天的用户数量，这在您的账户上大约需要 30 秒，超出了我们托管的请求超时时间（这就是您“随机”收到它的原因）。

github.com/discourse/discourse

PERF: Use SQL COUNT for chat_enabled_user_count in group serializer

main ← fix-chatables-timeout

opened 05:40PM - 29 Dec 25 UTC

ZogStriP

+8 -1

When searching for `chatables`, groups matching the search term are serialized. …The serializer was computing `chat_enabled_user_count` by loading **ALL** users from each group into memory and iterating through them in Ruby: ```ruby object.human_users.count { |user| user.user_option&.chat_enabled } ``` On large sites, groups like `trust_level_0` can have tens of thousands of users. This caused serialization to be extremely slow, potentially hitting request timeouts and resulting in 502 errors. The fix uses a SQL COUNT query instead, which completes in milliseconds. The result is also memoized since `can_chat` calls `chat_enabled_user_count` internally. Ref: https://meta.discourse.org/t/392286

话题		回复	浏览量
Users can initiate chat with unprivileged users Bug chat	9	364	2024 年3 月 9 日
Query causing 400% CPU Load Bug chat	25	1097	2024 年3 月 29 日
In chat, moderators group appears to have 22 members when it only has 8 Bug chat	7	129	2025 年4 月 21 日
Introducing Discourse Chat (BETA) Announcements chat , new-feature	149	26112	2022 年8 月 3 日
Chat unusable after update Support	1	189	2024 年6 月 8 日

502 错误 - 可能是因为调整浏览器窗口大小

相关话题