Hi. These last days, after some months of running relatively smoothly, I've been having some trouble with MySQL. Sometimes (yesterday 4 times) it just goes astray and virtually hangs. Load goes up to +200%, all connections are occupied and it just doesn't do anything. The only way to stop it is to killall -9 mysql because a mysqladmin shutdown won't do.
Looking though the error file I get this: 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, [...] key_buffer_size=402649088 record_buffer=8384512 sort_buffer=33554424 max_used_connections=352 max_connections=400 threads_connected=287 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 4192696 K bytes of memory Hope that's ok, if not, decrease some variables in the equation (Is it ok? Box is a Dual 1Ghz, 1Gb ram, Linux 2.4.16 dedicated only to MySQL) 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: 0x806ede4 0x8120148 0x814ba77 0x80a147f 0x807561a 0x8073f97 [...] 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=1733 Everytime the box hangs I get the same stack backtrace, I have resolved it and it's: 0x806ede4 pack__12Field_stringPcPCcUi + 20 0x8120148 regatoi + 8 0x814ba6f __printf_fp + 5719 0x80a147f join_read_const__FP13st_join_table + 35 0x807561a push_front__t4List1Z3KeyP3Key + 18 0x8073f97 prepare__13select_exportRt4List1Z4Item + 443 ...but when I try to find the thread that caused it (1733 in this case) in the binary log it doesn't appear so I'm unable to determine what's causing the error. I thought at first that it could be a load peak issue, but this error is from today at 6am, and this isn't a busy hour. Everytime I get this i run myisamchk -r *.MYI. It seems that after some time (+30 minutes usually) mysql restarts and starts running again. Any thoughts on this? Anything I can do to resolve it? Thanks. -- L --------------------------------------------------------------------- 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
