[Dspace-general] [Dspace-tech] Cannot delete collections from Dspace

[Claudia Jürgen]

Hi Filippos,


are you sure you're running 1.4.2?
The table "dcvalue" does not exist anymore in 1.4.2. It has been 
replaced in 1.4.

In 1.3.2 there has been a known bug
http://sourceforge.net/tracker/index.php?func=detail&aid=1333269&group_id=19984&atid=119984
on the deletion of collections/communities containing withdrawn items.

cheers

Claudia


Filippos Kolovos schrieb:
> Dear all,
> 
> Recently I am dealing with a problem with my Dspace installation (1.4.2).
> When I try to delete a collection and/or community from Dspace
> the system returns an "Internal Server Error". The explanation
> of this error is shown below:
> 
> Exception:
> org.postgresql.util.PSQLException: ERROR: update or delete on "item" violates foreign key constraint "$1" on "dcvalue"
> 
> at org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
> at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
> at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
> at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:273)
> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
> at org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:519)
> etc, etc
> ..........
> .........
> 
> The exact reason for this error seems to be that the collection id is referenced from another table, but isn't that what the
> system is supposed to do when deleting a community/collection? Shouldn't all the relations be deleted and/or get handled by
> the Dspace system?
> 
> If I go manually into the Postgres and delete all the "relations" of one collection by hand then the items related to that collection remain
> in the tables. I then have to do the "manual deletion" process by hand for each item, something which is not very efficient when dealing 
> with thousands of records (items).
> 
> Does anyone have had this problem before?
> 
> Kind Regards,
> 
> -Fk
> 
> 
> 
> ------------------------------------------------------------------------
> 
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> DSpace-tech mailing list
> DSpace-tech at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech