When running hourly auto-archive cron task as per How to Set up Auto-Archiving of Your Reports - Analytics Platform - Matomo
I get the following error recorded in piwik-archive.log
WARNING [2019-01-08 19:54:48] 1141 /var/www/vhosts/…/httpdocs/core/Common.php(271): Notice - unserialize(): Error at offset 0 of 57757 bytes - Matomo 3.7.0 - Please report this message in the Matomo forums: https://forum.matomo.org (please do a search first as it might have been reported already)
Can you run the command with -vvv added, to get more information?
Same problem here, see logs with ‘-vvv’:
Exception trace:
() at /home/analytics.mydomain.com/public_html/core/CronArchive.php:572
Piwik\CronArchive->logFatalError() at /home/analytics.mydomain.com/public_html/core/CronArchive.php:565
Piwik\CronArchive->end() at /home/analytics.mydomain.com/public_html/core/CronArchive.php:318
Piwik\CronArchive->Piwik\{closure}() at /home/analytics.mydomain.com/public_html/core/Access.php:628
Piwik\Access::doAsSuperUser() at /home/analytics.mydomain.com/public_html/core/CronArchive.php:319
Piwik\CronArchive->main() at /home/analytics.mydomain.com/public_html/plugins/CoreConsole/Commands/CoreArchiver.php:27
Piwik\Plugins\CoreConsole\Commands\CoreArchiver->execute() at /home/analytics.mydomain.com/public_html/vendor/symfony/console/Symfony/Component/Console/Command/Command.php:257
Symfony\Component\Console\Command\Command->run() at /home/analytics.mydomain.com/public_html/vendor/symfony/console/Symfony/Component/Console/Application.php:874
Symfony\Component\Console\Application->doRunCommand() at /home/analytics.mydomain.com/public_html/vendor/symfony/console/Symfony/Component/Console/Application.php:195
Symfony\Component\Console\Application->doRun() at n/a:n/a
call_user_func() at /home/analytics.mydomain.com/public_html/core/Console.php:98
Piwik\Console->Piwik\{closure}() at /home/analytics.mydomain.com/public_html/core/Access.php:628
Piwik\Access::doAsSuperUser() at /home/analytics.mydomain.com/public_html/core/Console.php:99
Piwik\Console->doRun() at /home/analytics.mydomain.com/public_html/vendor/symfony/console/Symfony/Component/Console/Application.php:126
Symfony\Component\Console\Application->run() at /home/analytics.mydomain.com/public_html/console:27
DEBUG [2019-03-20 08:59:37] 92010 UserSynchronizer::makeConfigured(): LDAP access synchronization not enabled.
DEBUG [2019-03-20 08:59:37] 92010 UserSynchronizer::makeConfigured: configuring with defaultSitesWithViewAccess =
INFO [2019-03-20 08:59:37] 92010 ---------------------------
INFO [2019-03-20 08:59:37] 92010 INIT
INFO [2019-03-20 08:59:37] 92010 Running Matomo 3.9.0 as Super User
INFO [2019-03-20 08:59:37] 92010 ---------------------------
INFO [2019-03-20 08:59:37] 92010 NOTES
INFO [2019-03-20 08:59:37] 92010 - If you execute this script at least once per hour (or more often) in a crontab, you may disable 'Browser trigger archiving' in Matomo UI > Settings > General Settings.
INFO [2019-03-20 08:59:37] 92010 See the doc at: https://matomo.org/docs/setup-auto-archiving/
INFO [2019-03-20 08:59:37] 92010 - Reports for today will be processed at most every 900 seconds. You can change this value in Matomo UI > Settings > General Settings.
INFO [2019-03-20 08:59:37] 92010 - Reports for the current week/month/year will be requested at most every 3600 seconds.
INFO [2019-03-20 08:59:37] 92010 - Will process 1 other websites because some old data reports have been invalidated (eg. using the Log Import script or the InvalidateReports plugin) , IDs: 7
INFO [2019-03-20 08:59:37] 92010 ---------------------------
INFO [2019-03-20 08:59:37] 92010 START
INFO [2019-03-20 08:59:37] 92010 Starting Matomo reports archiving...
INFO [2019-03-20 08:59:37] 92010 Old report was invalidated for website id 7
INFO [2019-03-20 08:59:37] 92010 Will pre-process for website id = 7, period = day, date = last22
INFO [2019-03-20 08:59:37] 92010 - pre-processing all visits
DEBUG [2019-03-20 08:59:37] 92010 /usr/bin/php7.3 -q /home/analytics.mydomain.com/public_html/console climulti:request -q --matomo-domain='analytics.mydomain.com' --superuser 'module=API&method=API.get&idSite=7&period=day&date=last22&format=php&trigger=archivephp&pid=42a0a86e2248da8f2bea421214ebb9e7c6a5cd7868f027e38a73c591308c297aa79e8b33d7e7bb5659ceeab855ef1d9f45ed0&runid=92010' > /home/analytics.mydomain.com/public_html/tmp/climulti/42a0a86e2248da8f2bea421214ebb9e7c6a5cd7868f027e38a73c591308c297aa79e8b33d7e7bb5659ceeab855ef1d9f45ed0.output 2>&1 &
WARNING [2019-03-20 08:59:42] 92010 /home/analytics.mydomain.com/public_html/core/Common.php(271): Notice - unserialize(): Error at offset 0 of 109777 bytes - Matomo 3.9.0 - Please report this message in the Matomo forums: https://forum.matomo.org (please do a search first as it might have been reported already)
INFO [2019-03-20 08:59:42] 92010 - tracking data found for website id 11 since 2019-03-19 23:00:00 UTC (since midnight)
INFO [2019-03-20 08:59:42] 92010 Will pre-process for website id = 11, period = day, date = last22
INFO [2019-03-20 08:59:42] 92010 - pre-processing all visits
DEBUG [2019-03-20 08:59:42] 92010 /usr/bin/php7.3 -q /home/analytics.mydomain.com/public_html/console climulti:request -q --matomo-domain='analytics.mydomain.com' --superuser 'module=API&method=API.get&idSite=11&period=day&date=last22&format=php&trigger=archivephp&pid=54db474dfac08017600e1f987b915a428292fe473e4c08abeb093923c2cc15cee39696cafba487c33af463c3494a9a0405af0&runid=92010' > /home/analytics.mydomain.com/public_html/tmp/climulti/54db474dfac08017600e1f987b915a428292fe473e4c08abeb093923c2cc15cee39696cafba487c33af463c3494a9a0405af0.output 2>&1 &
WARNING [2019-03-20 08:59:46] 92010 /home/analytics.mydomain.com/public_html/core/Common.php(271): Notice - unserialize(): Error at offset 0 of 110411 bytes - Matomo 3.9.0 - Please report this message in the Matomo forums: https://forum.matomo.org (please do a search first as it might have been reported already)
INFO [2019-03-20 08:59:46] 92010 Done archiving!
INFO [2019-03-20 08:59:46] 92010 ---------------------------
INFO [2019-03-20 08:59:46] 92010 SUMMARY
INFO [2019-03-20 08:59:46] 92010 Total visits for today across archived websites: 0
INFO [2019-03-20 08:59:46] 92010 Archived today's reports for 0 websites
INFO [2019-03-20 08:59:46] 92010 Archived week/month/year for 0 websites
INFO [2019-03-20 08:59:46] 92010 Skipped 2 websites
INFO [2019-03-20 08:59:46] 92010 - 0 skipped because no new visit since the last script execution
INFO [2019-03-20 08:59:46] 92010 - 0 skipped because existing daily reports are less than 900 seconds old
INFO [2019-03-20 08:59:46] 92010 - 0 skipped because existing week/month/year periods reports are less than 3600 seconds old
INFO [2019-03-20 08:59:46] 92010 - 2 skipped because got an error while querying reporting API
INFO [2019-03-20 08:59:46] 92010 Total API requests: 0
INFO [2019-03-20 08:59:46] 92010 done: 0/2 0%, 0 vtoday, 0 wtoday, 0 wperiods, 0 req, 8669 ms, 2 errors.
INFO [2019-03-20 08:59:46] 92010 Time elapsed: 8.669s
INFO [2019-03-20 08:59:46] 92010 ---------------------------
INFO [2019-03-20 08:59:46] 92010 SCHEDULED TASKS
DEBUG [2019-03-20 08:59:46] 92010 26 scheduled tasks loaded
INFO [2019-03-20 08:59:46] 92010 Starting Scheduled tasks...
DEBUG [2019-03-20 08:59:46] 92010 Executing tasks with priority 0:
DEBUG [2019-03-20 08:59:46] 92010 Executing tasks with priority 1:
DEBUG [2019-03-20 08:59:46] 92010 Executing tasks with priority 2:
DEBUG [2019-03-20 08:59:46] 92010 Executing tasks with priority 3:
DEBUG [2019-03-20 08:59:46] 92010 Executing tasks with priority 4:
DEBUG [2019-03-20 08:59:46] 92010 Executing tasks with priority 5:
DEBUG [2019-03-20 08:59:46] 92010 Executing tasks with priority 6:
DEBUG [2019-03-20 08:59:46] 92010 Executing tasks with priority 7:
DEBUG [2019-03-20 08:59:46] 92010 Executing tasks with priority 8:
DEBUG [2019-03-20 08:59:46] 92010 Executing tasks with priority 9:
DEBUG [2019-03-20 08:59:46] 92010 Executing tasks with priority 10:
DEBUG [2019-03-20 08:59:46] 92010 Executing tasks with priority 11:
DEBUG [2019-03-20 08:59:46] 92010 Executing tasks with priority 12:
INFO [2019-03-20 08:59:46] 92010 done
INFO [2019-03-20 08:59:46] 92010 ---------------------------
INFO [2019-03-20 08:59:46] 92010 ---------------------------
INFO [2019-03-20 08:59:46] 92010 SUMMARY OF ERRORS
INFO [2019-03-20 08:59:46] 92010 Error: Empty or invalid response '[2019-03-20 08:59:38] piwik.DEBUG: Loaded plugins: CorePluginsAdmin, CoreAdminHome, CoreHome,
WebsiteMeasurable, IntranetMeasurable, Diagnostics, CoreVisualizations, Proxy, API, ExamplePlugin, Widgetize, Transitions, LanguagesManager, Actions, Dashboard, MultiSites, Referrers, UserLanguage, DevicesDetection, Goals, Ecommerce, SEO, Events, UserCountry, GeoIp2, VisitsSummary, VisitFrequency, VisitTime, VisitorInterest, ExampleAPI, RssWidget, Feedback, Monolog, TwoFactorAuth, UsersManager, SitesManager, Installation, CoreUpdater, CoreConsole, ScheduledReports, UserCountryMap,
Live, CustomVariables, PrivacyManager, ImageGraph, Annotations, MobileMessaging, Overlay, SegmentEditor, Insights, Morpheus, Contents, BulkTracking, Resolution, DevicePlugins, Heartbeat, Intl, Marketplace, ProfessionalServices, UserId, CustomPiwikJs, LoginLdap [] {"class":"Piwik\\Plugin\\Manager","request_id":92101} [2019-03-20 08:59:38] piwik.DEBUG: UserSynchronizer::makeConfigured(): LDAP access synchronization not enabled. {"func":"makeConfigured"} {"class":"LoginLdap","request_id":92101} [2019-03-20 08:59:38] piwik.DEBUG: UserSynchronizer::makeConfigured: configuring with defaultSitesWithViewAccess = {"func":"makeConfigured","sites":""} {"class":"LoginLdap","request_id":92101} [2019-03-20 08:59:38] piwik.DEBUG: /* trigger = CronArchive */ SELECT count(distinct log_visit.idvisitor) AS `1`, count(*) AS `2`, sum(log_visit.visit_total_actions) AS `3`, max(log_visit.visit_total_actions) AS `4`, sum(log_visit.visit_total_time) AS `5`,
sum(case log_visit.visit_total_actions when 1 then 1 when 0 then 1 else 0 end) AS `6`, sum(case log_visit.visit_goal_converted when 1 then 1 else 0 end) AS `7`, count(distinct log_visit.user_id) AS `39` FROM matomo_log_visit AS log_visit WHERE log_visit.visit_last_action_time >= ? AND log_visit.visit_last_action_time <= ? AND log_visit.idsite IN (?) [] {"class":"VisitsSummary","request_id":92101} [2019-03-20 08:59:38] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Initializing archiving process for all plugins [visits = 3, visits converted = 0] ["callAggregateAllPlugins",3,"0"] {"class":"VisitsSummary","request_id":92101} [2019-03-20 08:59:38] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Archiving day reports for plugin 'ExamplePlugin'. ["callAggregateAllPlugins","ExamplePlugin"] {"class":"VisitsSummary","request_id":92101} [2019-03-20 08:59:38] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Memory
delta: 400 B while archiving day reports for plugin 'ExamplePlugin' (for segment = ''). ["callAggregateAllPlugins","Memory delta: 400 B","day","ExamplePlugin","(for segment = '')"] {"class":"VisitsSummary","request_id":92101} [2019-03-20 08:59:38] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Archiving day reports for plugin 'Actions'. ["callAggregateAllPlugins","Actions"] {"class":"VisitsSummary","request_id":92101} [2019-03-20 08:59:38] piwik.DEBUG: /* trigger = CronArchive */ SELECT log_action.name, log_action.type, log_action.idaction, log_action.url_prefix, count(distinct log_link_visit_action.idvisit) as `2`, count(distinct log_link_visit_action.idvisitor) as `1`, count(*) as `12`, sum( case when custom_float is null then 0 else custom_float end ) / 1000 as `30`, sum(
case when custom_float is null then 0 else 1 end ) as `31`,
min(custom_float) / 1000 as `32`, max(custom_float) / 1000 as `33`, CASE WHEN (MAX(log_link_visit_action.custom_var_v5) = 0 AND log_link_visit_action.custom_var_k5 = '_pk_scount') THEN 1 ELSE 0 END AS `28`, SUM( CASE WHEN log_action_name_ref.type = 8 THEN 1 ELSE 0 END) AS `29` FROM matomo_log_link_visit_action AS log_link_visit_action LEFT JOIN matomo_log_action AS log_action ON log_link_visit_action.%s = log_action.idaction LEFT JOIN matomo_log_action AS log_action_name_ref ON log_link_visit_action.idaction_name_ref = log_action_name_ref.idaction WHERE log_link_visit_action.server_time >= ? AND log_link_visit_action.server_time <= ? AND log_link_visit_action.idsite IN (?) AND log_link_visit_action.%s IS NOT NULL AND log_link_visit_action.idaction_event_category IS NULL GROUP BY log_link_visit_action.%s ORDER BY `12` DESC, name ASC [] {"class":"Actions","request_id":92101} [2019-03-20 08:59:38] piwik.DEBUG: /* trigger = CronArchive */ SELECT log_action.name, log_action.type, log_action.idaction, log_action.url_prefix, count(distinct log_link_visit_action.idvisit) as `2`, count(distinct log_link_visit_action.idvisitor) as `1`, count(*) as `12`, sum( case when custom_float is null
then 0 else custom_float end ) / 1000 as `30`, sum( case when custom_float is null then 0 else 1 end ) as `31`, min(custom_float) / 1000 as `32`, max(custom_float) / 1000 as `33`, CASE WHEN (MAX(log_link_visit_action.custom_var_v5) = 0 AND log_link_visit_action.custom_var_k5 = '_pk_scount') THEN 1 ELSE 0 END AS `28`, SUM( CASE WHEN log_action_name_ref.type = 8
THEN 1 ELSE 0 END) AS `29` FROM matomo_log_link_visit_action AS log_link_visit_action LEFT JOIN matomo_log_action AS log_action ON log_link_visit_action.%s = log_action.id
INFO [2019-03-20 08:59:46] 92010 Error: Empty or invalid response '[2019-03-20 08:59:43] piwik.DEBUG: Loaded plugins: CorePluginsAdmin, CoreAdminHome, CoreHome,
WebsiteMeasurable, IntranetMeasurable, Diagnostics, CoreVisualizations, Proxy, API, ExamplePlugin, Widgetize, Transitions, LanguagesManager, Actions, Dashboard, MultiSites, Referrers, UserLanguage, DevicesDetection, Goals, Ecommerce, SEO, Events, UserCountry, GeoIp2, VisitsSummary, VisitFrequency, VisitTime, VisitorInterest, ExampleAPI, RssWidget, Feedback, Monolog, TwoFactorAuth, UsersManager, SitesManager, Installation, CoreUpdater, CoreConsole, ScheduledReports, UserCountryMap,
Live, CustomVariables, PrivacyManager, ImageGraph, Annotations, MobileMessaging, Overlay, SegmentEditor, Insights, Morpheus, Contents, BulkTracking, Resolution, DevicePlugins, Heartbeat, Intl, Marketplace, ProfessionalServices, UserId, CustomPiwikJs, LoginLdap [] {"class":"Piwik\\Plugin\\Manager","request_id":92215} [2019-03-20 08:59:43] piwik.DEBUG: UserSynchronizer::makeConfigured(): LDAP access synchronization not enabled. {"func":"makeConfigured"} {"class":"LoginLdap","request_id":92215} [2019-03-20 08:59:43] piwik.DEBUG: UserSynchronizer::makeConfigured: configuring with defaultSitesWithViewAccess = {"func":"makeConfigured","sites":""} {"class":"LoginLdap","request_id":92215} [2019-03-20 08:59:43] piwik.DEBUG: /* trigger = CronArchive */ SELECT count(distinct log_visit.idvisitor) AS `1`, count(*) AS `2`, sum(log_visit.visit_total_actions) AS `3`, max(log_visit.visit_total_actions) AS `4`, sum(log_visit.visit_total_time) AS `5`,
sum(case log_visit.visit_total_actions when 1 then 1 when 0 then 1 else 0 end) AS `6`, sum(case log_visit.visit_goal_converted when 1 then 1 else 0 end) AS `7`, count(distinct log_visit.user_id) AS `39` FROM matomo_log_visit AS log_visit WHERE log_visit.visit_last_action_time >= ? AND log_visit.visit_last_action_time <= ? AND log_visit.idsite IN (?) [] {"class":"VisitsSummary","request_id":92215} [2019-03-20 08:59:43] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Initializing archiving process for all plugins [visits = 1, visits converted = 0] ["callAggregateAllPlugins",1,"0"] {"class":"VisitsSummary","request_id":92215} [2019-03-20 08:59:43] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Archiving day reports for plugin 'ExamplePlugin'. ["callAggregateAllPlugins","ExamplePlugin"] {"class":"VisitsSummary","request_id":92215} [2019-03-20 08:59:43] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Memory
delta: 400 B while archiving day reports for plugin 'ExamplePlugin' (for segment = ''). ["callAggregateAllPlugins","Memory delta: 400 B","day","ExamplePlugin","(for segment = '')"] {"class":"VisitsSummary","request_id":92215} [2019-03-20 08:59:43] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Archiving day reports for plugin 'Actions'. ["callAggregateAllPlugins","Actions"] {"class":"VisitsSummary","request_id":92215} [2019-03-20 08:59:43] piwik.DEBUG: /* trigger = CronArchive */ SELECT log_action.name, log_action.type, log_action.idaction, log_action.url_prefix, count(distinct log_link_visit_action.idvisit) as `2`, count(distinct log_link_visit_action.idvisitor) as `1`, count(*) as `12`, sum( case when custom_float is null then 0 else custom_float end ) / 1000 as `30`, sum(
case when custom_float is null then 0 else 1 end ) as `31`,
min(custom_float) / 1000 as `32`, max(custom_float) / 1000 as `33`, CASE WHEN (MAX(log_link_visit_action.custom_var_v5) = 0 AND log_link_visit_action.custom_var_k5 = '_pk_scount') THEN 1 ELSE 0 END AS `28`, SUM( CASE WHEN log_action_name_ref.type = 8 THEN 1 ELSE 0 END) AS `29` FROM matomo_log_link_visit_action AS log_link_visit_action LEFT JOIN matomo_log_action AS log_action ON log_link_visit_action.%s = log_action.idaction LEFT JOIN matomo_log_action AS log_action_name_ref ON log_link_visit_action.idaction_name_ref = log_action_name_ref.idaction WHERE log_link_visit_action.server_time >= ? AND log_link_visit_action.server_time <= ? AND log_link_visit_action.idsite IN (?) AND log_link_visit_action.%s IS NOT NULL AND log_link_visit_action.idaction_event_category IS NULL GROUP BY log_link_visit_action.%s ORDER BY `12` DESC, name ASC [] {"class":"Actions","request_id":92215} [2019-03-20 08:59:43] piwik.DEBUG: /* trigger = CronArchive */ SELECT log_action.name, log_action.type, log_action.idaction, log_action.url_prefix, count(distinct log_link_visit_action.idvisit) as `2`, count(distinct log_link_visit_action.idvisitor) as `1`, count(*) as `12`, sum( case when custom_float is null
then 0 else custom_float end ) / 1000 as `30`, sum( case when custom_float is null then 0 else 1 end ) as `31`, min(custom_float) / 1000 as `32`, max(custom_float) / 1000 as `33`, CASE WHEN (MAX(log_link_visit_action.custom_var_v5) = 0 AND log_link_visit_action.custom_var_k5 = '_pk_scount') THEN 1 ELSE 0 END AS `28`, SUM( CASE WHEN log_action_name_ref.type = 8
THEN 1 ELSE 0 END) AS `29` FROM matomo_log_link_visit_action AS log_link_visit_action LEFT JOIN matomo_log_action AS log_action ON log_link_visit_action.%s = log_action.id
I got the same error with Matomo 3.9.0, PHP 5.6.40 on Ubutu 16.04:
INFO [2019-03-20 09:18:27] 28728 Will pre-process for website id = 1, period = day, date = last52
INFO [2019-03-20 09:18:27] 28728 - pre-processing all visits
WARNING [2019-03-20 09:18:30] 28728 /var/www/matomo/site/matomo-versions/matomo-live/core/Common.php(271): Notice - unserialize(): Error at offset 0 of 177148 bytes - Matomo 3.9.0 - Please report this message in the Matomo forums: https://forum.matomo.org (please do a search first as it might have been reported already)
ERROR [2019-03-20 09:18:30] 28728 Empty or invalid response '[2019-03-20 09:18:27] piwik.DEBUG: Loaded plugins: CorePluginsAdmin, CoreAdminHome, CoreHome, WebsiteMeasurable, IntranetMeasurable, Diagnostics, CoreVisualizations, Proxy, API, ExamplePlugin, Widgetize, Transitions, LanguagesManager, Actions, Dashboard, MultiSites, Referrers, UserLanguage, DevicesDetection, Goals, Ecommerce, SEO, Events, UserCountry, GeoIp2, VisitsSummary, VisitFrequency, VisitTime, VisitorInterest, ExampleAPI, RssWidget, Feedback, Monolog, Login, TwoFactorAuth, UsersManager, SitesManager, Installation, CoreUpdater, CoreConsole, ScheduledReports, UserCountryMap, Live, CustomVariables, PrivacyManager, ImageGraph, Annotations, MobileMessaging, Overlay, SegmentEditor, Insights, Morpheus, Contents, BulkTracking, Resolution, DevicePlugins, Heartbeat, Intl, Marketplace, ProfessionalServices, UserId, CustomPiwikJs, Provider [] {"class":"Piwik\\Plugin\\Manager","request_id":28815} [2019-03-20 09:18:28] piwik.DEBUG: /* trigger = CronArchive */ SELECT count(distinct log_visit.idvisitor) AS `1`, count(*) AS `2`, sum(log_visit.visit_total_actions) AS `3`, max(log_visit.visit_total_actions) AS `4`, sum(log_visit.visit_total_time) AS `5`, sum(case log_visit.visit_total_actions when 1 then 1 when 0 then 1 else 0 end) AS `6`, sum(case log_visit.visit_goal_converted when 1 then 1 else 0 end) AS `7`, count(distinct log_visit.user_id) AS `39` FROM prefix_log_visit AS log_visit WHERE log_visit.visit_last_action_time >= ? AND log_visit.visit_last_action_time <= ? AND log_visit.idsite IN (?) [] {"class":"VisitsSummary","request_id":28815} [2019-03-20 09:18:28] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Initializing archiving process for all plugins [visits = 320, visits converted = 1] ["callAggregateAllPlugins","320","1"] {"class":"VisitsSummary","request_id":28815} [2019-03-20 09:18:28] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Archiving day reports for plugin 'ExamplePlugin'. ["callAggregateAllPlugins","ExamplePlugin"] {"class":"VisitsSummary","request_id":28815} [2019-03-20 09:18:28] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Memory delta: 400 B while archiving day reports for plugin 'ExamplePlugin' (for segment = ''). ["callAggregateAllPlugins","Memory delta: 400 B","day","ExamplePlugin","(for segment = '')"] {"class":"VisitsSummary","request_id":28815} [2019-03-20 09:18:28] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Archiving day reports for plugin 'Actions'. ["callAggregateAllPlugins","Actions"] {"class":"VisitsSummary","request_id":28815} [2019-03-20 09:18:28] piwik.DEBUG: /* trigger = CronArchive */ SELECT log_action.name, log_action.type, log_action.idaction, log_action.url_prefix, count(distinct log_link_visit_action.idvisit) as `2`, count(distinct log_link_visit_action.idvisitor) as `1`, count(*) as `12`, sum( case when custom_float is null then 0 else custom_float end ) / 1000 as `30`, sum( case when custom_float is null then 0 else 1 end ) as `31`, min(custom_float) / 1000 as `32`, max(custom_float) / 1000 as `33`, CASE WHEN (MAX(log_link_visit_action.custom_var_v5) = 0 AND log_link_visit_action.custom_var_k5 = '_pk_scount') THEN 1 ELSE 0 END AS `28`, SUM( CASE WHEN log_action_name_ref.type = 8 THEN 1 ELSE 0 END) AS `29` FROM prefix_log_link_visit_action AS log_link_visit_action LEFT JOIN prefix_log_action AS log_action ON log_link_visit_action.%s = log_action.idaction LEFT JOIN prefix_log_action AS log_action_name_ref ON log_link_visit_action.idaction_name_ref = log_action_name_ref.idaction WHERE log_link_visit_action.server_time >= ? AND log_link_visit_action.server_time <= ? AND log_link_visit_action.idsite IN (?) AND log_link_visit_action.%s IS NOT NULL AND log_link_visit_action.idaction_event_category IS NULL GROUP BY log_link_visit_action.%s ORDER BY `12` DESC, name ASC [] {"class":"Actions","request_id":28815} [2019-03-20 09:18:28] piwik.DEBUG: /* trigger = CronArchive */ SELECT log_action.name, log_action.type, log_action.idaction, log_action.url_prefix, count(distinct log_link_visit_action.idvisit) as `2`, count(distinct log_link_visit_action.idvisitor) as `1`, count(*) as `12`, sum( case when custom_float is null then 0 else custom_float end ) / 1000 as `30`, sum( case when custom_float is null then 0 else 1 end ) as `31`, min(custom_float) / 1000 as `32`, max(custom_float) / 1000 as `33`, CASE WHEN (MAX(log_link_visit_action.custom_var_v5) = 0 AND log_link_visit_action.custom_var_k5 = '_pk_scount') THEN 1 ELSE 0 END AS `28`, SUM( CASE WHEN log_action_name_ref.type = 8 THEN 1 ELSE 0 END) AS `29` FROM prefix_log_link_visit_action AS log_link_visit_action LEFT JOIN prefix_log_action AS log_action ON log_link_visit_action.%s = log_action.idaction LEFT JOIN prefix_log_action AS log_action_name_ref ON log_link_visit_action.idaction_name_ref = log_action_name_ref.idaction WHERE log_link_visit_action.server_time >= ? AND log_link_visit_action.server_time <= ? AND log_link_visit_action.idsite IN (?) AND log_link_visit_action.%s IS NOT NULL AND log_link_visit_action.idact
I, too, have the same error, with the same exception and other details as Romain. Running PHP 7.2, though this doesn’t seem relevant.
This started with the upgrade to 3.9.0, which did not go flawlessly (as usual), so I reinstalled the update manually.
Yes, same error shows up.
Hi,
This bug has been fixed in Make sure Monolog never adds its default handler. by diosmosis · Pull Request #14239 · matomo-org/matomo · GitHub
SoonTM 3.9.1 will be released that includes this fix.
3.9.1 has been released.
Thanks Lukas! I can confirm that pull request #14239 solved this problem for me.