liquibase.exception.MigrationFailedException: Migration failed for change set add-column-create-index-drop-column.xml::Test viewExists::test: Reason: add-column-create-index-drop-column.xml : liquibase.precondition.core.ViewExistsPrecondition@1a3938c5 : Empty result set, expected one row

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via JIRA by Lonny Jacobson, 1 year ago
Migration failed for change set add-column-create-index-drop-column.xml::Test viewExists::test: Reason: add-column-create-index-drop-column.xml : liquibase.precondition.core.ViewExistsPrecondition@1a3938c5 : Empty result set, expected one row
via JIRA by Lonny Jacobson, 1 year ago
Migration failed for change set add-column-create-index-drop-column.xml::Test viewExists::test: Reason: add-column-create-index-drop-column.xml : liquibase.precondition.core.ViewExistsPrecondition@1a3938c5 : Empty result set, expected one row
via JIRA by Dzmitry Kazimirchyk, 1 year ago
Migration failed for change set resources/liquibase/initialSchema/schema.xml::createIndex::dzmitry: Reason: resources/liquibase/liquibase.db.changelog.xml : Index Exists Precondition: Transaction_recordId : Comparisons between 'VARCHAR (UCS_BASIC
via JIRA by Dzmitry Kazimirchyk, 1 year ago
Migration failed for change set resources/liquibase/initialSchema/schema.xml::createIndex::dzmitry: Reason: resources/liquibase/liquibase.db.changelog.xml : Index Exists Precondition: Transaction_recordId : Comparisons between 'VARCHAR (UCS_BASIC
via JIRA by Rafael Chaves, 1 year ago
Migration failed for change set changelog/db-changelog-3.7.1.xml::3.7.1_mychangeset::mycorp: Reason: changelog/db-changelog-3.7.1.xml : liquibase.precondition.core.ColumnExistsPrecondition@252b6749 : Cannot snapshot offline database
via JIRA by Rafael Chaves, 1 year ago
Migration failed for change set changelog/db-changelog-3.7.1.xml::3.7.1_mychangeset::mycorp: Reason: changelog/db-changelog-3.7.1.xml : liquibase.precondition.core.ColumnExistsPrecondition@252b6749 : Cannot snapshot offline database
liquibase.exception.MigrationFailedException: Migration failed for change set add-column-create-index-drop-column.xml::Test viewExists::test: Reason: add-column-create-index-drop-column.xml : liquibase.precondition.core.ViewExistsPrecondition@1a3938c5 : Empty result set, expected one row
at liquibase.util.JdbcUtils.requiredSingleResult(JdbcUtils.java:141)
at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:153)
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)
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.init(DatabaseSnapshot.java:60)
at liquibase.snapshot.DatabaseSnapshot.(DatabaseSnapshot.java:37)
at liquibase.snapshot.JdbcDatabaseSnapshot.(JdbcDatabaseSnapshot.java:25)
at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:126)
at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:134)
at liquibase.snapshot.SnapshotGeneratorFactory.has(SnapshotGeneratorFactory.java:88)
at liquibase.precondition.core.ViewExistsPrecondition.check(ViewExistsPrecondition.java:60)
at liquibase.precondition.core.AndPrecondition.check(AndPrecondition.java:43)
at liquibase.precondition.core.PreconditionContainer.check(PreconditionContainer.java:201)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:471)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:43)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
at liquibase.Liquibase.update(Liquibase.java:200)
at liquibase.Liquibase.update(Liquibase.java:181)
at liquibase.ext.spatial.LiquibaseIT.testLiquibaseUpdate(LiquibaseIT.java:183)
at sun.reflect.GeneratedMethodAccessor268.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:84)
at org.testng.internal.Invoker.invokeMethod(Invoker.java:714)
at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:901)
at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1231)
at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:127)
at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:111)
at org.testng.TestRunner.privateRun(TestRunner.java:767)
at org.testng.TestRunner.run(TestRunner.java:617)
at org.testng.SuiteRunner.runTest(SuiteRunner.java:334)
at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:329)
at org.testng.SuiteRunner.privateRun(SuiteRunner.java:291)
at org.testng.SuiteRunner.run(SuiteRunner.java:240)
at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86)
at org.testng.TestNG.runSuitesSequentially(TestNG.java:1224)
at org.testng.TestNG.runSuitesLocally(TestNG.java:1149)
at org.testng.TestNG.run(TestNG.java:1057)
at org.testng.remote.RemoteTestNG.run(RemoteTestNG.java:111)
at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:204)
at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:175)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Know the solutions? Share your knowledge to help other developers to debug faster.