My HS has accumulated thousands of unreferenced state groups
Author: richvdhCreated Jun 7, 2018Updated Dec 7, 2023
Labelsz-p2A-Disk-SpaceS-MinorT-DefectA-Databaseroadmap
... which are filling up my disk :(
To check if you are also affected, run this query:
select count(*) from state_groups sg
left join event_to_state_groups esg on esg.state_group=sg.id
left join state_group_edges e on e.prev_state_group=sg.id
where esg.state_group is null and e.prev_state_group is null;if you see numbers in the thousands, then it is this issue. Otherwise, you're not affected by this issue.
Source: matrix-org/synapse