Description:
Running query_cache_notembedded test case from regular mysql-test suite in
multithread environment(stress test) for some time (less than 1-2 min) will lead to crash.
This issue possible related to BUG#12848 but backtraces are different:
backtrace:
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 1115069360 (LWP 25841)]
0x08204a0e in Query_cache::free_cache (this=0x84e4ae0, destruction=0 '\0')
at sql_cache.cc:1619
1619 if (bins[0].free_blocks == 0)
(gdb) bt
#0 0x08204a0e in Query_cache::free_cache (this=0x84e4ae0, destruction=0 '\0')
at sql_cache.cc:1619
#1 0x08201064 in Query_cache::resize (this=0x84e4ae0, query_cache_size_arg=1355776)
at sql_cache.cc:746
#2 0x0814614f in fix_query_cache_size (thd=0x4280bd48, type=OPT_GLOBAL) at set_var.cc:1134
#3 0x081493af in set_var::update (this=0x8b26900, thd=0x4280bd48) at set_var.cc:2887
#4 0x08149053 in sql_set_variables (thd=0x4280bd48, var_list=0x0) at set_var.cc:2772
#5 0x08156784 in mysql_execute_command (thd=0x4280bd48) at sql_parse.cc:3216
#6 0x08159081 in mysql_parse (thd=0x4280bd48,
inBuf=0x8b26850 "set GLOBAL query_cache_size=1355776", length=35) at sql_parse.cc:4278
#7 0x08151f68 in dispatch_command (command=COM_QUERY, thd=0x4280bd48,
packet=0x4280d549 "set GLOBAL query_cache_size=1355776", packet_length=36)
at sql_parse.cc:1500
#8 0x08151858 in do_command (thd=0x4280bd48) at sql_parse.cc:1313
#9 0x08150c88 in handle_one_connection (arg=0x0) at sql_parse.cc:1045
#10 0x4004aaa7 in start_thread () from /lib/tls/libpthread.so.0
#11 0x4017bc2e in clone () from /lib/tls/libc.so.6
How to repeat:
Run stress test with test case above.
Until stress test will be integrated to regular mysql-test suite please contact
me and I will provide all necessary information.
