liquibase.exception.DatabaseException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • When using the <indexExists> precondition in Informix to check to see if an index exists, the check does not appear to succeed if an index actually exists. Applying the following pair of changesets to "jxclean" {code} <changeSet id="ngp-constituent-jpa.military_service.NewTableCreation" author="lgray"} <createTable tableName="military_service"> <column name="id" type="bigint"> <constraints nullable="false"/> </column> <column name="country_type_id" type="bigint"> <constraints nullable="false"/> </column> </createTable> <addPrimaryKey tableName="military_service" columnNames="id" constraintName="pk_military_service"/> <createIndex tableName="military_service" indexName="idx_mil_country_type_id"> <column name="country_type_id"/> </createIndex> </changeSet> <changeSet id="ngp-constituent-jpa.military_service.createIndex" author="lgray"> <preConditions onFail="MARK_RAN"> <tableExists tableName="military_service"/> <not> <indexExists indexName="idx_mil_country_type_id"/> </not> </preConditions> <createIndex tableName="military_service" indexName="idx_mil_country_type_id"> <column name="country_type_id"/> </createIndex> </changeSet> {code} generates the following error when Liquibase attempts to execute the second changeset: {code} SEVERE 9/21/16 1:43 PM: liquibase: com.jenzabar.ngp:ngp-test-jpa::ngp-constituent-jpa.military_service.createIndex::sowmya: Index (idx_mil_country_type_id) already exists in database. [Failed SQL: CREATE INDEX jxclean351:ngp.idx_mil_country_type_id ON jxclean351:ngp.military_service(country_type_id)] liquibase.exception.MigrationFailedException: Migration failed for change set com.jenzabar.ngp:ngp-test-jpa::ngp-constituent-jpa.military_service.createIndex::sowmya: Reason: liquibase.exception.DatabaseException: Index (idx_mil_country_type_id) already exists in database. [Failed SQL: CREATE INDEX jxclean351:ngp.idx_mil_country_type_id ON jxclean351:ngp.military_service(country_type_id)] at liquibase.changelog.ChangeSet.execute(ChangeSet.java:605) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79) at liquibase.Liquibase.update(Liquibase.java:214) at liquibase.Liquibase.update(Liquibase.java:192) at liquibase.integration.commandline.Main.doMigration(Main.java:1126) at liquibase.integration.commandline.Main.run(Main.java:184) at liquibase.integration.commandline.Main.main(Main.java:103) Caused by: liquibase.exception.DatabaseException: Index (idx_mil_country_type_id) already exists in database. [Failed SQL: CREATE INDEX jxclean351:ngp.idx_mil_country_type_id ON jxclean351:ngp.military_service(country_type_id)] at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:301) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:107) at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1273) at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1255) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:568) ... 7 more {code} even though the precondition should have prevented the second changeset from attempting to create the index again.
    via by Lyle H. Gray,
  • Hi, I use liquibase with maven and an ant build skript. Locally everything works fine but when I build the same project via jenkins the build breaks with the following exception: updateSQL: [java] Unexpected error running Liquibase: liquibase.exception.DatabaseException: Connection could not be created to https://svn.<..> with driver oracle.jdbc.driver.OracleDriver. Possibly the wrong driver for the given database URL [java] [java] SEVERE 12/15/15 9:13 AM: liquibase: liquibase.exception.DatabaseException: Connection could not be created to https://svn.<..> with driver oracle.jdbc.driver.OracleDriver. Possibly the wrong driver for the given database URL [java] liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: Connection could not be created to https://svn.<..> with driver oracle.jdbc.driver.OracleDriver. Possibly the wrong driver for the given database URL [java] at liquibase.integration.commandline.CommandLineUtils.createDatabaseObject(CommandLineUtils.java:54) [java] at liquibase.integration.commandline.Main.doMigration(Main.java:884) [java] at liquibase.integration.commandline.Main.run(Main.java:177) [java] at liquibase.integration.commandline.Main.main(Main.java:96) [java] Caused by: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: Connection could not be created to https://svn.<..> with driver oracle.jdbc.driver.OracleDriver. Possibly the wrong driver for the given database URL [java] at liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:239) [java] at liquibase.database.DatabaseFactory.openDatabase(DatabaseFactory.java:143) [java] at liquibase.integration.commandline.CommandLineUtils.createDatabaseObject(CommandLineUtils.java:45) [java] ... 3 more [java] Caused by: liquibase.exception.DatabaseException: Connection could not be created to https://svn.<..> with driver oracle.jdbc.driver.OracleDriver. Possibly the wrong driver for the given database URL [java] at liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:234) [java] ... 5 more [java] [java] [java] For more information, use the --logLevel flag Somehow liquibase tries to connect to our Subversion Server. The liquibase.properties file is as follows: #liquibase.properties driver = oracle.jdbc.driver.OracleDriver classpath = target/lib/ojdbc6-11.2.0.3.0.jar url = offline:oracle?version=12.1.0.3 logLevel = info As I said, when I run with mvn clean install on my local machine everythings works fine. Is this a bug? Best Serano
    via by Serano Colameo,
  • Hi, I use liquibase with maven and an ant build skript. Locally everything works fine but when I build the same project via jenkins the build breaks with the following exception: updateSQL: [java] Unexpected error running Liquibase: liquibase.exception.DatabaseException: Connection could not be created to https://svn.<..> with driver oracle.jdbc.driver.OracleDriver. Possibly the wrong driver for the given database URL [java] [java] SEVERE 12/15/15 9:13 AM: liquibase: liquibase.exception.DatabaseException: Connection could not be created to https://svn.<..> with driver oracle.jdbc.driver.OracleDriver. Possibly the wrong driver for the given database URL [java] liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: Connection could not be created to https://svn.<..> with driver oracle.jdbc.driver.OracleDriver. Possibly the wrong driver for the given database URL [java] at liquibase.integration.commandline.CommandLineUtils.createDatabaseObject(CommandLineUtils.java:54) [java] at liquibase.integration.commandline.Main.doMigration(Main.java:884) [java] at liquibase.integration.commandline.Main.run(Main.java:177) [java] at liquibase.integration.commandline.Main.main(Main.java:96) [java] Caused by: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: Connection could not be created to https://svn.<..> with driver oracle.jdbc.driver.OracleDriver. Possibly the wrong driver for the given database URL [java] at liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:239) [java] at liquibase.database.DatabaseFactory.openDatabase(DatabaseFactory.java:143) [java] at liquibase.integration.commandline.CommandLineUtils.createDatabaseObject(CommandLineUtils.java:45) [java] ... 3 more [java] Caused by: liquibase.exception.DatabaseException: Connection could not be created to https://svn.<..> with driver oracle.jdbc.driver.OracleDriver. Possibly the wrong driver for the given database URL [java] at liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:234) [java] ... 5 more [java] [java] [java] For more information, use the --logLevel flag Somehow liquibase tries to connect to our Subversion Server. The liquibase.properties file is as follows: #liquibase.properties driver = oracle.jdbc.driver.OracleDriver classpath = target/lib/ojdbc6-11.2.0.3.0.jar url = offline:oracle?version=12.1.0.3 logLevel = info As I said, when I run with mvn clean install on my local machine everythings works fine. Is this a bug? Best Serano
    via by Serano Colameo,
    • liquibase.exception.DatabaseException: Index (idx_mil_country_type_id) already exists in database. [Failed SQL: CREATE INDEX jxclean351:ngp.idx_mil_country_type_id ON jxclean351:ngp.military_service(country_type_id)] at liquibase.changelog.ChangeSet.execute(ChangeSet.java:605) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79) at liquibase.Liquibase.update(Liquibase.java:214) at liquibase.Liquibase.update(Liquibase.java:192) at liquibase.integration.commandline.Main.doMigration(Main.java:1126) at liquibase.integration.commandline.Main.run(Main.java:184) at liquibase.integration.commandline.Main.main(Main.java:103) Caused by: liquibase.exception.DatabaseException: Index (idx_mil_country_type_id) already exists in database. [Failed SQL: CREATE INDEX jxclean351:ngp.idx_mil_country_type_id ON jxclean351:ngp.military_service(country_type_id)] at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:301) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:107) at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1273) at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1255) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:568) ... 7 more

    Users with the same issue

    Unknown visitor
    Unknown visitor2 times, last one,
    MalcshourMalcshour
    13 times, last one,