Description:
looks related to bug #59513
I still get this in 5.5.10:
110121 14:29:53 InnoDB: Assertion failure in thread 140737018169104 in file ./storage/innobase/row/row0sel.c line 3696
InnoDB: Failing assertion: prebuilt->sql_stat_start || trx->conc_state == 1
Program received signal SIGABRT, Aborted.
[Switching to Thread 0x7fffe3f98710 (LWP 10175)]
0x00000030e14329a5 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64
64 return INLINE_SYSCALL (tgkill, 3, pid, selftid, sig);
(gdb) bt
#0 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64
#1 in abort () at abort.c:92
#2 in row_search_for_mysql at./storage/innobase/row/row0sel.c:3696
#3 in ha_innobase::general_fetch at./storage/innobase/handler/ha_innodb.cc:5878
#4 in ha_innobase::rnd_next at./storage/innobase/handler/ha_innodb.cc:6072
#5 in rr_sequential at./sql/records.cc:455
#6 in sub_select at./sql/sql_select.cc:11675
#7 in do_select at./sql/sql_select.cc:11436
#8 in JOIN::exec at./sql/sql_select.cc:2362
#9 in subselect_single_select_engine::exec at./sql/item_subselect.cc:1983
#10 in Item_subselect::exec at./sql/item_subselect.cc:275
#11 in Item_singlerow_subselect::val_int at./sql/item_subselect.cc:588
#12 in Item_func_set_user_var::check at./sql/item_func.cc:4521
#13 in set_var_user::check at./sql/set_var.cc:688
#14 in sql_set_variables at./sql/set_var.cc:570
#15 in mysql_execute_command at./sql/sql_parse.cc:3053
#16 in mysql_parse at./sql/sql_parse.cc:5509
#17 in dispatch_command at./sql/sql_parse.cc:1035
#18 in do_command at./sql/sql_parse.cc:772
#19 in do_handle_one_connection at./sql/sql_connect.cc:748
#20 in handle_one_connection at./sql/sql_connect.cc:684
#21 in start_thread at pthread_create.c:301
#22 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115
How to repeat:
concurrent joins and subqueries. will make testcase later.
