Re: [Dspace-tech] Unable to delete Community
> for a safe option, try to run index-init with the -r and -f parameters (see > -h). > The reindex will take a while, depending on the size of your repo, so prepare > for the downtime. Thanks for the suggestion - I will try this during our early morning "at risk" period tomorrow so as to minimise the impact. Cheers, Mike Michael White eLearning Liaison and Development (eLD) Information Services S8, Library University of Stirling Stirling SCOTLAND FK9 4LA Email: michael.wh...@stir.ac.uk Tel: +44 (0) 1786 466877 Fax: +44 (0) 1786 466880 http://www.stir.ac.uk/is/staff/about/teams/aldt/#eld > -Original Message- > From: ivan.ma...@gmail.com [mailto:ivan.ma...@gmail.com] On Behalf Of > helix84 > Sent: 24 February 2014 10:10 > To: Michael White > Cc: dspace-tech@lists.sourceforge.net > Subject: Re: [Dspace-tech] Unable to delete Community > > Hi Mike, > > for a safe option, try to run index-init with the -r and -f parameters (see > -h). > The reindex will take a while, depending on the size of your repo, so prepare > for the downtime. > > > Regards, > ~~helix84 > > Compulsory reading: DSpace Mailing List Etiquette > https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette > -- The University of Stirling has been ranked in the top 12 of UK universities for graduate employment*. 94% of our 2012 graduates were in work and/or further study within six months of graduation. *The Telegraph The University of Stirling is a charity registered in Scotland, number SC 011159. -- Flow-based real-time traffic analytics software. Cisco certified tool. Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer Customize your own dashboards, set traffic alerts and generate reports. Network behavioral analysis & security monitoring. All-in-one tool. http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
Re: [Dspace-tech] Unable to delete Community
Hi Mike, for a safe option, try to run index-init with the -r and -f parameters (see -h). The reindex will take a while, depending on the size of your repo, so prepare for the downtime. Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- Flow-based real-time traffic analytics software. Cisco certified tool. Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer Customize your own dashboards, set traffic alerts and generate reports. Network behavioral analysis & security monitoring. All-in-one tool. http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
[Dspace-tech] Unable to delete Community
Hi, I'm trying to delete a Community in my v1.6.2 DSpace system that is no longer required. I emptied all the Collections in the Community by moving their (several hundred) items to Collections in different Communities, then deleted these empty Collections - so now only the Community remains, and the "Community strength" shows as "[0]" on the Community/Collections list page - however, when I try to delete the Community, I get the error: Exception: org.postgresql.util.PSQLException: ERROR: update or delete on table "community" violates foreign key constraint "$1" on table "communities2item" Detail: Key (community_id)=(83) is still referenced from table "communities2item". - checking the database, I can see that there are, indeed, 11 references to the apparently empty Community in the communities2item table, but checking each of these items, I see that they all appear twice in the table - once against the old, now supposedly empty Community, and once against the Community containing the Collections the items have been moved to . . . So, aside from the fact that I don't know why these 11 items still appear against this Community in the DB, my question is, is it safe to simply delete the 11 apparently spurious rows in the communities2item table relating to the empty Community so that I can then delete the no longer needed Community? Or is there something more subtle going on that I'm not aware of . . . ? Any pointers/reassurance welcome :-) Cheers, Mike Michael White eLearning Liaison and Development (eLD) Information Services S8, Library University of Stirling Stirling SCOTLAND FK9 4LA Email: michael.wh...@stir.ac.uk Tel: +44 (0) 1786 466877 Fax: +44 (0) 1786 466880 http://www.stir.ac.uk/is/staff/about/teams/aldt/#eld -- The University of Stirling has been ranked in the top 12 of UK universities for graduate employment*. 94% of our 2012 graduates were in work and/or further study within six months of graduation. *The Telegraph The University of Stirling is a charity registered in Scotland, number SC 011159. -- Flow-based real-time traffic analytics software. Cisco certified tool. Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer Customize your own dashboards, set traffic alerts and generate reports. Network behavioral analysis & security monitoring. All-in-one tool. http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette