Grouper Users - Open Discussion List

[Shilen Patel <>]

Hi,

Can you send the full stacktrace from the logs?  What do you see when you run these queries?

1.  select * from grouper_memberships ms, grouper_members m where ms.member_id = m.id and m.subject_id='3431b0bc686543f8bd49b62154c2f93a'

2.  select * from grouper_groups where id='3431b0bc686543f8bd49b62154c2f93a'

Thanks!

-- Shilen

From: Nathan Weyenberg <>
Date: Monday, November 11, 2013 12:25 PM
To: "" <>
Subject: [grouper-users] Error with Obliterate Stem

Hi,

I have been having issues trying to delete a stem and its relating groups. When using obliterate stem I get the following error: 

Obliterating stem: u:netid:daconner

Obliterating stem: u:netid:daconner:_admin

// Error: unable to evaluate command: Sourced file: inline evaluation of: ``obliterateStem("u", false, false);'' : Error invoking compiled command: : Error in compiled command: edu.internet2.middleware.grouper.exception.MemberDeleteException: Cant find group by uuid: 3431b0bc686543f8bd49b62154c2f93a,

Exception in delete: edu.internet2.middleware.grouper.Membership, edu.internet2.middleware.grouper.hibernate.ByObject@6593e3d0,

Problem in HibernateSession: HibernateSession: isNew: false, isReadonly: false, grouperTransactionType: READ_WRITE_NEW,

Exception in delete: edu.internet2.middleware.grouper.Membership, ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName: ImmediateMembershipEntry, tx type: null,

Problem in HibernateSession: HibernateSession: isNew: false, isReadonly: false, grouperTransactionType: READ_WRITE_NEW,

Problem in HibernateSession: HibernateSession: isNew: false, isReadonly: false, grouperTransactionType: READ_WRITE_NEW,

Problem in HibernateSession: HibernateSession: isNew: false, isReadonly: false, grouperTransactionType: READ_WRITE_NEW,

Problem in HibernateSession: HibernateSession: isNew: false, isReadonly: false, grouperTransactionType: READ_WRITE_NEW,

Problem in HibernateSession: HibernateSession: isNew: false, isReadonly: false, grouperTransactionType: READ_WRITE_NEW,

Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: false, grouperTransactionType: READ_WRITE_NEW

I have also tried using the following script for deleting stems:

grouperSession = GrouperSession.startRootSession();

stem = StemFinder.findByName(grouperSession, "u:netid:daconner");

for(child : stem.getChildGroups(Stem.Scope.SUB)) { System.out.println("deleting: " + child.getName()); child.delete();  }

stemList = new ArrayList(stem.getChildStems(Stem.Scope.SUB));

Collections.sort(stemList);

Collections.reverse(stemList);

for(childStem : stemList) { System.out.println("deleting: " + childStem.getName()); childStem.delete(); }

stem.delete();

and got the following error:

stem: name='u:netid:daconner' displayName='u:netid:daconner' uuid='f7d2964808774847a3ed9089348d2c02' 

deleting: u:netid:daconner:_admin:_group_mother_update

// Error: unable to evaluate command: Sourced file: inline evaluation of: ``for(child : stem.getChildGroups(Stem.Scope.SUB)) { System.out.println("deleting: . . . '' : Method Invocation child.delete

// See error log for full stacktrace

// caused by: edu.internet2.middleware.grouper.exception.MemberDeleteException:

// Cant find group by uuid: 3431b0bc686543f8bd49b62154c2f93a,

Exception in delete: edu.internet2.middleware.grouper.Membership, edu.internet2.middleware.grouper.hibernate.ByObject@7a718e31,

Problem in HibernateSession: HibernateSession: isNew: false, isReadonly: false, grouperTransactionType: READ_WRITE_NEW,

Exception in delete: edu.internet2.middleware.grouper.Membership, ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName: ImmediateMembershipEntry, tx type: null,

Problem in HibernateSession: HibernateSession: isNew: false, isReadonly: false, grouperTransactionType: READ_WRITE_NEW,

Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: false, grouperTransactionType: READ_WRITE_NEW

// caused by: edu.internet2.middleware.grouper.exception.GroupNotFoundException:

// Cant find group by uuid: 3431b0bc686543f8bd49b62154c2f93a,

