Grouper Users - Open Discussion List

[Colin Hudler <>]

I just created a group, which has other groups as members.  Everything 
seemed fine, but when looking at one of the members with the UI, it 
would say "There was a serious error connecting to the database".  In 
the logs it produced an identical error to gsh, which is below.

gsh 3%  g.delete()
// Error: unable to evaluate command: Sourced file: inline evaluation 
of: `` g.delete();'' : Method Invocation g.delete
// See error log for full stacktrace
// caused by: 
edu.internet2.middleware.grouper.exception.GroupDeleteException:
// Problem in HibernateSession: HibernateSession: isNew: true, 
isReadonly: true, grouperTransactionType: READONLY_NEW,
Exception in uniqueResult: (class [Ljava.lang.Object;), ByHqlStatic, 
query: 'select ms, m from Membership as ms, Member as m, Field as field 
where       ms.ownerUuid  = :owner            and  ms.memberUuid = 
:member           and  ms.fieldId = field.uuid and  field.name   = 
:fname            and  field.typeString       = :ftype             and 
ms.type       = :type             and  ms.memberUuid = m.uuid', 
cacheable: false, cacheRegion: 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO.FindByOwnerAndMemberAndFieldAndType, 
tx type: nullBind var[0]: 'Param (class java.lang.String): 
'owner'->'41f8d440-e715-4f9f-809f-2c491165ea62', Bind var[1]: 'Param 
(class java.lang.String): 
'member'->'4208396d-9b34-4e51-92c2-759b9fa9bb60', Bind var[2]: 'Param 
(class java.lang.String): 'fname'->'members', Bind var[3]: 'Param (class 
java.lang.String): 'ftype'->'list'Bind var[4]: 'Param (class 
java.lang.String): 'type'->'immediate',
// caused by: 
edu.internet2.middleware.grouper.internal.dao.GrouperDAOException:
// Problem in HibernateSession: HibernateSession: isNew: true, 
isReadonly: true, grouperTransactionType: READONLY_NEW,
Exception in uniqueResult: (class [Ljava.lang.Object;), ByHqlStatic, 
query: 'select ms, m from Membership as ms, Member as m, Field as field 
where       ms.ownerUuid  = :owner            and  ms.memberUuid = 
:member           and  ms.fieldId = field.uuid and  field.name   = 
:fname            and  field.typeString       = :ftype             and 
ms.type       = :type             and  ms.memberUuid = m.uuid', 
cacheable: false, cacheRegion: 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO.FindByOwnerAndMemberAndFieldAndType, 
tx type: nullBind var[0]: 'Param (class java.lang.String): 
'owner'->'41f8d440-e715-4f9f-809f-2c491165ea62', Bind var[1]: 'Param 
(class java.lang.String): 
'member'->'4208396d-9b34-4e51-92c2-759b9fa9bb60', Bind var[2]: 'Param 
(class java.lang.String): 'fname'->'members', Bind var[3]: 'Param (class 
java.lang.String): 'ftype'->'list'Bind var[4]: 'Param (class 
java.lang.String): 'type'->'immediate',
// caused by: org.hibernate.NonUniqueResultException:
// query did not return a unique result: 2

I decided to dig around in the db, since I hadn't seen it's structure 
yet.  I was suspicious of the member '4208396d-9b34-4e51-92c2-759b9fa9bb60'.

I soon found some apparent oddness.  See this query:

mysql> select name,value,mship_type from grouper_memberships INNER JOIN 
grouper_members ON grouper_members.id=grouper_memberships.member_id 
INNER JOIN grouper_attributes ON 
grouper_attributes.group_id=grouper_memberships.owner_id INNER JOIN 
grouper_fields ON grouper_attributes.field_id=grouper_fields.id WHERE 
grouper_memberships.member_id='4208396d-9b34-4e51-92c2-759b9fa9bb60' 
HAVING grouper_fields.name='name';
+------+----------------------------------------+------------+
| name | value                                  | mship_type |
+------+----------------------------------------+------------+
| name | uc:applications:wireless:eligible      | immediate  |
| name | uc:applications:wireless:authorized    | composite  |
| name | uc:applications:cmail:users:eligible   | immediate  |
| name | uc:applications:cmail:users:eligible   | immediate  |
| name | uc:applications:cmail:users:authorized | composite  |
+------+----------------------------------------+------------+

Could it be the cause of my problem that this group is twice an 
immediate member?  Here is a fragment of the membership table for that 
member (group):

mysql>  select owner_id,mship_type,via_id from grouper_memberships where 
member_id = '4208396d-9b34-4e51-92c2-759b9fa9bb60';
+--------------------------------------+------------+--------------------------------------+
| owner_id                             | mship_type | via_id 
                   |
+--------------------------------------+------------+--------------------------------------+
| 62b9c697-1af2-47a6-b7ac-90a23602c2ac | immediate  | NULL 
                   |
| 20bd10d2-2766-4342-9fd6-c0c5f472603e | composite  | 
1fb43f92-7457-46e7-906c-ddfc8b0f4129 |
| 41f8d440-e715-4f9f-809f-2c491165ea62 | immediate  | NULL 
                   |
| 41f8d440-e715-4f9f-809f-2c491165ea62 | immediate  | NULL 
                   |
| 49fe6f6f-7a03-4e69-9ad1-912212407af7 | composite  | 
f7c157d5-9eb6-4bd7-a82a-d41ba1499e96 |
+--------------------------------------+------------+--------------------------------------+
5 rows in set (0.00 sec)


Finally, what could I do to fix this?  Unfortunately, I have not found 
the cause yet.