Bug #59306 Server crashes at Item_in_optimizer::fix_left during a Join Operation
Submitted: 5 Jan 2011 10:09 Modified: 10 Jan 2013 12:05
Reporter: Sandeep Doddaballapur Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S2 (Serious)
Version:5.6.1-m5 OS:Linux
Assigned to: Tor Didriksen CPU Architecture:Any

[5 Jan 2011 10:09] Sandeep Doddaballapur
Description:
Machine : lu0009.mysql.com
Build : mysql-5.6.1-m5-linux2.6-x86_64

The crash was dumped during a rqg run on WL5004 grammar

Following is the query reported by the crash.
SELECT   `col_int` , `col_int_key` , `pk`  FROM testdb_S . t1_view1_S  AS A WHERE A.`pk` IN ( SELECT `pk` FROM testdb_S . t1_base2_S  AS B WHERE B.`pk` = 6 )  INTO OUTFILE '/tmp/gentest1665.tmp'

Following is the rqg options supplied 
runall.pl \ 
--mtr-build-thread=450 \ 
--duration=3600 \ 
--queries=100000 \ 
--reporter=Deadlock,Backtrace,ErrorLog \ 
--threads=32 \ 
--gendata=/data0/sandeepd/runs/storagenew/1293975539/bughunt_data.zz \ 
--redefine=/data0/sandeepd/runs/storagenew/1293975539/bughunt_sql_redefine.yy \ 
--basedir=/users/sandeepd/work/mysql-5.6.1-m5-linux2.6-x86_64 \ 
--mysqld=--lock-wait-timeout=1 \ 
--mysqld=--log-output=none \ 
--mysqld=--loose-innodb-lock-wait-timeout=1 \ 
--grammar=/data0/sandeepd/runs/storagenew/1293975539/bughunt_sql.yy \ 
--vardir=/dev/shm/var_1293975539 \ 
--mask-level=0 \ 
--mask=29 \ 
--seed=30

Following is the backtrace of the core 
#0  0x000000382860bd02 in pthread_kill () from /lib64/libpthread.so.0
#1  0x000000000050bdee in handle_segfault (sig=11)
    at /export/home/pb2/build/sb_0-2709405-1293121758.41/mysql-5.6.1-m5/sql/mysqld.cc:2511
#2  <signal handler called>
#3  0x0000000000693fe3 in Item_in_optimizer::fix_left (this=0x133905e0, 
    thd=0x2aaac008c0e0, ref=<value optimized out>)
    at /export/home/pb2/build/sb_0-2709405-1293121758.41/mysql-5.6.1-m5/sql/item_cmpfunc.cc:1714
#4  0x00000000006940af in Item_in_optimizer::fix_fields (this=0x2aaacc1e5a40, 
    thd=0x2aaac008c0e0, ref=0x13390660)
    at /export/home/pb2/build/sb_0-2709405-1293121758.41/mysql-5.6.1-m5/sql/item_cmpfunc.cc:1749
#5  0x000000000069308d in Item_cond::fix_fields (this=0x13588ee8, 
    thd=0x2aaac008c0e0, ref=<value optimized out>)
    at /export/home/pb2/build/sb_0-2709405-1293121758.41/mysql-5.6.1-m5/sql/item_cmpfunc.cc:4343
#6  0x0000000000537ba6 in setup_conds (thd=0x2aaac008c0e0, 
    tables=<value optimized out>, leaves=0x2aaacc07ec20, conds=0x13589418)
    at /export/home/pb2/build/sb_0-2709405-1293121758.41/mysql-5.6.1-m5/sql/sql_base.cc:8291
#7  0x000000000059f30d in setup_without_group (this=0x135890a8, 
    rref_pointer_array=0x2aaacc1a8ca0, tables_init=<value optimized out>, 
    wild_num=<value optimized out>, conds_init=<value optimized out>, 
    og_num=<value optimized out>, order_init=0x0, group_init=0x0, 
    having_init=0x0, proc_param_init=0x0, select_lex_arg=0x2aaacc1a8ab8, 
    unit_arg=0x2aaacc1a8480)
    at /export/home/pb2/build/sb_0-2709405-1293121758.41/mysql-5.6.1-m5/sql/sql_select.cc:488
#8  JOIN::prepare (this=0x135890a8, rref_pointer_array=0x2aaacc1a8ca0, 
    tables_init=<value optimized out>, wild_num=<value optimized out>, 
    conds_init=<value optimized out>, og_num=<value optimized out>, 
    order_init=0x0, group_init=0x0, having_init=0x0, proc_param_init=0x0, 
    select_lex_arg=0x2aaacc1a8ab8, unit_arg=0x2aaacc1a8480)
    at /export/home/pb2/build/sb_0-2709405-1293121758.41/mysql-5.6.1-m5/sql/sql_select.cc:570
