Database Upgrade Required

[Anatoly]

Database Upgrade Required
The following dimensions will be updated: log_conversion.example_conversion_dimension, log_link_visit_action.example_action_dimension, log_visit.example_visit_dimension.

Error during plugin updates:

/var/www/piwik/core/Columns/Updater.php: Error trying to execute the migration ‘ALTER TABLE piwik_log_visit ADD COLUMN example_visit_dimension INTEGER(11) DEFAULT 0 NULL;’. The error was: SQLSTATE[HY000]: General error: 1034 Incorrect key file for table ‘piwik_log_visit’; try to repair it
/var/www/piwik/core/Columns/Updater.php: Error trying to execute the migration ‘ALTER TABLE piwik_log_visit ADD COLUMN example_visit_dimension INTEGER(11) DEFAULT 0 NULL;’. The error was: SQLSTATE[HY000]: General error: 1034 Incorrect key file for table ‘piwik_log_visit’; try to repair it
/var/www/piwik/core/Columns/Updater.php: Error trying to execute the migration ‘ALTER TABLE piwik_log_visit ADD COLUMN example_visit_dimension INTEGER(11) DEFAULT 0 NULL;’. The error was: SQLSTATE[HY000]: General error: 1034 Incorrect key file for table ‘piwik_log_visit’; try to repair it

Please help solve the problem.
The tables are all integers and enough memory problem in the app.

[Lukas (Lukas Winkler)]

@Anatoly

Incorrect key file for table

Hi,

The error seems to be inside of MySQL.

According to some stackoverflow questions one reason could be corrupted databases or no free disk space in /tmp.

How do you fix a MySQL "Incorrect key file" error when you can't repair the table?

MySQL: #126 - Incorrect key file for table

[Anatoly]

@Lukas

According to some stackoverflow questions one reason could be corrupted databases or no free disk space in

RAM is sufficient and there is no tables with the extension *.MYI

[Anatoly]

Please help.
Can’t update the database.