What instances can cause a Table to crash? Is this caused by a bug in itself, a power failure, or something else?
Richard >> William_dw, >> Tuesday, July 23, 2002, 10:34:16 AM, you wrote: >> WS> I'm hoping someone can give me a pointer as to what's going wrong >> that's >> WS> crashing our MySQL server, I've included a snippet of the log (for the >> last >> WS> time it restarted and then the errors after that). >> WS> I've been trying to read through the 'Debugging MySQL server' section, >> but >> WS> there doesn't seem to be much to go on from the log, and the 'if you >> don't >> WS> see anything something went terribly wrong' message with nothing but >> an >> WS> 'aborting backtrace' message after it kinda has me worried over here. >> WS> Any suggestions, pointers, or anything else would be really >> appreciated as >> WS> my hair is turning gray by the second :). >> WS> Thanks in advance, >> WS> William. >> WS> mysqld got signal 11; >> WS> The manual section 'Debugging a MySQL server' tells you how to use a >> WS> stack trace and/or the core file to produce a readable backtrace that >> may >> WS> help in finding out why mysqld died >> WS> Attemping backtrace. You can use the following information to find out >> WS> where mysqld died. If you see no messages after this, something went >> WS> terribly wrong >> WS> Bogus stack limit or frame pointer, aborting backtrace >> WS> Number of processes running now: 0 >> WS> 020722 08:55:42 mysqld restarted >> WS> /usr/sbin/mysqld: ready for connections >> WS> 020722 8:55:45 read_key: Got error 127 when reading table >> WS> './wahse/keywords' >> $ perror 127 >> Error code 127: Unknown error 127 >> 127 = Record-file is crashed >> Your table is crashed. You should repair it using myisamchk: >> http://www.mysql.com/doc/m/y/myisamchk_repair_options.html >> http://www.mysql.com/doc/R/e/Repair.html >> -- >> For technical support contracts, goto https://order.mysql.com/?ref=ensita >> This email is sponsored by Ensita.net http://www.ensita.net/ >> __ ___ ___ ____ __ >> / |/ /_ __/ __/ __ \/ / Victoria Reznichenko >> / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] >> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net >> <___/ www.mysql.com >> --------------------------------------------------------------------- >> 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
