[Archivesspace_Users_Group] database crash on setup

[Holland, Andrew S]

I appreciate the help Maura. I'm sending a note to my sys admins to look into the: UTC - mysqld got signal 6 I'm seeing before the crash. I think it might be a red hat bug.

-Andrew

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 3:09 PM
To: Archivesspace Users Group
Subject: Re: [Archivesspace_Users_Group] database crash on setup

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<mailto: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<mailto: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> [mailto: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<mailto: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<mailto: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<tel:%28781%29%20736-4659>
415 South Street, (MS 017/P.O. Box 549110)
Waltham, MA 02454-9110
email: mauraa at brandeis.edu<mailto:mauraa at brandeis.edu>

_______________________________________________
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group at lyralists.lyrasis.org<mailto: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<tel:%28781%29%20736-4659>
415 South Street, (MS 017/P.O. Box 549110)
Waltham, MA 02454-9110
email: mauraa at brandeis.edu<mailto: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<mailto:mauraa at brandeis.edu>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150527/800b31bc/attachment.html>