MySQL#74480 - Failing assertion: os_file_status(newpath, &exists, &type) after Operating system error number 36 in a file operation

create table t1(f1 INT,f2 INT,f3 CHAR (10),primary key(f1,f2)) partition by range(f1) subpartition by hash(f2) subpartitions 2 (partition p1 values less than (0),partition p2 values less than (2),partition p3 values less than (2147483647));

RENAME TABLE t1 TO `t2_new..............................................end`;

2014-11-08 17:24:48 7f142d6fa700  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

141108 17:24:48 [ERROR] InnoDB: File ./test/t2_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#p1sp0.ibd: 'stat' returned OS error 136.

2014-11-08 17:24:48 7f142d6fa700  InnoDB: Assertion failure in thread 139724638365440 in file os0file.cc line 2113

InnoDB: Failing assertion: os_file_status(newpath, &exists, &type)

InnoDB: We intentionally generate a memory trap.

#5  0x00007f142b77f7c0 in *__GI_abort () at abort.c:92

#6  0x0000000000a8b72e in os_file_rename_func (oldpath=0x7f1418254e58 "./test/t1#P#p1#SP#p1sp0.ibd", newpath=0x7f141833e938 "./test/t2_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@0"...) at 10.0/storage/xtradb/os/os0file.cc:2113

#7  0x0000000000c32b6c in pfs_os_file_rename_func (key=42, oldpath=0x7f1418254e58 "./test/t1#P#p1#SP#p1sp0.ibd", newpath=0x7f141833e938 "./test/t2_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@0"..., src_file=0x10be348 "10.0/storage/xtradb/fil/fil0fil.cc", src_line=2990) at 10.0/storage/xtradb/include/os0file.ic:386

#8  0x0000000000c3a766 in fil_rename_tablespace (old_name_in=0x7f142d6f54e0 "test/t1#P#p1#SP#p1sp0", id=4, new_name=0x7f142d6f5c30 "test/t2_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@002"..., new_path_in=0x0) at 10.0/storage/xtradb/fil/fil0fil.cc:2990

#9  0x0000000000c07aa7 in dict_table_rename_in_cache (table=0x7f141834bc78, new_name=0x7f142d6f5c30 "test/t2_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@002"..., rename_also_foreigns=1) at 10.0/storage/xtradb/dict/dict0dict.cc:1606

#10 0x0000000000b069f8 in row_rename_table_for_mysql (old_name=0x7f142d6f5e30 "test/t1#P#p1#SP#p1sp0", new_name=0x7f142d6f5c30 "test/t2_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@002"..., trx=0x7f1418154678, commit=true) at 10.0/storage/xtradb/row/row0mysql.cc:5134

#11 0x0000000000a10aee in innobase_rename_table (trx=0x7f1418154678, from=0x7f142d6f6a60 "./test/t1#P#p1#SP#p1sp0", to=0x7f142d6f6c60 "./test/t2_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@0"...) at 10.0/storage/xtradb/handler/ha_innodb.cc:11266

#12 0x0000000000a10d74 in ha_innobase::rename_table (this=0x7f1418019088, from=0x7f142d6f6a60 "./test/t1#P#p1#SP#p1sp0", to=0x7f142d6f6c60 "./test/t2_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@0"...) at 10.0/storage/xtradb/handler/ha_innodb.cc:11374

#13 0x0000000000870f4f in handler::ha_rename_table (this=0x7f1418019088, from=0x7f142d6f6a60 "./test/t1#P#p1#SP#p1sp0", to=0x7f142d6f6c60 "./test/t2_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@0"...) at 10.0/sql/handler.cc:4237

#14 0x0000000000e0d59c in ha_partition::del_ren_table (this=0x7f141821e080, from=0x7f142d6f7520 "./test/t1", to=0x7f142d6f7730 "./test/t2_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@0"...) at 10.0/sql/ha_partition.cc:2318

#15 0x0000000000e09793 in ha_partition::rename_table (this=0x7f141821e080, from=0x7f142d6f7520 "./test/t1", to=0x7f142d6f7730 "./test/t2_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@0"...) at 10.0/sql/ha_partition.cc:587

#16 0x0000000000870f4f in handler::ha_rename_table (this=0x7f141821e080, from=0x7f142d6f7520 "./test/t1", to=0x7f142d6f7730 "./test/t2_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@0"...) at 10.0/sql/handler.cc:4237

#17 0x0000000000728914 in mysql_rename_table (base=0x7f1421a48270, old_db=0x7f141821d8b0 "test", old_name=0x7f141821d198 "t1", new_db=0x7f141821dec8 "test", new_name=0x7f141821d200 "t2_new", '.' <repeats 46 times>, "end", flags=0) at 10.0/sql/sql_table.cc:5205

#18 0x00000000006a008a in do_rename (thd=0x7f142530b070, ren_table=0x7f141821d2d8, new_db=0x7f141821dec8 "test", new_table_name=0x7f141821d200 "t2_new", '.' <repeats 46 times>, "end", new_table_alias=0x7f141821d8b8 "t2_new", '.' <repeats 46 times>, "end", skip_error=false) at 10.0/sql/sql_rename.cc:276

#19 0x00000000006a0315 in rename_tables (thd=0x7f142530b070, table_list=0x7f141821d2d8, skip_error=false) at 10.0/sql/sql_rename.cc:358

#20 0x000000000069fced in mysql_rename_tables (thd=0x7f142530b070, table_list=0x7f141821d2d8, silent=false) at 10.0/sql/sql_rename.cc:153

#21 0x0000000000683554 in execute_rename_table (thd=0x7f142530b070, first_table=0x7f141821d2d8, all_tables=0x7f141821d2d8) at 10.0/sql/sql_parse.cc:5331

#22 0x000000000067cc2c in mysql_execute_command (thd=0x7f142530b070) at 10.0/sql/sql_parse.cc:3172

#23 0x000000000068586f in mysql_parse (thd=0x7f142530b070, rawbuf=0x7f141821d088 "RENAME TABLE t1 TO `t2_new", '.' <repeats 46 times>, "end`", length=76, parser_state=0x7f142d6f9630) at 10.0/sql/sql_parse.cc:6407

#24 0x0000000000678652 in dispatch_command (command=COM_QUERY, thd=0x7f142530b070, packet=0x7f141a3f2071 "RENAME TABLE t1 TO `t2_new", '.' <repeats 46 times>, "end`", packet_length=76) at 10.0/sql/sql_parse.cc:1299

#25 0x00000000006779f7 in do_command (thd=0x7f142530b070) at 10.0/sql/sql_parse.cc:996

#26 0x00000000007944aa in do_handle_one_connection (thd_arg=0x7f142530b070) at 10.0/sql/sql_connect.cc:1379

#27 0x00000000007941fd in handle_one_connection (arg=0x7f142530b070) at 10.0/sql/sql_connect.cc:1293

#28 0x0000000000ccb4a6 in pfs_spawn_thread (arg=0x7f14253d9df0) at 10.0/storage/perfschema/pfs.cc:1860

#29 0x00007f142d32eb50 in start_thread (arg=<optimized out>) at pthread_create.c:304

#30 0x00007f142b82620d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

revision-id: sergii@pisem.net-20141103164737-457hfby1eg82zol9

date: 2014-11-03 17:47:37 +0100

build-date: 2014-11-08 17:30:48 +0400

revno: 4471

branch-nick: 10.0