Skip to main content


Tens of thousands of Message queues


!Friendica Admins I posted before about this and we tried a bunch of things. I moved from cron to daemon and managed to burn 100k Message queues in a few days. Then it stopped at burning them so fast. We checked and 99% of them are AddContact. With debugging enabled here is a sample of what the log shows me: https://paste.trom.tf/ayovelucug.sql

One of the Warnings is:
2022-06-15T04:10:29Z worker [WARNING]: Contact lock had not been acquired {"worker_id":"5a518d7","worker_cmd":"AddContact"} - {"file":"Contact.php","line":1280,"function":"getIdForURL","uid":"289a24","process_id":17436}

My Friendica works fine, but can someone help me with this issue? Maybe I have come across some nasty Friendica bug.

Friendica Admins reshared this.

in reply to Tio

@Tio did you ever try to optimize the friendica database (especially the contact table) ?
@Tio
This entry was edited (1 year ago)

Friendica Admins reshared this.

in reply to Luca Nucifora

I did it with mysqloptimize -p friendica

Friendica Admins reshared this.

Unknown parent

Tio
I am unsure how to exactly do that. But as soon as I figure it out I will do it and let you know. Thx

Friendica Admins reshared this.

Unknown parent

Tio
Great I did that. Do I need to restart any service? Let's see if it has an effect on Message queues. And thanks!

Friendica Admins reshared this.

in reply to Tio

grep "AddContact" /var/www/friendica/friendica.log | wc -l
0


Ok so that error seems to be gone now.

Friendica Admins reshared this.

in reply to Tio

Now here's an updated log file, 100 times smaller in size https://paste.trom.tf/anijuvakux.pl - we still have a lot of message queues tho...

Friendica Admins reshared this.

Unknown parent

Tio
This is what I get:

Friendica Admins reshared this.

Unknown parent

Tio
Message queues
4100 - 66074

That's the situation now. If you think is worth waiting more I will, else if you have any idea what else I could try....I'd appreciate it.

Friendica Admins reshared this.

Unknown parent

Tio

This:

I see a lot of FetchFeaturedPosts and UpdateContact

Friendica Admins reshared this.

Unknown parent

Tio
Ok then I am reassured now. 😀 I mean you are the mastermind behind Friendica so probably I can't get a better opinion than yours 😁 - thank you for the help and I am simply going to ignore these large numbers.

Friendica Admins reshared this.