[Archivesspace_Users_Group] Database migration from 1.0.9 to 1.2.0 produces NoMethodError: undefined method `to_sequel_blob' for #<String:0x229db918>

Levy, Michael mlevy at ushmm.org
Mon Apr 27 16:52:46 EDT 2015


Working on the same situation as previously with some sample data entered
in a 1.0.9 version which I'm trying to upgrade. I ran git clone today, got
the current head version, built the zip file in a development environment,
put the zip file where I wanted it, unzipped it, copied the data directory
from the 1.0.9 version replacing the data directory from the zipped
version, and modified config.rb just to have it run on a set of 5 unused
ports (the older version on 1.0.9 is using the default ports).

Starting, I got a number of errors that seem to relate to attempts to run
migrations. Any tips? Should I use one of the tagged versions instead of
head? I'd be happy to share the entire log file but I think the first part
of the log is showing that it is having trouble running a database
migration. I have not tried to set resequence_on_startup (which doesn't
seem to relate to startup errors). Thanks for any help.

Loading ArchivesSpace configuration file from path:
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/config/config.rb
Loading ArchivesSpace configuration file from path:
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/config/config.rb
2015-04-27 15:24:39.585:INFO:oejs.Server:jetty-8.1.5.v20120716
2015-04-27 15:24:40.059:INFO:/:INFO: jruby 1.7.18 (1.9.3p551) 2014-12-22
625381c on Java HotSpot(TM) 64-Bit Server VM 1.6.0_26-b03 +jit [linux-amd64]
2015-04-27 15:24:40.061:INFO:/:INFO: using a shared (threadsafe!) runtime
Loading ArchivesSpace configuration file from path:
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/config/config.rb
Running database migrations for demo database
2015-04-27 15:25:00.901:INFO:/:An exception happened during JRuby-Rack
startup|Java::JavaSql::SQLException: Failed to start database
'/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/data/archivesspace_demo_db'
with class loader org.jruby.util.JRubyClassLoader at 1f72e08e, see the next
exception for details.|--- System|jruby 1.7.18 (1.9.3p551) 2014-12-22
625381c on Java HotSpot(TM) 64-Bit Server VM 1.6.0_26-b03 +jit
[linux-amd64]|Time: 2015-04-27 15:25:00 -0400|Server:
jetty/8.1.5.v20120716|jruby.home:
file:/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/jruby-jars-1.7.18/lib/jruby-stdlib-1.7.18.jar!/META-INF/jruby.home||---
Context Init Parameters:|jruby.compat.version = 1.9|jruby.max.runtimes =
1|jruby.min.runtimes = 1|public.root = /|rack.env = production||---
Backtrace|Sequel::DatabaseConnectionError: Java::JavaSql::SQLException:
Failed to start database
'/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/data/archivesspace_demo_db'
with class loader org.jruby.util.JRubyClassLoader at 1f72e08e, see the next
exception for details.|                     make_new at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool.rb:110|
                    make_new at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:160|
                   available at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:137|
                     acquire at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:127|
                        sync at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:201|
                 synchronize at org/jruby/ext/thread/Mutex.java:149|
                  sync at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:201|
                     acquire at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:126|
                        hold at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:88|
                 synchronize at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255|
                     execute at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:244|
                 execute_ddl at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:270|
 create_table_from_generator at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:641|
                create_table at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:195|
               create_table? at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:223|
              schema_dataset at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:584|
                  initialize at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:444|
                  initialize at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:506|
                         run at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:391|
              setup_database at
file:/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/lib/common.jar!/db/db_migrator.rb:184|
            prepare_database at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/data/tmp/jetty-0.0.0.0-8289-backend.war-_-any-/webapp/WEB-INF/app/lib/bootstrap.rb:64|
                     connect at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:69|
                     connect at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/core.rb:95|
            prepare_database at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/data/tmp/jetty-0.0.0.0-8289-backend.war-_-any-/webapp/WEB-INF/app/lib/bootstrap.rb:62|
                        init at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/data/tmp/jetty-0.0.0.0-8289-backend.war-_-any-/webapp/WEB-INF/app/lib/bootstrap.rb:40|
                      (root) at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/data/tmp/jetty-0.0.0.0-8289-backend.war-_-any-/webapp/WEB-INF/app/main.rb:10|
                     require at org/jruby/RubyKernel.java:1071|
         require at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/jruby-jars-1.7.18/lib/jruby-stdlib-1.7.18.jar!/META-INF/jruby.home/lib/ruby/shared/rubygems/core_ext/kernel_require.rb:55|
                     require at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/jruby-jars-1.7.18/lib/jruby-stdlib-1.7.18.jar!/META-INF/jruby.home/lib/ruby/shared/rubygems/core_ext/kernel_require.rb:53|
                      (root) at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/data/tmp/jetty-0.0.0.0-8289-backend.war-_-any-/webapp/WEB-INF/config.ru:1|
               instance_eval at org/jruby/RubyBasicObject.java:1533|
                (root) at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/data/tmp/jetty-0.0.0.0-8289-backend.war-_-any-/webapp/WEB-INF/config.ru:4|
                  initialize at
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/jruby-rack-1.1.18/lib/jruby-rack-1.1.18.jar!/vendor/rack-1.5.2/rack/builder.rb:55|
                start_server at launcher/launcher.rb:86|
      main at launcher/launcher.rb:147|                       (root) at
launcher/launcher.rb:230||--- RubyGems|Gem.dir:
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems|Gem.path:|/home/www/.gem/jruby/1.9|file:/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/jruby-jars-1.7.18/lib/jruby-stdlib-1.7.18.jar!/META-INF/jruby.home/lib/ruby/gems/shared|/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems|Activated
gems:|  json-1.8.0-java|  bundler-1.7.12|  rake-10.4.2|  i18n-0.7.0|
 multi_json-1.11.0|  activesupport-3.2.19|  atomic-1.0.1-java|
 htmlentities-4.3.3|  nokogiri-1.6.6.2-java|  rubyzip-1.0.0|  axlsx-2.0.1|
 backports-3.6.4|  bcrypt-3.1.7-java|  diff-lcs-1.1.3|
 eventmachine-1.0.7-java|  factory_girl-4.1.0|  jdbc-derby-10.6.2.1-java|
 jdbc-mysql-5.1.13|  jruby-jars-1.7.18|  jruby-rack-1.1.18|
 json-schema-1.0.10|  ladle-0.2.0-java|  multipart-post-1.2.0|
 net-http-persistent-2.8|  net-ldap-0.6.1|  rack-1.4.5|  puma-2.8.2-java|
 rack-protection-1.5.3|  sequel-4.20.0|  rack-session-sequel-0.0.1|
 rack-test-0.6.3|  rjack-jackson-1.8.11.0-java|  rspec-core-2.12.1|
 rspec-expectations-2.12.1|  rspec-mocks-2.12.2|  rspec-2.12.0|
 rufus-lru-1.0.5|  tzinfo-0.3.39|  rufus-scheduler-2.0.24|
 saxerator-0.9.5|  saxon-xslt-0.5.1-java|  simplecov-html-0.7.1|
 simplecov-0.7.1|  tilt-1.4.1|  sinatra-1.3.6|  sinatra-contrib-1.3.2|
 sinatra-reloader-1.0|  warbler-1.4.2|  zip-zip-0.3||---
Bundler|Bundler.bundle_path:
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems|Bundler.root:
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/data/tmp/jetty-0.0.0.0-8289-backend.war-_-any-/webapp/WEB-INF|Gemfile:
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/data/tmp/jetty-0.0.0.0-8289-backend.war-_-any-/webapp/WEB-INF/Gemfile|Settings:|
 bin_path =
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/bundler-1.7.12/bin/bundle|
 gemfile =
/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/data/tmp/jetty-0.0.0.0-8289-backend.war-_-any-/webapp/WEB-INF/Gemfile||---
JRuby-Rack Config|compat_version = RUBY1_9|default_logger =
org.jruby.rack.logging.StandardOutLogger at 6724e231|equals = <error: >|err =
java.io.PrintStream at 15335332|filter_adds_html =
true|filter_verifies_resource = false|ignore_environment =
false|initial_memory_buffer_size = |initial_runtimes =
1|jms_connection_factory = |jms_jndi_properties = |logger =
org.jruby.rack.logging.ServletContextLogger at 3d2a07c9|logger_class_name =
servlet_context|logger_name = jruby.rack|maximum_memory_buffer_size =
|maximum_runtimes = 1|num_initializer_threads = |out =
java.io.PrintStream at 34c1efe7|rackup = |rackup_path = |rewindable =
true|runtime_arguments = |runtime_environment = |runtime_timeout_seconds =
|serial_initialization = false|servlet_context =
ServletContext at o.e.j.w.WebAppContext{/,file:/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/data/tmp/jetty-0.0.0.0-8289-backend.war-_-any-/webapp/},/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/wars/backend.war|throw_init_exception
= false|
2015-04-27 15:25:00.905:WARN:/:ERROR: initialization failed
org.jruby.rack.RackInitializationException: Java::JavaSql::SQLException:
Failed to start database
'/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/data/archivesspace_demo_db'
with class loader org.jruby.util.JRubyClassLoader at 1f72e08e, see the next
exception for details.|?from
java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:597)|?from
RUBY.connect(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:219)|?from
RUBY.make_new(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool.rb:101)|?from
RUBY.make_new(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:160)|?from
RUBY.available(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:137)|?from
RUBY.acquire(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:127)|?from
RUBY.sync(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:201)|?from
org.jruby.ext.thread.Mutex.synchronize(org/jruby/ext/thread/Mutex.java:149)|?from
RUBY.sync(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:201)|?from
RUBY.acquire(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:126)|?from
RUBY.hold(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:88)|?from
RUBY.synchronize(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255)|?from
RUBY.execute(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:244)|?from
RUBY.execute_ddl(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:270)|?from
RUBY.create_table_from_generator(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:641)|?from
RUBY.create_table(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:195)|?from
RUBY.create_table?(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:223)|?from
RUBY.schema_dataset(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:584)|?from
RUBY.initialize(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:444)|?from
RUBY.initialize(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:506)|?from
RUBY.run(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:391)|?from
RUBY.setup_database(file:/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/lib/common.jar!/db/db_migrator.rb:184)|?from
RUBY.prepare_database(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/data/tmp/jetty-0.0.0.0-8289-backend.war-_-any-/webapp/WEB-INF/app/lib/bootstrap.rb:64)|?from
RUBY.connect(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:69)|?from
RUBY.connect(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/core.rb:95)|?from
RUBY.prepare_database(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/data/tmp/jetty-0.0.0.0-8289-backend.war-_-any-/webapp/WEB-INF/app/lib/bootstrap.rb:62)|?from
RUBY.init(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/data/tmp/jetty-0.0.0.0-8289-backend.war-_-any-/webapp/WEB-INF/app/lib/bootstrap.rb:40)|?from
RUBY.(root)(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/data/tmp/jetty-0.0.0.0-8289-backend.war-_-any-/webapp/WEB-INF/app/main.rb:10)|?from
org.jruby.RubyKernel.require(org/jruby/RubyKernel.java:1071)|?from
Kernel.require(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/jruby-jars-1.7.18/lib/jruby-stdlib-1.7.18.jar!/META-INF/jruby.home/lib/ruby/shared/rubygems/core_ext/kernel_require.rb:55)|?from
Kernel.require(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/jruby-jars-1.7.18/lib/jruby-stdlib-1.7.18.jar!/META-INF/jruby.home/lib/ruby/shared/rubygems/core_ext/kernel_require.rb:55)|?from
Kernel.require(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/jruby-jars-1.7.18/lib/jruby-stdlib-1.7.18.jar!/META-INF/jruby.home/lib/ruby/shared/rubygems/core_ext/kernel_require.rb:53)|?from
Kernel.require(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/jruby-jars-1.7.18/lib/jruby-stdlib-1.7.18.jar!/META-INF/jruby.home/lib/ruby/shared/rubygems/core_ext/kernel_require.rb:53)|?from
RUBY.(root)(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/data/tmp/jetty-0.0.0.0-8289-backend.war-_-any-/webapp/WEB-INF/config.ru:1)|?from
org.jruby.RubyBasicObject.instance_eval(org/jruby/RubyBasicObject.java:1533)|?from
RUBY.(root)(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/data/tmp/jetty-0.0.0.0-8289-backend.war-_-any-/webapp/WEB-INF/config.ru:4)|?from
RUBY.initialize(/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/gems/gems/jruby-rack-1.1.18/lib/jruby-rack-1.1.18.jar!/vendor/rack-1.5.2/rack/builder.rb:55)|?from
org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(org/eclipse/jetty/server/handler/ContextHandler.java:766)|?from
org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(org/eclipse/jetty/servlet/ServletContextHandler.java:406)|?from
org.eclipse.jetty.server.handler.ContextHandler.startContext(org/eclipse/jetty/server/handler/ContextHandler.java:758)|?from
org.eclipse.jetty.servlet.ServletContextHandler.startContext(org/eclipse/jetty/servlet/ServletContextHandler.java:242)|?from
org.eclipse.jetty.webapp.WebAppContext.startContext(org/eclipse/jetty/webapp/WebAppContext.java:1233)|?from
org.eclipse.jetty.server.handler.ContextHandler.doStart(org/eclipse/jetty/server/handler/ContextHandler.java:701)|?from
org.eclipse.jetty.webapp.WebAppContext.doStart(org/eclipse/jetty/webapp/WebAppContext.java:475)|?from
org.eclipse.jetty.util.component.AbstractLifeCycle.start(org/eclipse/jetty/util/component/AbstractLifeCycle.java:59)|?from
org.eclipse.jetty.server.handler.HandlerCollection.doStart(org/eclipse/jetty/server/handler/HandlerCollection.java:224)|?from
org.eclipse.jetty.server.handler.ContextHandlerCollection.doStart(org/eclipse/jetty/server/handler/ContextHandlerCollection.java:167)|?from
org.eclipse.jetty.util.component.AbstractLifeCycle.start(org/eclipse/jetty/util/component/AbstractLifeCycle.java:59)|?from
org.eclipse.jetty.server.handler.HandlerWrapper.doStart(org/eclipse/jetty/server/handler/HandlerWrapper.java:90)|?from
org.eclipse.jetty.server.Server.doStart(org/eclipse/jetty/server/Server.java:272)|?from
org.eclipse.jetty.util.component.AbstractLifeCycle.start(org/eclipse/jetty/util/component/AbstractLifeCycle.java:59)|?from
java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:597)|?from
launcher.launcher.start_server(launcher/launcher.rb:86)|?from
launcher.launcher.start_server(launcher/launcher/launcher.rb:86)|?from
launcher.launcher.main(launcher/launcher.rb:147)|?from
launcher.launcher.main(launcher/launcher/launcher.rb:147)|?from
launcher.launcher.(root)(launcher/launcher.rb:230)|?from
launcher.launcher.(root)(launcher/launcher/launcher.rb:230)|
at
org.jruby.rack.RackInitializationException.wrap(RackInitializationException.java:29)
at
org.jruby.rack.RackApplicationFactoryDecorator.init(RackApplicationFactoryDecorator.java:104)
at
org.jruby.rack.RackServletContextListener.contextInitialized(RackServletContextListener.java:50)
at
org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:766)
at
org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:406)
at
org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:758)
at
org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:242)
at
org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1233)
at
org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:701)
at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:475)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)
at
org.eclipse.jetty.server.handler.HandlerCollection.doStart(HandlerCollection.java:224)
at
org.eclipse.jetty.server.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:167)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)
at
org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:90)
at org.eclipse.jetty.server.Server.doStart(Server.java:272)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(JavaMethod.java:440)
at org.jruby.javasupport.JavaMethod.invokeDirect(JavaMethod.java:304)
at
org.jruby.java.invokers.InstanceMethodInvoker.call(InstanceMethodInvoker.java:52)
at
org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:306)
at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:136)
at launcher.launcher.method__1$RUBY$start_server(launcher/launcher.rb:86)
at
launcher$launcher$method__1$RUBY$start_server.call(launcher$launcher$method__1$RUBY$start_server)
at
org.jruby.internal.runtime.methods.DynamicMethod.call(DynamicMethod.java:218)
at
org.jruby.internal.runtime.methods.CompiledMethod.call(CompiledMethod.java:268)
at
org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:346)
at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:204)
at
launcher.launcher.chained_4_rescue_1$RUBY$SYNTHETICmain(launcher/launcher.rb:147)
at launcher.launcher.method__3$RUBY$main(launcher/launcher.rb:145)
at
launcher$launcher$method__3$RUBY$main.call(launcher$launcher$method__3$RUBY$main)
at
launcher$launcher$method__3$RUBY$main.call(launcher$launcher$method__3$RUBY$main)
at
org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:306)
at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:136)
at launcher.launcher.__file__(launcher/launcher.rb:230)
at launcher.launcher.load(launcher/launcher.rb)
at org.jruby.Ruby.runScript(Ruby.java:866)
at org.jruby.Ruby.runScript(Ruby.java:859)
at org.jruby.Ruby.runNormally(Ruby.java:728)
at org.jruby.Ruby.runFromMain(Ruby.java:577)
at org.jruby.Main.doRunFromMain(Main.java:395)
at org.jruby.Main.internalRun(Main.java:290)
at org.jruby.Main.run(Main.java:217)
at org.jruby.Main.main(Main.java:197)
Caused by:
org.jruby.exceptions.RaiseException: (DatabaseConnectionError)
Java::JavaSql::SQLException: Failed to start database
'/data/sites/apps/public/archivesspace-20150427-1447/archivesspace/data/archivesspace_demo_db'
with class loader org.jruby.util.JRubyClassLoader at 1f72e08e, see the next
exception for details.


On Thu, Apr 2, 2015 at 5:22 PM, Levy, Michael <mlevy at ushmm.org> wrote:

> We'll be happy to wait for a fix. Thanks Brian.
>
> On Thu, Apr 2, 2015 at 5:20 PM, Brian Hoffman <brianjhoffman at gmail.com>
> wrote:
>
>> Hi Michael,
>>
>> I think the best thing would be to wait for us to fix it. We’ll post a
>> minor release next week. Can you wait till then? I’d hate for your data to
>> get corrupted.
>>
>> Brian
>>
>>
>>
>> On Apr 2, 2015, at 5:17 PM, Levy, Michael <mlevy at ushmm.org> wrote:
>>
>> Any suggestions on what I ought to try to work around this issue? Should
>> I try running the upgrade incrementally from the 1.0.9 instance I have
>> running to some other interim version(s) and then on to 1.2.0?
>>
>> In my initial posting I did not finish a sentence. I merely meant to say
>> I copied the data folder and configuration, and that I had not added any
>> plugins.
>>
>> On Thu, Apr 2, 2015 at 12:07 PM, Brian Hoffman <brianjhoffman at gmail.com>
>> wrote:
>>
>>> Thank you!
>>>
>>> https://archivesspace.atlassian.net/browse/AR-1188
>>>
>>>
>>> On Apr 2, 2015, at 12:02 PM, Levy, Michael <mlevy at ushmm.org> wrote:
>>>
>>> > Starting with a small test instance with no modifications, under RHEL,
>>> using derby, from a working v1.0.9 instance (which had been stopped), and
>>> then attempting to upgrade to 1.2.0. I just copied the
>>> >
>>> > [www at saturn archivesspace-v1.2.0]$ scripts/setup-database.sh
>>> > Loading ArchivesSpace configuration file from path:
>>> /data/sites/apps/public/archivesspace-v1.2.0/config/config.rb
>>> > Loading ArchivesSpace configuration file from path:
>>> /data/sites/apps/public/archivesspace-v1.2.0/config/config.rb
>>> > Running migrations against
>>> jdbc:derby:/data/sites/apps/public/archivesspace-v1.2.0/data/archivesspace_demo_db;create=true;aspacedemo=true
>>> > Adding separate permissions for updating major record types
>>> >     ... accession records
>>> >     ... resource records
>>> >     ... digital object records
>>> >     ... running import jobs
>>> >     ... managing vocabulary records
>>> > Updating groups to include the new permssions
>>> > Deleting update_archival_record permission
>>> > Adding 'Date Not Yet Determined' to resource 2/4
>>> > Adding 'Date Not Yet Determined' to resource 2/23
>>> > Adding 'Date Not Yet Determined' to resource 2/24
>>> >
>>> >  ............
>>> >
>>> > Adding 'Date Not Yet Determined' to resource 2/52
>>> > Adding 'Date Not Yet Determined' to resource 2/53
>>> > *** ADDING SOME ENUMS
>>> > *** Genre Form to note_index_item_type  enum list
>>> > Triggering reindex of resource
>>> > Triggering reindex of archival_object
>>> > Triggering reindex of digital_object
>>> > Making location_temporary list editble
>>> > {:id=>1, :import_type=>"marcxml_lcnaf_subjects_and_agents",
>>> :repo_id=>2, :lock_version=>5, :json_schema_version=>1,
>>> :filenames=>"[\"lcnaf_import_d2adf1d5-64f5-4577-b55a-2e00b3bac1d5\"]",
>>> :time_submitted=>2014-03-26 17:51:23 UTC, :time_started=>2014-03-26
>>> 17:51:27 UTC, :time_finished=>2014-03-26 17:51:42 UTC, :owner_id=>1,
>>> :status=>"completed", :created_by=>"admin", :last_modified_by=>"admin",
>>> :create_time=>2014-03-26 17:51:23 UTC, :system_mtime=>2014-03-26 17:51:42
>>> UTC, :user_mtime=>2014-03-26 17:51:23 UTC}
>>> > 1297
>>> > NoMethodError: undefined method `to_sequel_blob' for
>>> #<String:0x229db918>
>>> >               blobify at
>>> /data/sites/apps/public/archivesspace-v1.2.0/lib/common.jar!/db/migrations/utils.rb:33
>>> >                (root) at
>>> /data/sites/apps/public/archivesspace-v1.2.0/lib/common.jar!/db/migrations/037_generalized_job_table.rb:44
>>> >                  each at org/jruby/RubyArray.java:1613
>>> >                (root) at
>>> /data/sites/apps/public/archivesspace-v1.2.0/lib/common.jar!/db/migrations/037_generalized_job_table.rb:37
>>> >         instance_eval at org/jruby/RubyBasicObject.java:1533
>>> >                 apply at
>>> /data/sites/apps/public/archivesspace-v1.2.0/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:100
>>> >                   run at
>>> /data/sites/apps/public/archivesspace-v1.2.0/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:528
>>> >          _transaction at
>>> /data/sites/apps/public/archivesspace-v1.2.0/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:134
>>> >           transaction at
>>> /data/sites/apps/public/archivesspace-v1.2.0/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:108
>>> >                  hold at
>>> /data/sites/apps/public/archivesspace-v1.2.0/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:98
>>> >                  hold at
>>> /data/sites/apps/public/archivesspace-v1.2.0/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:87
>>> >           synchronize at
>>> /data/sites/apps/public/archivesspace-v1.2.0/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255
>>> >           transaction at
>>> /data/sites/apps/public/archivesspace-v1.2.0/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:97
>>> >   checked_transaction at
>>> /data/sites/apps/public/archivesspace-v1.2.0/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:464
>>> >                   run at
>>> /data/sites/apps/public/archivesspace-v1.2.0/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:527
>>> >                  each at org/jruby/RubyArray.java:1613
>>> >                   run at
>>> /data/sites/apps/public/archivesspace-v1.2.0/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:524
>>> >                   run at
>>> /data/sites/apps/public/archivesspace-v1.2.0/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:391
>>> >        setup_database at
>>> file:/data/sites/apps/public/archivesspace-v1.2.0/lib/common.jar!/db/db_migrator.rb:184
>>> >                (root) at ../scripts/rb/migrate_db.rb:43
>>> >               connect at
>>> /data/sites/apps/public/archivesspace-v1.2.0/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:69
>>> >               connect at
>>> /data/sites/apps/public/archivesspace-v1.2.0/gems/gems/sequel-4.20.0/lib/sequel/core.rb:95
>>> >                (root) at ../scripts/rb/migrate_db.rb:28
>>> > [www at saturn archivesspace-v1.2.0]$
>>> >
>>> > _______________________________________________
>>> > Archivesspace_Users_Group mailing list
>>> > Archivesspace_Users_Group at lyralists.lyrasis.org
>>> >
>>> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>>>
>>> _______________________________________________
>>> Archivesspace_Users_Group mailing list
>>> Archivesspace_Users_Group at lyralists.lyrasis.org
>>> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>>>
>>
>> _______________________________________________
>> Archivesspace_Users_Group mailing list
>> Archivesspace_Users_Group at lyralists.lyrasis.org
>> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>>
>>
>>
>> _______________________________________________
>> 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/20150427/04bf2f1d/attachment.html>


More information about the Archivesspace_Users_Group mailing list