Description:
Pushbuild failure that happens in tests when they execute either SELECT ... FROM INFORMATION_SCHEMA or SHOW VARIABLES:
main.variables [ fail ]
mysqltest: At line 715: query 'select * from information_schema.session_variables where variable_name like 'log_queries_not_using_indexes'' failed: 1: Can't create/write to file 'c:\tmp\pbtmp-n_mix-100\#sql_b38_0.MYI' (Errcode: 13)
The result from queries just before the failure was:
< snip >
Variable_name Value
ssl_ca #
ssl_capath #
ssl_cert #
ssl_cipher #
ssl_key #
select * from information_schema.session_variables where variable_name like 'ssl%' order by 1;
VARIABLE_NAME VARIABLE_VALUE
SSL_CA #
SSL_CAPATH #
SSL_CERT #
SSL_CIPHER #
SSL_KEY #
select @@log_queries_not_using_indexes;
@@log_queries_not_using_indexes
0
show variables like 'log_queries_not_using_indexes';
Variable_name Value
log_queries_not_using_indexes OFF
select * from information_schema.session_variables where variable_name like 'log_queries_not_using_indexes';
More results from queries before failure can be found in e:\var-n_mix-100\log\variables.log
Warnings from just before the error:
Error 1 Can't create/write to file 'c:\tmp\pbtmp-n_mix-100\#sql_b38_0.MYI' (Errcode: 13)
Error 1036 Table 'c:\tmp\pbtmp-n_mix-100\#sql_b38_0' is read only
Stopping All Servers
Restoring snapshot of databases
How to repeat:
E.g., here: https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-opt-subqueries&o... vm-win2003-32-a/n_mix
Has happened over 1000 times according to xref: http://tinyurl.com/63bjb3 . All failures after June 2008 were on vm-win2003-23-a, but it also happend on other platforms before that.
