Tracking in real time works, but sum is zero


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!!

Crashed tables are not a piwik issue. have a look at mysql - What causes tables to need to be repaired? - Stack Overflow why tables crash and try to solve the root cause for that.

1 Like

Repair of piwik_log_visit wasn’t enough - I’ve repaired some other tables and checked the whole database. Then everything was ok again. I don’t know what the crash caused and I hope it doesn’t happen again!
As the installation is located on an external server provider, I can’t follow the tipps from the link !?
However, thanks a lot!