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@lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
_______________________________________________
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group@lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group

Reply via email to