Bug #31580 log_tables.test fails on all windows platforms in pushbuild
Submitted: 13 Oct 2007 14:44 Modified: 16 Oct 2007 0:12
Reporter: Sergey Petrunya Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.2-bk OS:Windows
Assigned to: CPU Architecture:Any

[13 Oct 2007 14:44] Sergey Petrunya
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.
[13 Oct 2007 14:45] Sergey Petrunya
Disabling log_tables test in pushbuild. Please re-enable it once the bug is fixed.
[16 Oct 2007 0:12] Marc ALFF
Duplicate of bug#30221