In the table log_visit we have more that 52 million rows.
The update process is not finising while doing:
Executing ALTER TABLE `log_visit` MODIFY COLUMN `location_region` char(3) DEFAULT NULL;... [X] Error during plugin updates: * /var/www/piwik-3.5.1/core/Columns/Updater.php: Error trying to execute the migration 'ALTER TABLE `log_visit` MODIFY COLUMN `location_region` char(3) DEFAULT NULL;'. The error was: SQLSTATE: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction The update completed successfuly, however there were issues during the process. Please read the above descriptions for details. For further help:
Any suggestions on how to handle this?
I have maintenance mode enabled and loggin disabled.