Grouper Users - Open Discussion List

[Shilen Patel <>]

I think if you’re just trying to quickly clean it up, then you can just delete the bad row from grouper_members and delete the temp change log entries associated with that bad row.  If you were able to successfully add a membership with that bad member, then the temp change log also has other rows that would probably fail and need to be deleted.

 

Thanks!

 

- Shilen

 

From: Julio Polo <>
Date: Monday, October 15, 2018 at 4:57 PM
To: Shilen Patel <>
Cc: Baron Fujimoto <>, Grouper-Users <>
Subject: Re: [grouper-users] error running CHANGE_LOG_changeLogTempToChangeLog

 

I'm Baron's colleague, and I've witnessed the empty id issue in our version of Grouper (2.2.2).  It happens when we press return instead of tab to add a member in the new UI.  A few seconds after that, Grouper crashes and we are left with a membership in the group where the subject id is empty. We delete those empty-subject memberships as we encounter them, and that's probably why you can't find it now. 

 

If I'm correctly understanding the issue here, how do we delete this empty-subject-id entry from the change log so that it doesn't cause problems when running "CHANGE_LOG_changeLogTempToChangeLog"?

 

-julio

 

On Mon, Oct 15, 2018 at 10:42 AM Shilen Patel <> wrote:

How about:  select * from grouper_members where id = '069e366f7a4e4803ba9604fea154c7b2';

Thanks!

- Shilen

On 10/15/18, 4:40 PM, "Baron Fujimoto" <> wrote:

    It's possible the error is that old. This is actually a test system so some of this type of housekeeping is run very irregularly or on a perceived as-needed basis. IIRC, this is also supposed to be handled by the grouper loader, which we also, admittedly, don't run regularly. We don't use the loader for provisioning, and the current documentation doesn't mention changelog maintenance I think.

    I'm not sure how the entry was originally introduced, but perhaps it was due to a known bug in the UI (at least for our version) where you press return instead of tab to choose a person when adding a member.

    I'm not sure what to look for for "anything odd", but the following query yields no results:
    select * from grouper_members where subject_id = "069e366f7a4e4803ba9604fea154c7b2";

    On Sun, Oct 14, 2018 at 03:10:08AM +0000, Shilen Patel wrote:
    >Hi,
    >
    >I believe that change log is for a member add.  There are a couple of things that seem odd.  First, the created time on that is July 16 2017.  Have you been having this error for over a year?  Second, the error suggests that a member was added without a subject id, which shouldn’t be possible.  The member id (in the grouper_members table) should be the string01 in the error.  Perhaps take a look and see if there’s anything odd there? 
    >
    >Thanks!
    >
    >- Shilen
    >
    >On 10/12/18, 11:22 PM, " on behalf of Baron Fujimoto" < on behalf of > wrote:
    >
    >    I feel like this may have come up before, but my google-fu is coming up short.
    >   
    >    When I try the following from gsh, I'm encountering the following error for one of our instances:
    >   
    >    gsh 0% loaderRunOneJob("CHANGE_LOG_changeLogTempToChangeLog");
    >    // Error: unable to evaluate command: Sourced file: inline evaluation of: ``loaderRunOneJob("CHANGE_LOG_changeLogTempToChangeLog");'' : Error invoking compiled command: : Error in compiled command: java.lang.RuntimeException: java.lang.RuntimeException: subjectId is empty for change log entry: ChangeLogEntry: changeLogTypeId: '9bb887a5830e427086c951e4b93bda62', contextId: '', createdOnDb: '1500250492727000', hibernateVersionNumber: '-1', string01: '069e366f7a4e4803ba9604fea154c7b2', string02: '', string03: 'LDAP', string04: 'person', string05: '', string06: '', string07: '', string08: '', string09: '', string10: '', string11: '', string12: '',
    >    Problem in HibernateSession: HibernateSession (60a7e509): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (2b916808)
    >   
    >    This is Grouper 2.2.2. Any suggestions would be appreciated.

    --
    Baron Fujimoto <> :: UH Information Technology Services
    minutas cantorum, minutas balorum, minutas carboratum desendus pantorum