Description:
MySQL Crashes often.
How-To-Repeat:
Don't know
Fix:
Don't know
>Submitter-Id: Gavin Woodhatch
>Originator:
>Organization: NetZone Ltd.
>MySQL support: [none]
>Synopsis: Random MySQL crashes (1-2 every 24h)
>Severity: [ serious ]
>Priority: [ medium ]
>Category: mysql
>Class: [ sw-bug ]
>Release: mysql-3.23.49a (Official MySQL Binary)
>Environment:
System: Linux db1 2.4.10-4GB #1 Tue Sep 25 12:33:54 GMT 2001 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs
gcc version 2.95.3 20010315 (SuSE)
Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type -Wid-clash-51 -Wswi
tch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec
-Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=penti
umpro -O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-Wimplicit -Wreturn-typ
e -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wi
mplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings
-Woverloaded-virtual -Wextern-inline -Wsign-promo -Wreorder -Wctor-dtor-privacy
-Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentium
pro -O3 -fno-omit-frame-pointer' LDFLAGS=''
LIBC:
-rwxr-xr-x 1 root root 1384168 Sep 20 2001 /lib/libc.so.6
-rw-r--r-- 1 root root 25215580 Sep 20 2001 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Sep 20 2001 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler --wi
th-extra-charsets=complex --enable-thread-safe-client --with-mysqld-ldflags=-all
-static --with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-gli
bc '--with-comment=Official MySQL Binary' --prefix=/usr/local/mysql --with-extra
-charset=complex --enable-thread-safe-client --enable-local-infile 'CFLAGS=-Wimp
licit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subsc
ripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compa
re -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' 'CXXFL
AGS=-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wc
har-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Ws
ign-compare -Wwrite-strings -Woverloaded-virtual -Wextern-inline -Wsign-promo -W
reorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-excepti
ons -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX=gcc
Attached Here are the last two Stack Traces, and logfile entrys i dont know if there
right, i
grabbed the mysqld.sym from the server.rpm, but am using the tar.gz
binary package. I did not find the mysqld.sym.gz in the tar.gz
archiv.
here is the bit of the log file for our last crash:
mysqld got signal 4;
<snip
key_buffer_size=16773120
record_buffer=1044480
sort_buffer=4194296
max_used_connections=29
max_connections=150
threads_connected=19
It is possible that mysqld could use up to
key_buffer_size + (record_buffer + sort_buffer)*max_connections = 783778 K
<snip>
Stack range sanity check OK, backtrace follows:
0x806db54
0x811c328
0x806afdd
0x808fb1d
0x8092cb8
0x808c1db
0x807472a
0x8078828
0x8073904
0x8072cb7
Stack trace seems successful - bottom reached
<snip>
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x83a9c78 = SELECT id FROM dvdone_rented WHERE id_movie = '10089'
and state != 'back'
thd->thread_id=23860
And here is the resolved Stack Trace .. (hope its right ..)
db1:/tmp # /usr/local/mysql/bin/resolve_stack_dump -s /tmp/mysqld.sym -n
/tmp/mysql.stack1
0x806db54 server_init__Fv + 8
0x811c328 pthread_mutex_trylock + 8
0x806afdd mysql_lock_tables__FP3THDPP8st_tableUi + 573
0x808fb1d make_join_select__FP4JOINP10SQL_SELECTP4Item + 713
0x8092cb8 create_myisam_tmp_table__FP8st_tableP15TMP_TABLE_PARAMUi + 336
0x808c1db
mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4T3T4UiP13select_result
+ 3611
0x807472a do_command__FP3THD + 3466
0x8078828
add_table_to_list__FP11Table_identP10lex_stringb13thr_lock_typePt4List1Z6StringT4 + 280
0x8073904 mysql_table_dump__FP3THDPcT1i + 260
0x8072cb7 check_for_max_user_connections__FPCciT0 + 311
Here is some more info on the 2nd last crash
mysqld got signal 11;
<snip>
key_buffer_size=16773120
record_buffer=1044480
sort_buffer=4194296
max_used_connections=28
max_connections=150
threads_connected=19
It is possible that mysqld could use up to
key_buffer_size + (record_buffer + sort_buffer)*max_connections = 783778 K
bytes of memory
Hope that's ok, if not, decrease some variables in the equation
<snip>
Stack range sanity check OK, backtrace follows:
0x806db54
0x811c328
0xb3
0x806981c
0x8069726
0x80679f2
0x809827d
0x8092f76
0x8092c80
0x808c1db
0x807472a
0x8078828
0x8073904
0x8072cb7
Stack trace seems successful - bottom reached
<snip>
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x83c2138 = SELECT * FROM fm_ad WHERE expired > '1019424115'
thd->thread_id=26095
And here again is the resolved stack Trace :
db1:/tmp # /usr/local/mysql/bin/resolve_stack_dump -s /tmp/mysqld.sym -n
/tmp/mysql.stack2
0x806db54 server_init__Fv + 8
0x811c328 pthread_mutex_trylock + 8
0xb3 (?)
0x806981c my_real_read__FP6st_netPUl + 580
0x8069726 my_real_read__FP6st_netPUl + 334
0x80679f2 __3THD + 18
0x809827d only_eq_ref_tables__FP4JOINP8st_orderUl + 17
0x8092f76 create_myisam_from_heap__FP8st_tableP15TMP_TABLE_PARAMib + 54
0x8092c80 create_myisam_tmp_table__FP8st_tableP15TMP_TABLE_PARAMUi + 280
0x808c1db
mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4T3T4UiP13select_result
+ 3611
0x807472a do_command__FP3THD + 3466
0x8078828
add_table_to_list__FP11Table_identP10lex_stringb13thr_lock_typePt4List1Z6StringT4 + 280
0x8073904 mysql_table_dump__FP3THDPcT1i + 260
0x8072cb7 check_for_max_user_connections__FPCciT0 + 311
I hope someone can help us on this one .. i guess i am lost.
The distribution we are using is SuSE 7.3
Thanks for your Help in advance.
Gavin Woodhatch
NetZone Ltd.
---------------------------------------------------------------------
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
