Unable to create a VPS on Compute Resource with resource usage limit even though the resource limit is not actually exceeded

Symptoms 

Unable to create a VPS on Compute Resource with resource usage limit even though the resource limit is not actually exceeded. The following error is displayed upon attempt to create VPS:

SVM_ERROR: The compute resource usage limits are exceeded.

Cause

Usage in database and actual usage do not correspond.

SolusVM 2 bug #SIO-6911, which will be fixed in future updates.

Resolution

1. Connected to the Management node via SSH
2. Created the MN backup:

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

3. Accessed the database:

   # docker exec -it $(docker ps -q -f name=solus_postgres | head -n1) psql -U$(docker exec $(docker ps -q -f name=solus_postgres | head -n1) env | grep POSTGRES_USER | awk -F "=" {'print $2'}) $(docker exec $(docker ps -q -f name=solus_postgres | head -n1) env | grep POSTGRES_DB | awk -F "=" {'print $2'})

4. Ran the query:

   # update compute_resources set settings=settings||'{"limits": {"vm": {"used": 15, "total": 0, "unlimited": true},"hdd": {"used": 9500, "total": 0, "unlimited": true}, "ram": {"used": 125627793408, "total": 130996502528, "unlimited": false}, "vcpu": {"used": 60, "total": 62, "unlimited": false}}}' where id=22;