My site is running piwik 2.14.3 and MySql Ver 14.14 Distrib 5.5.46 on Ubuntu.
Import of logs is scheduled for 02:00. In the webserver logs during the attempted import is seen:
====
[Mon Nov 09 02:02:56 2015] [error] [client 140.211.11.134] Error in Piwik (tracker): Error query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction In query: UPDATE piwik_log_visit SET idvisitor = ?, visit_total_time = ?, visit_last_action_time = ?, visit_exit_idaction_url = ?, visit_total_actions = visit_total_actions + 1 WHERE idsite = ? AND idvisit = ? Parameters: array ( 0 => ‘QT\x16\xa8\xca\xcf\xc9\xf2’, 1 => 1, 2 => ‘2015-10-09 21:05:13’, 3 => 1, 4 => 1, 5 => 1, )
[Mon Nov 09 02:04:00 2015] [error] [client 140.211.11.134] Error in Piwik (tracker): Error query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction In query: UPDATE piwik_log_visit SET idvisitor = ?, visit_total_time = ?, visit_last_action_time = ?, visit_exit_idaction_url = ?, visit_total_actions = visit_total_actions + 1 WHERE idsite = ? AND idvisit = ? Parameters: array ( 0 => ‘QT\x16\xa8\xca\xcf\xc9\xf2’, 1 => 1, 2 => ‘2015-10-09 21:05:13’, 3 => 1, 4 => 1, 5 => 1, )
[Mon Nov 09 02:04:54 2015] [error] [client 140.211.11.134] Error in Piwik (tracker): Error query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction In query: UPDATE piwik_log_visit SET idvisitor = ?, visit_total_time = ?, visit_last_action_time = ?, visit_exit_idaction_url = ?, visit_total_actions = visit_total_actions + 1 WHERE idsite = ? AND idvisit = ? Parameters: array ( 0 => ‘[\xb4\x93+\xac\x84\x11b’, 1 => 1, 2 => ‘2015-10-09 21:05:13’, 3 => 1, 4 => 1, 5 => 89, )
[Mon Nov 09 02:05:54 2015] [error] [client 140.211.11.134] Error in Piwik (tracker): Error query: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction In query: UPDATE piwik_log_visit SET idvisitor = ?, visit_total_time = ?, visit_last_action_time = ?, visit_exit_idaction_url = ?, visit_total_actions = visit_total_actions + 1 WHERE idsite = ? AND idvisit = ? Parameters: array ( 0 => ‘QT\x16\xa8\xca\xcf\xc9\xf2’, 1 => 13, 2 => ‘2015-10-09 21:05:25’, 3 => 9, 4 => 1, 5 => 1, )
…
====
Based on another post, already tried hacking config.ini.php by adding:
bulk_requests_use_transaction=0
without success.
Lou.