投稿内容でバッジSQLがトリガーされました

zogstrip · 2026 年 2 月 10 日午後 2:32

残念ながら再現できませんでした

その上で、バッジの付与を妨げる可能性のある BadgeGranter のバグをいくつか見つけました。

github.com/discourse/discourse

FIX: improve badge granter resilience (#37674)

main ← fix/badge-granter-resilience

opened 02:21PM - 10 Feb 26 UTC

ZogStriP

+51 -2

Two issues were found in BadgeGranter that could prevent badges from being grant…ed. First, `Array#compact!` returns `nil` when no elements are removed. For PostAction triggers, `[post_id, related_post_id].compact!` returns `nil` when `related_post_id` is present (nothing to compact), causing the post_ids payload to be silently lost. Using `compact` instead always returns the array. Second, `process_queue!` had no error isolation between badges. A single badge with a broken SQL query would raise an exception and abort processing of all remaining badges in the queue. Since queue items are already popped from Redis at that point, they are lost. Each badge is now rescued individually so one failure doesn't block the rest. https://meta.discourse.org/t/394444

マージされたら、アップグレードしてもう一度試してみてはいかがでしょうか？

トピック		返信	表示
Badges for posting Data & reporting sql-triggered-badge	4	394	2024 年 8 月 27 日
Creating triggered custom badge queries Site Management badges , how-to , sql-triggered-badge	0	12681	2014 年 8 月 27 日
Need some Help with my Triggered Custom Badge Query Support sql-triggered-badge	3	44	2026 年 2 月 5 日
Creating Custom Badges and Triggers Data & reporting sql-triggered-badge	0	1656	2020 年 8 月 8 日
Badge not working Data & reporting sql-triggered-badge	4	1447	2024 年 6 月 8 日

投稿内容でバッジSQLがトリガーされました

関連トピック