<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<p>You might find some tips by reading this thread from a little
over a year ago:</p>
<p><a class="moz-txt-link-freetext" href="http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/2021-December/008848.html">http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/2021-December/008848.html</a></p>
<p>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.<br>
</p>
<p>Andrew.</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 06/01/2023 17:26, Kara Hart wrote:<br>
</div>
<blockquote type="cite" cite="mid:CAKRVKBpW8ODh+yWuH_gM83Vmy=CT0Xdafq7+ehpGTaVOmTmoDA@mail.gmail.com">
<div dir="ltr">
<div class="gmail_default" style="font-family:arial,sans-serif;font-size:small;color:#000000">My
Archives staff are reporting issues with a newly added
collection's content (series, files, etc) not displaying in
the PUI. </div>
<div class="gmail_default" style="font-family:arial,sans-serif;font-size:small;color:#000000">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. </div>
<div class="gmail_default" style="font-family:arial,sans-serif;font-size:small;color:#000000"><br>
</div>
<div class="gmail_default" style="font-family:arial,sans-serif;font-size:small;color:#000000"><br>
</div>
<div class="gmail_default" style="font-family:arial,sans-serif;font-size:small;color:#000000">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.</div>
<div class="gmail_default" style="font-family:arial,sans-serif;font-size:small;color:#000000">Is
this an indexing problem, should I fire off a full
reindexing? Is there something bigger happening? </div>
<div class="gmail_default" style="font-family:arial,sans-serif;font-size:small;color:#000000">Thanks
for any advice,</div>
<div class="gmail_default" style="font-family:arial,sans-serif;font-size:small;color:#000000">Kara</div>
<div class="gmail_default" style="font-family:arial,sans-serif;font-size:small;color:#000000"><br>
</div>
<div class="gmail_default" style="font-family:arial,sans-serif;font-size:small;color:#000000">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)<br>
E, [2023-01-06T12:21:32.661982 #2142] ERROR -- : Thread-2296:
org/jruby/RubyIO.java:2674:in `readline'<br>
/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'<br>
org/jruby/RubyIO.java:1171:in `open'<br>
/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'<br>
/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'<br>
/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'<br>
/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'<br>
E, [2023-01-06T12:21:32.662160 #2142] ERROR -- : Thread-2296:
#<EOFError: End of file reached><br>
E, [2023-01-06T12:21:32.669214 #2142] ERROR -- : Thread-2016:
org/jruby/RubyIO.java:2674:in `readline'<br>
/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'<br>
org/jruby/RubyIO.java:1171:in `open'<br>
/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'<br>
/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'<br>
/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'<br>
/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'<br>
E, [2023-01-06T12:21:32.669343 #2142] ERROR -- : Thread-2016:
#<EOFError: End of file reached><br>
</div>
<div>
<div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature">
<div dir="ltr">
<div>
<p class="MsoNormal">~~~~~ <span style="font-family:arial;color:rgb(39,78,19)">Kara
S. Hart </span></p>
</div>
<div>
<div style="font-family:arial"><font size="2" color="#274e13"><font>Systems Librarian - Library
& Technology Services
<div style="font-family:arial,helvetica,sans-serif;display:inline">- </div>
</font>Wellesley College</font></div>
<div style="font-family:arial;font-size:small">
<div><font size="1"><br>
</font></div>
<div><font size="1" color="#6aa84f"><font face="verdana, sans-serif">*** </font>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 <a href="http://wellesley.edu" target="_blank" moz-do-not-send="true">wellesley.edu</a> domain,
DO NOT provide your password. LTS will never ask
for your passwords -- when in doubt, contact the
LTS Help Desk.</font></div>
</div>
</div>
</div>
</div>
</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>