com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'MESSAGE' at row 1

Atlassian JIRA | Chris Shim [Atlassian] | 4 years ago
  1. 0

    When attempting to Sync a GitHub respository with the DVCS connector the following stacktrace was seen: {noformat} com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'MESSAGE' at row 1 com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:MySQL - version:5.5.29-0ubuntu1 - minor version:5 - major version:5 Driver: - name:MySQL Connector Java - version:mysql-connector-java-5.1.25 ( Revision: ${bzr.revision-id} ) com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'MESSAGE' at row 1 at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.create(EntityManagedActiveObjects.java:105) at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.create(DelegatingActiveObjects.java:61) ... Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'MESSAGE' 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:2815) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) {noformat} * Strict Mode did not do anything as well. * Ultimately changing the datatype to 'LONGTEXT' solved this issue. {panel:title=Workaround| borderStyle=dashed| borderColor=#3C78B5| titleBGColor=#a7c4e2 | bgColor=#E7F4FA} The problem here was that the length of the message in the repository was beyond what the datatype "text" could receive (64k), so making this bigger solved the issue. {code} ALTER TABLE 'AO_E8B6CC_CHANGESET_MAPPING' MODIFY MESSAGE LONGTEXT; {code} {panel} Can we make this error more descriptive or possibly output the value that is too long in the logs, or even the frontend for the customer to easily understand?

    Atlassian JIRA | 4 years ago | Chris Shim [Atlassian]
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'MESSAGE' at row 1
  2. 0

    When attempting to Sync a GitHub respository with the DVCS connector the following stacktrace was seen: {noformat} com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'MESSAGE' at row 1 com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:MySQL - version:5.5.29-0ubuntu1 - minor version:5 - major version:5 Driver: - name:MySQL Connector Java - version:mysql-connector-java-5.1.25 ( Revision: ${bzr.revision-id} ) com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'MESSAGE' at row 1 at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.create(EntityManagedActiveObjects.java:105) at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.create(DelegatingActiveObjects.java:61) ... Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'MESSAGE' 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:2815) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) {noformat} * Strict Mode did not do anything as well. * Ultimately changing the datatype to 'LONGTEXT' solved this issue. {panel:title=Workaround| borderStyle=dashed| borderColor=#3C78B5| titleBGColor=#a7c4e2 | bgColor=#E7F4FA} The problem here was that the length of the message in the repository was beyond what the datatype "text" could receive (64k), so making this bigger solved the issue. {code} ALTER TABLE 'AO_E8B6CC_CHANGESET_MAPPING' MODIFY MESSAGE LONGTEXT; {code} {panel} Can we make this error more descriptive or possibly output the value that is too long in the logs, or even the frontend for the customer to easily understand?

    Atlassian JIRA | 4 years ago | Chris Shim [Atlassian]
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'MESSAGE' at row 1
  3. 0

    When attempting to Sync a GitHub respository with the DVCS connector the following stacktrace was seen: {noformat} com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'MESSAGE' at row 1 com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:MySQL - version:5.5.29-0ubuntu1 - minor version:5 - major version:5 Driver: - name:MySQL Connector Java - version:mysql-connector-java-5.1.25 ( Revision: ${bzr.revision-id} ) com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'MESSAGE' at row 1 at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.create(EntityManagedActiveObjects.java:105) at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.create(DelegatingActiveObjects.java:61) ... Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'MESSAGE' 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:2815) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) {noformat} * Strict Mode did not do anything as well. * Ultimately changing the datatype to 'LONGTEXT' solved this issue. {panel:title=Workaround| borderStyle=dashed| borderColor=#3C78B5| titleBGColor=#a7c4e2 | bgColor=#E7F4FA} The problem here was that the length of the message in the repository was beyond what the datatype "text" could receive (64k), so making this bigger solved the issue. {code} ALTER TABLE 'AO_E8B6CC_CHANGESET_MAPPING' MODIFY MESSAGE LONGTEXT; {code} {panel} Can we make this error more descriptive or possibly output the value that is too long in the logs, or even the frontend for the customer to easily understand?

    Atlassian JIRA | 4 years ago | Chris Shim [Atlassian]
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'MESSAGE' at row 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Java JDBC Transaction Management and Savepoint - JournalDev

    journaldev.com | 3 months ago
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'message' at row 1
  6. 0

    My cat made a [SEVERE] error (no lie).

    GitHub | 4 years ago | Bronski
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'message' at row 1

    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 'MESSAGE' at row 1

      at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.create()
    2. com.atlassian.activeobjects
      DelegatingActiveObjects.create
      1. com.atlassian.activeobjects.internal.EntityManagedActiveObjects.create(EntityManagedActiveObjects.java:105)
      2. com.atlassian.activeobjects.osgi.DelegatingActiveObjects.create(DelegatingActiveObjects.java:61)
      2 frames