[Archivesspace_Users_Group] database crash on setup

[Maura Carbone]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150527/244a8ae8/attachment.html>