Skip to main content
rohit_r_sharma
rohit_r_sharma
Gold ⭐️
May 31, 2019
Solved

Unable to view Ambari Alerts page content

Hi All,

The configured HDP 2.6.3 cluster with Ambari 2.6 is unable to show contents inside the Alerts page.

Can anyone help me, how to find the RCA for the same?

Attaching screenshot of the Ambari Alerts Page:

109082-1559292125617.png

How to monitor log ? for this Alert page.

Shelton
SheltonAnswer
Gold ⭐️⭐️⭐️
June 3, 2019

@Rohit Sharma

I suspect your ambari-server is overwhelmed. How long has your installation been in use? You should think of purging some old data.

SELECT table_schema "Database Name", SUM( data_length + index_length)/1024/1024 "Database Size (MB)"
FROM information_schema.TABLES where table_schema = 'mydb';


The solution of purge ambari history by hortonworks

You should be able to load your page after the above action. use the below statement to get the size of the ambari database

HTH

View in thread

9 replies

Shelton
SheltonAnswer
Gold ⭐️⭐️⭐️
June 3, 2019

@Rohit Sharma

I suspect your ambari-server is overwhelmed. How long has your installation been in use? You should think of purging some old data.

SELECT table_schema "Database Name", SUM( data_length + index_length)/1024/1024 "Database Size (MB)"
FROM information_schema.TABLES where table_schema = 'mydb';


The solution of purge ambari history by hortonworks

You should be able to load your page after the above action. use the below statement to get the size of the ambari database

HTH

Translate
    rohit_r_sharma
    rohit_r_sharmaAuthor
    Gold ⭐️
    June 11, 2019

    @Geoffrey Shelton Okot,

    The purging saved me.

    Thanks a lot for the support.

    It would be great if I can automate purging every 6 months, please let me know if there is any way to do it.

    Translate
    ask_bill_brooks
    Platinum ⭐️
    ask_bill_brooks
    Platinum ⭐️
    June 4, 2019

    The above was originally posted in the Community Help Track. On Tue Jun 4 03:36 UTC 2019, a member of the HCC moderation staff moved it to the Cloud & Operations track. The Community Help Track is intended for questions about using the HCC site itself.

    Translate
    Bill Brooks, Community Moderator Was your question answered? Make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs up button.
    jsensharma
    Platinum ⭐️⭐️
    jsensharma
    Platinum ⭐️⭐️
    June 4, 2019

    @Rohit Sharma

    In addition to Geoffrey's comment, Can you also tail the "/var/log/ambari-server/ambari-server.log" and then try to hit the Ambari UI Alert page again and then see if it shows any WARNING / Error there?

    When you hit the Alert page in Ambari UI then do you see any error/failure in the Browser debugger console?

    Chrome Browser Menu --> More Tools --> Developer Tools --> Console (Tab)


    Also please try to open browser in Incognito mode in order to isolate if it has any Browser caching issue?

    Also it will be good to see if your Ambari Server is having enough resources like it has sufficient menory..etc. You can refer to the following doc to find out how to check the AmbariServer memory settings and see the current memory usage: https://community.hortonworks.com/articles/131670/ambari-server-performance-tuning-troubleshooting-c.html

    /usr/jdk64/jdk1.8.0_112/bin/jmap -heap $AMBARI_SERVER_PID


    .

    Translate
    rohit_r_sharma
    rohit_r_sharmaAuthor
    Gold ⭐️
    June 10, 2019

    @Jay Kumar SenSharma

    1st Point ambari-server.log : Error Processing URI: /api/v1/clusters/cluster-name/alerts - (java.lang.NullPointerException) null

    109332-1560168120879.png

    2nd Incognito Browser- Console (Tab)

    109333-1560168322710.png3rd There is enough memory for Ambari-Server to function approx 166GB is Available.

    4th With the help of your link above there is no log in ambari server saying exceeded Java Heap Size.


    The error in ambari-server is Java Null Pointer Exception null running alerts tab.


    Please Suggest.

    Translate
    jsensharma
    Platinum ⭐️⭐️
    jsensharma
    Platinum ⭐️⭐️
    June 10, 2019

    @Rohit Sharma

    Your recent error indicates that there is some inconsistency in your Ambari DB. Due to this inconsistency the Ambari UI for Alerts page is not showing any alert details.

    Error Processing URI: /api/v1/clusters/cluster-name/alerts - (java.lang.NullPointerException) null


    .

    You can follow the below article to get this issue fixed.

    Please make sure to take a fresh Amabri DB dump for backup purpose before following the below article.

    https://community.hortonworks.com/content/supportkb/174817/ambari-alert-page-is-invisible-on-ambari-screen.html

    After performing the steps mentioned in the above article please do not forget to restart Ambari Server.


    Translate
    jsensharma
    Platinum ⭐️⭐️
    jsensharma
    Platinum ⭐️⭐️
    June 11, 2019

    @Rohit Sharma

    Did you find that the below query returned any record in your Ambari DB ? If, yes then that explains about the issue and the above shared article should help in getting it fixed.

    select * from alert_current where history_id not in (select alert_id from alert_history);


    .

    Translate
    rohit_r_sharma
    rohit_r_sharmaAuthor
    Gold ⭐️
    June 11, 2019

    @Jay Kumar SenSharma,

    Thanks for the support!!!

    Yeah, there was inconsistency in Ambari-Server DB which was not allowing Alert to function on Ambari-UI.

    The Ambari-server DB size was grown to 294 MB. By purging the last 6 months from DB and restarting the ambari functioned the Alerts back on Ambari-UI.

    Would like to know in detail if this happens on PROD env what measures should be taken as an admin.

    Translate
    Terms & ConditionsAccessibility statement