this post was submitted on 28 Oct 2023
23 points (100.0% liked)

Fedia Discussions

1 readers
5 users here now

founded 1 year ago
MODERATORS
jerry@fedia.io
23
We’re back (fedia.io)
submitted 11 months ago by jerry@fedia.io to c/fedia@fedia.io
12 comments fedilink hide all child comments
 

I spent an incredible amount of time over the past few days unf*cking the fedia.io database. It should be clean now and that should both dramatically improve performance and fix all or most all of the remaining error 500’s

top 12 comments
sorted by: hot top controversial new old
[–] MHLoppy@fedia.io 7 points 11 months ago

Thanks for going to so much trouble on your fedi services - it's nice to be home! ^_^

[–] offendicula@fedia.io 6 points 11 months ago (1 children)

Thanks so much for everything you do Jerry.

[–] jerry@fedia.io 3 points 11 months ago (1 children)

Thanks. I feel bad that it took this long to get here, though

[–] offendicula@fedia.io 5 points 11 months ago

Please don't! I'm in awe that you fit Fedia in with all the other things you run, and they aren't even your job. Thanks again.

[–] troed@fedia.io 5 points 11 months ago

Legend.

[–] jerry@fedia.io 4 points 11 months ago (1 children)

I am aware that visiting the notifications link gives an error 500. I will work on it.

[–] jerry@fedia.io 6 points 11 months ago

Ok, this problem is fixed now as well

[–] hitstun@fedia.io 2 points 11 months ago

Thank you! My 500 Server errors appear to be all fixed now. I'll try not to accidentally double post and then delete one of their thumbnails, if that still causes the error.

[–] realslef@fedia.io 1 points 11 months ago (1 children)

Are the dropship-marktplatz image links also gone?

[–] jerry@fedia.io 3 points 11 months ago

They should be. I’ve not seen any since I changed the nginx config the prevent that domain from pointing to the mbin instance.

[–] ciferecaNinjo@fedia.io 0 points 11 months ago (1 children)

Was there any data loss? The comments tab of my profile only shows 11 comments which only go back 1 week (perhaps to around this “we’re back” thread). I should have much more than that.

[–] jerry@fedia.io 2 points 11 months ago

As part of the database clean up, I had to remove many corrupt records, so the answer is yes there are missing posts and comments, however I do have backups have I have been attempting to find ways to reinsert them without recreating the problems. I’ve not had much luck with that yet.