Hallo,
I have small problem with my sql (again :)
version:3.23.32
linux: SuSE 6.2 kernel: 2.2.16, 2.2.18, 2.4.1
lib: libc-2.1.2-31 (suse)
compiled: gcc-2.95.2, egcs 2.7.2.3
compilation parameters: --prefix=/opt/mysql ( --without-debug
--enable-assembler)
memory: 1GB
processor: 2* PIII 550Mhz
ps uax | grep mysqld | wc -l : between 100 and 600 (really :)
this machine is db backend for one wide used portal ( 3 web machines with
apache and php 4.0.4pl1 with patched persistent connections)
I tryed all combinations of this but in my db.err is really often
mysqld got signal 11.
Does anybody have an idea what can I do ?
is it possible that this is caused by bad written php scripts ? (because I'm
not developer but I know how our developers work :)
if yes where in php scripts should I search a bug ?
Jan Matis
have a look at my stackdumps from log
and then at the resolve_stack_dump results
stack range sanity check, ok, backtrace follows
0x2ab204d7
0x2abeaba4
0x2abea744
0x81745f8
0x80eec2c
0x80ed946
0x80ec239
0x80cde91
0x80d2328
0x80cd27d
0x80cc896
stack trace successful
stack range sanity check, ok, backtrace follows
0x2ab204d7
0x81422a0
0x8141850
0x8148dd8
0x8148e9b
0x8148e9b
0x8148bf3
0x8148ab8
0x8119229
0x80fcc02
0x80fc49a
0x80cf03c
0x80d2328
0x80cd27d
0x80cc896
stack trace successful
db:/raid/debug # resolve_stack_dump -s mysqld.sym -n stack1
0x2ab204d7 _end + 579999511
0x2abeaba4 _end + 580828644
0x2abea744 _end + 580827524
0x81745f8 my_malloc + 24
0x80eec2c
update_ref_and_keys__FP16st_dynamic_arrayP13st_join_tableUiP4ItemUlRt4List1Z
15Item_func_match + 44
0x80ed946
make_join_statistics__FP4JOINP13st_table_listP4ItemP16st_dynamic_arrayRt4Lis
t1Z15Item_func_match + 1350
0x80ec239
mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemRt4List1Z15Item_func
_matchP8st_orderT5P4ItemT5UiP13select_result + 2121
0x80cde91 mysql_execute_command__Fv + 753
0x80d2328 mysql_parse__FP3THDPcUi + 200
0x80cd27d do_command__FP3THD + 1197
0x80cc896 handle_one_connection__FPv + 630
db:/raid/debug # resolve_stack_dump -s mysqld.sym -n stack2
0x2ab204d7 _end + 579999511
0x81422a0 _nisam_key_cmp + 1760
0x8141850 _nisam_bin_search + 144
0x8148dd8 w_search + 200
0x8148e9b w_search + 395
0x8148e9b w_search + 395
0x8148bf3 _nisam_ck_write + 51
0x8148ab8 nisam_write + 264
0x8119229 write_row__7ha_isamPc + 89
0x80fcc02 write_record__FP8st_tableP12st_copy_info + 514
0x80fc49a
mysql_insert__FP3THDP13st_table_listRt4List1Z4ItemRt4List1Zt4List1Z4Item15en
um_duplicates13thr_lock_type + 1178
0x80cf03c mysql_execute_command__Fv + 5276
0x80d2328 mysql_parse__FP3THDPcUi + 200
0x80cd27d do_command__FP3THD + 1197
0x80cc896 handle_one_connection__FPv + 630
---------------------------------------------------------------------
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
