<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
<div>
<div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
Hi all-</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
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="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
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="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
Thanks!</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
Joshua</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<br>
</div>
<div>
<div><font face="Calibri,sans-serif">Error: </font></div>
<div><font face="Calibri,sans-serif"> #<Sequel::Error: Missing foreign key for [:repo_id]></font></div>
<div><font face="Calibri,sans-serif"> Missing foreign key for [:repo_id]</font></div>
<div><font face="Calibri,sans-serif"> /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:736:in `foreign_key_name'</font></div>
<div><font face="Calibri,sans-serif">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/adapters/shared/mysql.rb:227:in `alter_table_op_sql'</font></div>
<div><font face="Calibri,sans-serif">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:480:in `alter_table_sql_list'</font></div>
<div><font face="Calibri,sans-serif">org/jruby/RubyArray.java:1613:in `each'</font></div>
<div><font face="Calibri,sans-serif">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:478:in `alter_table_sql_list'</font></div>
<div><font face="Calibri,sans-serif">/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><font face="Calibri,sans-serif">org/jruby/RubyArray.java:1613:in `each'</font></div>
<div><font face="Calibri,sans-serif">/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><font face="Calibri,sans-serif">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:423:in `apply_alter_table_generator'</font></div>
<div><font face="Calibri,sans-serif">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:79:in `alter_table'</font></div>
<div><font face="Calibri,sans-serif">/Applications/archivesspace-v140/lib/common.jar!/db/migrations/059_add_on_cascade_delete_to_repo_fk.rb:12:in `(root)'</font></div>
<div><font face="Calibri,sans-serif">org/jruby/RubyBasicObject.java:1574:in `instance_eval'</font></div>
<div><font face="Calibri,sans-serif">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:100:in `apply'</font></div>
<div><font face="Calibri,sans-serif">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:528:in `run'</font></div>
<div><font face="Calibri,sans-serif">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:466:in `checked_transaction'</font></div>
<div><font face="Calibri,sans-serif">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:527:in `run'</font></div>
<div><font face="Calibri,sans-serif">org/jruby/RubyArray.java:1613:in `each'</font></div>
<div><font face="Calibri,sans-serif">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:524:in `run'</font></div>
<div><font face="Calibri,sans-serif">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:391:in `run'</font></div>
<div><font face="Calibri,sans-serif">file:/Applications/archivesspace-v140/lib/common.jar!/db/db_migrator.rb:185:in `setup_database'</font></div>
<div><font face="Calibri,sans-serif">../scripts/rb/migrate_db.rb:43:in `(root)'</font></div>
<div><font face="Calibri,sans-serif">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:69:in `connect'</font></div>
<div><font face="Calibri,sans-serif">/Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/core.rb:95:in `connect'</font></div>
<div><font face="Calibri,sans-serif">../scripts/rb/migrate_db.rb:28:in `(root)'</font></div>
<div><font face="Calibri,sans-serif"><br>
</font></div>
<div><font face="Calibri,sans-serif"> </font></div>
<div><font face="Calibri,sans-serif"> 3</font></div>
<div><font face="Calibri,sans-serif">Sequel::Error: Missing foreign key for [:repo_id]</font></div>
<div><font face="Calibri,sans-serif"> foreign_key_name at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:736</font></div>
<div><font face="Calibri,sans-serif"> alter_table_op_sql at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/adapters/shared/mysql.rb:227</font></div>
<div><font face="Calibri,sans-serif"> alter_table_sql_list at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:480</font></div>
<div><font face="Calibri,sans-serif"> each at org/jruby/RubyArray.java:1613</font></div>
<div><font face="Calibri,sans-serif"> alter_table_sql_list at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:478</font></div>
<div><font face="Calibri,sans-serif"> 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><font face="Calibri,sans-serif"> each at org/jruby/RubyArray.java:1613</font></div>
<div><font face="Calibri,sans-serif"> 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><font face="Calibri,sans-serif"> apply_alter_table_generator at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:423</font></div>
<div><font face="Calibri,sans-serif"> alter_table at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/database/schema_methods.rb:79</font></div>
<div><font face="Calibri,sans-serif"> (root) at /Applications/archivesspace-v140/lib/common.jar!/db/migrations/059_add_on_cascade_delete_to_repo_fk.rb:12</font></div>
<div><font face="Calibri,sans-serif"> instance_eval at org/jruby/RubyBasicObject.java:1574</font></div>
<div><font face="Calibri,sans-serif"> apply at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:100</font></div>
<div><font face="Calibri,sans-serif"> run at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:528</font></div>
<div><font face="Calibri,sans-serif"> checked_transaction at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:466</font></div>
<div><font face="Calibri,sans-serif"> run at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:527</font></div>
<div><font face="Calibri,sans-serif"> each at org/jruby/RubyArray.java:1613</font></div>
<div><font face="Calibri,sans-serif"> run at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:524</font></div>
<div><font face="Calibri,sans-serif"> run at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/extensions/migration.rb:391</font></div>
<div><font face="Calibri,sans-serif"> setup_database at file:/Applications/archivesspace-v140/lib/common.jar!/db/db_migrator.rb:185</font></div>
<div><font face="Calibri,sans-serif"> (root) at ../scripts/rb/migrate_db.rb:43</font></div>
<div><font face="Calibri,sans-serif"> connect at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/database/connecting.rb:69</font></div>
<div><font face="Calibri,sans-serif"> connect at /Applications/archivesspace-v140/gems/gems/sequel-4.20.0/lib/sequel/core.rb:95</font></div>
<div><font face="Calibri,sans-serif"> (root) at ../scripts/rb/migrate_db.rb:28</font></div>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<div id="MAC_OUTLOOK_SIGNATURE"></div>
</div>
</div>
</div>
</body>
</html>