Tracking in real time works, but sum is zero

Hi,

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!

tracking-error

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!