JiJun Tang created EAGLE-851:
--------------------------------
Summary: Data too long for column 'policyId'
Key: EAGLE-851
URL: https://issues.apache.org/jira/browse/EAGLE-851
Project: Eagle
Issue Type: Bug
Components: Web UI
Reporter: JiJun Tang
Assignee: JiJun Tang
Priority: Minor
Fix For: v0.5.0
Long policyId will cause exception like below:
{noformat}
ERROR [2017-01-09 01:07:35,547]
org.apache.eagle.alert.metadata.impl.JdbcMetadataHandler: Error to add
publishments to policy xxx_topologyHealthCheckApp_nodeManagerStatusNotRunning
! com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column
'policyId' at row 1
! at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3885)
~[mysql-connector-java-5.1.34.jar:5.1.34]
! at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
~[mysql-connector-java-5.1.34.jar:5.1.34]
! at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
~[mysql-connector-java-5.1.34.jar:5.1.34]
! at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
~[mysql-connector-java-5.1.34.jar:5.1.34]
! at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)
~[mysql-connector-java-5.1.34.jar:5.1.34]
! at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)
~[mysql-connector-java-5.1.34.jar:5.1.34]
! at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2141)
~[mysql-connector-java-5.1.34.jar:5.1.34]
! at
com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1773)
~[mysql-connector-java-5.1.34.jar:5.1.34]
{noformat}
We should check the length of policyId before insert into the table.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
