Bug #52205 innodb.innodb-index_ucs2 crashes the server on Mac OSX
Submitted: 19 Mar 2010 8:47 Modified: 20 Jul 2010 6:56
Reporter: Alexander Nozdrin Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: InnoDB Plugin storage engine Severity:S1 (Critical)
Version:5.5.3-M3 (Celosia) OS:MacOS (i386 max)
Assigned to: Calvin Sun CPU Architecture:Any
Tags: mysql-trunk-bugfixing, pb2, test failure

[19 Mar 2010 8:47] Alexander Nozdrin
Description:
innodb.innodb-index_ucs2 [ fail ]
        Test ended at 2010-03-18 03:44:47

CURRENT_TEST: innodb.innodb-index_ucs2
mysqltest: In included file "./suite/innodb/include/innodb-index.inc": At line 15: query 'alter table t1 add unique index (c), add index (d)' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
10	10	kkk	iii
select * from t1 force index(b) order by b;
a	b	c	d
1	1	ab	ab
2	2	ac	ac
4	4	afe	afe
10	10	kkk	iii
explain select * from t1 force index(b) order by b;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	index	NULL	b	5	NULL	6	
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `a` int(11) NOT NULL,
  `b` int(11) DEFAULT NULL,
  `c` char(10) DEFAULT NULL,
  `d` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`a`),
  KEY `b` (`b`)
) ENGINE=InnoDB DEFAULT CHARSET=ucs2

How to repeat:
Check out PB page for mysql-trunk-bugfixing.

Sample log: http://tinyurl.com/yjhunpo
[19 Mar 2010 15:21] Valeriy Kravchuk
Test passes on current mysql-trunk tree:

77-52-28-202:mysql-test openxs$ ./mtr innodb-index_ucs2 
Logging: ./mtr  innodb-index_ucs2
100319 17:20:18 [Warning] Setting lower_case_table_names=2 because file system for /var/folders/dX/dXCzvuSlHX4Op1g-o1jIWk+++TI/-Tmp-/Vbe49ygQPX/ is case insensitive
100319 17:20:18 [Note] Buffered information: Performance schema disabled (reason: start parameters).

100319 17:20:18 [Note] Plugin 'FEDERATED' is disabled.
100319 17:20:18 [Note] Plugin 'ndbcluster' is disabled.
MySQL Version 5.5.4
Checking supported features...
 - using ndbcluster when necessary, mysqld supports it
 - SSL connections supported
 - binaries are debug compiled
Collecting tests...
vardir: /Users/openxs/dbs/trunk/mysql-test/var
Checking leftover processes...
Removing old var directory...
Creating var directory '/Users/openxs/dbs/trunk/mysql-test/var'...
Installing system database...
Using server port 52372

==============================================================================

TEST                                      RESULT   TIME (ms)
------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
innodb.innodb-index_ucs2                 [ pass ]    484
------------------------------------------------------------
The servers were restarted 0 times
Spent 0.484 of 9 seconds executing testcases

Completed: All 1 tests were successful.

So this looks like mysql-trunk-bugfixing specific bug.
[22 Mar 2010 11:59] Sveta Smirnova
Thank you for the report.

Verified as described using link provided. Not repeatable in my environment.
[20 Jul 2010 6:56] Alexander Nozdrin
Closing as Can't Repeat anymore.