liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE MYSCHEMA.myprefix_changelog ( [ ...] ): ORA-00955: name is already used by an existing object

JIRA | Thomas Weinlein | 3 years ago
  1. 0

    Unable to update 1.0.3 db?

    GitHub | 2 years ago | ojhunt
    liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE commafeed.FEEDENTRYTAGS ADD CONSTRAINT fk_entry_id FOREIGN KEY (entry_id) REFERENCES commafeed.FEEDENTRIES (id): Can't create table 'commafeed.#sql-3e1_87a6' (errno: 150)
  2. Speed up your debug routine!

    Automated exception search integrated into your IDE

  3. 0

    Can liquibase handle a partially updated schema?

    Stack Overflow | 4 years ago | Kramer
    liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE limit ADD id serial: ERROR: column "id" of relation "limit" already exists
  4. 0

    PL/SQL and SQL script in one sqlFile with liquibase?

    Stack Overflow | 1 year ago | Gabor
    liquibase.exception.DatabaseException: ORA-06550: 4 line, 1 col: PLS-00103: Encountered the symbol: "/" [Failed SQL: BEGIN aud.someProcedure('parameter'); END; // insert into test_table(_id, value) VALUES(1, 'test') ]

  1. davidvanlaatum 1 times, last 7 months ago
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. liquibase.exception.DatabaseException

    Error executing SQL CREATE TABLE MYSCHEMA.myprefix_changelog ( [ ...] ): ORA-00955: name is already used by an existing object

    at liquibase.executor.jvm.JdbcExecutor.execute()
  2. Liquibase Core
    Liquibase.update
    1. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:56)
    2. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:98)
    3. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:64)
    4. liquibase.database.AbstractJdbcDatabase.checkDatabaseChangeLogTable(AbstractJdbcDatabase.java:694)
    5. liquibase.Liquibase.checkDatabaseChangeLogTable(Liquibase.java:602)
    6. liquibase.Liquibase.update(Liquibase.java:130)
    6 frames