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.
Update 08-10-2025
Two updates:
- We've planned the db migration for this Saturday Oct 11th.
- A PR is ready which fixed the issue with the S3 addon for the Friendica update. We've tested this fix on the Dev instance and it works. Once the PR is merged and the docker image updated, we can upgrade prod.
Update 04-11-2025
The database has been migrated to the larger server, and today we also rescaled the 2 app servers to a larger plan, so they have double CPU and RAM.
Can you explain? What picture, and biased how?