update or delete on table "collection" violates foreign key constraint "$2"
on table "community2collection" Detail: Key (collection_id)=(7) is still
referenced from table "community2collection
Dear Sir,
I have migrated the the entry from collection to other collection now i am
trying to remove the collection.It is showing internal system error.
Please let us know how to solve this problem. Error log is attached below.
With regards
Indu Bhushan
RRCAT, Indore MP
-------------------------------------------------------------------------------------------------------------------------------
2011-03-14 15:31:21,854 INFO org.dspace.content.Bitstream @
i...@cat.ernet.in:
session_id=2BA90EB05194A55AE8EE1071AE4B2C17:ip_addr=10.130.2.201:
delete_bitstream:bitstream_id=195
2011-03-14 15:31:21,854 INFO org.dspace.content.Collection @
i...@cat.ernet.in:
session_id=2BA90EB05194A55AE8EE1071AE4B2C17:ip_addr=10.130.2.201:
remove_logo:collection_id=7
2011-03-14 15:31:21,856 WARN org.dspace.app.webui.servlet.DSpaceServlet @ *
i...@cat.ernet.in:
session_id=2BA90EB05194A55AE8EE1071AE4B2C17:ip_addr=10.130.2.201:database_error:org.postgresql.util.PSQLException\colon;
ERROR\colon; update or delete on table "collection" violates foreign key
constraint "$2" on table "community2collection"*
* Detail\colon; Key (collection_id)=(7) is still referenced from table
"community2collection".org.postgresql.util.PSQLException: ERROR: update or
delete on table "collection" violates foreign key constraint "$2" on table
"community2collection" Detail: Key (collection_id)=(7) is still referenced
from table "community2collection".*
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
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:421)
at
org.dspace.storage.rdbms.DatabaseManager.deleteByValue(DatabaseManager.java:572)
at
org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:536)
at
org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:760)
at org.dspace.content.Collection.delete(Collection.java:1162)
at org.dspace.content.Community.removeCollection(Community.java:969)
at
org.dspace.app.webui.servlet.admin.EditCommunitiesServlet.doDSPost(EditCommunitiesServlet.java:250)
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)
------------------------------------------------------------------------------
Colocation vs. Managed Hosting
A question and answer guide to determining the best fit
for your organization - today and in the future.
http://p.sf.net/sfu/internap-sfd2d
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
