MySQL Bugs: #51077: Assertion `it->fixed' in item.cc:1012: virtual bool Item_sp_variable::fix

Bug #51077	Assertion `it->fixed' in item.cc:1012: virtual bool Item_sp_variable::fix_field
Submitted:	11 Feb 2010 1:14	Modified:	13 Mar 2014 19:04
Reporter:	Elena Stepanova	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.5.99-m3-debug	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
mysqld: item.cc:1012: virtual bool Item_sp_variable::fix_fields(THD*, Item**): Assertion `it->fixed' failed.
100203  8:25:32 - mysqld got signal 6 ;

key_buffer_size=50331648
read_buffer_size=131072
max_used_connections=35
max_threads=120
thread_count=29
connection_count=28
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 96469 K
bytes of memory

thd->query at 0x23563a0 = set @tmp_num=int_rand(@f1_nums)
thd->thread_id=75
thd->killed=NOT_KILLED

#0  0x00002b4185d1aea3 in pthread_kill () from /lib64/libpthread.so.0
#1  0x00000000009ee9be in my_write_core (sig=6) at stacktrace.c:326
#2  0x000000000062ee49 in handle_segfault (sig=6) at mysqld.cc:2726
#3  <signal handler called>
#4  0x00002b41863bdbb5 in raise () from /lib64/libc.so.6
#5  0x00002b41863befb0 in abort () from /lib64/libc.so.6
#6  0x00002b41863b7286 in __assert_fail () from /lib64/libc.so.6
#7  0x0000000000552b33 in Item_sp_variable::fix_fields (this=0x2377380, thd=0x2aaabc359520) at item.cc:1012
#8  0x00000000005897a9 in Item_func::fix_fields (this=0x2377508, thd=0x2aaabc359520, ref=0x23776f8)
    at item_func.cc:172
#9  0x00000000005897a9 in Item_func::fix_fields (this=0x2377678, thd=0x2aaabc359520, ref=0x2377880)
    at item_func.cc:172
#10 0x00000000005897a9 in Item_func::fix_fields (this=0x2377800, thd=0x2aaabc359520, ref=0x23778e8)
    at item_func.cc:172
#11 0x000000000081a4c5 in sp_prepare_func_item (thd=0x2aaabc359520, it_addr=0x23778e8) at sp_head.cc:309
#12 0x000000000081a64a in sp_eval_expr (thd=0x2aaabc359520, result_field=0x2357b18, expr_item_ptr=0x23778e8)
    at sp_head.cc:347
#13 0x0000000000823bb7 in sp_rcontext::set_return_value (this=0x2aaabc3bad90, thd=0x2aaabc359520, 
    return_value_item=0x23778e8) at sp_rcontext.cc:169
#14 0x000000000081a222 in sp_instr_freturn::exec_core (this=0x23778b8, thd=0x2aaabc359520, nextp=0x45025e68)
    at sp_head.cc:3254
#15 0x000000000081b2f3 in sp_lex_keeper::reset_lex_and_exec_core (this=0x23778f8, thd=0x2aaabc359520, 
    nextp=0x45025e68, open_tables=true, instr=0x23778b8) at sp_head.cc:2774
#16 0x000000000081b61b in sp_instr_freturn::execute (this=0x23778b8, thd=0x2aaabc359520, nextp=0x45025e68)
    at sp_head.cc:3232
#17 0x000000000081dbd1 in sp_head::execute (this=0x2375b80, thd=0x2aaabc359520) at sp_head.cc:1261
#18 0x000000000081f2b2 in sp_head::execute_function (this=0x2375b80, thd=0x2aaabc359520, argp=0x23566b8, 
    argcount=1, return_value_fld=0x2357b18) at sp_head.cc:1789
#19 0x000000000058132e in Item_func_sp::execute_impl (this=0x2356638, thd=0x2aaabc359520) at item_func.cc:6098
#20 0x00000000005813a2 in Item_func_sp::execute (this=0x2356638) at item_func.cc:6027
#21 0x0000000000594499 in Item_func_sp::val_int (this=0x2356638) at item_func.h:1657
#22 0x000000000057ff68 in Item_func_set_user_var::check (this=0x23573d0, use_result_field=false)
    at item_func.cc:4254
#23 0x000000000064d1b1 in set_var_user::check (this=0x2357810, thd=0x2aaabc359520) at set_var.cc:655
#24 0x000000000064d367 in sql_set_variables (thd=0x2aaabc359520, var_list=0x2aaabc35b638) at set_var.cc:537
#25 0x00000000006439e4 in mysql_execute_command (thd=0x2aaabc359520) at sql_parse.cc:3390
#26 0x000000000064894d in mysql_parse (thd=0x2aaabc359520, inBuf=0x23563a0 "set @tmp_num=int_rand(@f1_nums)", 
    length=31, found_semicolon=0x45027f80) at sql_parse.cc:5993
#27 0x0000000000649edb in dispatch_command (command=COM_QUERY, thd=0x2aaabc359520, 
    packet=0x2aaabc35be71 "set @tmp_num=int_rand(@f1_nums)", packet_length=31) at sql_parse.cc:1141
#28 0x000000000064b29e in do_command (thd=0x2aaabc359520) at sql_parse.cc:811
#29 0x00000000006384b7 in do_handle_one_connection (thd_arg=0x2aaabc359520) at sql_connect.cc:1174
#30 0x000000000063856d in handle_one_connection (arg=0x2aaabc359520) at sql_connect.cc:1113
#31 0x00002b4185d16143 in start_thread () from /lib64/libpthread.so.0
#32 0x00002b418644e8cd in clone () from /lib64/libc.so.6
#33 0x0000000000000000 in ?? ()

How to repeat:
No repeatable test case yet

all threads bt full

Attachment: bug51077_all_threads_bt_full.out (application/octet-stream, text), 251.96 KiB.

Closed as "Can't repeat", because I have not access to files provided anymore, error was sporadic and what caused it to happen is unknown. If you are able to repeat similar failure feel free to reopen the report.