liquibase.exception.DatabaseException: java.sql.SQLException: Invalid SQL statement or JDBC escape, terminating ''' not found.

JIRA | Maren | 2 years ago
  1. 0

    Blank page after server deployment

    GitHub | 3 years ago | seewhydee
    liquibase.exception.DatabaseException: Error executing SQL DROP INDEX `subscription_id` ON `FEEDENTRYSTATUSES`: Cannot drop index 'subscription_id': needed in a foreign key constra\ int: Caused By: Error executing SQL DROP INDEX `subscription_id` ON `FEEDENTRYSTATUSES`: Cannot drop index 'subscription_id': needed in a foreign key constraint: Caused By: Cannot drop index 'subscription_id': needed in a foreign key constraint
  2. Speed up your debug routine!

    Automated exception search integrated into your IDE

  3. 0

    GitHub comment 3321#205684486

    GitHub | 8 months ago | adam-ho
    liquibase.exception.DatabaseException: Table "COUNTRY" not found; SQL statement: ALTER TABLE PUBLIC.location ADD CONSTRAINT fk_location_country_id FOREIGN KEY (country_id) REFERENCES PUBLIC.country (id) [42102-191] [Failed SQL: ALTER TABLE PUBLIC.location ADD CONSTRAINT fk_location_country_id FOREIGN KEY (country_id) REFERENCES PUBLIC.country (id)]
  4. 0

    GitHub comment 1#219251094

    GitHub | 7 months ago | ThomasBassa
    liquibase.exception.DatabaseException: Index "SUB_ENTRY_READ_INDEX" belongs to constraint "FKD6DCE994E181535F"; SQL statement: DROP INDEX PUBLIC.sub_entry_read_index [90085-190] [Failed SQL: DROP INDEX PUBLIC.sub_entry_read_index]

  1. tvrmsmith 1 times, last 4 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

    java.sql.SQLException: Invalid SQL statement or JDBC escape, terminating ''' not found.

    at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement()
  2. Liquibase Core
    ChangeSet.execute
    1. liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316)
    2. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
    3. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
    4. liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1221)
    5. liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1204)
    6. liquibase.changelog.ChangeSet.execute(ChangeSet.java:550)
    6 frames