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-boun...@lyralists.lyrasis.org <archivesspace_users_group-boun...@lyralists.lyrasis.org> on behalf of Tom Hanstra <hans...@nd.edu> Sent: Monday, March 14, 2022 9:42 AM To: Archivesspace Users Group <archivesspace_users_group@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.car...@lyrasis.org<mailto:blake.car...@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@lyralists.lyrasis.org<mailto:Archivesspace_Users_Group@lyralists.lyrasis.org> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group -- Tom Hanstra Sr. Systems Administrator hans...@nd.edu<mailto:hans...@nd.edu> [https://docs.google.com/uc?export=download&id=1GFX1KaaMTtQ2Kg2u8bMXt1YwBp96bvf0&revid=0B7APN9POn6xAQ244WWFYMFU3aVJwZ0lxbmVHK3FxNXlCd0RRPQ]
_______________________________________________ Archivesspace_Users_Group mailing list Archivesspace_Users_Group@lyralists.lyrasis.org http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
