MySQL Bugs: #8346: Test case 'query_cache' crashes server on Windows 2000

Bug #8346	Test case 'query_cache' crashes server on Windows 2000
Submitted:	6 Feb 2005 22:09	Modified:	5 Oct 2005 23:50
Reporter:	Kent Boortz	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	4.1.10-pre	OS:	Windows (Windows XP)
Assigned to:	Kent Boortz	CPU Architecture:	Any

Description:
When running the test suite on Windows XP (buildxp1) the 'query_cache' test case
crashes the server.

How to repeat:
Install the latest snapshot of the server, copy the "mysql-test" directory from the latest bitkeeper repository into the install directory, go down to "mysql-test" from within Cygwin, and do

INST=C:/cygwin/home/mysqldev/kent/mysql-4.1.10-win32  (insert your path here)

$INST/bin/mysqld --no-defaults --basedir=$INST --character-sets-dir=$INST/share/charsets --core --default-character-set=latin1 --language=$INST/share/english/ --tmpdir=$INST/mysql-test/var/tmp --log-bin=$INST/mysql-test/var/log/master-bin --pid-file=$INST/mysql-test/var/run/master.pid --port=9306 --server-id=1 --socket=$INST/mysql-test/var/tmp/master.sock --innodb_data_file_path=ibdata1:50M --local-infile --datadir=$INST/mysql-test/var/master-data --key_buffer_size=1M --sort_buffer=256K --max_heap_table_size=1M --user=root --rpl-recovery-rank=1 --init-rpl-role=master --exit-info=256 --open-files-limit=1024 --log=$INST/mysql-test/var/log/master.log &

(wait for the server to fully start, takes 20 seconds or more)

$INST/bin/mysqltest --no-defaults --socket=$INST/mysql-test/var/tmp/master.sock --database=test --user=root --password= --silent -v --skip-safemalloc --tmpdir=$INST/mysql-test/var/tmp --port=9306 -R $INST/mysql-test/r/query_cache.result < t/query_cache.test

Running it like above, require that the "mysql-test/var" is already initiated.
Once recent changes to the mysql-test-run.pl are pushed, you might use it
instead, i.e. run the test like "./mysql-test-run.pl query_cache".

The last lines in the master log before the crash, are

                      1 Query       set GLOBAL query_cache_size=51200
                      1 Query       show global variables like "query_cache_size"
                      1 Query       select * from t1

I wasn't able for to repeat with a debug server built with
latest BK source.

Jorge and Kent please use a debug server for to get the
call stack. Thanks.

The test cases doesn't fail using the "mysqld-debug.exe", only
if using one of the optimized binaries.

Using windows snapshot from 2/4, I was unable to reproduce this.  Tried it with the mysqld.exe, mysqld-nt.exe, and mysqld-max-nt.exe binaries. Alll reported [pass]

I was able to repeat just issuing:

create table t1 (a int);
set GLOBAL query_cache_size=1000;
show global variables like "query_cache_size";
select * from t1;
set GLOBAL query_cache_size=1024;
show global variables like "query_cache_size";
select * from t1;
set GLOBAL query_cache_size=10240;
show global variables like "query_cache_size";
select * from t1;
set GLOBAL query_cache_size=20480;
show global variables like "query_cache_size";
select * from t1;
set GLOBAL query_cache_size=40960;
show global variables like "query_cache_size";
select * from t1;
set GLOBAL query_cache_size=51200;
show global variables like "query_cache_size";
select * from t1;

below call stack:

>      mysqld-nt.exe!Query_cache::get_free_block()  + 0x2a	C++
 	mysqld-nt.exe!Query_cache::allocate_block()  + 0x43	C++
 	mysqld-nt.exe!Query_cache::write_block_data()  + 0x43	C++
 	mysqld-nt.exe!Query_cache::store_query()  + 0x1c8	C++
 	mysqld-nt.exe!mysql_execute_command()  + 0x405	C++
 	mysqld-nt.exe!mysql_parse()  + 0xc7	C++
 	mysqld-nt.exe!dispatch_command()  + 0x456	C++
 	mysqld-nt.exe!do_command()  + 0xa7	C++
 	mysqld-nt.exe!_handle_one_connection()  + 0x1ed	C++
 	mysqld-nt.exe!_pthread_create()  + 0xcb	C
 	mysqld-nt.exe!__beginthread()  + 0xce	
 	ntdll.dll!7c9106eb() 	
 	kernel32.dll!7c80b50b() 	
 	ntdll.dll!7c9106eb() 	
 	kernel32.dll!7c8399f3()

I was able to reproduce the bug with 4.1.9 for windows, using Miguel's test case.

The bug is simply repeatable by (optimized Windows build):
drop table if exists t1;
create table t1 (a int);
set global query_cache_size=41984;
select * from t1;

Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/

Re-open as verified since continues to be reported i.e.:

http://bugs.mysql.com/bug.php?id=9555

I am marking this bug back to open and unassigning it from me.  The server binaries that #eng are building do crash.  However, we have shown that their windows toolchain is suspect.  In addition, any 4.1 build that I compile up using vc6 or vc7 works passes the query_cache test.

I was able to reproduce this bug using 5.0.7 from bk and Miguel's test case.

Setting back to verified.

BTW, I used our 5.0.4 binary to test this bug

We now build 5.0, and soon 4.1 using VC7.1, i.e. Visual Studio .Net 2003.
Indication was that broken 64 bit arithmetics was the cause, and using 
the new compiler the problem with 'query_cache' crash is gone.

No changelog entry needed.