| Bug #52206 | main.ctype_utf8mb4_innodb crashes the server on Mac OSX | ||
|---|---|---|---|
| Submitted: | 19 Mar 2010 8:49 | Modified: | 20 Jul 2010 6:55 |
| Reporter: | Alexander Nozdrin | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: InnoDB Plugin storage engine | Severity: | S1 (Critical) |
| Version: | M3 (Celosia) | OS: | MacOS (i386 max) |
| Assigned to: | Calvin Sun | CPU Architecture: | Any |
| Tags: | mysql-trunk-bugfixing, pb2, test failure | ||
[19 Mar 2010 15:19]
Valeriy Kravchuk
Test passes OK on current mysql-trunk tree on Mac: 77-52-28-202:mysql-trunk openxs$ cd ../../dbs/trunk/mysql-test/ 77-52-28-202:mysql-test openxs$ ./mtr ctype_utf8mb4_innodb Logging: ./mtr ctype_utf8mb4_innodb 100319 17:16:55 [Warning] Setting lower_case_table_names=2 because file system for /var/folders/dX/dXCzvuSlHX4Op1g-o1jIWk+++TI/-Tmp-/LxeZWQy58W/ is case insensitive 100319 17:16:55 [Note] Buffered information: Performance schema disabled (reason: start parameters). 100319 17:16:55 [Note] Plugin 'FEDERATED' is disabled. 100319 17:16:55 [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 52346 ============================================================================== TEST RESULT TIME (ms) ------------------------------------------------------------ worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 main.ctype_utf8mb4_innodb [ pass ] 11419 ------------------------------------------------------------ The servers were restarted 0 times Spent 11.419 of 19 seconds executing testcases Completed: All 1 tests were successful. So this is mysql-trunk-bugfixing tree specific bug it seems.
[22 Mar 2010 15:57]
Valeriy Kravchuk
This is NOT repeatable to me even with recent mysql-trunk-bugfixing tree locally: 77-52-28-202:mysql-trunk-bugfixing openxs$ cd ../../dbs/trunk-bugfixing/mysql-test/ 77-52-28-202:mysql-test openxs$ ./mtr ctype_utf8mb4_innodb Logging: ./mtr ctype_utf8mb4_innodb 100322 17:56:03 [Warning] Setting lower_case_table_names=2 because file system for /var/folders/dX/dXCzvuSlHX4Op1g-o1jIWk+++TI/-Tmp-/NNwdD0yt6T/ is case insensitive 100322 17:56:03 [Note] Buffered information: Performance schema disabled (reason: start parameters). 100322 17:56:03 [Note] Plugin 'FEDERATED' is disabled. 100322 17:56:03 [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-bugfixing/mysql-test/var Removing old var directory... Creating var directory '/Users/openxs/dbs/trunk-bugfixing/mysql-test/var'... Installing system database... Using server port 49778 ============================================================================== TEST RESULT TIME (ms) ------------------------------------------------------------ worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 main.ctype_utf8mb4_innodb [ pass ] 13249 ------------------------------------------------------------ The servers were restarted 0 times Spent 13.249 of 21 seconds executing testcases Completed: All 1 tests were successful.
[22 Mar 2010 16:57]
MySQL Verification Team
Not repeatable on Linux X86_64 too: ============================================================================== TEST RESULT TIME (ms) ------------------------------------------------------------ worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 main.ctype_utf8mb4_innodb [ pass ] 39971 ------------------------------------------------------------ The servers were restarted 0 times Spent 39.971 of 51 seconds executing testcases Completed: All 1 tests were successful.
[22 Mar 2010 18:36]
Sveta Smirnova
Thank you for the report. Verified as described using link provided. Not repeatable in my environment.
[20 Jul 2010 6:55]
Alexander Nozdrin
Closing as Can't Repeat anymore.
Description: main.ctype_utf8mb4_innodb [ fail ] Test ended at 2010-03-18 03:45:15 CURRENT_TEST: main.ctype_utf8mb4_innodb mysqltest: In included file "./include/ctype_utf8mb4.inc": At line 1063: query 'create index it1 on t1 (s1)' failed: 2013: Lost connection to MySQL server during query The result from queries just before the failure was: < snip > alter table t1 add b int; INSERT INTO t1 VALUES('uuABCDEFGHIGKLMNOPRSTUVWXYZ̈bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb',1); INSERT INTO t1 VALUES('uuABCDEFGHIGKLMNOPRSTUVWXYZ̈bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb',2); delete from t1 where b=1; INSERT INTO t1 VALUES('UUABCDEFGHIGKLMNOPRSTUVWXYZ̈bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb',1); check table t1; Table Op Msg_type Msg_text test.t1 check status OK INSERT INTO t1 VALUES('uuABCDEFGHIGKLMNOPRSTUVWXYZ̈bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb',3); INSERT INTO t1 VALUES('uuABCDEFGHIGKLMNOPRSTUVWXYZ̈bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb',4); delete from t1 where b=3; INSERT INTO t1 VALUES('uUABCDEFGHIGKLMNOPRSTUVWXYZ̈bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb',3); check table t1; Table Op Msg_type Msg_text test.t1 check status OK drop table t1; set names utf8mb4; create table t1 (s1 char(5) character set utf8mb4) engine InnoDB; insert into t1 values ('a'),('b'),(null),('ペテルグル'),('ü'),('Y'); How to repeat: Check out PB page for mysql-trunk-bugfixing. Sample log: http://tinyurl.com/yjhunpo