[Archivesspace_Users_Group] database crash on setup

[Maura Carbone]

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!
-Maura

On Wed, May 27, 2015 at 2:31 PM, Maura Carbone <mauraa at brandeis.edu> wrote:

> 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:
>
> down do
>
>     remaining = tables.reject {|t| t == :schema_info}
>
>     ceiling = 100
>
>     begin
>
>       greylist = []
>
>       remaining.each do |table|
>         foreign_key_list(table).each do |fk|
>
>           next if fk[:table] == table
>           if (not greylist.include?(fk[:table])) &&
> remaining.include?(fk[:table])
>             greylist << fk[:table]
>           end
>         end
>       end
>
>       remaining.each do |table|
>         if not greylist.include?(table)
>           puts "Dropping #{table}"
>           drop_table?(table)
>         end
>       end
>
>       remaining = greylist.clone
>       ceiling = ceiling - 1
>
>     end while (not remaining.empty?) && ceiling > 0
>
>   end
>
> Not an expert on this though, so I could be wrong.
>
> -Maura
>
> On Wed, May 27, 2015 at 2:04 PM, Holland, Andrew S <
> andrew-holland at uiowa.edu> wrote:
>
>>  My logs don't show that one way or another. Not that I've seen anyway.
>> Here's the tables that are being created:
>>
>>
>>
>> accession
>>
>>  agent_corporate_entity
>>
>>  agent_family
>>
>>  agent_person
>>
>>  agent_software
>>
>>  auth_db
>>
>>  enumeration
>>
>>  enumeration_value
>>
>>  group
>>
>>  group_permission
>>
>>  group_user
>>
>>  notification
>>
>>  permission
>>
>>  repository
>>
>>  schema_info
>>
>>  session
>>
>>  user
>>
>>
>>
>> *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
>> archivesspace_users_group-bounces at lyralists.lyrasis.org] *On Behalf Of *Maura
>> Carbone
>> *Sent:* Wednesday, May 27, 2015 12:54 PM
>> *To:* Archivesspace Users Group
>> *Subject:* Re: [Archivesspace_Users_Group] database crash on setup
>>
>>
>>
>> Hi Andrew,
>>
>> 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?
>>
>>
>>
>> -Maura
>>
>>
>>
>> On Wed, May 27, 2015 at 1:03 PM, Holland, Andrew S <
>> andrew-holland at uiowa.edu> wrote:
>>
>>  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:
>>
>>
>>
>> Some pointers may be invalid and cause the dump to abort.
>>
>> Query (17d2440): ALTER TABLE `resource` ADD FOREIGN KEY (`accession_id`)
>> REFERENCES `accession`(`id`)
>>
>>
>>
>> Looking through what tables were created before the failure, `resource`
>> wasn't there yet.
>>
>>
>>
>> Anyone have thoughts on why this isn't working?
>>
>>
>>
>> Andrew Holland
>>
>> Web Applications Developer, LIT
>>
>>
>> _______________________________________________
>> Archivesspace_Users_Group mailing list
>> Archivesspace_Users_Group at lyralists.lyrasis.org
>> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>>
>>
>>
>>
>>
>> --
>>
>> Maura Carbone
>>
>> Digital Initiatives Librarian
>> Brandeis University
>> Library and Technology Services
>> (781) 736-4659
>> 415 South Street, (MS 017/P.O. Box 549110)
>> Waltham, MA 02454-9110
>> email: mauraa at brandeis.edu
>>
>> _______________________________________________
>> Archivesspace_Users_Group mailing list
>> Archivesspace_Users_Group at lyralists.lyrasis.org
>> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>>
>>
>
>
> --
> Maura Carbone
> Digital Initiatives Librarian
> Brandeis University
> Library and Technology Services
> (781) 736-4659
> 415 South Street, (MS 017/P.O. Box 549110)
> Waltham, MA 02454-9110
> email: mauraa at brandeis.edu
>



-- 
Maura Carbone
Digital Initiatives Librarian
Brandeis University
Library and Technology Services
(781) 736-4659
415 South Street, (MS 017/P.O. Box 549110)
Waltham, MA 02454-9110
email: mauraa at brandeis.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150527/02413be6/attachment.html>