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.