[
https://issues.apache.org/jira/browse/AMBARI-18492?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15532620#comment-15532620
]
Hadoop QA commented on AMBARI-18492:
------------------------------------
{color:green}+1 overall{color}. Here are the results of testing the latest
attachment
http://issues.apache.org/jira/secure/attachment/12830879/AMBARI-18492.patch
against trunk revision .
{color:green}+1 @author{color}. The patch does not contain any @author
tags.
{color:green}+1 tests included{color}. The patch appears to include 1 new
or modified test files.
{color:green}+1 javac{color}. The applied patch does not increase the
total number of javac compiler warnings.
{color:green}+1 release audit{color}. The applied patch does not increase
the total number of release audit warnings.
{color:green}+1 core tests{color}. The patch passed unit tests in
ambari-server.
Test results:
https://builds.apache.org/job/Ambari-trunk-test-patch/8758//testReport/
Console output:
https://builds.apache.org/job/Ambari-trunk-test-patch/8758//console
This message is automatically generated.
> Clusters With Many Hosts Can Create Alerts With Text Too Large To Be Stored
> ---------------------------------------------------------------------------
>
> Key: AMBARI-18492
> URL: https://issues.apache.org/jira/browse/AMBARI-18492
> Project: Ambari
> Issue Type: Bug
> Components: alerts
> Affects Versions: 2.2.2
> Reporter: Dmytro Sen
> Assignee: Dmytro Sen
> Priority: Critical
> Fix For: 2.5.0
>
> Attachments: AMBARI-18492.patch
>
>
> When running alerts in a large cluster (for example a cluster with 1300
> hosts), some alerts like the Stale Alert may create text too large to store
> in the database.
> On MySQL, for example, the size of a {{TEXT}} field is {{65k}} (less if UTF-8
> is used). Normally, this is plenty of space. However, some clusters
> experience:
> {code}
> ERROR [alert-event-bus-1] AmbariJpaLocalTxnInterceptor:188 - [DETAILED ERROR]
> Internal exception (1) :
> com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column
> 'alert_text' at row 1
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4185)
> {code}
> The quick solution to fix this problem is to increase the field to the
> {{MEDIUMTEXT}} size which allows for {{16MB}} of data (way overkill):
> {code}
> ALTER TABLE alert_history MODIFY alert_text MEDIUMTEXT;
> ALTER TABLE alert_current MODIFY latest_text MEDIUMTEXT;
> {code}
> Alert text should be middle-ellipsized
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
