<html 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=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<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:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
font-size:10.0pt;
font-family:"Courier New";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Consolas",serif;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.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>
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Related to this we see in the logs “<span style="font-size:10.0pt;color:black">Failure in Staff Indexer worker thread: {"error":{"db_error":["Database integrity constraint conflict: Java::JavaSql::SQLSyntaxErrorException: The SELECT would
examine more than MAX_JOIN_SIZE rows;”</span><span style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">We’re running v2.7.1. Anyone else seeing this?</span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="color:black">Ed Busch, MLIS</span></b><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Interim Head of University Archives and Electronic Records Archivist<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Michigan State University Archives and Historical Collections<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Conrad Hall<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">943 Conrad Road, Room 101<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">East Lansing, MI 48824<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">517-884-6438<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><a href="mailto:buschedw@msu.edu"><span style="color:#0563C1">buschedw@msu.edu</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">he/him/his<o:p></o:p></span></p>
</div>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:12.0pt;color:black">From: </span></b><span style="font-size:12.0pt;color:black"><archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Andrew Morrison <andrew.morrison@bodleian.ox.ac.uk><br>
<b>Reply-To: </b>"archivesspace_users_group@lyralists.lyrasis.org" <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Date: </b>Monday, August 17, 2020 at 8:53 AM<br>
<b>To: </b>"archivesspace_users_group@lyralists.lyrasis.org" <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject: </b>Re: [Archivesspace_Users_Group] No records found<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p>One possible cause is the indexer timing out at some stage after indexing the things you can see, but before indexing the things you cannot.<o:p></o:p></p>
<p>For example, it could happen if Solr takes a long time to commit changes from memory to disk storage, if the latter is slow, and if you have a lot of records. You could try doubling the value for
<i>AppConfig[:indexer_solr_timeout_seconds]</i> in your config.rb file and then <a href="https://urldefense.com/v3/__https:/archivesspace.github.io/archivesspace/user/re-creating-indexes/__;!!HXCxUKc!mb7xFMumXIwbUm5AB66GCJSR-Fcrh_7b8c8XmDME-aqkj_B5NHF7aCyiMIFhfOw$">
trigger a re-index</a>.<o:p></o:p></p>
<p>Also try monitoring the application log file while the indexer is running. Errors messages there could help with further diagnosis.<o:p></o:p></p>
<p>Andrew.<o:p></o:p></p>
<p><o:p> </o:p></p>
<div>
<p class="MsoNormal">On 14/08/2020 16:10, Busch, Ed wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">Hi-<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">We’re suddenly experiencing an odd problem. We did a reindex last week and now we can only browse Accessions, Resources and DOs. Everything else returns a No records found.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">If we are in a resource or accession, we can see the Agents and Subjects, etc linked to them find. It’s only when we try to Browse and see all.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Anyone have any clues? We’ve tried rolling back the data but that doesn’t seem to be it. It seems like a system problem cropped up.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal"><b><span style="color:black">Ed Busch, MLIS</span></b><o:p></o:p></p>
<p class="MsoNormal"><span style="color:black">Interim Head of University Archives and Electronic Records Archivist</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:black">Michigan State University Archives and Historical Collections</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:black">Conrad Hall</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:black">943 Conrad Road, Room 101</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:black">East Lansing, MI 48824</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:black">517-884-6438</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:black"><a href="mailto:buschedw@msu.edu"><span style="color:#0563C1">buschedw@msu.edu</span></a></span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:black">he/him/his</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"><br>
<br>
<o:p></o:p></p>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>Archivesspace_Users_Group mailing list<o:p></o:p></pre>
<pre><a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org">Archivesspace_Users_Group@lyralists.lyrasis.org</a><o:p></o:p></pre>
<pre><a href="https://urldefense.com/v3/__http:/lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group__;!!HXCxUKc!mb7xFMumXIwbUm5AB66GCJSR-Fcrh_7b8c8XmDME-aqkj_B5NHF7aCyi6Wqcb84$">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><o:p></o:p></pre>
</blockquote>
</div>
</body>
</html>