juddi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kurt Stam (JIRA)" <juddi-...@ws.apache.org>
Subject [jira] Resolved: (JUDDI-44) MySQL "InnoDB" complains of foreign keys with jUDDI schema
Date Fri, 27 Jul 2007 15:36:19 GMT

     [ https://issues.apache.org/jira/browse/JUDDI-44?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Kurt Stam resolved JUDDI-44.
----------------------------

    Resolution: Cannot Reproduce
      Assignee: Kurt Stam  (was: Steve Viens)

Can no longer reproduce this. I ran with MySQL5. Please reopen if this is still an issue.

> MySQL "InnoDB" complains of foreign keys with jUDDI schema
> ----------------------------------------------------------
>
>                 Key: JUDDI-44
>                 URL: https://issues.apache.org/jira/browse/JUDDI-44
>             Project: jUDDI
>          Issue Type: Bug
>    Affects Versions: 0.9rc3
>         Environment: Mac OS X 10.3.5, MySQL 4.0.21
>            Reporter: David Smiley
>            Assignee: Kurt Stam
>            Priority: Minor
>
> 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.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: juddi-dev-unsubscribe@ws.apache.org
For additional commands, e-mail: juddi-dev-help@ws.apache.org


Mime
View raw message