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

Thu Aug 4 16:48:07 EDT 2016

Is this your 2nd attempt ? 

top_container and some other tables are added by the migration to 1.5.x 

I have seen this when I attempted to reload a mysql dump from 1.4.2 and redo the 1.5.x upgrade. 

I believe you need to delete those extra tables before loading the mysql dump and performing the upgrade.

I wasn’t sure of what needed to be deleted, so I used SEQUEL PRO to select and delete all tables.
An alternative would be to delete and recreate the entire database. 

— Steve Majewski / UVA Alderman Library

> On Aug 4, 2016, at 4:28 PM, Brent Ellingson <brent_ellingson at byu.edu> wrote:
> 
> 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
>  
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group