This article will explain how to fix the MySQL instance. We will delete the disk reference and replace it with a new blank one.
This was the process followed:
bosh cck and deleted the disk referencessh vcap@<director-IP> password in the Operations Manager Director tile credentials section under VM Credentials)Bosh::Director::Models::PersistentDisk.where(disk_cid:"blah").all (Blah is swapped with the disk-id previously recorded)Bosh::Director::Models::PersistentDisk.where(disk_cid:"blah").first.update(active: false)Bosh::Director::Models::PersistentDisk.where(disk_cid:"blah").instance.persistent_disksBosh::Director::Models::PersistentDisk.where(disk_cid:"blah").first.instance.persistent_disksBosh::Director::Models::PersistentDisk.where(disk_cid:"blah").first.deletebosh cck and it passedbosh deploy (with mysql targeted as deploy)bosh instances --details & bosh vms --ps and verified all was good