[Feature request] Room state database integrity check

[matrixbot]

This issue has been migrated from #12489.

---

Description:

A background (and/or admin-submittable) task that will walk state groups, outliers, and other calculated information of relevant rooms, and validate it.

This will then rewrite, fetch, deny or invalidate any incorrect state, and tolerantly rebuild a state group table for a particular room.

Reasoning:

This would be a “last resort” button for administrators to push, to fix any inconsistencies in their database.

(Hypothesis) It could possibly also work with state resets, “revalidating” a room, or provide insightful information about some internal fault or bug that would lead to state resets.