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 J

 

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.white@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.gibson@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

 

On 24 August 2014 15:20, Michael White <michael.white@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.white@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.

------------------------------------------------------------------------------
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

 


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.