Grouper Users - Open Discussion List

[Richard James <>]

Also when I tried adding the type using 
GrouperDAOFactory.getFactory().getGroup().addType( group, base); I noticed 
the in table row for the new entry did not have the Context id set, it was 
null? I wonder if this could cause the Stale object exception.

Cheers,
Richie

-----Original Message-----
From: Richard James 
Sent: 19 February 2013 15:22
To: 'Chris Hyzer'
Subject: RE: Unresolvable Group

I tried exactly what you did on a test group on our dev grouper instance and 
got the same behaviour as you, see messages below.

Another thing I tried was adding an entry directly into the 
grouper_groups_types table.

I produced a UUID using the Select UUID (  ) command, which gave me 
66836442-7aa7-11e2-b95a-0050563b0032 (I stripped out the -) to leave me with 
668364427aa711e2b95a0050563b0032.

I then added the group UUID, the type UUID and the context id of the group 
into the new row.

This then allows me to delete the group from GSH and the UI, not sure if this 
could potentially causes issues anywhere?


 #################
gsh 0% grouperSession = GrouperSession.startRootSession();
edu.internet2.middleware.grouper.GrouperSession: 
583c58fc4b4e4afe88b8758a20e5ba5c,'GrouperSystem','application'
gsh 1% group = GroupFinder.findByName(grouperSession,"Applications:test2")
group: name='Applications:test2' displayName='Applications:test2' 
uuid='6b6c8c402d2d41e2aa42d254846656b3'
gsh 2% group.delete();
// Error: unable to evaluate command: Sourced file: inline evaluation of: 
``group.delete();'' : Method Invocation group.delete
// See error log for full stacktrace
// caused by: edu.internet2.middleware.grouper.exception.GrouperException:
// unexpected condition,
Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: 
false, grouperTransactionType: READ_WRITE_NEW
// caused by: edu.internet2.middleware.grouper.exception.SchemaException:
// invalid group type:  for group name: Applications:test2, 
GroupType[creatorUuid=2234fc40d72143a8870bc8c597e0dd47,createTime=1321351952067,fields=7,isAssignable=false,isInternal=false,name=base,uuid=d67c38ab1eb44ece90d91f6b11e39979]:admins
gsh 3% base = GroupTypeFinder.find("base");
type: 'base'
gsh 4% GrouperDAOFactory.getFactory().getGroup().addType( group, base);
edu.internet2.middleware.grouper.GroupTypeTuple: 
GroupTypeTuple[groupUuid=6b6c8c402d2d41e2aa42d254846656b3,typeUuid=d67c38ab1eb44ece90d91f6b11e39979]

#######
restarted GSH
######

