today I did the update from 3.0.4 to 3.1.0. Then I saw, that for 4 sites (from about 20 sites), the last visits sum is zero since 6th of September 2017. The tracking works, live tracking shows visitors… please see the screenshot!
I’ve found the following in the errorlog:
[07-Sep-2017 10:45:41 UTC] Error in Piwik (tracker): Error query: SQLSTATE[HY000]: General error: 1194
Table ‘piwik_log_visit’ is marked as crashed and should be repaired In query: SELECT visit_last_action_time, visit_first_action_time, idvisitor, idvisit, user_id, visit_exit_idaction_url, visit_exit_idaction_name, visitor_returning, visitor_days_since_first, visitor_days_since_order, visitor_count_visits, visit_goal_buyer, location_country, location_region, location_city, location_latitude, location_longitude, referer_name, referer_keyword, referer_type, idsite, visit_entry_idaction_url, visit_total_actions, visit_total_interactions, visit_total_searches, config_device_brand, config_device_model, config_device_type, visit_total_events, visit_total_time, location_ip, location_browser_lang, custom_var_k1, custom_var_v1, custom_var_k2, custom_var_v2, custom_var_k3, custom_var_v3, custom_var_k4, custom_var_v4, custom_var_k5, custom_var_v5 FROM piwik_log_visit WHERE visit_last_action_time >= ? AND visit_last_action_time <= ? AND idsite = ? AND idvisitor = ? ORDER BY visit_last_action_time DESC LIMIT 1 Parameters: array ( 0 => ‘2017-09-07 10:15:40’, 1 => ‘2017-09-07 11:15:40’, 2 => 12, 3 => ‘é„Þ_‰ïO’, )
I repaired the table in piwik. How can this crash happen and why are only 4 sites affected?
The table piwik_log_visit counts 1.9 GB. Is this a problem. We already use the archive cron option!?
Thanks for any help!!