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