Re: [Archivesspace_Users_Group] 'Tis The Season For Ye Ol' "HOUR_OF_DAY: 2 -> 3" Error :-(
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 on behalf of Tom Hanstra Sent: Monday, March 14, 2022 9:42 AM To: Archivesspace Users Group 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 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
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 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 > http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group > -- *Tom Hanstra* *Sr. Systems Administrator* hans...@nd.edu ___ Archivesspace_Users_Group mailing list Archivesspace_Users_Group@lyralists.lyrasis.org http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
[Archivesspace_Users_Group] 'Tis The Season For Ye Ol' "HOUR_OF_DAY: 2 -> 3" Error :-(
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 http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group