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: [email protected]
<[email protected]> on behalf of Mike
McDermott <[email protected]>
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: [email protected]
<[email protected]> On Behalf Of Daniel
Sprouse
Sent: Monday, March 9, 2020 12:38 PM
To: Archivesspace Users Group <[email protected]>
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:[email protected]]
_______________________________________________
Archivesspace_Users_Group mailing list
[email protected]
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
