How to delete an unavailable storage

If the storage contains backups or is specified in the schedule settings, it cannot be deleted through the platform interface.

In this case, you can delete the storage via the database (DB).

Instructions on how to delete the storage via the DB

1. Back up the platform. See the Creating backups manually of VMmanager 6 documentation for details.

   
   

   1. Connect to the server with VMmanager via SSH and enter the command:

      vm backup

   2.  Enter the password for the backup archive or press Enter to create an archive without a password. The backup will be saved in /opt/ispsystem/vm/backup/.

2. Connect to MySQL:

   docker exec -it mysql bash -c "mysql isp -p\$MYSQL_ROOT_PASSWORD"

3. Request a list of storages:

   SELECT id, name, state, connection_params FROM vm_backup_location\G ;

   Example of response:

   *************************** 1. row ***************************
                  id: 3
                name: ssh_example
               state: active
   connection_params: {"ip": "10.0.0.0", "path": "/backup", "port": 22, "login": "root"}

   Comments

   id — storage ID

   name — storage name

   state — current storage status

   connection_params — data for connecting to the storage

4. Delete records of backups that are in unavailable storage:

   DELETE FROM vm_disk_backup WHERE backup_location = <storage ID> ;

   Пояснения

   <storage ID> — the value has been obtained in step 3

5. Delete the storage:

   DELETE FROM vm_backup_location WHERE id = <storage ID> ;

   Пояснения

   <storage ID> — the value has been obtained in step 3