#9  0x00000000005b7b32 in mysql_select (thd=0x2aaac008c0e0, 
    rref_pointer_array=0x2aaacc1a8ca0, tables=0x6636e0, wild_num=0, 
    fields=..., conds=0xfa9620, og_num=0, order=0x0, group=0x0, having=0x0, 
    proc_param=0x0, select_options=2148798208, result=0x2aaacc01cb20, 
    unit=0x2aaacc1a8480, select_lex=0x2aaacc1a8ab8)
    at /export/home/pb2/build/sb_0-2709405-1293121758.41/mysql-5.6.1-m5/sql/sql_select.cc:3533
#10 0x00000000005b7f99 in handle_select (thd=0x2aaac008c0e0, 
    lex=0x2aaacc1a83d0, result=0x2aaacc01cb20, setup_tables_done_option=0)
    at /export/home/pb2/build/sb_0-2709405-1293121758.41/mysql-5.6.1-m5/sql/sql_select.cc:323
#11 0x00000000005707fc in execute_sqlcom_select (thd=0x2aaac008c0e0, 
    all_tables=0x2aaacc01af78)
    at /export/home/pb2/build/sb_0-2709405-1293121758.41/mysql-5.6.1-m5/sql/sql_parse.cc:4513
#12 0x0000000000575410 in mysql_execute_command (thd=0x2aaac008c0e0)
    at /export/home/pb2/build/sb_0-2709405-1293121758.41/mysql-5.6.1-m5/sql/sql_parse.cc:2096
#13 0x0000000000726fae in sp_instr_stmt::exec_core (this=0x2aaacc0bb100, 
    thd=0x2aaac008c0e0, nextp=0x13390660)
    at /export/home/pb2/build/sb_0-2709405-1293121758.41/mysql-5.6.1-m5/sql/sp_head.cc:3162
#14 0x0000000000727134 in sp_lex_keeper::reset_lex_and_exec_core (
    this=0x2aaacc0bb140, thd=0x2aaac008c0e0, nextp=0x41a328f8, 
    open_tables=false, instr=0x2aaacc0bb100)
    at /export/home/pb2/build/sb_0-2709405-1293121758.41/mysql-5.6.1-m5/sql/sp_head.cc:2959
#15 0x000000000072c27d in sp_instr_stmt::execute (this=0x2aaacc0bb100, 
    thd=0x2aaac008c0e0, nextp=0x41a328f8)
    at /export/home/pb2/build/sb_0-2709405-1293121758.41/mysql-5.6.1-m5/sql/sp_head.cc:3094
#16 0x000000000072a2c1 in sp_head::execute (this=0x2aaacc1a7970, 
    thd=0x2aaac008c0e0, merge_da_on_success=true)
    at /export/home/pb2/build/sb_0-2709405-1293121758.41/mysql-5.6.1-m5/sql/sp_head.cc:1420
#17 0x000000000072b961 in sp_head::execute_procedure (this=0x2aaacc1a7970, 
    thd=0x2aaac008c0e0, args=0x2aaac008e640)
    at /export/home/pb2/build/sb_0-2709405-1293121758.41/mysql-5.6.1-m5/sql/sp_head.cc:2176
#18 0x0000000000576351 in mysql_execute_command (thd=0x2aaac008c0e0)
    at /export/home/pb2/build/sb_0-2709405-1293121758.41/mysql-5.6.1-m5/sql/sql_parse.cc:3970
#19 0x000000000057826a in mysql_parse (thd=0x2aaac008c0e0, 
    rawbuf=<value optimized out>, length=<value optimized out>, 
    parser_state=0x41a33d60)
    at /export/home/pb2/build/sb_0-2709405-1293121758.41/mysql-5.6.1-m5/sql/sql_parse.cc:5550
#20 0x0000000000579e07 in dispatch_command (command=COM_QUERY, 
    thd=0x2aaac008c0e0, packet=<value optimized out>, packet_length=23)
    at /export/home/pb2/build/sb_0-2709405-1293121758.41/mysql-5.6.1-m5/sql/sql_parse.cc:1078
#21 0x0000000000610417 in do_handle_one_connection (
    thd_arg=<value optimized out>)
    at /export/home/pb2/build/sb_0-2709405-1293121758.41/mysql-5.6.1-m5/sql/sql_connect.cc:748
#22 0x0000000000610484 in handle_one_connection (arg=<value optimized out>)
    at /export/home/pb2/build/sb_0-2709405-1293121758.41/mysql-5.6.1-m5/sql/sql_connect.cc:684
#23 0x000000382860673d in start_thread () from /lib64/libpthread.so.0
#24 0x0000003827ad3d1d in clone () from /lib64/libc.so.6

How to repeat:
Currently not able to reproduce the crash . Working on it and will attach the steps if I hit a suitable scenario.
[10 Jan 2013 12:05] Erlend Dahl
Not repeatable on recent sources.