Synopsis: Innobase: Assertion failure Originator: Mike Smith Organization: Thinking Arts Release: mysql-3.23.38-win (binary) Exectutable: mysqld Environment: Win 98 System: Dell Pentium 111 with 512 Meg memory Compiler: N/AArchitecture: i --------------------- Description Mysql installed and ran OK until I amended my.cnf to include support for Innobase. (A copy of the my.cnf file is appended below.) Mysql created the necessary files correctly but then consistently crashes with the error:Innobase: Assertion failure in thread 4293291367 in file M:\mysql-3.23\innobase\os\os0file.c line 187 Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to mys...@lists.mysql.com 010612 12:54:04 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 11. Aborting! 010612 12:54:04 Aborting InnoDB: Warning: shutting down not properly started database 010612 12:54:04 C:\MYSQL\BIN\MYSQLD.EXE: Shutdown Complete -----------------------------Repeat----------------------------------------

-------- Install mysql and then add the appended my.cnf file in C:\.--------------------- my.cnf------------------------------------------------------ # This will be passed to all mysql clients[client]#password=my_passwordport=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=MySQLskip-lockingset-variable = key_buffer=16M set-variable = max_allowed_packet=1Mset-variable = thread_stack=128K set-variable = flush_time=1800#innodb added by me innodb_data_file_path = ibdata1:100M;ibdata2:100M innodb_data_home_dir = C:\mysql\ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = C:\mysql\ibdata\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30Mset-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1innodb_log_arch_dir = C:\mysql\ibdata\iblogs innodb_log_archive=0set-variable = innodb_buffer_pool_size=80M 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 move the MySQL distribution toanother # location#basedir = d:/mysql/[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.optionshistory_length=20database = test queries_root= c:\mysql\querieslast_database_file= c:\mysql\lastdb-- Michael H SmithEmail: mike@thinkingarts.comVisit: www.thinkingarts.com