Chat

234 readers

1 users here now

General chat about anything at all

founded 2 years ago

MODERATORS

mrmanager

New update is slower? (self.general)

submitted 11 months ago* (last edited 11 months ago) by 1984 to c/general

36 comments fedilink hide all child comments

It feels like the new update is slower than before. Anyone else noticed this?

Could be temporary maybe, or something that will be fixed in a update.

But i get timeouts loading pages even, and that never ever happened before.

you are viewing a single comment's thread
view the rest of the comments

[–] tal 2 points 11 months ago* (last edited 11 months ago) (1 children)

Hmmm.

A couple thoughts:

As I commented above, this doesn't appear to be impacting every 0.19.1 instance, so there may be something on lemmy.today that is tickling it (or it and some other instances).
If you decide that you want to move back to 0.18.x, I have no idea whether lemmy's PostgreSQL databases and stuff support rolling back, while continuing to use the current databases, whether there were any schema changes in the move to 0.19.x or whatever.
Something that also just occurred to me -- I don't know what kind of backup system, if any, you have rigged up, but normally backup systems backing up servers running databases need to be aware of the database, so that they can get an atomic snapshot. Like, if you have something that just backs up files nightly or something, they may not have valid, atomic snapshots of the PostgreSQL databases. If you do attempt a rollback, you might want to bring all of the services down, and only while they are down back up the PostgreSQL database. That way, if the rollback fails, it's at least possible to get back to a valid copy of the current 0.19.1 state as it is in this moment.

If all that's old hat and you've spent a bunch of time thinking about it, apologies. Just didn't want a failed rollback to wind up in a huge mess, wiping out lemmy.today's data.

[–] mrmanager 2 points 11 months ago (1 children)

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.

[–] tal 1 points 11 months ago* (last edited 11 months ago) (1 children)

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.

[–] mrmanager 2 points 11 months ago

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...