Bug #78331 'stat' returned OS error 136. on RENAME TABLE in os_file_rename_func
Submitted: 5 Sep 2015 1:14 Modified: 28 Sep 2016 9:41
Reporter: Roel Van de Paar Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: DML Severity:S6 (Debug Builds)
Version:5.6.23, 5.7.8 RC2, 5.6.26, 5.6.27, 5.6.28, 5.7.9 OS:Any
Assigned to: CPU Architecture:Any

[5 Sep 2015 1:14] Roel Van de Paar 
Description:
mysql> RENAME TABLE t1 TO `new..............................................end`;
ERROR 2013 (HY000): Lost connection to MySQL server during query

2015-09-05 11:04:42 6065 [Note] Event Scheduler: scheduler thread started with id 1
2015-09-05 11:04:51 7f6ccc4a0700  InnoDB: Operating system error number 36 in a file operation.
InnoDB: Error number 36 means 'File name too long'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2015-09-05 11:04:51 6065 [ERROR] InnoDB: File ./test/new@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002eend#P#p1#SP#p1spFirst.ibd: 'stat' returned OS error 136.
2015-09-05 11:04:51 7f6ccc4a0700  InnoDB: Assertion failure in thread 140105260599040 in file os0file.cc line 1950
InnoDB: Failing assertion: os_file_status(newpath, &exists, &type)

How to repeat:
# mysqld options required for replay:  --event-scheduler=ON --maximum-bulk_insert_buffer_size=1M --maximum-join_buffer_size=1M --maximum-max_heap_table_size=1M --maximum-max_join_size=1M --maximum-myisam_max_sort_file_size=1M --maximum-myisam_mmap_size=1M --maximum-myisam_sort_buffer_size=1M --maximum-optimizer_trace_max_mem_size=1M --maximum-preload_buffer_size=1M --maximum-query_alloc_block_size=1M --maximum-query_prealloc_size=1M --maximum-range_alloc_block_size=1M --maximum-read_buffer_size=1M --maximum-read_rnd_buffer_size=1M --maximum-sort_buffer_size=1M --maximum-tmp_table_size=1M --maximum-transaction_alloc_block_size=1M --maximum-transaction_prealloc_size=1M --log-output=none --sql_mode=ONLY_FULL_GROUP_BY --slave-transaction-retries=1023 --max-relay-log-size=2 --myisam-block-size=1024

DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(a INT)PARTITION BY LIST (a) SUBPARTITION BY HASH (a) SUBPARTITIONS 2 (PARTITION p1 VALUES IN (1) COMMENT "Comment in p1" (SUBPARTITION p1spFirst COMMENT "SubPartition comment in p1spFirst",SUBPARTITION p1spSecond COMMENT "SubPartition comment in p1spSecond"),PARTITION p2 VALUES IN (2) COMMENT "Comment in p2" (SUBPARTITION p2spFirst COMMENT "SubPartition comment in p2spFirst",SUBPARTITION p2spSecond COMMENT "SubPartition comment in p2spSecond"));
RENAME TABLE t1 TO `new..............................................end`;
[5 Sep 2015 1:14] Roel Van de Paar 
+bt
#0  0x00007f6ccbee7771 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1  0x0000000000a9804e in my_write_core (sig=6) at /bzr/mysql-5.6.23/mysys/stacktrace.c:422
#2  0x00000000007277f0 in handle_fatal_signal (sig=6) at /bzr/mysql-5.6.23/sql/signal_handler.cc:230
#3  <signal handler called>
#4  0x00007f6ccacf35d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5  0x00007f6ccacf4cc8 in __GI_abort () at abort.c:90
#6  0x0000000000bea640 in os_file_rename_func (oldpath=0x7f6c198fa958 "./test/t1#P#p1#SP#p1spFirst.ibd", newpath=0x7f6c1990c578 "./test/new@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002eend#P#p1#SP#p1spFirst.ibd") at /bzr/mysql-5.6.23/storage/innobase/os/os0file.cc:1950
#7  0x0000000000d9ef0e in pfs_os_file_rename_func (key=44, oldpath=0x7f6c198fa958 "./test/t1#P#p1#SP#p1spFirst.ibd", newpath=0x7f6c1990c578 "./test/new@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002eend#P#p1#SP#p1spFirst.ibd", src_file=0x10700a8 "/bzr/mysql-5.6.23/storage/innobase/fil/fil0fil.cc", src_line=3127) at /bzr/mysql-5.6.23/storage/innobase/include/os0file.ic:383
#8  0x0000000000da6d76 in fil_rename_tablespace (old_name_in=0x7f6ccc49aed0 "test/t1#P#p1#SP#p1spFirst", id=6, new_name=0x7f6ccc49b610 "test/new@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002eend#P#p1#SP#p1spFirst", new_path_in=0x0) at /bzr/mysql-5.6.23/storage/innobase/fil/fil0fil.cc:3127
#9  0x0000000000d71e01 in dict_table_rename_in_cache (table=0x7f6c19880378, new_name=0x7f6ccc49b610 "test/new@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002eend#P#p1#SP#p1spFirst", rename_also_foreigns=1) at /bzr/mysql-5.6.23/storage/innobase/dict/dict0dict.cc:1612
#10 0x0000000000c6b23a in row_rename_table_for_mysql (old_name=0x7f6ccc49b810 "test/t1#P#p1#SP#p1spFirst", new_name=0x7f6ccc49b610 "test/new@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002eend#P#p1#SP#p1spFirst", trx=0x7f6c198c7a78, commit=true) at /bzr/mysql-5.6.23/storage/innobase/row/row0mysql.cc:5152
#11 0x0000000000b76fb9 in innobase_rename_table (trx=0x7f6c198c7a78, from=0x7f6ccc49c440 "./test/t1#P#p1#SP#p1spFirst", to=0x7f6ccc49c640 "./test/new@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002eend#P#p1#SP#p1spFirst") at /bzr/mysql-5.6.23/storage/innobase/handler/ha_innodb.cc:10197
#12 0x0000000000b77206 in ha_innobase::rename_table (this=0x7f6c198232e0, from=0x7f6ccc49c440 "./test/t1#P#p1#SP#p1spFirst", to=0x7f6ccc49c640 "./test/new@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002eend#P#p1#SP#p1spFirst") at /bzr/mysql-5.6.23/storage/innobase/handler/ha_innodb.cc:10300
#13 0x000000000063ffa3 in handler::ha_rename_table (this=0x7f6c198232e0, from=0x7f6ccc49c440 "./test/t1#P#p1#SP#p1spFirst", to=0x7f6ccc49c640 "./test/new@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002eend#P#p1#SP#p1spFirst") at /bzr/mysql-5.6.23/sql/handler.cc:4476
#14 0x0000000000e11c39 in ha_partition::del_ren_table (this=0x7f6c19822e68, from=0x7f6ccc49d0c0 "./test/t1", to=0x7f6ccc49d2d0 "./test/new@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002eend") at /bzr/mysql-5.6.23/sql/ha_partition.cc:2347
#15 0x0000000000e0db5d in ha_partition::rename_table (this=0x7f6c19822e68, from=0x7f6ccc49d0c0 "./test/t1", to=0x7f6ccc49d2d0 "./test/new@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002eend") at /bzr/mysql-5.6.23/sql/ha_partition.cc:615
#16 0x000000000063ffa3 in handler::ha_rename_table (this=0x7f6c19822e68, from=0x7f6ccc49d0c0 "./test/t1", to=0x7f6ccc49d2d0 "./test/new@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002eend") at /bzr/mysql-5.6.23/sql/handler.cc:4476
#17 0x000000000083fa97 in mysql_rename_table (base=0x7f6cca030800, old_db=0x7f6c19822718 "test", old_name=0x7f6c19822120 "t1", new_db=0x7f6c19822cb8 "test", new_name=0x7f6c19822150 "new", '.' <repeats 46 times>, "end", flags=0) at /bzr/mysql-5.6.23/sql/sql_table.cc:5238
#18 0x00000000007fa180 in do_rename (thd=0x7f6c23ff8000, ren_table=0x7f6c198221b8, new_db=0x7f6c19822cb8 "test", new_table_name=0x7f6c19822150 "new", '.' <repeats 46 times>, "end", new_table_alias=0x7f6c19822720 "new", '.' <repeats 46 times>, "end", skip_error=false) at /bzr/mysql-5.6.23/sql/sql_rename.cc:278
#19 0x00000000007fa42c in rename_tables (thd=0x7f6c23ff8000, table_list=0x7f6c198221b8, skip_error=false) at /bzr/mysql-5.6.23/sql/sql_rename.cc:367
#20 0x00000000007f9dcb in mysql_rename_tables (thd=0x7f6c23ff8000, table_list=0x7f6c198221b8, silent=false) at /bzr/mysql-5.6.23/sql/sql_rename.cc:154
#21 0x00000000007d4c0b in mysql_execute_command (thd=0x7f6c23ff8000) at /bzr/mysql-5.6.23/sql/sql_parse.cc:3184
#22 0x00000000007dd54a in mysql_parse (thd=0x7f6c23ff8000, rawbuf=0x7f6c19822010 "RENAME TABLE t1 TO `new", '.' <repeats 46 times>, "end`", length=73, parser_state=0x7f6ccc49ee70) at /bzr/mysql-5.6.23/sql/sql_parse.cc:6357
#23 0x00000000007d06bc in dispatch_command (command=COM_QUERY, thd=0x7f6c23ff8000, packet=0x7f6c18724001 "RENAME TABLE t1 TO `new", '.' <repeats 46 times>, "end`", packet_length=73) at /bzr/mysql-5.6.23/sql/sql_parse.cc:1332
#24 0x00000000007cf7ab in do_command (thd=0x7f6c23ff8000) at /bzr/mysql-5.6.23/sql/sql_parse.cc:1034
#25 0x0000000000797b3d in do_handle_one_connection (thd_arg=0x7f6c23ff8000) at /bzr/mysql-5.6.23/sql/sql_connect.cc:982
#26 0x0000000000797626 in handle_one_connection (arg=0x7f6c23ff8000) at /bzr/mysql-5.6.23/sql/sql_connect.cc:898
#27 0x0000000000ae6600 in pfs_spawn_thread (arg=0x7f6cb1370a60) at /bzr/mysql-5.6.23/storage/perfschema/pfs.cc:1860
#28 0x00007f6ccbee2df5 in start_thread (arg=0x7f6ccc4a0700) at pthread_create.c:308
#29 0x00007f6ccadb41ad in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113
[5 Sep 2015 1:17] Roel Van de Paar 
Actually, no --options are required. Still crashes without above mentioned ones. Major bug.
[5 Sep 2015 1:24] Roel Van de Paar 
Looks like a dup of 74480 which seems incorrect triaged
[7 Sep 2015 6:32] MySQL Verification Team 
Thank you for the report.
Confirmed that only debug builds of 5.6.26, 5.6.27, 5.6.28, 5.7.8 and 5.7.9 are affected and hence removing security flag as it does't qualify for the security bug.

Marking this as duplicate of 74480.
[7 Sep 2015 6:34] MySQL Verification Team 
// 5.6.26 -- release build not affected

mysql> show variables like '%version%';
+-------------------------+------------------------------+
| Variable_name           | Value                        |
+-------------------------+------------------------------+
| innodb_version          | 5.6.26                       |
| protocol_version        | 10                           |
| slave_type_conversions  |                              |
| version                 | 5.6.26                       |
| version_comment         | MySQL Community Server (GPL) |
| version_compile_machine | x86_64                       |
| version_compile_os      | linux-glibc2.5               |
+-------------------------+------------------------------+
7 rows in set (0.00 sec)

mysql> DROP DATABASE test;CREATE DATABASE test;USE test;
Query OK, 0 rows affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
mysql> CREATE TABLE t1(a INT)PARTITION BY LIST (a) SUBPARTITION BY HASH (a) SUBPARTITIONS 2 (PARTITION p1 VALUES IN (1) COMMENT "Comment in p1" (SUBPARTITION p1spFirst COMMENT "SubPartition comment in p1spFirst",SUBPARTITION p1spSecond COMMENT "SubPartition comment in p1spSecond"),PARTITION p2 VALUES IN (2) COMMENT "Comment in p2" (SUBPARTITION p2spFirst COMMENT "SubPartition comment in p2spFirst",SUBPARTITION p2spSecond COMMENT "SubPartition comment in p2spSecond"));
Query OK, 0 rows affected (0.01 sec)

mysql> RENAME TABLE t1 TO `new..............................................end`;
ERROR 1025 (HY000): Error on rename of './test/t1' to './test/new@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e' (errno: -1 - Unknown error -1)
.
mysql> RENAME TABLE t1 TO `new..............................................end`;
ERROR 1025 (HY000): Error on rename of './test/t1' to './test/new@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e' (errno: -1 - Unknown error -1)
mysql>

