Resolution: Cannot Reproduce
Affects Version/s: 0.9rc3
Fix Version/s: None
Environment:Mac OS X 10.3.5, MySQL 4.0.21
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.
|Field||Original Value||New Value|
|Priority||Major [ 3 ]||Minor [ 4 ]|
|Assignee||Steve Viens [ sviens ]||Kurt Stam [ kurtstam ]|
|Status||Open [ 1 ]||Resolved [ 5 ]|
|Resolution||Cannot Reproduce [ 5 ]|
|Status||Resolved [ 5 ]||Closed [ 6 ]|