Hello,
We have compiled in InnoDB support for MySQL 3.23.51. We would LOVE to take
advantage of the transactions and foreign key assignments that it provides.
We are having an issue, with the following SQL, however:
All of the alter table statements are ending with this error:
ERROR 1005: Can't create table './everbase/#sql-955_b.frm' (errno: 150)
I found references to a bug that was fixed in .51, but I can't find anything
as to what is going on. We think we have the syntax right, but some help
would be appreciated. Thanks!
-James
P.S. I also included my my.cnf file as well and the bottom.
create table FailedPaymentContact (
FailedPaymentContactGenKey int AUTO_INCREMENT PRIMARY KEY,
ClearingHouseCreditCardFKey int NOT NULL,
INDEX
iFailedPaymentContact_ClearingHouseCreditCardFKey(ClearingHouseCreditCardFKe
y),
ContactDate timestamp NOT NULL,
ValidContactTypeFKey int NOT NULL,
INDEX iFailedPaymentContact_ValidContactTypeFKey(ValidContactTypeFKey),
EmployeeFKey varchar(50) NOT NULL,
INDEX iFailedPaymentContact_EmployeeFKey(EmployeeFKey)
) TYPE = InnoDB;
ALTER TABLE FailedPaymentContact ADD CONSTRAINT
FK_FailedPaymentContact_N400038 FOREIGN KEY ( ClearingHouseCreditCardFKey )
REFERENCES
ClearingHouseCreditCard (ClearingHouseCreditCardGenKey)
ON DELETE SET NULL ON UPDATE CASCADE
;
ALTER TABLE FailedPaymentContact ADD CONSTRAINT
FK_FailedPaymentContact_N400041 FOREIGN KEY ( EmployeeFKey )
REFERENCES
Employee (EmployeeID)
ON DELETE SET NULL ON UPDATE CASCADE
;
ALTER TABLE FailedPaymentContact ADD CONSTRAINT
FK_FailedPaymentContact_N40004A FOREIGN KEY ( ValidContactTypeFKey )
REFERENCES
ValidContactType (ContactTypeID)
ON DELETE SET NULL ON UPDATE CASCADE
;
<MY.CNF>
[mysql@warbaby innodblogs]$ cat /etc/my.cnf
[mysqld]
log-bin=/storage/mysql/
server-id=1
default-table-type=innodb
innodb_data_home_dir=/storage/innodb
set-variable = innodb_mirrored_log_groups=1
#
#
innodb_data_file_path=indata1:2000M;indata2:2000M;indata3:2000M;indata4:2000
M;indata5:2000M;indata6:2000M
#
#
set-variable = innodb_buffer_pool_size=128M
set-variable = innodb_additional_mem_pool_size=80M
innodb_log_group_home_dir = /storage/innodblogs
#
#
innodb_log_arch_dir = /storage/innodblogs
innodb_log_archive = 0
set-variable = innodb_log_files_in_group=3
#
#
set-variable = innodb_log_file_size=100M
set-variable = innodb_log_buffer_size=16M
#
#
#
innodb_flush_log_at_trx_commit=1
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
