too many queries when creating group

Hi Chris,

I hope you're doing well. We are planning to put Grouper in prod this week, but suddenly started noticing major performance issues in our test env primarily when creating new groups (either individually or as part of a template). For example it takes about 20 sec to create a new empty group (no members) and several minutes to create a new app template structure. Our DBA enabled profiling and says the query (below) is run 3000 times when a new group is created in the UI. I did recently change the subject db connection settings from to the loader.properties file settings you mentioned in the forums and a lot of new groups were created to handle grouper->google provisioning, but those provisioner Google settings are not currently in this env. I have also noticed the following null attribute entries in the INFO logs: Hib3AttributeDefNameDAO.findByIdSecure(160) - - AttributeDefName not found: null.

I tried enabling debug but it was so chatty and I'm really not seeing any errors on the Grouper side at all. Do you have any ideas what might be causing this or tips to point me in the right direction? Thanks for your help!

---- Query running 3,000 times —
select distinct membership0_.membership_id as membersh1_28_0_, membership0_.immediate_membership_id as immediat2_28_0_, membership0_.group_set_id as group_se3_28_0_, member1_.id as id1_26_1_, membership0_.hibernate_version_number as hibernat4_28_0_, membership0_.owner_id as owner_id5_28_0_, membership0_.owner_attr_def_id as owner_at6_28_0_, membership0_.owner_group_id as owner_gr7_28_0_, membership0_.owner_stem_id as owner_st8_28_0_, membership0_.member_id as member_i9_28_0_, membership0_.field_id as field_i10_28_0_, membership0_.immediate_field_id as immedia11_28_0_, membership0_.via_composite_id as via_com12_28_0_, membership0_.membership_creator_id as members13_28_0_, membership0_.membership_create_time as members14_28_0_, membership0_.group_set_creator_id as group_s15_28_0_, membership0_.group_set_create_time as group_s16_28_0_, membership0_.context_id as context17_28_0_, membership0_.group_set_parent_id as group_s18_28_0_, membership0_.via_group_id as via_gro19_28_0_, membership0_.depth as depth20_28_0_, membership0_.mship_type as mship_t21_28_0_, membership0_.immediate_mship_enabled as immedia22_28_0_, membership0_.immediate_mship_enabled_time as immedia23_28_0_, membership0_.immediate_mship_disabled_time as immedia24_28_0_, member1_.hibernate_version_number as hibernat2_26_1_, member1_.subject_id as subject_3_26_1_, member1_.subject_source as subject_4_26_1_, member1_.subject_type as subject_5_26_1_, member1_.context_id as context_6_26_1_, member1_.subject_identifier0 as subject_7_26_1_, member1_.sort_string0 as sort_str8_26_1_, member1_.sort_string1 as sort_str9_26_1_, member1_.sort_string2 as sort_st10_26_1_, member1_.sort_string3 as sort_st11_26_1_, member1_.sort_string4 as sort_st12_26_1_, member1_.search_string0 as search_13_26_1_, member1_.search_string1 as search_14_26_1_, member1_.search_string2 as search_15_26_1_, member1_.search_string3 as search_16_26_1_, member1_.search_string4 as search_17_26_1_, member1_.name as name18_26_1_, member1_.description as descrip19_26_1_ from grouper_memberships_all_v membership0_ cross join grouper_members member1_ cross join grouper_fields field2_ where membership0_.owner_group_id=$1 and membership0_.member_id=$2 and membership0_.field_id=$3 and membership0_.member_id=member1_.id and membership0_.immediate_mship_enabled='T'

–
Lacey Vickery | Identity & Access Management
UNC Charlotte | Information Technology Services
9201 University City Blvd. | Charlotte, NC 28223
Phone: 704-687-7064 | Office: Kennedy 301-C38
Lacey.Vickery@uncc.edu | https://itservices.uncc.edu