On Wed, Jan 24, 2001 at 03:15:48PM -0600, Kevin Day wrote:
Does this only occur when more than one client is accessing the table
in question? If so, it's a thread-related problem that has been with
us since FreeBSD 3.x. :-(
It looks like what I've seen before.
I have a re-produceable case that I sent to one of the MySQL
developers and he was able to see the problem. Tracing it down,
however, requires someone who knows a lot about FreeBSD threading.
I've found some FreeBSD gurus here who might be able to help. I just
need a MySQL developer to point them at...
> >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
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951
---------------------------------------------------------------------
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
