Sites back, communities that previously had their community page not vieweable are now viewable
An example of this is https://programming.dev/c/a11y
Basically what I did was before the maintenance exported every single post in the post table and use a js script to check for duplicate ap_ids (checking using sql itself didnt work due to broken indices so it was always missing some). Then I generated sql statements to remove duplicate posts that had higher ids than the other posts theyre a duplicate of. Ran all those during maintenance and since all duplicate ap_ids were removed I could now reindex the table to fix the broken indices
Did the same for communities after the posts (but also did some statements to move posts from one version of the community to the other)
Site might be slow for a tiny bit as it processes the 2 hour of activities that were generated while it was down