You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
ERROR [2019-03-20 12:15:05] 15549 Empty or invalid response '[2019-03-20 12:15:03] piwik.DEBUG: Loaded plugins: CorePluginsAdmin, CoreAdminHome, CoreHome, WebsiteMeasurable, IntranetMeasurable, Diagnostics, CoreVisualizations, Proxy, API, Widgetize, Transitions, LanguagesManager, Actions, Dashboard, Referrers, UserLanguage, DevicesDetection, Goals, Ecommerce, SEO, Events, UserCountry, VisitsSummary, VisitFrequency, VisitTime, VisitorInterest, RssWidget, Monolog, Login, TwoFactorAuth, UsersManager, SitesManager, Installation, CoreUpdater, CoreConsole, ScheduledReports, UserCountryMap, Live, CustomVariables, ImageGraph, Annotations, Overlay, SegmentEditor, Insights, Morpheus, Contents, BulkTracking, Resolution, DevicePlugins, Heartbeat, Intl, Marketplace, ProfessionalServices, UserId, CustomPiwikJs, DBStats, Provider [] {"class":"Piwik\\Plugin\\Manager","request_id":15646} [2019-03-20 12:15:04] 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 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":15646} [2019-03-20 12:15:04] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Initializing archiving process for all plugins [visits = 55, visits converted = 0] ["callAggregateAllPlugins","55","0"] {"class":"VisitsSummary","request_id":15646} [2019-03-20 12:15:04] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Archiving day reports for plugin 'Actions'. ["callAggregateAllPlugins","Actions"] {"class":"VisitsSummary","request_id":15646} [2019-03-20 12:15:04] 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 log_link_visit_action AS log_link_visit_action LEFT JOIN log_action AS log_action ON log_link_visit_action.%s = log_action.idaction LEFT JOIN 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":15646} [2019-03-20 12:15:04] 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 log_link_visit_action AS log_link_visit_action LEFT JOIN log_action AS log_action ON log_link_visit_action.%s = log_action.idaction LEFT JOIN 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":15646} [2019-03-20 12:15:04] piwik.DEBUG: /* trigger = CronArchive */ SELECT log_visit.visit_entry_idaction_url as idaction, log_action.type, log_action.name, count(distinct log_visit.idvisitor) as `17`, count(*) as `19`, sum(log_visit.visit_total_actions) as `20`, sum(log_visit.visit_total_time) as `21`, sum(case log_visit.visit_total_actions when 1 then 1 when 0 then 1 else 0 end) as `22` FROM log_visit AS log_visit LEFT JOIN log_ac
ERROR [2019-03-20 12:15:12] 15549 1 total errors during this script execution, please investigate and try and fix these errors.
[Exception]
1 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[="..."]]
This also happens when run manually via console:
The text was updated successfully, but these errors were encountered:
After updating the core archive jobs fails:
This also happens when run manually via console:
The text was updated successfully, but these errors were encountered: