You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ranger.apache.org by "Rakesh Gupta (Jira)" <ji...@apache.org> on 2026/03/23 07:32:00 UTC

[jira] [Created] (RANGER-5526) Security Zone creation fails with tag service due to NonUniqueResultException

Rakesh Gupta created RANGER-5526:
------------------------------------

             Summary: Security Zone creation fails with tag service due to NonUniqueResultException
                 Key: RANGER-5526
                 URL: https://issues.apache.org/jira/browse/RANGER-5526
             Project: Ranger
          Issue Type: Bug
          Components: Ranger
            Reporter: Rakesh Gupta
            Assignee: Rakesh Gupta


While creating a Security Zone with a tag service, the operation fails during postCreate execution. The stack trace shows a NonUniqueResultException from XXAccessTypeDefDao.findByNameAndServiceId(), triggered during default policy creation.

This issue is caused by duplicate entries in the access type definition tables for the associated service.

 
{code:java}
ERROR [RangerSecurityZoneServiceService.java:102] postCreate processing failed for security-zone:[{name=zone_1, services={dev_hive={resources=[{resource={resource-def-name=database, values=[t]} {resource-def-name=column, values=[*]} {resource-def-name=table, values=[*]} } {baseInfo={id=1, createdBy=admin, createTime=Thu Mar 19 11:26:49 UTC 2026, updatedBy=admin, updateTime=Thu Mar 19 11:26:49 UTC 2026}} ]}}, tagServices=[dev_tag], adminUsers=[admin], adminUserGroups=[testgroup], adminRoles=[], auditUsers=[admin], auditUserGroups=[testgroup], auditRoles=[], description=}]javax.persistence.NonUniqueResultException: More than one result was returned from Query.getSingleResult()	at org.eclipse.persistence.internal.jpa.QueryImpl.throwNonUniqueResultException(QueryImpl.java:991)	at org.eclipse.persistence.internal.jpa.QueryImpl.getSingleResult(QueryImpl.java:538)	at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:404)	at org.apache.ranger.db.XXAccessTypeDefDao.findByNameAndServiceId(XXAccessTypeDefDao.java:59)	at org.apache.ranger.biz.PolicyRefUpdater.createNewPolMappingForRefTable(PolicyRefUpdater.java:279)	at org.apache.ranger.biz.ServiceDBStore.createPolicy(ServiceDBStore.java:2293)	at org.apache.ranger.biz.ServiceDBStore.createDefaultPolicy(ServiceDBStore.java:1416)	at org.apache.ranger.biz.ServiceDBStore.createZoneDefaultPolicies(ServiceDBStore.java:2438)	at org.apache.ranger.service.RangerSecurityZoneServiceService.postCreate(RangerSecurityZoneServiceService.java:99)	at org.apache.ranger.service.RangerSecurityZoneServiceService.postCreate(RangerSecurityZoneServiceService.java:53)	at org.apache.ranger.service.RangerBaseModelService.create(RangerBaseModelService.java:138)	at org.apache.ranger.biz.SecurityZoneDBStore.createSecurityZone(SecurityZoneDBStore.java:99)	at org.apache.ranger.rest.SecurityZoneREST.createSecurityZone(SecurityZoneREST.java:147)	at org.apache.ranger.rest.SecurityZoneREST$$FastClassBySpringCGLIB$$797df817.invoke(<generated>)	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)