[Archivesspace_Users_Group] Hard re-indexing question

[Andrew Morrison]

There is a bug involving the "deleted_records" table that can cause 
records to disappear after a re-index:


https://archivesspace.atlassian.net/browse/ANW-1607


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.


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.


Andrew.



On 17/10/2022 17:48, Blake Carver wrote:
>
> >> 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?
>
>
> Maybe related to what's in your deleted_records table? How many rows 
> in that table?
>
> >> Related, is there a table/tables in the dbase that tell Solr when 
> to index that we could investigate,
>
>
> Many things have a system_mtime that you can set to NOW().
>
>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20221018/79a9cd82/attachment.html>