Error making archive


(Günther Pfannhauser) #1

I started console core:archive --url=https://piwik.tiberius-systems.at/

but it gives me the folowing error:

/var/www/html/piwik/core/Common.php(271): Notice - unserialize(): Error at offset 0 of 53988 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-19 08:09:20] 8327 Empty or invalid response '[2019-03-19 08:09:19] 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, TagManager [] {“class”:“Piwik\Plugin\Manager”,“request_id”:8414} [2019-03-19 08:09:19] 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”:8414} [2019-03-19 08:09:19] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Initializing archiving process for all plugins [visits = 0, visits converted = ] [“callAggregateAllPlugins”,“0”,null] {“class”:“VisitsSummary”,“request_id”:8414} [2019-03-19 08:09:19] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin ‘ExamplePlugin’ (no visits). [“callAggregateAllPlugins”,“ExamplePlugin”] {“class”:“VisitsSummary”,“request_id”:8414} [2019-03-19 08:09:19] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin ‘Actions’ (no visits). [“callAggregateAllPlugins”,“Actions”] {“class”:“VisitsSummary”,“request_id”:8414} [2019-03-19 08:09:19] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin ‘Referrers’ (no visits). [“callAggregateAllPlugins”,“Referrers”] {“class”:“VisitsSummary”,“request_id”:8414} [2019-03-19 08:09:19] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin ‘UserLanguage’ (no visits). [“callAggregateAllPlugins”,“UserLanguage”] {“class”:“VisitsSummary”,“request_id”:8414} [2019-03-19 08:09:19] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin ‘DevicesDetection’ (no visits). [“callAggregateAllPlugins”,“DevicesDetection”] {“class”:“VisitsSummary”,“request_id”:8414} [2019-03-19 08:09:19] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin ‘Goals’ (no visits). [“callAggregateAllPlugins”,“Goals”] {“class”:“VisitsSummary”,“request_id”:8414} [2019-03-19 08:09:19] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin ‘Events’ (no visits). [“callAggregateAllPlugins”,“Events”] {“class”:“VisitsSummary”,“request_id”:8414} [2019-03-19 08:09:19] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin ‘UserCountry’ (no visits). [“callAggregateAllPlugins”,“UserCountry”] {“class”:“VisitsSummary”,“request_id”:8414} [2019-03-19 08:09:19] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin ‘VisitTime’ (no visits). [“callAggregateAllPlugins”,“VisitTime”] {“class”:“VisitsSummary”,“request_id”:8414} [2019-03-19 08:09:19] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin ‘VisitorInterest’ (no visits). [“callAggregateAllPlugins”,“VisitorInterest”] {“class”:“VisitsSummary”,“request_id”:8414} [2019-03-19 08:09:19] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin ‘CustomVariables’ (no visits). [“callAggregateAllPlugins”,“CustomVariables”] {“class”:“VisitsSummary”,“request_id”:8414} [2019-03-19 08:09:19] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin ‘Contents’ (no visits). [“callAggregateAllPlugins”,“Contents”] {“class”:“VisitsSummary”,“request_id”:8414} [2019-03-19 08:09:19] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin ‘Resolution’ (no visits). [“callAggregateAllPlugins”,“Resolution”] {“class”:“VisitsSummary”,“request_id”:8414} [2019-03-19 08:09:19] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin ‘DevicePlugins’ (no visits). [“callAggregateAllPlugins”,“DevicePlugins”] {“class”:“VisitsSummary”,“request_id”:8414} [2019-03-19 08:09:19] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin ‘UserId’ (no visits). [“callAggregateAllPlugins”,“UserId”] {“class”:“VisitsSummary”,“request_id”:8414} [2019-03-19 08:09:19] piwik.DEBUG: day archive, idSite = 4 (temporary archive), segment ‘’, report = ‘VisitsSummary’, UTC datetime [2019-03-18 23:00:00 -> 2019-03-19 22:59:59] [“day”,4,“temporary archive”,"",“VisitsSummary”,“2019-03-18 23:00:00”,“2019-03-19 22:59:59”] {“class”:“VisitsSummary”,“request_id”:8414} [2019-03-19 08:09:19] 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

