need some urgent help
we are trying to upgrade our piwik version from 2.16 to 3.0.3 and the db upgrade doesn’t seem to work. I am running it from the server and query updating this table in particular fails piwik_log_link_visit_action. our DB is 750 G and that table has 2 billion rows. after running for several hours it fails with this error ERROR 1034 (HY000): Incorrect key file for table ‘piwik_log_link_visit_action’; try to repair it. Is there another way to update this table ? I need to run two alter statements
ALTER TABLE piwik_log_link_visit_action ADD COLUMN idpageview CHAR(6) NULL DEFAULT NULL, ADD COLUMN interaction_position SMALLINT UNSIGNED DEFAULT NULL, MODIFY COLUMN time_spent_ref_action INTEGER(10) UNSIGNED NULL;
ALTER TABLE piwik_log_link_visit_action CHANGE idlink_va idlink_va BIGINT(10) UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE idvisit idvisit BIGINT(10) UNSIGNED NOT NULL, CHANGE idaction_name_ref idaction_name_ref INTEGER(10) UNSIGNED NULL;
lplease help …the system is down for our users and can’t be used untill the DB upgrade is complete.