<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;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p><br>
</p>
<p>Ah cool. <br>
</p>
<p><br>
</p>
<p>You can also just touch the timestamp column on the deleted_records table and rebuild the index...
<br>
</p>
<p><br>
</p>
<p>update deleted_records set timestamp = NOW();<br>
<br>
</p>
<p><br>
</p>
<p>b,chris. <br>
</p>
<p><br>
</p>
<div id="Signature">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:; margin:0">
<div class="BodyFragment"><font size="2">
<div class="PlainText">Chris Fitzpatrick | <font size="2">Developer, ArchivesSpace</font><br>
Skype: chrisfitzpat  | Phone: 918.236.6048<br>
http://archivesspace.org/<br>
</div>
</font></div>
</div>
</div>
<br>
<br>
<div style="color: rgb(0, 0, 0);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Brian Hoffman
 <brianjhoffman@gmail.com><br>
<b>Sent:</b> Wednesday, December 2, 2015 7:08 PM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] duplicate records?</font>
<div> </div>
</div>
<div>This is a common occurrence when developing or testing, especially if you switch between databases. It annoys me frequently enough that I wrote a utility to prune the index. I only recommend this for users with command line skills, and don’t recommend
 using it on a production solr index:
<div class=""><br class="">
</div>
<div class="">npm install ashtin -g</div>
<div class="">ashtin setup</div>
<div class="">ashtin prune-index --solr_url <a id="LPlnk625372" href="http://localhost:8090" class="">
http://localhost:8090</a></div>
<div class=""><br class="">
</div>
<div class="">That should remove all non-existent resource records from the index.</div>
<div class=""><br class="">
</div>
<div class="">Brian</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
<div>
<blockquote type="cite" class="">
<div class="">On Dec 2, 2015, at 10:28 AM, Matthew J Gorzalski <<a href="mailto:mGorzalski@lib.siu.edu" class="">mGorzalski@lib.siu.edu</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div class="WordSection1" style="font-family:Helvetica; font-size:12px; font-style:normal; font-variant:normal; font-weight:normal; letter-spacing:normal; line-height:normal; orphans:auto; text-align:start; text-indent:0px; text-transform:none; white-space:normal; widows:auto; word-spacing:0px">
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:10pt; font-family:Georgia,serif">We’ll give it a try later today.  Thanks Chris.</span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:10pt; font-family:Georgia,serif"> </span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:10pt; font-family:Georgia,serif">Matt</span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<span class="" style="font-size:10pt; font-family:Georgia,serif"> </span></div>
<div class="">
<div class="" style="border-style:solid none none; border-top-color:rgb(225,225,225); border-top-width:1pt; padding:3pt 0in 0in">
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
<b class=""><span class="" style="font-size:11pt; font-family:Calibri,sans-serif">From:</span></b><span class="" style="font-size:11pt; font-family:Calibri,sans-serif"><span class="Apple-converted-space"> </span><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="" style="color:rgb(149,79,114); text-decoration:underline">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>[<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="" style="color:rgb(149,79,114); text-decoration:underline">mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org</a>]<span class="Apple-converted-space"> </span><b class="">On
 Behalf Of<span class="Apple-converted-space"> </span></b>Chris Fitzpatrick<br class="">
<b class="">Sent:</b><span class="Apple-converted-space"> </span>Wednesday, December 02, 2015 2:58 AM<br class="">
<b class="">To:</b><span class="Apple-converted-space"> </span>Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" class="" style="color:rgb(149,79,114); text-decoration:underline">archivesspace_users_group@lyralists.lyrasis.org</a>><br class="">
<b class="">Subject:</b><span class="Apple-converted-space"> </span>Re: [Archivesspace_Users_Group] duplicate records?</span></div>
</div>
</div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif">
 </div>
