Applicable to:
- SolusVM 2
Symptoms
- SolusVM 2 update fails:
SVM_ERROR: Failed to download update
- The following error is in the log file /var/log/solus/installer.log on Management node:
CONFIG_TEXT: ERROR: constraint \"compute_resource_vms_storage_id_foreign\" of relation \"compute_resource_vms\" does not exist
Cause
Database inconsistency.
Resolution
- Connect to Management node via SSH
- Create Management node backup:
# /usr/local/solus/bin/installer -backup
- Access 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'})
- Add the missing indexes:
MYSQL_LIN: ALTER TABLE compute_resource_vms ADD CONSTRAINT "compute_resource_vms_storage_id_foreign" FOREIGN KEY (storage_id) REFERENCES storages(id) ON UPDATE CASCADE ON DELETE SET NULL;
Comments
0 commentsPlease sign in to leave a comment.