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

[Blake Carver]

I think it's just a spring thing? Though I can't remember, pretty sure at least.
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.
It seems like in the past it was rather rare, and this year, maybe not so rare?

I haven't seen anyway to proactively mitigate the problem.

________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Tom Hanstra <hanstra at nd.edu>
Sent: Monday, March 14, 2022 9:42 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] 'Tis The Season For Ye Ol' "HOUR_OF_DAY: 2 -> 3" Error :-(

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<mailto: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<mailto: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<mailto:hanstra at nd.edu>

[https://docs.google.com/uc?export=download&id=1GFX1KaaMTtQ2Kg2u8bMXt1YwBp96bvf0&revid=0B7APN9POn6xAQ244WWFYMFU3aVJwZ0lxbmVHK3FxNXlCd0RRPQ]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20220314/ef26fa40/attachment.html>