Bug #12990 query_cache: Fails when run with ssl
Submitted: 5 Sep 2005 12:01 Modified: 12 Oct 2005 9:22
Reporter: Magnus Blåudd Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version: OS:nocona-icc-glibc23, octane2
Assigned to: Magnus Blåudd CPU Architecture:Any

[5 Sep 2005 12:01] Magnus Blåudd
Description:
Random query_cache failures can be seen when run with ssl on several platforms
08697: query_cache                     [ fail ]
08698: Errors are (from /Users/mysqldev/powermacg4/test/mysql-standard-5.0.13-beta-yassl-osx10.2-powerpc/mysql-test/var/log/mysqltest-time) :
08699: mysqltest: At line 799: unable to send query 'select sql_cache * from t1' (mysql_errno=2013 , errno=0)
08700: (the last lines may be the most important ones)
08701: 
08702: Ending Tests
08703: Shutting-down MySQL daemon
08704: 
08705: Master(s) shutdown finished
08706: Slave(s) shutdown finished
08707: Resuming Tests
08708: 

How to repeat:
Build script failure
[15 Sep 2005 14:38] Magnus Blåudd
Script to reproduce. Seems similar to bug#6897

set GLOBAL query_cache_size=1355776;
flush query cache;
reset query cache;
flush status;
delimiter //;
create table t1 (s1 int)//
create procedure f1 () begin
select sql_cache * from t1;
select sql_cache * from t1;
end;//
delimiter ;//
call f1();
set GLOBAL query_cache_size=0;
[12 Oct 2005 9:22] Magnus Blåudd
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html