<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none"><!--.jfk-bubble {
filter: invert(100%) hue-rotate(180deg) contrast(90%) !important;
}[data-darkreader-inline-bgcolor] {
background-color: var(--darkreader-inline-bgcolor) !important;
}
[data-darkreader-inline-bgimage] {
background-image: var(--darkreader-inline-bgimage) !important;
}
[data-darkreader-inline-border] {
border-color: var(--darkreader-inline-border) !important;
}
[data-darkreader-inline-border-bottom] {
border-bottom-color: var(--darkreader-inline-border-bottom) !important;
}
[data-darkreader-inline-border-left] {
border-left-color: var(--darkreader-inline-border-left) !important;
}
[data-darkreader-inline-border-right] {
border-right-color: var(--darkreader-inline-border-right) !important;
}
[data-darkreader-inline-border-top] {
border-top-color: var(--darkreader-inline-border-top) !important;
}
[data-darkreader-inline-boxshadow] {
box-shadow: var(--darkreader-inline-boxshadow) !important;
}
[data-darkreader-inline-color] {
color: var(--darkreader-inline-color) !important;
}
[data-darkreader-inline-fill] {
fill: var(--darkreader-inline-fill) !important;
}
[data-darkreader-inline-stroke] {
stroke: var(--darkreader-inline-stroke) !important;
}
[data-darkreader-inline-outline] {
outline-color: var(--darkreader-inline-outline) !important;
}input, textarea, select, button {
background-color: #181a1b;
}
html, body, input, textarea, select, button {
border-color: #575757;
color: #e8e6e3;
}
a {
color: #3391ff;
}
table {
border-color: #4c4c4c;
}
::placeholder {
color: #bab5ab;
}
::selection {
background-color: #005ccc;
color: #ffffff;
}
::-moz-selection {
background-color: #005ccc;
color: #ffffff;
}
input:-webkit-autofill,
textarea:-webkit-autofill,
select:-webkit-autofill {
background-color: #545b00 !important;
color: #e8e6e3 !important;
}
::-webkit-scrollbar {
background-color: #1c1e1f;
color: #c5c1b9;
}
::-webkit-scrollbar-thumb {
background-color: #2a2c2e;
}
::-webkit-scrollbar-thumb:hover {
background-color: #323537;
}
::-webkit-scrollbar-thumb:active {
background-color: #3d4043;
}
::-webkit-scrollbar-corner {
background-color: #181a1b;
}
* {
scrollbar-color: #2a2c2e #1c1e1f;
}P{margin-top:0;margin-bottom:0;} .vimvixen-hint {
background-color: #7b5300 !important;
border-color: #d8b013 !important;
color: #f3e8c8 !important;
}
::placeholder {
opacity: 0.5 !important;
}input, textarea, select, button
{background-color:#181a1b}
html, body, input, textarea, select, button
{border-color:#575757;
color:#e8e6e3}
a
{color:#3391ff}
table
{border-color:#4c4c4c}
input:-webkit-autofill, textarea:-webkit-autofill, select:-webkit-autofill
{background-color:#545b00!important;
color:#e8e6e3!important}
*
{}
.vimvixen-hint
{background-color:#7b5300!important;
border-color:#d8b013!important;
color:#f3e8c8!important}
input, textarea, select, button
{background-color:#181a1b}
html, body, input, textarea, select, button
{border-color:#575757;
color:#e8e6e3}
a
{color:#3391ff}
table
{border-color:#4c4c4c}
input:-webkit-autofill, textarea:-webkit-autofill, select:-webkit-autofill
{background-color:#545b00!important;
color:#e8e6e3!important}
.vimvixen-hint
{background-color:#7b5300!important;
border-color:#d8b013!important;
color:#f3e8c8!important}
input, textarea, select, button
{background-color:#181a1b}
html, body, input, textarea, select, button
{border-color:#575757;
color:#e8e6e3}
a
{color:#3391ff}
table
{border-color:#4c4c4c}
input:-webkit-autofill, textarea:-webkit-autofill, select:-webkit-autofill
{background-color:#545b00!important;
color:#e8e6e3!important}
.vimvixen-hint
{background-color:#7b5300!important;
border-color:#d8b013!important;
color:#f3e8c8!important}
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
a:link, span.MsoHyperlink
{color:#0563C1;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:#954F72;
text-decoration:underline}
p.msonormal0, li.msonormal0, div.msonormal0
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
span.EmailStyle20
{font-family:"Calibri",sans-serif;
color:windowtext}
.MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}--></style>
</head>
<body dir="ltr" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<div dir="ltr" style="font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: Calibri, Arial, Helvetica, sans-serif; --darkreader-inline-color:#e8e6e3; --darkreader-inline-bgcolor:#181a1b;" data-darkreader-inline-colordata-darkreader-inline-bgcolor="">
<div dir="ltr" style="font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: Calibri, Arial, Helvetica, sans-serif; --darkreader-inline-color:#e8e6e3; --darkreader-inline-bgcolor:#181a1b;" data-darkreader-inline-colordata-darkreader-inline-bgcolor="">
<div dir="ltr" style="font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: Calibri, Arial, Helvetica, sans-serif; --darkreader-inline-color:#e8e6e3; --darkreader-inline-bgcolor:#181a1b;" data-darkreader-inline-colordata-darkreader-inline-bgcolor="">
<p>Hi Mike,</p>
<p><br>
</p>
<p>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.</p>
<p>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.<br>
</p>
<p><br>
</p>
<p>From Blake:</p>
<p><br>
</p>
<div class="_rp_x3" tabindex="-1">
<div class="_rp_X"></div>
</div>
<span dir="ltr">
<div><font style="--darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color="" size="3" face="Calibri,Arial,Helvetica,sans-serif" color="black"><span style="font-size:12pt">"It's probably a problem brought on by the change of time this week.</span></font></div>
<div><font style="--darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color="" size="3" face="Calibri,Arial,Helvetica,sans-serif" color="black"><span style="font-size:12pt"><br>
</span></font></div>
<div><font style="--darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color="" size="3" face="Calibri,Arial,Helvetica,sans-serif" color="black"><span style="font-size:12pt">
<div style="background-color: white; margin: 0px 0px 16px; --darkreader-inline-bgcolor:#181a1b;" data-darkreader-inline-bgcolor="">
<font style="--darkreader-inline-color:#d2cfc8;" data-darkreader-inline-color="" size="2" face="system-ui,-apple-system,system-ui,Segoe UI,Roboto,Oxygen-Sans,Ubuntu,Cantarell,Helvetica Neue,Arial,sans-serif" color="#2F3941"><span style="font-size: 14px; background-color: white; --darkreader-inline-bgcolor:#181a1b;" data-darkreader-inline-bgcolor="">Try
this:</span></font></div>
<pre style="background-color: rgb(248, 249, 249); margin: 15px 0px; padding: 6px 10px; border: 1px solid rgb(194, 200, 204); --darkreader-inline-bgcolor:#1a1c1d; --darkreader-inline-border-top:#3b4246; --darkreader-inline-border-right:#3b4246; --darkreader-inline-border-bottom:#3b4246; --darkreader-inline-border-left:#3b4246;" data-darkreader-inline-bgcolordata-darkreader-inline-border-topdata-darkreader-inline-border-rightdata-darkreader-inline-border-bottomdata-darkreader-inline-border-left=""><font style="--darkreader-inline-color:#bdb8ae;" data-darkreader-inline-color="" size="1" face="Consolas,Liberation Mono,Menlo,Bitstream Vera Sans Mono,Courier,monospace" color="#68737D"><span style="font-size: 12.2px; background-color: rgb(248, 249, 249); --darkreader-inline-bgcolor:#1a1c1d;" data-darkreader-inline-bgcolor=""><font size="1" face="Courier New"><span style="font-size:12px">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 |
</span></font></span></font></pre>
<div style="background-color: white; margin: 0px 0px 16px; --darkreader-inline-bgcolor:#181a1b;" data-darkreader-inline-bgcolor="">
<font style="--darkreader-inline-color:#d2cfc8;" data-darkreader-inline-color="" size="2" face="system-ui,-apple-system,system-ui,Segoe UI,Roboto,Oxygen-Sans,Ubuntu,Cantarell,Helvetica Neue,Arial,sans-serif" color="#2F3941"><span style="font-size: 14px; background-color: white; --darkreader-inline-bgcolor:#181a1b;" data-darkreader-inline-bgcolor="">Take
a look at<font size="1" face="Consolas,Liberation Mono,Menlo,Bitstream Vera Sans Mono,Courier,monospace"><span style="font-size: 12px; background-color: rgb(248, 249, 249); --darkreader-inline-bgcolor:#1a1c1d;" data-darkreader-inline-bgcolor="">search_indexer</span></font> and
the 2 times. The <font size="1" face="Consolas,Liberation Mono,Menlo,Bitstream Vera Sans Mono,Courier,monospace"><span style="font-size: 12px; background-color: rgb(248, 249, 249); --darkreader-inline-bgcolor:#1a1c1d;" data-darkreader-inline-bgcolor="">system_time</span></font> is
probably the one with the bad hour. You can just update that the current time and that should do it. So something like</span></font></div>
<div style="background-color: white; margin: 0px 0px 16px; --darkreader-inline-bgcolor:#181a1b;" data-darkreader-inline-bgcolor="">
<font style="--darkreader-inline-color:#d2cfc8;" data-darkreader-inline-color="" size="2" face="system-ui,-apple-system,system-ui,Segoe UI,Roboto,Oxygen-Sans,Ubuntu,Cantarell,Helvetica Neue,Arial,sans-serif" color="#2F3941"><span style="font-size: 14px; background-color: white; --darkreader-inline-bgcolor:#181a1b;" data-darkreader-inline-bgcolor="">update
auth_db set system_mtime = NOW()where username = search_indexer. "<br>
</span></font></div>
<div style="background-color: white; margin: 0px 0px 16px; --darkreader-inline-bgcolor:#181a1b;" data-darkreader-inline-bgcolor="">
<br>
</div>
<div style="background-color: white; margin: 0px 0px 16px; --darkreader-inline-bgcolor:#181a1b;" data-darkreader-inline-bgcolor="">
<p>-Alan Huebschen</p>
<p>University of Illinois at Springfield<br>
</p>
<p>Brookens Library Information Systems</p>
</div>
</span></font></div>
</span>
<p><br>
</p>
<div style="color: rgb(220, 218, 212); --darkreader-inline-color:#dcd9d4;" data-darkreader-inline-color="">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size: 11pt; --darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color="" face="Calibri, sans-serif" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org>
on behalf of Mike McDermott <mmcderm2@bowdoin.edu><br>
<b>Sent:</b> Tuesday, March 10, 2020 11:02 AM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Subject:</b> [EXTERNAL] Re: [Archivesspace_Users_Group] archivesspace admin account 'System'->'manage users' and 'Repository Settings'->'manage user access' pages give error</font>
<div> </div>
</div>
<div>
<div class="WordSection1">
<p class="MsoNormal">Greetings…</p>
<p class="MsoNormal">We began noticing issues with our ArchivesSpace installations yesterday. (version 2.6.0)
</p>
<p class="MsoNormal">The significant error in log seems to be:</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Java::JavaSql::SQLException: HOUR_OF_DAY: 2 -> 3</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">I notice this error coming up in your log output as well…</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">I’m thinking this is related to the Daylight Saving Time change? Is anyone else having problems since that change?</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">We’re on Red Hat 7 – I’ve updated to the newest available versions of java and the oracle java mysql connector.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Mike McDermott</p>
<p class="MsoNormal">Bowdoin College Library</p>
<p class="MsoNormal"> </p>
<div>
<div style="border-color: rgb(225, 225, 225) currentcolor currentcolor; border-style: solid none none; border-width: 1pt medium medium; padding: 3pt 0in 0in; --darkreader-inline-border-top:#393939; --darkreader-inline-border-right:currentcolor; --darkreader-inline-border-bottom:currentcolor; --darkreader-inline-border-left:currentcolor;" data-darkreader-inline-border-topdata-darkreader-inline-border-rightdata-darkreader-inline-border-bottomdata-darkreader-inline-border-left="">
<p class="MsoNormal"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org>
<b>On Behalf Of </b>Daniel Sprouse<br>
<b>Sent:</b> Monday, March 9, 2020 12:38 PM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> [Archivesspace_Users_Group] archivesspace admin account 'System'->'manage users' and 'Repository Settings'->'manage user access' pages give error</p>
</div>
</div>
<p class="MsoNormal"> </p>
<div>
<p class="MsoNormal" style="background: white none repeat scroll 0% 0%; --darkreader-inline-bgcolor:#181a1b; --darkreader-inline-bgimage:none;" data-darkreader-inline-bgcolordata-darkreader-inline-bgimage="">
<span style="font-size: 12pt; color: black; --darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color="">after migrating from 2.7.0 to 2.7.1, and from mysqld Ver 5.7.16 to mysqld Ver 8.0.16.</span></p>
<div>
<p class="MsoNormal" style="background: white none repeat scroll 0% 0%; --darkreader-inline-bgcolor:#181a1b; --darkreader-inline-bgimage:none;" data-darkreader-inline-bgcolordata-darkreader-inline-bgimage="">
<span style="font-size: 12pt; color: black; --darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color=""> </span></p>
</div>
<div>
<p class="MsoNormal" style="background: white none repeat scroll 0% 0%; --darkreader-inline-bgcolor:#181a1b; --darkreader-inline-bgimage:none;" data-darkreader-inline-bgcolordata-darkreader-inline-bgimage="">
<span style="font-size: 12pt; color: black; --darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color="">archivesspace admin account 'System'->'manage users' and 'Repository Settings'->'manage user access' pages give error</span></p>
</div>
<div>
<p class="MsoNormal" style="background: white none repeat scroll 0% 0%; --darkreader-inline-bgcolor:#181a1b; --darkreader-inline-bgimage:none;" data-darkreader-inline-bgcolordata-darkreader-inline-bgimage="">
<span style="font-size: 12pt; color: black; --darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color=""> </span></p>
</div>
<div>
<p class="MsoNormal" style="background: white none repeat scroll 0% 0%; --darkreader-inline-bgcolor:#181a1b; --darkreader-inline-bgimage:none;" data-darkreader-inline-bgcolordata-darkreader-inline-bgimage="">
<span style="font-size: 12pt; color: black; --darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color=""><a href="http://arisint.tsl.texas.gov:8080/users">http://arisint.tsl.texas.gov:8080/users</a></span></p>
</div>
<div>
<p class="MsoNormal" style="background: white none repeat scroll 0% 0%; --darkreader-inline-bgcolor:#181a1b; --darkreader-inline-bgimage:none;" data-darkreader-inline-bgcolordata-darkreader-inline-bgimage="">
<span style="font-size: 12pt; color: black; --darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color=""><a href="http://arisint.tsl.texas.gov:8080/users/manage_access">http://arisint.tsl.texas.gov:8080/users/manage_access</a></span></p>
</div>
<div>
<p class="MsoNormal" style="background: white none repeat scroll 0% 0%; --darkreader-inline-bgcolor:#181a1b; --darkreader-inline-bgimage:none;" data-darkreader-inline-bgcolordata-darkreader-inline-bgimage="">
<span style="font-size: 12pt; color: black; --darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color="">We're sorry, but something went wrong.</span></p>
</div>
<div>
<p class="MsoNormal" style="background: white none repeat scroll 0% 0%; --darkreader-inline-bgcolor:#181a1b; --darkreader-inline-bgimage:none;" data-darkreader-inline-bgcolordata-darkreader-inline-bgimage="">
<span style="font-size: 12pt; color: black; --darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color=""> </span></p>
</div>
<div>
<p class="MsoNormal" style="background: white none repeat scroll 0% 0%; --darkreader-inline-bgcolor:#181a1b; --darkreader-inline-bgimage:none;" data-darkreader-inline-bgcolordata-darkreader-inline-bgimage="">
<span style="font-size: 12pt; color: black; --darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color="">I have not found any other pages that give this error.</span></p>
</div>
<div>
<p class="MsoNormal" style="background: white none repeat scroll 0% 0%; --darkreader-inline-bgcolor:#181a1b; --darkreader-inline-bgimage:none;" data-darkreader-inline-bgcolordata-darkreader-inline-bgimage="">
<span style="font-size: 12pt; color: black; --darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color=""> </span></p>
</div>
<p class="MsoNormal" style="background: white none repeat scroll 0% 0%; --darkreader-inline-bgcolor:#181a1b; --darkreader-inline-bgimage:none;" data-darkreader-inline-bgcolordata-darkreader-inline-bgimage="">
<span style="font-size: 12pt; color: black; --darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color="">attached is a tail -f of archivesspace.out while attempting to get to 'System'->'manage users'</span></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-size: 12pt; color: black; --darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color=""> </span></p>
</div>
<div id="Signature">
<div id="divtagdefaultwrapper">
<div>
<p class="MsoNormal"><span style="font-size: 12pt; color: black; --darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color=""><img id="_x0000_i1025" style="width:5.5in; height:2.25in" width="528" height="216" border="0" src="cid:image001.jpg@01D5F6D2.3AE30820"></span></p>
</div>
<p class="MsoNormal"><span style="font-size: 12pt; color: black; --darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color=""> </span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>