I just converted several tables to InnoDB on our Linux 3.23.49a (binary from MySQL.com). After running our production system against it for about 10 minutes, InnoDB crashed with a stack trace:
---snip--- /home/mysql/bin/mysqld: ready for connections InnoDB: Assertion failure in thread 159781 in file ha_innobase.cc line 302 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail 0x806dc04 0x82ad1a8 0x80be1ca 0x80c0aee 0x80b4604 0x809f782 0x804ec80 0x806784d 0x806d8e4 0x80731a1 Stack trace seems successful - bottom reached Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instr uctions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at (nil) is invalid pointer thd->thread_id=3 ---snip--- However, there are no symbols in the mysqld binary so that I can resolve the bug. The trace was identical both times. I've just converted the tables back to MyISAM and will run like this I guess. Is anyone using the pre-release 3.23.50 in production yet? Or should I build my own 3.23.51 and try that? Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 4.0.2: up 0 days, processed 3,903,167 queries (96/sec. avg) --------------------------------------------------------------------- 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