General error: 1526 after 2.16.1 upgrading

Hi all,
Last week, I upgraded my piwik from 2.13 to 2.16.1. All seemed OK.
But 2 days after this change, Piwik stops collecting data. From this moment, I find the following error message :

[Sat Jun 11 02:06:57.904463 2016] [:error] [pid 6302] [client 10.90.xx.xx:548xx] Error in Piwik (tracker): Error query: SQLSTATE[HY000]: General error: 1526 Table has no partition for value 736491 In query: UPDATE piwik_pre_log_visit SET idvisitor = ?, visit_last_action_time = ?, visit_exit_idaction_name = ?, visit_exit_idaction_url = ?, visit_total_actions = visit_total_actions + 1 , visit_total_time = ?
, custom_var_k1 = ?, custom_var_v1 = ?, custom_var_k2 = ?, custom_var_v2 = ?, custom_var_k3 = ?, custom_var_v3 = ?, custom_var_k4 = ?, cu
stom_var_v4 = ?, custom_var_k5 = ?, custom_var_v5 = ? WHERE idsite = ? AND idvisit = ? Parameters: array ( 0 => ‘\xb1.\xa8+\xbf\xb3T@’, 1 => ‘2016-06-11 00:06:57’, 2 => '4170 […]

…Help :slight_smile:

Francois

Hi,

Resolved case.
Piwik was not at the origin of the problem, but the upgrade of MySQL was !
It’s because we upgraded Mysql before the change, that the partionning of the db failed !
We fixed the partitionning of DB, and Piwik works now !

…it could be help you, if you have the same error code :wink: