When delete a collection to load data again generates
The batch import you initiated from the DSpace UI was not completed, due to
the following reason:
org.postgresql.util.PSQLException: ERROR: update or delete on table "item"
violates foreign key constraint "coll2item_item_fk" on table
"collection2item"
Detail: Key (item_id)=(2) is still referenced from table
"collection2item".
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:441)
at
org.dspace.storage.rdbms.DatabaseManager.deleteByValue(DatabaseManager.java:612)
at
org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:571)
at
org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:796)
at org.dspace.content.Item.delete(Item.java:1308)
at
org.dspace.content.WorkspaceItem.deleteAll(WorkspaceItem.java:594)
at org.dspace.app.itemimport.ItemImport.addItem(ItemImport.java:918)
at
org.dspace.app.itemimport.ItemImport.addItems(ItemImport.java:736)
at org.dspace.app.itemimport.ItemImport$3.run(ItemImport.java:2253)
Configuration used is
DSpace 5.2
postgresql-9.3.6-2-linux-x64
apache-tomcat-7.0.50
apache-maven-3.0.5
apache-ant-1.9.3
All the solutions writed are about migrations from version 1.6 or 1.7.
Someone tell me about a solution in DSpace 5?
--
All messages to this mailing list should adhere to the DuraSpace Code of
Conduct: https://duraspace.org/about/policies/code-of-conduct/
---
You received this message because you are subscribed to the Google Groups
"DSpace Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/dspace-community.
For more options, visit https://groups.google.com/d/optout.
