<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;" dir="ltr">
<p style="margin-top:0;margin-bottom:0">Hello,</p>
<p style="margin-top:0;margin-bottom:0"><br>
</p>
<p style="margin-top:0;margin-bottom:0">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. </p>
<p style="margin-top:0;margin-bottom:0"><br>
</p>
<p style="margin-top:0;margin-bottom:0">I have attached the part of the error log that corresponds with our problem.</p>
<p style="margin-top:0;margin-bottom:0"><br>
</p>
<p style="margin-top:0;margin-bottom:0">Thanks,</p>
<p style="margin-top:0;margin-bottom:0"><br>
</p>
<div id="Signature">
<div id="divtagdefaultwrapper" style="font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: Calibri, Arial, Helvetica, sans-serif, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols;">
<p>Daniel Thacker</p>
<p>Digital Archivist </p>
<p>James C. Jernigan Library</p>
<p>Texas A&M University-Kingsville</p>
<p>MSC 197 </p>
<p>700 University Blvd</p>
<p>Kingsville, TX 78363-8202</p>
<p>361-593-4154</p>
</div>
</div>
</div>
</body>
</html>