<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">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;" dir="ltr">
<p>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.</p>
<p><br>
</p>
<p>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... </p>
<p><br>
</p>
<p>Joshua<br>
</p>
</div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Joshua D. Shaw
<Joshua.D.Shaw@dartmouth.edu><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</font>
<div> </div>
</div>
<div>
<table id="msexchangesafetytips;7a514d69-b80e-44b2-503e-08d50132e823;R:en-US" border="0" cellspacing="0" cellpadding="0" width="100%" style="cellpadding:0;border:0;cellspacing:0;display:table;width:100%;table-layout:fixed;border-collapse:seperate;float:none;" align="left">
<tbody>
<tr>
<td valign="middle" width="1px" bgcolor="#910A19" cellpadding="7px 2px 7px 2px" style="padding:7px 2px 7px 2px;background-color:#910A19;valign:middle">
</td>
<td valign="middle" width="100%" bgcolor="#FDF2F4" cellpadding="7px 5px 7px 15px" color="#212121" style="width:100%;background-color:#FDF2F4;padding:7px 5px 7px 15px;font-family:wf_segoe-ui_normal,Segoe UI,Segoe WP,Tahoma,Arial, sans-serif;font-size:12px;font-weight:normal;color:#212121;text-align:left;word-wrap:break-word;">
<div>This sender failed our fraud detection checks and may not be who they appear to be. Learn about <a href="http://aka.ms/LearnAboutSpoofing">spoofing</a></div>
</td>
<td valign="middle" align="left" width="75px" bgcolor="#FDF2F4" cellpadding="7px 5px 7px 5px" color="#212121" style="width:75px;background-color:#FDF2F4;padding:7px 5px 7px 5px;font-family:wf_segoe-ui_normal,Segoe UI,Segoe WP,Tahoma,Arial, sans-serif;font-size:12px;font-weight:normal;color:#212121;text-align:left;word-wrap:break-word;align:left">
<a href="http://aka.ms/SafetyTipsFeedback">Feedback</a></td>
</tr>
</tbody>
</table>
<div>
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;" dir="ltr">
<div id="divtagdefaultwrapper" style="font-size: 12pt; color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif,"EmojiFont","Apple Color Emoji","Segoe UI Emoji",NotoColorEmoji,"Segoe UI Symbol","Android Emoji",EmojiSymbols;" dir="ltr">
<p>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</p>
<p><br>
</p>
<p></p>
<div>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'<br>
<br>
</div>
<br>
<p></p>
<p><br>
</p>
<p><br>
</p>
</div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<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 Stanonik, Ronald
<rstanonik@ucsd.edu><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</font>
<div> </div>
</div>
<div>
<div style="">
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">I notice a repeating error and stacktrace in the log about an unhandled exception.<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D"><o:p> </o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">E, [2017-09-15T09:45:13.168412 #10788] ERROR -- : Thread-5342: Unhandled exception!<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">E, [2017-09-15T09:45:13.168722 #10788] ERROR -- :<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">key not found: :<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">org/jruby/RubyHash.java:1189:in `fetch'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<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'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<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'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">org/jruby/RubyArray.java:1734:in `each'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<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'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<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'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<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'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<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'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<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'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">org/jruby/RubyBasicObject.java:1687:in `instance_eval'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<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'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<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'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<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'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:134:in `_transaction'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:108:in `block in transaction'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:98:in `hold'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255:in `synchronize'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:97:in `transaction'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<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'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<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'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">org/jruby/RubyFixnum.java:305:in `times'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<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'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<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'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<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'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<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'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<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'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">org/jruby/RubyMethod.java:111:in `call'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1611:in `block in compile!'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:975:in `block in route!'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:994:in `route_eval'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:975:in `block in route!'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1015:in `block in process_route'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">org/jruby/RubyKernel.java:1120:in `catch'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1013:in `process_route'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:973:in `block in route!'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">org/jruby/RubyArray.java:1734:in `each'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:972:in `route!'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1085:in `block in dispatch!'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1067:in `block in invoke'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">org/jruby/RubyKernel.java:1120:in `catch'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1067:in `invoke'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1082:in `dispatch!'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:907:in `block in call!'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1067:in `block in invoke'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">org/jruby/RubyKernel.java:1120:in `catch'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1067:in `invoke'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:907:in `call!'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:895:in `call'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<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'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/rack-protection-1.5.3/lib/rack/protection/xss_header.rb:18:in `call'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/rack-protection-1.5.3/lib/rack/protection/path_traversal.rb:16:in `call'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/rack-protection-1.5.3/lib/rack/protection/json_csrf.rb:18:in `call'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/rack-protection-1.5.3/lib/rack/protection/base.rb:49:in `call'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/rack-protection-1.5.3/lib/rack/protection/base.rb:49:in `call'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/rack-protection-1.5.3/lib/rack/protection/frame_options.rb:31:in `call'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">uri:classloader:/vendor/rack-1.5.5/rack/nulllogger.rb:9:in `call'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">uri:classloader:/vendor/rack-1.5.5/rack/head.rb:11:in `call'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:182:in `call'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:2013:in `call'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1487:in `block in call'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1787:in `synchronize'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">/usr/local/archivesspace/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1487:in `call'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">uri:classloader:/vendor/rack-1.5.5/rack/builder.rb:138:in `call'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">uri:classloader:/vendor/rack-1.5.5/rack/urlmap.rb:65:in `block in call'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">org/jruby/RubyArray.java:1734:in `each'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">uri:classloader:/vendor/rack-1.5.5/rack/urlmap.rb:50:in `call'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<span style="color:#1F497D">uri:classloader:/rack/handler/servlet.rb:22:in `call'<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<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<o:p></o:p></span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<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 style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org]
<b>On Behalf Of </b>Stanonik, Ronald<br>
<b>Sent:</b> Friday, September 15, 2017 9:48 AM<br>
<b>To:</b> archivesspace_users_group@lyralists.lyrasis.org<br>
<b>Subject:</b> [Archivesspace_Users_Group] 2.1.2 re-indexing loop<o:p></o:p></p>
</div>
</div>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<o:p> </o:p></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
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></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
<o:p> </o:p></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri",sans-serif;">
ps. I also posted this question to <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" style="color: rgb(5, 99, 193); text-decoration: underline;">
https://groups.google.com/forum/#!forum/archivesspace</a>. Sorry if that is redundant.<o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</body>
</html>