Skip to content

Instantly share code, notes, and snippets.

/gist:cc3d2ef586a07f3f341e

Created October 6, 2015 23:56
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/cc3d2ef586a07f3f341e to your computer and use it in GitHub Desktop.
Save anonymous/cc3d2ef586a07f3f341e to your computer and use it in GitHub Desktop.
Download ZIP
ArchivesSpace migration error
Raw
gistfile1.txt
Running migrations against jdbc:mysql://localhost:3306/archivesspace?user=[REDACTED]&password=[REDACTED]&useUnicode=true&characterEncoding=UTF-8
UPDATING OUR CONTROLLED VALUE LISTS...
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
3
Database migration error.
Your upgrade has encountered a problem.
You must resolve these issues before the database migration can complete.
Error:
#<Sequel::DatabaseError: Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'telephone' already exists>
Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'telephone' already exists
java.lang.reflect.Constructor.newInstance(java/lang/reflect/Constructor.java:526)
com.mysql.jdbc.Util.handleNewInstance(com/mysql/jdbc/Util.java:400)
com.mysql.jdbc.Util.getInstance(com/mysql/jdbc/Util.java:383)
com.mysql.jdbc.SQLError.createSQLException(com/mysql/jdbc/SQLError.java:980)
com.mysql.jdbc.MysqlIO.checkErrorPacket(com/mysql/jdbc/MysqlIO.java:3847)
com.mysql.jdbc.MysqlIO.checkErrorPacket(com/mysql/jdbc/MysqlIO.java:3783)
com.mysql.jdbc.MysqlIO.sendCommand(com/mysql/jdbc/MysqlIO.java:2447)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(com/mysql/jdbc/MysqlIO.java:2594)
com.mysql.jdbc.ConnectionImpl.execSQL(com/mysql/jdbc/ConnectionImpl.java:2541)
com.mysql.jdbc.ConnectionImpl.execSQL(com/mysql/jdbc/ConnectionImpl.java:2499)
com.mysql.jdbc.StatementImpl.execute(com/mysql/jdbc/StatementImpl.java:844)
com.mysql.jdbc.StatementImpl.execute(com/mysql/jdbc/StatementImpl.java:748)
java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:606)
Sequel::JDBC::Database.execute(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:254)
Sequel::JDBC::Database.execute(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:254)
Sequel::Database.log_yield(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/database/logging.rb:33)
Sequel::Database.log_yield(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/database/logging.rb:33)
Sequel::JDBC::Database.execute(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:254)
Sequel::JDBC::Database.execute(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:254)
Sequel::JDBC::Database.statement(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:646)
Sequel::JDBC::Database.statement(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:646)
Sequel::JDBC::Database.execute(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:245)
Sequel::JDBC::Database.execute(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:245)
Sequel::ThreadedConnectionPool.hold(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:98)
Sequel::ThreadedConnectionPool.hold(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:98)
Sequel::ThreadedConnectionPool.hold(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:87)
Sequel::ThreadedConnectionPool.hold(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:87)
Sequel::Database.synchronize(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255)
Sequel::Database.synchronize(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255)
Sequel::JDBC::Database.execute(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:244)
Sequel::JDBC::Database.execute(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:244)
RUBY.execute_ddl(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:270)
RUBY.create_table_from_generator(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:641)
RUBY.create_table(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:195)
RUBY.(root)(/usr/local/as140/lib/common.jar!/db/migrations/043_add_phone_numbers_to_agent_contact.rb:7)
org.jruby.RubyBasicObject.instance_eval(org/jruby/RubyBasicObject.java:1574)
RUBY.apply(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:100)
RUBY.run(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:528)
RUBY.checked_transaction(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:466)
RUBY.run(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:527)
org.jruby.RubyArray.each(org/jruby/RubyArray.java:1613)
RUBY.run(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:524)
RUBY.run(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:391)
RUBY.setup_database(file:/usr/local/as140/lib/common.jar!/db/db_migrator.rb:185)
$_dot_dot_.scripts.rb.migrate_db.(root)(../scripts/rb/migrate_db.rb:43)
$_dot_dot_.scripts.rb.migrate_db.(root)($_dot_dot_/scripts/rb/../scripts/rb/migrate_db.rb:43)
RUBY.connect(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:69)
RUBY.connect(/usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/core.rb:95)
$_dot_dot_.scripts.rb.migrate_db.(root)(../scripts/rb/migrate_db.rb:28)
$_dot_dot_.scripts.rb.migrate_db.(root)($_dot_dot_/scripts/rb/../scripts/rb/migrate_db.rb:28)
3
Sequel::DatabaseError: Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'telephone' already exists
raise_error at /usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/database/misc.rb:423
statement at /usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:648
statement at /usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:646
execute at /usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:245
hold at /usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:98
hold at /usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:87
synchronize at /usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255
execute at /usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:244
execute_ddl at /usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:270
create_table_from_generator at /usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:641
create_table at /usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:195
(root) at /usr/local/as140/lib/common.jar!/db/migrations/043_add_phone_numbers_to_agent_contact.rb:7
instance_eval at org/jruby/RubyBasicObject.java:1574
apply at /usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:100
run at /usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:528
checked_transaction at /usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:466
run at /usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:527
each at org/jruby/RubyArray.java:1613
run at /usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:524
run at /usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:391
setup_database at file:/usr/local/as140/lib/common.jar!/db/db_migrator.rb:185
(root) at ../scripts/rb/migrate_db.rb:43
connect at /usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:69
connect at /usr/local/as140/gems/gems/sequel-4.20.0/lib/sequel/core.rb:95
(root) at ../scripts/rb/migrate_db.rb:28
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment