When a message is flagged as spam/offensive, network wide 10k users are shown a number of pending chat flags.

Chat Flags

As shown in the above image, it is shown that there are 15 messages waiting for review. At the same time, there are no flags to display. If we hover on 15, it says

"flagged as spam/offensive"

Similar questions with a :
New messages flagged blue bubble does not go away
Chat prompts me to act on flagged messages, but there are no flagged messages to display

In those scenarios, they were blue dots but now, it is a number in the top bar.


1 Answer 1


There's a big pile of SQL that runs periodically to correct denormalized star, pin, flag, and mod-flag counts on messages and rooms. It has a bit of a special-case for deleted messages: they always get 0 flags, 0 stars, and 0 pins, thus avoiding the need to delete (or zero out) those associated votes when a message is deleted.

This update query was altered yesterday to...

  • ...be slightly more efficient
  • ...only run once per day

Unfortunately, the change omitted the special-case that ignores votes on deleted messages. And when it runs, it runs for all messages ever posted. So after yesterday's change, it started counting flags on deleted messages...

Fortunately, flags expire after a week, so this only revived flags for flagged, deleted messages from the past week. That's why the count wasn't much, much higher.

Nick patched up the query and ran it manually. Going forward, the counts should be corrected every day.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .