Nahappan Somasundaram created AMBARI-17350:
----------------------------------------------
Summary: If two users are created differing in case then no users
are shown due to error
Key: AMBARI-17350
URL: https://issues.apache.org/jira/browse/AMBARI-17350
Project: Ambari
Issue Type: Bug
Components: ambari-server
Affects Versions: 2.4.0
Reporter: Nahappan Somasundaram
Assignee: Nahappan Somasundaram
Priority: Critical
Fix For: 2.4.0
When usernames that differ only by case are created, no users are show in the
when clicking the Users link in Ambari Management page due to the following
error.
The fix is to block creating usernames that differ only by case.
{code}
12 Jun 2016 03:59:28,569 WARN [ambari-client-thread-559] ServletHandler:628 -
/api/v1/users/
javax.persistence.NonUniqueResultException: More than one result was returned
from Query.getSingleResult()
at
org.eclipse.persistence.internal.jpa.QueryImpl.throwNonUniqueResultException(QueryImpl.java:980)
at
org.eclipse.persistence.internal.jpa.QueryImpl.getSingleResult(QueryImpl.java:529)
at
org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:400)
at
org.apache.ambari.server.orm.dao.UserDAO.findUserByName(UserDAO.java:69)
at
org.apache.ambari.server.orm.AmbariLocalSessionInterceptor.invoke(AmbariLocalSessionInterceptor.java:53)
at
org.apache.ambari.server.controller.internal.ActiveWidgetLayoutResourceProvider.getResources(ActiveWidgetLayoutResourceProvider.java:161)
at
org.apache.ambari.server.controller.internal.ClusterControllerImpl$ExtendedResourceProviderWrapper.queryForResources(ClusterControllerImpl.java:966)
at
org.apache.ambari.server.controller.internal.ClusterControllerImpl.getResources(ClusterControllerImpl.java:141)
at
org.apache.ambari.server.api.query.QueryImpl.doQuery(QueryImpl.java:512)
at
org.apache.ambari.server.api.query.QueryImpl.queryForSubResources(QueryImpl.java:464)
...
{code}
{code}
select * from users ;
***(press return to proceed or enter x and return to cancel)********************
user_id | principal_id | ldap_user | user_name | user_type |
create_time | user_password
| active | active
_widget_layouts
---------+--------------+-----------+-----------+-----------+----------------------------+----------------------------------------------------------------------------------+--------+-------
----------------
1 | 1 | 0 | admin | LOCAL | 2016-06-11
16:08:51.300678 |
538916f8943ec225d97a9a86a2c6ec0818c1cd400e09e03b660fdaaec4af29ddbb6f2b1033b81b00
| 1 | [{"id"
:"6"}]
3 | 14 | 0 | Abcd | LOCAL | 2016-06-12
03:58:38.944 |
ee677dc216a63092fd1e4dbb56c3661dcca0053feae5968bdf82e15cb95e9b83747f1b7d25c3badc
| 1 |
4 | 15 | 0 | abcd | LOCAL | 2016-06-12
03:58:49.32 |
f941a9570f1b42f2f74b164e9e419fb7d63660681e3ccd9e9313f0369c6d5d03e3249fcfc1fd835e
| 1 |
(3 rows)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
