[Archivesspace_Users_Group] database crash on setup

[Holland, Andrew S]

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<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
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/7f320d6c/attachment.html>