juddi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Smiley (JIRA)" <juddi-...@ws.apache.org>
Subject [jira] Created: (JUDDI-44) MySQL "InnoDB" complains of foreign keys with jUDDI schema
Date Wed, 03 Nov 2004 22:04:33 GMT
MySQL "InnoDB" complains of foreign keys with jUDDI schema
----------------------------------------------------------

         Key: JUDDI-44
         URL: http://nagoya.apache.org/jira/browse/JUDDI-44
     Project: jUDDI
        Type: Bug
    Versions: 0.9rc3    
 Environment: Mac OS X 10.3.5, MySQL 4.0.21
    Reporter: David Smiley
 Assigned to: Steve Viens 


I prefer to use the "InnoDB" MySQL storage engine whenever possible because it is the only
one that is ACID compliant.  I tried to load the create_database.sql script though I got 3
errors.  MySQL couldn't create the BUSINESS_SERVICE, BINDING_TEMPLATE, and PUBLISHER_ASSERTION
tables for the same reason:
ERROR 1005: Can't create table './juddi/<table-name-here>.frm' (errno: 150)
This is an InnoDB error code that has to do with foreign key constraints.  I've searched the
net a bit and studied the SQL hard and I really can't figure out why it's failing.

Good luck fixing this one.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://nagoya.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira


Mime
View raw message