After removing a bitstream, I checked to see if it really did get removed.  It did not.  But after
checking my Dspace log file, it seems that there is a Postgres error causing the "cleanup" job
to fail.  Here is the necessary error:

2005-06-28 12:44:15,270 INFO  org.dspace.storage.bitstore.Cleanup @ Cleaning up
asset store
2005-06-28 12:44:15,648 FATAL org.dspace.storage.bitstore.Cleanup @ Caught excep
tion:
org.postgresql.util.PSQLException: ERROR: update or delete on "bitstream" violat
es foreign key constraint "$2" on "bundle"

        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(AbstractJdbc1Stat
ement.java:517)
 at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:50)
        at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdb
c1Statement.java:273)
        at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdb
c1Statement.java:259)
        at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingS
tatement.java:225)
        at org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.
java:284)
        at org.dspace.storage.rdbms.DatabaseManager.deleteByValue(DatabaseManage
r.java:431)
        at org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:
400)
        at org.dspace.storage.bitstore.BitstreamStorageManager.cleanup(Bitstream
StorageManager.java:381)
        at org.dspace.storage.bitstore.Cleanup.main(Cleanup.java:67)

Any suggestions on fixes that need to be applied? 

TIA,


Jeffrey A. Trimble
Interim Head Collection Services
Systems Librarian
Youngstown State University
Youngstown, OH
jtrimble@cc.ysu.edu
(330) 941-2483