[Archivesspace_Users_Group] DB problem in upgrade from 1.1.1 to 1.1.2

[Brian Hoffman]

Hi Brent,

If you are migrating from 1.1.1 to 1.1.2, it is odd that your setup would
be running this migration, which predates 1.1.1 by a version or two - in
other words, the migration producing this error should have been run when
you installed 1.1.1 for the first time, and should be skipped when you
upgrade from 1.1.1 to 1.1.2. Could you please look in the 'schema_info'
table of your database (both before and after failed migration) and let me
know the version number?

Brian


On Fri, Jan 23, 2015 at 2:53 PM, Brent Ellingson <brent_ellingson at byu.edu>
wrote:

>  We are working on upgrading our instance of ArchivesSpace from 1.1.1 to
> 1.1.2 and getting the following error.  Any thoughts on what to do next
> would be greatly appreciated.
>
>
>
> # *scripts/setup-database.sh*
> Loading ArchivesSpace configuration file from path:
> file:/opt/archivesspace-1.1.2/archivesspace/lib/common.jar!/config/config.rb
> Loading ArchivesSpace configuration file from path:
> /opt/archivesspace-1.1.2/archivesspace/config/config.rb
> Loading ArchivesSpace configuration file from path:
> /opt/archivesspace-1.1.2/archivesspace/config/config.rb
> Running migrations against
> jdbc:mysql://localhost:3306/archivesspace100?user=DBUSER&password=DBPASSWORD&useUnicode=true&characterEncoding=UTF-8
> Adding separate permissions for updating major record types
> Updating groups to include the new permssions
> Sequel::DatabaseError:
> Java::ComMysqlJdbcExceptionsJdbc4::MySQLIntegrityConstraintViolationException:
> Duplicate entry '27-1' for key
> 'group_permission_permission_id_group_id_index'
>           raise_error at
> /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/database/misc.rb:313
>             statement at
> /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/adapters/jdbc.rb:563
>               execute at
> /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/adapters/jdbc.rb:255
>                  hold at
> /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/connection_pool/threaded.rb:104
>           synchronize at
> /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/database/connecting.rb:240
>               execute at
> /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/adapters/jdbc.rb:254
>        execute_insert at
> /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/adapters/jdbc.rb:283
>        execute_insert at
> /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/dataset/actions.rb:778
>                insert at
> /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/dataset/actions.rb:317
>                (root) at
> /opt/archivesspace-1.1.2/archivesspace/lib/common.jar!/db/migrations/032_split_update_archival_record_permission_by_record_type_and_related_permissions_changes.rb:91
>                  each at org/jruby/RubyArray.java:1613
>                (root) at
> /opt/archivesspace-1.1.2/archivesspace/lib/common.jar!/db/migrations/032_split_update_archival_record_permission_by_record_type_and_related_permissions_changes.rb:90
>         instance_eval at org/jruby/RubyBasicObject.java:1533
>                 apply at
> /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/extensions/migration.rb:94
>                   run at
> /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/extensions/migration.rb:519
>   checked_transaction at
> /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/extensions/migration.rb:456
>                   run at
> /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/extensions/migration.rb:518
>                  each at org/jruby/RubyArray.java:1613
>                   run at
> /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/extensions/migration.rb:514
>                   run at
> /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/extensions/migration.rb:381
>        setup_database at
> file:/opt/archivesspace-1.1.2/archivesspace/lib/common.jar!/db/db_migrator.rb:184
>                (root) at ../scripts/rb/migrate_db.rb:43
>               connect at
> /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/database/connecting.rb:80
>               connect at
> /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/core.rb:147
>                (root) at ../scripts/rb/migrate_db.rb:28
>
>
>
> Regards,
>
> *__________________________*
>
> Brent Ellingson
>
> Software Developer
>
> 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
>
>


-- 
Brian Hoffman
brianjhoffman at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150123/07f9375e/attachment.html>