[Archivesspace_Users_Group] DB error when trying to upgrade from 1.4.2 to 1.5.1

Thu Aug 4 16:47:55 EDT 2016

Hi Brent-

Were you running the container manager plugin in 1.4? If so, here's how I managed to get the migrations, etc to happen in my local test instance. Dartmouth is still in 1.3 in production and I haven't tested this in our dev and pre-prod server environments.

1) With the container plugin in the active plugins list in config.rb, run the setup database script

2) Remove the container manager plugin from the list of active plugins in config.rb

3) Remove the /data/indexer_state and /data/solr_index/index contents

4) start the app back up

5) Wait while the indexer works[😉]

If you haven't been running the container manager plugin, then I'm left scratching my head too.

Joshua

________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Brent Ellingson <brent_ellingson at byu.edu>
Sent: Thursday, August 4, 2016 4:28:26 PM
To: Archivesspace Users Group (archivesspace_users_group at lyralists.lyrasis.org) (archivesspace_users_group at lyralists.lyrasis.org)
Subject: [Archivesspace_Users_Group] DB error when trying to upgrade from 1.4.2 to 1.5.1

We are trying to upgrade an instance of ArchivesSpace from 1.4.2 to 1.5.1 and we’re getting the following error message.

Some help or thoughts on how to overcome this error would be appreciated.

*** Error message ***

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 'top_container' already exists>

     Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'top_container' already exists

     java.lang.reflect.Constructor.newInstance(java/lang/reflect/Constructor.java:423)

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:4187)

com.mysql.jdbc.MysqlIO.checkErrorPacket(com/mysql/jdbc/MysqlIO.java:4119)

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:2809)

com.mysql.jdbc.ConnectionImpl.execSQL(com/mysql/jdbc/ConnectionImpl.java:2758)

com.mysql.jdbc.StatementImpl.execute(com/mysql/jdbc/StatementImpl.java:894)

com.mysql.jdbc.StatementImpl.execute(com/mysql/jdbc/StatementImpl.java:732)

java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:498)

RUBY.execute(/opt/archivesspace-1.5.1/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:254)

RUBY.log_yield(/opt/archivesspace-1.5.1/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/logging.rb:33)

RUBY.execute(/opt/archivesspace-1.5.1/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:254)

RUBY.statement(/opt/archivesspace-1.5.1/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:646)

RUBY.execute(/opt/archivesspace-1.5.1/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:245)

RUBY.hold(/opt/archivesspace-1.5.1/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/connection_pool/threaded.rb:98)

RUBY.synchronize(/opt/archivesspace-1.5.1/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:255)

RUBY.execute(/opt/archivesspace-1.5.1/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:244)

RUBY.execute_ddl(/opt/archivesspace-1.5.1/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/adapters/jdbc.rb:270)

RUBY.create_table_from_generator(/opt/archivesspace-1.5.1/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:641)

RUBY.create_table(/opt/archivesspace-1.5.1/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:195)

RUBY.(root)(/opt/archivesspace-1.5.1/archivesspace/lib/common.jar!/db/migrations/060_top_container_migration.rb:30)

org.jruby.RubyBasicObject.instance_eval(org/jruby/RubyBasicObject.java:1574)

RUBY.apply(/opt/archivesspace-1.5.1/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:100)

RUBY.run(/opt/archivesspace-1.5.1/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:528)

RUBY.checked_transaction(/opt/archivesspace-1.5.1/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:466)

RUBY.run(/opt/archivesspace-1.5.1/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:527)

org.jruby.RubyArray.each(org/jruby/RubyArray.java:1613)

RUBY.run(/opt/archivesspace-1.5.1/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:524)

RUBY.run(/opt/archivesspace-1.5.1/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:391)

RUBY.setup_database(file:/opt/archivesspace-1.5.1/archivesspace/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(/opt/archivesspace-1.5.1/archivesspace/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:69)

RUBY.connect(/opt/archivesspace-1.5.1/archivesspace/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)

*** End error message ***

Regards,

__________________________

Brent Ellingson

Sr. Software Engineer

2750 Harold B. Lee Library

Brigham Young University

(801)422-6148

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20160804/4876f1b5/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: OutlookEmoji-?.png
Type: image/png
Size: 390 bytes
Desc: OutlookEmoji-?.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20160804/4876f1b5/attachment.png>