<div id="divtagdefaultwrapper" class="">
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">Hi Matt,</span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">You probably need to rebuild your index from scratch. Delete your index and your indexer_state files.</span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif">best, Chris.</span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></div>
<div id="Signature" class="">
<div name="divtagdefaultwrapper" class="">
<div class="">
<div class="">
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:10pt; font-family:Calibri,sans-serif">Chris Fitzpatrick | Developer, ArchivesSpace<br class="">
Skype: chrisfitzpat  | Phone: 918.236.6048<br class="">
</span><a href="http://archivesspace.org/" class="" style="color:rgb(149,79,114); text-decoration:underline"><span class="" style="font-size:10pt; font-family:Calibri,sans-serif">http://archivesspace.org/</span></a><span class="" style="font-size:10pt; font-family:Calibri,sans-serif"></span></div>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin:0in 0in 12pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></p>
<div class="">
<div class="MsoNormal" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; text-align:center; background-color:white" align="center">
<span class="" style="font-family:Calibri,sans-serif">
<hr class="" align="center" size="2" width="98%">
</span></div>
<div id="divRplyFwdMsg" class="">
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<b class=""><span class="" style="font-size:11pt; font-family:Calibri,sans-serif">From:</span></b><span class="" style="font-size:11pt; font-family:Calibri,sans-serif"> </span><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="" style="color:rgb(149,79,114); text-decoration:underline"><span class="" style="font-size:11pt; font-family:Calibri,sans-serif">archivesspace_users_group-bounces@lyralists.lyrasis.org</span></a><span class="" style="font-size:11pt; font-family:Calibri,sans-serif"><</span><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="" style="color:rgb(149,79,114); text-decoration:underline"><span class="" style="font-size:11pt; font-family:Calibri,sans-serif">archivesspace_users_group-bounces@lyralists.lyrasis.org</span></a><span class="" style="font-size:11pt; font-family:Calibri,sans-serif">>
 on behalf of Matthew J Gorzalski <</span><a href="mailto:mGorzalski@lib.siu.edu" class="" style="color:rgb(149,79,114); text-decoration:underline"><span class="" style="font-size:11pt; font-family:Calibri,sans-serif">mGorzalski@lib.siu.edu</span></a><span class="" style="font-size:11pt; font-family:Calibri,sans-serif">><br class="">
