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

Stack Overflow | Dave | 9 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Getting "Data truncated for column " when running Liquibase changeset

    Stack Overflow | 9 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
  2. 0

    GitHub comment 1#200814582

    GitHub | 1 year 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

    GitHub comment 3978#240652930

    GitHub | 9 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)]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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

      at liquibase.executor.jvm.JdbcExecutor.execute()
    2. Liquibase Core
      AbstractJdbcDatabase.executeStatements
      1. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
      2. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
      3. liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1206)
      4. liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1189)
      4 frames