[Archivesspace_Users_Group] No records found

[Busch, Ed]

Related to this we see in the logs “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;”

We’re running v2.7.1. Anyone else seeing this?

Ed Busch, MLIS
Interim Head of University Archives and Electronic Records Archivist
Michigan State University Archives and Historical Collections
Conrad Hall
943 Conrad Road, Room 101
East Lansing, MI 48824
517-884-6438
buschedw at msu.edu<mailto:buschedw at msu.edu>
he/him/his


From: <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Andrew Morrison <andrew.morrison at bodleian.ox.ac.uk>
Reply-To: "archivesspace_users_group at lyralists.lyrasis.org" <archivesspace_users_group at lyralists.lyrasis.org>
Date: Monday, August 17, 2020 at 8:53 AM
To: "archivesspace_users_group at lyralists.lyrasis.org" <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] No records found


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.

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 AppConfig[:indexer_solr_timeout_seconds] in your config.rb file and then trigger a re-index<https://urldefense.com/v3/__https:/archivesspace.github.io/archivesspace/user/re-creating-indexes/__;!!HXCxUKc!mb7xFMumXIwbUm5AB66GCJSR-Fcrh_7b8c8XmDME-aqkj_B5NHF7aCyiMIFhfOw$>.

Also try monitoring the application log file while the indexer is running. Errors messages there could help with further diagnosis.

Andrew.


On 14/08/2020 16:10, Busch, Ed wrote:
Hi-

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.

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.

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.

Ed Busch, MLIS
Interim Head of University Archives and Electronic Records Archivist
Michigan State University Archives and Historical Collections
Conrad Hall
943 Conrad Road, Room 101
East Lansing, MI 48824
517-884-6438
buschedw at msu.edu<mailto:buschedw at msu.edu>
he/him/his




_______________________________________________

Archivesspace_Users_Group mailing list

Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:Archivesspace_Users_Group at lyralists.lyrasis.org>

http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<https://urldefense.com/v3/__http:/lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group__;!!HXCxUKc!mb7xFMumXIwbUm5AB66GCJSR-Fcrh_7b8c8XmDME-aqkj_B5NHF7aCyi6Wqcb84$>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20200818/05fdc32d/attachment.html>