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_disks
Bosh::Director::Models::PersistentDisk.where(disk_cid:"blah").first.instance.persistent_disks
Bosh::Director::Models::PersistentDisk.where(disk_cid:"blah").first.delete
bosh cck
and it passedbosh deploy
(with mysql targeted as deploy)bosh instances --details
& bosh vms --ps
and verified all was good