You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@juddi.apache.org by "David Smiley (JIRA)" <ju...@ws.apache.org> on 2004/11/03 23:04:33 UTC
[jira] Created: (JUDDI-44) MySQL "InnoDB" complains of foreign keys with jUDDI schema
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
[jira] Resolved: (JUDDI-44) MySQL "InnoDB" complains of foreign
keys with jUDDI schema
Posted by "Kurt Stam (JIRA)" <ju...@ws.apache.org>.
[ 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
[jira] Commented: (JUDDI-44) MySQL "InnoDB" complains of foreign keys with jUDDI schema
Posted by "Steve Viens (JIRA)" <ju...@ws.apache.org>.
[ http://issues.apache.org/jira/browse/JUDDI-44?page=comments#action_61070 ]
Steve Viens commented on JUDDI-44:
----------------------------------
More information on MySQL InnoDB Foreign Key Constraints: http://dev.mysql.com/doc/mysql/en/innodb-foreign-key-constraints.html
> MySQL "InnoDB" complains of foreign keys with jUDDI schema
> ----------------------------------------------------------
>
> Key: JUDDI-44
> URL: http://issues.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
> Assignee: 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://issues.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
[jira] Commented: (JUDDI-44) MySQL "InnoDB" complains of foreign keys with jUDDI schema
Posted by "Steve Viens (JIRA)" <ju...@ws.apache.org>.
[ http://issues.apache.org/jira/browse/JUDDI-44?page=comments#action_61069 ]
Steve Viens commented on JUDDI-44:
----------------------------------
>From the online MySQL Manual: InnoDB Error Codes
1005 (ER_CANT_CREATE_TABLE)
Cannot create table. If the error message string refers to errno 150, table creation failed because a foreign key constraint was not correctly formed.
Source:
http://dev.mysql.com/doc/mysql/en/innodb-error-codes.html
> MySQL "InnoDB" complains of foreign keys with jUDDI schema
> ----------------------------------------------------------
>
> Key: JUDDI-44
> URL: http://issues.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
> Assignee: 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://issues.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
[jira] Updated: (JUDDI-44) MySQL "InnoDB" complains of foreign keys
with jUDDI schema
Posted by "Steve Viens (JIRA)" <ju...@ws.apache.org>.
[ 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: juddi-dev-unsubscribe@ws.apache.org
For additional commands, e-mail: juddi-dev-help@ws.apache.org
[jira] Commented: (JUDDI-44) MySQL "InnoDB" complains of foreign
keys with jUDDI schema
Posted by "Kurt Stam (JIRA)" <ju...@ws.apache.org>.
[ https://issues.apache.org/jira/browse/JUDDI-44?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12511926 ]
Kurt Stam commented on JUDDI-44:
--------------------------------
I'm not seeing this issue using mysql5. I think if we don't get any more reports on this in the next few weeks we should "reject" the issue, assuming it was a mysql4 problem.
> 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: 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: juddi-dev-unsubscribe@ws.apache.org
For additional commands, e-mail: juddi-dev-help@ws.apache.org