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

ruud@lemmy.world

Current status of Friendica.World (lemmy.world)

submitted 4 months ago* (last edited 2 days ago) by ruud@lemmy.world to c/friendicaworld@lemmy.world

11 comments fedilink hide all child comments

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.

all 12 comments

sorted by: hot top controversial new old

[–] ankorage@scribe.disroot.org 1 points 6 days ago (1 children)

Good morning. What is the current status of the active research and mitigation of the performance issues? Timeouts are still encountered, even with the Tip in use. The tip is not a solid WO, so it effectively doesn't really exist as timeouts still do occur, albeit less frequent.

Thank you. Much appreciated.

[–] ruud@lemmy.world 1 points 5 days ago

I will put an update in the post. Thank you!

[–] ano@lemmy.world 4 points 4 months ago (2 children)

Rooting for you! Friendica is by far my preferred way of accessing the Fediverse – and it seems .world is the largest European server on the whole platform, so I really need it to work, aaaaa

[–] ruud@lemmy.world 4 points 4 months ago

Thanks! We're doing our best. But we also need the github issues solved by the devs. Or others with programming skills

[–] Sunshine@lemmy.dbzer0.com 1 points 3 months ago

I really like the local feed! I miss it already.

[–] eve@evenyc.com 2 points 1 month ago* (last edited 1 month ago)

Is this still ongoing? I’m still having problems accessing it

[–] Jerry@feddit.online 2 points 3 months ago (1 children)

My instance only has 387 users, but these queries plague mine as well, locking tables for very long times, causing huge stalls.

[–] heluecht@pirati.ca 1 points 3 months ago (1 children)

@Jerry In the RC/Develop there is the fix that changes one of the ugly queries. Also it contains a coding to prevent executing long queries when another long query is running.

[–] Jerry@feddit.online 1 points 3 months ago

This is great! Can't wait for the new release! Thanks.

[–] n816Life@lemmy.world 1 points 3 months ago (1 children)

Are there some other friendica based sites experiencing similar problems ?

[–] ruud@lemmy.world 1 points 3 months ago

Not really, there are no Friendica sites with this many users...