List:General Discussion« Previous MessageNext Message »
From:James Nobis Date:April 19 2005 5:35pm
Subject:Segfault 5.0.4 with subquery of the form <> ANY ( inner query )
View as plain text  
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: root
To: mysql@stripped
Subject: 5.0.4 (and 5.0.3) segfault when presented with a specific query
containing a subquery of the form <> ANY( inner query )

>Description:
        0x8097e13 init_signals__Fv + 327
        0x833c348 __md5_crypt_r + 312
        0x82d729f uf_space_prespace_selected + 219
        0x82d3410 _mi_calc_var_pack_key_length + 1044
        0x8126676 innobase_mysql_prepare_print_arbitrary_thd + 10
        0x8123574 repair__9ha_myisamP3THDR17st_mi_check_paramb + 196
        0x81233d1 repair__9ha_myisamP3THDP15st_ha_check_opt + 389
        0x81194cd
cost_group_min_max__FP8st_tableP6st_keyUiUiP8SEL_TREEP7SEL_ARGUlbT7PdPUl + 489
        0x811db78
merge_buffers__FP13st_sort_paramP11st_io_cacheT1PUcP10st_buffpekN24i + 760
        0x80e3754 make_cond_for_table__FP4ItemUxUx + 680
        0x80e2839 end_send__FP4JOINP13st_join_tableb + 173
        0x80e3754 make_cond_for_table__FP4ItemUxUx + 680
        0x80e2839 end_send__FP4JOINP13st_join_tableb + 173
        0x80e2584 join_read_last__FP13st_join_table + 128
        0x80d3d6f exec__4JOIN + 2591
        0x807eb7b exec__30subselect_single_select_engine + 379
        0x807bc9e cleanup__21Item_maxmin_subselect + 18
        0x807ca39
single_value_transformer__17Item_in_subselectP4JOINP12Comp_creator + 121
        0x83aec41 transform__18Item_default_valuePM4ItemFP4ItemPc_P4ItemPc + 81
        0x8064eb8 cleanup__17Item_in_optimizer + 0
        0x80639c5 convert_constant_item__FP3THDP5FieldPP4Item + 1
        0x804c44d val_bool__4Item + 33
        0x8068ae4 val_int__12Item_cond_or + 32
        0x80e28e5 end_send__FP4JOINP13st_join_tableb + 345
        0x80e29a1 end_send_group__FP4JOINP13st_join_tableb + 37
        0x80e29a1 end_send_group__FP4JOINP13st_join_tableb + 37
        0x80e29a1 end_send_group__FP4JOINP13st_join_tableb + 37
        0x80e29a1 end_send_group__FP4JOINP13st_join_tableb + 37
        0x80e2584 join_read_last__FP13st_join_table + 128
        0x80d3d6f exec__4JOIN + 2591
        0x80d55b6
make_join_statistics__FP4JOINP13st_table_listP4ItemP16st_dynamic_array + 1262
        0x80d1c8f
prepare__4JOINPPP4ItemP13st_table_listUiP4ItemUiP8st_orderT6T4T6P13st_select_lexP18st_select_lex_unit
+ 1159
        0x80a8a79 mysql_execute_command__FP3THD + 1813
        0x80ae6db
add_field_to_list__FP3THDPc16enum_field_typesT1T1UiP4ItemT6P13st_lex_stringT1Pt4List1Z6StringP15charset_info_stUi
+ 435
        0x80a7164 dispatch_command__F19enum_server_commandP3THDPcUi + 2216
        0x80a6acf dispatch_command__F19enum_server_commandP3THDPcUi + 531
        0x80a6084 handle_bootstrap + 180
        0x8339afc __pthread_lock + 28
        0x836350a _svcauth_des + 730

>How-To-Repeat:
        Unfortunately this NDA'd so I cannot provide the table structure, query,
etc.  If the stack trace is unhelpful I will happily spend the time to try to
create a test case.
>Fix:
        unknown

>Submitter-Id:  <submitter ID>
>Originator:    root
>Organization:
 <organization of PR author (multiple lines)>
>MySQL support: none
>Synopsis:      Segfault with subquery
>Severity:      critical
>Priority:      high
>Category:      mysql
>Class:         sw-bug
sw-bug
>Release:       mysql-5.0.4-beta-standard (MySQL Community Edition - Standard
(GPL))
>Server: /usr/local/bin/mysqladmin  Ver 8.41 Distrib 5.0.4-beta, for
pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version          5.0.4-beta-standard-log
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /tmp/mysql.sock
Uptime:                 5 min 59 sec

Threads: 1  Questions: 2  Slow queries: 0  Opens: 0  Flush tables: 1  Open
tables: 0  Queries per second avg: 0.006
>C compiler:    2.95.3
>C++ compiler:  2.95.3
>Environment:
        <machine, os, target, libraries (multiple lines)>
System: Linux dev2 2.4.29-vs1.2.10 #1 Thu Mar 24 23:28:44 CST 2005 i686 unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs
gcc version 2.95.4 20011002 (Debian prerelease)
Compilation info: CC='gcc'  CFLAGS='-O2 -mcpu=pentiumpro'  CXX='gcc' 
CXXFLAGS='-O2 -mcpu=pentiumpro -felide-constructors'  LDFLAGS=''  ASFLAGS=''
LIBC:
lrwxrwxrwx    1 root     root           13 Apr 14 14:06 /lib/libc.so.6 ->
libc-2.2.5.so
-rwxr-xr-x    1 root     root      1153784 Jan  7 06:05 /lib/libc-2.2.5.so
Configure command: ./configure '--prefix=/usr/local/mysql'
'--localstatedir=/usr/local/mysql/data' '--libexecdir=/usr/local/mysql/bin'
'--with-comment=MySQL Community Edition - Standard (GPL)'
'--with-extra-charsets=complex' '--with-server-suffix=-standard'
'--enable-thread-safe-client' '--enable-local-infile' '--enable-assembler'
'--disable-shared' '--with-client-ldflags=-all-static' '--with-big-tables'
'--with-mysqld-ldflags=-all-static' '--with-readline' '--with-embedded-server'
'--with-archive-storage-engine' '--with-innodb' 'CFLAGS=-O2 -mcpu=pentiumpro'
'CPPFLAGS=-DDEFAULT_THREAD_STACK=126976' 'CXXFLAGS=-O2 -mcpu=pentiumpro
-felide-constructors' 'CXX=gcc'

Also, it should be noted in 4.1.x there is no segfault.

James Nobis
Web Developer
Academic Superstore
223 W. Anderson Ln. Suite A110, Austin, TX 78752
Voice: (512) 450-1199 x453 Fax: (512) 450-0263
http://www.academicsuperstore.com
Thread
Segfault 5.0.4 with subquery of the form <> ANY ( inner query )James Nobis19 Apr