Skip to Content.
Sympa Menu

grouper-users - [grouper-users] bug in 2.3.0? cannot delete group

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] bug in 2.3.0? cannot delete group


Chronological Thread 
  • From: Jim Fox <>
  • To: "" <>
  • Subject: [grouper-users] bug in 2.3.0? cannot delete group
  • Date: Fri, 9 Feb 2018 13:55:26 -0800 (PST)
  • Ironport-phdr: 9a23:Xe0ezBLVOxVNXUIWaNmcpTZWNBhigK39O0sv0rFitYgRLvjxwZ3uMQTl6Ol3ixeRBMOHs6sC07KempujcFRI2YyGvnEGfc4EfD4+ouJSoTYdBtWYA1bwNv/gYn9yNs1DUFh44yPzahANS47xaFLIv3K98yMZFAnhOgppPOT1HZPZg9iq2+yo9JDffxhEiCChbb9uMR67sRjfus4KjIV4N60/0AHJonxGe+RXwWNnO1eelAvi68mz4ZBu7T1et+ou+MBcX6r6eb84TaFDAzQ9L281/szrugLdQgaJ+3ART38ZkhtMAwjC8RH6QpL8uTb0u+ZhxCWXO9D9QLYpUjqg8qhrUgflhikHOTAn7W/ZicJ/g61Hrx+6uxxz35TZbJ2JOPdkYK/Qe84RS2pbXsZWUixMGoeyb4oKD+EcPehYqIb8rEYJoBuwAgmtC/jiyzFSiX/t3a060uIhEQ7a3AwnGdICqmrbo8joNKoLV+2+0arGzS3bYv9Lxzvw65LEfxQhrP2WQ759ftTdxVMxGw/bkFmcsY3oMjeP2ukJrmSX9fRsWO2vhmI9rwx8pCWkyN02hYnTnI0Vz0jJ9SVnz4YxIt21UEt7YNGjEJtNqyGWKZV6Ttk5Q21ypSY7xKcKtoCmcygX0JgnxhjfZOKbc4WQ/x7vSuWcLS18iX9lYr6zmRm//Va6xuHiSMW4zk5Gri9fndnNsnAN2QbT6s+CSvZl8Eeh3jmO2hvd6+5eOkA0lavbK5guwr4skZoTt17PETHrl0XrlKOWbFkr+vC06+T7ZbXrvpCcN5VzigHjKqQhhNa/Df0lMggVQWeb4/+82abn/U34W7VKkuY2nrfDvJDbI8QburC2AxVT0ok99xazES2q38oFknkafxp5f0fNgJLuJknDOrXlFvqlmHytlitm3fbLIuenD5nQZDCXn63mYK5w8QtB0wcp1vhe4Y5ZELcMPKi1V0Ps4o/2FBg8Zi61xq7JD8U1go0ZSUqQC7SZMaXdrViOoO8jPr/fN8cupD/hJq19tLbVhngjlApFcA==

This looks like a grouper bug, relating to custom lists.

I am doing some final testing for our soon-to-happen upgrade to grouper 2.3.0. So this is on a test database.

1) have grouper 2.3.0 with patch level 92
2) copied database (postgres) to test database
3) converted the database from 26 to 30

We have some custom lists, 'authorized-senders' being one.

For a particular group I can add a member to that list in the admin ui. That
works.
However, now I cannot delete the group. Trying to results in these log
entries:

(several)
2018-02-09 13:22:16,516: [ajp-nio-127.0.0.1-8009-exec-4] INFO EventLog.info(156) -
< fox 193FE75E02962F84795D608DD9527B54.iam21-0071
0aa1b0d7f4ff440b9da54cf43cc85f26 d9459cae21d011d4abd00004ac494ffe uwpds > -
[af75960cd6104f6492b5d08773d00f8c,'GrouperSystem','application'] revoke access
priv: group='u:fox:browser6:sub7' priv='view' (92ms)

and etc for the other privs. Then:

2018-02-09 13:22:17,163: [ajp-nio-127.0.0.1-8009-exec-4] ERROR SqlExceptionHelper.logExceptions(129) - < fox
193FE75E02962F84795D608DD9527B54.iam21-0071 0aa1b0d7f4ff440b9da54cf43cc85f26 d9459cae21d011d4abd00004ac494ffe
uwpds > - Batch entry 0 delete from grouper_groups where id='09e7861885d546b4bde6e00df413f690' and
hibernate_version_number=4 was aborted: ERROR: update or delete on table "grouper_groups" violates
foreign key constraint "fk_memberships_group_owner_id" on table "grouper_memberships"

This is because the membership of the custom list was not deleted. If I delete that membership then I can delete the group. I've encountered this with both the API and the UI.

Jim





Archive powered by MHonArc 2.6.19.

Top of Page