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

[Brian Hoffman]

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