<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>Just a guess, but are there more than 1024 top containers that you are trying to retrieve? The maxBooleanClauses setting in
<a href="https://github.com/archivesspace/archivesspace/blob/master/solr/solrconfig.xml#L69" id="LPlnk808308">
https://github.com/archivesspace/archivesspace/blob/master/solr/solrconfig.xml#L69</a> limits the max number of booleans to 1024.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div>
<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 Cory Nimer
<cory_nimer@byu.edu><br>
<b>Sent:</b> Wednesday, September 30, 2020 12:09 PM<br>
<b>To:</b> Archivesspace Users Group (archivesspace_users_group@lyralists.lyrasis.org) <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> [Archivesspace_Users_Group] Database connection error in ArchivesSpace 2.8 PUI</font>
<div> </div>
</div>
<div lang="EN-US">
<div class="x_WordSection1">
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
Colleagues,</p>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
</p>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
While testing ArchivesSpace 2.8, we have run into occasional problems loading some records in the PUI, receiving the message "Unable to Connect to Database". Looking at the log files, it reports that the Solr search failed, caused by "too many boolean clauses".
A copy of the relevant portion of the log file is attached. </p>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
</p>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
We had experienced similar issues in 2.5.1 as well, but hoped that this would be resolved by the 2.8 release. Reviewing GitHub, the only similar references that we found were pull requests 1155 (<a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Farchivesspace%2Farchivesspace%2Fpull%2F1155&data=02%7C01%7Cjoshua.d.shaw%40dartmouth.edu%7Cb964b77d8c734c505dac08d8655b4804%7C995b093648d640e5a31ebf689ec9446f%7C0%7C1%7C637370790074461570&sdata=luMVoRgj245fXpohvHhuuUYglynRRPUIjaTG2pxqEqI%3D&reserved=0" originalsrc="https://github.com/archivesspace/archivesspace/pull/1155" shash="Mxy7Xm9Uycjx9jdIxqXyReW7gjPJhBvBP8knqK2KHfJ+8H5HG/SW/rJwt6dyre+M1czH8KHyGi16VCWktFOJ+g7tbHBgI56wcu7t/bSg01EmLRt5U5bEbvHUtQFJzClfRnWTROrmzQDk4upgePyqLGg6p8GrL3Y76zvhMdwhPKs=">https://github.com/archivesspace/archivesspace/pull/1155</a>)
and 1257 (<a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Farchivesspace%2Farchivesspace%2Fissues%2F1257&data=02%7C01%7Cjoshua.d.shaw%40dartmouth.edu%7Cb964b77d8c734c505dac08d8655b4804%7C995b093648d640e5a31ebf689ec9446f%7C0%7C1%7C637370790074471523&sdata=2%2BGYq9uEXpPP%2FtTLlhJ0zFhHlFxLKlYHPhj4sSQNxG4%3D&reserved=0" originalsrc="https://github.com/archivesspace/archivesspace/issues/1257" shash="DLvHfSF9ojzTdguGTt7vBzFCiBOXA4yitLlIu7E8j2zvbbGoC5QhEkShiEmXxLTrPL0tzxWIx8NjXILbp66H1Xbt6EhCdKQUP3StLXMZ/HgeNRVJMMxVaZsAnv/warNt64TmuvhW6S/iPDQ17JI+F3FBHQEjx2msyOkWD0Sw1W8=">https://github.com/archivesspace/archivesspace/issues/1257</a>),
though these were back in the 2.3.1 release.</p>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
</p>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
Have others encountered similar issues, and if so how were they resolved?</p>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
</p>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
Thank you for your help,</p>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
</p>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
Cory Nimer</p>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
University Archivist</p>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
Brigham Young University</p>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
801-422-6091</p>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt; font-family: "Calibri", sans-serif;">
</p>
</div>
</div>
</div>
</body>
</html>