[ 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
