[Archivesspace_Users_Group] Resequencing error

Mon Jun 1 14:56:00 EDT 2015

Chris,

No the resequencer never completed. It just stopped after a certain point with no error message. I let it run for a couple of hours with no success.

I could let it run for an entire day over the weekend once, but I'd like the figure out why solr hasn't started yet. What could cause solr to stop working?

Thanks,

Patrick Galligan
Rockefeller Archive Center
Assistant Digital Archivist
914-366-6386

-----Original Message-----
From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of Chris Fitzpatrick
Sent: Monday, June 01, 2015 5:43 AM
To: Archivesspace Users Group
Subject: Re: [Archivesspace_Users_Group] Resequencing error

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__com
> mysqljdbcexceptionsjdbc4__mysqlintegrityconstraintviolationexception__
> duplicate_entry__479856 at archival_object-0__for_key__uniq_ao_pos_<mailt
> o:en.validation_errors.database_integrity_constraint_conflict__java__c
> ommysqljdbcexceptionsjdbc4__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
_______________________________________________
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group at lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group