4
Current status of Friendica.World (lemmy.world)
submitted 1 month ago* (last edited 2 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.

top 22 comments
sorted by: hot top controversial new old
[-] ano@lemmy.world 3 points 4 weeks ago

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

[-] Sunshine@lemmy.dbzer0.com 1 points 4 days ago

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

[-] ruud@lemmy.world 5 points 4 weeks ago

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

[-] convene_depth@lemmy.ml 2 points 2 weeks ago
[-] ruud@lemmy.world 3 points 2 weeks ago

Yes I saw. Looks like they only addressed the example query I provided, and not all 'NOT IN' queries.. looks like I have to submit an issue for every query I find.

[-] convene_depth@lemmy.ml 2 points 1 week ago

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

[-] ruud@lemmy.world 2 points 1 week ago

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

[-] Jerry@feddit.online 2 points 1 week ago

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 2 days 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.

[-] Jerry@feddit.online 1 points 2 days ago

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

[-] n816Life@lemmy.world 1 points 1 week ago

Are there some other friendica based sites experiencing similar problems ?

[-] ruud@lemmy.world 1 points 1 week ago

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

[-] convene_depth@lemmy.ml 1 points 1 week ago* (last edited 1 week ago)

There is squeet.me with 4,6k users: https://fedi.wrm.sr/instance/squeet.me comparable to the 4k users of friendica.world.

[-] ruud@lemmy.world 1 points 1 week ago

Ah I didn't know that one, they only have 80 mnthly active users though. I'll see if I can contact them

[-] heluecht@pirati.ca 2 points 2 days ago

@ruud @convene_depth It's one of my servers. The active users there are a lot of news bot accounts, besides some users. AFAIK the server runs quiet stable, but I had to tweak the database a lot to make it work.

Also there are some tweaks in the setting (like reducing the number of delivery retrials) to make the system work faster.

[-] ruud@lemmy.world 1 points 2 days ago

Maybe after I upgraded to the RC we could schedule some time to go over your tweaks together?

[-] heluecht@pirati.ca 1 points 2 days ago

@ruud We can try. I will be on the HOA until Saturday. Because of that I'm not sure how available I will be in that time.

[-] ruud@lemmy.world 1 points 2 days ago

Continuing this on Matrix.

[-] convene_depth@lemmy.ml 2 points 2 days ago

Now that 2025.07RC is out had you considered updating to that?

[-] ruud@lemmy.world 2 points 2 days ago

Yeah, I might as well. Normally I'm reluctant to install RC's but it can't get much worse ;-)

[-] convene_depth@lemmy.ml 2 points 2 days ago* (last edited 2 days ago)

Please give 2025-07RC a try as main dev was explicitly suggesting that.. And they were asking for Slowquery-log. Could you provide that after updating to RC?

[-] ruud@lemmy.world 1 points 2 days ago

Will do. Creating extra backup first before upgrade.

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

Friendica.World status, support and issues

85 readers
3 users here now

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

founded 1 month ago
MODERATORS
ruud@lemmy.world