-- 5.6.26 only debug builds affected

[umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.26:  bin/mysql -uroot -S /tmp/mysql_ushastry.sock                                                                                         Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.26-debug MySQL Community Server - Debug (GPL)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(a INT)PARTITION BY LIST (a) SUBPARTITION BY HASH (a) SUBPARTITIONS 2 (PARTITION p1 VALUES IN (1) COMMENT "Comment in p1" (SUBPARTITION p1spFirst COMMENT "SubPartition comment in p1spFirst",SUBPARTITION p1spSecond COMMENT "SubPartition comment in p1spSecond"),PARTITION p2 VALUES IN (2) COMMENT "Comment in p2" (SUBPARTITION p2spFirst COMMENT "SubPartition comment in p2spFirst",SUBPARTITION p2spSecond COMMENT "SubPartition comment in p2spSecond"));
RENAME TABLE t1 TO `new..............................................end`;Query OK, 1 row affected (0.03 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
mysql> CREATE TABLE t1(a INT)PARTITION BY LIST (a) SUBPARTITION BY HASH (a) SUBPARTITIONS 2 (PARTITION p1 VALUES IN (1) COMMENT "Comment in p1" (SUBPARTITION p1spFirst COMMENT "SubPartition comment in p1spFirst",SUBPARTITION p1spSecond COMMENT "SubPartition comment in p1spSecond"),PARTITION p2 VALUES IN (2) COMMENT "Comment in p2" (SUBPARTITION p2spFirst COMMENT "SubPartition comment in p2spFirst",SUBPARTITION p2spSecond COMMENT "SubPartition comment in p2spSecond"));
Query OK, 0 rows affected (0.02 sec)

mysql> RENAME TABLE t1 TO `new..............................................end`;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql>
[7 Sep 2015 6:34] MySQL Verification Team 
// 5.6.27 - release build not affected

mysql> show variables like '%version%';
+-------------------------+---------------------------------------------------------+
| Variable_name           | Value                                                   |
+-------------------------+---------------------------------------------------------+
| innodb_version          | 5.6.27                                                  |
| protocol_version        | 10                                                      |
| slave_type_conversions  |                                                         |
| version                 | 5.6.27-enterprise-commercial-advanced                   |
| version_comment         | MySQL Enterprise Server - Advanced Edition (Commercial) |
| version_compile_machine | x86_64                                                  |
| version_compile_os      | linux-glibc2.5                                          |
+-------------------------+---------------------------------------------------------+
7 rows in set (0.00 sec)

mysql> DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(a INT)PARTITION BY LIST (a) SUBPARTITION BY HASH (a) SUBPARTITIONS 2 (PARTITION p1 VALUES IN (1) COMMENT "Comment in p1" (SUBPARTITION p1spFirst COMMENT "SubPartition comment in p1spFirst",SUBPARTITION p1spSecond COMMENT "SubPartition comment in p1spSecond"),PARTITION p2 VALUES IN (2) COMMENT "Comment in p2" (SUBPARTITION p2spFirst COMMENT "SubPartition comment in p2spFirst",SUBPARTITION p2spSecond COMMENT "SubPartition comment in p2spSecond"));
Query OK, 0 rows affected (0.04 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
mysql> CREATE TABLE t1(a INT)PARTITION BY LIST (a) SUBPARTITION BY HASH (a) SUBPARTITIONS 2 (PARTITION p1 VALUES IN (1) COMMENT "Comment in p1" (SUBPARTITION p1spFirst COMMENT "SubPartition comment in p1spFirst",SUBPARTITION p1spSecond COMMENT "SubPartition comment in p1spSecond"),PARTITION p2 VALUES IN (2) COMMENT "Comment in p2" (SUBPARTITION p2spFirst COMMENT "SubPartition comment in p2spFirst",SUBPARTITION p2spSecond COMMENT "SubPartition comment in p2spSecond"));
Query OK, 0 rows affected (0.05 sec)

mysql> RENAME TABLE t1 TO `new..............................................end`;
ERROR 1025 (HY000): Error on rename of './test/t1' to './test/new@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e' (errno: -1 - Unknown error -1)
.
.
mysql> RENAME TABLE t1 TO `new..............................................end`;
ERROR 1025 (HY000): Error on rename of './test/t1' to './test/new@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e' (errno: -1 - Unknown error -1)
mysql>

// 5.6.27 - debug build affected

mysql> show variables like '%version%';
+-------------------------+---------------------------------------------------------------+
| Variable_name           | Value                                                         |
+-------------------------+---------------------------------------------------------------+
| innodb_version          | 5.6.27                                                        |
| protocol_version        | 10                                                            |
| slave_type_conversions  |                                                               |
| version                 | 5.6.27-enterprise-commercial-advanced-debug                   |
| version_comment         | MySQL Enterprise Server - Advanced Edition Debug (Commercial) |
| version_compile_machine | x86_64                                                        |
| version_compile_os      | linux-glibc2.5                                                |
+-------------------------+---------------------------------------------------------------+
7 rows in set (0.01 sec)

.

mysql> RENAME TABLE t1 TO `new..............................................end`;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql>
[7 Sep 2015 6:34] MySQL Verification Team 
// 5.6.28 - release build not affected

mysql> show variables like '%version%';
+-------------------------+---------------------------------------------------------+
| Variable_name           | Value                                                   |
+-------------------------+---------------------------------------------------------+
| innodb_version          | 5.6.28                                                  |
| protocol_version        | 10                                                      |
| slave_type_conversions  |                                                         |
| version                 | 5.6.28-enterprise-commercial-advanced                   |
| version_comment         | MySQL Enterprise Server - Advanced Edition (Commercial) |
| version_compile_machine | x86_64                                                  |
| version_compile_os      | linux-glibc2.5                                          |
+-------------------------+---------------------------------------------------------+
7 rows in set (0.00 sec)

mysql> DROP DATABASE test;CREATE DATABASE test;USE test;
Query OK, 0 rows affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
mysql> CREATE TABLE t1(a INT)PARTITION BY LIST (a) SUBPARTITION BY HASH (a) SUBPARTITIONS 2 (PARTITION p1 VALUES IN (1) COMMENT "Comment in p1" (SUBPARTITION p1spFirst COMMENT "SubPartition comment in p1spFirst",SUBPARTITION p1spSecond COMMENT "SubPartition comment in p1spSecond"),PARTITION p2 VALUES IN (2) COMMENT "Comment in p2" (SUBPARTITION p2spFirst COMMENT "SubPartition comment in p2spFirst",SUBPARTITION p2spSecond COMMENT "SubPartition comment in p2spSecond"));
RENAME TABLE t1 TO `new..............................................end`;Query OK, 0 rows affected (0.00 sec)
.
mysql> RENAME TABLE t1 TO `new..............................................end`;
ERROR 1025 (HY000): Error on rename of './test/t1' to './test/new@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e' (errno: -1 - Unknown error -1)

// 5.6.28 - debug build affected

mysql> show variables like '%version%';
+-------------------------+---------------------------------------------------------------+
| Variable_name           | Value                                                         |
+-------------------------+---------------------------------------------------------------+
| innodb_version          | 5.6.28                                                        |
| protocol_version        | 10                                                            |
| slave_type_conversions  |                                                               |
| version                 | 5.6.28-enterprise-commercial-advanced-debug                   |
| version_comment         | MySQL Enterprise Server - Advanced Edition Debug (Commercial) |
| version_compile_machine | x86_64                                                        |
| version_compile_os      | linux-glibc2.5                                                |
+-------------------------+---------------------------------------------------------------+
7 rows in set (0.00 sec)

mysql> DROP DATABASE test;CREATE DATABASE test;USE test;
Query OK, 1 row affected (0.03 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
mysql> CREATE TABLE t1(a INT)PARTITION BY LIST (a) SUBPARTITION BY HASH (a) SUBPARTITIONS 2 (PARTITION p1 VALUES IN (1) COMMENT "Comment in p1" (SUBPARTITION p1spFirst COMMENT "SubPartition comment in p1spFirst",SUBPARTITION p1spSecond COMMENT "SubPartition comment in p1spSecond"),PARTITION p2 VALUES IN (2) COMMENT "Comment in p2" (SUBPARTITION p2spFirst COMMENT "SubPartition comment in p2spFirst",SUBPARTITION p2spSecond COMMENT "SubPartition comment in p2spSecond"));
Query OK, 0 rows affected (0.03 sec)

mysql> RENAME TABLE t1 TO `new..............................................end`;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql>
[7 Sep 2015 6:35] MySQL Verification Team 
// 5.7.9  - release build not affected

mysql> show variables like '%version%';
+-------------------------+---------------------------------------------------------+
| Variable_name           | Value                                                   |
+-------------------------+---------------------------------------------------------+
| innodb_version          | 5.7.9                                                   |
| protocol_version        | 10                                                      |
| slave_type_conversions  |                                                         |
| version                 | 5.7.9-enterprise-commercial-advanced                    |
| version_comment         | MySQL Enterprise Server - Advanced Edition (Commercial) |
| version_compile_machine | x86_64                                                  |
| version_compile_os      | linux-glibc2.5                                          |
+-------------------------+---------------------------------------------------------+
7 rows in set, 1 warning (0.00 sec)

mysql> DROP DATABASE test;CREATE DATABASE test;USE test;
ERROR 1008 (HY000): Can't drop database 'test'; database doesn't exist
Query OK, 1 row affected (0.00 sec)

Database changed
mysql> CREATE TABLE t1(a INT)PARTITION BY LIST (a) SUBPARTITION BY HASH (a) SUBPARTITIONS 2 (PARTITION p1 VALUES IN (1) COMMENT "Comment in p1" (SUBPARTITION p1spFirst COMMENT "SubPartition comment in p1spFirst",SUBPARTITION p1spSecond COMMENT "SubPartition comment in p1spSecond"),PARTITION p2 VALUES IN (2) COMMENT "Comment in p2" (SUBPARTITION p2spFirst COMMENT "SubPartition comment in p2spFirst",SUBPARTITION p2spSecond COMMENT "SubPartition comment in p2spSecond"));
RENAME TABLE t1 TO `new..............................................end`;Query OK, 0 rows affected (0.00 sec)

.
mysql> RENAME TABLE t1 TO `new..............................................end`;
ERROR 1025 (HY000): Error on rename of './test/t1' to './test/new@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e' (errno: 168 - Unknown (generic) error from engine)
mysql>

// 5.7.9  - debug build affected

mysql> show variables like '%version%';
+-------------------------+---------------------------------------------------------------+
| Variable_name           | Value                                                         |
+-------------------------+---------------------------------------------------------------+
| innodb_version          | 5.7.9                                                         |
| protocol_version        | 10                                                            |
| slave_type_conversions  |                                                               |
| version                 | 5.7.9-enterprise-commercial-advanced-debug                    |
| version_comment         | MySQL Enterprise Server - Advanced Edition Debug (Commercial) |
| version_compile_machine | x86_64                                                        |
| version_compile_os      | linux-glibc2.5                                                |
+-------------------------+---------------------------------------------------------------+
7 rows in set, 1 warning (0.00 sec)

mysql> DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(a INT)PARTITION BY LIST (a) SUBPARTITION BY HASH (a) SUBPARTITIONS 2 (PARTITION p1 VALUES IN (1) COMMENT "Comment in p1" (SUBPARTITION p1spFirst COMMENT "SubPartition comment in p1spFirst",SUBPARTITION p1spSecond COMMENT "SubPartition comment in p1spSecond"),PARTITION p2 VALUES IN (2) COMMENT "Comment in p2" (SUBPARTITION p2spFirst COMMENT "SubPartition comment in p2spFirst",SUBPARTITION p2spSecond COMMENT "SubPartition comment in p2spSecond"));
Query OK, 1 row affected (0.03 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
mysql> CREATE TABLE t1(a INT)PARTITION BY LIST (a) SUBPARTITION BY HASH (a) SUBPARTITIONS 2 (PARTITION p1 VALUES IN (1) COMMENT "Comment in p1" (SUBPARTITION p1spFirst COMMENT "SubPartition comment in p1spFirst",SUBPARTITION p1spSecond COMMENT "SubPartition comment in p1spSecond"),PARTITION p2 VALUES IN (2) COMMENT "Comment in p2" (SUBPARTITION p2spFirst COMMENT "SubPartition comment in p2spFirst",SUBPARTITION p2spSecond COMMENT "SubPartition comment in p2spSecond"));
Query OK, 0 rows affected (0.02 sec)

mysql> RENAME TABLE t1 TO `new..............................................end`;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql>
[28 Sep 2016 9:41] Roel Van de Paar 
For easy reference, this bug is considered a duplicate of bug 74480