The site may be down within the period of 1-3am ET for maintenance
Doing another round of maintenance to fix some issues related to posts
It might only be down for a bit within that window but im giving myself two hours in case some things take longer than I expect
You're viewing a single thread.
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
Then I generated sql statements to remove duplicate posts that had higher ids than the other posts theyre a duplicate of
i assume this was done after updating the other tables referencing this table, such as comments, votes, saved posts, as previously discussed on matrix?
while it may be omitted here for simplicity, it can be dangerous to not mention that for others that might find this in the future if they experience index corruptions on their own if they don't fix all references, as that would result in data loss.
No votes or comments were connected to the duplicates but yeah if there was some you would move it over to the other one
The posts that had comments were the posts that were uniquely on the other community and those moved over with the post when I updated the community of the post
Well done