MySQL Bugs: #39364: main.ctype_collate fails randomly in Pushbuild

Bug #39364	main.ctype_collate fails randomly in Pushbuild
Submitted:	10 Sep 2008 8:59	Modified:	31 Mar 2009 14:54
Reporter:	John Embretsen	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	Tests: Server	Severity:	S7 (Test Cases)
Version:	6.0	OS:	Windows (64bit)
Assigned to:		CPU Architecture:	Any
Tags:	pushbuild, sporadic, test failure

Description:
main.ctype_collate fails intermittently in Pushbuild - server crash (test output before crash may vary).

Example (2008-09-09, bzr_mysql-6.0-falcon-team):

main.ctype_collate             [ fail ]

mysqltest: At line 11: query 'CREATE TABLE t2 (
latin1_f CHAR(32) CHARACTER SET latin1 COLLATE koi8r_general_ci NOT NULL
)' failed with wrong errno 2013: 'Lost connection to MySQL server during query', instead of 1253...

The result from queries just before the failure was:
DROP TABLE IF EXISTS t1;
DROP TABLE IF EXISTS t2;
CREATE TABLE t1 (
latin1_f CHAR(32) CHARACTER SET latin1 NOT NULL
);
CREATE TABLE t2 (
latin1_f CHAR(32) CHARACTER SET latin1 COLLATE koi8r_general_ci NOT NULL
);
ERROR HY000: Lost connection to MySQL server during query

More results from queries before failure can be found in e:\var-ps_row-101\log\ctype_collate.log

How to repeat:
Run the main test suite (repeatable in Pushbuild).

This xref shows only the "lost connection" failures: http://tinyurl.com/6ymjnw

Note that it only happens on one host, vm-win2003-64-b.

Happens, e.g., here:
https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-5.1.29-rc&order=... vm-win2003-64-b/n_mix