You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@eagle.apache.org by "DanielZhou (JIRA)" <ji...@apache.org> on 2016/05/05 23:05:12 UTC

[jira] [Created] (EAGLE-293) Size of field "alertContext " is too small in table "alertdetail_hadoop" in MySQL

DanielZhou created EAGLE-293:
--------------------------------

             Summary: Size of field "alertContext " is too small in table "alertdetail_hadoop" in MySQL
                 Key: EAGLE-293
                 URL: https://issues.apache.org/jira/browse/EAGLE-293
             Project: Eagle
          Issue Type: Bug
         Environment: mysql
            Reporter: DanielZhou


Problem:
When using MySQL as eagle's storage, some alert messages didn't show in UI.

Reason:
In  table "alertdetail_hadoop",  field size of "alertContext" is set as varchar(1024), which is too small, it can lead to the failure to save alert messages.

Suggestion:
Rearrange the size of these columns based on their usages.
Eg:  It makes more sense if we arrange more storage to  field "description" and "alertContext" , because they usually contain much more characters than  "site", "hostname", "application", "alertSource", "streamId",etc.




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)