Skip to Content.
Sympa Menu

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

Subject: Grouper Users - Open Discussion List

List archive

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


Chronological Thread 
  • From: Jim Fox <>
  • To: Shilen Patel <>
  • Cc: "" <>
  • Subject: Re: [grouper-users] bug in 2.3.0? cannot delete group
  • Date: Wed, 14 Feb 2018 09:19:17 -0800 (PST)
  • Ironport-phdr: 9a23:wAL+BRbkUTqeor6dGLIMt8f/LSx+4OfEezUN459isYplN5qZoMq+bnLW6fgltlLVR4KTs6sC17KN9fi4EUU7or+5+EgYd5JNUxJXwe43pCcHRPC/NEvgMfTxZDY7FskRHHVs/nW8LFQHUJ2mPw6arXK99yMdFQviPgRpOOv1BpTSj8Oq3Oyu5pHfeQpFiCazbL9oMBm6sRjau9ULj4dlNqs/0AbCrGFSe+RRy2NoJFaTkAj568yt4pNt8Dletuw4+cJYXqr0Y6o3TbpDDDQ7KG81/9HktQPCTQSU+HQRVHgdnwdSDAjE6BH6WYrxsjf/u+Fg1iSWIdH6QLYpUjm58axlVAHnhzsGNz4h8WHYlMpwjL5AoBm8oxBz2pPYbJ2JOPZ7eK7WYNEUSndbXstJWSJPAp2yYZYNAOQCM+ZXoYbyqEcVoBuiGQWhHv/jxiNSi3Po26AxzuQvERvB3AwlB98AtHXUrNDoP6kSVuC0w7TDwDLNb/NR1jbw84bJfQo6ofGMXLJwd8XRyVUoFwPDlFmft5HqPy6M2+kLrmOV7PJgWPqyh2Motw19uCWjy8gyhoXTmI4YxF/J+T9kzIs3JdC0UFN3bcCnHZdKqS2WK4h7Ttk+T21yuSs3zKANt4ShcygQ0psnwgbSa/yZfIiM5RLuTOORIDh/hHJ4ZLKzmRa//VK7yuHmS8m13kxGoTRYndnRrnwN1hrT5dabSvZl40us1iqD2xrO5uxLP0w4j7TXJpAuz7Iqi5Yes0TOEjfzmErsja+Wcksk+vKv6+TierjmqJicNoBvhwDwKKsugcy/AeU+MggBQ2ib/uK82Kf98kLkXbVGluc2nbXBsJDGOcQboba0AwBP0oYk9ha/Fymp0M4BkXkaN1JKZgiHj5PyNlHKIfD4Fuu/g0+ynDtxxvDGOKHhDYvXLnjFjrjhYahx51RCxwUu0NAMr65TX4oBIfb+XAfJvcDVCldtKAy1x+vhINlg1Y5YVG6SVPy3KqTX5H2J46oBJPnEMIESqB7iIuMl5vjhkXg/31IRYP/6jtMsdHmkE6E+cA2ian32j4JESD9Ssw==


Thanks,

Jim


On Wed, 14 Feb 2018, Shilen Patel wrote:

Date: Wed, 14 Feb 2018 07:42:23
From: Shilen Patel
<>
To: Jim Fox
<>
Cc:
""

<>
Subject: Re: [grouper-users] bug in 2.3.0? cannot delete group

This is fixed in grouper_v2_3_0_api_patch_93.

- Shilen

On 2/9/18, 4:55 PM,
"
on behalf of Jim Fox"
<
on behalf of
>
wrote:


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