<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I think it's just a spring thing? Though I can't remember, pretty sure at least.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
This year it would seem to be a more widespread problem that previous years, though I don't know if that's something to do with the new version, or just bad luck.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
It seems like in the past it was rather rare, and this year, maybe not so rare?</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I haven't seen anyway to proactively mitigate the problem. </div>
<div id="appendonsend"></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Tom Hanstra
<hanstra@nd.edu><br>
<b>Sent:</b> Monday, March 14, 2022 9:42 AM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] 'Tis The Season For Ye Ol' "HOUR_OF_DAY: 2 -> 3" Error :-(</font>
<div> </div>
</div>
<div>
<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="x_gmail_quote">
<div dir="ltr" class="x_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="x_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="x_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="x_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" target="_blank" style="color:rgb(17,85,204); font-size:12.7273px; font-family:arial,helvetica,sans-serif">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>
</div>
</body>
</html>