Bug #12864 Stress test: Server crashes on regular query_cache_notembedded
Submitted: 29 Aug 2005 20:57 Modified: 30 Aug 2005 14:13
Reporter: Alexey Stroganov Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version:the latest 4.1, 5.0 OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[29 Aug 2005 20:57] Alexey Stroganov
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:


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.
[30 Aug 2005 14:13] Alexey Stroganov
This issue was fixed by patch for BUG#12848