Follow

Admin stuff, mastodon software upgrade, boosts OK 

OK, getting this weird error when trying to rails db:migrate

'ERROR: relation "index_accounts_on_username_and_domain_lower" does not exist'

and well, yes it doesn't

Didn't do anything with that though and did all version upgrades as far as I know, so anyone knows what's the issue?

· · Web · 1 · 6 · 2

Admin stuff, mastodon software upgrade, boosts OK 

OK, apparently a 2017 migration adds it and a 2018 migration deletes it and now a 2020 migration tries to rename it

WTF am I apparently the only one running into this issue???

Show thread

Admin stuff, mastodon software upgrade 

OK, looks like I might have to take down this instance for some hours, in the future and sift through the database,

We have a couple duplicate entries, that prevent us to migrate past upstream 3.1.5

Somehow migrations f@&#!% up two years ago and it bites me in the butt now.

Show thread

Admin stuff, mastodon software upgrade, boosts OK 

@maxine I ran into the opposite issue the other day, it shrieking about that entry already existing and refusing to continue, so I think someone royally cocked up there somehow.

Admin stuff, mastodon software upgrade, boosts OK 

@Jo Oh, yeah I found the line and "fixed it" (commented out the unnecessary rename, because the index will be created next line)

Well, and now I'm hit with duplicate account errors.

This is going to be some work to get to 3.2.0...

Admin stuff, mastodon software upgrade, boosts OK 

@maxine Server admin is fun, ain't it. :blobupsidedown:

Admin stuff, mastodon software upgrade, boosts OK 

@Jo it usually is, if not someone fucks up code *grumbles*

Admin stuff, mastodon software upgrade, boosts OK 

@maxine @Jo this is 100% bad design and maintenance

From having local accounts have a null domain to making schema changes that break upgrades to patching that consequence of null domain names without dealing with the underlying issue, it’s just,,

Finding the duplicates should be easy enough, but cleaning them up won’t be pretty

Admin stuff, mastodon software upgrade, boosts OK 

@skipsageneration @Jo I did a check and at least it's only 9 accounts, I have to manually deal with.

Still gonna take some time to look through it, to minimize further damage

re: Admin stuff, mastodon software upgrade, boosts OK 

@maxine nah I ran into the same issue at one point. It's bullshit. I think I backed up the db and tried to fix it manually.

Sign in to participate in the conversation
Mootech

Small, friendly instance for friends. Come join us and be cute and soft and small and cute.