Cron Daemon errors on Greengeeks hosting and PHP7.2


#1

Hello!
I’ve installed the latest 3.9.0 version of Matomo thanks to the Softaculous script into cPanel of my Greengeeks hosting.

As said I do have PHP7.2 set as default for my domain(s).

I am receiving these emails:


ERROR [2019-03-21 10:29:04] 16383  Empty or invalid response '[2019-03-21 10:29:04] piwik.DEBUG: Loaded plugins: CorePluginsAdmin, CoreAdminHome, CoreHome, WebsiteMeasurable, IntranetMeasurable, Diagnostics, CoreVisualizations, Proxy, API, ExamplePlugin, Widgetize, Transitions, LanguagesManager, Actions, Dashboard, MultiSites, Referrers, UserLanguage, DevicesDetection, Goals, 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, SecurityInfo [] {"class":"Piwik\\Plugin\\Manager","request_id":16923} a:2:{s:10:"2019-03-20";a:0:{}s:10:"2019-03-21";a:0:{}}' for website id 1, Time elapsed: 1.614s, skipping
ERROR [2019-03-21 10:29:06] 16383  Empty or invalid response '[2019-03-21 10:29: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, 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, SecurityInfo [] {"class":"Piwik\\Plugin\\Manager","request_id":17309} [2019-03-21 10:29: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     mtm_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":17309} [2019-03-21 10:29:06] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Initializing archiving process for all plugins [visits = 14, visits converted = 0] ["callAggregateAllPlugins",14,"0"] {"class":"VisitsSummary","request_id":17309} [2019-03-21 10:29:06] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Archiving day reports for plugin 'ExamplePlugin'. ["callAggregateAllPlugins","ExamplePlugin"] {"class":"VisitsSummary","request_id":17309} [2019-03-21 10:29:06] 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":17309} [2019-03-21 10:29:06] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Archiving day reports for plugin 'Actions'. ["callAggregateAllPlugins","Actions"] {"class":"VisitsSummary","request_id":17309} [2019-03-21 10:29:06] 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     mtm_log_link_visit_action AS log_link_visit_action LEFT JOIN mtm_log_action AS log_action ON log_link_visit_action.%s = log_action.idaction LEFT JOIN mtm_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":17309} [2019-03-21 10:29:06] 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     mtm_log_link_visit_action AS log_link_visit_action LEFT JOIN mtm_log_action AS log_action ON log_link_visit_action.%s = log_action.idaction LEFT JOIN mtm_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
ERROR [2019-03-21 10:29:07] 16383  Empty or invalid response '[2019-03-21 10:29:07] piwik.DEBUG: Loaded plugins: CorePluginsAdmin, CoreAdminHome, CoreHome, WebsiteMeasurable, IntranetMeasurable, Diagnostics, CoreVisualizations, Proxy, API, ExamplePlugin, Widgetize, Transitions, LanguagesManager, Actions, Dashboard, MultiSites, Referrers, UserLanguage, DevicesDetection, Goals, 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, SecurityInfo [] {"class":"Piwik\\Plugin\\Manager","request_id":17815} [2019-03-21 10:29:07] 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     mtm_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":17815} [2019-03-21 10:29:07] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Initializing archiving process for all plugins [visits = 0, visits converted = ] ["callAggregateAllPlugins",0,null] {"class":"VisitsSummary","request_id":17815} [2019-03-21 10:29:07] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin 'ExamplePlugin' (no visits). ["callAggregateAllPlugins","ExamplePlugin"] {"class":"VisitsSummary","request_id":17815} [2019-03-21 10:29:07] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin 'Actions' (no visits). ["callAggregateAllPlugins","Actions"] {"class":"VisitsSummary","request_id":17815} [2019-03-21 10:29:07] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin 'Referrers' (no visits). ["callAggregateAllPlugins","Referrers"] {"class":"VisitsSummary","request_id":17815} [2019-03-21 10:29:07] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin 'UserLanguage' (no visits). ["callAggregateAllPlugins","UserLanguage"] {"class":"VisitsSummary","request_id":17815} [2019-03-21 10:29:07] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin 'DevicesDetection' (no visits). ["callAggregateAllPlugins","DevicesDetection"] {"class":"VisitsSummary","request_id":17815} [2019-03-21 10:29:07] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin 'Goals' (no visits). ["callAggregateAllPlugins","Goals"] {"class":"VisitsSummary","request_id":17815} [2019-03-21 10:29:07] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin 'Events' (no visits). ["callAggregateAllPlugins","Events"] {"class":"VisitsSummary","request_id":17815} [2019-03-21 10:29:07] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin 'UserCountry' (no visits). ["callAggregateAllPlugins","UserCountry"] {"class":"VisitsSummary","request_id":17815} [2019-03-21 10:29:07] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin 'VisitTime' (no visits). ["callAggregateAllPlugins","VisitTime"] {"class":"VisitsSummary","request_id":17815} [2019-03-21 10:29:07] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin 'VisitorInterest' (no visits). ["callAggregateAllPlugins","VisitorInterest"] {"class":"VisitsSummary","request_id":17815} [2019-03-21 10:29:07] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin 'CustomVariables' (no visits). ["callAggregateAllPlugins","CustomVariables"] {"class":"VisitsSummary","request_id":17815} [2019-03-21 10:29:07] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin 'Contents' (no visits). ["callAggregateAllPlugins","Contents"] {"class":"VisitsSummary","request_id":17815} [2019-03-21 10:29:07] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin 'Resolution' (no visits). ["callAggregateAllPlugins","Resolution"] {"class":"VisitsSummary","request_id":17815} [2019-03-21 10:29:07] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin 'DevicePlugins' (no visits). ["callAggregateAllPlugins","DevicePlugins"] {"class":"VisitsSummary","request_id":17815} [2019-03-21 10:29:07] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Skipping archiving for plugin 'UserId' (no visits). ["callAggregateAllPlugins","UserId"] {"class":"VisitsSummary","request_id":17815} [2019-03-21 10:29:07] piwik.DEBUG: day archive, idSite = 3 (temporary archive), segment '', report = 'VisitsSummary', UTC datetime [2019-03-20 23:00:00 -> 2019-03-21 22:59:59] ["day",3,"temporary archive","","VisitsSummary","2019-03-20 23:00:00","2019-03-21 22:59:59"] {"class":"VisitsSummary","request_id":17815} [2019-03-21 10:29:07] 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     mtm_log_v
ERROR [2019-03-21 10:29:08] 16383  Empty or invalid response '[2019-03-21 10:29: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, 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, SecurityInfo [] {"class":"Piwik\\Plugin\\Manager","request_id":18113} [2019-03-21 10:29: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     mtm_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":18113} [2019-03-21 10:29:08] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Initializing archiving process for all plugins [visits = 10, visits converted = 0] ["callAggregateAllPlugins",10,"0"] {"class":"VisitsSummary","request_id":18113} [2019-03-21 10:29:08] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Archiving day reports for plugin 'ExamplePlugin'. ["callAggregateAllPlugins","ExamplePlugin"] {"class":"VisitsSummary","request_id":18113} [2019-03-21 10:29:08] 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":18113} [2019-03-21 10:29:08] piwik.DEBUG: PluginsArchiver::callAggregateAllPlugins: Archiving day reports for plugin 'Actions'. ["callAggregateAllPlugins","Actions"] {"class":"VisitsSummary","request_id":18113} [2019-03-21 10:29:08] 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     mtm_log_link_visit_action AS log_link_visit_action LEFT JOIN mtm_log_action AS log_action ON log_link_visit_action.%s = log_action.idaction LEFT JOIN mtm_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":18113} [2019-03-21 10:29:08] 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     mtm_log_link_visit_action AS log_link_visit_action LEFT JOIN mtm_log_action AS log_action ON log_link_visit_action.%s = log_action.idaction LEFT JOIN mtm_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
ERROR [2019-03-21 10:29:08] 16383  4 total errors during this script execution, please investigate and try and fix these errors.


                                                                                                 
  [Exception]                                                                                    
  4 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[="..."]]

(Fabian Dellwing) #2

Please update to 3.9.1 released today, 3.9.0 is sadly broken.