When I try to delete a collection in the 1.6.2 XMLUI interface, I get a
referential integrity violation. Here's the stack trace:
Caused by: org.postgresql.util.PSQLException: ERROR: <unnamed>
referential integrity violation - key in collection still referenced from
community2collection
at
org.postgresql.core.v2.QueryExecutorImpl.receiveErrorMessage(QueryExecutorImpl.java:557)
at
org.postgresql.core.v2.QueryExecutorImpl.processResults(QueryExecutorImpl.java:480)
at
org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.java:364)
at
org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.java:258)
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:102)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460)
at
org.dspace.storage.rdbms.DatabaseManager.deleteByValue(DatabaseManager.java:605)
at
org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:572)
at
org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:807)
at org.dspace.content.Collection.delete(Collection.java:1137)
at
org.dspace.content.Community.removeCollection(Community.java:917)
at
org.dspace.app.xmlui.aspect.administrative.FlowContainerUtils.processDeleteCollection(FlowContainerUtils.java:668)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:155)
... 219 more
We ran the 1.5 to 1.6 schema update, and I see only the one
comm2coll_collection_fk foreign key constraint. We're still on postgres
7.3, but that supports deferred constraints.
Has anyone else run into this issue?
--Bill
****************************************************************
William Jordan
Associate Dean
University of Washington Libraries
Resource Acquisition and Description/
Information Technology Services
Box 352900, Seattle, WA 98195-2900
Voice: (206) 685-1625 Fax: (206) 543-5457
****************************************************************
------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
