<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)"><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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.contentpasted1
{mso-style-name:contentpasted1;}
span.markwuv8aitsw
{mso-style-name:markwuv8aitsw;}
span.contentpasted0
{mso-style-name:contentpasted0;}
span.EmailStyle23
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
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-GB link="#0563C1" vlink="#954F72" style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Hi,<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>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.<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Here is the console interaction for SQL:<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>mysql> UPDATE user set user_mtime = NOW(), system_mtime=NOW();<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Query OK, 4 rows affected (0.01 sec)<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Rows matched: 4 Changed: 4 Warnings: 0<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Here is the stack trace (first few lines):<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Mar 28, 2023 12:00:08 PM org.eclipse.jetty.server.handler.ContextHandler$Context log<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>WARNING: ERROR: initialization failed<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>org.jruby.rack.RackInitializationException: Java::JavaSql::SQLException: HOUR_OF_DAY: 1 -> 2<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'> from com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:129)<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'> from com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:97)<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'> from com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:89)<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'> from com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:63)<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'> from com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:73)<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'> from com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(com/mysql/cj/jdbc/exceptions/SQLExceptionsMapping.java:85)<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'> from com.mysql.cj.jdbc.result.ResultSetImpl.getTimestamp(com/mysql/cj/jdbc/result/ResultSetImpl.java:947)<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'> from java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:498)<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'> from org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(org/jruby/javasupport/JavaMethod.java:456)<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'> from org.jruby.javasupport.JavaMethod.invokeDirect(org/jruby/javasupport/JavaMethod.java:317)<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'> 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)<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'> 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)<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'> from org.jruby.RubyMethod.call(org/jruby/RubyMethod.java:123)<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'> from org.jruby.RubyMethod$INVOKER$i$call.call(org/jruby/RubyMethod$INVOKER$i$call.gen)<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'> 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)<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'> 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)<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'> from org.jruby.RubyArray.each(org/jruby/RubyArray.java:1809)<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>This is affecting a production service, so I may have to raise a technical support request if there isn’t a community solution.<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Regards,<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Philip Webster<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>The University of Sheffield<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=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<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></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...<o:p></o:p></p><p><o:p> </o:p></p><p>Andrew.<o:p></o:p></p><p><o:p> </o:p></p><p><o:p> </o:p></p><div><p class=MsoNormal>On 12/03/2023 19:57, Blake Carver wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal><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'>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'>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><p class=MsoNormal style='background:white'><span style='color:black'><o:p> </o:p></span></p></div></div></div></div></blockquote></div></body></html>