[Archivesspace_Users_Group] Resequencing error

Mon Jun 1 05:42:38 EDT 2015

Hi Patrick,

Is the reseqencer not completing ( there should be a completed message ). The error that is showing up is the system is trying to make a backup of Solr, but Solr hasn't been started yet...I'm not sure if this would stop the resequence process.

Br Raphael, 

You error is much different. I think you need to run the setup-database script to add the proper tables to your database. Can you try this and tell me what the output is? 

b,chris. 

Chris Fitzpatrick | Developer, ArchivesSpace
Skype: chrisfitzpat  | Phone: 918.236.6048
http://archivesspace.org/

________________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of library at princeofpeaceabbey.org <library at princeofpeaceabbey.org>
Sent: Thursday, May 28, 2015 10:43 PM
To: Archivesspace Users Group
Subject: Re: [Archivesspace_Users_Group] Resequencing error

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:/archiv
 esspace/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.sync
 hronize(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:/archivess
 pace/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

_______________________________________________
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group at lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group