Cloud Migration Assistant app shows up in the list of apps even after being uninstalled

Issue Summary

Cloud Migration Assistant app shows up in the list of user installed apps even after being uninstalled from the UI

Steps to Reproduce

1. Go to    ** > Manage Apps
2. Choose User Installed from the drop-down
3. Uninstall Cloud Migration Assistant app, a message would pop-up stating the app has been uninstalled

Expected Results

Cloud Migration Assistant app is uninstalled completely

Actual Results

After each restart Cloud Migration Assistant app shows up in the list again with the below

Notes

• It would also throw the below error in the logs:

  2019-03-26 17:04:43,015 ERROR [Caesium-1-3] [migration.agent.queue.QueueBroker] error An error occurred when getting the next batch for consumer type: CONFLUENCE_IMPORT. Message: org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: missing column [scheduleDate] in table [MIG_PLAN]
  com.atlassian.util.concurrent.LazyReference$InitializationException: org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: missing column [scheduleDate] in table [MIG_PLAN]
          at com.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:149)
          at com.atlassian.util.concurrent.LazyReference.get(LazyReference.java:112)
  

• The only way to get around this log spam is to drop the tables associated with Migration Assistant and clear caches as per the documentation:

  drop table MIG_ANALYTICS_EVENT;
  drop table MIG_ATTACHMENT;
  drop table MIG_SEQUENCES;
  drop table MIG_STATS;
  drop table MIG_STEP;
  drop table MIG_TASK;
  drop table MIG_WORK_ITEM;
  drop table MIG_PLAN;
  drop table MIG_CLOUD_SITE;
  drop table MIG_DB_CHANGELOG;
  drop table MIG_DB_CHANGELOG_LOCK;
  

Workaround

Currently, there is no known workaround wholistically as far as the UI is concerned but if we check the status of the app from the database you will notice that the app is actually uninstalled

DB Query

select PLUGINDATAID, PLUGINKEY, FILENAME, LASTMODDATE from PLUGINDATA;