| 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: | |
| 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 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.
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