[Archivesspace_Users_Group] 'Tis The Season For Ye Ol' "HOUR_OF_DAY: 2 -> 3" Error :-(

[Tom Hanstra]

Thanks, Blake. We actually got hit with this yesterday and I did not see
your message. A quick Google search found the issue, however.

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?

Also, can I expect the same thing when we "Fall back"?  Or is this somehow
just a Spring issue?

Thanks,
Tom

On Sun, Mar 13, 2022 at 2:34 PM Blake Carver <blake.carver at lyrasis.org>
wrote:

> Yet another reason to hate Daylight Savings Time...
> 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.
>
> There's a JIRA here:
> https://archivesspace.atlassian.net/browse/ANW-1229
>
> It's PROBABLY the search_indexer user, and can be fixed by doing:
> UPDATE user set user_mtime = NOW(), system_mtime=NOW() where
> username='search_indexer';
>
> You might need to restart after updating the user
>
> If you're not quite so lucky, it could be hiding elsewhere, another user,
> or an AO or a Date.
>
> -- AO
> update archival_object set create_time = '2022-03-13 06:00:00',
> system_mtime = '2022-03-13 06:00:00'
> where create_time >= '2022-03-13 02:00:00' and create_time <= '2022-03-13
> 03:00:00';
> -- DATE
> update `date` set create_time = '2022-03-13 06:00:00', system_mtime =
> '2022-03-13 06:00:00'
> where create_time >= '2022-03-13 02:00:00' and create_time <= '2022-03-13
> 03:00:00';
> -- USER
> UPDATE user set user_mtime = NOW(), system_mtime=NOW() where
> username='SOME_OTHER_USER';
>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>


-- 
*Tom Hanstra*
*Sr. Systems Administrator*
hanstra at nd.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20220314/6a2604ac/attachment.html>