That's exactly it, is this caused by the database migration script? I'm not sure what to do about it. It looks like its affecting almost every archival object. ________________________________ From: archivesspace_users_group-boun...@lyralists.lyrasis.org <archivesspace_users_group-boun...@lyralists.lyrasis.org> on behalf of Brian Hoffman <brian.hoff...@lyrasis.org> Sent: Thursday, May 19, 2022 7:52:28 AM To: Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org> Subject: Re: [Archivesspace_Users_Group] Errors Upgrading from 2.7.0 to 2.8.1
You could also try running this query in MySQL. If you get any results, that would likely be the problem: select id, aspace_relationship_position from top_container_link_rlshp where aspace_relationship_position is null; From: archivesspace_users_group-boun...@lyralists.lyrasis.org <archivesspace_users_group-boun...@lyralists.lyrasis.org> on behalf of Blake Carver <blake.car...@lyrasis.org> Date: Wednesday, May 18, 2022 at 4:13 PM To: Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org> Subject: Re: [Archivesspace_Users_Group] Errors Upgrading from 2.7.0 to 2.8.1 That looks pretty bad, not sure what it means, but I would start over, maybe something is missing or there's a bad plugin or some other mysterious thing has failed. ________________________________ From: archivesspace_users_group-boun...@lyralists.lyrasis.org <archivesspace_users_group-boun...@lyralists.lyrasis.org> on behalf of Corinne Chatnik <corinne.chat...@nysed.gov> Sent: Wednesday, May 18, 2022 3:25 PM To: Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org> Subject: [Archivesspace_Users_Group] Errors Upgrading from 2.7.0 to 2.8.1 Hi, Trying to upgrade from 2.7.0 to 2.8.1 and we keep getting the same error repeated over and over for nearly every record and we don’t know where to start looking. I’ve done a complete reindex and redid the database migration etc. The log file keeps repeating this: E, [2022-05-18T14:07:50.629287 #48326] ERROR -- : Thread-2902: Unhandled exception! E, [2022-05-18T14:07:50.630620 #48326] ERROR -- : comparison of NilClass with 0 failed org/jruby/RubyEnumerable.java:574:in `sort_by' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/mixins/relationships.rb:347:in `find_by_participant' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/mixins/relationships.rb:411:in `who_participates_with' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/mixins/relationships.rb:545:in `related_records' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/top_container.rb:170:in `find_subcontainer_barcodes' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/top_container.rb:190:in `block in sequel_to_jsonmodel' org/jruby/RubyArray.java:1809:in `each' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/top_container.rb:184:in `sequel_to_jsonmodel' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/uri_resolver.rb:336:in `block in resolve' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/request_context.rb:24:in `open' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/uri_resolver.rb:335:in `block in resolve' org/jruby/RubyHash.java:1415:in `each' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/uri_resolver.rb:331:in `block in resolve' org/jruby/RubyGenerator.java:104:in `each' org/jruby/RubyEnumerator.java:396:in `each' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/uri_resolver.rb:247:in `block in fetch_records_by_uri' org/jruby/RubyHash.java:1415:in `each' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/uri_resolver.rb:241:in `fetch_records_by_uri' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/uri_resolver.rb:130:in `resolve_references' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/uri_resolver.rb:44:in `resolve_references' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/crud_helpers.rb:113:in `listing_response' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/crud_helpers.rb:68:in `handle_listing' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/controllers/archival_object.rb:97:in `block in ArchivesSpaceService' org/jruby/RubyBasicObject.java:2622:in `instance_eval' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/rest.rb:368:in `block in GET /repositories/:repo_id/archival_objects' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:105:in `block in open' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:69:in `block in transaction' /opt/archivesspace-2.8.1/gems/gems/sequel-5.9.0/lib/sequel/database/transactions.rb:204:in `_transaction' /opt/archivesspace-2.8.1/gems/gems/sequel-5.9.0/lib/sequel/database/transactions.rb:179:in `block in transaction' /opt/archivesspace-2.8.1/gems/gems/sequel-5.9.0/lib/sequel/connection_pool/threaded.rb:91:in `hold' /opt/archivesspace-2.8.1/gems/gems/sequel-5.9.0/lib/sequel/database/connecting.rb:270:in `synchronize' /opt/archivesspace-2.8.1/gems/gems/sequel-5.9.0/lib/sequel/database/transactions.rb:145:in `transaction' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:68:in `transaction' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:104:in `block in open' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:101:in `open' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:426:in `block in DB' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/rest.rb:351:in `block in GET /repositories/:repo_id/archival_objects' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/request_context.rb:24:in `open' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/rest.rb:319:in `block in GET /repositories/:repo_id/archival_objects' org/jruby/RubyMethod.java:115:in `call' /opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1635:in `block in compile!' /opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:992:in `block in route!' /opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1011:in `route_eval' /opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:992:in `block in route!' /opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1040:in `block in process_route' org/jruby/RubyKernel.java:1189:in `catch' /opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1038:in `process_route' /opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:990:in `block in route!' org/jruby/RubyArray.java:1809:in `each' /opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:989:in `route!' /opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1097:in `block in dispatch!' /opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1076:in `block in invoke' org/jruby/RubyKernel.java:1189:in `catch' /opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1076:in `invoke' /opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1094:in `dispatch!' /opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:924:in `block in call!' /opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1076:in `block in invoke' org/jruby/RubyKernel.java:1189:in `catch' /opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1076:in `invoke' /opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:924:in `call!' /opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:913:in `call' /opt/archivesspace-2.8.1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:292:in `call' /opt/archivesspace-2.8.1/gems/gems/rack-protection-2.0.5/lib/rack/protection/xss_header.rb:18:in `call' /opt/archivesspace-2.8.1/gems/gems/rack-protection-2.0.5/lib/rack/protection/path_traversal.rb:16:in `call' /opt/archivesspace-2.8.1/gems/gems/rack-protection-2.0.5/lib/rack/protection/json_csrf.rb:26:in `call' /opt/archivesspace-2.8.1/gems/gems/rack-protection-2.0.5/lib/rack/protection/base.rb:50:in `call' /opt/archivesspace-2.8.1/gems/gems/rack-protection-2.0.5/lib/rack/protection/base.rb:50:in `call' /opt/archivesspace-2.8.1/gems/gems/rack-protection-2.0.5/lib/rack/protection/frame_options.rb:31:in `call' uri:classloader:/vendor/rack-2.2.3/rack/null_logger.rb:11:in `call' uri:classloader:/vendor/rack-2.2.3/rack/head.rb:12:in `call' /opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:194:in `call' /opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1957:in `call' /opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1502:in `block in call' /opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1729:in `synchronize' /opt/archivesspace-2.8.1/gems/gems/sinatra-2.0.5/lib/sinatra/base.rb:1502:in `call' uri:classloader:/vendor/rack-2.2.3/rack/urlmap.rb:74:in `block in call' org/jruby/RubyArray.java:1809:in `each' uri:classloader:/vendor/rack-2.2.3/rack/urlmap.rb:58:in `call' uri:classloader:/rack/handler/servlet.rb:22:in `call' Thanks! Corinne Chatnik Archivist Digital Strategies New York State Archives www.archives.nysed.gov<http://www.archives.nysed.gov/> | corinne.chat...@nysed.gov<mailto:corinne.chat...@nysed.gov> Facebook<https://www.facebook.com/nysarchives> | Twitter<https://twitter.com/nysarchives> | New York Archives Magazine<https://www.nysarchivestrust.org/new-york-archives-magazine> | YouTube<https://www.youtube.com/user/nysarchives> Confidentiality Notice This email including all attachments is confidential and intended solely for the use of the individual or entity to which it is addressed. This communication may contain information that is protected from disclosure under State and/or Federal law. Please notify the sender immediately if you have received this communication in error and delete this email from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.
_______________________________________________ Archivesspace_Users_Group mailing list Archivesspace_Users_Group@lyralists.lyrasis.org http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group