<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:Menlo;
panose-1:2 11 6 9 3 8 4 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.contentpasted1
{mso-style-name:contentpasted1;}
span.markwuv8aitsw
{mso-style-name:markwuv8aitsw;}
span.contentpasted0
{mso-style-name:contentpasted0;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Consolas",serif;}
span.xxxapple-converted-space
{mso-style-name:x_x_x_apple-converted-space;}
span.EmailStyle25
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Hey Blake,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Looks like this might be affecting us. Thanks in advance for any help!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">-Bailey<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal"><b><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#841617">Bailey Hoffner (she/her or they/them)</span></b><span style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:black">Metadata and Collections Management Archivist</span><span style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><img width="310" height="61" style="width:3.2291in;height:.6354in" id="Picture_x0020_1" src="cid:image001.png@01D95587.04DDF020" alt="Text
Description automatically generated"><img width="1177" height="1140" style="width:12.2604in;height:11.875in" id="Picture_x0020_6" src="cid:image002.png@01D95587.04DDF020" alt="Graphical user interface, text, application
Description automatically generated"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif">Phone: (405) 325-1566 </span><span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif">Email: <u>baileys@ou.edu</u></span><span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif">Web:
<a href="https://libcal.ou.edu/appointments/asofficehours"><span style="color:#0563C1">ArchivesSpace Office Hours</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif">University Libraries<br>
The University of Oklahoma</span><span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif">401 W. Brooks St. | Norman, OK 73019</span><span style="font-size:12.0pt"><o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:12.0pt;color:black">From: </span></b><span style="font-size:12.0pt;color:black"><archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Blake Carver <blake.carver@lyrasis.org><br>
<b>Reply-To: </b>Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Date: </b>Sunday, March 12, 2023 at 2:57 PM<br>
<b>To: </b>Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject: </b>Re: [Archivesspace_Users_Group] : HOUR_OF_DAY: 1 -> 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">It's that time of year again! If ArchivesSpace isn't working for you today, check the logs... If you see<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span class="contentpasted1"><span style="font-size:12.0pt;color:black;background:white">DatabaseError: Java::JavaSql::SQLException: </span></span><span class="markwuv8aitsw"><span style="font-size:12.0pt;color:black">HOUR_OF_DAY</span></span><span class="contentpasted1"><span style="font-size:12.0pt;color:black;background:white">:
1 -> 2</span></span><span style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Try this and restart, that'll probably do the trick. <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span class="contentpasted0"><span style="font-family:"Courier New";color:black;background:white">UPDATE user set user_mtime = NOW(), system_mtime=NOW();</span></span><span style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
</div>
<div id="Signature">
<div>
<div id="divtagdefaultwrapper">
<div name="divtagdefaultwrapper">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div name="divtagdefaultwrapper">
<p class="MsoNormal" style="background:white"><span style="color:black;background:white"> </span><span style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
</div>
<div name="divtagdefaultwrapper">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
</div>
</div>
</div>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="0" width="100%" align="center">
</div>
<div id="divRplyFwdMsg">
<p class="MsoNormal"><b><span style="color:black">From:</span></b><span style="color:black"> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of RENTON Scott <Scott.Renton@ed.ac.uk><br>
<b>Sent:</b> Monday, March 28, 2022 11:05 AM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] : HOUR_OF_DAY: 1 -> 2</span> <o:p>
</o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">Thanks Blake. It looks like the one-liner (</span><span style="font-family:"Courier New";color:black;background:white">UPDATE user set user_mtime = NOW(), system_mtime=NOW();) </span><span style="font-size:12.0pt;color:black">did
the trick. I'll remember that for future seasonal changes.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">Cheers<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">Scott<o:p></o:p></span></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div id="x_Signature">
<div>
<div id="x_divtagdefaultwrapper">
<p><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:12.0pt;color:black">==========<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;color:black">Scott Renton<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;color:black">Digital Library Development & Systems<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;color:black">Floor F East<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;color:black">Argyle House<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;color:black">515219<o:p></o:p></span></p>
</div>
</div>
</div>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="0" width="100%" align="center">
</div>
<div id="x_divRplyFwdMsg">
<p class="MsoNormal"><b><span style="color:black">From:</span></b><span style="color:black"> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Blake Carver <blake.carver@lyrasis.org><br>
<b>Sent:</b> 28 March 2022 16:00<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] : HOUR_OF_DAY: 1 -> 2</span> <o:p>
</o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div style="border:dotted #FF884D 1.5pt;padding:0in 0in 0in 0in">
<p class="MsoNormal" style="background:#FFF2E6"><b><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:black">This email was sent to you by someone outside the University.</span></b><span style="color:black">
</span><o:p></o:p></p>
<div>
<p class="MsoNormal" style="background:#FFF2E6"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">You should only click on links or attachments if you are certain that the email is genuine and the content is safe.</span><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
</div>
</div>
<div>
<p class="MsoNormal"><a href="https://urldefense.com/v3/__http:/lyralists.lyrasis.org/pipermail/archivesspace_users_group/2022-March/009092.html__;!!GNU8KkXDZlD12Q!6kZ0XmJpb_VsDkdNeEbPcDzRU7-rBigcjgmuf6BY9WvT46LUY4bD6orSOt7Q8WVttnTq3kdWEIWdh1lQq6EbJg$">http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/2022-March/009092.html</a>
<o:p></o:p></p>
<div>
<div id="x_x_Signature">
<div>
<div id="x_x_divtagdefaultwrapper">
<div name="x_x_divtagdefaultwrapper">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div name="x_x_divtagdefaultwrapper">
<p class="MsoNormal" style="background:white"><span style="color:black;background:white">You can probably just:</span><span style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
</div>
<div name="x_x_divtagdefaultwrapper">
<p class="MsoNormal" style="background:white"><span style="font-family:"Courier New";color:black;background:white">UPDATE user set user_mtime = NOW(), system_mtime=NOW();</span><span style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
</div>
<div name="x_x_divtagdefaultwrapper">
<p class="MsoNormal" style="background:white"><span style="font-family:"Courier New";color:black;background:white"><br>
<br>
</span><span style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
</div>
<div name="x_x_divtagdefaultwrapper">
<p class="MsoNormal" style="background:white"><span style="font-family:"Courier New";color:black;background:white">Though might need to:</span><span style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
</div>
<div name="x_x_divtagdefaultwrapper">
<pre style="background:white"><span style="color:black;background:white">-- AO<o:p></o:p></span></pre>
<pre style="background:white"><span style="color:black;background:white">update archival_object set create_time = '2022-03-13 06:00:00', system_mtime = '2022-03-13 06:00:00'<o:p></o:p></span></pre>
<pre style="background:white"><span style="color:black;background:white">where create_time >= '2022-03-13 02:00:00' and create_time <= '2022-03-13 03:00:00';<o:p></o:p></span></pre>
<pre style="background:white"><span style="color:black;background:white">-- DATE<o:p></o:p></span></pre>
<pre style="background:white"><span style="color:black;background:white">update `date` set create_time = '2022-03-13 06:00:00', system_mtime = '2022-03-13 06:00:00'<o:p></o:p></span></pre>
<pre style="background:white"><span style="color:black;background:white">where create_time >= '2022-03-13 02:00:00' and create_time <= '2022-03-13 03:00:00';<o:p></o:p></span></pre>
<pre style="background:white"><span style="color:black;background:white">-- USER<o:p></o:p></span></pre>
<pre style="background:white"><span style="color:black;background:white">UPDATE user set user_mtime = NOW(), system_mtime=NOW() where username='SOME_OTHER_USER';<o:p></o:p></span></pre>
</div>
<div name="x_x_divtagdefaultwrapper">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div name="x_x_divtagdefaultwrapper">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
</div>
</div>
</div>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="0" width="100%" align="center">
</div>
<div id="x_x_divRplyFwdMsg">
<p class="MsoNormal"><b><span style="color:black">From:</span></b><span style="color:black"> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of RENTON Scott <Scott.Renton@ed.ac.uk><br>
<b>Sent:</b> Monday, March 28, 2022 10:55 AM<br>
<b>To:</b> archivesspace_users_group@lyralists.lyrasis.org <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] : HOUR_OF_DAY: 1 -> 2</span> <o:p>
</o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">Little bit more information- running v.2.8.1 and MariaDB 5.5.68. <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">Time complained about is eg
<o:p></o:p></span></p>
<p style="background:white"><span style="font-size:8.5pt;font-family:Menlo;color:black">Time: 2022-03-28 15:46:28 +0100<o:p></o:p></span></p>
<p style="background:white;font-variant-caps:normal;font-stretch:normal"><span style="font-size:8.5pt;font-family:Menlo;color:black"><br>
<br>
<o:p></o:p></span></p>
<p style="background:white;font-variant-caps:normal;font-stretch:normal"><span style="font-size:8.5pt;font-family:Menlo;color:black"><o:p> </o:p></span></p>
</div>
<div>
<div id="x_x_x_Signature">
<div>
<div id="x_x_x_divtagdefaultwrapper">
<p><span style="font-size:12.0pt;color:black">So basically any startup time + 0100 (I'm not sure which table it would be writing to there), which puts it into the future- no longer blaming users! I am guessing that a reindex won't solve this; my time_zone settings
are unchanged.<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<div>
<p style="font-variant-caps:normal;font-stretch:normal"><span style="font-size:8.5pt;font-family:Menlo;color:black">MariaDB [(none)]> SELECT @@global.time_zone, @@session.time_zone;<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span style="font-size:8.5pt;font-family:Menlo;color:black">+--------------------+---------------------+<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span style="font-size:8.5pt;font-family:Menlo;color:black">| @@global.time_zone | @@session.time_zone |<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span style="font-size:8.5pt;font-family:Menlo;color:black">+--------------------+---------------------+<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span style="font-size:8.5pt;font-family:Menlo;color:black">| SYSTEM
<span class="xxxapple-converted-space"> </span>| SYSTEM<span class="xxxapple-converted-space">
</span>|<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span style="font-size:8.5pt;font-family:Menlo;color:black">+--------------------+---------------------+<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><b><span style="font-size:8.5pt;font-family:Menlo;color:black">1 row in set (0.00 sec)</span></b><span style="font-size:8.5pt;font-family:Menlo;color:black"><o:p></o:p></span></p>
</div>
<p><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:12.0pt;color:black">Cheers<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;color:black">Scott<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<div>
<p style="font-variant-caps:normal;font-stretch:normal"><span style="font-size:8.5pt;font-family:Menlo;color:black">Java::JavaSql::SQLException: HOUR_OF_DAY: 1 -> 2<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span style="font-size:8.5pt;font-family:Menlo;color:black">--- System<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span style="font-size:8.5pt;font-family:Menlo;color:black">jruby 9.2.12.0 (2.5.7) 2020-07-01 db01a49ba6 OpenJDK 64-Bit Server VM 25.322-b06 on 1.8.0_322-b06 +jit [linux-x86_64]<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span style="font-size:8.5pt;font-family:Menlo;color:black">Time: 2022-03-28 15:46:28 +0100<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span style="font-size:8.5pt;font-family:Menlo;color:black">Server: jetty/8.1.5.v20120716<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span style="font-size:8.5pt;font-family:Menlo;color:black">jruby.home: uri:classloader://META-INF/jruby.home<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal;min-height:13px"><span style="font-size:8.5pt;font-family:Menlo;color:black"><o:p> </o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span style="font-size:8.5pt;font-family:Menlo;color:black">--- Context Init Parameters:<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span style="font-size:8.5pt;font-family:Menlo;color:black">jruby.max.runtimes = 1<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span style="font-size:8.5pt;font-family:Menlo;color:black">jruby.min.runtimes = 1<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span style="font-size:8.5pt;font-family:Menlo;color:black">public.root = /<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span style="font-size:8.5pt;font-family:Menlo;color:black">rack.env = production<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal;min-height:13px"><span style="font-size:8.5pt;font-family:Menlo;color:black"><o:p> </o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span style="font-size:8.5pt;font-family:Menlo;color:black">--- Backtrace<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span style="font-size:8.5pt;font-family:Menlo;color:black">Sequel::DatabaseError: Java::JavaSql::SQLException: HOUR_OF_DAY: 1 -> 2<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">raise_error at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/misc.rb:419<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">statement at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/adapters/jdbc.rb:677<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">execute at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/adapters/jdbc.rb:239<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">hold at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/connection_pool/threaded.rb:87<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">synchronize at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/connecting.rb:270<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">execute at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/adapters/jdbc.rb:238<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">execute at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/dataset/actions.rb:1082<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">fetch_rows at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/adapters/jdbc.rb:726<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">with_sql_each at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/dataset/actions.rb:934<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">with_sql_first at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/dataset/actions.rb:944<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">single_record! at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/dataset/actions.rb:700<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">first at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/dataset/actions.rb:243<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">first at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/model/plugins.rb:33<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">[] at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/model/base.rb:214<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">create_system_user at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/bootstrap_access_control.rb:<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black"> </span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">create_hidden_system_user at
/apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/bootstrap_access_control.rb:21<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">create_search_user at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/bootstrap_access_control.rb:306<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black"><class:ArchivesSpaceService> at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/bootstrap_access_control.rb:330<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black"><main> at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/bootstrap_access_control.rb:1<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">require at org/jruby/RubyKernel.java:974<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">require_relative at org/jruby/RubyKernel.java:1002<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">ArchivesSpaceService at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:195<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">open at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:105<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">transaction at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:69<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">_transaction at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/transactions.rb:204<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">transaction at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/transactions.rb:179<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">hold at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/connection_pool/threaded.rb:91<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">synchronize at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/connecting.rb:270<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">transaction at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/transactions.rb:145<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">transaction at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:68<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">open at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:104<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">open at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:101<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">open at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:426<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">ArchivesSpaceService at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:194<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">configure at /apps/archivesspace/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1426<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black"><class:ArchivesSpaceService> at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:79<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black"><main> at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:39<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">require at org/jruby/RubyKernel.java:974<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">require at uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/rubygems/core_ext/kernel_require.rb:54<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black"><main> at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/config.ru:4<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">instance_eval at org/jruby/RubyBasicObject.java:2622<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">initialize at uri:classloader:/vendor/rack-2.2.3/rack/builder.rb:125<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black"><main> at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/config.ru:1<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">start_server at launcher/launcher.rb:92<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black">main at launcher/launcher.rb:157<o:p></o:p></span></p>
<p style="font-variant-caps:normal;font-stretch:normal"><span class="xxxapple-converted-space"><span style="font-size:8.5pt;font-family:Menlo;color:black">
</span></span><span style="font-size:8.5pt;font-family:Menlo;color:black"><main> at launcher/launcher.rb:261<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<p><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:12.0pt;color:black">==========<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;color:black">Scott Renton<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;color:black">Digital Library Development & Systems<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;color:black">Floor F East<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;color:black">Argyle House<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;color:black">515219<o:p></o:p></span></p>
</div>
</div>
</div>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="0" width="100%" align="center">
</div>
<div id="x_x_x_divRplyFwdMsg">
<p class="MsoNormal"><b><span style="color:black">From:</span></b><span style="color:black"> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of RENTON Scott <Scott.Renton@ed.ac.uk><br>
<b>Sent:</b> 28 March 2022 15:13<br>
<b>To:</b> archivesspace_users_group@lyralists.lyrasis.org <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> [Archivesspace_Users_Group] : HOUR_OF_DAY: 1 -> 2</span> <o:p></o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">Hi folks<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">I've got the <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">--- Backtrace Sequel::DatabaseError: Java::JavaSql::SQLException: HOUR_OF_DAY: 1 -> 2 (<a href="https://urldefense.com/v3/__https:/archivesspace.atlassian.net/browse/ANW-1229__;!!GNU8KkXDZlD12Q!6kZ0XmJpb_VsDkdNeEbPcDzRU7-rBigcjgmuf6BY9WvT46LUY4bD6orSOt7Q8WVttnTq3kdWEIWdh1nt1KTIfQ$">https://archivesspace.atlassian.net/browse/ANW-1229</a>)<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">issue which I see from threads can happen after Daylight Saving. I've never seen it before, but it looks like our users have put some data in today that's thrown it out.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">I've found a few fixes talked about, but I wanted to check with yourselves to see if there was an official fix that I could safely run.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">I've taken the system down temporarily.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Cheers<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Scott<o:p></o:p></span></p>
</div>
<div id="x_x_x_x_Signature">
<div>
<div id="x_x_x_x_divtagdefaultwrapper">
<p><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:12.0pt;color:black">==========<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;color:black">Scott Renton<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;color:black">Digital Library Development & Systems<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;color:black">Floor F East<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;color:black">Argyle House<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;color:black">515219<o:p></o:p></span></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal">The University of Edinburgh is a charitable body, registered in Scotland, with registration number SC005336. Is e buidheann carthannais a th’ ann an Oilthigh Dhùn Èideann, clàraichte an Alba, àireamh clàraidh SC005336.
<o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>