Grouper Users - Open Discussion List

[Chris Hyzer <>]

fyi

> -----Original Message-----
> From: Chris Hyzer
> Sent: Monday, January 19, 2009 9:49 AM
> To: 
> ''
> Subject: RE: [grouper-users] Grouper 1.4.0: Unable to delete broken
> stem
>
> Sorry about that, this sounds like a bug.  I will try to reproduce this
> and fix it for 1.4.1.
>
> In the meantime, if you can delete all those from the DB (except one,
> or all and recreate).
>
> Once you get your DB to a state where there are no dupes, the index on
> stem name could be unique I believe... until 1.4.1 you might want to
> check to see if a stem exists before creating (if that is the problem,
> create twice without checking?)  If you get more info about the web
> service you call and params used to create multiples, let me know (I
> assume its "save stem")
>
> https://bugs.internet2.edu/jira/browse/GRP-204
>
> Anyone know of a reason why stem name index shouldn’t be unique?  I
> don’t think it was unique in 1.3 (with hibernate schema export)
> either...
>
> Thanks!
> Chris
>
> > -----Original Message-----
> > From: Dr. Loris Bennett 
> > [mailto:]
> > Sent: Monday, January 19, 2009 4:39 AM
> > To: Chris Hyzer
> > Subject: RE: [grouper-users] Grouper 1.4.0: Unable to delete broken
> > stem
> >
> > Hi Chris,
> >
> > Here is the log file. The offending stem "test:new_junk" has been
> > created multiple times in the table "grouper_stems".
> >
> > I have been using GcTransactionType.NONE, which strikes me as unwise,
> > but I don't really understand the consequences of using
> > READ_WRITE_OR_USE_EXISTING as opposed to READ_WRITE_NEW.
> >
> > Cheers
> >
> > Loris
> >
> >
> > On Fri, 2009-01-16 at 10:17 -0500, Chris Hyzer wrote:
> > > Its hard to tell without more info... are there any error messages
> in
> > the logs?
> > >
> > > Quick and dirty might just a DB query:  delete from grouper_stems
> > > where name = "a:b:c";
> > >
> > > (then if you get foreign key problems with group records or
> > something,
> > > delete that stuff too...  but it would be nice to figure out what
> the
> > > real problem is...)
> > >
> > > Regards,
> > > Chris
> > >
> > >
> > > > -----Original Message-----
> > > > From: Dr. Loris Bennett 
> > > > [mailto:]
> > > > Sent: Friday, January 16, 2009 8:22 AM
> > > > To: Grouper Users Mailing List
> > > > Subject: [grouper-users] Grouper 1.4.0: Unable to delete broken
> > stem
> > > >
> > > > Hi,
> > > >
> > > > Through fiddling around with grouper client and possibly due to a
> > > > version mismatch between client and web service I have managed to
> > > > create a stem which I cannot delete via the UI or via grouper
> > client.
> > > > Also, when I click on it in the UI I reach a sort of dead end in
> > > > which I can no longer browse by click on "explore" (see
> > attachment).
> > > >
> > > > Any ideas how I can get rid of the stem?
> > > >
> > > > Loris
> > > > --
> > > > Dr. Loris Bennett (Mr.)
> > > > Freie Universität Berlin
> > > > ZEDAT - Zentraleinrichtung für Datenverarbeitung / Computer
> Center
> > > > Compute & Media Service Fabeckstr. 32, Room 221
> > > > D-14195 Berlin
> > > > Tel ++49 30 838 51024
> > > > Fax ++49 30 838 56721
> > > > Email 
> > > > 
> > > > Web www.zedat.fu-berlin.de
> > --
> > Dr. Loris Bennett (Mr.)
> > Freie Universität Berlin
> > ZEDAT - Zentraleinrichtung für Datenverarbeitung / Computer Center
> > Compute & Media Service Fabeckstr. 32, Room 221
> > D-14195 Berlin
> > Tel ++49 30 838 51024
> > Fax ++49 30 838 56721
> > Email 
> > 
> > Web www.zedat.fu-berlin.de