[Archivesspace_Users_Group] [EXTERNAL] Re: archivesspace admin account 'System'->'manage users' and 'Repository Settings'->'manage user access' pages give error

[Huebschen, Alan M]

Hi Mike,


This is an issue I faced during last year's DST switch and yesterday someone also ran into it here on the listserv. Blake had a well laid out response so I'll paste it below.

If anyone knows how to change the time indexing runs to 1am or 3am I think that would prevent this issue in the future as DST time change is at 2am.


>From Blake:


"It's probably a problem brought on by the change of time this week.

Try this:

MySQL [archivesspace]> select * from auth_db;
+------+------------------+---------------------+---------------------+--------------------------------------------------------------+
| id   | username         | create_time         | system_mtime        | pwhash                                                       |
+------+------------------+---------------------+---------------------+--------------------------------------------------------------+
|    1 | admin            | 2016-03-09 07:10:13 | 2016-03-09 07:10:13 | $2a$10$Gp0oqAuyVXmG/M1s7XDcTuz8.6aTRooPxbf.AWNUuhxNvzsjTa7om |
|    2 | search_indexer   | 2016-03-09 07:10:14 | 2019-10-05 08:33:40 | $2a$10$WEoh7JjTOFZ.m.ih9sbxPOHomfcReIBlnAoRQceAbwWFK0DuyC8Tm |


Take a look atsearch_indexer and the 2 times. The system_time is probably the one with the bad hour. You can just update that the current time and that should do it. So something like
update auth_db set system_mtime = NOW()where username = search_indexer.  "


-Alan Huebschen

University of Illinois at Springfield

Brookens Library Information Systems


________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Mike McDermott <mmcderm2 at bowdoin.edu>
Sent: Tuesday, March 10, 2020 11:02 AM
To: Archivesspace Users Group
Subject: [EXTERNAL] Re: [Archivesspace_Users_Group] archivesspace admin account 'System'->'manage users' and 'Repository Settings'->'manage user access' pages give error

Greetings...
We began noticing issues with our ArchivesSpace installations yesterday. (version 2.6.0)
The significant error in log seems to be:

Java::JavaSql::SQLException: HOUR_OF_DAY: 2 -> 3

I notice this error coming up in your log output as well...

I'm thinking this is related to the Daylight Saving Time change? Is anyone else having problems since that change?

We're on Red Hat 7 - I've updated to the newest available versions of java and the oracle java mysql connector.

Mike McDermott
Bowdoin College Library

From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> On Behalf Of Daniel Sprouse
Sent: Monday, March 9, 2020 12:38 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: [Archivesspace_Users_Group] archivesspace admin account 'System'->'manage users' and 'Repository Settings'->'manage user access' pages give error

after migrating from 2.7.0 to 2.7.1, and from mysqld  Ver 5.7.16 to mysqld  Ver 8.0.16.

archivesspace admin account 'System'->'manage users' and 'Repository Settings'->'manage user access' pages give error

http://arisint.tsl.texas.gov:8080/users
http://arisint.tsl.texas.gov:8080/users/manage_access
We're sorry, but something went wrong.

I have not found any other pages that give this error.

attached is a tail -f of archivesspace.out while attempting to get to 'System'->'manage users'

[cid:image001.jpg at 01D5F6D2.3AE30820]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20200310/8ba1b7bc/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 30834 bytes
Desc: image001.jpg
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20200310/8ba1b7bc/attachment.jpg>