Skip to Content.
Sympa Menu

grouper-users - AW: [grouper-users] Database problem with group

Subject: Grouper Users - Open Discussion List

List archive

AW: [grouper-users] Database problem with group


Chronological Thread 
  • From: "Biernath, Jutta" <>
  • To: "'Hyzer, Chris'" <>, "" <>
  • Subject: AW: [grouper-users] Database problem with group
  • Date: Tue, 27 Feb 2018 14:56:37 +0100
  • Accept-language: de-DE, en-US
  • Ironport-phdr: 9a23:42dO9RHJj5UbAUnY9gnN/51GYnF86YWxBRYc798ds5kLTJ7yoc+wAkXT6L1XgUPTWs2DsrQY07GQ6/iocFdDyK7JiGoFfp1IWk1NouQttCtkPvS4D1bmJuXhdS0wEZcKflZk+3amLRodQ56mNBXdrXKo8DEdBAj0OxZrKeTpAI7SiNm82/yv95HJbAhEmDSwbaluIBmqsA7cqtQYjYx+J6gr1xDHuGFIe+NYxWNpIVKcgRPx7dqu8ZBg7ipdpesv+9ZPXqvmcas4S6dYDCk9PGAu+MLrrxjDQhCR6XYaT24bjwBHAwnB7BH9Q5fxri73vfdz1SWGIcH7S60/VDK/5KlpVRDokj8KOT4n/m/Klsx+j6xbrxC9qBNwzYDUYZqYO+Bicq7ZZ94WWXZNUttXWidcAo28dYwPD+8ZMOpWsoT9pkUBrQG4BQa2GOPvyidEjWLy060nz+QhDRvJ0AI9FN8JsnTUscn1NLsIXuyv16bIzCvMb+lQ2Tjn9IjIcgssof+RXb5pasXe11MvFwfEjlWWs4DqIi2a2/0LvmOG4eRgUuevhHQmqwF3ujWvyNoshpDSiY0L0FDE8SR5wIAvKdKlVkF2Z8OvHphItyyCKod7TN8uT3t1tCs0xLAKo5G2cDIOxZkn3xLTdvKKf5SS7h7+WuucLy10iG9ndb6jnRq+71SsxvPkWsWp3ltGsjBJnsTCu30DzRDf98qKRudn8ku81zuDywbe4fxeL08uj6rUMZshz6YwlpUNtUTDGTf7mELrjK+KbkUk/fOo6/jjb7n8p56TKZJ7hRviMqg0lMy/HP00PRMQUGiB/eS81bvj8VfkT7pUlvE2k6/Zv47GJckDu6K0DRNZ3pw+5xuxATqqytsVkWMDIV9FYB6HipLmO1DKIPD2F/e/hFGsnS9px/DbIr3hHo/CImLYn7fgY7l98UhcxxAvzdBf/J9UBKwBLOvoVUDvrtzYCh45Mwquz+n6FtpxzpkeVn6XAq+FLKPStkeF5u01I+mLeY8VoCjyK+I86/7zln82h0UdfbKy0JsTaXC4BehmI16HbXb2g9cBF3sKsRQkTOzsllKCTSBfa2ysUK0h+zFoQL6hWM2MZpG/jabFlAy7BJxNKSoOXlWHEWb6ep+sWuwHLj+KL8ln1DEISO7lA8UuzxazrALgjqd8I/DP0iweqZ/50tVpvavemQx4vWh7FcOAy2yXCnxvk3kTbz4wwK1lp0FhkBGO3bUu0NJCEtkGrdlIXx08PILci6RYFszuU0iJKtWUVEqvBN+nDCs3R84x69ETJkxwAdGjiFbP0nz5UPcui7WXCclsoern1H/rKpMlxg==

ok, it worked! I’ve taken the „context_id“ of the group in grouper_groups and have made it active in grouper_pit_members again.

 

I could delete it then, and the group disappeared from grouper_groups. However it was still in both grouper_pit_members and grouper_pit_groups as “active”. I’ve updated it both into active=’F’ and end_time = ‘1519738028000’.

 

Thanks again,

 

Jutta

 

 

 

 

 

--------------------

 

Freie Universit├Ąt Berlin

Zentraleinrichtung Datenverarbeitung

FU Directory and Identity Service

Fabeckstr. 32

14195 Berlin, Germany

 

Telefon +49 30 838-58385

https://www.zedat.fu-berlin.de/FUDIS

 

Von: [mailto:] Im Auftrag von Biernath, Jutta
Gesendet: Dienstag, 27. Februar 2018 09:20
An: 'Hyzer, Chris' <>;
Betreff: AW: [grouper-users] Database problem with group

 

Hi, Chris,

 

The record I’ve found in grouper_pit_members is inactive and has an end date.  I think this must be changed?!

 

There’s also a column “context_id” in grouper_members. I don’t have a clue what to insert in there.

 

Thank you for your help!

 

Jutta

 

--------------------

 

Freie Universit├Ąt Berlin

Zentraleinrichtung Datenverarbeitung

FU Directory and Identity Service

Fabeckstr. 32

14195 Berlin, Germany

 

Telefon +49 30 838-58385

https://www.zedat.fu-berlin.de/FUDIS

 

Von: Hyzer, Chris []
Gesendet: Montag, 26. Februar 2018 19:35
An: Biernath, Jutta <>;
Betreff: RE: [grouper-users] Database problem with group

 

Yes, try adding a dummy record I guess.  Look at an existing group to see how things line up with other tables.

 

See the group in grouper_groups (in this case assume name is test:testGroup)

 

select id from grouper_groups where name = 'test:testGroup';

 

In my case its: dbfa18c3-a025-47b6-a9a0-be5ac02e8270

 

The id column of the group is the subject_id in grouper_members.  So in my case the grouper_members.subject_id is “dbfa18c3-a025-47b6-a9a0-be5ac02e8270”

 

The id column of grouper_members is the source_id in grouper_pit_members where the subject_id is the thing above (in my case dbfa18c3-a025-47b6-a9a0-be5ac02e8270):

 

select source_id from grouper_pit_members gpm where GPM.subject_id = 'dbfa18c3-a025-47b6-a9a0-be5ac02e8270';

 

Note, when you select the record from grouper_pit_members, does it have an end date, and/or active ‘F’?

 

Subject_source is “g:gsa”

Subject_type is “group”

Hibernate_version_number is 1

For the rest of the cols, look at an existing group and make it similar

 

Thanks

Chris

 

 

 

 

 

-----Original Message-----
From: [] On Behalf Of Jutta Biernath
Sent: Monday, February 26, 2018 12:59 PM
To:
Subject: [grouper-users] Database problem with group

 

Hi, all,

 

I have a big problem with a group with was created and filled via web

services. Everything worked ok, but a few days ago the according dataset in

grouper_members was seemingly deleted.

 

Unfortunately I just can guess that from the (meanwhile overwritten) log files

and from the fact that there are records in grouper_members for the other

groups, but not for this one.

 

Now this group is absolutely unhandle-able, I can neither rename nor move nor

delete it, neither in UI nor in gsh. And even worse: there's no bulkSync

possible, for it crashes each time when the sync touches this group.

 

I have no idea why this record is missing in grouper_members. It must have

been there before, for the provisioning once worked, the group was exported to

ldap as expected, but was not updated fo a few days now.

 

Error in log file when provisioning:

****************************************

ERROR Group.toMember(5289) -  - could not convert group to member: null

ERROR BaseSpmlProvider.execute(139) -  -

Response[status=failure,error=unsupportedOperation,errorMessages={},requestID=

2018/02/26-17:32:04.111]

 

Error in log file when trying to delete:

**********************************************

ERROR ShellHelper.eval(91) -  - Sourced file: inline evaluation of:

``g.delete();'' : Method Invocation g.delete

edu.internet2.middleware.grouper.exception.GrouperException: could not convert

group to member: null,

 

Error in UI when trying to delete:

*****************************************

Error: could not convert group to member: null, Problem in HibernateSession:

HibernateSession (236e7bf1): notNew, notReadonly, READ_WRITE_NEW,

activeTransaction, session (45e96b86), Problem in HibernateSession:

HibernateSession (77a7eb74): new, notReadonly, READ_WRITE_NEW,

notActiveTransaction, session (45e96b86), Problem calling method

groupDeleteSubmit on

edu.internet2.middleware.grouper.grouperUi.serviceLogic.UiV2Group

 

 

Error in UI when trying to rename:

******************************************

Error editing group: could not convert group to member: null, Exception in

update: edu.internet2.middleware.grouper.Group,

, Problem in

HibernateSession: HibernateSession (1e7bfff9): notNew, notReadonly,

READ_WRITE_NEW, activeTransaction, session (2aebcae1), Exception in update:

edu.internet2.middleware.grouper.Group, ByObjectStatic, query: ', cacheable:

null, cacheRegion: null, entityName: null, tx type: null, Problem in

HibernateSession: HibernateSession (1f03989c): notNew, notReadonly,

READ_WRITE_NEW, activeTransaction, session (2aebcae1), Problem in

HibernateSession: HibernateSession (296d75d5): new, notReadonly,

READ_WRITE_NEW, notActiveTransaction, session (2aebcae1), Problem saving

group: xxx, thread: 5df7bb64

 

 

I already thought of simply adding a dummy record in grouper_members, but I

don't know if that causes unresolvable inconsistencies.

 

Please help!

 

 

 

Thank you,

 

Jutta




Archive powered by MHonArc 2.6.19.

Top of Page