ambari-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hadoop QA (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (AMBARI-18492) Clusters With Many Hosts Can Create Alerts With Text Too Large To Be Stored
Date Thu, 29 Sep 2016 19:36:20 GMT

    [ https://issues.apache.org/jira/browse/AMBARI-18492?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15533824#comment-15533824
] 

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/12830896/AMBARI-18492_2.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/8761//testReport/
Console output: https://builds.apache.org/job/Ambari-trunk-test-patch/8761//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_2.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)

Mime
View raw message