Description:
log_tables.test fails on all windows platforms:
main.log_tables [ fail ]
mysqltest: At line 444: query 'ALTER TABLE mysql.slow_log ENGINE = CSV' failed: 7: Error on rename of '.\mysql\slow_log.MYI' to '.\mysql\#sql2-3a0-1.MYI' (Errcode: 13)
The result from queries just before the failure was:
< snip >
My own slow query 0
SELECT "My own slow query", sleep(2);
My own slow query sleep(2)
My own slow query 0
SELECT "My own slow query", sleep(2);
My own slow query sleep(2)
My own slow query 0
SELECT "My own slow query", sleep(2);
My own slow query sleep(2)
My own slow query 0
SELECT * FROM mysql.slow_log WHERE seq >= 2 LIMIT 3;
start_time user_host query_time lock_time rows_sent rows_examined db last_insert_id insert_id server_id sql_text seq
START_TIME USER_HOST QUERY_TIME 00:00:00 1 0 test NULL NULL 1 SELECT "My own slow query", sleep(2) 2
START_TIME USER_HOST QUERY_TIME 00:00:00 1 0 test NULL NULL 1 SELECT "My own slow query", sleep(2) 3
START_TIME USER_HOST QUERY_TIME 00:00:00 1 0 test NULL NULL 1 SELECT "My own slow query", sleep(2) 4
SET GLOBAL slow_query_log = 0;
SET SESSION long_query_time =@old_long_query_time;
FLUSH LOGS;
ALTER TABLE mysql.slow_log DROP COLUMN seq;
ALTER TABLE mysql.slow_log ENGINE = CSV;
More results from queries before failure can be found in e:\var-n_mix-110\log\log_tables.log
Warnings from just before the error:
Error 7 Error on rename of '.\mysql\slow_log.MYI' to '.\mysql\#sql2-3a0-1.MYI' (Errcode: 13)
Stopping All Servers
Restoring snapshot of databases
Resuming Tests.
How to repeat:
See pushbuild, all pushes into 5.2 since the start of September till Oct, 10.
Suggested fix:
Find out the cause of the failure (it it the testcase or something is really wrong in the server) and fix it.