<div dir="ltr"><div><div>Hi Brent,<br><br></div>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?<br><br></div>Brian<br><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Jan 23, 2015 at 2:53 PM, Brent Ellingson <span dir="ltr"><<a href="mailto:brent_ellingson@byu.edu" target="_blank">brent_ellingson@byu.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p class="MsoNormal">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.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p style="margin-bottom:12.0pt"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">#
<em><span style="font-family:"Arial","sans-serif"">scripts/setup-database.sh</span></em><br>
Loading ArchivesSpace configuration file from path: file:/opt/archivesspace-1.1.2/archivesspace/lib/common.jar!/config/config.rb<br>
Loading ArchivesSpace configuration file from path: /opt/archivesspace-1.1.2/archivesspace/config/config.rb<br>
Loading ArchivesSpace configuration file from path: /opt/archivesspace-1.1.2/archivesspace/config/config.rb<br>
Running migrations against jdbc:mysql://localhost:3306/archivesspace100?user=DBUSER&password=DBPASSWORD&useUnicode=true&characterEncoding=UTF-8<br>
Adding separate permissions for updating major record types<br>
Updating groups to include the new permssions<br>
Sequel::DatabaseError: Java::ComMysqlJdbcExceptionsJdbc4::MySQLIntegrityConstraintViolationException: Duplicate entry '27-1' for key 'group_permission_permission_id_group_id_index'<br>
raise_error at /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/database/misc.rb:313<br>
statement at /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/adapters/jdbc.rb:563<br>
execute at /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/adapters/jdbc.rb:255<br>
hold at /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/connection_pool/threaded.rb:104<br>
synchronize at /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/database/connecting.rb:240<br>
execute at /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/adapters/jdbc.rb:254<br>
execute_insert at /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/adapters/jdbc.rb:283<br>
execute_insert at /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/dataset/actions.rb:778<br>
insert at /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/dataset/actions.rb:317<br>
(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<br>
each at org/jruby/RubyArray.java:1613<br>
(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<br>
instance_eval at org/jruby/RubyBasicObject.java:1533<br>
apply at /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/extensions/migration.rb:94<br>
run at /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/extensions/migration.rb:519<br>
checked_transaction at /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/extensions/migration.rb:456<br>
run at /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/extensions/migration.rb:518<br>
each at org/jruby/RubyArray.java:1613<br>
run at /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/extensions/migration.rb:514<br>
run at /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/extensions/migration.rb:381<br>
setup_database at file:/opt/archivesspace-1.1.2/archivesspace/lib/common.jar!/db/db_migrator.rb:184<br>
(root) at ../scripts/rb/migrate_db.rb:43<br>
connect at /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/database/connecting.rb:80<br>
connect at /opt/archivesspace-1.1.2/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/core.rb:147<br>
(root) at ../scripts/rb/migrate_db.rb:28<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Regards,<u></u><u></u></p>
<p class="MsoNormal"><u><span style="font-size:10.0pt;color:#365f91">__________________________<u></u><u></u></span></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;color:#365f91">Brent Ellingson<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;color:#365f91">Software Developer<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;color:#365f91">2750 Harold B. Lee Library<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;color:#365f91">Brigham Young University<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;color:#365f91"><a href="tel:%28801%29422-6148" value="+18014226148" target="_blank">(801)422-6148</a><u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
<br>_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature">Brian Hoffman<br><a href="mailto:brianjhoffman@gmail.com">brianjhoffman@gmail.com</a></div>
</div>