[Archivesspace_Users_Group] database error migrating from 1.1.2 to 1.2.4
Kevin Clair
Kevin.Clair at du.edu
Tue Jun 2 11:31:09 EDT 2015
I started my database over from scratch in 1.1.2 and followed the upgrade instructions exactly. The results of running setup-database.sh were:
1.1.2 -> 1.2.4 ran normally, and then started normally (triggering a complete re-index, which I assume is by design)
1.1.2 -> 1.2.5 didn’t finish, and reported the following error:
kevin at archivesspace-2:~/archivesspace$ ./scripts/setup-database.sh
Loading ArchivesSpace configuration file from path: /home/kevin/archivesspace/./config/config.rb
Running migrations against jdbc:mysql://192.168.100.101:3306/archivesspace?user=as&password=[$password]&useUnicode=true&characterEncoding=UTF-8
Making location_temporary list editble
UPDATING OUR CONTROLLED VALUE LISTS...
Sequel::DatabaseError: Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Unknown column 'enumeration_id' in 'field list'
raise_error at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/database/misc.rb:423
statement at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:648
statement at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:646
execute at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:245
hold at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:85
synchronize at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255
execute at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:244
execute_insert at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:276
execute_insert at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:927
insert at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:336
(root) at /home/kevin/archivesspace-v1.2.5-dev07/lib/common.jar!/db/migrations/049_add_phone_number_type_and_enum.rb:17
each at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:139
process_result_set at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:797
fetch_rows at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:725
execute at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:250
statement at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:646
execute at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:245
hold at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:98
hold at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:87
synchronize at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255
execute at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:244
execute at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:911
fetch_rows at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:725
each at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:139
(root) at /home/kevin/archivesspace-v1.2.5-dev07/lib/common.jar!/db/migrations/049_add_phone_number_type_and_enum.rb:16
instance_eval at org/jruby/RubyBasicObject.java:1533
apply at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:100
run at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:528
checked_transaction at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:466
run at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:527
each at org/jruby/RubyArray.java:1613
run at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:524
run at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:391
setup_database at file:/home/kevin/archivesspace-v1.2.5-dev07/lib/common.jar!/db/db_migrator.rb:184
(root) at ../scripts/rb/migrate_db.rb:43
connect at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:69
connect at /home/kevin/archivesspace-v1.2.5-dev07/gems/gems/sequel-4.20.0/lib/sequel/core.rb:95
(root) at ../scripts/rb/migrate_db.rb:28
-k
From: "chris.fitzpatrick at lyrasis.org<mailto:chris.fitzpatrick at lyrasis.org>" <chris.fitzpatrick at lyrasis.org<mailto:chris.fitzpatrick at lyrasis.org>>
Reply-To: Archivesspace Group <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>>
Date: Tuesday, June 2, 2015 at 6:17 AM
To: Archivesspace Group <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>>
Subject: Re: [Archivesspace_Users_Group] database error migrating from 1.1.2 to 1.2.4
Hi Kevin,
Hm, it looks like your missing the position column that's added by this migration<https://github.com/archivesspace/archivesspace/blob/master/common/db/migrations/041_position_suppress_enum_values.rb> .
[https://avatars2.githubusercontent.com/u/1311559?v=3&s=400]<https://github.com/archivesspace/archivesspace/blob/master/common/db/migrations/041_position_suppress_enum_values.rb>
archivesspace/041_position_suppress_enum_values.rb at master · archivesspace/archivesspace · GitHub
archivesspace - The ArchivesSpace archives management tool
Read more...<https://github.com/archivesspace/archivesspace/blob/master/common/db/migrations/041_position_suppress_enum_values.rb>
Did you run the setup-database script? And what's the value of in your schema_info table?
b,chris.
Chris Fitzpatrick | Developer, ArchivesSpace
Skype: chrisfitzpat | Phone: 918.236.6048
http://archivesspace.org/
________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> <archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of Kevin Clair <Kevin.Clair at du.edu<mailto:Kevin.Clair at du.edu>>
Sent: Tuesday, June 2, 2015 4:51 AM
To: Archivesspace Group
Subject: [Archivesspace_Users_Group] database error migrating from 1.1.2 to 1.2.4
Hello,
I tried migrating my development site from 1.1.2 to 1.2.4 tonight and got the error listed below the cut. I never had this happen when I migrated from 1.2.0 so it’s possible there’s a necessary step there that I’m missing, but I thought I’d mention it in case it’s a bug. It happens when I jump from 1.1.2 to 1.2.5 as well. -k
— stack trace below —
E, [2015-06-01T20:46:29.761000 #4561] ERROR -- :
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Unknown column 'position' in 'order clause'
java.lang.reflect.Constructor.newInstance(java/lang/reflect/Constructor.java:526)
com.mysql.jdbc.Util.handleNewInstance(com/mysql/jdbc/Util.java:377)
com.mysql.jdbc.Util.getInstance(com/mysql/jdbc/Util.java:360)
com.mysql.jdbc.SQLError.createSQLException(com/mysql/jdbc/SQLError.java:978)
com.mysql.jdbc.MysqlIO.checkErrorPacket(com/mysql/jdbc/MysqlIO.java:3887)
com.mysql.jdbc.MysqlIO.checkErrorPacket(com/mysql/jdbc/MysqlIO.java:3823)
com.mysql.jdbc.MysqlIO.sendCommand(com/mysql/jdbc/MysqlIO.java:2435)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(com/mysql/jdbc/MysqlIO.java:2582)
com.mysql.jdbc.ConnectionImpl.execSQL(com/mysql/jdbc/ConnectionImpl.java:2526)
com.mysql.jdbc.ConnectionImpl.execSQL(com/mysql/jdbc/ConnectionImpl.java:2484)
com.mysql.jdbc.StatementImpl.executeQuery(com/mysql/jdbc/StatementImpl.java:1446)
java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:606)
Sequel::JDBC::Database.execute(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:250)
Sequel::JDBC::Database.execute(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:250)
Sequel::Database.log_yield(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/logging.rb:33)
Sequel::Database.log_yield(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/logging.rb:33)
Sequel::JDBC::Database.execute(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:250)
Sequel::JDBC::Database.execute(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:250)
Sequel::JDBC::Database.statement(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:646)
Sequel::JDBC::Database.statement(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:646)
Sequel::JDBC::Database.execute(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:245)
Sequel::JDBC::Database.execute(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:245)
Sequel::ThreadedConnectionPool.hold(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:85)
Sequel::ThreadedConnectionPool.hold(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:85)
Sequel::Database.synchronize(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255)
Sequel::Database.synchronize(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255)
Sequel::JDBC::Database.execute(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:244)
Sequel::JDBC::Database.execute(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:244)
Sequel::Dataset.execute(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:911)
Sequel::Dataset.execute(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:911)
Sequel::JDBC::Dataset.fetch_rows(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:725)
Sequel::JDBC::Dataset.fetch_rows(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:725)
Sequel::Dataset.with_sql_each(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:801)
Sequel::Dataset.with_sql_each(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:801)
RUBY.with_sql_all(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:784)
RUBY._all(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:860)
RUBY.with_sql_all(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:784)
RUBY.all(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/placeholder_literalizer.rb:138)
RUBY._load_associated_object_array(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/model/associations.rb:2131)
RUBY._load_associated_objects(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/model/associations.rb:2142)
RUBY.load_associated_objects(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/model/associations.rb:2240)
RUBY.enumeration_value(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/model/associations.rb:1767)
RUBY.sequel_to_jsonmodel(/home/kevin/archivesspace-v1.2.4-dev06/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/enumeration.rb:151)
org.jruby.RubyArray.each(org/jruby/RubyArray.java:1613)
RUBY.sequel_to_jsonmodel(/home/kevin/archivesspace-v1.2.4-dev06/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/enumeration.rb:146)
RUBY.listing_response(/home/kevin/archivesspace-v1.2.4-dev06/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/crud_helpers.rb:102)
RUBY.handle_unlimited_listing(/home/kevin/archivesspace-v1.2.4-dev06/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/crud_helpers.rb:44)
RUBY.ArchivesSpaceService(/home/kevin/archivesspace-v1.2.4-dev06/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/controllers/enumeration.rb:9)
org.jruby.RubyBasicObject.instance_eval(org/jruby/RubyBasicObject.java:1533)
RESTHelpers::Endpoint.returns(/home/kevin/archivesspace-v1.2.4-dev06/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/rest.rb:241)
RESTHelpers::Endpoint.returns(/home/kevin/archivesspace-v1.2.4-dev06/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/rest.rb:241)
RUBY.open(/home/kevin/archivesspace-v1.2.4-dev06/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:117)
RUBY.transaction(/home/kevin/archivesspace-v1.2.4-dev06/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:93)
RUBY._transaction(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:134)
RUBY.transaction(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:108)
Sequel::ThreadedConnectionPool.hold(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:98)
Sequel::ThreadedConnectionPool.hold(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:98)
Sequel::ThreadedConnectionPool.hold(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:87)
Sequel::ThreadedConnectionPool.hold(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:87)
Sequel::Database.synchronize(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255)
Sequel::Database.synchronize(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255)
RUBY.transaction(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:97)
RUBY.transaction(/home/kevin/archivesspace-v1.2.4-dev06/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:92)
RUBY.open(/home/kevin/archivesspace-v1.2.4-dev06/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(/home/kevin/archivesspace-v1.2.4-dev06/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/model/db.rb:113)
RESTHelpers::Endpoint.returns(/home/kevin/archivesspace-v1.2.4-dev06/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/rest.rb:223)
RESTHelpers::Endpoint.returns(/home/kevin/archivesspace-v1.2.4-dev06/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/rest.rb:223)
RUBY.open(/home/kevin/archivesspace-v1.2.4-dev06/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/request_context.rb:24)
RESTHelpers::Endpoint.returns(/home/kevin/archivesspace-v1.2.4-dev06/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/rest.rb:207)
RESTHelpers::Endpoint.returns(/home/kevin/archivesspace-v1.2.4-dev06/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/lib/rest.rb:207)
org.jruby.RubyMethod.call(org/jruby/RubyMethod.java:124)
Sinatra::Base.compile!(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:1293)
Sinatra::Base.compile!(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:1293)
org.jruby.RubyProc.call(org/jruby/RubyProc.java:271)
RUBY.route!(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:860)
RUBY.route_eval(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:876)
RUBY.route!(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:860)
RUBY.process_route(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:897)
org.jruby.RubyKernel.catch(org/jruby/RubyKernel.java:1270)
RUBY.process_route(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:895)
RUBY.route!(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:859)
org.jruby.RubyArray.each(org/jruby/RubyArray.java:1613)
RUBY.route!(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:858)
RUBY.dispatch!(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:963)
RUBY.invoke(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:946)
org.jruby.RubyKernel.catch(org/jruby/RubyKernel.java:1270)
RUBY.invoke(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:946)
RUBY.dispatch!(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:960)
RUBY.call!(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:794)
RUBY.invoke(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:946)
org.jruby.RubyKernel.catch(org/jruby/RubyKernel.java:1270)
RUBY.invoke(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:946)
RUBY.call!(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:794)
RUBY.call(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:780)
RUBY.call(/home/kevin/archivesspace-v1.2.4-dev06/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:257)
RUBY.call(/home/kevin/archivesspace/gems/gems/rack-protection-1.5.3/lib/rack/protection/xss_header.rb:18)
RUBY.call(/home/kevin/archivesspace/gems/gems/rack-protection-1.5.3/lib/rack/protection/path_traversal.rb:16)
RUBY.call(/home/kevin/archivesspace/gems/gems/rack-protection-1.5.3/lib/rack/protection/json_csrf.rb:18)
RUBY.call(/home/kevin/archivesspace/gems/gems/rack-protection-1.5.3/lib/rack/protection/base.rb:49)
RUBY.call(/home/kevin/archivesspace/gems/gems/rack-protection-1.5.3/lib/rack/protection/base.rb:49)
RUBY.call(/home/kevin/archivesspace/gems/gems/rack-protection-1.5.3/lib/rack/protection/frame_options.rb:31)
RUBY.call(/home/kevin/archivesspace/gems/gems/rack-1.4.5/lib/rack/nulllogger.rb:9)
RUBY.call(/home/kevin/archivesspace/gems/gems/rack-1.4.5/lib/rack/head.rb:9)
RUBY.call(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:124)
RUBY.call(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:1417)
RUBY.synchronize(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:1499)
RUBY.call(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:1417)
RUBY.call(/home/kevin/archivesspace-v1.2.4-dev06/gems/gems/jruby-rack-1.1.18/lib/jruby-rack-1.1.18.jar!/vendor/rack-1.5.2/rack/builder.rb:138)
RUBY.call(/home/kevin/archivesspace/gems/gems/rack-1.4.5/lib/rack/urlmap.rb:64)
org.jruby.RubyArray.each(org/jruby/RubyArray.java:1613)
RUBY.call(/home/kevin/archivesspace/gems/gems/rack-1.4.5/lib/rack/urlmap.rb:49)
RUBY.call(file:/home/kevin/archivesspace-v1.2.4-dev06/gems/gems/jruby-rack-1.1.18/lib/jruby-rack-1.1.18.jar!/rack/handler/servlet.rb:22)
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(org/eclipse/jetty/servlet/ServletHandler.java:1302)
org.eclipse.jetty.servlet.ServletHandler.doHandle(org/eclipse/jetty/servlet/ServletHandler.java:448)
org.eclipse.jetty.server.handler.ScopedHandler.handle(org/eclipse/jetty/server/handler/ScopedHandler.java:131)
org.eclipse.jetty.security.SecurityHandler.handle(org/eclipse/jetty/security/SecurityHandler.java:524)
org.eclipse.jetty.server.session.SessionHandler.doHandle(org/eclipse/jetty/server/session/SessionHandler.java:231)
org.eclipse.jetty.server.handler.ContextHandler.doHandle(org/eclipse/jetty/server/handler/ContextHandler.java:1067)
org.eclipse.jetty.servlet.ServletHandler.doScope(org/eclipse/jetty/servlet/ServletHandler.java:377)
org.eclipse.jetty.server.session.SessionHandler.doScope(org/eclipse/jetty/server/session/SessionHandler.java:192)
org.eclipse.jetty.server.handler.ContextHandler.doScope(org/eclipse/jetty/server/handler/ContextHandler.java:1001)
org.eclipse.jetty.server.handler.ScopedHandler.handle(org/eclipse/jetty/server/handler/ScopedHandler.java:129)
org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(org/eclipse/jetty/server/handler/ContextHandlerCollection.java:250)
org.eclipse.jetty.server.handler.HandlerWrapper.handle(org/eclipse/jetty/server/handler/HandlerWrapper.java:111)
org.eclipse.jetty.server.Server.handle(org/eclipse/jetty/server/Server.java:360)
org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(org/eclipse/jetty/server/AbstractHttpConnection.java:454)
org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(org/eclipse/jetty/server/AbstractHttpConnection.java:890)
org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(org/eclipse/jetty/server/AbstractHttpConnection.java:944)
org.eclipse.jetty.http.HttpParser.parseNext(org/eclipse/jetty/http/HttpParser.java:630)
org.eclipse.jetty.http.HttpParser.parseAvailable(org/eclipse/jetty/http/HttpParser.java:230)
org.eclipse.jetty.server.AsyncHttpConnection.handle(org/eclipse/jetty/server/AsyncHttpConnection.java:77)
org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(org/eclipse/jetty/io/nio/SelectChannelEndPoint.java:622)
org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(org/eclipse/jetty/io/nio/SelectChannelEndPoint.java:46)
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(org/eclipse/jetty/util/thread/QueuedThreadPool.java:603)
org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(org/eclipse/jetty/util/thread/QueuedThreadPool.java:538)
java.lang.Thread.run(java/lang/Thread.java:745)
D, [2015-06-01T20:46:29.771000 #4561] DEBUG -- : Thread-3494: Responded with [400, {"Content-Type"=>"application/json", "Cache-Control"=>"private, must-revalidate, max-age=0", "Content-Length"=>"173"}, ["{\"error\":{\"db_error\":[\"Database integrity constraint conflict: Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Unknown column 'position' in 'order clause'\"]}}\n"]]... in 927.0ms
Connection to backend failed ({"error":{"db_error":["Database integrity constraint conflict: Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Unknown column 'position' in 'order clause'"]}}
). Retrying...
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150602/df52c9e1/attachment.html>
More information about the Archivesspace_Users_Group
mailing list