Post by @xrobau@mastodon.au

2026-09-20 01:47 UTC

Sorry #MastodonNZ but there is a good chance I'm going to have to do a complete database dump and restore, as there's still some bits of corruption left over from the crash the other day. This is probably an hour or so outage. I'm actually not even totally sure that #PostgreSQL will even restart properly when I shut it down. More information will be in this thread (so you can look at it on #MastodonAU directly via the web interface.)

Replies (4)

@xrobau@mastodon.au 2026-09-20 02:42

So far it looks like ONLY the 'status_stats' table is corrupt. This is not a critical table, and fingers crossed I can just skip the bad bits and re-import it. #MastodonNZ

Open ##4772935
@xrobau@mastodon.au 2026-09-20 06:50

The good news is that it looks like it is only the status_stats table that is messed up. I've ALMOST finished a complete raw dump of the db (which takes an hour++) to confirm it's just that table. After it's all safely backed up, I'll write some scripts to rebuild it all and we HOPEFULLY shouldn't need a long outage #MastodonNZ

Open ##5020330
@BobLefridge@mastodon.nz 2026-09-20 01:51

Thanks for the heads up Rob. Good luck with the database wrestling. For NZ users, here's this thread but on the AU server. https://mastodon.au/@xrobau/117300844625946496 @xrobau@mastodon.au

Open ##5020332
@kerravonsen@mastodon.au 2026-09-20 04:53

@xrobau@mastodon.au Do you know what caused the crash? (And thank you for keeping us informed!) (Yes, I am not a .nz user, but I'm still glad for your habit of keeping us all informed!)

Open ##5020333