[Archivesspace_Users_Group] database error migrating from 1.1.2 to 1.2.4
Kevin Clair
Kevin.Clair at du.edu
Mon Jun 1 22:51:32 EDT 2015
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/8ca0d2ea/attachment.html>
More information about the Archivesspace_Users_Group
mailing list