Thanks Hilton,
> http://wiki.lib.sun.ac.za/index.php/SUNScholar/Browse_Indexes/3.2#WARNING
That definitely looks like the issue that I’ve come across – thanks for the
pointer ☺
I guess next I’ll check if rebuilding the lucene index with empty tables as I
did has just “emptied out” the same tables that are indicated for deletion on
that page - (i.e. that the same tables have been operated on) . . . . (?)
If rebuilding an empty index (as I’ve done) appears to be equivalent to
manually dropping those tables (as suggested on the above page), does anyone
have any thoughts on which might be better (i.e. kill the tables completely or
just empty them)?
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<mailto: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
From: Hilton Gibson [mailto:hilton.gib...@gmail.com]
Sent: 24 August 2014 17:03
To: Michael White
Cc: dspace-tech@lists.sourceforge.net
Subject: Re: [Dspace-tech] DSpace 4.1 upgrade - can't delete
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
<michael.wh...@stir.ac.uk<mailto:michael.wh...@stir.ac.uk>> 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: michael.wh...@stir.ac.uk<mailto:michael.wh...@stir.ac.uk>
Tel: +44 (0) 1786 466877<tel:%2B44%20%280%29%201786%20466877>
Fax: +44 (0) 1786 466880<tel:%2B44%20%280%29%201786%20466880>
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
DSpace-tech@lists.sourceforge.net<mailto:DSpace-tech@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/dspace-tech
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.
------------------------------------------------------------------------------
Slashdot TV.
Video for Nerds. Stuff that matters.
http://tv.slashdot.org/
_______________________________________________
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