Edit

Upgrade: HSDI_migrate_runs errors or not found

Symptoms

MySQL migration is interrupted.

Execute: migrate status

...
20170223131755 2017-04-19 16:26:12 CC-21389 rename HSD HSDIL to archivate
20170223131756    ...pending...    CC-21389 migrate non active runs
20170302104253 2017-04-19 16:26:13 CC-21669 - add index by run id on WorkerActivityLog
...

The script throws the following (or a similar) error:

PROCEDURE mturk.HSDI_migrate_runs does not exist

Root cause

Incompatible migrations when trying to upgrade WorkFusion 8.4.0. Other versions (8.3.x, 8.4.x) should be upgradable.

Resolution

1. Migrate non-active runs:

   CALL HSDI_migrate_runs(false);   
   

2. Mark the migration as completed:

   insert into CHANGELOG( ID, APPLIED_AT, DESCRIPTION) values( 20170223131756, now(), 'CC-21389_migrate_non_active_runs');
   

3. Clear objects:

   insert into PREFERENCE
         ( PREFERENCE_KEY                 , PREFERENCE_TYPE, BOOLEAN_VALUE)
   values( 'FINISHED_RUN_MIGRATION_STEP_1', 'BOOLEAN'      , 1            )
   ;
   
   alter table AwsHit
     modify column `hitId`      varchar(100)   NULL
   , drop foreign key `FK_awsHit_hitData`
   , drop         key `FK_awsHit_hitData_idx`
   , drop column `hitData_id`
   ;
   
   drop procedure if exists HSDI_migrate_AHAA ;
   drop procedure if exists HSDI_migrate_byRun;
   drop procedure if exists HSDI_migrate_final;
   drop procedure if exists HSDI_migrate_gold ;
   drop procedure if exists HSDI_migrate_ids  ;
   drop procedure if exists HSDI_migrate_runs ;
   drop procedure if exists HSDI_migrate_trace;
   
   drop table if exists AwsHitAssignmentAnswer_83      ;
   drop table if exists AwsHitQuestion_83              ;
   drop table if exists HitDataItemLog_83              ;
   drop table if exists HitSubmissionDataItemHistory_83;
   drop table if exists HitSubmissionDataItemLink_83   ;
   drop table if exists HitSubmissionDataItemValue_83  ;
   drop table if exists HitSubmissionDataItem_83       ;
   drop table if exists HitSubmissionData_83           ;
   drop table if exists HitItem_ids                    ;
   drop table if exists HSDI_migrate_progress          ;
   drop view  if exists HIT_DATA_ITEMS                 ;