this post was submitted on 21 Dec 2023
5 points (85.7% liked)
Chat
234 readers
1 users here now
General chat about anything at all
founded 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
I would like to roll back but the database schema changes would mean having to restore a backup. And potentially end up in more issues just like you were thinking too.
I guess it's best to wait for a fix, and I will also see if I can troubleshoot this myself a bit. I'm guessing it's a database issue since I can see very long running update statements on every restart, and they may not be able to complete for some reason.
Possibly relevant:
https://github.com/LemmyNet/lemmy/issues/4288
This was the bug for the original 0.19.0 federation problems, and admins are reporting problems with 0.19.1 there as well.
The lemmy devs reopened the bug four hours ago, so I'm guessing that they're looking at it. Not sure if you want to submit any diagnostic data there or whatnot.
Thank you, very good to know.
My idea was to try and see what specific query is failing in the database and go from there, so currently enabling logging of failed postgres queries. Hopefully see something in those logs...