<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
I ran into the same problem. I used the refactored migration tool to migrate to ASpace 1.3.0 and then upgrade to 1.4.2 after that. It is a work around.
<div class=""><br class="">
</div>
<div class="">Thanks, </div>
<div class=""><br class="">
</div>
<div class="">Phil </div>
<div class=""><br class="">
</div>
<div class="">
<div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
Phillip Suda<o:p class=""></o:p></div>
<div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
Systems Librarian<o:p class=""></o:p></div>
<div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
Howard-Tilton Memorial Library<o:p class=""></o:p></div>
<div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
Tulane University<o:p class=""></o:p></div>
<div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<a href="mailto:psuda1@tulane.edu" style="color: rgb(149, 79, 114);" class="">psuda1@tulane.edu</a><o:p class=""></o:p></div>
<div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
504-865-5607</div>
</div>
<div class=""><br class="">
<div>
<blockquote type="cite" class="">
<div class="">On Nov 6, 2015, at 8:56 AM, Joshua D. Shaw <<a href="mailto:Joshua.D.Shaw@dartmouth.edu" class="">Joshua.D.Shaw@dartmouth.edu</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<div class="">
<div class="">
<div style="font-family: Calibri, sans-serif; font-size: 14px;" class="">Hi all-</div>
<div style="font-family: Calibri, sans-serif; font-size: 14px;" class=""><br class="">
</div>
<div style="font-family: Calibri, sans-serif; font-size: 14px;" class="">I'm starting to test the v1.4 releases and have run into an issue with migrations. v1.3.0 works just fine, but when I clone my db and then attempt to run the setup-database script for
any 1.4+ release, I get the error below. I've checked the table referenced in the migration file on line 12 (the job table) and the structure seems to be ok - at least there's a column labeled repo_id in there, though I have no data in that table.</div>
<div style="font-family: Calibri, sans-serif; font-size: 14px;" class=""><br class="">
</div>
<div style="font-family: Calibri, sans-serif; font-size: 14px;" class="">Any thoughts as to what might be the cause? We (Dartmouth) may be extra special since we are running a bunch of plugins.</div>
<div style="font-family: Calibri, sans-serif; font-size: 14px;" class=""><br class="">
</div>
<div style="font-family: Calibri, sans-serif; font-size: 14px;" class="">Thanks!</div>
<div style="font-family: Calibri, sans-serif; font-size: 14px;" class="">Joshua</div>
<div style="font-family: Calibri, sans-serif; font-size: 14px;" class=""><br class="">
</div>
<div class="">
<div class=""><font face="Calibri,sans-serif" class="">Error: </font></div>
<div class=""><font face="Calibri,sans-serif" class=""> #<Sequel::Error: Missing foreign key for [:repo_id]></font></div>
<div class=""><font face="Calibri,sans-serif" class=""> Missing foreign key for [:repo_id]</font></div>
<div class=""><font face="Calibri,sans-serif" class=""> /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:736:in `foreign_key_name'</font></div>
<div class=""><font face="Calibri,sans-serif" class="">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/adapters/shared/mysql.rb:227:in `alter_table_op_sql'</font></div>
<div class=""><font face="Calibri,sans-serif" class="">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:480:in `alter_table_sql_list'</font></div>
<div class=""><font face="Calibri,sans-serif" class="">org/jruby/RubyArray.java:1613:in `each'</font></div>
<div class=""><font face="Calibri,sans-serif" class="">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:478:in `alter_table_sql_list'</font></div>
<div class=""><font face="Calibri,sans-serif" class="">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/adapters/utils/split_alter_table.rb:35:in `apply_alter_table'</font></div>
<div class=""><font face="Calibri,sans-serif" class="">org/jruby/RubyArray.java:1613:in `each'</font></div>
<div class=""><font face="Calibri,sans-serif" class="">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/adapters/utils/split_alter_table.rb:33:in `apply_alter_table'</font></div>
<div class=""><font face="Calibri,sans-serif" class="">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:423:in `apply_alter_table_generator'</font></div>
<div class=""><font face="Calibri,sans-serif" class="">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:79:in `alter_table'</font></div>
<div class=""><font face="Calibri,sans-serif" class="">/Applications/archivesspace-v140/lib/common.jar!/db/migrations/059_add_on_cascade_delete_to_repo_fk.rb:12:in `(root)'</font></div>
<div class=""><font face="Calibri,sans-serif" class="">org/jruby/RubyBasicObject.java:1574:in `instance_eval'</font></div>
<div class=""><font face="Calibri,sans-serif" class="">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:100:in `apply'</font></div>
<div class=""><font face="Calibri,sans-serif" class="">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:528:in `run'</font></div>
<div class=""><font face="Calibri,sans-serif" class="">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:466:in `checked_transaction'</font></div>
<div class=""><font face="Calibri,sans-serif" class="">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:527:in `run'</font></div>
<div class=""><font face="Calibri,sans-serif" class="">org/jruby/RubyArray.java:1613:in `each'</font></div>
<div class=""><font face="Calibri,sans-serif" class="">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:524:in `run'</font></div>
<div class=""><font face="Calibri,sans-serif" class="">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:391:in `run'</font></div>
<div class=""><font face="Calibri,sans-serif" class="">file:/Applications/archivesspace-v140/lib/common.jar!/db/db_migrator.rb:185:in `setup_database'</font></div>
<div class=""><font face="Calibri,sans-serif" class="">../scripts/rb/migrate_db.rb:43:in `(root)'</font></div>
<div class=""><font face="Calibri,sans-serif" class="">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:69:in `connect'</font></div>
<div class=""><font face="Calibri,sans-serif" class="">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/core.rb:95:in `connect'</font></div>
<div class=""><font face="Calibri,sans-serif" class="">../scripts/rb/migrate_db.rb:28:in `(root)'</font></div>
<div class=""><font face="Calibri,sans-serif" class=""><br class="">
</font></div>
<div class=""><font face="Calibri,sans-serif" class=""> </font></div>
<div class=""><font face="Calibri,sans-serif" class=""> 3</font></div>
<div class=""><font face="Calibri,sans-serif" class="">Sequel::Error: Missing foreign key for [:repo_id]</font></div>
<div class=""><font face="Calibri,sans-serif" class=""> foreign_key_name at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:736</font></div>
<div class=""><font face="Calibri,sans-serif" class=""> alter_table_op_sql at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/adapters/shared/mysql.rb:227</font></div>
<div class=""><font face="Calibri,sans-serif" class=""> alter_table_sql_list at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:480</font></div>
<div class=""><font face="Calibri,sans-serif" class=""> each at org/jruby/RubyArray.java:1613</font></div>
<div class=""><font face="Calibri,sans-serif" class=""> alter_table_sql_list at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:478</font></div>
<div class=""><font face="Calibri,sans-serif" class=""> apply_alter_table at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/adapters/utils/split_alter_table.rb:35</font></div>
<div class=""><font face="Calibri,sans-serif" class=""> each at org/jruby/RubyArray.java:1613</font></div>
<div class=""><font face="Calibri,sans-serif" class=""> apply_alter_table at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/adapters/utils/split_alter_table.rb:33</font></div>
<div class=""><font face="Calibri,sans-serif" class=""> apply_alter_table_generator at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:423</font></div>
<div class=""><font face="Calibri,sans-serif" class=""> alter_table at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:79</font></div>
<div class=""><font face="Calibri,sans-serif" class=""> (root) at /Applications/archivesspace-v140/lib/common.jar!/db/migrations/059_add_on_cascade_delete_to_repo_fk.rb:12</font></div>
<div class=""><font face="Calibri,sans-serif" class=""> instance_eval at org/jruby/RubyBasicObject.java:1574</font></div>
<div class=""><font face="Calibri,sans-serif" class=""> apply at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:100</font></div>
<div class=""><font face="Calibri,sans-serif" class=""> run at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:528</font></div>
<div class=""><font face="Calibri,sans-serif" class=""> checked_transaction at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:466</font></div>
<div class=""><font face="Calibri,sans-serif" class=""> run at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:527</font></div>
<div class=""><font face="Calibri,sans-serif" class=""> each at org/jruby/RubyArray.java:1613</font></div>
<div class=""><font face="Calibri,sans-serif" class=""> run at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:524</font></div>
<div class=""><font face="Calibri,sans-serif" class=""> run at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:391</font></div>
<div class=""><font face="Calibri,sans-serif" class=""> setup_database at file:/Applications/archivesspace-v140/lib/common.jar!/db/db_migrator.rb:185</font></div>
<div class=""><font face="Calibri,sans-serif" class=""> (root) at ../scripts/rb/migrate_db.rb:43</font></div>
<div class=""><font face="Calibri,sans-serif" class=""> connect at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:69</font></div>
<div class=""><font face="Calibri,sans-serif" class=""> connect at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/core.rb:95</font></div>
<div class=""><font face="Calibri,sans-serif" class=""> (root) at ../scripts/rb/migrate_db.rb:28</font></div>
</div>
<div style="font-family: Calibri, sans-serif; font-size: 14px;" class=""><br class="">
</div>
<div style="font-family: Calibri, sans-serif; font-size: 14px;" class="">
<div id="MAC_OUTLOOK_SIGNATURE" class=""></div>
</div>
</div>
</div>
</div>
_______________________________________________<br class="">
Archivesspace_Users_Group mailing list<br class="">
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" class="">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br class="">
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<br class="">
</div>
</blockquote>
</div>
<br class="">
<div apple-content-edited="true" class="">
<div class="">
<div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<br class="">
</div>
</div>
</div>
<br class="">
</div>
</body>
</html>