Thanks all it seems working fine for me also now.
On Fri, Aug 29, 2014 at 1:40 PM, Michael White <[email protected]>
wrote:
> Hi,
>
> > When i attempt to delete item through JSPUI interface it gives internal
> system
> > error message but when i delete the same through xmlui interface it aslo
> > gives some error:
>
> I came across the same problem with my upgrade from v1.6 to v4.1 last week
> - my understanding is that it is due to old data in the database that
> relates to the (legacy) Lucene indexing system used in the earlier versions
> - if you have switched to using the Discovery (SOLR) Browse/Search indexing
> system in v4.2 (which is the default out of the box), then the old Lucene
> data lying around in the database is preventing items from being deleted
> (due to a foreign key constraint on one of the tables used by the old
> Lucene system).
>
> I also asked the question on the list, and Hilton Gibson kindly sent me
> these links which helped to confirm my suspicions:
>
> --------------------------------------------------------------
> Perhaps these links help.
> http://wiki.lib.sun.ac.za/index.php/SUNScholar/Browse_Indexes/3.2#WARNING
>
> http://wiki.lib.sun.ac.za/index.php/SUNScholar/Upgrading/DSpace/Release_Notes/3.X#During_our_upgrade_from_1.8.2_to_3.2.2C_the_following_errors_were_discovered_after_applying_the_upgrade_to_our_production_server
>
> http://wiki.lib.sun.ac.za/index.php/SUNScholar/Upgrading/DSpace/Release_Notes/4.X
> --------------------------------------------------------------
>
> The advice on those pages suggests making changes in the database
> directly, which you may or may not be comfortable doing.
>
> Instead of running SQL against the database directly, though, simply
> rebuilding the Lucene index as just empty tables with the following command
> seemed to do the trick for me (and no one on the list came back to me and
> said "don't do it that way because . . .", so I'm pretty sure it is OK):
>
> [dspace]/bin/dspace index-lucene-init -r -t -v
>
> When I ran this, it did throw an error (basically saying something about
> not setting up caching because SOLR is better, but I don't recall exactly)
> and most of the Lucene related tables actually disappeared! - but once I'd
> run it, I was able to delete items from my repository again, and I haven't
> noticed any other issues as a result.
>
> I hope that helps.
>
> Regards,
>
> Mike
>
> Michael White
> eLearning Liaison and Development (eLD)
> Information Services
> S8, Library
> University of Stirling
> Stirling SCOTLAND
> FK9 4LA
> Email: [email protected]
> Tel: +44 (0) 1786 466877
> Fax: +44 (0) 1786 466880
> http://www.stir.ac.uk/is/staff/about/teams/aldt/#eld
>
>
> >
> > Message: 1
> > Date: Thu, 28 Aug 2014 09:47:40 +0530
> > From: vinod mishra <[email protected]>
> > Subject: [Dspace-tech] Item delete problem
> > To: "[email protected]"
> > <[email protected]>, General List
> > <[email protected]>
> > Message-ID:
> > <CAGLUwiTvs+QdVdeSFuHcuaLinANJJc0qi3Dwn=EEE1hrEtmkuw@mail
> > .gmail.com>
> > Content-Type: text/plain; charset="utf-8"
> >
> > Dear All,
> >
> > When i attempt to delete item through JSPUI interface it gives internal
> system
> > error message but when i delete the same through xmlui interface it aslo
> > gives some error:
> >
> > "org.postgresql.util.PSQLException: ERROR: update or delete on table
> "item"
> > violates foreign key constraint "$2" on table "collection2item""
> > Detail: Key (item_id)=(429349) is still referenced from table
> > "collection2item""
> >
> > But ultimately it seems to be deleted, i have updated my dspace 1.2.1 to
> 4.2
> > by upgrading dabase schema as instructed for multiversion update option
> > available at:
> > https://wiki.duraspace.org/display/DSDOC4x/Multi-
> > Version+Upgrade+Tips+and+Tricks
> >
> > Kindly suggest for correcting the error.
> >
> >
> >
> > --
> > With Regards,
> > Vinod Kumar Mishra,
> > Assistant Librarian,
> > Biju Patnaik Central Library (BPCL),
> > NIT Rourkela.
> > Mob:91+9439420860
> > -------------- next part --------------
> > An HTML attachment was scrubbed...
> >
>
>
> --
> 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.
>
>
--
With Regards,
Vinod Kumar Mishra,
Assistant Librarian,
Biju Patnaik Central Library (BPCL),
NIT Rourkela.
Mob:91+9439420860
------------------------------------------------------------------------------
Slashdot TV.
Video for Nerds. Stuff that matters.
http://tv.slashdot.org/
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
