Environment: I'm setting up a database server on a Dell Poweredge 2650, dual 1.8GHZ pentium with 1GB of memory and RAID5 drives. I've installed RedHat 9, and updated the kernel to 2.4.20-19.9smp. I've installed the RPM binary distribution of MySQL 4.0.14 right from the MySQL website. The only thing I have done is disable InnoDb in my my.cnf file.
Database Table: I have a database with 21.4 million records. One field is a VARCHAR(255) field on which I have created a FULLTEXT index. Problem: Most single word full text searches work perfectly and quickly. Occasionally, when someone enters several words (without any operators), MySQL will crash with the following in the error log (see below). This is totally consistent, and MySQL will crash on the same submitted search text each time. Then other, more complex terms will work. But I can make MySQL crash every time with the query below in the error log. I've already rebuilt the fulltext index with myisamchk, and there are no writes to this table at all - it's totally read only. I'm not sure what to do next - I don't want to have my database crashing every hour when someone submits a valid search term that trips up the database. Any help would be most appreciated. Thanks, -Hank --------------- 030813 12:37:09 mysqld started /usr/sbin/mysqld: ready for connections. Version: '4.0.14-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 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 against 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. key_buffer_size=8388600 read_buffer_size=131072 max_used_connections=3 max_connections=100 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 225791 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x84c4408 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbff3e528, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x807474f 0x82a0ad8 0x82ca717 0x82891c3 0x827b037 0x8289956 0x828992c 0x828986b 0x827b2de 0x827946f 0x83328c1 0x80516bd 0x80962be 0x80999fe 0x80a6fed 0x807f46a 0x8082f6b 0x807e5b3 0x80844ee 0x807d79f 0x829e28c 0x82d199a New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/en/Using_stack_trace.html and follow instructions 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 0x84b2668 = SELECT denom,series,serial_number,notes,MATCH (notes) AGAINST ('\"traded this bill\"') AS score FROM temp_bill_note_search WHERE MATCH (notes) AGAINST ('\"traded this bill\"' IN BOOLEAN MODE) order by score desc limit 0, 20 thd->thread_id=214 The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. Number of processes running now: 0 030813 12:48:24 mysqld restarted --------------- __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
