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

Christine Di Bella christine.dibella at lyrasis.org
Fri Jun 22 14:48:08 EDT 2018

Hi Daniel,

I'm going to put a support ticket in for you on this. (You'll see another message about that directly to you in a minute.) It'd be great if you posted the answer back to the list when it's resolved.


Christine Di Bella
ArchivesSpace Program Manager
christine.dibella at lyrasis.org<mailto:christine.dibella at lyrasis.org>
800.999.8558 x2905
cdibella13 (Skype)


From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> On Behalf Of Daniel L Thacker
Sent: Friday, June 22, 2018 12:02 PM
To: archivesspace_users_group at lyralists.lyrasis.org
Subject: [Archivesspace_Users_Group] That ID is already in use problem and not being able to delete


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/2f1d7bfa/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 6608 bytes
Desc: image003.jpg
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20180622/2f1d7bfa/attachment.jpg>

More information about the Archivesspace_Users_Group mailing list