<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<p>There is a bug involving the "deleted_records" table that can
cause records to disappear after a re-index:</p>
<p><br>
</p>
<p><a class="moz-txt-link-freetext" href="https://archivesspace.atlassian.net/browse/ANW-1607">https://archivesspace.atlassian.net/browse/ANW-1607</a><br>
</p>
<p><br>
</p>
<p>But it only affects things that have been transferred from one
repository to another, then back again. And that doesn't apply to
subjects, as they don't belong to any one repository. There could
be another mechanism to trigger than same bug for subjects, if so
the SQL file attached to that issue could be adapted to find and
fix them.<br>
</p>
<p><br>
</p>
<p>If subjects are missing from the public interface but not from
the staff interface, then it is a problem with the indexer, or the
code it calls to check that each subject is linked to at least one
published record.<br>
</p>
<p><br>
</p>
<p>Andrew.</p>
<p><br>
</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 17/10/2022 17:48, Blake Carver
wrote:<br>
</div>
<blockquote type="cite" cite="mid:DM6PR22MB23096FC5F9DE0A4BD553C0CD9F299@DM6PR22MB2309.namprd22.prod.outlook.com">
<style type="text/css" style="display:none;">P {margin-top:0;margin-bottom:0;}</style>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
</div>
<div style="word-wrap:break-word" lang="EN-US">
<div class="x_WordSection1">
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt;
font-family: Calibri, sans-serif;">
</p>
<p class="x_MsoNormal elementToProof" style="margin: 0in;
font-size: 11pt; font-family: Calibri, sans-serif;">
>> We recently tried a hard re-index and discovered
that for the PUI, subjects linked only to digital objects
were not re-indexed and dropped from the PUI. Is this
expected behavior?</p>
<p class="x_MsoNormal elementToProof" style="margin: 0in;
font-size: 11pt; font-family: Calibri, sans-serif;">
<br>
</p>
<p class="x_MsoNormal elementToProof" style="margin: 0in;
font-size: 11pt; font-family: Calibri, sans-serif;">
Maybe related to what's in your deleted_records table? How
many rows in that table?</p>
<p class="x_MsoNormal elementToProof" style="margin: 0in;
font-size: 11pt; font-family: Calibri, sans-serif;">
</p>
<p class="x_MsoNormal elementToProof" style="margin: 0in;
font-size: 11pt; font-family: Calibri, sans-serif;">
>> Related, is there a table/tables in the dbase that
tell Solr when to index that we could investigate,</p>
<p class="x_MsoNormal elementToProof" style="margin: 0in;
font-size: 11pt; font-family: Calibri, sans-serif;">
<br>
</p>
<p class="x_MsoNormal elementToProof" style="margin: 0in;
font-size: 11pt; font-family: Calibri, sans-serif;">
Many things have a system_mtime that you can set to NOW().</p>
<p class="x_MsoNormal elementToProof" style="margin: 0in;
font-size: 11pt; font-family: Calibri, sans-serif;">
<br>
</p>
<p class="x_MsoNormal" style="margin: 0in; font-size: 11pt;
font-family: Calibri, sans-serif;">
</p>
</div>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Archivesspace_Users_Group mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org">Archivesspace_Users_Group@lyralists.lyrasis.org</a>
<a class="moz-txt-link-freetext" href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a>
</pre>
</blockquote>
</body>
</html>