<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
Thanks Blake. It looks like the one-liner (<span style="caret-color: rgb(0, 0, 0); font-family: monospace; font-size: 14.666666984558105px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); display: inline !important;">UPDATE user set user_mtime =
NOW(), system_mtime=NOW();) </span>did the trick. I'll remember that for future seasonal changes.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
Cheers</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
Scott</div>
<div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div>
<div></div>
<div></div>
<div></div>
<div id="divtagdefaultwrapper" dir="ltr" style="font-size: 12pt; font-family: Calibri, Helvetica, sans-serif; color: rgb(0, 0, 0);">
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0"><br>
</p>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0">==========</p>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0">Scott Renton</p>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0">Digital Library Development & Systems</p>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0">Floor F East</p>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0">Argyle House</p>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0">515219</p>
</div>
</div>
</div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> 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</font>
<div> </div>
</div>
<style type="text/css" style="display:none">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
</style>
<div dir="ltr">
<div style="background-color:#fff2e6; border:2px dotted #ff884d"><span style="font-size:12pt; font-family:sans-serif; color:black; font-weight:bold; padding:.2em">This email was sent to you by someone outside the University.</span>
<div style="font-size:10pt; font-family:sans-serif; font-style:normal; padding:.2em">
You should only click on links or attachments if you are certain that the email is genuine and the content is safe.</div>
</div>
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
</div>
http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/2022-March/009092.html
<div>
<div id="x_Signature">
<div>
<div id="x_divtagdefaultwrapper" dir="ltr" style="color:rgb(0,0,0); background-color:rgb(255,255,255)">
<div name="x_divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; margin:0px">
<font face="Calibri,Arial,Helvetica,sans-serif" size="3" color="black"><span dir="ltr" style="font-size:12pt; background-color:white"><font size="2"><span style="font-size:11pt">
<p style="margin:0in; font-size:11pt; font-family:Calibri,sans-serif; color:rgb(32,31,30); text-align:start; background-color:rgb(255,255,255)">
<span style="margin:0px; font-family:Arial,sans-serif; color:black"></span></p>
<br>
</span></font></span></font></div>
<div name="x_divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; margin:0px">
<font face="Calibri,Arial,Helvetica,sans-serif" size="3" color="black"><span dir="ltr" style="font-size:12pt; background-color:white"><font size="2"><span style="font-size:11pt">You can probably just:</span></font></span></font></div>
<div name="x_divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; margin:0px">
<font face="Calibri,Arial,Helvetica,sans-serif" size="3" color="black"><span dir="ltr" style="font-size:12pt; background-color:white"><font size="2"><span style="font-size:11pt"><span style="font-family:monospace; background-color:rgb(255,255,255); display:inline!important">UPDATE
user set user_mtime = NOW(), system_mtime=NOW();</span><br>
</span></font></span></font></div>
<div name="x_divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; margin:0px">
<font face="Calibri,Arial,Helvetica,sans-serif" size="3" color="black"><span dir="ltr" style="font-size:12pt; background-color:white"><font size="2"><span style="font-size:11pt"><span style="font-family:monospace; background-color:rgb(255,255,255); display:inline!important"><br>
</span></span></font></span></font></div>
<div name="x_divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; margin:0px">
<font face="Calibri,Arial,Helvetica,sans-serif" size="3" color="black"><span dir="ltr" style="font-size:12pt; background-color:white"><font size="2"><span style="font-size:11pt"><span style="font-family:monospace; background-color:rgb(255,255,255); display:inline!important">Though
might need to:</span></span></font></span></font></div>
<div name="x_divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; margin:0px">
<font face="Calibri,Arial,Helvetica,sans-serif" size="3" color="black"><span dir="ltr" style="font-size:12pt; background-color:white"><font size="2"><span style="font-size:11pt">
<pre>-- 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';</pre>
</span></font></span></font></div>
<div name="x_divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; margin:0px">
<font face="Calibri,Arial,Helvetica,sans-serif" size="3" color="black"><span dir="ltr" style="font-size:12pt; background-color:white"><font size="2"><span style="font-size:11pt"><br>
</span></font></span></font></div>
<div name="x_divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; margin:0px">
<font face="Calibri,Arial,Helvetica,sans-serif" size="3" color="black"><span dir="ltr" style="font-size:12pt; background-color:white"><font size="2"><span style="font-size:11pt"><br>
</span></font></span></font></div>
</div>
</div>
</div>
</div>
<div id="x_appendonsend"></div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> 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</font>
<div> </div>
</div>
<style type="text/css" style="display:none">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
</style>
<div dir="ltr">
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255)">
Little bit more information- running v.2.8.1 and MariaDB 5.5.68. </div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255)">
Time complained about is eg
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures">Time: 2022-03-28 15:46:28 +0100</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><br>
</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<br>
</p>
</div>
<div>
<div id="x_x_Signature">
<div>
<div></div>
<div></div>
<div></div>
<div id="x_x_divtagdefaultwrapper" dir="ltr" style="font-size:12pt; font-family:Calibri,Helvetica,sans-serif; color:rgb(0,0,0)">
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0">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.</p>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0"><br>
</p>
<div style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0">
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures">MariaDB [(none)]> SELECT @@global.time_zone, @@session.time_zone;</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures">+--------------------+---------------------+</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures">| @@global.time_zone | @@session.time_zone |</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures">+--------------------+---------------------+</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures">| SYSTEM <span class="x_x_Apple-converted-space">
</span>| SYSTEM<span class="x_x_Apple-converted-space"> </span>
|</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures">+--------------------+---------------------+</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><b>1 row in set (0.00 sec)</b></span></p>
</div>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0"><br>
</p>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0">Cheers</p>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0">Scott</p>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0"><br>
</p>
<div style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0">
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures">Java::JavaSql::SQLException: HOUR_OF_DAY: 1 -> 2</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures">--- System</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures">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]</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures">Time: 2022-03-28 15:46:28 +0100</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures">Server: jetty/8.1.5.v20120716</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures">jruby.home: uri:classloader://META-INF/jruby.home</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; min-height:13px; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"></span><br>
</p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures">--- Context Init Parameters:</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures">jruby.max.runtimes = 1</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures">jruby.min.runtimes = 1</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures">public.root = /</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures">rack.env = production</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; min-height:13px; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"></span><br>
</p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures">--- Backtrace</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures">Sequel::DatabaseError: Java::JavaSql::SQLException: HOUR_OF_DAY: 1 -> 2</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>raise_error at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/misc.rb:419</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>statement at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/adapters/jdbc.rb:677</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>execute at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/adapters/jdbc.rb:239</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>hold at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/connection_pool/threaded.rb:87</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>synchronize at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/connecting.rb:270</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>execute at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/adapters/jdbc.rb:238</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>execute at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/dataset/actions.rb:1082</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>fetch_rows at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/adapters/jdbc.rb:726</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>with_sql_each at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/dataset/actions.rb:934</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>with_sql_first at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/dataset/actions.rb:944</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>single_record! at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/dataset/actions.rb:700</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>first at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/dataset/actions.rb:243</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>first at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/model/plugins.rb:33</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>[] at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/model/base.rb:214</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>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:</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space"> </span>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</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>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</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span><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</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span><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</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>require at org/jruby/RubyKernel.java:974</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>require_relative at org/jruby/RubyKernel.java:1002</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>ArchivesSpaceService at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:195</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>open at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:105</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>transaction at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:69</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>_transaction at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/transactions.rb:204</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>transaction at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/transactions.rb:179</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>hold at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/connection_pool/threaded.rb:91</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>synchronize at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/connecting.rb:270</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>transaction at /apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/transactions.rb:145</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>transaction at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:68</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>open at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:104</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>open at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:101</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>open at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:426</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>ArchivesSpaceService at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:194</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>configure at /apps/archivesspace/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1426</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span><class:ArchivesSpaceService> at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:79</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span><main> at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:39</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>require at org/jruby/RubyKernel.java:974</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>require at uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/rubygems/core_ext/kernel_require.rb:54</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span><main> at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/config.ru:4</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>instance_eval at org/jruby/RubyBasicObject.java:2622</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>initialize at uri:classloader:/vendor/rack-2.2.3/rack/builder.rb:125</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span><main> at /apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/config.ru:1</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>start_server at launcher/launcher.rb:92</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span>main at launcher/launcher.rb:157</span></p>
<p style="margin:0px; font-style:normal; font-variant-caps:normal; font-weight:normal; font-stretch:normal; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(0,0,0)">
<span style="font-variant-ligatures:no-common-ligatures"><span class="x_x_Apple-converted-space">
</span><main> at launcher/launcher.rb:261</span></p>
<br>
</div>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0"><br>
</p>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0">==========</p>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0">Scott Renton</p>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0">Digital Library Development & Systems</p>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0">Floor F East</p>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0">Argyle House</p>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0">515219</p>
</div>
</div>
</div>
</div>
<div id="x_x_appendonsend"></div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_x_divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> 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</font>
<div> </div>
</div>
<style type="text/css" style="display:none">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
</style>
<div dir="ltr">
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255)">
Hi folks</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255)">
I've got the </div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255)">
--- Backtrace Sequel::DatabaseError: Java::JavaSql::SQLException: HOUR_OF_DAY: 1 -> 2 (<a href="https://archivesspace.atlassian.net/browse/ANW-1229" style="margin:0px">https://archivesspace.atlassian.net/browse/ANW-1229</a>)</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255)">
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.</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255)">
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.</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255)">
I've taken the system down temporarily.</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255)">
<br>
</div>
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Cheers</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Scott</div>
<div id="x_x_x_Signature">
<div>
<div></div>
<div></div>
<div></div>
<div id="x_x_x_divtagdefaultwrapper" dir="ltr" style="font-size:12pt; font-family:Calibri,Helvetica,sans-serif; color:rgb(0,0,0)">
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0"><br>
</p>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0">==========</p>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0">Scott Renton</p>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0">Digital Library Development & Systems</p>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0">Floor F East</p>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0">Argyle House</p>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0; margin-bottom:0">515219</p>
</div>
</div>
</div>
</div>
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.
</div>
</div>
</div>
</div>
</body>
</html>