Grouper Users - Open Discussion List

["Hyzer, Chris" <>]

Try this:

 

grouperSession = GrouperSession.startRootSession();

group = GroupFinder.findByName(grouperSession, "test:testGroup3", true);

for (membership : group.getImmediateMemberships()) {membership.delete();}

group.delete();

 

 

Note, should we not use transactions if groups have over a certain number of members?  If people think so let me know and I can open a jira…

 

Thanks

Chris

 

From: [mailto:] On Behalf Of Ben Beecher
Sent: Sunday, December 18, 2016 11:40 AM
To:
Subject: [grouper-users] unable to remove group

 

I am trying to remove this group on the dev Grouper database: cu:ref:allusers

that group contains one member: cu:ref:empl:tree:employee

 

I am unable to remove the group member or delete the group using the grouper shell.  I have tried both of these commands separately and they both get the same error:

delMember("cu:ref:allusers", "cu:ref:empl:tree:employee");

delGroup("cu:ref:allusers");

 

The rollback was failing because the data table space was not large enough.  I asked our Systems Group to increase the size of the data table space in our Grouper database.  I tried again and now the command runs for 56 hours and then I get the following error.  Can you suggest how to fix this?  I was able to remove the same group without errors on the production Grouper instance.

 

API patches 0 to 30 are installed on dev Grouper (updated on 11/04/2016)

 

Ben

 

-------------------------------------------------------

 

Using GROUPER_HOME: /var/grouper/installGrouper2.3/grouper.apiBinary-2.3.0

Using GROUPER_CONF: /var/grouper/installGrouper2.3/grouper.apiBinary-2.3.0/conf

Using JAVA: java

using MEMORY: 128m-6g

Grouper starting up: version: 2.3.0, build date: 2016/04/16 05:37:21, env: dev

grouper.properties read from: /var/grouper/installGrouper2.3/grouper.apiBinary-2.3.0/conf/grouper.properties

Grouper current directory is: /hmt/sirius1/prv0/sy/beecher

log4j.properties read from:   /var/grouper/installGrouper2.3/grouper.apiBinary-2.3.0/conf/log4j.properties

Grouper logs are not using log4j: class org.apache.commons.logging.impl.SLF4JLocationAwareLog

grouper.hibernate.properties: /var/grouper/installGrouper2.3/grouper.apiBinary-2.3.0/conf/grouper.hibernate.properties

grouper.hibernate.properties:

sources.xml read from:        /var/grouper/installGrouper2.3/grouper.apiBinary-2.3.0/conf/sources.xml

sources.xml groupersource id: g:gsa

sources.xml ldap source id:   ldap: ldap.properties

sources.xml groupersource id: grouperEntities

sources.xml jdbc source id:   idm: grouper@jdbc:oracle:thin:@//idmsysdevdb01.cc.columbia.edu:1527/idmdev1.cc.columbia.edu

sources.xml jdbc source id:   externalUsers: GrouperJdbcConnectionProvider

Type help() for instructions

gsh 0% delMember("cu:ref:allusers", "cu:ref:empl:tree:employee");

// Error: unable to evaluate command: Sourced file: inline evaluation of: ``delMember("cu:ref:allusers", "cu:ref:empl:tree:employee");'' : Error invoking compiled command: : Error in compiled command: java.lang.NullPointerException: Problem in HibernateSession: HibernateSession (36e33715): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (10cc3620),

Exception in list: (class edu.internet2.middleware.grouper.group.GroupSet), ByHqlStatic, query: 'select gs from GroupSet as gs where gs.parentId = :parent and gs.type = 'effective'', cacheable: false, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3GroupSetDAO.FindAllChildren, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'parent'->'d1c7b5c4a9aa4b18b4040a8468410c58', ,

Exception in delete: edu.internet2.middleware.grouper.group.GroupSet, ,

Problem in HibernateSession: HibernateSession (7f81afbb): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (10cc3620),

Exception in delete: edu.internet2.middleware.grouper.Membership, ,

Problem in HibernateSession: HibernateSession (f1ee873): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (10cc3620),

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

Problem in HibernateSession: HibernateSession (399fa905): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (10cc3620),

Problem in HibernateSession: HibernateSession (6aab3cba): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (10cc3620)