[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
Wed Apr 29 12:51:51 EDT 2015
Please ignore my posting here. I have retried this same operation and it
works fine. This time I shut down the old ArchivesSpace instance (1.0.9)
prior to copying the /data/ directory. This time I made sure to stop the
1.0.9 instance before copying the /data/ direcdtory.
On Mon, Apr 27, 2015 at 4:52 PM, Levy, Michael <mlevy at ushmm.org> wrote:
> 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/20150429/2c92c357/attachment.html>
More information about the Archivesspace_Users_Group
mailing list