Aleksandr, thank you for the bug report. Please upgrade to 4.0.2.
>From http://www.innodb.com/bugfixes.html: February 10, 2002: If one defines a non-latin1 character set as the default character set, then definition of foreign key constraints may fail in an assertion failure in dict0crea.c, reporting an internal error 17. Fixed in 3.23.49 and 4.0.2. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com ----- Original Message ----- From: ""Александр Степаненко"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, August 19, 2002 11:47 AM Subject: BUG in 4.0.1 - alpha > ___________________________________________ > > MySQL version 4.0.1-alpha on Win 2000 Server SP2 Rus > ___________________________________________ > > # mysql config file. > > # This will be passed to all mysql clients > [client] > #password=my_password > port=3306 > #socket=MySQL > > # Here is entries for some specific programs > # The following values assume you have at least 32M ram > > # The MySQL server > [mysqld] > port=3306 > #socket=MySQL > skip-locking > default-character-set=cp1251 > set-variable = key_buffer=16M > set-variable = max_allowed_packet=1M > set-variable = thread_stack=128K > set-variable = flush_time=1800 > > # Uncomment the following rows if you move the MySQL distribution to another > # location > basedir = c:/mysql/ > datadir = c:/mysql/data/ > > # Uncomment the following rows if you are using InnoDB tables > # Create the directories ibdata and iblogs before to start the server. > # If necessary, modify the size of the files > > innodb_data_file_path = ibdata1:50M > innodb_data_home_dir = c:\mysql\ibdata > set-variable = innodb_mirrored_log_groups=1 > innodb_log_group_home_dir = c:\mysql\ibdata > set-variable = innodb_log_files_in_group=3 > set-variable = innodb_log_file_size=30M > set-variable = innodb_log_buffer_size=8M > innodb_flush_log_at_trx_commit=1 > innodb_log_arch_dir = c:\mysql\ibdata > innodb_log_archive=0 > set-variable = innodb_buffer_pool_size=80M > set-variable=lower_case_table_names =0 > set-variable = innodb_additional_mem_pool_size=10M > set-variable = innodb_file_io_threads=4 > set-variable = innodb_lock_wait_timeout=50 > > # Uncomment the following row if you are using a Max server and you don't > want the > # InnoDb tables > > #skip-innodb > > [mysqldump] > quick > set-variable = max_allowed_packet=16M > > [mysql] > no-auto-rehash > > [isamchk] > set-variable= key=16M > > [client_fltk] > help_file= c:\mysql\sql_client\MySQL.help > client_file= c:\mysql\MySQL.options > history_length=20 > database = test > queries_root= c:\mysql\queries > last_database_file= c:\mysql\lastdb > > ___________________________________________ > > USE IBANK; > DROP TABLE IF EXISTS IB_USERS; > > CREATE TABLE IB_USERS( > USR VARCHAR(30) NOT NULL, > PWD VARCHAR(30) NOT NULL, > USERID NUMERIC(10) NOT NULL, > ISLOCKED DATE, > PRIMARY KEY(USR, PWD), > UNIQUE(USERID)) > TYPE=INNODB > > DROP TABLE IF EXISTS IB_USERSKEYS; > > CREATE TABLE IB_USERSKEYS( > USERID NUMERIC(10) NOT NULL, > STARTDATE DATE NOT NULL, > MANAGERID NUMERIC(10) NOT NULL, > KEYAC BLOB, > KEYCH BLOB, > PRIMARY KEY(USERID, STARTDATE), > FOREIGN KEY(USERID) REFERENCES IB_USERS(USERID) ON DELETE NO ACTION) > TYPE=INNODB > ___________________________________________ > > InnoDB: foreign constraint creation failed; > InnoDB: internal error number 17 > InnoDB: Assertion failure in thread 872 in file > C:\build\innobase\dict\dict0crea > .c line 1241 > InnoDB: We intentionally generate a memory trap. > InnoDB: Send a detailed bug report to [EMAIL PROTECTED] > > ___________________________________________ > > So, I sent. > > Best regards, Alex Stepanenko > > ___________________________________________ > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
