<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);" class="elementToProof">
It looks like there's a bad date hiding somewhere else. It's ALMOST always in the user table, but not always always.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class="elementToProof">
<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);" class="elementToProof">
Try something like:</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class="elementToProof">
<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);" class="elementToProof ContentPasted0">
<a href="https://gist.github.com/Blake-/d493da28be5554a49a3a3835bbd98f05">https://gist.github.com/Blake-/d493da28be5554a49a3a3835bbd98f05</a><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);" class="elementToProof ContentPasted0">
<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);" class="elementToProof ContentPasted0 ContentPasted1">
<a href="https://gist.github.com/Blake-/3c133ec7e42d039d85afbad5b3089eb4">https://gist.github.com/Blake-/3c133ec7e42d039d85afbad5b3089eb4</a><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);" class="elementToProof ContentPasted0">
<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);" class="elementToProof ContentPasted0">
You can update that year-month-day on those and see if you can find something. </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 Philip Webster
<philip.webster@sheffield.ac.uk><br>
<b>Sent:</b> Tuesday, March 28, 2023 7:07 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</font>
<div> </div>
</div>
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
span.x_contentpasted1
{}
span.x_markwuv8aitsw
{}
span.x_contentpasted0
{}
span.x_EmailStyle23
{font-family:"Calibri",sans-serif;
color:windowtext}
.x_MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:72.0pt 72.0pt 72.0pt 72.0pt}
div.x_WordSection1
{}
-->
</style>
<div lang="EN-GB" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="x_WordSection1">
<p class="x_MsoNormal"><span style="">Hi,</span></p>
<p class="x_MsoNormal"><span style="">Ran into this yesterday, and I ran the SQL UPDATE query – I got a report of 4 rows affected, but now our AS instance won’t start up due to initialisation errors. We are getting the same error as before.</span></p>
<p class="x_MsoNormal"><span style=""> </span></p>
<p class="x_MsoNormal"><span style="">Here is the console interaction for SQL:</span></p>
<p class="x_MsoNormal"><span style="">mysql> UPDATE user set user_mtime = NOW(), system_mtime=NOW();</span></p>
<p class="x_MsoNormal"><span style="">Query OK, 4 rows affected (0.01 sec)</span></p>
<p class="x_MsoNormal"><span style="">Rows matched: 4 Changed: 4 Warnings: 0</span></p>
<p class="x_MsoNormal"><span style=""> </span></p>
<p class="x_MsoNormal"><span style="">Here is the stack trace (first few lines):</span></p>
<p class="x_MsoNormal"><span style="">Mar 28, 2023 12:00:08 PM org.eclipse.jetty.server.handler.ContextHandler$Context log</span></p>
<p class="x_MsoNormal"><span style="">WARNING: ERROR: initialization failed</span></p>
<p class="x_MsoNormal"><span style="">org.jruby.rack.RackInitializationException: Java::JavaSql::SQLException: HOUR_OF_DAY: 1 -> 2</span></p>
<p class="x_MsoNormal"><span style=""> from com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:129)</span></p>
<p class="x_MsoNormal"><span style=""> from com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:97)</span></p>
<p class="x_MsoNormal"><span style=""> from com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:89)</span></p>
<p class="x_MsoNormal"><span style=""> from com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:63)</span></p>
<p class="x_MsoNormal"><span style=""> from com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:73)</span></p>
<p class="x_MsoNormal"><span style=""> from com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(com/mysql/cj/jdbc/exceptions/SQLExceptionsMapping.java:85)</span></p>
<p class="x_MsoNormal"><span style=""> from com.mysql.cj.jdbc.result.ResultSetImpl.getTimestamp(com/mysql/cj/jdbc/result/ResultSetImpl.java:947)</span></p>
<p class="x_MsoNormal"><span style=""> from java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:498)</span></p>
<p class="x_MsoNormal"><span style=""> from org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(org/jruby/javasupport/JavaMethod.java:456)</span></p>
<p class="x_MsoNormal"><span style=""> from org.jruby.javasupport.JavaMethod.invokeDirect(org/jruby/javasupport/JavaMethod.java:317)</span></p>
<p class="x_MsoNormal"><span style=""> from home.archivesspace.archivesspace.gems.gems.sequel_minus_5_dot_9_dot_0.lib.sequel.adapters.jdbc.invokeOther0:getTimestamp(home/archivesspace/archivesspace/gems/gems/sequel_minus_5_dot_9_dot_0/lib/sequel/adapters//home/archivesspace/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/adapters/jdbc.rb:685)</span></p>
<p class="x_MsoNormal"><span style=""> from home.archivesspace.archivesspace.gems.gems.sequel_minus_5_dot_9_dot_0.lib.sequel.adapters.jdbc.timestamp_convert(/home/archivesspace/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/adapters/jdbc.rb:685)</span></p>
<p class="x_MsoNormal"><span style=""> from org.jruby.RubyMethod.call(org/jruby/RubyMethod.java:123)</span></p>
<p class="x_MsoNormal"><span style=""> from org.jruby.RubyMethod$INVOKER$i$call.call(org/jruby/RubyMethod$INVOKER$i$call.gen)</span></p>
<p class="x_MsoNormal"><span style=""> from home.archivesspace.archivesspace.gems.gems.sequel_minus_5_dot_9_dot_0.lib.sequel.adapters.jdbc.invokeOther9:call(home/archivesspace/archivesspace/gems/gems/sequel_minus_5_dot_9_dot_0/lib/sequel/adapters//home/archivesspace/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/adapters/jdbc.rb:793)</span></p>
<p class="x_MsoNormal"><span style=""> from home.archivesspace.archivesspace.gems.gems.sequel_minus_5_dot_9_dot_0.lib.sequel.adapters.jdbc.process_result_set(/home/archivesspace/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/adapters/jdbc.rb:793)</span></p>
<p class="x_MsoNormal"><span style=""> from org.jruby.RubyArray.each(org/jruby/RubyArray.java:1809)</span></p>
<p class="x_MsoNormal"><span style=""> </span></p>
<p class="x_MsoNormal"><span style="">This is affecting a production service, so I may have to raise a technical support request if there isn’t a community solution.</span></p>
<p class="x_MsoNormal"><span style=""> </span></p>
<p class="x_MsoNormal"><span style="">Regards,</span></p>
<p class="x_MsoNormal"><span style=""> </span></p>
<p class="x_MsoNormal"><span style="">Philip Webster</span></p>
<p class="x_MsoNormal"><span style="">The University of Sheffield</span></p>
<p class="x_MsoNormal"><span style=""> </span></p>
<p class="x_MsoNormal"><span style=""> </span></p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0cm 0cm 0cm">
<p class="x_MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org>
<b>On Behalf Of </b>Andrew Morrison<br>
<b>Sent:</b> 27 March 2023 09:07<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></p>
</div>
</div>
<p class="x_MsoNormal"> </p>
<p>A reminder to anyone in Europe, whose clocks changed this weekend, to check your ArchivesSpace system. If everything but the home page isn't working, try the fix below...</p>
<p> </p>
<p>Andrew.</p>
<p> </p>
<p> </p>
<div>
<p class="x_MsoNormal">On 12/03/2023 19:57, Blake Carver wrote:</p>
</div>
<blockquote style="margin-top:5.0pt; margin-bottom:5.0pt">
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<div>
<p class="x_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</span></p>
</div>
<div>
<p class="x_MsoNormal"><span class="x_contentpasted1"><span style="font-size:12.0pt; color:black">DatabaseError: Java::JavaSql::SQLException: </span></span><span class="x_markwuv8aitsw"><span style="font-size:12.0pt; color:black">HOUR_OF_DAY</span></span><span class="x_contentpasted1"><span style="font-size:12.0pt; color:black; background:white">:
1 -> 2</span></span><span style="font-size:12.0pt; color:black"></span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black">Try this and restart, that'll probably do the trick. </span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<p class="x_MsoNormal"><span class="x_contentpasted0"><span style="font-family:"Courier New"; color:black">UPDATE user set user_mtime = NOW(), system_mtime=NOW();</span></span><span style="font-size:12.0pt; color:black"></span></p>
</div>
<div id="x_Signature">
<div>
<div id="x_divtagdefaultwrapper">
<div name="x_divtagdefaultwrapper">
<p class="x_MsoNormal" style="background:white"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div name="x_divtagdefaultwrapper">
<p class="x_MsoNormal" style="background:white"><span style="color:black; background:white"> </span><span style="font-size:12.0pt; color:black"></span></p>
</div>
<p class="x_MsoNormal" style="background:white"><span style="color:black"> </span></p>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</body>
</html>