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

Friendica.World status, support and issues

86 readers
2 users here now

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

founded 1 month ago
MODERATORS
ruud@lemmy.world
5
Current status of Friendica.World (lemmy.world)
submitted 1 month ago* (last edited 3 days ago) by ruud@lemmy.world to c/friendicaworld@lemmy.world
22 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.

you are viewing a single comment's thread
view the rest of the comments
[–] Jerry@feddit.online 2 points 1 week ago (2 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 days 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 days ago

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