Meta (slrpnk.net)

678 readers

23 users here now

Here we can discuss anything about this Lemmy instance/server itself.

Our XMPP support chat: Movim or XMPP client.

Please also refer to our Wiki

founded 3 years ago

MODERATORS

[email protected]

Scheduled downtime of Lemmy instance for database maintenance (postponed) (slrpnk.net)

submitted 2 months ago* (last edited 2 months ago) by [email protected] to c/[email protected]

2 comments fedilink hide all child comments

Edit: postponed by one week most likely.

I might have identified the cause of the occasional stalling that you likely noticed when using this Lemmy instance.

It seems that during one of the previous migrations and restoring the database from a backup the noCoW flag on the database files was reset and this causes slowdowns on a btrfs file-system specifically for databases.

To fix this we need to recreate all the database files with this flag set, which requires a somewhat longer down-time, maybe 3 hours or so.

While doing so we can also do a database vaccuum and upgrade to Postgres 17, so even if this turns out not to be the real cause of the stalling we would still get some benefit from it.

top 2 comments

sorted by: hot top controversial new old

[–] [email protected] 9 points 2 months ago

Thanks for your ongoing hard work!

[–] [email protected] 2 points 2 months ago

I have made the same error with my btrfs file sytem!