<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">+1 on this… I am getting this index loop as well. I am also not able to view any details of my collections and I am not familiar enough with the program to know which is causing the other or if these issues
are independent of each other.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">jeremy<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org]
<b>On Behalf Of </b>Christine Di Bella<br>
<b>Sent:</b> Friday, September 22, 2017 11:16 AM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> [EXT] Re: [Archivesspace_Users_Group] 2.1.2 re-indexing loop<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hi Joshua,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I think your issue may be different than Ron’s. Ron’s appears to have been caused by orphaned instances and archival objects in the database. Earlier versions of ArchivesSpace ignored these during indexing, but 2.1 is more finicky about
that. See <a href="https://archivesspace.atlassian.net/browse/ANW-220">https://archivesspace.atlassian.net/browse/ANW-220</a> for some information about that issue. Ron can hopefully share more details about his resolution.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I do think your issue may also be specific to your data and local deployment, so it would be worth working through this on a support ticket. You’ll see another message about that directly to you in a minute. It would also be great if you’d
share the solution back to the list when you get there.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Christine<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1F497D">Christine Di Bella<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1F497D">ArchivesSpace Program Manager<o:p></o:p></span></p>
<p class="MsoNormal"><a href="mailto:christine.dibella@lyrasis.org"><span style="font-family:"Arial",sans-serif;color:#0563C1">christine.dibella@lyrasis.org</span></a><span style="font-family:"Arial",sans-serif;color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1F497D">800.999.8558 x2905<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1F497D">678-235-2905<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1F497D">cdibella13 (Skype)</span><span style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><img border="0" width="267" height="61" id="Picture_x0020_1" src="cid:image001.jpg@01D33395.FB88B320" alt="ASpaceOrgHomeMedium"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">
archivesspace_users_group-bounces@lyralists.lyrasis.org</a> [<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org</a>]
<b>On Behalf Of </b>Joshua D. Shaw<br>
<b>Sent:</b> Friday, September 22, 2017 11:36 AM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] 2.1.2 re-indexing loop<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div id="divtagdefaultwrapper">
<p><span style="color:black">To add another datapoint, when I change the publish status for all items in a node's immediate tree (ie file-> parent box -> parent series) then the child node and its parents will appear in the staff interface. If the AO or *any*
of its ancestors are *not* published, they do *not* appear in the staff interface.<o:p></o:p></span></p>
<p><span style="color:black"><o:p> </o:p></span></p>
<p><span style="color:black">I took a quick look at the database and the publish status for *most* of our AOs is "NULL", not the 1 or 0 that large_tree.rb is looking for in published_filter (line 73). I'm currently thinking that our initial custom migration
never set that column... <o:p></o:p></span></p>
<p><span style="color:black"><o:p> </o:p></span></p>
<p><span style="color:black">Joshua<o:p></o:p></span></p>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="3" width="98%" align="center">
</div>
<div id="divRplyFwdMsg">
<p class="MsoNormal"><b><span style="color:black">From:</span></b><span style="color:black">
</span><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a><span style="color:black"> <</span><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a><span style="color:black">>
on behalf of Joshua D. Shaw <</span><a href="mailto:Joshua.D.Shaw@dartmouth.edu">Joshua.D.Shaw@dartmouth.edu</a><span style="color:black">><br>
<b>Sent:</b> Thursday, September 21, 2017 4:54:04 PM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] 2.1.2 re-indexing loop</span> <o:p>
</o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" width="100%" style="width:100.0%;cellpadding:0;cellspacing:0;display:table;border-collapse:seperate;float:none" id="msexchangesafetytips;7a514d69-b80e-44b2-503e-08d50132e823;R:en-US">
<tbody>
<tr>
<td style="background:#910A19;padding:5.25pt 1.5pt 5.25pt 1.5pt;valign:middle"></td>
<td width="100%" style="width:100.0%;background:#FDF2F4;padding:5.25pt 3.75pt 5.25pt 11.25pt;word-wrap:break-word">
<div>
<p class="MsoNormal" style="mso-element:frame;mso-element-frame-hspace:2.25pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<span style="font-size:9.0pt;font-family:"Segoe UI",sans-serif;color:#212121">This sender failed our fraud detection checks and may not be who they appear to be. Learn about </span><a href="http://aka.ms/LearnAboutSpoofing"><span style="font-size:9.0pt;font-family:"Segoe UI",sans-serif">spoofing</span></a><span style="font-size:9.0pt;font-family:"Segoe UI",sans-serif;color:#212121"><o:p></o:p></span></p>
</div>
</td>
<td width="60" style="width:56.25pt;background:#FDF2F4;padding:5.25pt 3.75pt 5.25pt 3.75pt;word-wrap:break-word;align:left">
<p class="MsoNormal" style="mso-element:frame;mso-element-frame-hspace:2.25pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<a href="http://aka.ms/SafetyTipsFeedback"><span style="font-size:9.0pt;font-family:"Segoe UI",sans-serif">Feedback</span></a><span style="font-size:9.0pt;font-family:"Segoe UI",sans-serif;color:#212121"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<div>
<div id="divtagdefaultwrapper">
<div id="divtagdefaultwrapper">
<p><span style="color:black">I'd love to know the solution as well, since I'm seeing a similar/related(?) error as I'm starting to test 2.1.2 locally. I've migrated from a 1.5.3 instance and see the following error when attempting to view an archival object.
The archival object information renders in the record pane, but the tree fails to populate anything except the collection level. I checked the db and the id being referenced (14195) does exist in the archival_object table (I think that's what the id is referencing
- assuming I'm reading the code right). This is running with only one plugin (our omniauthCas) plugin enabled, though the database contains some additional tables from some of our other plugins<o:p></o:p></span></p>
<p><span style="color:black"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:12.0pt;color:black">key not found: :14195<br>
org/jruby/RubyHash.java:1189:in `fetch'<br>
/Applications/archivesspace-2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/large_tree.rb:203:in `block in node_from_root'<br>
org/jruby/RubyArray.java:1734:in `each'<br>
/Applications/archivesspace-2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/large_tree.rb:193:in `block in node_from_root'<br>
/Applications/archivesspace-2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:111:in `block in open'<br>
/Applications/archivesspace-2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:75:in `block in transaction'<br>
/Applications/archivesspace-2.1.2/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:105:in `block in transaction'<br>
/Applications/archivesspace-2.1.2/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:85:in `hold'<br>
/Applications/archivesspace-2.1.2/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255:in `synchronize'<br>
/Applications/archivesspace-2.1.2/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:97:in `transaction'<br>
/Applications/archivesspace-2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:74:in `transaction'<br>
/Applications/archivesspace-2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:110:in `block in open'<br>
org/jruby/RubyFixnum.java:305:in `times'<br>
/Applications/archivesspace-2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:107:in `open'<br>
/Applications/archivesspace-2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:432:in `block in DB'<br>
/Applications/archivesspace-2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/large_tree.rb:145:in `node_from_root'<br>
/Applications/archivesspace-2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/controllers/resource.rb:203:in `block in ArchivesSpaceService'<br>
org/jruby/RubyBasicObject.java:1687:in `instance_eval'<br>
/Applications/archivesspace-2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/rest.rb:280:in `block in returns'<br>
/Applications/archivesspace-2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:111:in `block in open'<br>
/Applications/archivesspace-2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:75:in `block in transaction'<br>
/Applications/archivesspace-2.1.2/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:134:in `_transaction'<br>
/Applications/archivesspace-2.1.2/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:108:in `block in transaction'<br>
/Applications/archivesspace-2.1.2/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:98:in `hold'<br>
/Applications/archivesspace-2.1.2/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255:in `synchronize'<br>
/Applications/archivesspace-2.1.2/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:97:in `transaction'<br>
/Applications/archivesspace-2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:74:in `transaction'<br>
/Applications/archivesspace-2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:110:in `block in open'<br>
org/jruby/RubyFixnum.java:305:in `times'<br>
/Applications/archivesspace-2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:107:in `open'<br>
/Applications/archivesspace-2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:432:in `block in DB'<br>
/Applications/archivesspace-2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/rest.rb:262:in `block in returns'<br>
/Applications/archivesspace-2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/request_context.rb:24:in `open'<br>
/Applications/archivesspace-2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/rest.rb:230:in `block in returns'<br>
org/jruby/RubyMethod.java:111:in `call'<br>
/Applications/archivesspace-2.1.2/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1611:in `block in compile!'<br>
/Applications/archivesspace-2.1.2/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:975:in `block in route!'<br>
/Applications/archivesspace-2.1.2/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:994:in `route_eval'<br>
/Applications/archivesspace-2.1.2/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:975:in `block in route!'<br>
/Applications/archivesspace-2.1.2/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1015:in `block in process_route'<br>
org/jruby/RubyKernel.java:1120:in `catch'<br>
/Applications/archivesspace-2.1.2/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1013:in `process_route'<br>
/Applications/archivesspace-2.1.2/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:973:in `block in route!'<br>
org/jruby/RubyArray.java:1734:in `each'<br>
/Applications/archivesspace-2.1.2/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:972:in `route!'<br>
/Applications/archivesspace-2.1.2/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1085:in `block in dispatch!'<br>
/Applications/archivesspace-2.1.2/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1067:in `block in invoke'<br>
org/jruby/RubyKernel.java:1120:in `catch'<br>
/Applications/archivesspace-2.1.2/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1067:in `invoke'<br>
/Applications/archivesspace-2.1.2/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1082:in `dispatch!'<br>
/Applications/archivesspace-2.1.2/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:907:in `block in call!'<br>
/Applications/archivesspace-2.1.2/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1067:in `block in invoke'<br>
org/jruby/RubyKernel.java:1120:in `catch'<br>
/Applications/archivesspace-2.1.2/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1067:in `invoke'<br>
/Applications/archivesspace-2.1.2/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:907:in `call!'<br>
/Applications/archivesspace-2.1.2/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:895:in `call'<br>
/Applications/archivesspace-2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:291:in `call'<br>
/Applications/archivesspace-2.1.2/gems/gems/rack-protection-1.5.3/lib/rack/protection/xss_header.rb:18:in `call'<br>
/Applications/archivesspace-2.1.2/gems/gems/rack-protection-1.5.3/lib/rack/protection/path_traversal.rb:16:in `call'<br>
/Applications/archivesspace-2.1.2/gems/gems/rack-protection-1.5.3/lib/rack/protection/json_csrf.rb:18:in `call'<br>
/Applications/archivesspace-2.1.2/gems/gems/rack-protection-1.5.3/lib/rack/protection/base.rb:49:in `call'<br>
/Applications/archivesspace-2.1.2/gems/gems/rack-protection-1.5.3/lib/rack/protection/base.rb:49:in `call'<br>
/Applications/archivesspace-2.1.2/gems/gems/rack-protection-1.5.3/lib/rack/protection/frame_options.rb:31:in `call'<br>
uri:classloader:/vendor/rack-1.5.5/rack/nulllogger.rb:9:in `call'<br>
uri:classloader:/vendor/rack-1.5.5/rack/head.rb:11:in `call'<br>
/Applications/archivesspace-2.1.2/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:182:in `call'<br>
/Applications/archivesspace-2.1.2/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:2013:in `call'<br>
/Applications/archivesspace-2.1.2/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1487:in `block in call'<br>
/Applications/archivesspace-2.1.2/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1787:in `synchronize'<br>
/Applications/archivesspace-2.1.2/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1487:in `call'<br>
uri:classloader:/vendor/rack-1.5.5/rack/builder.rb:138:in `call'<br>
uri:classloader:/vendor/rack-1.5.5/rack/urlmap.rb:65:in `block in call'<br>
org/jruby/RubyArray.java:1734:in `each'<br>
uri:classloader:/vendor/rack-1.5.5/rack/urlmap.rb:50:in `call'<br>
uri:classloader:/rack/handler/servlet.rb:22:in `call'<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p><span style="color:black"><o:p> </o:p></span></p>
<p><span style="color:black"><o:p> </o:p></span></p>
</div>
<div class="MsoNormal" align="center" style="text-align:center"><span style="font-size:12.0pt;color:black">
<hr size="3" width="98%" align="center">
</span></div>
<div id="divRplyFwdMsg">
<p class="MsoNormal"><b><span style="color:black">From:</span></b><span style="color:black">
</span><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a><span style="color:black"> <</span><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a><span style="color:black">>
on behalf of Stanonik, Ronald <</span><a href="mailto:rstanonik@ucsd.edu">rstanonik@ucsd.edu</a><span style="color:black">><br>
<b>Sent:</b> Friday, September 15, 2017 1:44:44 PM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] 2.1.2 re-indexing loop</span><span style="font-size:12.0pt;color:black">
<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"> <o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p><span style="color:#1F497D">I notice a repeating error and stacktrace in the log about an unhandled exception.</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">E, [2017-09-15T09:45:13.168412 #10788] ERROR -- : Thread-5342: Unhandled exception!</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">E, [2017-09-15T09:45:13.168722 #10788] ERROR -- :</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">key not found: :</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">org/jruby/RubyHash.java:1189:in `fetch'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace-v2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/ancestor_listing.rb:63:in `root_record'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace-v2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/ancestor_listing.rb:22:in `block in add_ancestors'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">org/jruby/RubyArray.java:1734:in `each'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace-v2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/ancestor_listing.rb:12:in `add_ancestors'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace-v2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/archival_object.rb:69:in `sequel_to_jsonmodel'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace-v2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/crud_helpers.rb:105:in `listing_response'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace-v2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/crud_helpers.rb:68:in `handle_listing'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace-v2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/controllers/archival_object.rb:95:in `block in ArchivesSpaceService'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">org/jruby/RubyBasicObject.java:1687:in `instance_eval'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace-v2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/rest.rb:280:in `block in returns'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace-v2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:111:in `block in open'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace-v2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:75:in `block in transaction'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:134:in `_transaction'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:108:in `block in transaction'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:98:in `hold'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255:in `synchronize'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:97:in `transaction'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace-v2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:74:in `transaction'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace-v2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:110:in `block in open'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">org/jruby/RubyFixnum.java:305:in `times'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace-v2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:107:in `open'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace-v2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:432:in `block in DB'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace-v2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/rest.rb:262:in `block in returns'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace-v2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/request_context.rb:24:in `open'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace-v2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/rest.rb:230:in `block in returns'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">org/jruby/RubyMethod.java:111:in `call'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1611:in `block in compile!'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:975:in `block in route!'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:994:in `route_eval'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:975:in `block in route!'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1015:in `block in process_route'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">org/jruby/RubyKernel.java:1120:in `catch'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1013:in `process_route'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:973:in `block in route!'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">org/jruby/RubyArray.java:1734:in `each'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:972:in `route!'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1085:in `block in dispatch!'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1067:in `block in invoke'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">org/jruby/RubyKernel.java:1120:in `catch'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1067:in `invoke'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1082:in `dispatch!'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:907:in `block in call!'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1067:in `block in invoke'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">org/jruby/RubyKernel.java:1120:in `catch'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1067:in `invoke'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:907:in `call!'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:895:in `call'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace-v2.1.2/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:291:in `call'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/rack-protection-1.5.3/lib/rack/protection/xss_header.rb:18:in `call'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/rack-protection-1.5.3/lib/rack/protection/path_traversal.rb:16:in `call'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/rack-protection-1.5.3/lib/rack/protection/json_csrf.rb:18:in `call'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/rack-protection-1.5.3/lib/rack/protection/base.rb:49:in `call'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/rack-protection-1.5.3/lib/rack/protection/base.rb:49:in `call'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/rack-protection-1.5.3/lib/rack/protection/frame_options.rb:31:in `call'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">uri:classloader:/vendor/rack-1.5.5/rack/nulllogger.rb:9:in `call'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">uri:classloader:/vendor/rack-1.5.5/rack/head.rb:11:in `call'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:182:in `call'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:2013:in `call'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1487:in `block in call'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1787:in `synchronize'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1487:in `call'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">uri:classloader:/vendor/rack-1.5.5/rack/builder.rb:138:in `call'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">uri:classloader:/vendor/rack-1.5.5/rack/urlmap.rb:65:in `block in call'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">org/jruby/RubyArray.java:1734:in `each'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">uri:classloader:/vendor/rack-1.5.5/rack/urlmap.rb:50:in `call'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">uri:classloader:/rack/handler/servlet.rb:22:in `call'</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D">D, [2017-09-15T09:45:13.169154 #10788] DEBUG -- : Thread-5342: Responded with [500, {"Content-Type"=>"application/json", "Cache-Control"=>"private, must-revalidate, max-age=0", "Content-Length"=>"29"}, ["{\"error\":\"key not found:
:\"}\n"]]... in 247ms</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p><b><span style="color:black">From:</span></b><span style="color:black"> </span>
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a><span style="color:black"> [</span><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org</a><span style="color:black">]
<b>On Behalf Of </b>Stanonik, Ronald<br>
<b>Sent:</b> Friday, September 15, 2017 9:48 AM<br>
<b>To:</b> </span><a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a><span style="color:black"><br>
<b>Subject:</b> [Archivesspace_Users_Group] 2.1.2 re-indexing loop<o:p></o:p></span></p>
</div>
</div>
<p><span style="color:black"> <o:p></o:p></span></p>
<p><span style="color:black">I recently upgraded to 2.1.2 and it seems to be in an indexing loop.<br>
<br>
I restarted the application.<br>
<br>
I removed the solr index and restarted the application.<br>
<br>
In the log I see it counting up<br>
<br>
Staff Indexer [2017-09-15 07:42:21 -0700] ~~~ Indexed 185825 of 212959 archival_object records in repository SC&A<br>
...<br>
Staff Indexer [2017-09-15 03:50:30 -0700] ~~~ Indexed 201525 of 212959 archival_object records in repository SC&A<br>
<br>
But then<br>
<br>
Staff Indexer [2017-09-15 04:09:49 -0700] ~~~ Indexed 25 of 212959 archival_object records in repository SC&A<br>
<br>
Since yesterday it has re-indexed ten times.<br>
<br>
The resulting constant re-indexing causes a high load average and slow performance for users.<br>
<br>
Any suggestions?<br>
<br>
Thanks,<br>
<br>
Ron<o:p></o:p></span></p>
<p><span style="color:black"> <o:p></o:p></span></p>
<p><span style="color:black">ps. I also posted this question to </span><a href="https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fforum%2F%23!forum%2Farchivesspace&data=02%7C01%7Cjoshua.d.shaw%40dartmouth.edu%7C028f6cddc8a54f13039908d4fc61778d%7C995b093648d640e5a31ebf689ec9446f%7C0%7C0%7C636410942941690532&sdata=WypeTQ4t6O31ExmAoPwc34i%2B6%2BrkDCVV%2Fg6nYbnizPI%3D&reserved=0"><span style="color:#0563C1">https://groups.google.com/forum/#!forum/archivesspace</span></a><span style="color:black">.
Sorry if that is redundant.<o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</body>
</html>