Hi Michael
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
Cheers
hg
*Hilton Gibson*
Ubuntu Linux Systems Administrator
JS Gericke Library
Room 1025D
Stellenbosch University
Private Bag X5036
Stellenbosch
7599
South Africa
Tel: +27 21 808 4100 | Cell: +27 84 646 4758
http://scholar.sun.ac.za
http://bit.ly/goodir
http://library.sun.ac.za
http://za.linkedin.com/in/hiltongibson
On 24 August 2014 15:20, Michael White <[email protected]> wrote:
> Hi,
>
> I am not able to delete items in my (upgraded) DSpace v4.1 system using
> JSPUI and SOLR Discovery/Browse/Search.
>
> This was an upgrade via data migration from our existing PROD DSpace v1.6
> system onto a new server running DSpace v4.1. The migration was carried out
> by “pg_dump”ing the data on v1.6 and restoring it to a new v4.1 instance,
> and then running the various upgrade scripts to upgrade the database from
> v1.6 to v4.1. Finally I re-indexed with “/usr/local/dspace/bin/dspace
> index-discovery –b” and updated the existing embargoes
> “/usr/local/dspace/bin/dspace migrate-embargo –a”.
>
> Everything appeared to be fine, but I have recently discovered that when
> attempting to delete an item I get the following postgres error:
>
> ERROR: update or delete on table "item" violates foreign key constraint
> "$2" on table "communities2item"
>
> My investigations have led me to believe that this table is related to the
> old Lucene indices – is this assumption correct? Anyone know if it is used
> by anything else?
>
> I have experimented with “cleaning out” the old lucene indexes using the
> following to rebuild the empty tables:
>
> /usr/local/dspace/bin/dspace index-lucene-init -r -t -v
>
> - this does throw one error:
>
> Elapsed time: 37 secs (37295 msecs)
> Exception: Caching is not supported by the ItemCountDAOSolr as it is not
> really needed, Solr is faster!
> org.dspace.browse.ItemCountException: Caching is not supported by the
> ItemCountDAOSolr as it is not really needed, Solr is faster!
>
> - but once I have run it, I am then able to delete items from DSpace
> without errors ☺
>
> Has anyone else come across this (or similar)? Are my assumptions correct?
> And is rebuilding empty Lucene indexes a safe way to work around this? If
> not, has anyone get any other suggestions?
>
> I have, unfortunately, already gone live with v4.1 before picking up on
> this issue, so I am obviously very keen to find a fix asap and I’m hoping
> this is it?
>
> Any thoughts, observations, pointers or hints would be very welcome!
>
> Cheers,
>
> 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
>
>
>
> --
> 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.
>
>
> ------------------------------------------------------------------------------
> 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
------------------------------------------------------------------------------
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
