iquibase.exception.DatabaseException: ... Data truncation: Data too long for column 'ID' at row 1

JIRA | Vadym Roganin | 2 years ago
  1. 0

    I have a changeset with very long Id, I try to run liquibase from maven and receive iquibase.exception.DatabaseException: ... Data truncation: Data too long for column 'ID' at row 1 at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:70) at liquibase.database.AbstractDatabase.markChangeSetExecStatus(AbstractDatabase.java:967) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:32) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58) at liquibase.Liquibase.update(Liquibase.java:114) at liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:262) at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:245) at com.alertme.zoo.provisioning.sql.liquibase.LiquibaseVerifier.executeChangeLog(LiquibaseVerifier.java:129) at com.alertme.zoo.provisioning.sql.liquibase.LiquibaseVerifier.execute(LiquibaseVerifier.java:59) at com.alertme.zoo.provisioning.sql.Bootstrap.main(Bootstrap.java:66) Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'ID' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4185) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:732) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) ... 11 more But, changeset is applied but not logged into DATABASECHANGELOG

    JIRA | 2 years ago | Vadym Roganin
    iquibase.exception.DatabaseException: ... Data truncation: Data too long for column 'ID' at row 1
  2. 0

    I have a changeset with very long Id, I try to run liquibase from maven and receive iquibase.exception.DatabaseException: ... Data truncation: Data too long for column 'ID' at row 1 at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:70) at liquibase.database.AbstractDatabase.markChangeSetExecStatus(AbstractDatabase.java:967) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:32) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58) at liquibase.Liquibase.update(Liquibase.java:114) at liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:262) at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:245) at com.alertme.zoo.provisioning.sql.liquibase.LiquibaseVerifier.executeChangeLog(LiquibaseVerifier.java:129) at com.alertme.zoo.provisioning.sql.liquibase.LiquibaseVerifier.execute(LiquibaseVerifier.java:59) at com.alertme.zoo.provisioning.sql.Bootstrap.main(Bootstrap.java:66) Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'ID' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4185) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:732) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) ... 11 more But, changeset is applied but not logged into DATABASECHANGELOG

    JIRA | 2 years ago | Vadym Roganin
    iquibase.exception.DatabaseException: ... Data truncation: Data too long for column 'ID' at row 1
  3. 0

    Liquibase binary array for multiple database types

    Stack Overflow | 1 year ago | voor
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'systemUuid' at row 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    LogBlock and the Far Lands

    GitHub | 4 years ago | tigerw
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1
  6. 0

    SQL Exception

    GitHub | 5 years ago | TheStriker0995
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for colu mn 'x' at row 1

  1. Kialandei 1 times, last 1 week ago
2 unregistered visitors
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. com.mysql.jdbc.MysqlDataTruncation

    Data truncation: Data too long for column 'ID' at row 1

    at com.mysql.jdbc.MysqlIO.checkErrorPacket()
  2. MySQL jdbc
    StatementImpl.execute
    1. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4185)
    2. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)
    3. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
    4. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
    5. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809)
    6. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758)
    7. com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894)
    8. com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:732)
    8 frames
  3. Commons DBCP
    DelegatingStatement.execute
    1. org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    2. org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    2 frames
  4. Liquibase Core
    SpringLiquibase.afterPropertiesSet
    1. liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
    2. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
    3. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
    4. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:70)
    5. liquibase.database.AbstractDatabase.markChangeSetExecStatus(AbstractDatabase.java:967)
    6. liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:32)
    7. liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
    8. liquibase.Liquibase.update(Liquibase.java:114)
    9. liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:262)
    10. liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:245)
    10 frames
  5. com.alertme.zoo
    Bootstrap.main
    1. com.alertme.zoo.provisioning.sql.liquibase.LiquibaseVerifier.executeChangeLog(LiquibaseVerifier.java:129)
    2. com.alertme.zoo.provisioning.sql.liquibase.LiquibaseVerifier.execute(LiquibaseVerifier.java:59)
    3. com.alertme.zoo.provisioning.sql.Bootstrap.main(Bootstrap.java:66)
    3 frames