liquibase.exception.DatabaseException: Identifier name 'test_many_to_many_test_custom_table_name_test_custom_table_names_id' is too long [Failed SQL: ALTER TABLE travisMysql.test_many_to_many_test_custom_table_name ADD CONSTRAINT test_many_to_many_test_custom_table_name_test_custom_table_names_id FOREIGN KEY (test_custom_table_names_id) REFERENCES travisMysql.test_custom_table_name_entity (id)]

GitHub | pascalgrimaud | 4 months ago
  1. 0

    GitHub comment 3978#240652930

    GitHub | 4 months ago | pascalgrimaud
    liquibase.exception.DatabaseException: Identifier name 'test_many_to_many_test_custom_table_name_test_custom_table_names_id' is too long [Failed SQL: ALTER TABLE travisMysql.test_many_to_many_test_custom_table_name ADD CONSTRAINT test_many_to_many_test_custom_table_name_test_custom_table_names_id FOREIGN KEY (test_custom_table_names_id) REFERENCES travisMysql.test_custom_table_name_entity (id)]
  2. 0

    GitHub comment 1#200814582

    GitHub | 8 months ago | pascalgrimaud
    liquibase.exception.DatabaseException: Column "TEST_ENTITYS_ID" not found; SQL statement: ALTER TABLE PUBLIC.test_entity_user_many_to_many ADD CONSTRAINT fk_test_entity_user_many_to_many_user_id FOREIGN KEY (test_entitys_id) REFERENCES PUBLIC.test_entity (id) [42122-191] [Failed SQL: ALTER TABLE PUBLIC.test_entity_user_many_to_many ADD CONSTRAINT fk_test_entity_user_many_to_many_user_id FOREIGN KEY (test_entitys_id) REFERENCES PUBLIC.test_entity (id)]
  3. 0

    Getting "Data truncated for column " when running Liquibase changeset

    Stack Overflow | 3 months ago | Dave
    liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE organization MODIFY COLUMN ACTIVE BIT(1) NOT NULL DEFAULT 1: Data truncated for column 'ACTIVE' at row 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error in addForeignKeyConstraint when using overridden table names

    GitHub | 6 months ago | HemanthD
    liquibase.exception.DatabaseException: Cannot add foreign key constraint [Failed SQL: ALTER TABLE atlas.pa_option ADD CONSTRAINT fk_option_criteria_id FOREIGN KEY (criteria_id) REFERENCES atlas.criteria (id)]
  6. 0

    updating user entity to add foreign key

    GitHub | 9 months ago | francisyuya
    liquibase.exception.DatabaseException: Can't create table '.\blog\#sql-784_3f.frm' (errno: 150) [Failed SQL: ALTER TABLE blog.jhi_user ADD CONSTRAINT fk_user_activityField FOREIGN KEY (activity_field_info_id) REFERENCES blog.activity_field_info (id)]

    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

      Identifier name 'test_many_to_many_test_custom_table_name_test_custom_table_names_id' is too long [Failed SQL: ALTER TABLE travisMysql.test_many_to_many_test_custom_table_name ADD CONSTRAINT test_many_to_many_test_custom_table_name_test_custom_table_names_id FOREIGN KEY (test_custom_table_names_id) REFERENCES travisMysql.test_custom_table_name_entity (id)]

      at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement()
    2. Liquibase Core
      AbstractJdbcDatabase.executeStatements
      1. liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:301)
      2. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
      3. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:107)
      4. liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1251)
      5. liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1234)
      5 frames