Yesterday updated to 3.9.0, I added an extra site and I added an extra user. Since this night I get every hour an error message in my mailbox from the cronjob, not changed.
What can be the reason and how can I solve it?
Thanks for reaction
The message is:
Blockquote
ERROR [2019-03-20 11:50:07] 2875911 Empty or invalid response '[2019-03-20 11:50:05] 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, VisitsSummary, VisitFrequency, VisitTime, VisitorInterest, ExampleAPI, 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, ExampleRssWidget {âclassâ:âPiwik\Plugin\Managerâ,ârequest_idâ:2876769} [2019-03-20 11:50:06] 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 piwik_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â:2876769} [2019-03-20 11:50:06] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Initializing archiving process for all plugins [visits = 1, visits converted = 0] [âcallAggregateAllPluginsâ,1,â0â] {âclassâ:âVisitsSummaryâ,ârequest_idâ:2876769} [2019-03-20 11:50:07] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Archiving day reports for plugin âExamplePluginâ. [âcallAggregateAllPluginsâ,âExamplePluginâ] {âclassâ:âVisitsSummaryâ,ârequest_idâ:2876769} [2019-03-20 11:50:07] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Memory delta: 344 B while archiving day reports for plugin âExamplePluginâ (for segment = ââ). [âcallAggregateAllPluginsâ,âMemory delta: 344 Bâ,âdayâ,âExamplePluginâ,â(for segment = ââ)â] {âclassâ:âVisitsSummaryâ,ârequest_idâ:2876769} [2019-03-20 11:50:07] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Archiving day reports for plugin âActionsâ. [âcallAggregateAllPluginsâ,âActionsâ] {âclassâ:âVisitsSummaryâ,ârequest_idâ:2876769} [2019-03-20 11:50:07] 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 piwik_log_link_visit_action AS log_link_visit_action LEFT JOIN piwik_log_action AS log_action ON log_link_visit_action.%s = log_action.idaction LEFT JOIN piwik_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â:2876769} [2019-03-20 11:50:07] 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 piwik_log_link_visit_action AS log_link_visit_action LEFT JOIN piwik_log_action AS log_action ON log_link_visit_action.%s = log_action.idaction LEFT JOIN piwik_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_cate
ERROR [2019-03-20 11:50:08] 2875911 Empty or invalid response '[2019-03-20 11:50:08] 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, VisitsSummary, VisitFrequency, VisitTime, VisitorInterest, ExampleAPI, 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, ExampleRssWidget {âclassâ:âPiwik\Plugin\Managerâ,ârequest_idâ:2877420} [2019-03-20 11:50:08] 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 piwik_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â:2877420} [2019-03-20 11:50:08] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Initializing archiving process for all plugins [visits = 0, visits converted = ] [âcallAggregateAllPluginsâ,0,null] {âclassâ:âVisitsSummaryâ,ârequest_idâ:2877420} [2019-03-20 11:50:08] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin âExamplePluginâ (no visits). [âcallAggregateAllPluginsâ,âExamplePluginâ] {âclassâ:âVisitsSummaryâ,ârequest_idâ:2877420} [2019-03-20 11:50:08] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin âActionsâ (no visits). [âcallAggregateAllPluginsâ,âActionsâ] {âclassâ:âVisitsSummaryâ,ârequest_idâ:2877420} [2019-03-20 11:50:08] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin âReferrersâ (no visits). [âcallAggregateAllPluginsâ,âReferrersâ] {âclassâ:âVisitsSummaryâ,ârequest_idâ:2877420} [2019-03-20 11:50:08] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin âUserLanguageâ (no visits). [âcallAggregateAllPluginsâ,âUserLanguageâ] {âclassâ:âVisitsSummaryâ,ârequest_idâ:2877420} [2019-03-20 11:50:08] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin âDevicesDetectionâ (no visits). [âcallAggregateAllPluginsâ,âDevicesDetectionâ] {âclassâ:âVisitsSummaryâ,ârequest_idâ:2877420} [2019-03-20 11:50:08] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin âGoalsâ (no visits). [âcallAggregateAllPluginsâ,âGoalsâ] {âclassâ:âVisitsSummaryâ,ârequest_idâ:2877420} [2019-03-20 11:50:08] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin âEventsâ (no visits). [âcallAggregateAllPluginsâ,âEventsâ] {âclassâ:âVisitsSummaryâ,ârequest_idâ:2877420} [2019-03-20 11:50:08] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin âUserCountryâ (no visits). [âcallAggregateAllPluginsâ,âUserCountryâ] {âclassâ:âVisitsSummaryâ,ârequest_idâ:2877420} [2019-03-20 11:50:08] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin âVisitTimeâ (no visits). [âcallAggregateAllPluginsâ,âVisitTimeâ] {âclassâ:âVisitsSummaryâ,ârequest_idâ:2877420} [2019-03-20 11:50:08] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin âVisitorInterestâ (no visits). [âcallAggregateAllPluginsâ,âVisitorInterestâ] {âclassâ:âVisitsSummaryâ,ârequest_idâ:2877420} [2019-03-20 11:50:08] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin âCustomVariablesâ (no visits). [âcallAggregateAllPluginsâ,âCustomVariablesâ] {âclassâ:âVisitsSummaryâ,ârequest_idâ:2877420} [2019-03-20 11:50:08] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin âContentsâ (no visits). [âcallAggregateAllPluginsâ,âContentsâ] {âclassâ:âVisitsSummaryâ,ârequest_idâ:2877420} [2019-03-20 11:50:08] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin âResolutionâ (no visits). [âcallAggregateAllPluginsâ,âResolutionâ] {âclassâ:âVisitsSummaryâ,ârequest_idâ:2877420} [2019-03-20 11:50:08] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin âDevicePluginsâ (no visits). [âcallAggregateAllPluginsâ,âDevicePluginsâ] {âclassâ:âVisitsSummaryâ,ârequest_idâ:2877420} [2019-03-20 11:50:08] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin âUserIdâ (no visits). [âcallAggregateAllPluginsâ,âUserIdâ] {âclassâ:âVisitsSummaryâ,ârequest_idâ:2877420} [2019-03-20 11:50:08] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin âProviderâ (no visits). [âcallAggregateAllPluginsâ,âProviderâ] {âclassâ:âVisitsSummaryâ,ârequest_idâ:2877420} [2019-03-20 11:50:08] piwik.DEBUG: day archive, idSite = 2 (temporary archive), segment ââ, report = âVisitsSummaryâ, UTC datetime [2019-03-19 23:00:00 â 2019-03-20 22:59:59] [âdayâ,2,âtemporary archiveâ,ââ,âVisitsSummaryâ,â2019-03-19 23:00:00â,â2019-03-20 22:59:59â] {âclassâ:âVisitsSummaryâ,ârequest_idâ:2877420} [2019-03-20 11:50:08] 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
ERROR [2019-03-20 11:50:10] 2875911 Empty or invalid response '[2019-03-20 11:50:09] 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, VisitsSummary, VisitFrequency, VisitTime, VisitorInterest, ExampleAPI, 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, ExampleRssWidget {âclassâ:âPiwik\Plugin\Managerâ,ârequest_idâ:2877601} [2019-03-20 11:50:09] 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 piwik_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â:2877601} [2019-03-20 11:50:09] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Initializing archiving process for all plugins [visits = 1, visits converted = 0] [âcallAggregateAllPluginsâ,1,â0â] {âclassâ:âVisitsSummaryâ,ârequest_idâ:2877601} [2019-03-20 11:50:09] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Archiving day reports for plugin âExamplePluginâ. [âcallAggregateAllPluginsâ,âExamplePluginâ] {âclassâ:âVisitsSummaryâ,ârequest_idâ:2877601} [2019-03-20 11:50:09] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Memory delta: 344 B while archiving day reports for plugin âExamplePluginâ (for segment = ââ). [âcallAggregateAllPluginsâ,âMemory delta: 344 Bâ,âdayâ,âExamplePluginâ,â(for segment = ââ)â] {âclassâ:âVisitsSummaryâ,ârequest_idâ:2877601} [2019-03-20 11:50:09] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Archiving day reports for plugin âActionsâ. [âcallAggregateAllPluginsâ,âActionsâ] {âclassâ:âVisitsSummaryâ,ârequest_idâ:2877601} [2019-03-20 11:50:09] 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 piwik_log_link_visit_action AS log_link_visit_action LEFT JOIN piwik_log_action AS log_action ON log_link_visit_action.%s = log_action.idaction LEFT JOIN piwik_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â:2877601} [2019-03-20 11:50:09] 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 piwik_log_link_visit_action AS log_link_visit_action LEFT JOIN piwik_log_action AS log_action ON log_link_visit_action.%s = log_action.idaction LEFT JOIN piwik_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_cate
ERROR [2019-03-20 11:50:10] 2875911 3 total errors during this script execution, please investigate and try and fix these errors.
[Exception]
3 total errors during this script execution, please investigate and try and fix these errors.
core:archive [âurl=ââŚâ] [âforce-all-websites] [âforce-all-periods[=ââŚâ]] [âforce-timeout-for-periods[=ââŚâ]] [âskip-idsites[=ââŚâ]] [âskip-all-segments] [âforce-idsites[=ââŚâ]] [âforce-periods[=ââŚâ]] [âforce-date-last-n=ââŚâ] [âforce-date-range[=ââŚâ]] [âforce-idsegments=ââŚâ] [âconcurrent-requests-per-website[=ââŚâ]] [âconcurrent-archivers[=ââŚâ]] [âdisable-scheduled-tasks] [âaccept-invalid-ssl-certificate] [âphp-cli-options[=ââŚâ]]