<div dir="ltr">Thanks, Blake. We actually got hit with this yesterday and I did not see your message. A quick Google search found the issue, however.<div><br></div><div>What do other sites do to mitigate this? Does everyone just wait until after the DST change to see if things broke? Or are they ways to proactively mitigate this? </div><div><br></div><div>Also, can I expect the same thing when we "Fall back"? Or is this somehow just a Spring issue?</div><div><br></div><div>Thanks,</div><div>Tom</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sun, Mar 13, 2022 at 2:34 PM Blake Carver <<a href="mailto:blake.carver@lyrasis.org">blake.carver@lyrasis.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
Yet another reason to hate Daylight Savings Time...
<div>Some of you may notice troubles this morning. There's a weird little bug that happens when the clocks change. It doesn't hit ALL sites, but we had some hosted sites hit this year for the first time, so I thought I'd put this at the top O' the list.</div>
<div><br>
</div>
<div>There's a JIRA here:</div>
<div><a href="https://archivesspace.atlassian.net/browse/ANW-1229" target="_blank">https://archivesspace.atlassian.net/browse/ANW-1229</a></div>
<div><br>
</div>
<div>It's PROBABLY the search_indexer user, and can be fixed by doing:</div>
<div>UPDATE user set user_mtime = NOW(), system_mtime=NOW() where username='search_indexer';</div>
<div><br>
</div>
<div>You might need to restart after updating the user</div>
<div><br>
</div>
<div>If you're not quite so lucky, it could be hiding elsewhere, another user, or an AO or a Date.</div>
<div><br>
</div>
<div>-- AO</div>
<div>update archival_object set create_time = '2022-03-13 06:00:00', system_mtime = '2022-03-13 06:00:00'</div>
<div>where create_time >= '2022-03-13 02:00:00' and create_time <= '2022-03-13 03:00:00';</div>
<div>-- DATE</div>
<div>update `date` set create_time = '2022-03-13 06:00:00', system_mtime = '2022-03-13 06:00:00'</div>
<div>where create_time >= '2022-03-13 02:00:00' and create_time <= '2022-03-13 03:00:00';</div>
<div>-- USER</div>
<div>UPDATE user set user_mtime = NOW(), system_mtime=NOW() where username='SOME_OTHER_USER';</div>
<span> </span>
<div>
<div>
<div>
<div dir="ltr" style="color:rgb(0,0,0);background-color:rgb(255,255,255)">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif;margin:0px">
<span style="font-size:14.6667px">
<div><br>
</div>
</span></div>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div><b style="font-family:arial,helvetica,sans-serif;font-size:12.7273px;color:rgb(136,136,136)">Tom Hanstra</b><br></div><div style="color:rgb(136,136,136);font-size:12.8px"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div style="font-size:12.7273px"><div><div><i style="font-size:12.7273px;font-family:arial,helvetica,sans-serif">Sr. Systems Administrator</i></div><div><a href="mailto:hanstra@nd.edu" style="color:rgb(17,85,204);font-size:12.7273px;font-family:arial,helvetica,sans-serif" target="_blank">hanstra@nd.edu</a><br></div></div><div><span style="font-family:arial,helvetica,sans-serif"><br></span></div></div><div style="font-size:12.7273px"><img src="https://docs.google.com/uc?export=download&id=1GFX1KaaMTtQ2Kg2u8bMXt1YwBp96bvf0&revid=0B7APN9POn6xAQ244WWFYMFU3aVJwZ0lxbmVHK3FxNXlCd0RRPQ"><br></div></div></div></div></div></div></div></div></div></div></div>