Exception in delete: edu.internet2.middleware.grouper.Membership, edu.internet2.middleware.grouper.hibernate.ByObject@7a718e31,

Problem in HibernateSession: HibernateSession: isNew: false, isReadonly: false, grouperTransactionType: READ_WRITE_NEW,

Exception in delete: edu.internet2.middleware.grouper.Membership, ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName: ImmediateMembershipEntry, tx type: null,

Problem in HibernateSession: HibernateSession: isNew: false, isReadonly: false, grouperTransactionType: READ_WRITE_NEW

java.util.ArrayList: [Stem[displayName=u:netid:daconner:_admin,name=u:netid:daconner:_admin,uuid=3ee2e03cf9f745eeb8ce39707319abed,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7], Stem[displayName=u:netid:daconner:foo_test,name=u:netid:daconner:foo,uuid=ff1ce75d126842bfbdb2b89b2da2650f,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7], Stem[displayName=u:netid:daconner:foo_attr1,name=u:netid:daconner:foo_attr1,uuid=9ca713b91e8f4cc5bb3ad34315724bcc,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7], Stem[displayName=u:netid:daconner:foo_attr2,name=u:netid:daconner:foo_attr2,uuid=49469d8632c443acbc8c17d32a1c6e51,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7], Stem[displayName=u:netid:daconner:foo_attr3,name=u:netid:daconner:foo_attr3,uuid=bec3275dc7a44948b5814ba21021d2d5,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7], Stem[displayName=u:netid:daconner:foo_attr3:Administrative Group for foo_attr3,name=u:netid:daconner:foo_attr3:_admin,uuid=f5b987368c78471da7c26eeb72245594,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7], Stem[displayName=u:netid:daconner:foo_attr4,name=u:netid:daconner:foo_attr4,uuid=dd924eb93e4944cda4734e5952f09850,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7], Stem[displayName=u:netid:daconner:foo_attr4:Administrative Group for foo_attr4,name=u:netid:daconner:foo_attr4:_admin,uuid=ccb1f21517674c41bfbd597a0d64c8b4,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7], Stem[displayName=u:netid:daconner:foo_attr5,name=u:netid:daconner:foo_attr5,uuid=8563e0d01aec4368b768c0206d761a73,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7], Stem[displayName=u:netid:daconner:foo_attr5:Administrative Group for foo_attr5,name=u:netid:daconner:foo_attr5:_admin,uuid=53547d4f42064892be3b0c2cf6593c21,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7], Stem[displayName=u:netid:daconner:foo,name=u:netid:daconner:attributes,uuid=db5d035a235d4001b4d7a5de5afa0d88,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7], Stem[displayName=u:netid:daconner:foo:Administrative Group for foo,name=u:netid:daconner:attributes:_admin,uuid=292b43146600443c9000e387b0526285,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7], Stem[displayName=u:netid:daconner:2222,name=u:netid:daconner:attributes2,uuid=858e82596ed845cb8033d22184df90bf,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7], Stem[displayName=u:netid:daconner:2222:Administrative Group for 2222,name=u:netid:daconner:attributes2:_admin,uuid=e598bf4460674041b76708fad4ae7c9f,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7]]

deleting: u:netid:daconner:foo_attr5:_admin

// Error: unable to evaluate command: Sourced file: inline evaluation of: ``for(childStem : stemList) { System.out.println("deleting: " + childStem.getName( . . . '' : Method Invocation childStem.delete

// See error log for full stacktrace

// caused by: edu.internet2.middleware.grouper.exception.StemDeleteException:

// cannot delete stem with child groups,

Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: false, grouperTransactionType: READ_WRITE_NEW

// Error: unable to evaluate command: Sourced file: inline evaluation of: ``stem.delete();'' : Method Invocation stem.delete

// See error log for full stacktrace

// caused by: edu.internet2.middleware.grouper.exception.StemDeleteException:

// cannot delete stem with child stems,

Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: false, grouperTransactionType: READ_WRITE_NEW

I have run the following queries with no results:

select * from grouper_memberships_v where member_id = '3431b0bc686543f8bd49b62154c2f93a';

select * from grouper_stems_v where stem_id = '3431b0bc686543f8bd49b62154c2f93a';

select * from grouper_memberships_all_v where member_id = '3431b0bc686543f8bd49b62154c2f93a';

How can I go about deleting this?

Nathan Weyenberg

UW-Madison DoIT - Middleware