[Dspace-devel] [DuraSpace JIRA] (DS-1920) Deleting an item fails because of old browse tables

Hilton Gibson (DuraSpace JIRA) Mon, 12 May 2014 03:38:33 -0700

Title: Message Title

Hilton Gibson commented on an issue

After upgrading from 1.5 to 4.1, we get the following error when trying to delete a collection:
>>>>
An internal server error occurred on http://etd.sun.ac.za:

Date: 2014/05/12 11:47 AM
Session ID: A80E568F6DE4A84C1B26CEF2357724FC
User: Ina Smith (ism...@sun.ac.za)
IP address: 146.232.124.115

-- URL Was: http://etd.sun.ac.za/tools/edit-communities
-- Method: POST
-- Parameters were:
-- submit: "Delete"
-- community_id: "29"
-- collection_id: "4698"
-- action: "10"

Exception:
org.postgresql.util.PSQLException: ERROR: update or delete on table "item" violates foreign key constraint "bi_2_dmap_item_id_fkey" on table "bi_2_dmap"
  Detail: Key (item_id)=(9103) is still referenced from table "bi_2_dmap".
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:417)
        at org.dspace.storage.rdbms.DatabaseManager.deleteByValue(DatabaseManager.java:568)
        at org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:532)
        at org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:756)
        at org.dspace.content.Item.delete(Item.java:2051)
        at org.dspace.content.Collection.removeItem(Collection.java:1029)
        at org.dspace.content.Collection.delete(Collection.java:1167)
        at org.dspace.content.Community.removeCollection(Community.java:1017)
        at org.dspace.app.webui.servlet.admin.EditCommunitiesServlet.doDSPost(EditCommunitiesServlet.java:251)
        at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:115)
        at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:73)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:66)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:78)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at com.googlecode.psiprobe.Tomcat60AgentValve.invoke(Tomcat60AgentValve.java:30)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:701)
>>>>

Is there a fix or documentation update for this yet??

Add Comment

DSpace /

DS-1920

When trying to delete an item, DSpace fails giving the following error:

org.postgresql.util.PSQLException: ERROR: update or delete on table "item" violates foreign key constraint "bi_2_dmap_item_id_fkey" on table "bi_2_dmap"
Detail: Key (item_id)=(66721) is still referenced from table "bi_2_dmap".

org.postgresql.util.PSQLException: ERROR: update or...

This message was sent by Atlassian JIRA

------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs

_______________________________________________
Dspace-devel mailing list
Dspace-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-devel

[Dspace-devel] [DuraSpace JIRA] (DS-1920) Deleting an item fails because of old browse tables

Reply via email to