Current status of Friendica.World (lemmy.world)

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

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

[-] [email protected] 2 points 1 month ago

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

[-] [email protected] 1 points 1 month ago

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

[-] [email protected] 1 points 1 month ago

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

this post was submitted on 30 May 2025

8 points (100.0% liked)

Friendica.World status, support and issues

105 readers

1 users here now

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

founded 2 months ago

MODERATORS

[email protected]