Uploaded image for project: 'Liquibase Core'
  1. CORE-3410

liquibase.exception.DatabaseException: Error getting jdbc:postgresql://127.0.0.1:5432/xe view with liquibase.statement.core.GetViewDefinitionStatement@7ea9e1e2

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects versions: 3.6.3
    • Fix versions: No Plans Yet
    • Components: Database Support
    • Environment:

      RHEL 7.4 i.e 3.10.0-693.11.6.el7.x86_64
      PostgreSQL 10 i.e postgresql10-10.7-2PGDG.rhel7.x86_64

    • Sprint:

      Description

      I am using PostgreSQL10 on RHEL 7.4 (64bit)
      Version as following postgresql10-10.7-2PGDG.rhel7.x86_64

      When i try to update liquibase, getting following error.

      $ ./liquibase update
      Liquibase Home is not set.
      Unexpected error running Liquibase: liquibase.exception.DatabaseException: Error getting jdbc:postgresql://127.0.0.1:5432/xe view with liquibare.GetViewDefinitionStatement@7ea9e1e2

      in Debug.

      $ ./liquibase --logLevel=debug update
      Liquibase Home is not set.
      DEBUG 4/04/19 11:25 AM: liquibase: Connected to umarket_installer_adm@jdbc:postgresql://127.0.0.1:5432/xe
      DEBUG 4/04/19 11:25 AM: liquibase: Setting auto commit to false from true
      DEBUG 4/04/19 11:25 AM: liquibase: Computed checksum for 1554377102674 as 7b588e5a4fc49ed166664e82dda51033
      DEBUG 4/04/19 11:25 AM: liquibase: Executing QUERY database command: select definition from pg_views where viewname='constraint_table_usage' A               ND schemaname='umarket_installer_adm'
      Unexpected error running Liquibase: liquibase.exception.DatabaseException: Error getting jdbc:postgresql://127.0.0.1:5432/xe view with liquiba               se.statement.core.GetViewDefinitionStatement@24fcf36f
      
      SEVERE 4/04/19 11:25 AM: liquibase: liquibase.exception.DatabaseException: Error getting jdbc:postgresql://127.0.0.1:5432/xe view with liquiba               se.statement.core.GetViewDefinitionStatement@24fcf36f
      liquibase.exception.LockException: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.DatabaseException: Error getting jdbc               :postgresql://127.0.0.1:5432/xe view with liquibase.statement.core.GetViewDefinitionStatement@24fcf36f
              at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:215)
              at liquibase.lockservice.StandardLockService.waitForLock(StandardLockService.java:154)
              at liquibase.Liquibase.update(Liquibase.java:186)
              at liquibase.integration.commandline.Main.doMigration(Main.java:1044)
              at liquibase.integration.commandline.Main.run(Main.java:175)
              at liquibase.integration.commandline.Main.main(Main.java:94)
      Caused by: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.DatabaseException: Error getting jdbc:postgresql://127.0.0.1:               5432/xe view with liquibase.statement.core.GetViewDefinitionStatement@24fcf36f
              at liquibase.lockservice.StandardLockService.hasDatabaseChangeLogLockTable(StandardLockService.java:141)
              at liquibase.lockservice.StandardLockService.init(StandardLockService.java:85)
              at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:188)
              ... 5 more
      Caused by: liquibase.exception.DatabaseException: Error getting jdbc:postgresql://127.0.0.1:5432/xe view with liquibase.statement.core.GetView               DefinitionStatement@24fcf36f
              at liquibase.snapshot.jvm.ViewSnapshotGenerator.snapshotObject(ViewSnapshotGenerator.java:95)
              at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:60)
              at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:50)
              at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:63)
              at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:50)
              at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:163)
              at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:241)
              at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:263)
              at liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:195)
              at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:177)
              at liquibase.snapshot.DatabaseSnapshot.init(DatabaseSnapshot.java:60)
              at liquibase.snapshot.DatabaseSnapshot.<init>(DatabaseSnapshot.java:37)
              at liquibase.snapshot.JdbcDatabaseSnapshot.<init>(JdbcDatabaseSnapshot.java:25)
              at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:126)
              at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:119)
              at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:107)
              at liquibase.snapshot.SnapshotGeneratorFactory.has(SnapshotGeneratorFactory.java:97)
              at liquibase.snapshot.SnapshotGeneratorFactory.hasDatabaseChangeLogLockTable(SnapshotGeneratorFactory.java:166)
              at liquibase.lockservice.StandardLockService.hasDatabaseChangeLogLockTable(StandardLockService.java:139)
              ... 7 more
      Caused by: liquibase.exception.DatabaseException: Expected single row from liquibase.statement.core.GetViewDefinitionStatement@7ea9e1e2 but go               t 0
              at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:155)
              at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:166)
              at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:161)
              at liquibase.database.AbstractJdbcDatabase.getViewDefinition(AbstractJdbcDatabase.java:862)
              at liquibase.snapshot.jvm.ViewSnapshotGenerator.snapshotObject(ViewSnapshotGenerator.java:75)
              ... 25 more
      Caused by: liquibase.exception.DatabaseException: Empty result set, expected one row
              at liquibase.util.JdbcUtils.requiredSingleResult(JdbcUtils.java:141)
              at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:153)
              ... 29 more
      
      
      For more information, use the --logLevel flag
      
      

        Attachments

          Activity

            People

            • Reporter:
              raman38192 sabkuch milega
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: