and now, 2 hours later, the next cronjob kicks in (it’s timed 5 */2 * * *. there was still one siteid=18 thread running, and now 3 more started
matomo_+ 5665 1.5 0.4 519684 146404 ? S 16:10 0:01 /opt/plesk/php/8.0/bin/php -q /var/www/vhosts/xxxxxxxxxxxxxx/httpdocs/console climulti:request -q --matomo-domain=xxxxxxxxxxxxxx --superuser module=API&method=CoreAdminHome.archiveReports&idSite=18&period=month&date=2021-04-01&format=json&plugin=CustomReports&trigger=archivephp&pluginOnly=1&requestedReport=6&pid=b1a2d24a2c3763e03b1416614db5981fd236fcc4ce3b5f96c29ad40d27111997a90285943a6c2d43958f0c3926a363187f100&runid=30856
matomo_+ 5678 1.7 0.5 538976 165688 ? S 16:10 0:01 /opt/plesk/php/8.0/bin/php -q /var/www/vhosts/xxxxxxxxxxxxxx/httpdocs/console climulti:request -q --matomo-domain=xxxxxxxxxxxxxx --superuser module=API&method=CoreAdminHome.archiveReports&idSite=18&period=month&date=2021-03-01&format=json&plugin=CustomReports&trigger=archivephp&pluginOnly=1&requestedReport=8&pid=115706c351255df95a04f92ae4b7b16d9895a95936555d0781d5344c8ed8c37cbea4e1acfc53f4dd8b850360b4f4e5d4db0a1&runid=30856
matomo_+ 5691 2.0 0.5 555532 182300 ? S 16:10 0:02 /opt/plesk/php/8.0/bin/php -q /var/www/vhosts/xxxxxxxxxxxxxx/httpdocs/console climulti:request -q --matomo-domain=xxxxxxxxxxxxxx --superuser module=API&method=CoreAdminHome.archiveReports&idSite=18&period=month&date=2021-02-01&format=json&plugin=CustomReports&trigger=archivephp&pluginOnly=1&requestedReport=6&pid=781c90184b64f31d9d4c9195a4adbfe10992f819e795de67caff60cda9a7db95925ffb978ad54a1e81f248652bfdb379ff8d2&runid=30856
matomo_+ 30855 0.0 0.0 113284 1184 ? Ss 16:05 0:00 /bin/bash -c /opt/php80/bin/php -d memory_limit=8192M /var/www/vhosts/xxxxxxxxxxxxxx/httpdocs/console core:archive --url=https://xxxxxxxxxxxxxx -vvv > /var/www/vhosts/xxxxxxxxxxxxxx/logs/_archiver_log.log
matomo_+ 30856 1.0 0.1 315176 45648 ? S 16:05 0:04 /opt/php80/bin/php -d memory_limit=8192M /var/www/vhosts/xxxxxxxxxxxxxx/httpdocs/console core:archive --url=https://xxxxxxxxxxxxxx -vvv
matomo_+ 20280 0.0 0.0 138176 15296 ? S 13:35 0:00 /usr/bin/python2 -Estt /usr/local/psa/admin/sbin/cron_task_executor -u matomo_admin -c /opt/php80/bin/php -d memory_limit=8192M /var/www/vhosts/xxxxxxxxxxxxxx/httpdocs/console core:archive --url=https://xxxxxxxxxxxxxx -vvv > /var/www/vhosts/xxxxxxxxxxxxxx/logs/_archiver_log.log --env SHELL=/bin/bash
matomo_+ 20285 0.0 0.0 113284 1184 ? S 13:35 0:00 /bin/bash -c /opt/php80/bin/php -d memory_limit=8192M /var/www/vhosts/xxxxxxxxxxxxxx/httpdocs/console core:archive --url=https://xxxxxxxxxxxxxx -vvv > /var/www/vhosts/xxxxxxxxxxxxxx/logs/_archiver_log.log
matomo_+ 20286 0.0 0.1 315312 45696 ? S 13:35 0:08 /opt/php80/bin/php -d memory_limit=8192M /var/www/vhosts/xxxxxxxxxxxxxx/httpdocs/console core:archive --url=https://xxxxxxxxxxxxxx -vvv
matomo_+ 25369 6.0 0.5 544928 171716 ? S 13:38 9:18 /opt/plesk/php/8.0/bin/php -q /var/www/vhosts/xxxxxxxxxxxxxx/httpdocs/console climulti:request -q --matomo-domain=xxxxxxxxxxxxxx --superuser module=API&method=CoreAdminHome.archiveReports&idSite=18&period=year&date=2020-01-01&format=json&plugin=CustomReports&trigger=archivephp&pluginOnly=1&requestedReport=10&pid=8be125f89cbcfd4d4e6755f45ec2c8b64ea1f1b219f6b1eaf9ac4342463e656f3350c93cbe906e6aeb88d296ede885c0bd062&runid=20286
(redacted output of # ps aux | grep -i matomo)
these are all siteid=18 threads that stay and push server load. site 18 is the only one that uses CustomReports (and it used HeatMaps, but i deactivated that plugin for testing). The rest runs through normally (according to the log)
EDIT:
Finally, I managed to have all CustomReports implementes as “Goals” and could then deactivate the plugin. and now no more zombie site 18 threads. just clean archiving as it sould be.
my conclusion for now: The Plugin CustomReports (v4.0.7) did somehow mess up on our server. There were just 6 simple CustomReports configured, that’s nothing the plugin shouldn’t be able to handle. So something is wrong with the plugin, the server or both.
but for now I think this is the solution for my server load problem. (even though it sucks to pay for a plugin we can’t use, of course.)
Should anyone have a idea about how to fix custom reports please post.