Hi !Friendica Support,
Since this morning I have 100% CPU utilization - php uses it.
It is generating a lot of error log entries.
Is there a command to clear the worker cache.
Presumably there is a post which is causing problems.
In any case, it paralyzes the entire system. Posts are not delivered to the remote locations and new ones are not retrieved.
The queue hangs at 55 - 471.
Does anyone have an idea?
error
Data too long for column 'description' at row 1
params
INSERT INTO `post-media` (`uri-id`, `url`, `media-uri-id`, `type`, `mimetype`, `description`, `name`, `author-url`, `author-name`, `author-image`, `publisher-url`, `publisher-name`) VALUES (5850527, 'https://palmoildetectives.com/2022/02/13/the-worlds-most-loved-cup-a-social-ethical-environmental-history-of-coffee/', 5849972, 20, 'application/activity+json', '
The World’s Most Loved Cup: A Social, Ethical & Environmental History of Coffee by Aviary Doert
\n[quote]Aviary Doert holds a Bachelor’s of Science in Biology and they have worked for a decade in medical and laboratory science. They are an amateur conservation scientist, with experience in field work and research. They are hoping to positively impact the environment and planet through education and increasing awareness of the consequences of people’s purchases and actions. \n\nA Social
-> This is just a short excerpt. It really is a lot.
Michael 🇺🇦
•administrator
•Hi Michael,
der Traffic ist normal.
But I have a lot of active PHP processes and the CPU utilization is still at 100% I get error logs every second.
Current:
code
1406
error
Data too long for column 'description' at row 1
params
INSERT INTO `post-media` (`uri-id`, `url`, `media-uri-id`, `type`, `mimetype`, `description`, `name`, `author-url`, `author-name`, `author-image`, `publisher-url`, `publisher-name`) VALUES (5851651, 'https://palmoildetectives.com/2022/02/13/the-worlds-most-loved-cup-a-social-ethical-environmental-history-of-coffee/', 5849972, 20, 'application/activity+json', '
The World’s Most Loved Cup: A Social, Ethical & Environmental History of Coffee by Aviary Doert
\n[quote]Aviary Doert holds a Bachelor’s of Science in Biology and they have worked for a decade in medical and laboratory science. They are an amateur conservation scientist, with experience in field work and research. They are hoping to positively impact the environment and planet through education and increasing awarene
... show moreHi Michael,
der Traffic ist normal.
But I have a lot of active PHP processes and the CPU utilization is still at 100% I get error logs every second.
Current:
code
1406
error
Data too long for column 'description' at row 1
params
INSERT INTO `post-media` (`uri-id`, `url`, `media-uri-id`, `type`, `mimetype`, `description`, `name`, `author-url`, `author-name`, `author-image`, `publisher-url`, `publisher-name`) VALUES (5851651, 'https://palmoildetectives.com/2022/02/13/the-worlds-most-loved-cup-a-social-ethical-environmental-history-of-coffee/', 5849972, 20, 'application/activity+json', '
The World’s Most Loved Cup: A Social, Ethical & Environmental History of Coffee by Aviary Doert
\n[quote]Aviary Doert holds a Bachelor’s of Science in Biology and they have worked for a decade in medical and laboratory science. They are an amateur conservation scientist, with experience in field work and research. They are hoping to positively impact the environment and planet through education and increasing awareness of the consequences of people’s purchases and actions. \n\nA Social, #Ethical Environmental #History of #Coffee by Aviary Doert/@SnowRiver66 who demystifies the origins and impact of the world’s most loved cup of liquid motivation #Boycott4Wildlife\n\n[url=http://twitter.com/
-> shortened
Quelle
file Database.php
line 782
function e
request-id 686689328277d
stack Database::e (1033), Database::insert (276), DBA::insert (107), Media::insert (765), Media::insertFromRelevantUrl (1205), Item::insert (1230), Processor:😛ostItem (786), Receiver::routeActivities (236), Queue:😛rocess (25), ProcessQueue::execute, Worker::execFunction (374), Worker::execute (109), Worker:😛rocessQueue (75)
uid dafe52
process_id 426547