Operating System and version?
Precompiled, you compiled?
> 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,
>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
>Attempting backtrace. You can use the following information to find out
>where mysqld died. If you see no messages after this, something went
>Stack range sanity check OK, backtrace follows:
>Trying to get some variables.
>Some pointers may be invalid and cause the dump to abort...
>thd->query at (nil) is invalid pointer
> 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?
>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 <mysql-thread117730@stripped>
>To unsubscribe, e-mail
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php