He tends to dawdle away his time and accomplish nothing.

  • 2 Posts
  • 5 Comments
Joined 2 years ago
cake
Cake day: July 12th, 2023

help-circle
  • 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.