[
https://issues.apache.org/jira/browse/JUDDI-44?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Steve Viens updated JUDDI-44:
-----------------------------
Priority: Minor (was: Major)
Changing priority to Minor as this issue hasn't come up much (this is the only
report I've seen). Not saying this isn't something that needs to be fixed -
just that it shouldn't hold up the next release.
> 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
> Assigned To: Steve Viens
> 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
