[Archivesspace_Users_Group] That ID is already in use problem and not being able to delete

Daniel L Thacker Daniel.Thacker at tamuk.edu
Fri Jun 22 12:01:48 EDT 2018


We imported a collection on Monday and it went through fine.  Then we had an error where we could not merge collections (it was an "db_error" {"Database integrity constraint conflict: Java: ComMysqlJdbcExceptionsJdbc4::MySQLTransactionRollbackException: Lock wait timeout exceeded: try restarting transaction"). We tired to back up the database straight from MySQL and took 30 minutes instead of the usual 10 seconds. Then we decided to roll back to a previous back-up, which worked.  The collection I put in on Monday was gone.  Since we went to the back-up I had to re-import the collection I put in on Monday.  The collection did not go through this time and got an "id_0 : That ID is already in use" error.  We cleared the indexes in the data folder and restored the backup again but the problem continues to exist.

I have attached the part of the error log that corresponds with our problem.


Daniel Thacker

Digital Archivist

James C. Jernigan Library

Texas A&M University-Kingsville

MSC 197

700 University Blvd

Kingsville, TX  78363-8202

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20180622/00e2195e/attachment.html>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: archivesspace errors.txt
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20180622/00e2195e/attachment.txt>

More information about the Archivesspace_Users_Group mailing list