hello~ When I try to "Using a stack trace" there's no "mysqld.sym.gz" on our server . Can we always find "mysqld.sym.gz" on any operating system? Our operating system is Linux 7.0 . I would like to mail you our error log to see if you can tell us what's wrong with our MySQL which always crash unexpectedly . Thanks ! Sincerely yours . Tracy Lu
Following is error log: 020213 21:50:23 mysqld started /home/ap1/libexec/mysqld: ready for connections mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. 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... Stack range sanity check OK, backtrace follows: 0x4007d00e 0x815f4f8 0x815f1c1 0x8143b08 0x81503ff 0x81506b9 0x81505ae 0x810e625 0x81050f7 0x8104de8 0x8105f73 0x8102107 0x80e3cc1 0x80e20ac 0x80c7605 0x80cb4ec 0x80c6a4d 0x80c5f66 Stack trace successful, trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x823a7c0 = select count(invno) as tlrecs from srvmst where invno='k0036381' and strno ='2053' thd->thread_id = 9861 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 9861 did to cause the crash. In some cases of really bad corruption, this value may be invalid Please use the information above to create a repeatable test case for the crash, and send it to [EMAIL PROTECTED] Number of processes running now: 0 --------------------------------------------------------------------- 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