liquibase.exception.DatabaseException: ORA-02275: such a referential constraint already exists in the table [Failed SQL: ALTER TABLE CRDM_RCHEN.SOME_TABLE ADD CONSTRAINT SOME_TABLE_FK FOREIGN KEY (COLUMN_2) REFERENCES CRDM_RCHEN.SOME_OTHER_TABLE (COLUMN_1)]

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.

  • 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,
  • 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,
  • is &#39;#&#39; not allowed in JSON?
    via Stack Overflow by Ya.
    ,
    • liquibase.exception.DatabaseException: ORA-02275: such a referential constraint already exists in the table [Failed SQL: ALTER TABLE CRDM_RCHEN.SOME_TABLE ADD CONSTRAINT SOME_TABLE_FK FOREIGN KEY (COLUMN_2) REFERENCES CRDM_RCHEN.SOME_OTHER_TABLE (COLUMN_1)] 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)

    Users with the same issue

    Unknown visitor2 times, last one,
    tvrmsmith
    tvrmsmith1 times, last one,
    Malcshour
    Malcshour26 times, last one,
    davidvanlaatum
    davidvanlaatum1 times, last one,
    Unknown visitor1 times, last one,