[Archivesspace_Users_Group] Contents not displaying, Top Containers not searchable and errors in log

[Andrew Morrison]

You might find some tips by reading this thread from a little over a 
year ago:

http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/2021-December/008848.html

In your case, the affected user is the one with the ID of 2, which is 
the "search_indexer" user. The indexer has to log in to the backend to 
get new/modified records to index them. Part of the logging-in process 
is updating the user table. So, if that is being blocked, new/modified 
records won't appear in the PUI.

Andrew.


On 06/01/2023 17:26, Kara Hart wrote:
> My Archives staff are reporting issues with a newly added collection's 
> content (series, files, etc) not displaying in the PUI.
> Also when creating top containers for some records, they do not show 
> up in Manage Top Containers search results when searching by Resources 
> title.  I can search by container name and see a result but no 
> resource is listed.
>
>
> I'm seeing the below errors and warnings repeated in my log file. 
> Optimistic locking error but no record to look at?  And then a few 
> related to the index_state.
> Is this an indexing problem, should I fire off a full reindexing?  Is 
> there something bigger happening?
> Thanks for any advice,
> Kara
>
> W, [2023-01-06T12:21:32.637746 #2142]  WARN -- : Thread-16226: Got an 
> optimistic locking error when updating user: Attempt to update object 
> did not result in a single row modification (SQL: UPDATE `user` SET 
> `system_mtime` = '2023-01-06 17:21:32', `user_mtime` = '2023-01-06 
> 17:21:32', `lock_version` = 34391 WHERE ((`id` = 2) AND 
> (`lock_version` = 34390)) LIMIT 1)
> E, [2023-01-06T12:21:32.661982 #2142] ERROR -- : Thread-2296: 
> org/jruby/RubyIO.java:2674:in `readline'
> /var/local/archivesspace/data/tmp/jetty-0.0.0.0-8091-indexer.war-_aspace-indexer-any-/webapp/WEB-INF/app/lib/index_state.rb:31:in 
> `block in get_last_mtime'
> org/jruby/RubyIO.java:1171:in `open'
> /var/local/archivesspace/data/tmp/jetty-0.0.0.0-8091-indexer.war-_aspace-indexer-any-/webapp/WEB-INF/app/lib/index_state.rb:30:in 
> `get_last_mtime'
> /var/local/archivesspace/data/tmp/jetty-0.0.0.0-8091-indexer.war-_aspace-indexer-any-/webapp/WEB-INF/app/lib/periodic_indexer.rb:89:in 
> `run_index_round'
> /var/local/archivesspace/data/tmp/jetty-0.0.0.0-8091-indexer.war-_aspace-indexer-any-/webapp/WEB-INF/app/lib/periodic_indexer.rb:210:in 
> `run'
> /var/local/archivesspace/data/tmp/jetty-0.0.0.0-8091-indexer.war-_aspace-indexer-any-/webapp/WEB-INF/app/main.rb:45:in 
> `block in main'
> E, [2023-01-06T12:21:32.662160 #2142] ERROR -- : Thread-2296: 
> #<EOFError: End of file reached>
> E, [2023-01-06T12:21:32.669214 #2142] ERROR -- : Thread-2016: 
> org/jruby/RubyIO.java:2674:in `readline'
> /var/local/archivesspace/data/tmp/jetty-0.0.0.0-8091-indexer.war-_aspace-indexer-any-/webapp/WEB-INF/app/lib/index_state.rb:31:in 
> `block in get_last_mtime'
> org/jruby/RubyIO.java:1171:in `open'
> /var/local/archivesspace/data/tmp/jetty-0.0.0.0-8091-indexer.war-_aspace-indexer-any-/webapp/WEB-INF/app/lib/index_state.rb:30:in 
> `get_last_mtime'
> /var/local/archivesspace/data/tmp/jetty-0.0.0.0-8091-indexer.war-_aspace-indexer-any-/webapp/WEB-INF/app/lib/periodic_indexer.rb:89:in 
> `run_index_round'
> /var/local/archivesspace/data/tmp/jetty-0.0.0.0-8091-indexer.war-_aspace-indexer-any-/webapp/WEB-INF/app/lib/periodic_indexer.rb:210:in 
> `run'
> /var/local/archivesspace/data/tmp/jetty-0.0.0.0-8091-indexer.war-_aspace-indexer-any-/webapp/WEB-INF/app/main.rb:32:in 
> `block in main'
> E, [2023-01-06T12:21:32.669343 #2142] ERROR -- : Thread-2016: 
> #<EOFError: End of file reached>
>
> ~~~~~ Kara S. Hart
>
> Systems Librarian - Library & Technology Services
> -
> Wellesley College
>
> *** Many people want your password so they can steal your information. 
> If an email asks you to send your password or directs you to a page 
> that is NOT in the wellesley.edu <http://wellesley.edu> domain, DO NOT 
> provide your password. LTS will never ask for your passwords -- when 
> in doubt, contact the LTS Help Desk.
>
> _______________________________________________
> 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/20230109/0bbe1f8c/attachment.html>