Bug #39748 main.grant fails sporadically on windows
Submitted: 30 Sep 2008 6:32 Modified: 11 Jun 2009 3:42
Reporter: Alexander Nozdrin Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:6.0-TRUNK OS:Windows (win2003-x86)
Assigned to: Alexander Nozdrin CPU Architecture:Any
Tags: pushbuild, sporadic, test failure

[30 Sep 2008 6:32] Alexander Nozdrin
main.grant fails sporadically on windows (win2003-x86) with the following symptoms:

mysqltest: At line 217: query 'GRANT SELECT ON ��.��� TO ����@localhost' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
ERROR HY000: Operation DROP USER failed for 'drop_user1'@'localhost','drop_user2'@'localhost','drop_user3'@'localhost','drop_user4'@'localhost'
drop table t1;
grant usage on *.* to mysqltest_1@localhost identified by "password";
grant select, update, insert on test.* to mysqltest_1@localhost;
show grants for mysqltest_1@localhost;
Grants for mysqltest_1@localhost
GRANT USAGE ON *.* TO 'mysqltest_1'@'localhost' IDENTIFIED BY PASSWORD '*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19'
GRANT SELECT, INSERT, UPDATE ON `test`.* TO 'mysqltest_1'@'localhost'
drop user mysqltest_1@localhost;
SET NAMES koi8r;
USE ��;
CREATE TABLE ��� (��� int);
GRANT SELECT ON ��.* TO ����@localhost;
SHOW GRANTS FOR ����@localhost;
Grants for ����@localhost
GRANT USAGE ON *.* TO '����'@'localhost'
GRANT SELECT ON `��`.* TO '����'@'localhost'
REVOKE SELECT ON ��.* FROM ����@localhost;
GRANT SELECT ON ��.��� TO ����@localhost;

How to repeat:
The bug reported after a failure in 6.0-falcon on Mon Sep 29 06:57:33:

XRef: http://tinyurl.com/4qnpbx
[11 Jun 2009 3:42] Alexander Nozdrin
According to XRef the last failure happened in January 2009.
XRef2 does not know about that failure either.

Closing as "Can't Repeat".