[Archivesspace_Users_Group] Java error - Java::JavaSql::SQLException: HOUR_OF_DAY: 2 -> 3

[James Bullen]

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.


Cheers,
James



> On Mar 15, 2021, at 1:59 PM, Tom Hanstra <hanstra at nd.edu> wrote:
> 
> I don't seem to be able to win with ArchivesSpace.
> 
> 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.
> 
> 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:
> 
> --------
> INFO: An exception happened during JRuby-Rack startup
> Java::JavaSql::SQLException: HOUR_OF_DAY: 2 -> 3
> --- System
> 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]
> Time: 2021-03-14 22:46:48 -0400
> Server: jetty/8.1.5.v20120716
> jruby.home: uri:classloader://META-INF/jruby.home
> 
> --- Context Init Parameters:
> jruby.max.runtimes = 1
> jruby.min.runtimes = 1
> public.root = /
> rack.env = production
> 
> --- Backtrace
> Sequel::DatabaseError: Java::JavaSql::SQLException: HOUR_OF_DAY: 2 -> 3
> 
> --------
> 
> Did something get corrupted in the database?  What might be happening to result in this error?
> How do I fix it?
> 
> Thanks,
> Tom
> 
> -- 
> Tom Hanstra
> Sr. Systems Administrator
> hanstra at nd.edu <mailto:hanstra at nd.edu>
> 
> 
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210315/b7c7f34a/attachment.html>