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

[Blake Carver]

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';


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20220313/c2c4f57c/attachment.html>