Github Actions ist für friendica deaktiviert


!Friendica Developers

@Tobias ich glaub, dass GitHub actions für Friendica irgendwie deaktiviert wurde. Kannst du das prüfen?

Das ist @Michael 🇺🇦 und mir schon mal vor paar Wochen aufgefallen, dann ging's irgendwie wieder (dachte, dass das ein Hickup war)

Merci :)

in reply to Artur Weigandt

since we moved friendica-addons to git.friendi.ca , it isn't possible to add woodpecker to a SECOND git-server. That's why we let the mirror of the addons at github.com.

Possible ways:
1) we move friendica-addon back to github and the pipeline will work again
2) we create a second woodpecker instance (ci-git.friendi.ca) which will work only with git.friendi.ca and therefor with the addons
3) we migrate friendica to git.friendi.ca and switch the whole config of ci.friendi.ca to git.friendi.ca

in reply to Michael 🇺🇦

@Friendica Developers

Hi :)

I think we should fokus on possible major issues for a release. @Tobias would it be possible for you somewhere in the near future to help creating the release?
@Michael 🇺🇦 / @Artur Weigandt what do you say?

Release / Activity


!Friendica Developers
Hi :)

I made some PRs and noticed that we're way over schedule (2025.02) for a next release. Shall we introduce the RC branch for a release like 2025.06 ?

A second thing is that it feels like @Artur Weigandt is currently very active in refactoring parts of the code (thanks!) but it seems like our overall responsiveness decreases more and more. That's sad, but I know from myself that there's a lot to do outside of Friendica ;)

Query optimizations


!Friendica Developers

Hi,

Since I'm running one of the larger nodes (opensocial.at, friendica.me), I'm constantly looking for bottlenecks and improvements.

I log all slow queries for later analysis. Would it be helpful to post it anywhere with some insights of the database (how much data is in it, how many entries post-user or contact do have, ...)

For example this query:
SELECT `circle`.`id`, `circle`.`name`, (SELECT COUNT(*) FROM `post-user` WHERE `uid` = 1137 AND `unseen` AND `contact-id` IN (SELECT `contact-id` FROM `group_member` AS `circle_member` WHERE `circle_member`.`gid` = `circle`.`id`) ) AS `count` FROM `group`
AS `circle` WHERE `circle`.`uid` = 1137
takes around 17 seconds and is constantly logged in the slow-query logs.

Shall I post it here, is it even useful? shall I open an issue for such cases? Is it just a problem for the node, so I post it at Friendica Admins for help?

@Michael Vogel what do you think :)

Slow /photo/preview performance


!Friendica Admins

Hi all,

Because of the ongoing performance issues, I moved my whole Friendica database of opensocial.at and friendica.me to a dedicated root-server just for mariadb with 128GB RAM.

At first, it seemed like it helped and opensocial.at is faster than before (the performance of friendica.me is still a mess, but I will analyze it later), but the /photo/preview route is now going crazy:

It seems like the RAM I/O issue I had (which is now gone) is now replaced by an Network throughput issue - but at least the network I/O seems fine:

Do you have any idea what I can do now?

One thing would be to add a "StorageClass" for the Photo to load them (directly) from a filedirectory/block storage instead of the database.

CI currenrly not usable


!Friendica Developers

Hi, I recently tried to increase the woodpecker / ci performance. Unfortunately it dropped the repositories after migrating from sqlite to MySQL as backend. @Tobias re-added it again (thanks :-) ) but now some settings are still missing.

So currently, the CI isn't working :-( I'll be back home at Sunday evening, but I think I will fix it not before Monday/Tuesday..

So if you need to merge new PRs, keep in mind that the files under files.friendi.ca aren't updating ...

Sorry and I'll give an update when it's working again..

in reply to Philipp Holzer

Leider hat die Migration nicht geklappt und ich musste wieder zurückrollen.
--> Ich probiere es im August noch einmal

---

Unfortunately, the migration didn't work so I had to rollback.
--> I will retry again in august

Geplante Downtime / Server Migration


!Opensocial.at
-- English below

Liebe opensocial.at BenutzerInnen,

Ich starte nun eine Migration von opensocial.at auf eine stärkere server-hardware. Dadurch entstehen temporäre Downtimes in den kommenden Stunden.

Ich möchte mich für die Unannehmlichkeiten entschuldigen, aber ich denke, dass dadurch die gesamte Performance von opensocial.at wieder besser werden sollte :).

Lg,
Philipp

----

Dear opensocial.at user,

I'm planning to migrate my server infrastructure onto a more powerful environment.
The goal is to increase the performance, as, I think, you all currently experience a downgrading performance.

I hope it will help :)

It will take some hours, where opensocial.at will be temporary unavailable from time to time.

Regards,
Philipp

Planned Downtime / Migration


!friendica.me

Dear friendica.me user,

I'm planning to migrate my server infrastructure onto a more powerful environment.
The goal is to increase the performance, as, I think, you all currently experience a downgrading performance.

I hope it will help :)

It will take some hours, where friendica.me will be temporary unavailable from time to time.

Regards,
Philipp