gsh 0% grouperSession = GrouperSession.startRootSession();
edu.internet2.middleware.grouper.GrouperSession: 
02e347ea8eda47e6bde156a15010421b,'GrouperSystem','application'
gsh 1%  group = GroupFinder.findByName(grouperSession,"Applications:test2")
group: name='Applications:test2' displayName='Applications:test2' 
uuid='6b6c8c402d2d41e2aa42d254846656b3'
gsh 2% group.delete();
// Error: unable to evaluate command: Sourced file: inline evaluation of: 
``group.delete();'' : Method Invocation group.delete
// See error log for full stacktrace
// caused by: 
edu.internet2.middleware.grouper.exception.GrouperStaleObjectStateException:
// 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
// caused by: org.hibernate.StaleObjectStateException:
// Row was updated or deleted by another transaction (or unsaved-value 
mapping was incorrect): 
[ImmediateMembershipEntry#6d954ac598d6476dbc684a2bb27204f5]

>-----Original Message-----
>From: Chris Hyzer 
>[mailto:]
>Sent: 19 February 2013 15:01
>To: Richard James; 
>
>Subject: RE: Unresolvable Group
>
>Yeah, Im trying to reproduce this.
>
>I have a group in grouper 1.6, and then I manually delete that row in the DB 
>in
>grouper_groups_types.
>
>Then I see the same error you see.  Then I recreate that row in
>grouper_groups_types:
>
>#######################################
>gsh 0% grouperSession = GrouperSession.startRootSession();
>edu.internet2.middleware.grouper.GrouperSession:
>01c2a99386ec454e8b5e00dd2637abd6,'GrouperSystem','application'
>gsh 3% group = GroupFinder.findByName(grouperSession, "test:testGroup");
>group: name='test:testGroup' displayName='test:testGroup'
>uuid='e7b54e4b2c4c42e288f7b6a667ffaec3'
>gsh 4% group.delete();
>// Error: unable to evaluate command: Sourced file: inline evaluation of:
>``group.delete();'' : Method Invocation group.delete
>// See error log for full stacktrace
>// caused by: edu.internet2.middleware.grouper.exception.GrouperException:
>// unexpected condition,
>Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: 
>false,
>grouperTransactionType: READ_WRITE_NEW
>// caused by: edu.internet2.middleware.grouper.exception.SchemaException:
>// invalid group type:  for group name: test:testGroup,
>GroupType[creatorUuid=3f68c77ab34e4563a5140306be23f3d8,createTime=131
>8266890386,fields=7,isAssignable=false,isInternal=false,name=base,uuid=a23b03
>ab173f44d9a98727faa77462ca]:admins
>
>gsh 6% base = GroupTypeFinder.find("base");
>type: 'base'
>gsh 8% GrouperDAOFactory.getFactory().getGroup().addType( group, base);
>edu.internet2.middleware.grouper.GroupTypeTuple:
>GroupTypeTuple[groupUuid=e7b54e4b2c4c42e288f7b6a667ffaec3,typeUuid=a23
>b03ab173f44d9a98727faa77462ca]
>#######################################
>
>Then stop and start GSH to clear things out.  Try to delete the group.  I 
>get an
>error about stale object state for hibernate.  I tried to set this for GSH 
>in the
>grouper.properties, but I still cant delete the group... can you?
>
>###############################
>groups.updateLastMembershipTime = false
>
>###############################
>gsh 11% group.delete();
>// Error: unable to evaluate command: Sourced file: inline evaluation of:
>``group.delete();'' : Method Invocation group.delete
>// See error log for full stacktrace
>// caused by:
>edu.internet2.middleware.grouper.exception.GrouperStaleObjectStateException:
>// 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
>// caused by: org.hibernate.StaleObjectStateException:
>// Row was updated or deleted by another transaction (or unsaved-value
>mapping was incorrect):
>[ImmediateMembershipEntry#0503a1f152b64f7d97145e1c45d8ede0]
>gsh 12%
>
>##############################
>
>-----Original Message-----
>From: Richard James 
>[mailto:]
>Sent: Tuesday, February 19, 2013 9:52 AM
>To: Chris Hyzer; 
>
>Subject: RE: Unresolvable Group
>
>Ive just been doing some digging around the database. I'm not sure if for 
>every
>group created, there is an entry made in the grouper_groups_types table? If 
>so,
>for this group there is no entry in this table, could this be causing the 
>invalid
>Group type message? Is there any way we could create an entry for this group?
>
>Thanks,
>Richie
>
>>-----Original Message-----
>>From: 
>>
>> [
>>]
>> On Behalf Of Richard James
>>Sent: 19 February 2013 14:28
>>To: Chris Hyzer; 
>>
>>Subject: [grouper-users] RE: Unresolvable Group
>>
>>Hi Chris,
>>
>>I've attached the latest copy of our grouper_error log which has a useful 
>>entry
>>when trying to access the group from the UI, it is reporting an invalid 
>>Group
>type.
>>(See entry the entry at 14:14:50).
>>
>>GSH doesn't seem to be logging any really useful stack traces to the log 
>>file , it's
>>just outputting them within GSH, I will see if I can amend the logging 
>>level for
>this
>>to do so. Every time I try and delete the group in GSH it gives the message 
>>as in
>>my first email about an unexpected condition.
>>
>>I'll forward on anymore error stacks if I can produce any.
>>
>>Thanks,
>>Richie
>>
>>
>>
>>>-----Original Message-----
>>>From: Chris Hyzer 
>>>[mailto:]
>>>Sent: 19 February 2013 13:52
>>>To: Richard James; 
>>>
>>>Subject: RE: Unresolvable Group
>>>
>>>There should be more info in the logs, can you send all the error stacks 
>>>form
>the
>>>UI and GSH?
>>>
>>>Thanks,
>>>chris
>>>
>>>-----Original Message-----
>>>From: 
>>>
>>> [
>>>]
>>> On Behalf Of Richard James
>>>Sent: Tuesday, February 19, 2013 5:32 AM
>>>To: 
>>>
>>>Subject: [grouper-users] Unresolvable Group
>>>
>>>Hi All,
>>>
>>>We are having a problem with one of our groups which was created yesterday.
>>>Within the Grouper UI, we can see the group that we created in the explore
>>view,
>>>named PSS_SFS_Careers_Service_Intranet within its designated stem. However
>>>when  you click on the group to view more details for it, the following 
>>>message
>>is
>>>displayed.
>>>
>>>Error:
>>>The error has been logged and the administrator notified.
>>>If you continue to encounter errors, please contact technical support.
>>>
>>>When going to GSH, I can find the group,
>>>
>>>gsh 25%
>>>getGroups("Applications:Filestores:PSS:Student_&_Academic_Services:Careers
>_
>>S
>>>ervice:PSS_SFS_Careers_Service_Intranet")
>>>group:
>>>name='Applications:Filestores:PSS:Student_&_Academic_Services:Careers_Ser
>vi
>>c
>>>e:PSS_SFS_Careers_Service_Intranet'
>>>displayName='Applications:Filestores:PSS:Student_&_Academic_Services:Care
>er
>>s
>>>_Service:PSS_SFS_Careers_Service_Intranet'
>>>uuid='1af21f3c9f1a4c50abb48209ead4b624'
>>>
>>>However if I try to delete the group, the following is displayed;
>>>
>>>gsh 28%
>>>delGroup("Applications:Filestores:PSS:Student_&_Academic_Services:Careers_
>S
>>er
>>>vice:PSS_SFS_Careers_Service_Intranet")
>>>// Error: unable to evaluate command: Sourced file: inline evaluation of:
>>>``delGroup("Applications:Filestores:PSS:Student_&_Academic_Services:Careers
>_
>>S
>>>ervic . . . '' : Error invoking compiled command: : Error in compiled 
>>>command:
>>>edu.internet2.middleware.grouper.exception.GrouperException: unexpected
>>>condition,
>>>Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: 
>>>false,
>>>grouperTransactionType: READ_WRITE_NEW
>>>
>>>It appears that the Group creation transaction may not have been completed
>>>correctly and has become into a bit of an orphaned state. I can see the 
>>>group
>in
>>>the groupers_group table in the database.
>>>
>>>Is there any way to resolve this? This is causing issues when we are 
>>>trying to
>>>provision our groups into the Active directory, as when it gets to this 
>>>group, its
>>>encountering a null error. I've attached a copy of our grouper_error log.
>>>
>>>Any help would be really appreciated.
>>>
>>>Regards,
>>>Richie
>>>
>>>Newcastle University