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)]

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 Stack Overflow by Ray Chen
, 1 year ago
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)]
via JIRA by Lyle H. Gray, 1 year ago
Primary key already exists on the table. [Failed SQL: ALTER TABLE jxclean351:ngp.military_service ADD CONSTRAINT PRIMARY KEY (id) CONSTRAINT pk_military_service]
via JIRA by Lyle H. Gray, 1 year ago
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)]
via JIRA by Lyle H. Gray, 1 year ago
A syntax error has occurred. [Failed SQL: CREATE TABLE jxclean351:ngp.country_type (id INT8 NOT NULL, value VARCHAR(100(100) NOT NULL)]
via Stack Overflow by Bohdan Olehovich
, 2 years ago
Table 'database.batch_job_execution' doesn't exist [Failed SQL: CREATE INDEX JOB_START_STATUS ON database.batch_job_execution(STATUS, START_TIME)]
via GitHub by brianhatchl
, 1 year ago
Error executing SQL DROP TYPE IF EXISTS nwr_enum: ERROR: cannot drop type nwr_enum because other objects depend on it Detail: table current_relation_members column member_type depends on type nwr_enum Hint: Use DROP ... CASCADE to drop the dependent objects too.
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)

Users with the same issue

Samebug visitor profile picture
Unknown user
2 times, 1 year ago
Once, 1 year ago
26 times, 1 year ago
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

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