Unable to update SolusVM 2: Attempt to read property "type" on null

Symptoms 

Unable to update SolusVM 2. The following error can be found in /var/log/solus/installer.log on Management node:

CONFIG_TEXT: Aug 30 06:32:02 painel 177338b6b058[4554]: 2023_07_18_133420_separate_server_disks ......................... 184ms FAIL
Aug 30 06:32:02 painel 177338b6b058[4554]: [2023-08-30 06:32:02] production.ERROR: Attempt to read property "type" on null {"exception":"[object] (ErrorException(code: 0): Attempt to read property \"type\" on null at /var/www/backend/database/postMigrations/2023_07_18_133420_separate_server_disks.php:48)
Aug 30 06:32:02 painel 177338b6b058[4554]: [stacktrace]

Cause

There are VPSes pointing to non-existing Storage in the database.

Resolution

1. Connect to Management node via SSH

2. Backup Management node:

   # /usr/local/solus/bin/installer -backup

3. Access SolusVM 2 database

4. Find the VPSes with non-existing storages:

   MYSQL_LIN: select id from compute_resource_vms where storage_id not in (select id from storages);

5. Update the entries for the VPSes:

   MYSQL_LIN: update compute_resource_vms set storage_id =STORAGE_ID where id=VM_ID;

   Replace STORAGE_ID and VM_ID correspondingly.