vRealize Automation 6.2.5 replica node with embedded clustered PSQL fails to upgrade to 7.6
Article ID: 319624
Updated On:
Products
VMware Aria Suite
Issue/Introduction
Symptoms:
Upgrading a vRealize Automation (vRA) 6.2.5 replica node with embedded clustered PSQL fails with this error:
Upgrading a vRealize Automation (vRA) 6.2.5 replica node with embedded clustered PSQL fails with this error:
****** Current service: advanced-designer-service
Upgrade:
Command execution failed with unexpected error: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase/advanced-designer-service-TA58422.xml::1393271824301-2::TA61870:
Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE public.asd_formscenario ADD CONSTRAINT asd_formscenario__resourceoperation_id__asd_resourceoperation__id__fkey FOREIGN KEY (resourceoperation_id) REFERENCES public.asd_resourceoperation (i
d) ON UPDATE NO ACTION ON DELETE NO ACTION: ERROR: there is no unique constraint matching given keys for referenced table "asd_resourceoperation".
Use -e option to get more details.
There are errors while upgrading the webapps database. Check /var/log/vcac/vcac-config.log for more information.
Error updating the DB.
Script /etc/bootstrap/postupdate.d/20-vcac failed, error status 2
Upgrade:
Command execution failed with unexpected error: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase/advanced-designer-service-TA58422.xml::1393271824301-2::TA61870:
Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE public.asd_formscenario ADD CONSTRAINT asd_formscenario__resourceoperation_id__asd_resourceoperation__id__fkey FOREIGN KEY (resourceoperation_id) REFERENCES public.asd_resourceoperation (i
d) ON UPDATE NO ACTION ON DELETE NO ACTION: ERROR: there is no unique constraint matching given keys for referenced table "asd_resourceoperation".
Use -e option to get more details.
There are errors while upgrading the webapps database. Check /var/log/vcac/vcac-config.log for more information.
Error updating the DB.
Script /etc/bootstrap/postupdate.d/20-vcac failed, error status 2
Environment
VMware vRealize Automation 7.6.x
VMware vRealize Automation 6.2.x
VMware vRealize Automation 6.2.x
Cause
This issue is caused by a known issue in liquibase. For more information, see https://liquibase.jira.com/browse/CORE-1718.
Resolution
To resolve this issue a new replica node needs to be created:
- SSH login to the primary node.
- Run this commands:
su - postgres
psql vcac
select * from cluster_nodes where node_host = 'REPLICA_FQDN'
delete from cluster_nodes where node_host = 'REPLICA_FQDN';
psql vcac
select * from cluster_nodes where node_host = 'REPLICA_FQDN'
delete from cluster_nodes where node_host = 'REPLICA_FQDN';
- Verify that the replica node is removed from the VAMI > Cluster page.
- Login to the primary node VAMI Management Console.
- Navigate to vRA > Messaging page.
- Click the Reset RabbitMQ Cluster button.
- Deploy new replica node and join it to the vRA cluster.
Feedback
Yes
No
Powered by
