CODEWITHSUNDEEP
springoracle-databasespring-bootliquibase
Kul Bhushan Prasad
Kul Bhushan Prasad

Reputation: 879

Liquibase 3.3.2 is failing with exception ORA-00955: name is already used by an existing object

I am using Liquibase as part of Spring boot program.

Earlier we were have normal Java Web application and we used to run the Liquibase manually with version liquibase-3.0.2.

Now as part of Liquibase+Spring boot, we are trying to run the Liquibase on same oracle database. so only Application is changed not database.

In my pom.xml

I am using 

<dependency>
        <groupId>org.liquibase</groupId>
        <artifactId>liquibase-core</artifactId>
        <version>3.3.2</version>
    </dependency>

or

    <dependency>
        <groupId>org.liquibase</groupId>
        <artifactId>liquibase-core</artifactId>
    </dependency>

So with latest Liquibase version whenever I am trying to deploy the application getting the error

CONSOLE: 15:18:53.190 [localhost-startStop-1] INFO  liquibase - Reading from SCHEMAMETA.DATABASECHANGELOG
CONSOLE: 15:18:53.600 [localhost-startStop-1] ERROR liquibase - classpath:/db/changelog/db.changelog-master.xml: classpath:/db/changelog/db.changelog-1.0.xml::001_create_ABC_TABLE::tcolson: Change Set classpath:/db/changelog/db.changelog-1.0.xml::001_create_ABC_TABLE::tcolson failed.  Error: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object

I am getting the same exceptions using both versions of mavan. It should say Ok, all is already deployed, nothing to do here. But Looks like Liquibase is failing even in verifying the existing entries.

Please let me know the catch here or any solution.

Upvotes: 0

Views: 8075

Answers (1)

Pankaj Kalra
Pankaj Kalra

Reputation: 81

This issue is same as liquibase.exception.DatabaseException: java.sql.SQLSyntaxErrorException: ORA-02264: name already used by an existing constraint This is not related to Liquibase 3.3.2 version.

First you should run below command after that you will be able to execute liquibase update successfully.

command: ./liquibase changeLogSync

Upvotes: 2

Related Questions