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

zogstrip · 2025年十二月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	8	455	2024年三月5日
Chat Pitchfork timeouts: replies silently create threads and auto-tracking bloats over time Bug chat	1	153	2026年四月21日
Query causing 400% CPU Load Bug chat	24	1564	2024年三月28日
In chat, moderators group appears to have 22 members when it only has 8 Bug chat	5	246	2025年四月21日
Introducing Discourse Chat (BETA) Announcements chat , new-feature	142	28531	2022年八月3日

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

相關主題