Search the VMware Knowledge Base (KB)
View by Article ID

Directories Management Identity Manager fails to start after Horizon-Workspace restart (2151103)

  • 0 Ratings

Symptoms

  • In a vRealize Automation high availability environment, the Directories Management Identity Manager can fail to start after the horizon-workspace service is restarted.
  • The horizon-workspace service is unable to start. You see an error similar to:

    Error creating bean with name
      'liquibase' defined in class path resource [spring/datastore-wireup.xml]:
      Invocation of init method failed; nested exception is
      liquibase.exception.LockException: Could not acquire change log lock. Currently
      locked by fe80:0:0:0:250:56ff:fea8:7d0c%eth0
      (fe80:0:0:0:250:56ff:fea8:7d0c%eth0) since 10/29/15

Cause

The Identity Manager fails to start in a high availability environment because of issues with the liquibase data management utility used by vRealize Automation

Resolution

This is a known issue affecting VMware vRealize Automation 7.x. For more information see, Troubleshooting the vRealize Automation Appliance section of Installing and Upgrading vRealize Automation guide.

Currently, there is no resolution.
 
To work around this issue:

  1. Log in using root credentials to a console session on the vRealize Automation appliance.
  2. Stop the horizon-workspace service by running the command:

    #service horizon-workspace stop

  3. Open the postgres shell as super user:

    su postgres

  4. Navigate to the correct bin directory by running the command: 

    cd /opt/vmware/vpostgres/current/bin

  5. Connect to the database by running the command:

    psql vcac

  6. From saas.databasechangeloglock, run the SQL query:

    select * from databasechangeloglock;


    If the output shows a value of t for true, the lock must be released manually.

  7. If you need to manually release the lock, run the SQL query:

    update saas.databasechangeloglock" set locked=FALSE, lockgranted=NULL, lockedby=NULL where id=1;

  8. From saas.databasechangeloglock, run the SQL query:

    select *


    The output should show a value of f for false, meaning it is unlocked.

  9. Exit the postgres vcac database by running the command:

    vcac=# \q

  10. Close the postgres shell by running the command: 

    exit

  11. Start the horizon-workspace service by running the command:

    #service horizon-workspace start

Additional Information

To be alerted when this article is updated, click Subscribe to Document in the Actions box.

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 0 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.

What can we do to improve this information? (4000 or fewer characters)




Please enter the Captcha code before clicking Submit.
  • 0 Ratings
Actions
KB: