Harald, I tested the below with 3.23.48, and it worked ok.
Could it be that you have not used DROP TABLE or DROP DATABASE to remove InnoDB tables? Then the internal data dictionary may be out-of-sync from the .frm files of your tables. Please use innodb_table_monitor (section 9.1 in http://www.innodb.com/ibman.html ) to print the contents of the internal data dictionary, and compare it to the .frm files you have for the tables. Please send the output to the mailing list. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB Harald Fuchs wrote in message ... >(MySQL 4.0.1-alpha-Max-log, your Linux binary) > >The following works fine (just a slight variation of what is in the manual): > > CREATE TABLE t1 ( > id INT UNSIGNED NOT NULL AUTO_INCREMENT, > PRIMARY KEY (id) > ) TYPE=InnoDB; > > CREATE TABLE t2 ( > id INT UNSIGNED NOT NULL AUTO_INCREMENT, > t1id INT UNSIGNED NOT NULL, > PRIMARY KEY (id), > KEY (t1id), > FOREIGN KEY (t1id) REFERENCES t1(id) > ) TYPE=InnoDB; > >The following, however, crashes MySQL: > > CREATE TABLE t1 ( > id INT UNSIGNED NOT NULL AUTO_INCREMENT, > PRIMARY KEY (id) > ) TYPE=InnoDB; > > CREATE TABLE t2 ( > id INT UNSIGNED NOT NULL AUTO_INCREMENT, > t1id INT UNSIGNED NOT NULL, > PRIMARY KEY (id), > KEY (t1id), > FOREIGN KEY (t1id) REFERENCES t1(id) > ) TYPE=InnoDB; > > CREATE TABLE t3 ( > id INT UNSIGNED NOT NULL AUTO_INCREMENT, > t2id INT UNSIGNED NOT NULL, > PRIMARY KEY (id), > KEY (t2id), > FOREIGN KEY (t2id) REFERENCES t2(id) > ) TYPE=InnoDB; > >The log file says: > > InnoDB: foreign constraint creation failed; > InnoDB: internal error number 17 > InnoDB: Assertion failure in thread 45067 in file dict0crea.c line 1241 > InnoDB: We intentionally generate a memory trap. > InnoDB: Send a detailed bug report to [EMAIL PROTECTED] > mysqld got signal 11; > >I can send you the stack trace if necessary. --------------------------------------------------------------------- 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
