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

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 jdbcostgresql://127.0.0.1:5432/xe view with liquibare.GetViewDefinitionStatement@7ea9e1e2

in Debug.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 $ ./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

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

Status

Assignee

Unassigned

Reporter

sabkuch milega

Labels

None

Components

Fix versions

Affects versions

3.6.3

Priority

Major
Configure