And I’m back. Whew, that was a rough upgrade. I had to do some manual PostgreSQL surgery to get it past 0.19.3 - there were two versions of the hot_rank function so the migration script was failing.

Then I noticed the logs were full of pictrs spitting out “Read corrupted data…” and crash looping, and I spent a couple of hours trying to get it to do anything. I finally had to give up and nuke it, so I guess the few images I’ve posted over the years are 404s now.

I started to get discouraged and I was going to just decommission the server, but I’ll try to learn my lesson and keep a closer eye on it so I can catch future problems before it’s too late.

Thanks very much!

I didn’t realize it was outdated; I get emails from Elestio regularly (including just this week) that it was automatically updated to the latest version. Apparently I forgot (it’s slowly coming back to me now) that at some point something broke on an upgrade and I must have pinned the version back in early 2024.

I just tried to move it forward and unfortunately, anything after that version breaks with a failing schema migration (maybe the same problem I had back then). I restored a backup for now and I’ll figure out how to fix it over the weekend.

I appreciate the assistance and info.

Hot damn do I love gloves. I bought a 5000-count case five years ago and I’m just about out of them. Turns out making it easier to touch icky things like the sink strainer was well worth the $50.

The part of my brain that needs to be interested in something to do it is actually very stupid and easily tricked. Sometimes when I’m stuck all I have to do is literally pretend I find the work engaging.

Nah, it’s not as bad as Linux.