i feel like i'm starting to go over my head with reverting these database migrations. it feels like i'm trying to un-tangle a heavily tangled bundle of cables, except the entire thing's in a black box apart from a number of the ends of cables sticking out that feel like they're only increasing in number.

i'm restoring from backup and undoing the changes. i'll need to figure out a better way to do this.



Don't you love it when you try to test federation, federation fails, and the error message you get is about as generic as you can get? :V



Show thread




apparently i can hold back actually upgrading the cluster until i'm ready

and i'm not ready yet

Show thread

ffs i didn't realize when i decided to update my main server, postgres was suddenly going to decide it was going to do a major version update x.x

just realized I haven't figured out dinner yet

Gonna do that, then probably going to start streaming
Sooo expect me to start that in about 25-30ish minutes

Thinking about doing some more randomized and wingding-ified Pokemon Sword streaming pretty soon

Partially because I realized just how long database migrations take and I want to do something while I wait lol

Also I think I managed to fix going into max raid battles, although it came at the cost of de-randomizing the support trainers... Honestly the randomizer should fix the fact that trainers can be randomly given non-existent pokemon

Why does postgres take so long to create indexes i swear

the h in holly stands for kissing on lesbiabs actually

the federating issues on my main instance are getting intolerable, and i have no idea what's causing them... .-.

update: not doing that because I'm 99% sure I'd just have to have everything re-analyzed and whatnot to account for the fact it's on a server with an NVMe drive and not a shared HDD

That and have to do school and whatnot and by the time I come back it'll be about the 4 hour range anyways and I might as well wait it out

Show thread

Y'know what? I wonder if I could do this faster by just... copypasting the data directory wholesale.

Show thread

The most depressing part? It did take as long to perform the migration.

Show thread

Fuck, it went most of the way through the migration and failed on a tiny thing near the end, so it threw away everything

Show thread

Alright I came up with a good idea that'll let me sleep without waiting for this to finish first

I've got it set up so that it should automatically start the instance back up once the database import completes. ...At least, it should start back up properly

Also I realized old remote posts weren't being pruned so I did that, and the resulting database backup was less than a gigabyte from the, like, 20 GB size it was

Soooo I should prune old remote posts more, and this import shouldn't take, like, 5-6 hours, knock on wood

Show thread

Alright, I'm at the point in this migration where the only thing I'm waiting on is for the database files to finish being imported

This time, however, the instance is going to be running on a server with an NVMe drive, soooooo at least while it's on this temp server, the hard drive won't be throttling anything

huh. apparently there are "hacking music" albums on youtube. just what i needed

Show more

The social network of the future: No ads, no corporate surveillance, ethical design, and decentralization! Own your data with Mastodon!