liquibase.exception.MigrationFailedException: 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)' and 'CHAR (TERRITORY_BASED:SECONDARY)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')

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

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via JIRA by Dzmitry Kazimirchyk, 1 year ago
)' and 'CHAR (TERRITORY_BASED:SECONDARY)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
via JIRA by Dzmitry Kazimirchyk, 1 year ago
)' and 'CHAR (TERRITORY_BASED:SECONDARY)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
via JIRA by Nathan Voxland, 1 year ago
Migration failed for change set latest/vw/departments_vw.xml::1::jsmith: Reason: update.xml : Error getting jdbc:hsqldb:hsql://localhost/testdb view with liquibase.statement.core.GetViewDefinitionStatement@a00185 : Caused By: Precondition Error
via liquibase.org by Unknown author, 1 year ago
Migration failed for change set latest/vw/departments_vw.xml::1::jsmith:     Reason:          update.xml : Error getting jdbc:hsqldb:hsql://localhost/testdb view with liquibase.statement.core.GetViewDefinitionStatement@a00185 :          Caused By: Precondition Error
via JIRA by Nathan Voxland, 1 year ago
Migration failed for change set latest/vw/departments_vw.xml::1::jsmith: Reason: update.xml : Error getting jdbc:hsqldb:hsql://localhost/testdb view with liquibase.statement.core.GetViewDefinitionStatement@a00185 : Caused By: Precondition Error
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 resources/liquibase/initialSchema/schema.xml::createIndex::dzmitry: Reason: resources/liquibase/liquibase.db.changelog.xml : Index Exists Precondition: Transaction_recordId : Comparisons between 'VARCHAR (UCS_BASIC)' and 'CHAR (TERRITORY_BASED:SECONDARY)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:514)
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)

Users with the same issue

Once, 1 year ago

Write tip

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