>Description:
I'm getting a pretty consistant crash in mysqld:
/usr/ports/databases/mysql323-server/work/mysql-3.23.32/sql/mysqld: ready for
connections
Program received signal SIGSEGV, Segmentation fault.
0x282ae35c in bcopy () from /usr/lib/libc_r.so.4
(gdb) bt
#0 0x282ae35c in bcopy () from /usr/lib/libc_r.so.4
#1 0x282c00a8 in _thread_autoinit_dummy_decl () from /usr/lib/libc_r.so.4
#2 0x282afcca in __dtoa () from /usr/lib/libc_r.so.4
#3 0x282adb3b in vfprintf () from /usr/lib/libc_r.so.4
#4 0x282abc56 in vfprintf () from /usr/lib/libc_r.so.4
#5 0x2829d4cd in sprintf () from /usr/lib/libc_r.so.4
#6 0x80633e0 in Field_float::val_str (this=0x9175410, val_buffer=0xbf7f046c,
val_ptr=0xbf7f046c) at field.cc:1847
#7 0x8061921 in Field::send (this=0x9175410, packet=0x8adcc20) at field.cc:257
#8 0x8132c59 in Item_field::send (this=0x8e4ea70, str_arg=0x8adcc20) at item.h:119
#9 0x806ac67 in select_send::send_data (this=0x8e4e6a8, items=@0x8adca4c) at
sql_class.cc:236
#10 0x809a36d in end_send (join=0xbf7f0778, join_tab=0x8b72868, end_of_records=false)
at sql_select.cc:4521
#11 0x80998d6 in sub_select (join=0xbf7f0778, join_tab=0x8b72750,
end_of_records=false) at sql_select.cc:4033
#12 0x8099567 in do_select (join=0xbf7f0778, fields=0x8adca4c, table=0x0,
procedure=0x0) at sql_select.cc:3925
#13 0x8091957 in mysql_select (thd=0x8adc800, tables=0x8e4e0d8, fields=@0x8adca4c,
conds=0x8e4e5c8, ftfuncs=@0x8adca80,
order=0x8e4e688, group=0x0, having=0x0, proc_param=0x0, select_options=8950784,
result=0x8e4e6a8) at sql_select.cc:755
#14 0x8079299 in mysql_execute_command () at sql_parse.cc:957
#15 0x807c29e in mysql_parse (thd=0x8adc800,
inBuf=0x8e4e010 "SELECT * FROM cp WHERE C11=1 && C12>=1.0 && C13>=1.0 && PL1 > 0
ORDER BY C4 DESC", length=80)
at sql_parse.cc:2085
#16 0x8078458 in do_command (thd=0x8adc800) at sql_parse.cc:668
#17 0x8077800 in handle_one_connection (arg=0x8adc800) at sql_parse.cc:403
#18 0x282419a7 in _thread_start () from /usr/lib/libc_r.so.4
#19 0xbee93ffc in ?? ()
#20 0x80738db in create_new_thread (thd=0x8e27780) at mysqld.cc:2056
#21 0x81c2c00 in ?? ()
Error accessing memory address 0x2: Bad address.
(gdb) up
#1 0x282c00a8 in _thread_autoinit_dummy_decl () from /usr/lib/libc_r.so.4
(gdb) up
#2 0x282afcca in __dtoa () from /usr/lib/libc_r.so.4
(gdb) up
#3 0x282adb3b in vfprintf () from /usr/lib/libc_r.so.4
(gdb) up
#4 0x282abc56 in vfprintf () from /usr/lib/libc_r.so.4
(gdb) up
#5 0x2829d4cd in sprintf () from /usr/lib/libc_r.so.4
(gdb) up
#6 0x80633e0 in Field_float::val_str (this=0x9175410, val_buffer=0xbf7f046c,
val_ptr=0xbf7f046c) at field.cc:1847
warning: Source file is more recent than executable.
1847 sprintf(to,"%.*f",dec,nr);
(gdb) print dec
$1 = 2 '\002'
(gdb) print nr
$2 = 999204736
(gdb) print to
$3 = 0xbf7f047c "1"
This bug was not present in 3.22.32, and only became evident when we skipped to 3.23.
>How-To-Repeat:
Right now, using the "adcycle" package hits it within 10-15 minutes of use on
a heavily loaded site.
>Fix:
>Submitter-Id: <submitter ID>
>Originator: Kevin Day
>Organization:
stileproject.com
>MySQL support: none
>Synopsis: Crash in mysqld Field_float::val_str in 3.23.32
>Severity: critical
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.32 (Source distribution)
>Environment:
<machine, os, target, libraries (multiple lines)>
System: FreeBSD server4.stileproject.com 4.2-RELEASE FreeBSD 4.2-RELEASE #0: Fri Sep
29 22:40:46 CDT 2000 [EMAIL PROTECTED]
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1169076 Nov 20 05:59 /usr/lib/libc.a
lrwxrwxrwx 1 root wheel 9 Sep 26 19:13 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 559196 Nov 20 05:59 /usr/lib/libc.so.4
Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock
--with-low-memory --with-mit-threads=yes --without-perl
Perl: This is perl, version 5.005_03 built for i386-freebsd
---------------------------------------------------------------------
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
