Skip to Content.
Sympa Menu

grouper-users - Fails to deleting group from grouper_members when the group is deleted

Subject: Grouper Users - Open Discussion List

List archive

Fails to deleting group from grouper_members when the group is deleted


Chronological Thread 
  • From: Colin Hudler <>
  • To:
  • Subject: Fails to deleting group from grouper_members when the group is deleted
  • Date: Thu, 10 Jun 2010 10:04:19 -0500

Greetings,

The grouper report emails are very helpful, thanks for that. I noticed that our unresolvable g:gsa subjects keeps increasing, so I investigated. In our environment, it seems that grouper does not delete groups from grouper_members table even though the group has been deleted from grouper_groups. See below for the steps I used to reproduce:

1) Starting with a (nearly) minimal registry:

mysql> select id,name from grouper_groups;
+----------------------------------+-----------------+
| id | name |
+----------------------------------+-----------------+
| 28f66ed34b03407b9525d8b23ce6603a | etc:wheel |
| 7621b985460f4fbcb9521e49203b261d | etc:provisioner |
+----------------------------------+-----------------+

mysql> select subject_id,subject_type from grouper_members;
+----------------------------------+--------------+
| subject_id | subject_type |
+----------------------------------+--------------+
| GrouperSystem | application |
| 28f66ed34b03407b9525d8b23ce6603a | group |
| GrouperAll | application |
| 7621b985460f4fbcb9521e49203b261d | group |
+----------------------------------+--------------+

2) Add a group using GSH, then check these two tables again:

gsh 0% addGroup("etc", "test", "test")
group: name='etc:test' displayName='etc:test' uuid='b7e6c819cc8a4bca84b99a92df097325'

mysql> select id,name from grouper_groups;
+----------------------------------+-----------------+
| id | name |
+----------------------------------+-----------------+
| 28f66ed34b03407b9525d8b23ce6603a | etc:wheel |
| 7621b985460f4fbcb9521e49203b261d | etc:provisioner |
| b7e6c819cc8a4bca84b99a92df097325 | etc:test |
+----------------------------------+-----------------+
mysql> select subject_id,subject_type from grouper_members;
+----------------------------------+--------------+
| subject_id | subject_type |
+----------------------------------+--------------+
| GrouperSystem | application |
| 28f66ed34b03407b9525d8b23ce6603a | group |
| GrouperAll | application |
| 7621b985460f4fbcb9521e49203b261d | group |
| b7e6c819cc8a4bca84b99a92df097325 | group |
+----------------------------------+--------------+


3) delete the group using GSH, then check the two tables again:

gsh 1% delGroup("etc:test")
true
mysql> select id,name from grouper_groups;
+----------------------------------+-----------------+
| id | name |
+----------------------------------+-----------------+
| 28f66ed34b03407b9525d8b23ce6603a | etc:wheel |
| 7621b985460f4fbcb9521e49203b261d | etc:provisioner |
+----------------------------------+-----------------+
mysql> select subject_id,subject_type from grouper_members;
+----------------------------------+--------------+
| subject_id | subject_type |
+----------------------------------+--------------+
| GrouperSystem | application |
| 28f66ed34b03407b9525d8b23ce6603a | group |
| GrouperAll | application |
| 7621b985460f4fbcb9521e49203b261d | group |
| b7e6c819cc8a4bca84b99a92df097325 | group | <--- It is still there?
+----------------------------------+--------------+

Do I need to make an additional command to grouper?

As an aside, USDU seems unable to delete these, even with the -delete option.



Archive powered by MHonArc 2.6.16.

Top of Page