<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);">
<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);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
You'll want to find the date more like '2021-03-14 02:00%' or would it be <span style="background-color:rgb(255, 255, 255);display:inline !important">03-13? Whatever the date was this year.</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span style="background-color:rgb(255, 255, 255);display:inline !important">Find any date with a time between 2-3am and just change it to any real hour.</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span style="background-color:rgb(255, 255, 255);display:inline !important">ArchivesSpace did "something" (probably restarted?) at a bad time on Sunday morning and wrote a time that never happened.</span></div>
<div>
<div id="Signature">
<div>
<div id="divtagdefaultwrapper" dir="ltr" style="color:rgb(0,0,0); background-color:rgb(255,255,255)">
</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 James Bullen
<james@hudmol.com><br>
<b>Sent:</b> Sunday, March 14, 2021 11:04 PM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Java error - Java::JavaSql::SQLException: HOUR_OF_DAY: 2 -> 3</font>
<div> </div>
</div>
<div class="" style="word-wrap:break-word; line-break:after-white-space">
<div class=""><br class="">
</div>
Oh gee, I’ve seen that horror. And, yes, it is caused by records having times in that non-existent hour. From memory the only fix I could find was to delete the offending rows, or update their times.
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">Cheers,</div>
<div class="">James</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
<div><br class="">
<blockquote type="cite" class="">
<div class="">On Mar 15, 2021, at 1:59 PM, Tom Hanstra <<a href="mailto:hanstra@nd.edu" class="">hanstra@nd.edu</a>> wrote:</div>
<br class="x_Apple-interchange-newline">
<div class="">
<div dir="ltr" class="">I don't seem to be able to win with ArchivesSpace.
<div class=""><br class="">
</div>
<div class="">After having indexing again finally give up because of another Java heap error, I restarted archivesspace again with some different java settings. I believe it actually got through the indexing, at least of the first repository.</div>
<div class=""><br class="">
</div>
<div class="">But tonight, looking at the logs, there is another error that seems to have something to do with, perhaps, daylight savings time? I'm seeing this Java error in the logs, even after a restart:<br class="">
<br class="">
--------</div>
<div class="">INFO: An exception happened during JRuby-Rack startup<br class="">
Java::JavaSql::SQLException: HOUR_OF_DAY: 2 -> 3<br class="">
--- System<br class="">
jruby 9.2.12.0 (2.5.7) 2020-07-01 db01a49ba6 OpenJDK 64-Bit Server VM 25.272-b10 on 1.8.0_272-b10 +jit [linux-x86_64]<br class="">
Time: 2021-03-14 22:46:48 -0400<br class="">
Server: jetty/8.1.5.v20120716<br class="">
jruby.home: uri:<a href="" class="">classloader://META-INF/jruby.home</a><br class="">
<br class="">
--- Context Init Parameters:<br class="">
jruby.max.runtimes = 1<br class="">
jruby.min.runtimes = 1<br class="">
public.root = /<br class="">
rack.env = production<br class="">
<br class="">
--- Backtrace<br class="">
Sequel::DatabaseError: Java::JavaSql::SQLException: HOUR_OF_DAY: 2 -> 3<br class="">
</div>
<div class=""><br class="">
</div>
<div class="">--------</div>
<div class=""><br class="">
</div>
<div class="">Did something get corrupted in the database? What might be happening to result in this error?</div>
<div class="">How do I fix it?</div>
<div class=""><br class="">
</div>
<div class="">Thanks,</div>
<div class="">Tom</div>
<div class="">
<div class=""><br class="">
</div>
-- <br class="">
<div dir="ltr" class="x_gmail_signature">
<div dir="ltr" class="">
<div class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div class=""><b class="" style="font-family:arial,helvetica,sans-serif; font-size:12.7273px; color:rgb(136,136,136)">Tom Hanstra</b><br class="">
</div>
<div class="" style="color:rgb(136,136,136); font-size:12.8px">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div class="" style="font-size:12.7273px">
<div class="">
<div class=""><i class="" style="font-size:12.7273px; font-family:arial,helvetica,sans-serif">Sr. Systems Administrator</i></div>
<div class=""><a href="mailto:hanstra@nd.edu" target="_blank" class="" style="color:rgb(17,85,204); font-size:12.7273px; font-family:arial,helvetica,sans-serif">hanstra@nd.edu</a><br class="">
</div>
</div>
<div class=""><span class="" style="font-family:arial,helvetica,sans-serif"><br class="">
</span></div>
</div>
<div class="" style="font-size:12.7273px"><img class="" src="https://docs.google.com/uc?export=download&id=1GFX1KaaMTtQ2Kg2u8bMXt1YwBp96bvf0&revid=0B7APN9POn6xAQ244WWFYMFU3aVJwZ0lxbmVHK3FxNXlCd0RRPQ"><br class="">
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<br class="">
Archivesspace_Users_Group mailing list<br class="">
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" class="">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br class="">
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<br class="">
</div>
</blockquote>
</div>
<br class="">
</div>
</div>
</body>
</html>