<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif;">
<div>Hello,</div>
<div><br>
</div>
<div>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</div>
<div><br>
</div>
<div>— stack trace below — </div>
<div><br>
</div>
<div>
<div>E, [2015-06-01T20:46:29.761000 #4561] ERROR -- : </div>
<div>Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Unknown column 'position' in 'order clause'</div>
<div>java.lang.reflect.Constructor.newInstance(java/lang/reflect/Constructor.java:526)</div>
<div>com.mysql.jdbc.Util.handleNewInstance(com/mysql/jdbc/Util.java:377)</div>
<div>com.mysql.jdbc.Util.getInstance(com/mysql/jdbc/Util.java:360)</div>
<div>com.mysql.jdbc.SQLError.createSQLException(com/mysql/jdbc/SQLError.java:978)</div>
<div>com.mysql.jdbc.MysqlIO.checkErrorPacket(com/mysql/jdbc/MysqlIO.java:3887)</div>
<div>com.mysql.jdbc.MysqlIO.checkErrorPacket(com/mysql/jdbc/MysqlIO.java:3823)</div>
<div>com.mysql.jdbc.MysqlIO.sendCommand(com/mysql/jdbc/MysqlIO.java:2435)</div>
<div>com.mysql.jdbc.MysqlIO.sqlQueryDirect(com/mysql/jdbc/MysqlIO.java:2582)</div>
<div>com.mysql.jdbc.ConnectionImpl.execSQL(com/mysql/jdbc/ConnectionImpl.java:2526)</div>
<div>com.mysql.jdbc.ConnectionImpl.execSQL(com/mysql/jdbc/ConnectionImpl.java:2484)</div>
<div>com.mysql.jdbc.StatementImpl.executeQuery(com/mysql/jdbc/StatementImpl.java:1446)</div>
<div>java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:606)</div>
<div>Sequel::JDBC::Database.execute(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:250)</div>
<div>Sequel::JDBC::Database.execute(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:250)</div>
<div>Sequel::Database.log_yield(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/logging.rb:33)</div>
<div>Sequel::Database.log_yield(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/logging.rb:33)</div>
<div>Sequel::JDBC::Database.execute(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:250)</div>
<div>Sequel::JDBC::Database.execute(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:250)</div>
<div>Sequel::JDBC::Database.statement(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:646)</div>
<div>Sequel::JDBC::Database.statement(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:646)</div>
<div>Sequel::JDBC::Database.execute(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:245)</div>
<div>Sequel::JDBC::Database.execute(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:245)</div>
<div>Sequel::ThreadedConnectionPool.hold(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:85)</div>
<div>Sequel::ThreadedConnectionPool.hold(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:85)</div>
<div>Sequel::Database.synchronize(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255)</div>
<div>Sequel::Database.synchronize(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255)</div>
<div>Sequel::JDBC::Database.execute(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:244)</div>
<div>Sequel::JDBC::Database.execute(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:244)</div>
<div>Sequel::Dataset.execute(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:911)</div>
<div>Sequel::Dataset.execute(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:911)</div>
<div>Sequel::JDBC::Dataset.fetch_rows(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:725)</div>
<div>Sequel::JDBC::Dataset.fetch_rows(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:725)</div>
<div>Sequel::Dataset.with_sql_each(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:801)</div>
<div>Sequel::Dataset.with_sql_each(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:801)</div>
<div>RUBY.with_sql_all(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:784)</div>
<div>RUBY._all(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:860)</div>
<div>RUBY.with_sql_all(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/actions.rb:784)</div>
<div>RUBY.all(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/dataset/placeholder_literalizer.rb:138)</div>
<div>RUBY._load_associated_object_array(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/model/associations.rb:2131)</div>
<div>RUBY._load_associated_objects(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/model/associations.rb:2142)</div>
<div>RUBY.load_associated_objects(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/model/associations.rb:2240)</div>
<div>RUBY.enumeration_value(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/model/associations.rb:1767)</div>
<div>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)</div>
<div>org.jruby.RubyArray.each(org/jruby/RubyArray.java:1613)</div>
<div>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)</div>
<div>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)</div>
<div>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)</div>
<div>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)</div>
<div>org.jruby.RubyBasicObject.instance_eval(org/jruby/RubyBasicObject.java:1533)</div>
<div>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)</div>
<div>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)</div>
<div>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)</div>
<div>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)</div>
<div>RUBY._transaction(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:134)</div>
<div>RUBY.transaction(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:108)</div>
<div>Sequel::ThreadedConnectionPool.hold(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:98)</div>
<div>Sequel::ThreadedConnectionPool.hold(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:98)</div>
<div>Sequel::ThreadedConnectionPool.hold(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:87)</div>
<div>Sequel::ThreadedConnectionPool.hold(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:87)</div>
<div>Sequel::Database.synchronize(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255)</div>
<div>Sequel::Database.synchronize(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255)</div>
<div>RUBY.transaction(/home/kevin/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/transactions.rb:97)</div>
<div>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)</div>
<div>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)</div>
<div>org.jruby.RubyFixnum.times(org/jruby/RubyFixnum.java:280)</div>
<div>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)</div>
<div>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)</div>
<div>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)</div>
<div>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)</div>
<div>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)</div>
<div>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)</div>
<div>org.jruby.RubyMethod.call(org/jruby/RubyMethod.java:124)</div>
<div>Sinatra::Base.compile!(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:1293)</div>
<div>Sinatra::Base.compile!(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:1293)</div>
<div>org.jruby.RubyProc.call(org/jruby/RubyProc.java:271)</div>
<div>RUBY.route!(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:860)</div>
<div>RUBY.route_eval(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:876)</div>
<div>RUBY.route!(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:860)</div>
<div>RUBY.process_route(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:897)</div>
<div>org.jruby.RubyKernel.catch(org/jruby/RubyKernel.java:1270)</div>
<div>RUBY.process_route(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:895)</div>
<div>RUBY.route!(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:859)</div>
<div>org.jruby.RubyArray.each(org/jruby/RubyArray.java:1613)</div>
<div>RUBY.route!(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:858)</div>
<div>RUBY.dispatch!(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:963)</div>
<div>RUBY.invoke(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:946)</div>
<div>org.jruby.RubyKernel.catch(org/jruby/RubyKernel.java:1270)</div>
<div>RUBY.invoke(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:946)</div>
<div>RUBY.dispatch!(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:960)</div>
<div>RUBY.call!(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:794)</div>
<div>RUBY.invoke(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:946)</div>
<div>org.jruby.RubyKernel.catch(org/jruby/RubyKernel.java:1270)</div>
<div>RUBY.invoke(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:946)</div>
<div>RUBY.call!(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:794)</div>
<div>RUBY.call(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:780)</div>
<div>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)</div>
<div>RUBY.call(/home/kevin/archivesspace/gems/gems/rack-protection-1.5.3/lib/rack/protection/xss_header.rb:18)</div>
<div>RUBY.call(/home/kevin/archivesspace/gems/gems/rack-protection-1.5.3/lib/rack/protection/path_traversal.rb:16)</div>
<div>RUBY.call(/home/kevin/archivesspace/gems/gems/rack-protection-1.5.3/lib/rack/protection/json_csrf.rb:18)</div>
<div>RUBY.call(/home/kevin/archivesspace/gems/gems/rack-protection-1.5.3/lib/rack/protection/base.rb:49)</div>
<div>RUBY.call(/home/kevin/archivesspace/gems/gems/rack-protection-1.5.3/lib/rack/protection/base.rb:49)</div>
<div>RUBY.call(/home/kevin/archivesspace/gems/gems/rack-protection-1.5.3/lib/rack/protection/frame_options.rb:31)</div>
<div>RUBY.call(/home/kevin/archivesspace/gems/gems/rack-1.4.5/lib/rack/nulllogger.rb:9)</div>
<div>RUBY.call(/home/kevin/archivesspace/gems/gems/rack-1.4.5/lib/rack/head.rb:9)</div>
<div>RUBY.call(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:124)</div>
<div>RUBY.call(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:1417)</div>
<div>RUBY.synchronize(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:1499)</div>
<div>RUBY.call(/home/kevin/archivesspace/gems/gems/sinatra-1.3.6/lib/sinatra/base.rb:1417)</div>
<div>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)</div>
<div>RUBY.call(/home/kevin/archivesspace/gems/gems/rack-1.4.5/lib/rack/urlmap.rb:64)</div>
<div>org.jruby.RubyArray.each(org/jruby/RubyArray.java:1613)</div>
<div>RUBY.call(/home/kevin/archivesspace/gems/gems/rack-1.4.5/lib/rack/urlmap.rb:49)</div>
<div>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)</div>
<div>org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(org/eclipse/jetty/servlet/ServletHandler.java:1302)</div>
<div>org.eclipse.jetty.servlet.ServletHandler.doHandle(org/eclipse/jetty/servlet/ServletHandler.java:448)</div>
<div>org.eclipse.jetty.server.handler.ScopedHandler.handle(org/eclipse/jetty/server/handler/ScopedHandler.java:131)</div>
<div>org.eclipse.jetty.security.SecurityHandler.handle(org/eclipse/jetty/security/SecurityHandler.java:524)</div>
<div>org.eclipse.jetty.server.session.SessionHandler.doHandle(org/eclipse/jetty/server/session/SessionHandler.java:231)</div>
<div>org.eclipse.jetty.server.handler.ContextHandler.doHandle(org/eclipse/jetty/server/handler/ContextHandler.java:1067)</div>
<div>org.eclipse.jetty.servlet.ServletHandler.doScope(org/eclipse/jetty/servlet/ServletHandler.java:377)</div>
<div>org.eclipse.jetty.server.session.SessionHandler.doScope(org/eclipse/jetty/server/session/SessionHandler.java:192)</div>
<div>org.eclipse.jetty.server.handler.ContextHandler.doScope(org/eclipse/jetty/server/handler/ContextHandler.java:1001)</div>
<div>org.eclipse.jetty.server.handler.ScopedHandler.handle(org/eclipse/jetty/server/handler/ScopedHandler.java:129)</div>
<div>org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(org/eclipse/jetty/server/handler/ContextHandlerCollection.java:250)</div>
<div>org.eclipse.jetty.server.handler.HandlerWrapper.handle(org/eclipse/jetty/server/handler/HandlerWrapper.java:111)</div>
<div>org.eclipse.jetty.server.Server.handle(org/eclipse/jetty/server/Server.java:360)</div>
<div>org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(org/eclipse/jetty/server/AbstractHttpConnection.java:454)</div>
<div>org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(org/eclipse/jetty/server/AbstractHttpConnection.java:890)</div>
<div>org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(org/eclipse/jetty/server/AbstractHttpConnection.java:944)</div>
<div>org.eclipse.jetty.http.HttpParser.parseNext(org/eclipse/jetty/http/HttpParser.java:630)</div>
<div>org.eclipse.jetty.http.HttpParser.parseAvailable(org/eclipse/jetty/http/HttpParser.java:230)</div>
<div>org.eclipse.jetty.server.AsyncHttpConnection.handle(org/eclipse/jetty/server/AsyncHttpConnection.java:77)</div>
<div>org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(org/eclipse/jetty/io/nio/SelectChannelEndPoint.java:622)</div>
<div>org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(org/eclipse/jetty/io/nio/SelectChannelEndPoint.java:46)</div>
<div>org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(org/eclipse/jetty/util/thread/QueuedThreadPool.java:603)</div>
<div>org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(org/eclipse/jetty/util/thread/QueuedThreadPool.java:538)</div>
<div>java.lang.Thread.run(java/lang/Thread.java:745)</div>
<div>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</div>
<div>Connection to backend failed ({"error":{"db_error":["Database integrity constraint conflict: Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Unknown column 'position' in 'order clause'"]}}</div>
<div>). Retrying...</div>
</div>
</body>
</html>