[ https://issues.apache.org/jira/browse/AMBARI-23961?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Akhil S Naik updated AMBARI-23961: ---------------------------------- Description: Update: This was originally reported as Ambari is creating unlimited widget dashboards in database if user name contains '_'. Upon further analysis, it turns out that this happens if the username contains at least one uppercase letter. Underscores do not matter. The dashboard works fine for a user name like first_last. ### Ambari is creating unlimited widget dashboards in database if user name contains '_' and none of them is returned when call : http://<AMBARI_SERVER>:8080/api/v1/users/USER_NAME/activeWidgetLayouts Reproduction steps Create a User with underscore in ambari , for ex : Test_User assign cluster user permissions to created user. Login as Test_User Navigate to Services >> Yarn Click on Plus icon on UI . Try to 'Add' any of widgets. When try to add any widgets in dashboard there exists a script error refer to !Screen Shot 2018-05-28 at 6.22.35 PM.png! Additionally ambari-web client keeps sending the Request to create new widget layout in recursive mode which results in infinite number of duplicate entries in database in widget_layout database and user_Widget_layout database. refer to !Screen Shot 2018-05-28 at 6.22.25 PM.png! root cause : Ambari-server saves the dashboard layouts in database by name "USER_SERVICENAME_DASHBOARD" and somewhere parsing logic is going wrong as username contains '_' Impact We are not able to see any of dashboards and each time when customer login and navigate to service there exists lots of REST calls to server results in increased network calls and increased DB size. was: Update: This was originally reported as Ambari is creating unlimited widget dashboards in database if user name contains '_'. Upon further analysis, it turns out that this happens if the username contains at least one uppercase letter. Underscores do not matter. The dashboard works fine for a user name like first_last. ### Ambari is creating unlimited widget dashboards in database if user name contains '_' and none of them is returned when call : http://<AMBARI_SERVER>:8080/api/v1/users/USER_NAME/activeWidgetLayouts Reproduction steps Create a User with underscore in ambari , for ex : Test_User assign cluster user permissions to created user. Login as Test_User Navigate to Services >> Yarn Click on Plus icon on UI . Try to 'Add' any of widgets. When try to add any widgets in dashboard there exists a script error refer to Screen Shot 2018-05-28 at 6.22.35 PM.png Additionally ambari-web client keeps sending the Request to create new widget layout in recursive mode which results in infinite number of duplicate entries in database in widget_layout database and user_Widget_layout database. refer to Screen Shot 2018-05-28 at 6.22.25 PM.png root cause : Ambari-server saves the dashboard layouts in database by name "USER_SERVICENAME_DASHBOARD" and somewhere parsing logic is going wrong as username contains '_' Impact We are not able to see any of dashboards and each time when customer login and navigate to service there exists lots of REST calls to server results in increased network calls and increased DB size. > Ambari is creating unlimited widget dashboards in database if user name > contains an uppercase letter > ---------------------------------------------------------------------------------------------------- > > Key: AMBARI-23961 > URL: https://issues.apache.org/jira/browse/AMBARI-23961 > Project: Ambari > Issue Type: Bug > Components: ambari-server > Affects Versions: 2.6.2 > Environment: Ambari-2.6.2 > Reporter: Akhil S Naik > Priority: Major > Attachments: Screen Shot 2018-05-28 at 6.22.25 PM.png, Screen Shot > 2018-05-28 at 6.22.35 PM.png > > > Update: This was originally reported as Ambari is creating unlimited widget > dashboards in database if user name contains '_'. Upon further analysis, it > turns out that this happens if the username contains at least one uppercase > letter. Underscores do not matter. The dashboard works fine for a user name > like first_last. > ### > Ambari is creating unlimited widget dashboards in database if user name > contains '_' and none of them is returned when call : > http://<AMBARI_SERVER>:8080/api/v1/users/USER_NAME/activeWidgetLayouts > Reproduction steps > Create a User with underscore in ambari , for ex : Test_User > assign cluster user permissions to created user. > Login as Test_User > Navigate to Services >> Yarn > Click on Plus icon on UI . > Try to 'Add' any of widgets. > When try to add any widgets in dashboard there exists a script error refer to > !Screen Shot 2018-05-28 at 6.22.35 PM.png! > Additionally ambari-web client keeps sending the Request to create new widget > layout in recursive mode which results in infinite number of duplicate > entries in database in widget_layout database and user_Widget_layout > database. refer to !Screen Shot 2018-05-28 at 6.22.25 PM.png! > root cause : > Ambari-server saves the dashboard layouts in database by name > "USER_SERVICENAME_DASHBOARD" and somewhere parsing logic is going wrong as > username contains '_' > Impact > We are not able to see any of dashboards and each time when customer login > and navigate to service there exists lots of REST calls to server results in > increased network calls and increased DB size. -- This message was sent by Atlassian JIRA (v7.6.3#76005)