grouper-users - Re: [grouper-users] Suddenly getting error after obliterateStem

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] Suddenly getting error after obliterateStem

From: "Crawford, Jeffrey" <>
To: Grouper Users <>
Subject: Re: [grouper-users] Suddenly getting error after obliterateStem
Date: Fri, 10 May 2019 14:44:31 +0000

I was able to get through this late last night by performing the obliterateStem on subsections of the folder path, I was eventually able to roll up to the root folder I really wanted to remove. Perhaps this was a memory or db connection pool problem

Jeffrey

From: <> on behalf of "Crawford, Jeffrey" <>
Reply-To: "Crawford, Jeffrey" <>
Date: Thursday, May 9, 2019 at 6:35 PM
To: Grouper Users <>
Subject: [grouper-users] Suddenly getting error after obliterateStem

Hi,

I’ve been doing this for a while now, while I do a POC but suddenly the groovy shell is spitting this out at me after I obliterate stem and it tries to clean up the pit entries:

ERROR java.lang.RuntimeException:

There is probably a problem that there are 20 nested new HibernateSessions called!,

Problem in HibernateSession: null,

Exception in list: (class edu.internet2.middleware.grouper.pit.PITGroupSet), ByHqlStatic, query: 'select gs from PITGroupSet as gs where gs.parentId = :parent and gs.depth <> '0'', cacheable: false, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3PITGroupSetDAO.FindImmediateChildren, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'parent'->'b4ec0e5aa6b54855b76a1f8f5f9af328', ,

Exception in delete: edu.internet2.middleware.grouper.pit.PITGroupSet, edu.internet2.middleware.grouper.hibernate.ByObject@48a3cac8,

Problem in HibernateSession: HibernateSession (d6db63e): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (7decdae9),

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

Exception in delete: edu.internet2.middleware.grouper.pit.PITGroupSet, edu.internet2.middleware.grouper.hibernate.ByObject@1d504f2c,

Problem in HibernateSession: HibernateSession (1c761232): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (7decdae9),

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

Exception in delete: edu.internet2.middleware.grouper.pit.PITGroupSet, edu.internet2.middleware.grouper.hibernate.ByObject@5f07df35,

Problem in HibernateSession: HibernateSession (632e4d5d): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (7decdae9),

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

Exception in delete: edu.internet2.middleware.grouper.pit.PITGroupSet, edu.internet2.middleware.grouper.hibernate.ByObject@9a4bb97,

Problem in HibernateSession: HibernateSession (3e691e44): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (7decdae9),

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

Exception in delete: edu.internet2.middleware.grouper.pit.PITGroupSet, edu.internet2.middleware.grouper.hibernate.ByObject@128403d8,

Problem in HibernateSession: HibernateSession (b300af4): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (7decdae9),

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

Exception in delete: edu.internet2.middleware.grouper.pit.PITGroupSet, edu.internet2.middleware.grouper.hibernate.ByObject@d32178b,

Problem in HibernateSession: HibernateSession (792b4d95): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (7decdae9),

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

Exception in delete: edu.internet2.middleware.grouper.pit.PITGroupSet, edu.internet2.middleware.grouper.hibernate.ByObject@6c2d9f6f,

Problem in HibernateSession: HibernateSession (4d390a0c): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (7decdae9),

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

Exception in delete: edu.internet2.middleware.grouper.pit.PITGroupSet, edu.internet2.middleware.grouper.hibernate.ByObject@40f9f97e,

Problem in HibernateSession: HibernateSession (67feb5d0): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (7decdae9),

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

Problem in HibernateSession: HibernateSession (1b6d0ee9): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (7decdae9),

Exception in delete: edu.internet2.middleware.grouper.pit.PITGroup, edu.internet2.middleware.grouper.hibernate.ByObject@72d1a87a,

Problem in HibernateSession: HibernateSession (6aef33f6): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (7decdae9),

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

Exception in delete: edu.internet2.middleware.grouper.pit.PITStem, edu.internet2.middleware.grouper.hibernate.ByObject@6fc277e4,

Problem in HibernateSession: HibernateSession (4731c9af): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (7decdae9),

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

Exception in delete: edu.internet2.middleware.grouper.pit.PITStem, edu.internet2.middleware.grouper.hibernate.ByObject@6f944b94,

Problem in HibernateSession: HibernateSession (5282f922): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (7decdae9),

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

Exception in delete: edu.internet2.middleware.grouper.pit.PITStem, edu.internet2.middleware.grouper.hibernate.ByObject@60296d11,

Problem in HibernateSession: HibernateSession (2f0166d7): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (7decdae9),

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

Exception in delete: edu.internet2.middleware.grouper.pit.PITStem, edu.internet2.middleware.grouper.hibernate.ByObject@1fc48b16,

Problem in HibernateSession: HibernateSession (176b8493): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (7decdae9),

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

Exception in delete: edu.internet2.middleware.grouper.pit.PITStem, edu.internet2.middleware.grouper.hibernate.ByObject@63c5a25d,

Problem in HibernateSession: HibernateSession (eb2ce99): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (7decdae9),

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

Exception in delete: edu.internet2.middleware.grouper.pit.PITStem, edu.internet2.middleware.grouper.hibernate.ByObject@2e408d5a,

Problem in HibernateSession: HibernateSession (531245fe): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (7decdae9),

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

Exception in delete: edu.internet2.middleware.grouper.pit.PITStem, edu.internet2.middleware.grouper.hibernate.ByObject@52a2c66,

Problem in HibernateSession: HibernateSession (6b7a96e1): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (7decdae9),

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

Exception in delete: edu.internet2.middleware.grouper.pit.PITStem, edu.internet2.middleware.grouper.hibernate.ByObject@3e8d8bee,

Problem in HibernateSession: HibernateSession (4b7feb38): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (7decdae9),

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

Exception in delete: edu.internet2.middleware.grouper.pit.PITStem, edu.internet2.middleware.grouper.hibernate.ByObject@70141128,

Problem in HibernateSession: HibernateSession (122f58a): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (7decdae9),

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

Exception in delete: edu.internet2.middleware.grouper.pit.PITStem, edu.internet2.middleware.grouper.hibernate.ByObject@5a14682d,

Problem in HibernateSession: HibernateSession (9be2897): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (7decdae9),

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

at edu.internet2.middleware.grouper.hibernate.HibernateSession.addStaticHibernateSession (HibernateSession.java:406)

at edu.internet2.middleware.grouper.hibernate.HibernateSession.<init> (HibernateSession.java:284)

at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSession (HibernateSession.java:468)

at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession (HibernateSession.java:660)

at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.list (ByHqlStatic.java:407)

at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.listSet (ByHqlStatic.java:458)

at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3PITGroupSetDAO.findImmediateChildren (Hib3PITGroupSetDAO.java:428)

at edu.internet2.middleware.grouper.pit.PITGroupSet.onPreDelete (PITGroupSet.java:1075)

at edu.internet2.middleware.grouper.hibernate.ByObject.delete (ByObject.java:114)

at edu.internet2.middleware.grouper.hibernate.ByObjectStatic$10.callback (ByObjectStatic.java:675)