<b class="">Sent:</b><span class="Apple-converted-space"> </span>Tuesday, December 1, 2015 10:45 PM<br class="">
<b class="">To:</b><span class="Apple-converted-space"> </span>Archivesspace Users Group<br class="">
<b class="">Subject:</b><span class="Apple-converted-space"> </span>[Archivesspace_Users_Group] duplicate records?</span><span class="" style="font-family:Calibri,sans-serif"></span></div>
<div class="">
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-family:Calibri,sans-serif"> </span></div>
</div>
</div>
<div class="">
<div class="">
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:10pt; font-family:Georgia,serif">Although the migration tool is improved, we’re still getting duplicate records where one is correct and one is erroneous and “not found.”  Do people still get duplicate records?</span><span class="" style="font-size:11pt; font-family:Calibri,sans-serif"></span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:10pt; font-family:Georgia,serif"> </span><span class="" style="font-size:11pt; font-family:Calibri,sans-serif"></span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:10pt; font-family:Georgia,serif">When I try to delete the duplicate Delyte Morris Photo collection I get</span><span class="" style="font-size:11pt; font-family:Calibri,sans-serif"></span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif"> </span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif">Unable to delete records:<br class="">
["{\"error\":\"Resource not found\"}\n"] [/repositories/4/resources/2190]</span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif"> </span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif">Thanks,</span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:10pt; font-family:Georgia,serif"> </span><span class="" style="font-size:11pt; font-family:Calibri,sans-serif"></span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:9pt; font-family:'Trebuchet MS',sans-serif">MATT GORZALSKI</span><span class="" style="font-size:11pt; font-family:Calibri,sans-serif"></span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:9pt; font-family:'Trebuchet MS',sans-serif">University Archivist</span><span class="" style="font-size:11pt; font-family:Calibri,sans-serif"></span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:9pt; font-family:'Trebuchet MS',sans-serif"> </span><span class="" style="font-size:11pt; font-family:Calibri,sans-serif"></span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:9pt; font-family:'Trebuchet MS',sans-serif; color:rgb(102,0,0)">MORRIS LIBRARY</span><span class="" style="font-size:11pt; font-family:Calibri,sans-serif"></span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:9pt; font-family:'Trebuchet MS',sans-serif; color:rgb(102,0,0)">MAIL CODE 6632</span><span class="" style="font-size:11pt; font-family:Calibri,sans-serif"></span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:9pt; font-family:'Trebuchet MS',sans-serif; color:rgb(102,0,0)">SOUTHERN ILLINOIS UNIVERSITY</span><span class="" style="font-size:11pt; font-family:Calibri,sans-serif"></span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:9pt; font-family:'Trebuchet MS',sans-serif; color:rgb(102,0,0)">605 AGRICULTURE DR</span><span class="" style="font-size:11pt; font-family:Calibri,sans-serif"></span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:9pt; font-family:'Trebuchet MS',sans-serif; color:rgb(102,0,0)">CARBONDALE, IL 62901</span><span class="" style="font-size:11pt; font-family:Calibri,sans-serif"></span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:9pt; font-family:'Trebuchet MS',sans-serif; color:rgb(102,0,0)"> </span><span class="" style="font-size:11pt; font-family:Calibri,sans-serif"></span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<a href="mailto:mgorzalski@lib.siu.edu" class="" style="color:rgb(149,79,114); text-decoration:underline"><span class="" style="font-size:9pt; font-family:'Trebuchet MS',sans-serif">mgorzalski@lib.siu.edu</span></a><span class="" style="font-size:11pt; font-family:Calibri,sans-serif"></span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:9pt; font-family:'Trebuchet MS',sans-serif">P: 618/453-2225</span><span class="" style="font-size:11pt; font-family:Calibri,sans-serif"></span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:9pt; font-family:'Trebuchet MS',sans-serif">F: 618/453-3440</span><span class="" style="font-size:11pt; font-family:Calibri,sans-serif"></span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:9pt; font-family:'Trebuchet MS',sans-serif; color:rgb(102,0,0)"><a href="http://lib.siu.edu" class="">lib.siu.edu</a></span><span class="" style="font-size:11pt; font-family:Calibri,sans-serif"></span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:'Times New Roman',serif; background-color:white">
<span class="" style="font-size:11pt; font-family:Calibri,sans-serif"> </span></div>
</div>
</div>
</div>
</div>
</div>
<span class="" style="font-family:Helvetica; font-size:12px; font-style:normal; font-variant:normal; font-weight:normal; letter-spacing:normal; line-height:normal; orphans:auto; text-align:start; text-indent:0px; text-transform:none; white-space:normal; widows:auto; word-spacing:0px; float:none; display:inline!important">_______________________________________________</span><br class="" style="font-family:Helvetica; font-size:12px; font-style:normal; font-variant:normal; font-weight:normal; letter-spacing:normal; line-height:normal; orphans:auto; text-align:start; text-indent:0px; text-transform:none; white-space:normal; widows:auto; word-spacing:0px">
<span class="" style="font-family:Helvetica; font-size:12px; font-style:normal; font-variant:normal; font-weight:normal; letter-spacing:normal; line-height:normal; orphans:auto; text-align:start; text-indent:0px; text-transform:none; white-space:normal; widows:auto; word-spacing:0px; float:none; display:inline!important">Archivesspace_Users_Group
 mailing list</span><br class="" style="font-family:Helvetica; font-size:12px; font-style:normal; font-variant:normal; font-weight:normal; letter-spacing:normal; line-height:normal; orphans:auto; text-align:start; text-indent:0px; text-transform:none; white-space:normal; widows:auto; word-spacing:0px">
<span class="" style="font-family:Helvetica; font-size:12px; font-style:normal; font-variant:normal; font-weight:normal; letter-spacing:normal; line-height:normal; orphans:auto; text-align:start; text-indent:0px; text-transform:none; white-space:normal; widows:auto; word-spacing:0px; float:none; display:inline!important"><a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" class="">Archivesspace_Users_Group@lyralists.lyrasis.org</a></span><br class="" style="font-family:Helvetica; font-size:12px; font-style:normal; font-variant:normal; font-weight:normal; letter-spacing:normal; line-height:normal; orphans:auto; text-align:start; text-indent:0px; text-transform:none; white-space:normal; widows:auto; word-spacing:0px">
<span class="" style="font-family:Helvetica; font-size:12px; font-style:normal; font-variant:normal; font-weight:normal; letter-spacing:normal; line-height:normal; orphans:auto; text-align:start; text-indent:0px; text-transform:none; white-space:normal; widows:auto; word-spacing:0px; float:none; display:inline!important"><a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" class="">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a></span></div>
</blockquote>
</div>
<br class="">
</div>
</div>
</div>
</div>
</body>
</html>