Hey guys,
We run some medium traffic sites and to pre-create the reports we setup a cron job running once every hour.
Lately the log for the cronjob shows many of these kind of entries, mainly for the tracked idsite 4:
INFO [2020-05-13 19:47:03] 50614 - tracking data found for website id 4 since 2020-05-13 13:19:55 UTC (since the last successful archiving)
INFO [2020-05-13 19:47:03] 50614 Will pre-process for website id = 4, period = day, date = last2
INFO [2020-05-13 19:47:03] 50614 - pre-processing all visits
WARNING [2020-05-13 19:49:03] 50614 /var/www/html/core/Common.php(297): Notice - unserialize(): Error at offset 0 of 165 bytes - Matomo 3.13.5 - Please report this message in the Matomo forums: https://forum.matomo.org (please do a search first as it might have been reported already)
</html>' for website id 4, Time elapsed: 120.548s, skipping '<html>
...
...
INFO [2020-05-13 19:57:06] 50614 SCHEDULED TASKS
INFO [2020-05-13 19:57:06] 50614 Starting Scheduled tasks...
INFO [2020-05-13 19:57:06] 50614 Scheduler: executing task Piwik\Plugins\CustomPiwikJs\Tasks.updateTracker...
INFO [2020-05-13 19:57:06] 50614 Scheduler: finished. Time elapsed: 0.042s
INFO [2020-05-13 19:57:06] 50614 Scheduler: executing task Piwik\Plugins\PrivacyManager\Tasks.deleteLogData...
INFO [2020-05-13 19:57:06] 50614 Scheduler: finished. Time elapsed: 0.010s
INFO [2020-05-13 19:57:06] 50614 Scheduler: executing task Piwik\Plugins\PrivacyManager\Tasks.anonymizePastData...
INFO [2020-05-13 19:57:06] 50614 Scheduler: finished. Time elapsed: 0.001s
INFO [2020-05-13 19:57:06] 50614 done
INFO [2020-05-13 19:57:06] 50614 ---------------------------
INFO [2020-05-13 19:57:06] 50614 ---------------------------
INFO [2020-05-13 19:57:06] 50614 SUMMARY OF ERRORS
</html>' for website id 4, Time elapsed: 120.548s, skippingsponse '<html>
ERROR [2020-05-13 19:57:06] 50614 1 total errors during this script execution, please investigate and try and fix these errors.
ERROR [2020-05-13 19:57:06] 50614 Uncaught exception: /var/www/html/core/CronArchive.php(606): 1 total errors during this script execution, please investigate and try and fix these errors.
...
INFO [2020-05-06 13:06:42] 11613 SUMMARY OF ERRORS
</html>nter>nginx</center>me-out</h1></center>d>serializing the following response from ?module=API&method=API.get&idSite=4&period=week&date=last2&format=php&trigger=archivephp: <html>
</html>' for website id 4, Time elapsed: 240.748s, skippingsponse '<html>
I tried to invalidate and force-recreate the reports through
./console core:archive --force-idsites 4 --force-periods=2020-05-12,2020-05-22
which exited with one error:
INFO [2020-05-22 12:49:09] 785 - pre-processing all visits
WARNING [2020-05-22 12:49:10] 785 /var/www/html/core/Common.php(297): Notice - unserialize(): Error at offset 0 of 165 bytes - Matomo 3.13.5 - Please report this message in the Matomo forums: https://forum.mato
mo.org (please do a search first as it might have been reported already)
</html>' for website id 4, Time elapsed: 135.790s, skippingonse<html>
ERROR [2020-05-22 12:49:10] 785 1 total errors during this script execution, please investigate and try and fix these errors.
ERROR [2020-05-22 12:49:10] 785 Uncaught exception: /var/www/html/core/CronArchive.php(606): 1 total errors during this script execution, please investigate and try and fix these errors.
1 total errors during this script execution, please investigate and try and fix these errors.
#0 /var/www/html/core/CronArchive.php(599): Piwik\CronArchive->logFatalError('1 total errors ...')
We are using the latest matomo 3.13.5 bound to one nginx. This nginx is running behind a proxy server which takes care of distribution and SSL certificate handling.
Both nginx are version 1.17.9 and we use PHP Version 7.4.5.
The site number 4 is using the tracking API so there should not so much html stuff reach Matomo.
How can we get rid of these errors or at least remove them savely from the Database?