<div dir="ltr">So after talking to someone who knows RoR, the up down might not be DB checks (my googling was not totally clear), but it does look like for whatever reason it is stopping at the make resource table line. But if he has any insights I'll let you know!<div>-Maura</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, May 27, 2015 at 2:31 PM, Maura Carbone <span dir="ltr"><<a href="mailto:mauraa@brandeis.edu" target="_blank">mauraa@brandeis.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">I think the presence of schema_info means you're losing your connection, which I think was a problem for you before, and resource isn't being created. schema_info appears in the 'down check' part of the migration script code:<div><br></div><div><div>down do</div><div><br></div><div> remaining = tables.reject {|t| t == :schema_info}</div><div><br></div><div> ceiling = 100</div><div><br></div><div> begin</div><div> </div><div> greylist = []</div><div> </div><div> remaining.each do |table|</div><div> foreign_key_list(table).each do |fk|</div><div><br></div><div> next if fk[:table] == table</div><div> if (not greylist.include?(fk[:table])) && remaining.include?(fk[:table])</div><div> greylist << fk[:table]</div><div> end </div><div> end</div><div> end</div><div><br></div><div> remaining.each do |table|</div><div> if not greylist.include?(table)</div><div> puts "Dropping #{table}"</div><div> drop_table?(table)</div><div> end</div><div> end</div><div> </div><div> remaining = greylist.clone</div><div> ceiling = ceiling - 1</div><div> </div><div> end while (not remaining.empty?) && ceiling > 0</div><div><br></div><div> end</div></div><div><br></div><div>Not an expert on this though, so I could be wrong.</div><span class="HOEnZb"><font color="#888888"><div><br></div><div>-Maura</div></font></span></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Wed, May 27, 2015 at 2:04 PM, Holland, Andrew S <span dir="ltr"><<a href="mailto:andrew-holland@uiowa.edu" target="_blank">andrew-holland@uiowa.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">My logs don't show that one way or another. Not that I've seen anyway. Here's the tables that are being created:
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">accession
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> agent_corporate_entity
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> agent_family
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> agent_person
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> agent_software
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> auth_db
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> enumeration
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> enumeration_value
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> group
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> group_permission
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> group_user
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> notification
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> permission <u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> repository
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> schema_info
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> session
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> user<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> [mailto:<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>]
<b>On Behalf Of </b>Maura Carbone<br>
<b>Sent:</b> Wednesday, May 27, 2015 12:54 PM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] database crash on setup<u></u><u></u></span></p><div><div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">Hi Andrew,<u></u><u></u></p>
<div>
<p class="MsoNormal">Is it trying to create resource and failing? Looking at some of the code, it looks like the resource table is supposed to be created right after the accession table. Does it show that being attempted at all in your logs?<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">-Maura<u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">On Wed, May 27, 2015 at 1:03 PM, Holland, Andrew S <<a href="mailto:andrew-holland@uiowa.edu" target="_blank">andrew-holland@uiowa.edu</a>> wrote:<u></u><u></u></p>
<blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<p class="MsoNormal">I've started a thread last week about our database setup failing. I was digging through my mysqld logs and it looks like this is where it's causing my server to crash:
<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">Some pointers may be invalid and cause the dump to abort.<u></u><u></u></p>
<p class="MsoNormal">Query (17d2440): ALTER TABLE `resource` ADD FOREIGN KEY (`accession_id`) REFERENCES `accession`(`id`)<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">Looking through what tables were created before the failure, `resource` wasn't there yet.
<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">Anyone have thoughts on why this isn't working?
<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal"><span style="font-family:"Garamond",serif">Andrew Holland</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-family:"Garamond",serif">Web Applications Developer, LIT</span><u></u><u></u></p>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">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><u></u><u></u></p>
</blockquote>
</div>
<p class="MsoNormal"><br>
<br clear="all">
<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<p class="MsoNormal">-- <u></u><u></u></p>
<div>
<div>
<p class="MsoNormal">Maura Carbone<u></u><u></u></p>
<div>
<p class="MsoNormal">Digital Initiatives Librarian<br>
Brandeis University<br>
Library and Technology Services<br>
<a href="tel:%28781%29%20736-4659" value="+17817364659" target="_blank">(781) 736-4659</a><br>
415 South Street, (MS 017/P.O. Box 549110)<br>
Waltham, MA 02454-9110<br>
email: <a href="mailto:mauraa@brandeis.edu" target="_blank">mauraa@brandeis.edu</a><u></u><u></u></p>
</div>
</div>
</div>
</div>
</div></div></div>
</div>
<br>_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">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"><div><br></div>-- <br><div><div dir="ltr">Maura Carbone<div>Digital Initiatives Librarian<br>Brandeis University<br>Library and Technology Services<br><a href="tel:%28781%29%20736-4659" value="+17817364659" target="_blank">(781) 736-4659</a><br>415 South Street, (MS 017/P.O. Box 549110)<br>Waltham, MA 02454-9110<br>email: <a href="mailto:mauraa@brandeis.edu" target="_blank">mauraa@brandeis.edu</a><br></div></div></div>
</div>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr">Maura Carbone<div>Digital Initiatives Librarian<br>Brandeis University<br>Library and Technology Services<br>(781) 736-4659<br>415 South Street, (MS 017/P.O. Box 549110)<br>Waltham, MA 02454-9110<br>email: <a href="mailto:mauraa@brandeis.edu" target="_blank">mauraa@brandeis.edu</a><br></div></div></div>
</div>