liquibase.exception.LockException: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.DatabaseException: Error executing SQL select count(*) from PUBLIC.DATABASECHANGELOGLOCK: user lacks privilege or object not found: DATABASECHANGELOGLOCK

JIRA | Dave Syer | 2 years ago
  1. 0

    When you use SpringLiquibase with dropFirst=true you get an error when the update is applied because the lock table has been dropped (I think): {noformat} INFO: Creating embedded database 'liquibasetest' INFO 27/10/14 14:11: liquibase: Successfully acquired change log lock INFO 27/10/14 14:11: liquibase: Dropping Database Objects in schema: PUBLIC.PUBLIC INFO 27/10/14 14:11: liquibase: Creating database history table with name: PUBLIC.DATABASECHANGELOG INFO 27/10/14 14:11: liquibase: Successfully released change log lock Oct 27, 2014 2:11:43 PM org.springframework.context.support.AbstractApplicationContext refresh WARNING: Exception encountered during context initialization - cancelling refresh attempt ... aused by: liquibase.exception.LockException: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.DatabaseException: Error executing SQL select count(*) from PUBLIC.DATABASECHANGELOGLOCK: user lacks privilege or object not found: DATABASECHANGELOGLOCK at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:214) at liquibase.lockservice.StandardLockService.waitForLock(StandardLockService.java:153) at liquibase.Liquibase.update(Liquibase.java:182) at liquibase.Liquibase.update(Liquibase.java:174) at liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:345) at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:302) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1627) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1564) ... 37 more Caused by: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.DatabaseException: Error executing SQL select count(*) from PUBLIC.DATABASECHANGELOGLOCK: user lacks privilege or object not found: DATABASECHANGELOGLOCK at liquibase.lockservice.StandardLockService.isDatabaseChangeLogLockTableInitialized(StandardLockService.java:121) at liquibase.lockservice.StandardLockService.init(StandardLockService.java:95) at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:187) ... 44 more ... {noformat}

    JIRA | 2 years ago | Dave Syer
    liquibase.exception.LockException: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.DatabaseException: Error executing SQL select count(*) from PUBLIC.DATABASECHANGELOGLOCK: user lacks privilege or object not found: DATABASECHANGELOGLOCK
  2. 0

    When you use SpringLiquibase with dropFirst=true you get an error when the update is applied because the lock table has been dropped (I think): {noformat} INFO: Creating embedded database 'liquibasetest' INFO 27/10/14 14:11: liquibase: Successfully acquired change log lock INFO 27/10/14 14:11: liquibase: Dropping Database Objects in schema: PUBLIC.PUBLIC INFO 27/10/14 14:11: liquibase: Creating database history table with name: PUBLIC.DATABASECHANGELOG INFO 27/10/14 14:11: liquibase: Successfully released change log lock Oct 27, 2014 2:11:43 PM org.springframework.context.support.AbstractApplicationContext refresh WARNING: Exception encountered during context initialization - cancelling refresh attempt ... aused by: liquibase.exception.LockException: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.DatabaseException: Error executing SQL select count(*) from PUBLIC.DATABASECHANGELOGLOCK: user lacks privilege or object not found: DATABASECHANGELOGLOCK at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:214) at liquibase.lockservice.StandardLockService.waitForLock(StandardLockService.java:153) at liquibase.Liquibase.update(Liquibase.java:182) at liquibase.Liquibase.update(Liquibase.java:174) at liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:345) at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:302) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1627) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1564) ... 37 more Caused by: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.DatabaseException: Error executing SQL select count(*) from PUBLIC.DATABASECHANGELOGLOCK: user lacks privilege or object not found: DATABASECHANGELOGLOCK at liquibase.lockservice.StandardLockService.isDatabaseChangeLogLockTableInitialized(StandardLockService.java:121) at liquibase.lockservice.StandardLockService.init(StandardLockService.java:95) at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:187) ... 44 more ... {noformat}

    JIRA | 2 years ago | Dave Syer
    liquibase.exception.LockException: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.DatabaseException: Error executing SQL select count(*) from PUBLIC.DATABASECHANGELOGLOCK: user lacks privilege or object not found: DATABASECHANGELOGLOCK
  3. 0

    spring liquibase / hsqldb integration

    Stack Overflow | 2 years ago | JayabalanAaron
    liquibase.exception.LockException: liquibase.exception.UnexpectedLiquibaseException: liquibase.snapshot.InvalidExampleException: Found multiple catalog/schemas matching null.PUBLIC
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    On ubuntu spring-boot fails

    GitHub | 1 year ago | pulkitnandan
    org.springframework.context.ApplicationContextException: Unable to start embedded container; nested exception is org.springframework.boot.context.embedded.EmbeddedServletContainerException: Unable to start embedded Tomcat
  6. 0

    latest image does not work

    GitHub | 1 year ago | gregory
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase-core' defined in URL [jar:file:/usr/share/cattle/b654598daad9f2d5479f67f96ddc2431/WEB-INF/lib/cattle-framework-db-loader-0.5.0-SNAPSHOT.jar!/META-INF/cattle/system/spring-db-loader-context.xml]: Invocation of init method failed; nested exception is liquibase.exception.LockException: Could not acquire change log lock. Currently locked by 881eb5d4360e (fe80:0:0:0:42:acff:fe11:17%54) since 10/12/15 4:52 AM

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. liquibase.exception.UnexpectedLiquibaseException

      liquibase.exception.DatabaseException: Error executing SQL select count(*) from PUBLIC.DATABASECHANGELOGLOCK: user lacks privilege or object not found: DATABASECHANGELOGLOCK

      at liquibase.lockservice.StandardLockService.isDatabaseChangeLogLockTableInitialized()
    2. Liquibase Core
      SpringLiquibase.afterPropertiesSet
      1. liquibase.lockservice.StandardLockService.isDatabaseChangeLogLockTableInitialized(StandardLockService.java:121)
      2. liquibase.lockservice.StandardLockService.init(StandardLockService.java:95)
      3. liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:187)
      4. liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:214)
      5. liquibase.lockservice.StandardLockService.waitForLock(StandardLockService.java:153)
      6. liquibase.Liquibase.update(Liquibase.java:182)
      7. liquibase.Liquibase.update(Liquibase.java:174)
      8. liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:345)
      9. liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:302)
      9 frames
    3. Spring Beans
      AbstractAutowireCapableBeanFactory.initializeBean
      1. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1627)
      2. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1564)
      2 frames