this post was submitted on 30 May 2025
10 points (100.0% liked)

Friendica.World status, support and issues

122 readers
1 users here now

This community is for status, support and issues on the Friendica.World instance

founded 4 months ago
MODERATORS
 

At this moment, friendica.world is not stable. You can experience 504 or 503 errors, or just be unable to load the site.

This is being worked on. We'll keep track of the currently known issues in this post.

Database query tuning

One of the main issues at the moment is the database hanging with many inefficient queries running for minutes or even hours. Most of them are using an inefficient 'NOT IN' or similar construction. We've created an issue for that here: https://github.com/friendica/friendica/issues/14947

Also we've created an issue for many updates to a key-value table: https://github.com/friendica/friendica/issues/14948

Update 30-06-2025

The beforementioned issues were closed, we'll upgrade to 2025.07-RC in order to get the latest fixes and do troubleshooting from there. We'll send the slow qeury logs to the devs.

Update 03-10-2025

It has been a while, so here's a long overdue update. In the last update I mentioned installing 2025.07-RC, which we did in test. But we noticed it broke the media (S3 plugin).
This issue has been raised, and it seems it has been fixed but not yet pushed (see https://github.com/friendica/friendica/pull/15158#issuecomment-3289713892). Looks like it's close. If this has been fixed, we can re-try installing the update on test, and if it works, on prod.

We're now looking into another issue, which is the diskspace running out. Partly because of performance issues with cleanup jobs, the database is growing very rapidly. And as this is a physical server, we can't easily extend storage. So we're looking into options to extend the space without introducing a big extra cost.

Update 05-10-2025

We have ordered extra disks for the DB server.

Update 06-10-2025

Apparently this server only had room for 1 extra disk. We need 2 extra disks, so we can mirror them. We now decided to get a 'new' auction server for Friendica's database, with more disk. The server we ordered also has more CPU cores and RAM so that's a bonus.

We'll migrate the database soon, and will announce the downtime here.

you are viewing a single comment's thread
view the rest of the comments
[โ€“] convene_depth@lemmy.ml 2 points 3 months ago (1 children)

Do you have a test instance to check whether the recent change does help?

[โ€“] ruud@lemmy.world 2 points 3 months ago

Yes we do, but it doesn't have the users.. so it can't really be compared.