Little bit more information- running v.2.8.1 and MariaDB 5.5.68.
Time complained about is eg
Time: 2022-03-28 15:46:28 +0100
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.
MariaDB [(none)]> SELECT @@global.time_zone, @@session.time_zone;
+--------------------+---------------------+
| @@global.time_zone | @@session.time_zone |
+--------------------+---------------------+
| SYSTEM | SYSTEM |
+--------------------+---------------------+
1 row in set (0.00 sec)
Cheers
Scott
Java::JavaSql::SQLException: HOUR_OF_DAY: 1 -> 2
--- System
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]
Time: 2022-03-28 15:46:28 +0100
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: 1 -> 2
raise_error at
/apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/misc.rb:419
statement at
/apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/adapters/jdbc.rb:677
execute at
/apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/adapters/jdbc.rb:239
hold at
/apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/connection_pool/threaded.rb:87
synchronize at
/apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/connecting.rb:270
execute at
/apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/adapters/jdbc.rb:238
execute at
/apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/dataset/actions.rb:1082
fetch_rows at
/apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/adapters/jdbc.rb:726
with_sql_each at
/apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/dataset/actions.rb:934
with_sql_first at
/apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/dataset/actions.rb:944
single_record! at
/apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/dataset/actions.rb:700
first at
/apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/dataset/actions.rb:243
first at
/apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/model/plugins.rb:33
[] at
/apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/model/base.rb:214
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:
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
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
<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
<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
require at org/jruby/RubyKernel.java:974
require_relative at org/jruby/RubyKernel.java:1002
ArchivesSpaceService at
/apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:195
open at
/apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:105
transaction at
/apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:69
_transaction at
/apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/transactions.rb:204
transaction at
/apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/transactions.rb:179
hold at
/apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/connection_pool/threaded.rb:91
synchronize at
/apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/connecting.rb:270
transaction at
/apps/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/transactions.rb:145
transaction at
/apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:68
open at
/apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:104
open at
/apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:101
open at
/apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:426
ArchivesSpaceService at
/apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:194
configure at
/apps/archivesspace/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1426
<class:ArchivesSpaceService> at
/apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:79
<main> at
/apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:39
require at org/jruby/RubyKernel.java:974
require at
uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/rubygems/core_ext/kernel_require.rb:54
<main> at
/apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/config.ru:4
instance_eval at org/jruby/RubyBasicObject.java:2622
initialize at
uri:classloader:/vendor/rack-2.2.3/rack/builder.rb:125
<main> at
/apps/solr/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/config.ru:1
start_server at launcher/launcher.rb:92
main at launcher/launcher.rb:157
<main> at launcher/launcher.rb:261
==========
Scott Renton
Digital Library Development & Systems
Floor F East
Argyle House
515219
________________________________
From: [email protected]
<[email protected]> on behalf of RENTON
Scott <[email protected]>
Sent: 28 March 2022 15:13
To: [email protected]
<[email protected]>
Subject: [Archivesspace_Users_Group] : HOUR_OF_DAY: 1 -> 2
Hi folks
I've got the
--- Backtrace Sequel::DatabaseError: Java::JavaSql::SQLException: HOUR_OF_DAY:
1 -> 2 (https://archivesspace.atlassian.net/browse/ANW-1229)
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.
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.
I've taken the system down temporarily.
Cheers
Scott
==========
Scott Renton
Digital Library Development & Systems
Floor F East
Argyle House
515219
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.
_______________________________________________
Archivesspace_Users_Group mailing list
[email protected]
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
