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:
My Friendica works fine, but can someone help me with this issue? Maybe I have come across some nasty Friendica bug.
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.
Michael Vogel
in reply to Tio • • •workerqueue
table for entries with thecommand
equals to "AddContact"? How many are there?Tio
in reply to Michael Vogel • • •Friendica Admins reshared this.
Tio
in reply to Michael Vogel • • •Friendica Admins reshared this.
Luca Nucifora
in reply to Tio • •Friendica Admins reshared this.
Tio
in reply to Luca Nucifora • • •mysqloptimize -p friendica
like this
Luca Nucifora e Roland Häder like this.
Friendica Admins reshared this.
Michael Vogel
in reply to Tio • • •public static function execute(int $uid = 0, string $url = '')
This should help to get rid of that message.
Friendica Admins reshared this.
Tio
in reply to Michael Vogel • • •Friendica Admins reshared this.
Tio
in reply to Tio • • •Ok so that error seems to be gone now.
Friendica Admins reshared this.
Tio
in reply to Tio • • •Friendica Admins reshared this.
Michael Vogel
in reply to Tio • • •Tio likes this.
Friendica Admins reshared this.
Tio
in reply to Michael Vogel • • •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.
Roland Häder likes this.
Friendica Admins reshared this.
Michael Vogel
in reply to Tio • • •select command, count(*) from workerqueue where not done and not retrial group by command;
Friendica Admins reshared this.
Tio
in reply to Michael Vogel • • •This:
I see a lot of FetchFeaturedPosts and UpdateContact
Friendica Admins reshared this.
Michael Vogel
in reply to Tio • • •Friendica Admins reshared this.
Tio
in reply to Michael Vogel • • •Friendica Admins reshared this.
Roland HĂ€der
in reply to Tio • • •Friendica Admins reshared this.
Roland HĂ€der
Unknown parent • • •`done` = 0
you can also useNOT `done`
. It works perfectly fine. I have learned this from this community.Tio likes this.
Friendica Admins reshared this.