[Archivesspace_Users_Group] Resequencing error

Thu May 28 16:43:35 EDT 2015

I am getting about the same error:

E, [2015-05-28T09:23:19.938000 #7656] ERROR -- : Thread-3302: Error in  
job manager thread:  
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table  
'archivesspace.job' doesn't exist  
["com.mysql.jdbc.Util.handleNewInstance(com/mysql/jdbc/Util.java:411)",  
"com.mysql.jdbc.Util.getInstance(com/mysql/jdbc/Util.java:386)",  
"com.mysql.jdbc.SQLError.createSQLException(com/mysql/jdbc/SQLError.java:1054)", "com.mysql.jdbc.MysqlIO.checkErrorPacket(com/mysql/jdbc/MysqlIO.java:4190)", "com.mysql.jdbc.MysqlIO.checkErrorPacket(com/mysql/jdbc/MysqlIO.java:4122)", "com.mysql.jdbc.MysqlIO.sendCommand(com/mysql/jdbc/MysqlIO.java:2570)", "com.mysql.jdbc.MysqlIO.sqlQueryDirect(com/mysql/jdbc/MysqlIO.java:2731)", "com.mysql.jdbc.ConnectionImpl.execSQL(com/mysql/jdbc/ConnectionImpl.java:2812)", "com.mysql.jdbc.ConnectionImpl.execSQL(com/mysql/jdbc/ConnectionImpl.java:2761)", "com.mysql.jdbc.StatementImpl.executeQuery(com/mysql/jdbc/StatementImpl.java:1612)", "Sequel::JDBC::Database.execute(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:250)", "Sequel::JDBC::Database.execute(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:250)", "Sequel::Database.log_yield(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/logging.rb:33)", "Sequel::Database.log_yield(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/logging.rb:33)", "Sequel::JDBC::Database.execute(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:250)", "Sequel::JDBC::Database.execute(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:250)", "Sequel::JDBC::Database.statement(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:646)", "Sequel::JDBC::Database.statement(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:646)", "Sequel::JDBC::Database.execute(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:245)", "Sequel::JDBC::Database.execute(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:245)", "Sequel::ThreadedConnectionPool.hold(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:85)", "Sequel::ThreadedConnectionPool.hold(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:85)", "Sequel::Database.synchronize(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255)", "Sequel::Database.synchronize(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255)", "Sequel::JDBC::Database.execute(C:/archivesspace/gems/gems/sequel-4..20.0/lib/sequel/adapters/jdbc.rb:244)", "Sequel::JDBC::Database.execute(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:244)", "Sequel::Dataset.execute(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:911)", "Sequel::Dataset.execute(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:911)", "Sequel::JDBC::Dataset.fetch_rows(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:725)", "Sequel::JDBC::Dataset.fetch_rows(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:725)", "Sequel::Dataset.each(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:137)", "Sequel::Dataset.each(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:137)", "Sequel::Dataset.single_record(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:643)", "Sequel::Dataset..single_record(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:643)", "RUBY.first(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:192)", "RUBY.find_stale_job(C:/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/background_job_queue.rb:19)", "RUBY.open(C:/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:117)", "RUBY.transaction(C:/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:93)", "RUBY._transaction(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:134)", "RUBY.transaction(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:108)", "Sequel::ThreadedConnectionPool.hold(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:98)", "Sequel::ThreadedConnectionPool.hold(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:98)", "Sequel::ThreadedConnectionPool.hold(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:87)", "Sequel::ThreadedConnectionPool.hold(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:87)", "Sequel::Database.synchronize(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255)", "Sequel::Database.synchronize(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255)", "RUBY.transaction(C:/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:97)", "RUBY.transaction(C:/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:92)", "RUBY.open(C:/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:116)", "org.jruby.RubyFixnum.times(org/jruby/RubyFixnum.java:280)", "RUBY.open(C:/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:113)", "RUBY.find_stale_job(C:/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/background_job_queue.rb:18)", "RUBY.get_next_job(C:/archivesspace/data/tmp/jetty-0.0.0..0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/background_job_queue.rb:67)", "RUBY.run_pending_job(C:/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/background_job_queue.rb:72)",  
"RUBY.start_background_thread(C:/archivesspace/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/background_job_queue.rb:128)"]
May 28, 2015 9:23:20 AM org.apache.solr.core.SolrResourceLoader locateSolrHome

Have no idea how to correct it. I am not a programer. So I need very  
simple instructions.

Br Raphael

Quoting "Galligan, Patrick" <PGalligan at rockarch.org>:

> Any thoughts on the below?
>
> We are seeing the following error: translation missing: en.no key -  
> translation missing:  
> en.validation_errors.database_integrity_constraint_conflict__java__commysqljdbcexceptionsjdbc4__mysqlintegrityconstraintviolationexception__duplicate_entry__479856 at archival_object-0__for_key__uniq_ao_pos_<mailto:en.validation_errors.database_integrity_constraint_conflict__java__commysqljdbcexceptionsjdbc4__mysqlintegrityconstraintviolationexception__duplicate_entry__479856 at archival_object-0__for_key__uniq_ao_pos_>
>
> It's only happening with certain objects, but it's basically making  
> it impossible to update/delete those items. This is very troubling  
> for us and holding up some work.
>
> The only suggestion was to resequence, but resequencing seems to be  
> stalling with the error I attached last night.
>
> Any help would be awesome.
>
> Thanks!
>
> Patrick Galligan
> Rockefeller Archive Center
> Assistant Digital Archivist
> 914-366-6386
>
> From: Galligan, Patrick
> Sent: Wednesday, May 27, 2015 7:04 PM
> To: Archivesspace Users Group
> Subject: Resequencing error
>
> Hi,
>
> I was trying to resequence tonight to fix a couple holes in our AO  
> tree, but I ran into the attached error.
>
> In the past, resequencing has been relatively fast, but after an  
> hour of waiting, the log never moves past this point.
>
> Any thoughts on how to fix this?
>
> Thanks,
>
> Patrick Galligan
> Rockefeller Archive Center
> Assistant Digital Archivist
> 914-366-6386

Br Raphael Meyer osb
Prince of Peace Abbey