<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
Hi all,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
I've just come across this error and I can see several problems that I'm sharing, hoping to be useful.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
First off, my Solr converted the <code>schema.xml</code> I uploaded into a file named
<code>managed-schema</code>, This is by no means unusual for recent versions, but the code that checks the checksums tries to download</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
<code>AppConfig[':solr_url']/admin/file?file=schema.xml&contentType=text%2Fxml%3Bcharset%3Dutf-8</code><br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
which trivially fails in this case.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
Workaround: copy the file over to the name <code>schema.xml</code></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
Second, the schema the downloaded one is being compared with is the one in the <code>
solr/</code> directory of the AS installation, which on the one hand makes sense, but also excludes any local schema modifications, like the ones we had in.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
Workaround: copy your <code>schema.xml</code> and <code>solrconfig.xml</code> into your AS installation's
<code>solr</code>/ directory</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
At this point you need to restart ArchivesSpace for it to recalculate the checksums for the local XML files, after that it should boot successfully.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
Third, checksums are a horrible way of comparing XML documents. A single-space difference would result in the exact same schema semantically and AS would still fail on startup.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
Solution: none locally. I believe that developers should utilise the version attribute of the
<code><schema></code> tag better, coming up with a versioning scheme, updating the version accordingly whenever the schema is changed in development and the application should not go beyond comparing this schema version.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
Fourth, most of 'solrconfig.xml' has nothing to do with AS and it is plain wrong to impose a particular version on the Solr administrator.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0 ContentPasted1">
Solution: developers should create a <code>configoverlay.json</code> file administrators can drop in place that ensures that AS's requirements are satisfied. I believe this is supported by all currently supported versions of Solr.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0 ContentPasted1">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0 ContentPasted1">
Thanks,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0 ContentPasted1">
p</div>
<div id="appendonsend"></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 Mark Cyzyk
<mcyzyk@gmail.com><br>
<b>Sent:</b> 16 July 2023 21:09<br>
<b>To:</b> mcyzyk@jhu.edu <mcyzyk@jhu.edu>; Connolly, Ashley <asconnolly@seattleschools.org>; Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Staging upgrade using Vagrant/Virtualbox, data in MySQL tables, Solr core present, reindexed, yet no data displayed in ASpace application</font>
<div> </div>
</div>
<div><br>
"Inconceivable!"<br>
<br>
(I don't think "reload" means what I think it means -- at least not in a Solr context.)<br>
<br>
Problem solved and moral of story:<br>
<br>
<ul>
<li>It is not enough to simply copy the Archivesspace Solr config files over to the corresponding directory on the Solr server.</li><li>It is not enough to reload the Solr Archivesspace Core with these files in place.</li><li>It is not enough to restart the Solr service with these files in place.</li><li>You must delete/destroy the existing Archivesspace Core, you must create a new Archivesspace Core, you must copy the Archivesspace Solr config files over to the corresponding directory on the Solr server, and finally for good measure you must restart the
Solr service with these files in place.</li><li>With a Solr Archivesspace Core up and running, you now are ready to boot up the Archivesspace application and will not get a checksum mismatch error.</li></ul>
<br>
Last few lines of my Vagrant routine -- basically Delete, Create, Copy, Restart:<br>
<br>
<blockquote>sudo su - solr -c "/opt/solr/bin/solr delete -c archivesspace -p 8983 -deleteConfig true"
<br>
sudo rm -Rv /opt/solr/server/solr/configsets/archivesspace<br>
sudo mkdir -p /opt/solr/server/solr/configsets/archivesspace/conf<br>
sudo cp -r /usr/share/archivesspace/solr/* /opt/solr/server/solr/configsets/archivesspace/conf/<br>
sudo chown -R solr:solr /opt/solr/server/solr/configsets/archivesspace/conf/<br>
sudo su - solr -c "/opt/solr/bin/solr create -c archivesspace -p 8983 -d archivesspace"<br>
sudo systemctl restart solr <br>
sudo /usr/share/archivesspace/scripts/setup-database.sh<br>
sudo systemctl start archivesspace<br>
</blockquote>
<br>
It's all working, upgraded to 3.4.0 with plugins seemingly working.<br>
<br>
Spinning in chair,<br>
G'Day!<br>
<br>
Mark<br>
<br>
<br>
<pre class="x_moz-signature" cols="72"><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
Mark Cyzyk, M.A., M.L.S.
Library Applications Group
The Sheridan Libraries
The Johns Hopkins University
<a class="x_moz-txt-link-abbreviated" href="mailto:mcyzyk@jhu.edu">mcyzyk@jhu.edu</a>
Verba volant, scripta manent.
</pre>
<div class="x_moz-cite-prefix">On 7/16/23 11:12, Mark Cyzyk wrote:<br>
</div>
<blockquote type="cite"><br>
More:<br>
<br>
From what I'm reading, Solr maintains the old config file (schema.xml) in some kind of temp directory. I'm thinking, therefore, that this old file is cached in this way and is the one being read and that that's how two different checksums are possible?<br>
<br>
So my thinking is, maybe once the new Solr config files are copied over to the Solr Archivesspace core, that that core needs to be reloaded in order for Solr to get rid of the cache.<br>
<br>
The last few lines from my Vagrant routine:<br>
<br>
<blockquote>sudo cp -Rv /usr/share/archivesspace/solr/* /opt/solr/server/solr/configsets/archivesspace/conf/<br>
sudo chown -R solr:solr /opt/solr/server/solr/configsets/archivesspace/conf/<br>
<b>curl <a class="x_moz-txt-link-rfc2396E" href="http://localhost:8983/solr/admin/cores?action=RELOAD&core=archivesspace">
"http://localhost:8983/solr/admin/cores?action=RELOAD&core=archivesspace"</a></b><br>
sudo systemctl restart solr <br>
sudo /usr/share/archivesspace/scripts/setup-database.sh<br>
sudo systemctl start archivesspace<br>
</blockquote>
<br>
But still no joy! Still checksum mismatch.<br>
<br>
...<br>
<br>
As an experiment, in my config.rb I set:<br>
<br>
<blockquote>AppConfig[:solr_verify_checksums] = false<br>
</blockquote>
<br>
Boot up ASpace, and error:<br>
<br>
<blockquote>ArchivesSpaceThreadDump: Touch the file '/usr/share/archivesspace/thread_dump_indexer.txt' to trigger a thread dump<br>
I, [2023-07-15T19:24:43.750508 #52921] INFO -- : Thread-2930: Starting periodic indexer<br>
I, [2023-07-15T19:24:43.752627 #52921] INFO -- : Thread-2930: Starting PUI indexer<br>
I, [2023-07-15T19:24:43.756222 #52921] INFO -- : Thread-2932: Staff Indexer [2023-07-15 19:24:43 +0000] Running index round<br>
E, [2023-07-15T19:24:44.997705 #52921] ERROR -- : Thread-2932: SolrIndexerError when indexing records: {<br>
"responseHeader":{<br>
"status":400,<br>
"QTime":38},<br>
"error":{<br>
"metadata":[<br>
"error-class","org.apache.solr.common.SolrException",<br>
"root-error-class","org.apache.solr.common.SolrException"],<br>
"msg":"ERROR: [doc=/repositories/3] <b>unknown field 'position_int_sort'",</b><br>
"code":400}}<br>
</blockquote>
<br>
It's as if the new Solr config has not taken effect. [It's not really a new config, both schemas are Version 1.5. I'm just trying to overcome this mysterious checksum mismatch...]<br>
<br>
Copying the ASpace Solr config files over to the corresponding Solr directory, reloading the Solr Archivesspace core with these new files in place, and restarting the Solr service is not enough. I feel like I'm missing one final step.<br>
<br>
Mark<br>
<br>
<br>
<pre class="x_moz-signature" cols="72"><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
Mark Cyzyk, M.A., M.L.S.
Library Applications Group
The Sheridan Libraries
The Johns Hopkins University
<a class="x_moz-txt-link-abbreviated x_moz-txt-link-freetext" href="mailto:mcyzyk@jhu.edu">mcyzyk@jhu.edu</a>
Verba volant, scripta manent.
</pre>
<div class="x_moz-cite-prefix">On 7/15/23 10:18, Mark Cyzyk wrote:<br>
</div>
<blockquote type="cite">Thanks, Ashley,<br>
<br>
I did not know about that Reindexer plugin. Useful!<br>
<br>
I am able to reindex now, no prob.<br>
<br>
My problem appears to be that the checksum on the schema.xml file from my Production server differs what the checksum on the schema.xml file in the 3.4.0 distribution, and this despite the fact that the both are Version 1.5 of the schema:<br>
<br>
<blockquote>Outside the VM, on Disk:<br>
mcyzyk@SPEEDY2022:~/VagrantBoxes/Archivesspace/archivesspace_CURRENT/solr$ sha256sum schema.xml
<br>
<b>4d4849771a91d677f255b638cbefa8b8d67a236c56c645bb13c2842480614d78 </b> schema.xml<br>
<br>
mcyzyk@SPEEDY2022:~/VagrantBoxes/Archivesspace/archivesspace_NEW/solr$ sha256sum schema.xml<br>
<b>f066f17556bbe49b0526ff70ae885bdc9655666b503227667ef0c4315e4e5b0b</b> schema.xml<br>
</blockquote>
<br>
And so, with the Production version of 3.2.0 installed in my VM, when I go to upgrade to 3.4.0 everything initially works --
<i>except</i> this checksum mismatch.<br>
<br>
In the VM, I copy the NEW (3.4.0) schema.xml file over into the Solr config and restart Solr. The files at this point should, and do, have identical checksums.<br>
<br>
<blockquote><span style="font-size:11.0pt">vagrant@vagrant:~$ sha256sum /usr/share/archivesspace/solr/schema.xml
</span><br>
<span style="font-size:11.0pt"><b>f066f17556bbe49b0526ff70ae885bdc9655666b503227667ef0c4315e4e5b0b</b> </span><br>
<span style="font-size:11.0pt"></span><br>
<span style="font-size:11.0pt">vagrant@vagrant:~$ sha256sum /opt/solr/server/solr/configsets/archivesspace/conf/schema.xml</span><br>
<span style="font-size:11.0pt"><b>f066f17556bbe49b0526ff70ae885bdc9655666b503227667ef0c4315e4e5b0b
</b></span><br>
</blockquote>
<br>
And yet the Archivesspace space error persists upon bootup: "<span style="font-size:11.0pt">Solr checksum verification failed</span>"<br>
<br>
With the two files being identical, I don't see how this is possible. If ASpace is performing a checksum against schema.xml in the Solr config, and the schema.xml file in the ASpace directory, they are now equal.<br>
<br>
Not sure why this error is still happening.<br>
<br>
Mark<br>
<br>
<pre class="x_moz-signature" cols="72"><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
Mark Cyzyk, M.A., M.L.S.
Library Applications Group
The Sheridan Libraries
The Johns Hopkins University
<a class="x_moz-txt-link-abbreviated x_moz-txt-link-freetext" href="mailto:mcyzyk@jhu.edu">mcyzyk@jhu.edu</a>
Verba volant, scripta manent.
</pre>
<div class="x_moz-cite-prefix">On 7/14/23 21:27, Connolly, Ashley wrote:<br>
</div>
<blockquote type="cite">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
@font-face
{font-family:"Calibri Light"}
@font-face
{font-family:Consolas}
p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
{margin:0in;
font-size:10.0pt;
font-family:"Calibri",sans-serif}
a:link, span.x_MsoHyperlink
{color:blue;
text-decoration:underline}
code
{font-family:"Courier New"}
pre
{margin:0in;
font-size:10.0pt;
font-family:"Courier New"}
span.x_HTMLPreformattedChar
{font-family:Consolas}
span.x_gmailsignatureprefix
{}
span.x_EmailStyle23
{font-family:"Calibri",sans-serif;
color:windowtext}
.x_MsoChpDefault
{font-size:10.0pt}
div.x_WordSection1
{}
-->
</style>
<div class="x_WordSection1">
<p class="x_MsoNormal"><span style="font-size:11.0pt">Hey Mark,</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt"> </span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt">Something that stuck out to me as I just did an upgrade to 3.4.0 from 3.3.1 today – I did not have either an indexer_state or indexer_pui_state directory in my Solr AS core, I only had an “index” directory.
<u>Running Solr 8.11.2.</u></span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt"> </span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt">I deleted the directory “index” from my Solr core data directory (for me, /home/solr/var-solr/data/archivesspace/data) and restarted Solr. I also installed
<a href="https://github.com/lyrasis/aspace-reindexer" originalsrc="https://github.com/lyrasis/aspace-reindexer" shash="iLLcvaeD3JSZKTRIlnTei3UF2LeLTT9o8gzBH/edz3ESL56kJUyX4ZA0bWKmSOSZRujhTC1fL6FS2JfMV089Ty+e9s96OrCXw+E68ZAHD+7Q5qJoSFdkyQ7MNu9tIiVj+QRL+MY4QM29m2ef84NPZA/Al/NwuTuqOm6LI5F76UE=" class="x_moz-txt-link-freetext">
https://github.com/lyrasis/aspace-reindexer</a> and (temporarily) enabled the configuration option to auto-reindex on AS start. Ran the DB migrations per the upgrade docs and after that I had no issues starting ArchivesSpace.</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt"> </span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt">Not sure if this helps or not but as I recall on some systems `rm` will return success if asked to delete a directory that doesn’t exist, so I thought it worth mentioning in case you missed deleting the
Solr index. Good luck,</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt"> </span></p>
<p class="x_MsoNormal"><span style="">--</span><span style=""><br>
<span style="border:none windowtext 1.0pt; padding:0in">Mx. Ashley Rose Connolly (she/her), Senior Systems Engineer, SPS DoTS SysOps</span></span><span style="font-size:11.0pt"></span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt"> </span></p>
<div id="x_mail-editor-reference-message-container">
<div>
<div style="border:none; border-top:solid #B5C4DF
1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_MsoNormal" style="margin-right:0in; margin-bottom:12.0pt; margin-left:.5in">
<b><span style="font-size:12.0pt; color:black">From: </span></b><span style="font-size:12.0pt; color:black"><a class="x_moz-txt-link-abbreviated x_moz-txt-link-freetext" href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>
<a class="x_moz-txt-link-rfc2396E" href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">
<archivesspace_users_group-bounces@lyralists.lyrasis.org></a> on behalf of Mark Cyzyk
<a class="x_moz-txt-link-rfc2396E" href="mailto:mcyzyk@gmail.com"><mcyzyk@gmail.com></a><br>
<b>Date: </b>Friday, July 14, 2023 at 15:11<br>
<b>To: </b><a class="x_moz-txt-link-abbreviated x_moz-txt-link-freetext" href="mailto:mcyzyk@jhu.edu">mcyzyk@jhu.edu</a>
<a class="x_moz-txt-link-rfc2396E" href="mailto:mcyzyk@jhu.edu"><mcyzyk@jhu.edu></a>,
<a class="x_moz-txt-link-abbreviated x_moz-txt-link-freetext" href="mailto:jesse.martinez@bc.edu">
jesse.martinez@bc.edu</a> <a class="x_moz-txt-link-rfc2396E" href="mailto:jesse.martinez@bc.edu">
<jesse.martinez@bc.edu></a><br>
<b>Cc: </b>Archivesspace Users Group <a class="x_moz-txt-link-rfc2396E" href="mailto:archivesspace_users_group@lyralists.lyrasis.org">
<archivesspace_users_group@lyralists.lyrasis.org></a><br>
<b>Subject: </b>Re: [Archivesspace_Users_Group] Staging upgrade using Vagrant/Virtualbox, data in MySQL tables, Solr core present, reindexed, yet no data displayed in ASpace application</span></p>
</div>
<p class="x_MsoNormal" style="margin-right:0in; margin-bottom:12.0pt; margin-left:.5in">
<span style="font-size:11.0pt"><br>
Sorry to keep this thread going!<br>
<br>
I returned to this project a little while ago and checked both schema.xml files and sure enough they have different checksums:</span></p>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">vagrant@vagrant:/usr/share/archivesspace/solr$ sha256sum schema.xml
<br>
<b>f066f17556bbe49b0526ff70ae885bdc9655666b503227667ef0c4315e4e5b0b</b> schema.xml<br>
<br>
vagrant@vagrant:/opt/solr/server/solr/configsets/archivesspace/conf$ sha256sum schema.xml<br>
<b>4d4849771a91d677f255b638cbefa8b8d67a236c56c645bb13c2842480614d78</b> schema.xml</span></p>
</blockquote>
<p class="x_MsoNormal" style="margin-right:0in; margin-bottom:12.0pt; margin-left:.5in">
<span style="font-size:11.0pt"><br>
Thinking maybe there was some kind of bit-flipping happening when copying between Vagrant/Virtualbox Host and Guest, I copied the Solr schema.xml file directly from within the VM itself.</span></p>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">cp /usr/share/archivesspace/solr/schema.xml /opt/solr/server/solr/configsets/archivesspace/conf/schema.xml</span></p>
</blockquote>
<p class="x_MsoNormal" style="margin-right:0in; margin-bottom:12.0pt; margin-left:.5in">
<span style="font-size:11.0pt"><br>
This results in two files with identical checksums:</span></p>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">vagrant@vagrant:~$ sha256sum /usr/share/archivesspace/solr/schema.xml
<br>
<b>f066f17556bbe49b0526ff70ae885bdc9655666b503227667ef0c4315e4e5b0b</b> <br>
<br>
vagrant@vagrant:~$ sha256sum /opt/solr/server/solr/configsets/archivesspace/conf/schema.xml<br>
<b>f066f17556bbe49b0526ff70ae885bdc9655666b503227667ef0c4315e4e5b0b </b></span></p>
</blockquote>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"><br>
Unfortunately, when I start up ASpace I still get the "Solr checksum verification failed."<br>
<br>
I just am not sure how this is possible. Both files have the same checksums!<br>
<br>
Thinking...<br>
<br>
Mark<br>
<br>
</span></p>
<pre style="margin-left:.5in"><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> </pre>
<pre style="margin-left:.5in">Mark Cyzyk, M.A., M.L.S.</pre>
<pre style="margin-left:.5in">Library Applications Group</pre>
<pre style="margin-left:.5in">The Sheridan Libraries</pre>
<pre style="margin-left:.5in">The Johns Hopkins University</pre>
<pre style="margin-left:.5in"><a href="mailto:mcyzyk@jhu.edu" class="x_moz-txt-link-freetext">mcyzyk@jhu.edu</a></pre>
<pre style="margin-left:.5in"> </pre>
<pre style="margin-left:.5in">Verba volant, scripta manent. </pre>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">On 7/14/23 11:58, Mark Cyzyk wrote:</span></p>
</div>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<p class="x_MsoNormal" style="margin-right:0in; margin-bottom:12.0pt; margin-left:.5in">
<span style="font-size:11.0pt"><br>
After-Party:<br>
<br>
Now that I have a copy of my production 3.2.0 running just fine via Vagrant, I run my Upgrade routines and ASpace DOES upgrade to 3.4.0!<br>
<br>
But, when I do a search for anything I get a nice "Unable to Connect to Database" error message which, I have determined, is a misnomer. What it means to say is: "Solr checksum verification failed".<br>
<br>
Full error message here:</span></p>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">ArchivesSpaceThreadDump: Touch the file '/usr/share/archivesspace/thread_dump_backend.txt' to trigger a thread dump<br>
I, [2023-07-14T15:40:57.771226 #52824] INFO -- : Thread-2002: Connecting to database: jdbc:mysql://localhost:3306/archivesspace?user=[REDACTED]&password=[REDACTED]&useUnicode=true&characterEncoding=UTF-8&useSS><br>
I, [2023-07-14T15:40:58.115235 #52824] INFO -- : Thread-2002: All tables checked and confirmed set to UTF-8. Nice job!<br>
========================================================================<br>
A trace file has been written to the following location: /usr/share/archivesspace/data/tmp/aspace_diagnostic_1689349259.txt<br>
<br>
This file contains information that will assist developers in diagnosing<br>
problems with your ArchivesSpace installation. Please review the file's<br>
contents for sensitive information (such as passwords) that you might not<br>
want to share.<br>
========================================================================<br>
Jul 14, 2023 3:40:59 PM org.eclipse.jetty.server.handler.ContextHandler$Context log<br>
INFO: An exception happened during JRuby-Rack startup<br>
Solr checksum verification failed (schema): expected [f066f17556bbe49b0526ff70ae885bdc9655666b503227667ef0c4315e4e5b0b] got [4d4849771a91d677f255b638cbefa8b8d67a236c56c645bb13c2842480614d78]</span></p>
</blockquote>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"><br>
DB check, OK.<br>
UTF-8 check, OK.<br>
Solr Schema checksum check, Not OK.<br>
<br>
And so, I then forced my Vagrant script to simply copy 3.4.0 Solr files* into /opt/solr/server/solr/configsets/archivesspace/conf At this point, the files in these two directories should be exactly similar with identical checksums.<br>
<br>
I restart Solr with these files in place.<br>
<br>
I restart ASpace -- still checksum failure.<br>
<br>
Trying to think how their checksums can differ. Should be an exact copy.<br>
<br>
Mark<br>
<br>
<br>
</span></p>
<pre style="margin-left:.5in"><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> </pre>
<pre style="margin-left:.5in">Mark Cyzyk, M.A., M.L.S.</pre>
<pre style="margin-left:.5in">Library Applications Group</pre>
<pre style="margin-left:.5in">The Sheridan Libraries</pre>
<pre style="margin-left:.5in">The Johns Hopkins University</pre>
<pre style="margin-left:.5in"><a href="mailto:mcyzyk@jhu.edu" class="x_moz-txt-link-freetext">mcyzyk@jhu.edu</a></pre>
<pre style="margin-left:.5in"> </pre>
<pre style="margin-left:.5in">Verba volant, scripta manent. </pre>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">On 7/13/23 16:19, Mark Cyzyk wrote:</span></p>
</div>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<p class="x_MsoNormal" style="margin-right:0in; margin-bottom:12.0pt; margin-left:.5in">
<span style="font-size:11.0pt">Thanks Joshua, Jesse, Brian, Blake, Valerie for helping me this week on my VEXING Aspace/Vagrant/Solr issue.<br>
<br>
Here is what's now working: (!)<br>
<br>
In my config.rb (for Vagrant version of this project):</span></p>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"># Vagrant ######################################################################<br>
AppConfig[:db_url] = "jdbc:mysql://localhost:3306/archivesspace?user=REDACTED&password=REDACTED&useUnicode=true&characterEncoding=UTF-8&useSSL=false&allowPublicKeyRetrieval=true"<br>
AppConfig[:backend_url] = <a href="http://localhost:8089">"http://localhost:8089"</a><br>
AppConfig[:frontend_url] = <a href="http://localhost:8080">"http://localhost:8080"</a><br>
AppConfig[:public_url] = <a href="http://localhost:9999">"http://localhost:9999"</a><br>
AppConfig[:solr_verify_checksums] = true<br>
AppConfig[:enable_solr] = false<br>
AppConfig[:solr_url] = <a href="http://localhost:8983/solr/archivesspace">"http://localhost:8983/solr/archivesspace"</a><br>
################################################################################</span></p>
</blockquote>
<p class="x_MsoNormal" style="margin-right:0in; margin-bottom:12.0pt; margin-left:.5in">
<span style="font-size:11.0pt"><br>
This and the following Force Reindex did the trick!</span></p>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">sudo service archivespace stop<br>
sudo rm -rf /usr/share/archivesspace/data/indexer_state/<br>
sudo rm -rf /usr/share/archivesspace/data/indexer_pui_state/<br>
curl -X POST -H 'Content-Type: application/json' --data-binary '{"delete":{"query":"*:*" }}'
<a href="http://localhost:8983/solr/archivesspace/update?commit=true" class="x_moz-txt-link-freetext">
http://localhost:8983/solr/archivesspace/update?commit=true</a><br>
sudo service archivesspace start</span></p>
</blockquote>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"><br>
Seriously appreciative.<br>
<br>
Onward!<br>
<br>
Mark<br>
<br>
</span></p>
<pre style="margin-left:.5in"><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> </pre>
<pre style="margin-left:.5in">Mark Cyzyk, M.A., M.L.S.</pre>
<pre style="margin-left:.5in">Library Applications Group</pre>
<pre style="margin-left:.5in">The Sheridan Libraries</pre>
<pre style="margin-left:.5in">The Johns Hopkins University</pre>
<pre style="margin-left:.5in"><a href="mailto:mcyzyk@jhu.edu" class="x_moz-txt-link-freetext">mcyzyk@jhu.edu</a></pre>
<pre style="margin-left:.5in"> </pre>
<pre style="margin-left:.5in"> </pre>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">On 7/13/23 11:24 AM, Jesse Martinez wrote:</span></p>
</div>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">Hi Mark,
</span></p>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">It's normal for the archivesspace core not to have a Data import handler set up. And it's also normal to see that warning message about security in the solr logs.</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">Thank you for checking that the solr schema.xml file matches. The last thing I can recommend for troubleshooting solr is to bootstrap it with solr data from production, and see if
that loads records into the ASpace interface.</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">Jesse </span></p>
</div>
</div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
<div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">On Thu, Jul 13, 2023 at 10:49 AM Mark Cyzyk <<a href="mailto:mcyzyk@gmail.com" target="_blank" class="x_moz-txt-link-freetext">mcyzyk@gmail.com</a>> wrote:</span></p>
</div>
<blockquote style="border:none; border-left:solid
#CCCCCC 1.0pt; padding:0in 0in 0in
6.0pt; margin-left:4.8pt; margin-right:0in">
<div>
<p class="x_MsoNormal" style="margin-right:0in; margin-bottom:12.0pt; margin-left:.5in">
<span style="font-size:11.0pt"><br>
In the Solr Web Gui --> Archivesspace Core --> Dataimport, there is this error message:</span></p>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">The solrconfig.xml file for this index does not have an operational DataImportHandler defined!</span></p>
</blockquote>
<p class="x_MsoNormal" style="margin-right:0in; margin-bottom:12.0pt; margin-left:.5in">
<span style="font-size:11.0pt"><br>
My solrconfig.xml, straight from 3.2.0 codebase:</span></p>
<div>
<div>
<pre style="margin-left:.5in"><code><?xml version="1.0" encoding="utf-8"?></code></pre>
<pre style="margin-left:.5in"><code><config></code></pre>
<pre style="margin-left:.5in"><code> <lib dir="${solr.install.dir}/dist/" regex="solr-analysis-extras.*\.jar" /></code></pre>
<pre style="margin-left:.5in"><code> <lib dir="${solr.install.dir}/contrib/analysis-extras/lucene-libs" regex="lucene-analyzers-icu-.*\.jar" /></code></pre>
<pre style="margin-left:.5in"><code> <lib dir="${solr.install.dir}/contrib/analysis-extras/lib/" regex="icu4j-*.*\.jar" /></code></pre>
<pre style="margin-left:.5in"><code> <schemaFactory class="ClassicIndexSchemaFactory"/></code></pre>
<pre style="margin-left:.5in"><code> <luceneMatchVersion>8.10</luceneMatchVersion></code></pre>
<pre style="margin-left:.5in"><code> <dataDir>${solr.data.dir:}</dataDir></code></pre>
<pre style="margin-left:.5in"><code> <directoryFactory name="DirectoryFactory" class="${solr.directoryFactory:solr.NRTCachingDirectoryFactory}" /></code></pre>
<pre style="margin-left:.5in"><code> <updateHandler class="solr.DirectUpdateHandler2"></code></pre>
<pre style="margin-left:.5in"><code> <maxPendingDeletes>1000</maxPendingDeletes></code></pre>
<pre style="margin-left:.5in"><code> <autoCommit></code></pre>
<pre style="margin-left:.5in"><code> <maxDocs>1000</maxDocs></code></pre>
<pre style="margin-left:.5in"><code> <maxTime>60000</maxTime></code></pre>
<pre style="margin-left:.5in"><code> <openSearcher>false</openSearcher></code></pre>
<pre style="margin-left:.5in"><code> </autoCommit></code></pre>
<pre style="margin-left:.5in"><code> </updateHandler></code></pre>
<pre style="margin-left:.5in"><code> <query></code></pre>
<pre style="margin-left:.5in"><code> <maxBooleanClauses>1024</maxBooleanClauses></code></pre>
<pre style="margin-left:.5in"><code> <filterCache class="solr.FastLRUCache" size="512" initialSize="512" autowarmCount="0" /></code></pre>
<pre style="margin-left:.5in"><code> <queryResultCache class="solr.LRUCache" size="512" initialSize="512" autowarmCount="0" /></code></pre>
<pre style="margin-left:.5in"><code> <documentCache class="solr.LRUCache" size="512" initialSize="512" autowarmCount="0" /></code></pre>
<pre style="margin-left:.5in"><code> <enableLazyFieldLoading>true</enableLazyFieldLoading></code></pre>
<pre style="margin-left:.5in"><code> <queryResultWindowSize>20</queryResultWindowSize></code></pre>
<pre style="margin-left:.5in"><code> <queryResultMaxDocsCached>200</queryResultMaxDocsCached></code></pre>
<pre style="margin-left:.5in"><code> <useColdSearcher>false</useColdSearcher></code></pre>
<pre style="margin-left:.5in"><code> <maxWarmingSearchers>2</maxWarmingSearchers></code></pre>
<pre style="margin-left:.5in"><code> </query></code></pre>
<pre style="margin-left:.5in"><code> <requestDispatcher handleSelect="false"></code></pre>
<pre style="margin-left:.5in"><code> <requestParsers enableRemoteStreaming="true" multipartUploadLimitInKB="2048000" /></code></pre>
<pre style="margin-left:.5in"><code> <httpCaching never304="true" /></code></pre>
<pre style="margin-left:.5in"><code> </requestDispatcher></code></pre>
<pre style="margin-left:.5in"><code> <requestHandler name="/select" class="solr.SearchHandler"></code></pre>
<pre style="margin-left:.5in"><code> <lst name="defaults"></code></pre>
<pre style="margin-left:.5in"><code> <str name="defType">edismax</str></code></pre>
<pre style="margin-left:.5in"><code> <str name="echoParams">explicit</str></code></pre>
<pre style="margin-left:.5in"><code> <int name="rows">10</int></code></pre>
<pre style="margin-left:.5in"><code> <str name="df">fullrecord</str></code></pre>
<pre style="margin-left:.5in"><code> <str name="pf">four_part_id^50</str></code></pre>
<pre style="margin-left:.5in"><code> <str name="qf">title^25 four_part_id^50 fullrecord</str></code></pre>
<pre style="margin-left:.5in"><code> <str name="bq">primary_type:resource^100</str></code></pre>
<pre style="margin-left:.5in"><code> <str name="bq">primary_type:accession^100</str></code></pre>
<pre style="margin-left:.5in"><code> <str name="bq">primary_type:subject^50</str></code></pre>
<pre style="margin-left:.5in"><code> <str name="bq">primary_type:agent_person^50</str></code></pre>
<pre style="margin-left:.5in"><code> <str name="bq">primary_type:agent_corporate_entity^30</str></code></pre>
<pre style="margin-left:.5in"><code> <str name="bq">primary_type:agent_family^30</str></code></pre>
<pre style="margin-left:.5in"><code> </lst></code></pre>
<pre style="margin-left:.5in"><code> </requestHandler></code></pre>
<pre style="margin-left:.5in"><code> <requestHandler name="/update" class="solr.UpdateRequestHandler"></requestHandler></code></pre>
<pre style="margin-left:.5in"><code> <requestHandler name="/analysis/document" class="solr.DocumentAnalysisRequestHandler" startup="lazy" /></code></pre>
<pre style="margin-left:.5in"><code> <requestHandler name="/analysis/field" startup="lazy" class="solr.FieldAnalysisRequestHandler" /></code></pre>
<pre style="margin-left:.5in"><code> <requestHandler name="/replication" class="solr.ReplicationHandler" startup="lazy" /></code></pre>
<pre style="margin-left:.5in"><code> <queryResponseWriter name="json" class="solr.JSONResponseWriter"></code></pre>
<pre style="margin-left:.5in"><code> <str name="content-type">text/plain; charset=UTF-8</str></code></pre>
<pre style="margin-left:.5in"><code> </queryResponseWriter></code></pre>
<pre style="margin-left:.5in"><code> <admin></code></pre>
<pre style="margin-left:.5in"><code> <defaultQuery>*:*</defaultQuery></code></pre>
<pre style="margin-left:.5in"><code> </admin></code></pre>
<pre style="margin-left:.5in"><code> <requestHandler name="/admin/luke" class="org.apache.solr.handler.admin.LukeRequestHandler" /></code></pre>
<pre style="margin-left:.5in"><code></config></code></pre>
</div>
</div>
<pre style="margin-left:.5in"><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> </pre>
<pre style="margin-left:.5in">Mark Cyzyk, M.A., M.L.S.</pre>
<pre style="margin-left:.5in">Library Applications Group</pre>
<pre style="margin-left:.5in">The Sheridan Libraries</pre>
<pre style="margin-left:.5in">The Johns Hopkins University</pre>
<pre style="margin-left:.5in"><a href="mailto:mcyzyk@jhu.edu" target="_blank" class="x_moz-txt-link-freetext">mcyzyk@jhu.edu</a></pre>
<pre style="margin-left:.5in"> </pre>
<pre style="margin-left:.5in">Verba volant, scripta manent. </pre>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">On 7/13/23 10:40, Mark Cyzyk wrote:</span></p>
</div>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">Hi Mark,
</span></p>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">If you go to this URL</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"><a href="http://localhost:8983/solr/#/archivesspace/files?file=schema.xml" target="_blank" class="x_moz-txt-link-freetext">http://localhost:8983/solr/#/archivesspace/files?file=schema.xml</a> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">does the schema file shown there match the same one you copied over?</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"><a href="https://github.com/archivesspace/archivesspace/blob/v3.2.0/solr/schema.xml" originalsrc="https://github.com/archivesspace/archivesspace/blob/v3.2.0/solr/schema.xml" shash="ns8vbIF9hRfA96rpjh5myVQaw/rCrAAOXoMwzfCQSI4tdyCfxTj/qzUnxKmXNB2tuOkPbFVY4uzIUiPgKVU9DKMCPQ6+OnzntXAEIRHag8Guth9Ielwggtcq/etkeeNM30R1bVhVbYYg61gtf4DglPR8+1rFtDIgtepjsBU/Wb8=" target="_blank" class="x_moz-txt-link-freetext">https://github.com/archivesspace/archivesspace/blob/v3.2.0/solr/schema.xml</a></span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">Jesse</span></p>
</div>
</blockquote>
<p class="x_MsoNormal" style="margin-right:0in; margin-bottom:12.0pt; margin-left:.5in">
<span style="font-size:11.0pt"><br>
<br>
Yes, they match:</span></p>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"><schema name="archivesspace" version="1.5"></span></p>
</blockquote>
<p class="x_MsoNormal" style="margin-right:0in; margin-bottom:12.0pt; margin-left:.5in">
<span style="font-size:11.0pt"><br>
Thinking...<br>
<br>
Mark</span></p>
<pre style="margin-left:.5in"><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> </pre>
<pre style="margin-left:.5in">Mark Cyzyk, M.A., M.L.S.</pre>
<pre style="margin-left:.5in">Library Applications Group</pre>
<pre style="margin-left:.5in">The Sheridan Libraries</pre>
<pre style="margin-left:.5in">The Johns Hopkins University</pre>
<pre style="margin-left:.5in"><a href="mailto:mcyzyk@jhu.edu" target="_blank" class="x_moz-txt-link-freetext">mcyzyk@jhu.edu</a></pre>
<pre style="margin-left:.5in"> </pre>
<pre style="margin-left:.5in">Verba volant, scripta manent. </pre>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">On 7/12/23 16:20, Jesse Martinez wrote:</span></p>
</div>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">Hi Mark,
</span></p>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">If you go to this URL</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"><a href="http://localhost:8983/solr/#/archivesspace/files?file=schema.xml" target="_blank" class="x_moz-txt-link-freetext">http://localhost:8983/solr/#/archivesspace/files?file=schema.xml</a> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">does the schema file shown there match the same one you copied over?</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"><a href="https://github.com/archivesspace/archivesspace/blob/v3.2.0/solr/schema.xml" originalsrc="https://github.com/archivesspace/archivesspace/blob/v3.2.0/solr/schema.xml" shash="ns8vbIF9hRfA96rpjh5myVQaw/rCrAAOXoMwzfCQSI4tdyCfxTj/qzUnxKmXNB2tuOkPbFVY4uzIUiPgKVU9DKMCPQ6+OnzntXAEIRHag8Guth9Ielwggtcq/etkeeNM30R1bVhVbYYg61gtf4DglPR8+1rFtDIgtepjsBU/Wb8=" target="_blank" class="x_moz-txt-link-freetext">https://github.com/archivesspace/archivesspace/blob/v3.2.0/solr/schema.xml</a></span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">Jesse</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
</div>
</div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
<div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">On Wed, Jul 12, 2023 at 3:44 PM Mark Cyzyk <<a href="mailto:mcyzyk@gmail.com" target="_blank" class="x_moz-txt-link-freetext">mcyzyk@gmail.com</a>> wrote:</span></p>
</div>
<blockquote style="border:none; border-left:solid
#CCCCCC 1.0pt; padding:0in 0in 0in
6.0pt; margin-left:4.8pt; margin-right:0in">
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">Another clue, from the Log in the Solr Web GUI:<br>
<br>
<br>
</span></p>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<table class="x_MsoNormalTable" cellspacing="0" cellpadding="0" border="0" style="margin-left:.5in">
<tbody>
<tr>
<td style="padding:0in 0in
0in 0in">
<p class="x_MsoNormal"><span style="font-size:11.0pt">7/12/2023, 3:19:27 PM</span></p>
</td>
<td style="padding:0in 0in
0in 0in">
<p class="x_MsoNormal"><span style="font-size:11.0pt">WARN false</span></p>
</td>
<td style="padding:0in 0in
0in 0in">
<br>
</td>
<td style="padding:0in 0in
0in 0in">
<p class="x_MsoNormal"><span style="font-size:11.0pt">CoreContainer</span></p>
</td>
<td style="padding:0in 0in
0in 0in">
<p class="x_MsoNormal"><span style="font-size:11.0pt">Not all security plugins configured! authentication=disabled authorization=disabled. Solr is only as secure as you make it. Consider configuring authentication/authorization before exposing Solr to users
internal or external. See <a class="x_moz-txt-link-freetext" href="https://s.apache.org/solrsecurity" originalsrc="https://s.apache.org/solrsecurity" shash="CIec33/U84OvAZFUZNM3s09dhvSt62BaKOXHOuxRbXhEzW2oWt7Kv6mRwf/tFuQQg3doT/nRUGMg9q2YiyMZMQqQcAiogmrsGilxGB5GsdQAPFYklELco58EGgDF9LbtIG5d5ZGXOqtUScuH20F7JaCQIxjuM5Lg57B43wARmVo=">
https://s.apache.org/solrsecurity</a> for more info</span></p>
</td>
</tr>
</tbody>
</table>
</blockquote>
<p class="x_MsoNormal" style="margin-right:0in; margin-bottom:12.0pt; margin-left:.5in">
<span style="font-size:11.0pt"><br>
Maybe ASpace simply does not have permission to add to Solr? (And yet, this is just a warning. And yet, for the sake of replicability, this very same Solr setup worked in Vagrant during our last ASpace upgrade.)<br>
<br>
Here, setting up Solr in my Vagrant file (which I recently ran line-by-line, manually, without error):</span></p>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> solr_provision = <<SCRIPT<br>
cd /opt<br>
sudo wget <a href="https://archive.apache.org/dist/lucene/solr/8.10.0/solr-8.10.0.tgz" originalsrc="https://archive.apache.org/dist/lucene/solr/8.10.0/solr-8.10.0.tgz" shash="z9cZdXbe/ndXXjz9B2LeMh9QgjTJzkQ86MCERoOXCelNxYpIS1AONzOkQo4PUli3Aw4dXe8xkosIoPiGzCqUYsV9qS38flGYPPqluZsSCsvWMqkmNUbs6Rdxf6VVYh9oX7Atk6+PibtZj5tkihYPCnxAipBReEDnfXROY+xIUxY=" target="_blank" class="x_moz-txt-link-freetext">
https://archive.apache.org/dist/lucene/solr/8.10.0/solr-8.10.0.tgz</a><br>
sudo tar zxf solr-8.10.0.tgz<br>
sudo bash /opt/solr-8.10.0/bin/install_solr_service.sh /opt/solr-8.10.0.tgz<br>
sudo mkdir -p /opt/solr/server/solr/configsets/archivesspace/conf<br>
sudo cp -r /vagrant/archivesspace_CURRENT/solr/* /opt/solr/server/solr/configsets/archivesspace/conf/<br>
sudo chown -R solr:solr /opt/solr<br>
sudo su - solr -c "/opt/solr/bin/solr create -c archivesspace -p 8983 -d archivesspace"<br>
sudo systemctl restart solr <br>
SCRIPT</span></p>
</blockquote>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"><br>
Reading about Solr and Permissions....<br>
<br>
And sorry for all the emails in this thread. And yet, once this is resolved it may have value for others in future?<br>
<br>
Mark<br>
<br>
<br>
</span></p>
<pre style="margin-left:.5in"><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> </pre>
<pre style="margin-left:.5in">Mark Cyzyk, M.A., M.L.S.</pre>
<pre style="margin-left:.5in">Library Applications Group</pre>
<pre style="margin-left:.5in">The Sheridan Libraries</pre>
<pre style="margin-left:.5in">The Johns Hopkins University</pre>
<pre style="margin-left:.5in"><a href="mailto:mcyzyk@jhu.edu" target="_blank" class="x_moz-txt-link-freetext">mcyzyk@jhu.edu</a></pre>
<pre style="margin-left:.5in"> </pre>
<pre style="margin-left:.5in"> </pre>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">On 7/12/23 11:46 AM, Joshua D. Shaw wrote:</span></p>
</div>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:12.0pt; color:black">Hey Mark</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:12.0pt; color:black">After the updates you've made to the config, try shutting down AS and clearing the indexer state directories and restarting. That should tell AS to try a new index.</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:12.0pt; color:black">Also, I think that +0000 is just a timestamp offset. Its not counting the objects indexed. That log line looks something like: PUI Indexer ... indexed x of y resources</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:12.0pt; color:black">Joshua</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div class="x_MsoNormal" align="center" style="margin-left:.5in; text-align:center">
<span style="font-size:11.0pt">
<hr width="100%" size="0" align="center">
</span></div>
<div id="x_m_9044674422647143338m_6398207830784655580m_4501676620168833283m_-7203434989826652434divRplyFwdMsg">
<p class="x_MsoNormal" style="margin-left:.5in"><b><span style="font-size:11.0pt; color:black">From:</span></b><span style="font-size:11.0pt; color:black">
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank" class="x_moz-txt-link-freetext">
archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">
<archivesspace_users_group-bounces@lyralists.lyrasis.org></a> on behalf of Mark Cyzyk
<a href="mailto:mcyzyk@gmail.com" target="_blank"><mcyzyk@gmail.com></a><br>
<b>Sent:</b> Wednesday, July 12, 2023 11:32 AM<br>
<b>To:</b> Brian Hoffman <a href="mailto:brian.hoffman@lyrasis.org" target="_blank">
<brian.hoffman@lyrasis.org></a>; <a href="mailto:mcyzyk@jhu.edu" target="_blank" class="x_moz-txt-link-freetext">
mcyzyk@jhu.edu</a> <a href="mailto:mcyzyk@jhu.edu" target="_blank"><mcyzyk@jhu.edu></a>; Archivesspace Users Group
<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank">
<archivesspace_users_group@lyralists.lyrasis.org></a>; <a href="mailto:jesse.martinez@bc.edu" target="_blank" class="x_moz-txt-link-freetext">
jesse.martinez@bc.edu</a> <a href="mailto:jesse.martinez@bc.edu" target="_blank">
<jesse.martinez@bc.edu></a><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Staging upgrade using Vagrant/Virtualbox, data in MySQL tables, Solr core present, reindexed, yet no data displayed in ASpace application</span><span style="font-size:11.0pt">
</span></p>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
</div>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"><br>
Brian,<br>
<br>
I am trying to duplicate our Production ASpace 3.2.0 in a local Vagrant box so I can stage an upgrade to the latest codebase.<br>
<br>
<br>
</span></p>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in">Try uncommenting that line and changing it to:<span style="font-size:10.0pt"></span></p>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"> <span style="font-size:10.0pt"></span></p>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">AppConfig[:solr_url] =
<a href="http://localhost:8983/solr/archivesspace" target="_blank">"http://localhost:8983/solr/archivesspace"</a></span></p>
</blockquote>
<p class="x_MsoNormal" style="margin-right:0in; margin-bottom:12.0pt; margin-left:.5in">
<span style="font-size:11.0pt"><br>
Done. And yet:</span></p>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">************************************************************<br>
Welcome to ArchivesSpace!<br>
You can now point your browser to <a href="http://localhost:8080" target="_blank" class="x_moz-txt-link-freetext">
http://localhost:8080</a><br>
************************************************************<br>
I, [2023-07-12T15:28:45.335247 #51936] INFO -- : Thread-3306: PUI Indexer [2023-07-12 15:28:45 +0000] Running index round<br>
I, [2023-07-12T15:28:47.533454 #51936] INFO -- : Thread-3306: PUI Indexer [2023-07-12 15:28:47 +0000] Index round complete<br>
I, [2023-07-12T15:28:50.634218 #51936] INFO -- : Thread-2956: Staff Indexer [2023-07-12 15:28:50 +0000] Running index round<br>
I, [2023-07-12T15:28:52.715507 #51936] INFO -- : Thread-2956: Staff Indexer [2023-07-12 15:28:52 +0000] Index round complete</span></p>
</blockquote>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"><br>
Still +0000!<br>
<br>
Mark<br>
<br>
<br>
</span></p>
<pre style="margin-left:.5in"><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> </pre>
<pre style="margin-left:.5in">Mark Cyzyk, M.A., M.L.S.</pre>
<pre style="margin-left:.5in">Library Applications Group</pre>
<pre style="margin-left:.5in">The Sheridan Libraries</pre>
<pre style="margin-left:.5in">The Johns Hopkins University</pre>
<pre style="margin-left:.5in"><a href="mailto:mcyzyk@jhu.edu" target="_blank" class="x_moz-txt-link-freetext">mcyzyk@jhu.edu</a></pre>
<pre style="margin-left:.5in"> </pre>
<pre style="margin-left:.5in">Verba volant, scripta manent. </pre>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">On 7/12/23 11:10, Brian Hoffman wrote:</span></p>
</div>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in">Hi Mark,<span style="font-size:10.0pt"></span></p>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"> <span style="font-size:10.0pt"></span></p>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in">What version of ASpace are you using?
<span style="font-size:10.0pt"></span></p>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"> <span style="font-size:10.0pt"></span></p>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in">Try uncommenting that line and changing it to:<span style="font-size:10.0pt"></span></p>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"> <span style="font-size:10.0pt"></span></p>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"><span style="font-size:10.0pt">AppConfig[:solr_url] =
<a href="http://localhost:8983/solr/archivesspace" target="_blank">"http://localhost:8983/solr/archivesspace"</a></span></p>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"> <span style="font-size:10.0pt"></span></p>
<div style="border:none; border-top:solid
#B5C4DF
1.0pt; padding:3.0pt 0in
0in 0in">
<p style="margin-right:0in; margin-bottom:12.0pt; margin-left:.5in"><b><span style="font-size:12.0pt; color:black">From:
</span></b><span style="font-size:12.0pt; color:black">Mark Cyzyk <a href="mailto:mcyzyk@gmail.com" target="_blank">
<mcyzyk@gmail.com></a><br>
<b>Date: </b>Wednesday, July 12, 2023 at 10:59 AM<br>
<b>To: </b>Brian Hoffman <a href="mailto:brian.hoffman@lyrasis.org" target="_blank">
<brian.hoffman@lyrasis.org></a>, <a href="mailto:mcyzyk@jhu.edu" target="_blank" class="x_moz-txt-link-freetext">
mcyzyk@jhu.edu</a> <a href="mailto:mcyzyk@jhu.edu" target="_blank"><mcyzyk@jhu.edu></a>, Archivesspace Users Group
<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank">
<archivesspace_users_group@lyralists.lyrasis.org></a>, <a href="mailto:jesse.martinez@bc.edu" target="_blank" class="x_moz-txt-link-freetext">
jesse.martinez@bc.edu</a> <a href="mailto:jesse.martinez@bc.edu" target="_blank">
<jesse.martinez@bc.edu></a><br>
<b>Subject: </b>Re: [Archivesspace_Users_Group] Staging upgrade using Vagrant/Virtualbox, data in MySQL tables, Solr core present, reindexed, yet no data displayed in ASpace application</span><span style="font-size:10.0pt"></span></p>
</div>
<p style="margin-right:0in; margin-bottom:12.0pt; margin-left:.5in"><span style="font-size:10.0pt"><br>
Brian,<br>
<br>
That value, commented out because it's the default, in my config is:</span></p>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"><span style="font-size:10.0pt">## The ArchivesSpace Solr index listens on port 8090 by default. You can<br>
## set it to something else below.<br>
#AppConfig[:solr_url] = <a href="http://localhost:8090" target="_blank">"http://localhost:8090"</a></span></p>
</blockquote>
<p style="margin-right:0in; margin-bottom:12.0pt; margin-left:.5in"><span style="font-size:10.0pt"><br>
Mark<br>
<br>
</span></p>
<pre style="margin-left:.5in"><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> </pre>
<pre style="margin-left:.5in">Mark Cyzyk, M.A., M.L.S.</pre>
<pre style="margin-left:.5in">Library Applications Group</pre>
<pre style="margin-left:.5in">The Sheridan Libraries</pre>
<pre style="margin-left:.5in">The Johns Hopkins University</pre>
<pre style="margin-left:.5in"><a href="mailto:mcyzyk@jhu.edu" target="_blank" class="x_moz-txt-link-freetext">mcyzyk@jhu.edu</a></pre>
<pre style="margin-left:.5in"> </pre>
<pre style="margin-left:.5in">Verba volant, scripta manent. </pre>
<div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"><span style="font-size:10.0pt">On 7/12/23 10:34, Brian Hoffman wrote:</span></p>
</div>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in">Hi Mark,<span style="font-size:10.0pt"></span></p>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"> <span style="font-size:10.0pt"></span></p>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in">I am referring to the value for :solr_url in the file ‘config/config.rb’<span style="font-size:10.0pt"></span></p>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"> <span style="font-size:10.0pt"></span></p>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in">Brian<span style="font-size:10.0pt"></span></p>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"> <span style="font-size:10.0pt"></span></p>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"> <span style="font-size:10.0pt"></span></p>
<div style="border:none; border-top:solid
#B5C4DF
1.0pt; padding:3.0pt
0in 0in 0in">
<p style="margin-right:0in; margin-bottom:12.0pt; margin-left:.5in"><b><span style="font-size:12.0pt; color:black">From:
</span></b><span style="font-size:12.0pt; color:black">Mark Cyzyk <a href="mailto:mcyzyk@gmail.com" target="_blank">
<mcyzyk@gmail.com></a><br>
<b>Date: </b>Wednesday, July 12, 2023 at 10:32 AM<br>
<b>To: </b>Brian Hoffman <a href="mailto:brian.hoffman@lyrasis.org" target="_blank">
<brian.hoffman@lyrasis.org></a>, <a href="mailto:mcyzyk@jhu.edu" target="_blank" class="x_moz-txt-link-freetext">
mcyzyk@jhu.edu</a> <a href="mailto:mcyzyk@jhu.edu" target="_blank"><mcyzyk@jhu.edu></a>, Archivesspace Users Group
<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank">
<archivesspace_users_group@lyralists.lyrasis.org></a>, <a href="mailto:jesse.martinez@bc.edu" target="_blank" class="x_moz-txt-link-freetext">
jesse.martinez@bc.edu</a> <a href="mailto:jesse.martinez@bc.edu" target="_blank">
<jesse.martinez@bc.edu></a><br>
<b>Subject: </b>Re: [Archivesspace_Users_Group] Staging upgrade using Vagrant/Virtualbox, data in MySQL tables, Solr core present, reindexed, yet no data displayed in ASpace application</span><span style="font-size:10.0pt"></span></p>
</div>
<p style="margin-right:0in; margin-bottom:12.0pt; margin-left:.5in">Thanks, Brian,<br>
<br>
Here is what I see on screen:<br>
<br>
<img id="x_m_9044674422647143338m_6398207830784655580m_4501676620168833283m_-7203434989826652434x__x005f_x0000_i1025" class="" width="1915" height="720" border="0" style="width:19.9479in; height:7.5in" data-outlook-trace="F:1|T:1" src="cid:part1.4gHmpx90.he5s8EJr@gmail.com"><br>
<br>
<span style="font-size:10.0pt"></span></p>
<pre style="margin-left:.5in"><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> </pre>
<pre style="margin-left:.5in">Mark Cyzyk, M.A., M.L.S.</pre>
<pre style="margin-left:.5in">Library Applications Group</pre>
<pre style="margin-left:.5in">The Sheridan Libraries</pre>
<pre style="margin-left:.5in">The Johns Hopkins University</pre>
<pre style="margin-left:.5in"><a href="mailto:mcyzyk@jhu.edu" target="_blank" class="x_moz-txt-link-freetext">mcyzyk@jhu.edu</a></pre>
<pre style="margin-left:.5in"> </pre>
<pre style="margin-left:.5in">Verba volant, scripta manent. </pre>
<div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in">On 7/12/23 10:24, Brian Hoffman wrote:<span style="font-size:10.0pt"></span></p>
</div>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in">Hi Mark,<span style="font-size:10.0pt"></span></p>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"> <span style="font-size:10.0pt"></span></p>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in">I believe you have incorrectly set the solr url to a screen on the control panel.<span style="font-size:10.0pt"></span></p>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"> <span style="font-size:10.0pt"></span></p>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in">Try replacing:<br>
<br>
<span style="font-size:10.0pt"><a href="http://localhost:8983/solr/#/~cores/archivesspace" target="_blank" title="http://localhost:8983/solr/#/~cores/archivesspace"><span style="font-size:12.0pt">http://localhost:8983/solr/#/~cores/archivesspace</span></a><br>
<br>
with </span></p>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"><span style="font-size:10.0pt"> </span></p>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"><span style="font-size:10.0pt"><a href="http://localhost:8983/solr/#/~cores/archivesspace" target="_blank" title="http://localhost:8983/solr/#/~cores/archivesspace"><span style="font-size:12.0pt">http://localhost:8983/solr/archivesspace</span></a></span></p>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"> <span style="font-size:10.0pt"></span></p>
<div style="border:none; border-top:solid
#B5C4DF
1.0pt; padding:3.0pt
0in 0in 0in">
<p style="margin-right:0in; margin-bottom:12.0pt; margin-left:.5in"><b><span style="font-size:12.0pt; color:black">From:
</span></b><span style="font-size:12.0pt; color:black"><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank" class="x_moz-txt-link-freetext">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">
<archivesspace_users_group-bounces@lyralists.lyrasis.org></a> on behalf of Mark Cyzyk
<a href="mailto:mcyzyk@gmail.com" target="_blank"><mcyzyk@gmail.com></a><br>
<b>Date: </b>Wednesday, July 12, 2023 at 10:19 AM<br>
<b>To: </b><a href="mailto:jesse.martinez@bc.edu" target="_blank" class="x_moz-txt-link-freetext">jesse.martinez@bc.edu</a>
<a href="mailto:jesse.martinez@bc.edu" target="_blank"><jesse.martinez@bc.edu></a>,
<a href="mailto:mcyzyk@jhu.edu" target="_blank" class="x_moz-txt-link-freetext">mcyzyk@jhu.edu</a>
<a href="mailto:mcyzyk@jhu.edu" target="_blank"><mcyzyk@jhu.edu></a><br>
<b>Cc: </b>Archivesspace Users Group <a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank">
<archivesspace_users_group@lyralists.lyrasis.org></a><br>
<b>Subject: </b>Re: [Archivesspace_Users_Group] Staging upgrade using Vagrant/Virtualbox, data in MySQL tables, Solr core present, reindexed, yet no data displayed in ASpace application</span><span style="font-size:10.0pt"></span></p>
</div>
<p style="margin-right:0in; margin-bottom:12.0pt; margin-left:.5in">Darn:<br>
<br>
<br>
<br>
<span style="font-size:10.0pt"></span></p>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<pre style="margin-left:.5in"><code>{</code></pre>
<pre style="margin-left:.5in"><code> "</code>responseHeader<code>":</code>{</pre>
<pre style="margin-left:.5in"> "status":0,</pre>
<pre style="margin-left:.5in"> "QTime":187,</pre>
<pre style="margin-left:.5in"> "params":{</pre>
<pre style="margin-left:.5in"> "q":"*:*",</pre>
<pre style="margin-left:.5in"> "indent":"true",</pre>
<pre style="margin-left:.5in"> "q.op":"OR",</pre>
<pre style="margin-left:.5in"> "_":"1689171084647"}}<code>,</code></pre>
<pre style="margin-left:.5in"><code> "</code>response<code>":</code>{"numFound":0,"start":0,"numFoundExact":true,"docs":[]</pre>
<pre style="margin-left:.5in"> }}</pre>
</blockquote>
<p style="margin-right:0in; margin-bottom:12.0pt; margin-left:.5in"><br>
I will look more carefully at my Solr Aspace config (and yet the steps in my Vagrant file for setting this up are the same as last summer when I did this!).<br>
<br>
Mark<br>
<br>
<br>
<span style="font-size:10.0pt"></span></p>
<pre style="margin-left:.5in"><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> </pre>
<pre style="margin-left:.5in">Mark Cyzyk, M.A., M.L.S.</pre>
<pre style="margin-left:.5in">Library Applications Group</pre>
<pre style="margin-left:.5in">The Sheridan Libraries</pre>
<pre style="margin-left:.5in">The Johns Hopkins University</pre>
<pre style="margin-left:.5in"><a href="mailto:mcyzyk@jhu.edu" target="_blank" class="x_moz-txt-link-freetext">mcyzyk@jhu.edu</a></pre>
<pre style="margin-left:.5in"> </pre>
<pre style="margin-left:.5in">Verba volant, scripta manent. </pre>
<div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in">On 7/12/23 10:09, Jesse Martinez wrote:<span style="font-size:10.0pt"></span></p>
</div>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in">Thanks for sharing that, Mark!
<span style="font-size:10.0pt"></span></p>
<div>
<div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"> <span style="font-size:10.0pt"></span></p>
</div>
<div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in">I have another quick follow up question.<span style="font-size:10.0pt"></span></p>
</div>
<div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"> <span style="font-size:10.0pt"></span></p>
</div>
<div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in">What do you see when you run a solr search like this one:<span style="font-size:10.0pt"></span></p>
</div>
<div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"> <span style="font-size:10.0pt"></span></p>
</div>
<div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"><a href="http://localhost:8983/solr/#/archivesspace/query?q=*:*&q.op=OR&indent=true" target="_blank">http://localhost:8983/solr/#/archivesspace/query?q=*:*&q.op=OR&indent=true</a><span style="font-size:10.0pt"></span></p>
</div>
</div>
<div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"> <span style="font-size:10.0pt"></span></p>
</div>
<div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in">You should see all your indexed records. But if you don't see any results then it may indicate that your archivesspace configuration directory is not correct. <span style="font-size:10.0pt"></span></p>
</div>
<div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"> <span style="font-size:10.0pt"></span></p>
</div>
<div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in">Jesse<span style="font-size:10.0pt"></span></p>
</div>
</div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"> <span style="font-size:10.0pt"></span></p>
<div>
<div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in">On Wed, Jul 12, 2023 at 10:05 AM Mark Cyzyk <<a href="mailto:mcyzyk@gmail.com" target="_blank" class="x_moz-txt-link-freetext">mcyzyk@gmail.com</a>> wrote:<span style="font-size:10.0pt"></span></p>
</div>
<blockquote style="border:none; border-left:solid
#CCCCCC
1.0pt; padding:0in
0in 0in
6.0pt; margin-left:4.8pt; margin-top:5.0pt; margin-right:0in; margin-bottom:5.0pt">
<div>
<p style="margin-right:0in; margin-bottom:12.0pt; margin-left:.5in"><br>
Thanks, Jesse,<br>
<br>
Here is the output of those commands:<span style="font-size:10.0pt"></span></p>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in">ps aux | grep solr | grep -v grep<br>
solr 898 0.0 0.1 19096 9812 ? Ss Jul11 0:00 /lib/systemd/systemd --user<br>
solr 910 0.0 0.0 169492 3368 ? S Jul11 0:00 (sd-pam)<br>
solr 1223 0.5 12.5 4018692 742508 ? Sl Jul11 7:41 java -server -Xms512m -Xmx512m -XX:+UseG1GC -XX:+PerfDisableSharedMem -XX:+ParallelRefProcEnabled -XX:MaxGCPauseMillis=250 -XX:+UseLargePages -XX:+AlwaysPreTouch -XX:+ExplicitGCInvokesConcurrent
-verbose:gc -XX:+PrintHeapAtGC -XX:+PrintGCDetails -XX:+PrintGCDateStamps -XX:+PrintGCTimeStamps -XX:+PrintTenuringDistribution -XX:+PrintGCApplicationStoppedTime -Xloggc:/var/solr/logs/solr_gc.log -XX:+UseGCLogFileRotation -XX:NumberOfGCLogFiles=9 -XX:GCLogFileSize=20M
-Dsolr.jetty.inetaccess.includes= -Dsolr.jetty.inetaccess.excludes= -Dsolr.log.dir=/var/solr/logs -Djetty.port=8983 -DSTOP.PORT=7983 -DSTOP.KEY=solrrocks -Duser.timezone=UTC -XX:-OmitStackTraceInFastThrow -XX:OnOutOfMemoryError=/opt/solr/bin/oom_solr.sh 8983
/var/solr/logs -Djetty.home=/opt/solr/server -Dsolr.solr.home=/var/solr/data -Dsolr.data.home= -Dsolr.install.dir=/opt/solr -Dsolr.default.confdir=/opt/solr/server/solr/configsets/_default/conf -Dlog4j.configurationFile=/var/solr/log4j2.xml -Xss256k -Dsolr.log.muteconsole
-jar start.jar --module=http --module=gzip<span style="font-size:10.0pt"></span></p>
</blockquote>
<p style="margin-right:0in; margin-bottom:12.0pt; margin-left:.5in">Puzzling!<br>
<br>
Mark<br>
<br>
<br>
<span style="font-size:10.0pt"></span></p>
<pre style="margin-left:.5in"><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> </pre>
<pre style="margin-left:.5in">Mark Cyzyk, M.A., M.L.S.</pre>
<pre style="margin-left:.5in">Library Applications Group</pre>
<pre style="margin-left:.5in">The Sheridan Libraries</pre>
<pre style="margin-left:.5in">The Johns Hopkins University</pre>
<pre style="margin-left:.5in"><a href="mailto:mcyzyk@jhu.edu" target="_blank" class="x_moz-txt-link-freetext">mcyzyk@jhu.edu</a></pre>
<pre style="margin-left:.5in"> </pre>
<pre style="margin-left:.5in">Verba volant, scripta manent. </pre>
<div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in">On 7/12/23 09:52, Jesse Martinez wrote:<span style="font-size:10.0pt"></span></p>
</div>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"><span style="font-size:10.0pt">ps aux | grep solr | grep -v grep</span></p>
</blockquote>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"> <span style="font-size:10.0pt"></span></p>
</div>
</blockquote>
</div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"><br clear="all">
<span style="font-size:10.0pt"></span></p>
<div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"> <span style="font-size:10.0pt"></span></p>
</div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in">-- <span style="font-size:10.0pt">
</span></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in">Jesse Martinez<span style="font-size:10.0pt"></span></p>
</div>
<div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in">Senior Library Applications Developer<span style="font-size:10.0pt"></span></p>
</div>
<div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in">O'Neill Library, Boston College<span style="font-size:10.0pt"></span></p>
</div>
<div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"><a href="mailto:jesse.martinez@bc.edu" target="_blank" class="x_moz-txt-link-freetext">jesse.martinez@bc.edu</a><span style="font-size:10.0pt"></span></p>
</div>
<div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in">617-552-2509<span style="font-size:10.0pt"></span></p>
</div>
<div>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in">he/him/his<span style="font-size:10.0pt"></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"> <span style="font-size:10.0pt"></span></p>
</blockquote>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"> <span style="font-size:10.0pt"></span></p>
</blockquote>
<p style="margin-right:0in; margin-bottom:0in; margin-left:.5in"> <span style="font-size:10.0pt"></span></p>
</div>
</blockquote>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
</div>
</blockquote>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
</div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank" class="x_moz-txt-link-freetext">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" originalsrc="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" shash="YZUNYjmrAotLIYmtMNbNAtuddWOdvDKchJ30NqG0msqMkmy29ArZrrf6S24sVLmxoRO4Kl14nflVVBx6rX2bH5eUsmaTbRq2sM/wfPk1V32nGEGh4JdcFcLuU7FzrlfuOJQPnXEQGgiWalHEcTVKvU+7UCQVwfE5Ystr19E8aCU=" target="_blank" class="x_moz-txt-link-freetext">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a></span></p>
</blockquote>
</div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"><br clear="all">
</span></p>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
</div>
<p class="x_MsoNormal" style="margin-left:.5in"><span class="x_gmailsignatureprefix"><span style="font-size:11.0pt">--
</span></span><span style="font-size:11.0pt"></span></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">Jesse Martinez</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">Senior Library Applications Developer</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">O'Neill Library, Boston College</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"><a href="mailto:jesse.martinez@bc.edu" target="_blank" class="x_moz-txt-link-freetext">jesse.martinez@bc.edu</a></span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">617-552-2509</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">he/him/his</span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
</blockquote>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
</div>
</blockquote>
</div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"><br clear="all">
</span></p>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
</div>
<p class="x_MsoNormal" style="margin-left:.5in"><span class="x_gmailsignatureprefix"><span style="font-size:11.0pt">--
</span></span><span style="font-size:11.0pt"></span></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">Jesse Martinez</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">Senior Library Applications Developer</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">O'Neill Library, Boston College</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"><a href="mailto:jesse.martinez@bc.edu" target="_blank" class="x_moz-txt-link-freetext">jesse.martinez@bc.edu</a></span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">617-552-2509</span></p>
</div>
<div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt">he/him/his</span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
</blockquote>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
</blockquote>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
<div style="border:solid #9C6500 1.0pt; padding:2.0pt
2.0pt 2.0pt 2.0pt">
<p class="x_MsoNormal" style="margin-left:.5in; line-height:12.0pt; background:#FFEB9C">
<b><span style="color:#9C6500">CAUTION:</span></b><span style="color:black"> This email originated from outside of the organization. Please don't click links, open attachments, or reply with confidential details unless you are certain you know the sender and
are expecting the content.</span></p>
</div>
<p class="x_MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt"> </span></p>
</div>
</div>
</div>
</blockquote>
<br>
</blockquote>
<br>
</blockquote>
<br>
</div>
</body>
</html>