Grouper Users - Open Discussion List

[Shilen Patel <>]

A separate application that just adds the 11,704th stem fails.  For 
example, if I add the stem using Grouper Shell with hibernate.show_sql 
set to true, I get the following output before Grouper Shell hangs:

gsh-0.0.1 0% addStem("duke", "teststem", "teststem")
Hibernate: select member0_.id as id, member0_.subject_id as subject_id, 
member0_.subject_source as subject_3_, member0_.subject_type as 
subject_4_, member0_.member_uuid as member_u5_ from grouper_members 
member0_ where (member0_.subject_id=? )and(member0_.subject_type=? 
)and(member0_.subject_source=? )
Hibernate: insert into grouper_sessions (member_id, start_time, 
session_uuid, id) values (?, ?, ?, ?)
Hibernate: update grouper_members set subject_id=?, subject_source=?, 
subject_type=?, member_uuid=? where id=?
Hibernate: select stem0_.owner_id as id, stem0_.description as 
descript2_9_, stem0_.display_extension as display_3_9_, 
stem0_.display_name as display_4_9_, stem0_.extension as extension9_, 
stem0_.name as name9_, stem0_.parent_stem as parent_s7_9_, 
stem0__1_.creator_id as creator_id8_, stem0__1_.create_source as 
create_s3_8_, stem0__1_.create_time as create_t4_8_, 
stem0__1_.modifier_id as modifier5_8_, stem0__1_.modify_source as 
modify_s6_8_, stem0__1_.modify_time as modify_t7_8_, stem0__1_.uuid as 
uuid8_ from grouper_stems stem0_, grouper_owners stem0__1_ where 
stem0_.owner_id=stem0__1_.id and ((stem0_.name=? ))
Hibernate: select stem0_.owner_id as id3_, stem0_.description as 
descript2_9_3_, stem0_.display_extension as display_3_9_3_, 
stem0_.display_name as display_4_9_3_, stem0_.extension as 
extension9_3_, stem0_.name as name9_3_, stem0_.parent_stem as 
parent_s7_9_3_, stem0__1_.creator_id as creator_id8_3_, 
stem0__1_.create_source as create_s3_8_3_, stem0__1_.create_time as 
create_t4_8_3_, stem0__1_.modifier_id as modifier5_8_3_, 
stem0__1_.modify_source as modify_s6_8_3_, stem0__1_.modify_time as 
modify_t7_8_3_, stem0__1_.uuid as uuid8_3_, stem1_.owner_id as id0_, 
stem1_.description as descript2_9_0_, stem1_.display_extension as 
display_3_9_0_, stem1_.display_name as display_4_9_0_, stem1_.extension 
as extension9_0_, stem1_.name as name9_0_, stem1_.parent_stem as 
parent_s7_9_0_, stem1__1_.creator_id as creator_id8_0_, 
stem1__1_.create_source as create_s3_8_0_, stem1__1_.create_time as 
create_t4_8_0_, stem1__1_.modifier_id as modifier5_8_0_, 
stem1__1_.modify_source as modify_s6_8_0_, stem1__1_.modify_time as 
modify_t7_8_0_, stem1__1_.uuid as uuid8_0_, member2_.id as id1_, 
member2_.subject_id as subject_id1_, member2_.subject_source as 
subject_3_1_, member2_.subject_type as subject_4_1_, 
member2_.member_uuid as member_u5_1_, member3_.id as id2_, 
member3_.subject_id as subject_id2_, member3_.subject_source as 
subject_3_2_, member3_.subject_type as subject_4_2_, 
member3_.member_uuid as member_u5_2_ from grouper_stems stem0_, 
grouper_owners stem0__1_, grouper_stems stem1_, grouper_owners 
stem1__1_, grouper_members member2_, grouper_members member3_ where 
stem0_.owner_id=? and stem0_.parent_stem=stem1_.owner_id(+) and 
stem1_.owner_id=stem1__1_.id(+) and stem0__1_.creator_id=member2_.id(+) 
and stem0__1_.modifier_id=member3_.id(+) and stem0_.owner_id=stem0__1_.id
Hibernate: select stem0_.owner_id as id, stem0_.description as 
descript2_9_, stem0_.display_extension as display_3_9_, 
stem0_.display_name as display_4_9_, stem0_.extension as extension9_, 
stem0_.name as name9_, stem0_.parent_stem as parent_s7_9_, 
stem0__1_.creator_id as creator_id8_, stem0__1_.create_source as 
create_s3_8_, stem0__1_.create_time as create_t4_8_, 
stem0__1_.modifier_id as modifier5_8_, stem0__1_.modify_source as 
modify_s6_8_, stem0__1_.modify_time as modify_t7_8_, stem0__1_.uuid as 
uuid8_ from grouper_stems stem0_, grouper_owners stem0__1_ where 
stem0_.owner_id=stem0__1_.id and ((stem0_.name=? ))
Hibernate: select child_stem0_.parent_stem as parent_s7___, 
child_stem0_.owner_id as owner_id__, child_stem0_.owner_id as id2_, 
child_stem0_.description as descript2_9_2_, 
child_stem0_.display_extension as display_3_9_2_, 
child_stem0_.display_name as display_4_9_2_, child_stem0_.extension as 
extension9_2_, child_stem0_.name as name9_2_, child_stem0_.parent_stem 
as parent_s7_9_2_, child_stem0__1_.creator_id as creator_id8_2_, 
child_stem0__1_.create_source as create_s3_8_2_, 
child_stem0__1_.create_time as create_t4_8_2_, 
child_stem0__1_.modifier_id as modifier5_8_2_, 
child_stem0__1_.modify_source as modify_s6_8_2_, 
child_stem0__1_.modify_time as modify_t7_8_2_, child_stem0__1_.uuid as 
uuid8_2_, member1_.id as id0_, member1_.subject_id as subject_id0_, 
member1_.subject_source as subject_3_0_, member1_.subject_type as 
subject_4_0_, member1_.member_uuid as member_u5_0_, member2_.id as id1_, 
member2_.subject_id as subject_id1_, member2_.subject_source as 
subject_3_1_, member2_.subject_type as subject_4_1_, 
member2_.member_uuid as member_u5_1_ from grouper_stems child_stem0_, 
grouper_owners child_stem0__1_, grouper_members member1_, 
grouper_members member2_ where child_stem0_.parent_stem=? and 
child_stem0__1_.creator_id=member1_.id(+) and 
child_stem0__1_.modifier_id=member2_.id(+) and 
child_stem0_.owner_id=child_stem0__1_.id
Hibernate: select child_grou0_.parent_stem as parent_s2___, 
child_grou0_.owner_id as owner_id__, child_grou0_.owner_id as id2_, 
child_grou0_.parent_stem as parent_s2_10_2_, child_grou0__1_.creator_id 
as creator_id8_2_, child_grou0__1_.create_source as create_s3_8_2_, 
child_grou0__1_.create_time as create_t4_8_2_, 
child_grou0__1_.modifier_id as modifier5_8_2_, 
child_grou0__1_.modify_source as modify_s6_8_2_, 
child_grou0__1_.modify_time as modify_t7_8_2_, child_grou0__1_.uuid as 
uuid8_2_, member1_.id as id0_, member1_.subject_id as subject_id0_, 
member1_.subject_source as subject_3_0_, member1_.subject_type as 
subject_4_0_, member1_.member_uuid as member_u5_0_, member2_.id as id1_, 
member2_.subject_id as subject_id1_, member2_.subject_source as 
subject_3_1_, member2_.subject_type as subject_4_1_, 
member2_.member_uuid as member_u5_1_ from grouper_groups child_grou0_, 
grouper_owners child_grou0__1_, grouper_members member1_, 
grouper_members member2_ where ((child_grou0_.parent_stem=?) or 
(child_grou0_.parent_stem=?) or (child_grou0_.parent_stem=?)) and 
child_grou0__1_.creator_id=member1_.id(+) and 
child_grou0__1_.modifier_id=member2_.id(+) and 
child_grou0_.owner_id=child_grou0__1_.id
Hibernate: select group_type0_.group_id as group_id__, 
group_type0_.type_id as type_id__, grouptype1_.id as id0_, 
grouptype1_.name as name0_, grouptype1_.creator_id as creator_id0_, 
grouptype1_.create_time as create_t4_0_, grouptype1_.assignable as 
assignable0_, grouptype1_.internal as internal0_ from 
grouper_groups_types group_type0_, grouper_types grouptype1_ where 
group_type0_.group_id=? and group_type0_.type_id=grouptype1_.id
Hibernate: select fields0_.group_type as group_type__, fields0_.id as 
id__, fields0_.id as id0_, fields0_.group_type as group_type0_, 
fields0_.field_type as field_type0_, fields0_.field_name as 
field_name0_, fields0_.read_priv as read_priv0_, fields0_.write_priv as 
write_priv0_, fields0_.nullable as nullable0_ from grouper_fields 
fields0_ where fields0_.group_type=? order by fields0_.field_name asc
Hibernate: select fields0_.group_type as group_type__, fields0_.id as 
id__, fields0_.id as id0_, fields0_.group_type as group_type0_, 
fields0_.field_type as field_type0_, fields0_.field_name as 
field_name0_, fields0_.read_priv as read_priv0_, fields0_.write_priv as 
write_priv0_, fields0_.nullable as nullable0_ from grouper_fields 
fields0_ where fields0_.group_type=? order by fields0_.field_name asc
Hibernate: select grouptype0_.id as id, grouptype0_.name as name, 
grouptype0_.creator_id as creator_id, grouptype0_.create_time as 
create_t4_, grouptype0_.assignable as assignable, grouptype0_.internal 
as internal from grouper_types grouptype0_ order by  name asc
Hibernate: select fields0_.group_type as group_type__, fields0_.id as 
id__, fields0_.id as id0_, fields0_.group_type as group_type0_, 
fields0_.field_type as field_type0_, fields0_.field_name as 
field_name0_, fields0_.read_priv as read_priv0_, fields0_.write_priv as 
write_priv0_, fields0_.nullable as nullable0_ from grouper_fields 
fields0_ where fields0_.group_type=? order by fields0_.field_name asc
Hibernate: select fields0_.group_type as group_type__, fields0_.id as 
id__, fields0_.id as id0_, fields0_.group_type as group_type0_, 
fields0_.field_type as field_type0_, fields0_.field_name as 
field_name0_, fields0_.read_priv as read_priv0_, fields0_.write_priv as 
write_priv0_, fields0_.nullable as nullable0_ from grouper_fields 
fields0_ where fields0_.group_type=? order by fields0_.field_name asc
Hibernate: select fields0_.group_type as group_type__, fields0_.id as 
id__, fields0_.id as id0_, fields0_.group_type as group_type0_, 
fields0_.field_type as field_type0_, fields0_.field_name as 
field_name0_, fields0_.read_priv as read_priv0_, fields0_.write_priv as 
write_priv0_, fields0_.nullable as nullable0_ from grouper_fields 
fields0_ where fields0_.group_type=? order by fields0_.field_name asc
Hibernate: select group_type0_.group_id as group_id__, 
group_type0_.type_id as type_id__, grouptype1_.id as id0_, 
grouptype1_.name as name0_, grouptype1_.creator_id as creator_id0_, 
grouptype1_.create_time as create_t4_0_, grouptype1_.assignable as 
assignable0_, grouptype1_.internal as internal0_ from 
grouper_groups_types group_type0_, grouper_types grouptype1_ where 
group_type0_.group_id=? and group_type0_.type_id=grouptype1_.id
Hibernate: select group_attr0_.group_id as group_id__, group_attr0_.id 
as id__, group_attr0_.id as id0_, group_attr0_.version as version0_, 
group_attr0_.group_id as group_id0_, group_attr0_.field_name as 
field_name0_, group_attr0_.field_type as field_type0_, 
group_attr0_.value as value0_ from grouper_attributes group_attr0_ where 
group_attr0_.group_id=?
Hibernate: select field0_.id as id, field0_.group_type as group_type, 
field0_.field_type as field_type, field0_.field_name as field_name, 
field0_.read_priv as read_priv, field0_.write_priv as write_priv, 
field0_.nullable as nullable from grouper_fields field0_ order by  
field_name asc
Hibernate: select fields0_.group_type as group_type__, fields0_.id as 
id__, fields0_.id as id0_, fields0_.group_type as group_type0_, 
fields0_.field_type as field_type0_, fields0_.field_name as 
field_name0_, fields0_.read_priv as read_priv0_, fields0_.write_priv as 
write_priv0_, fields0_.nullable as nullable0_ from grouper_fields 
fields0_ where fields0_.group_type=? order by fields0_.field_name asc
Hibernate: select fields0_.group_type as group_type__, fields0_.id as 
id__, fields0_.id as id0_, fields0_.group_type as group_type0_, 
fields0_.field_type as field_type0_, fields0_.field_name as 
field_name0_, fields0_.read_priv as read_priv0_, fields0_.write_priv as 
write_priv0_, fields0_.nullable as nullable0_ from grouper_fields 
fields0_ where fields0_.group_type=? order by fields0_.field_name asc
Hibernate: select fields0_.group_type as group_type__, fields0_.id as 
id__, fields0_.id as id0_, fields0_.group_type as group_type0_, 
fields0_.field_type as field_type0_, fields0_.field_name as 
field_name0_, fields0_.read_priv as read_priv0_, fields0_.write_priv as 
write_priv0_, fields0_.nullable as nullable0_ from grouper_fields 
fields0_ where fields0_.group_type=? order by fields0_.field_name asc
Hibernate: select group_attr0_.group_id as group_id__, group_attr0_.id 
as id__, group_attr0_.id as id0_, group_attr0_.version as version0_, 
group_attr0_.group_id as group_id0_, group_attr0_.field_name as 
field_name0_, group_attr0_.field_type as field_type0_, 
group_attr0_.value as value0_ from grouper_attributes group_attr0_ where 
group_attr0_.group_id=?
Hibernate: delete from grouper_groups_types where group_id=?
Hibernate: delete from grouper_groups_types where group_id=?


Thanks,

-- Shilen


Tom Barton wrote:
> Do you mean that a single load process stops? There've been a few 
> similar reports that were caused by running out of JVM heap space. 
> Have you set yours up from the default? Or do you mean that even 
> independent application invocations that try to add the 11,704 + 1st 
> stem fail to do so?
>
> Tom
>
> Shilen Patel wrote:
> > Hello,
> >
> > I'm noticing a strange issue with Grouper that I'm hoping somebody 
> > can help me out with.  I'm trying to create about 60,000 stems in 
> > Grouper, but after creating 11,704 stems, I'm unable to create any 
> > more with the API and with Grouper Shell.  In the 
> > _initializeChildGroupsAndStems(Stem) method of the Stem class, at the 
> > point where the code is trying to do a commit, nothing appears to be 
> > happening and the application just hangs (for days).  Though, I'm 
> > able to manuallly insert stems into the GROUPER_STEMS table.  Any 
> > ideas on what the problem might be?
> >
> > Thanks,
> >
> > -- Shilen Patel