<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<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.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></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<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Regards,<o:p></o:p></p>
<p class="MsoNormal"><u><span style="font-size:10.0pt;color:#365F91">__________________________<o:p></o:p></span></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;color:#365F91">Brent Ellingson<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;color:#365F91">Software Developer<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;color:#365F91">2750 Harold B. Lee Library<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;color:#365F91">Brigham Young University<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;color:#365F91">(801)422-6148<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>