Skip to Content.
Sympa Menu

grouper-users - RE: [grouper-users] unable to remove group

Subject: Grouper Users - Open Discussion List

List archive

RE: [grouper-users] unable to remove group


Chronological Thread 
  • From: "Hyzer, Chris" <>
  • To: Ben Beecher <>, "" <>
  • Subject: RE: [grouper-users] unable to remove group
  • Date: Mon, 19 Dec 2016 06:05:26 +0000
  • Accept-language: en-US
  • Authentication-results: spf=none (sender IP is ) ;
  • Ironport-phdr: 9a23:Mr5cLhx99wcwRxDXCy+O+j09IxM/srCxBDY+r6Qd0uoXLvad9pjvdHbS+e9qxAeQG96KsLQb1aGH7ujJYi8p2d65qncMcZhBBVcuqP49uEgeOvODElDxN/XwbiY3T4xoXV5h+GynYwAOQJ6tL1LdrWev4jEMBx7xKRR6JvjvGo7Vks+7y/2+94fdbghMijexe7F/IRS5oQjVtsQdnJdvJLs2xhbVuHVDZv5YxXlvJVKdnhb84tm/8Zt++ClOuPwv6tBNX7zic6s3UbJXAjImM3so5MLwrhnMURGP5noHXWoIlBdDHhXI4wv7Xpf1tSv6q/Z91SyHNsD4Ubw4RTKv5LpwRRT2lCkIKSI28GDPisxxkq1bpg6hpwdiyILQeY2ZKeZycr/Ycd4cWGFPXNteVzZZD428cYUBEvYBM+hboYnzpVQOrAexCga3Cez11jNEmmX70bEm3+kjFwzNwQwuH8gJsHTRtNj5OqUcUOC0zabW1zXPd+5d1Cn96IjScxAhuv+AVq93fMrU1UYvFwPEj1SOpoz/JD6V1/8NvHSB4+p9TeKglWgnqwdrrjex28gsl5DEi4QIwV7K8iV5xZw6Jdy+SENjfdGkF59QtzyfN4RtQ8MtWXtktzgnxb0bv5OwYSsEyIw/yhLBcfOLb5WE7xf+WOqMPDt1gXxldb2jixqu9EWtyPPzW8ap3FtPqydJjMXAu3AV2xDO5MWLVuFx80O81TqVyQzf9+VJLVopmafZKpMsxKM7mIAJvkTZBCD2nV37jK+IeUUg/eil8/zpb6nhqJOAKoN4kxzzPLwgl8CmBuQ3KRYBU3Kc+eShyL3s5kr5QKhMjvIriKXZqIraJcMHpqGnHwBVzocj6xG5Dzu819QYgGUHLFZCeBKAjIjlIU3BIPf9DfunglSslilkx+zeM7H/GJrBMmXPnbL8cbpg9kJRzQQzwN9D655ID7wMIuz8V0DsuNHdCxI1LRC4zub/BNV4zIweWGaPAqGDMKPVtF+F/ucvLPWMZI4VuTfyNeIl6uXvjX8ihVARZ7Sp3YMJZ3C+GPRqOVuWbmfxgtsZC2cFohI+TPD2iF2FSTNTaGyyX6Uh5jEjFo2mF57PRp22gLOfxie7BYZbZmRHClCXDXfobJuIV+0NaCKUPs9ujCYEVb6/RI89yx2irhH1xKd6LrmcxipNn5/lnPJ46ubTmAt6oTZ5As+d3nulRGZwg2YCRjZw0axi9wg1gFiZ1rVgjuYdCMde/ehhUwEmOITawvAgTd3+R0iJKtiTT0u+T8/jHCo8VMkZwtkSblx7Fsn4yB3Pwnz5LaUSkunBJI0m/7iYl1PxPcdmgT6S0aIhnksrWONOLmbgm7Zy8Q6VCoLUxRbK3522fLgRiXaevFyIynCD6QQBCFZ9
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99

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)




Archive powered by MHonArc 2.6.19.

Top of Page