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