any idea?

thanks in advance


(Dan) #2

I believe I have the same issue since upgrading to Matomo 3.9.0 this morning…

$ /usr/bin/php /home/analytics/public_html/console core:archive --url=https://analytics.example.com/
INFO [2019-03-19 09:58:42] 5768  ---------------------------
INFO [2019-03-19 09:58:42] 5768  INIT
INFO [2019-03-19 09:58:42] 5768  Running Matomo 3.9.0 as Super User
INFO [2019-03-19 09:58:42] 5768  ---------------------------
INFO [2019-03-19 09:58:42] 5768  NOTES
INFO [2019-03-19 09:58:42] 5768  - Reports for today will be processed at most every 150 seconds. You can change this value in Matomo UI > Settings > General Settings.
INFO [2019-03-19 09:58:42] 5768  - Reports for the current week/month/year will be requested at most every 3600 seconds.
INFO [2019-03-19 09:58:42] 5768  - Archiving was last executed without error 1 hours 23 min ago
INFO [2019-03-19 09:58:42] 5768  ---------------------------
INFO [2019-03-19 09:58:42] 5768  START
INFO [2019-03-19 09:58:42] 5768  Starting Matomo reports archiving...
INFO [2019-03-19 09:58:42] 5768  - tracking data found for website id 1 since 2019-03-19 08:35:06 UTC (since the last successful archiving)
INFO [2019-03-19 09:58:42] 5768  Will pre-process for website id = 1, period = day, date = last2
INFO [2019-03-19 09:58:42] 5768  - pre-processing all visits
WARNING [2019-03-19 09:58:43] 5768  /home/analytics/public_html/core/Common.php(271): Notice - unserialize(): Error at offset 0 of 112139 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-19 09:58:43] 5768  Empty or invalid response '[2019-03-19 09:58: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, 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, UserId, CustomPiwikJs, ForceSSL, MarketingCampaignsReporting, SecurityInfo [] {"class":"Piwik\\Plugin\\Manager","request_id":5858} [2019-03-19 09:58: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":5858} [2019-03-19 09:58:43] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Initializing archiving process for all plugins [visits = 28, visits converted = 0] ["callAggregateAllPlugins","28","0"] {"class":"VisitsSummary","request_id":5858} [2019-03-19 09:58:43] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Archiving day reports for plugin 'ExamplePlugin'. ["callAggregateAllPlugins","ExamplePlugin"] {"class":"VisitsSummary","request_id":5858} [2019-03-19 09:58:43] 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":5858} [2019-03-19 09:58:43] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Archiving day reports for plugin 'Actions'. ["callAggregateAllPlugins","Actions"] {"class":"VisitsSummary","request_id":5858} [2019-03-19 09:58: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":5858} [2019-03-19 09:58: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_ca
INFO [2019-03-19 09:58:43] 5768  - no new tracking data for website id 2 since 2019-03-19 08:35:06 UTC (since the last successful archiving)
INFO [2019-03-19 09:58:43] 5768  Skipped website id 2 as archiving is not needed
INFO [2019-03-19 09:58:43] 5768  - no new tracking data for website id 3 since 2019-03-19 08:35:06 UTC (since the last successful archiving)
INFO [2019-03-19 09:58:43] 5768  Skipped website id 3 as archiving is not needed
INFO [2019-03-19 09:58:43] 5768  - no new tracking data for website id 4 since 2019-03-19 08:35:06 UTC (since the last successful archiving)
INFO [2019-03-19 09:58:43] 5768  Skipped website id 4 as archiving is not needed
INFO [2019-03-19 09:58:43] 5768  - no new tracking data for website id 5 since 2019-03-19 08:35:06 UTC (since the last successful archiving)
INFO [2019-03-19 09:58:43] 5768  Skipped website id 5 as archiving is not needed
INFO [2019-03-19 09:58:43] 5768  - no new tracking data for website id 6 since 2019-03-19 08:35:06 UTC (since the last successful archiving)
INFO [2019-03-19 09:58:43] 5768  Skipped website id 6 as archiving is not needed
INFO [2019-03-19 09:58:43] 5768  - no new tracking data for website id 7 since 2019-03-19 08:35:06 UTC (since the last successful archiving)
INFO [2019-03-19 09:58:43] 5768  Skipped website id 7 as archiving is not needed
INFO [2019-03-19 09:58:43] 5768  Done archiving!
INFO [2019-03-19 09:58:43] 5768  ---------------------------
INFO [2019-03-19 09:58:43] 5768  SUMMARY
INFO [2019-03-19 09:58:43] 5768  Total visits for today across archived websites: 0
INFO [2019-03-19 09:58:43] 5768  Archived today's reports for 0 websites
INFO [2019-03-19 09:58:43] 5768  Archived week/month/year for 0 websites
INFO [2019-03-19 09:58:43] 5768  Skipped 7 websites
INFO [2019-03-19 09:58:43] 5768  - 6 skipped because no new visit since the last script execution
INFO [2019-03-19 09:58:43] 5768  - 0 skipped because existing daily reports are less than 150 seconds old
INFO [2019-03-19 09:58:43] 5768  - 0 skipped because existing week/month/year periods reports are less than 3600 seconds old
INFO [2019-03-19 09:58:43] 5768  - 1 skipped because got an error while querying reporting API
INFO [2019-03-19 09:58:43] 5768  Total API requests: 0
INFO [2019-03-19 09:58:43] 5768  done: 0/7 0%, 0 vtoday, 0 wtoday, 0 wperiods, 0 req, 1331 ms, 1 errors.
INFO [2019-03-19 09:58:43] 5768  Time elapsed: 1.331s
INFO [2019-03-19 09:58:43] 5768  ---------------------------
INFO [2019-03-19 09:58:43] 5768  SCHEDULED TASKS
INFO [2019-03-19 09:58:43] 5768  Starting Scheduled tasks... 
INFO [2019-03-19 09:58:43] 5768  done
INFO [2019-03-19 09:58:43] 5768  ---------------------------
INFO [2019-03-19 09:58:43] 5768  ---------------------------
INFO [2019-03-19 09:58:43] 5768  SUMMARY OF ERRORS
INFO [2019-03-19 09:58:43] 5768  Error: Empty or invalid response '[2019-03-19 09:58: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, 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, UserId, CustomPiwikJs, ForceSSL, MarketingCampaignsReporting, SecurityInfo [] {"class":"Piwik\\Plugin\\Manager","request_id":5858} [2019-03-19 09:58: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":5858} [2019-03-19 09:58:43] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Initializing archiving process for all plugins [visits = 28, visits converted = 0] ["callAggregateAllPlugins","28","0"] {"class":"VisitsSummary","request_id":5858} [2019-03-19 09:58:43] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Archiving day reports for plugin 'ExamplePlugin'. ["callAggregateAllPlugins","ExamplePlugin"] {"class":"VisitsSummary","request_id":5858} [2019-03-19 09:58:43] 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":5858} [2019-03-19 09:58:43] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Archiving day reports for plugin 'Actions'. ["callAggregateAllPlugins","Actions"] {"class":"VisitsSummary","request_id":5858} [2019-03-19 09:58: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":5858} [2019-03-19 09:58: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_ca
ERROR [2019-03-19 09:58:43] 5768  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[="..."]]

(Alex) #3

Has same issue Empty or invalid response when core:archive


(Matthieu Aubry) #4

Thanks for the report! let’s continue the discussion in Notice - unserialize(): Error at offset 0 of 53988 bytes · Issue #14229 · matomo-org/matomo · GitHub to consolidate into one place :slight_smile: