Thanks Blake. It looks like the one-liner (UPDATE user set user_mtime = NOW(), 
system_mtime=NOW();) did the trick. I'll remember that for future seasonal 
changes.

Cheers
Scott



==========

Scott Renton

Digital Library Development & Systems

Floor F East

Argyle House

515219

________________________________
From: archivesspace_users_group-boun...@lyralists.lyrasis.org 
<archivesspace_users_group-boun...@lyralists.lyrasis.org> on behalf of Blake 
Carver <blake.car...@lyrasis.org>
Sent: 28 March 2022 16:00
To: Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] : HOUR_OF_DAY: 1 -> 2

This email was sent to you by someone outside the University.
You should only click on links or attachments if you are certain that the email 
is genuine and the content is safe.
http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/2022-March/009092.html

You can probably just:
UPDATE user set user_mtime = NOW(), system_mtime=NOW();

Though might need to:

-- AO
update archival_object set create_time = '2022-03-13 06:00:00', system_mtime = 
'2022-03-13 06:00:00'
where create_time >= '2022-03-13 02:00:00' and create_time <= '2022-03-13 
03:00:00';
-- DATE
update `date` set create_time = '2022-03-13 06:00:00', system_mtime = 
'2022-03-13 06:00:00'
where create_time >= '2022-03-13 02:00:00' and create_time <= '2022-03-13 
03:00:00';
-- USER
UPDATE user set user_mtime = NOW(), system_mtime=NOW() where 
username='SOME_OTHER_USER';


________________________________
From: archivesspace_users_group-boun...@lyralists.lyrasis.org 
<archivesspace_users_group-boun...@lyralists.lyrasis.org> on behalf of RENTON 
Scott <scott.ren...@ed.ac.uk>
Sent: Monday, March 28, 2022 10:55 AM
To: archivesspace_users_group@lyralists.lyrasis.org 
<archivesspace_users_group@lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] : HOUR_OF_DAY: 1 -> 2

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: archivesspace_users_group-boun...@lyralists.lyrasis.org 
<archivesspace_users_group-boun...@lyralists.lyrasis.org> on behalf of RENTON 
Scott <scott.ren...@ed.ac.uk>
Sent: 28 March 2022 15:13
To: archivesspace_users_group@lyralists.lyrasis.org 
<archivesspace_users_group@lyralists.lyrasis.org>
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
Archivesspace_Users_Group@lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group

Reply via email to