Bug #74480 | Failing assertion: os_file_status(newpath, &exists, &type), os0file.cc line 1950 | ||
---|---|---|---|
Submitted: | 21 Oct 2014 11:44 | Modified: | 7 Sep 2015 7:01 |
Reporter: | Ramesh Sivaraman | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: DDL | Severity: | S1 (Critical) |
Version: | 5.6.20-debug,5.6.26, 5.6.27, 5.6.28, 5.7.8 and 5.7.9 | OS: | Linux (CentOS 7) |
Assigned to: | CPU Architecture: | Any |
[21 Oct 2014 11:44]
Ramesh Sivaraman
[21 Oct 2014 11:58]
MySQL Verification Team
Thank you for the bug report. I couldn't repeat with recent source code, please try with latest release. Thanks. C:\dbs>c:\dbs\5.6\bin\mysql -uroot --port=3560 --debug-info --prompt="mysql 5.6 > " Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.22-debug Source distribution Copyright (c) 2000, 2014, 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 5.6 > CREATE DATABASE d2 -> ; Query OK, 1 row affected (0.01 sec) mysql 5.6 > USE d2 Database changed mysql 5.6 > 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 Query OK, 0 rows affected (1.06 sec) mysql 5.6 > RENAME TABLE t1 TO `t2_new..............................................end`; ERROR 7 (HY000): Error on rename of '.\d2\t1.par' to '.\d2\t2_new@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e @002e@002eend.par' (Errcode: 2 - No such file or directory) mysql 5.6 > SHOW VARIABLES LIKE "%VERSION%"; +-------------------------+---------------------+ | Variable_name | Value | +-------------------------+---------------------+ | innodb_version | 5.6.22 | | protocol_version | 10 | | slave_type_conversions | | | version | 5.6.22-debug | | version_comment | Source distribution | | version_compile_machine | x86_64 | | version_compile_os | Win64 | +-------------------------+---------------------+ 7 rows in set (0.02 sec) mysql 5.6 >
[21 Oct 2014 12:02]
MySQL Verification Team
Repeatable on Linux CentOS 6.5: [miguel@cuzcatlan 5.6]$ bin/mysql -uroot --socket=/tmp/mysql.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.6.22-debug Source distribution Copyright (c) 2000, 2014, 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> USE test Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> 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)); Query OK, 0 rows affected (3.92 sec) mysql> RENAME TABLE t1 TO `t2_new..............................................end`; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql>
[6 Nov 2014 5:28]
Ramesh Sivaraman
Another testcase. DROP DATABASE test;CREATE DATABASE test;USE test; SET @@session.storage_engine=MYISAM; CREATE TABLE t1(id INT,purchased DATE)PARTITION BY RANGE(YEAR(purchased)) SUBPARTITION BY HASH(TO_DAYS(purchased)) SUBPARTITIONS 2 (PARTITION p0 VALUES LESS THAN MAXVALUE (SUBPARTITION sp0 DATA DIRECTORY='/tmp/not-existing' INDEX DIRECTORY='/tmp/not-existing',SUBPARTITION sp1)); ALTER TABLE t1 ENGINE=InnoDB; ***** GDB info #0 0x00007ff21f5e1771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000a9035e in my_write_core (sig=6) at /ssd/ramesh/mysql-server/mysql-5.6/mysys/stacktrace.c:422 #2 0x0000000000723688 in handle_fatal_signal (sig=6) at /ssd/ramesh/mysql-server/mysql-5.6/sql/signal_handler.cc:230 #3 <signal handler called> #4 0x00007ff21e3ed5c9 in raise () from /lib64/libc.so.6 #5 0x00007ff21e3eecd8 in abort () from /lib64/libc.so.6 #6 0x0000000000bc8807 in os_file_rename_func (oldpath=0x7ff18301c678 "/tmp/not-existing/test/#sql-69d_1#P#p0#SP#sp0.ibd", newpath=0x7ff18301ca38 "/tmp/not-existing/test/t1#P#p0#SP#sp0.ibd") at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/os/os0file.cc:1951 #7 0x0000000000d7bace in pfs_os_file_rename_func (key=41, oldpath=0x7ff18301c678 "/tmp/not-existing/test/#sql-69d_1#P#p0#SP#sp0.ibd", newpath=0x7ff18301ca38 "/tmp/not-existing/test/t1#P#p0#SP#sp0.ibd", src_file=0x10664e8 "/ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/fil/fil0fil.cc", src_line=3124) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/include/os0file.ic:383 #8 0x0000000000d8392b in fil_rename_tablespace (old_name_in=0x7ff21fbd3230 "test/#sql-69d_1#P#p0#SP#sp0", id=6, new_name=0x7ff21fbd3970 "test/t1#P#p0#SP#sp0", new_path_in=0x7ff18301c438 "/tmp/not-existing/test/t1#P#p0#SP#sp0.ibd") at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/fil/fil0fil.cc:3124 #9 0x0000000000d4f445 in dict_table_rename_in_cache (table=0x7ff183087378, new_name=0x7ff21fbd3970 "test/t1#P#p0#SP#sp0", rename_also_foreigns=1) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/dict/dict0dict.cc:1602 #10 0x0000000000c4905e in row_rename_table_for_mysql (old_name=0x7ff21fbd3b70 "test/#sql-69d_1#P#p0#SP#sp0", new_name=0x7ff21fbd3970 "test/t1#P#p0#SP#sp0", trx=0x7ff1830c7a78, commit=true) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/row/row0mysql.cc:5096 #11 0x0000000000b55c4f in innobase_rename_table (trx=0x7ff1830c7a78, from=0x7ff21fbd47a0 "./test/#sql-69d_1#P#p0#SP#sp0", to=0x7ff21fbd49a0 "./test/t1#P#p0#SP#sp0") at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/handler/ha_innodb.cc:10186 #12 0x0000000000b55e9c in ha_innobase::rename_table (this=0x7ff18307f010, from=0x7ff21fbd47a0 "./test/#sql-69d_1#P#p0#SP#sp0", to=0x7ff21fbd49a0 "./test/t1#P#p0#SP#sp0") at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/handler/ha_innodb.cc:10289 #13 0x000000000063c2d7 in handler::ha_rename_table (this=0x7ff18307f010, from=0x7ff21fbd47a0 "./test/#sql-69d_1#P#p0#SP#sp0", to=0x7ff21fbd49a0 "./test/t1#P#p0#SP#sp0") at /ssd/ramesh/mysql-server/mysql-5.6/sql/handler.cc:4476 #14 0x0000000000e05c8f in ha_partition::del_ren_table (this=0x7ff18307eb18, from=0x7ff21fbd5420 "./test/#sql-69d_1", to=0x7ff21fbd5630 "./test/t1") at /ssd/ramesh/mysql-server/mysql-5.6/sql/ha_partition.cc:2312 #15 0x0000000000e01bb3 in ha_partition::rename_table (this=0x7ff18307eb18, from=0x7ff21fbd5420 "./test/#sql-69d_1", to=0x7ff21fbd5630 "./test/t1") at /ssd/ramesh/mysql-server/mysql-5.6/sql/ha_partition.cc:580 #16 0x000000000063c2d7 in handler::ha_rename_table (this=0x7ff18307eb18, from=0x7ff21fbd5420 "./test/#sql-69d_1", to=0x7ff21fbd5630 "./test/t1") at /ssd/ramesh/mysql-server/mysql-5.6/sql/handler.cc:4476 #17 0x000000000083b433 in mysql_rename_table (base=0x7ff2193fb800, old_db=0x7ff18301f660 "test", old_name=0x7ff21fbd6890 "#sql-69d_1", new_db=0x7ff18301f660 "test", new_name=0x7ff18301f0c8 "t1", flags=1) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_table.cc:5238 #18 0x0000000000842e7c in mysql_alter_table (thd=0x7ff18c324000, new_db=0x7ff18301f660 "test", new_name=0x0, create_info=0x7ff21fbd76e0, table_list=0x7ff18301f100, alter_info=0x7ff21fbd7650, order_num=0, order=0x0, ignore=false) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_table.cc:8622 #19 0x000000000098177f in Sql_cmd_alter_table::execute (this=0x7ff18301f670, thd=0x7ff18c324000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_alter.cc:313 #20 0x00000000007d5ea3 in mysql_execute_command (thd=0x7ff18c324000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_parse.cc:4945 #21 0x00000000007d8fa4 in mysql_parse (thd=0x7ff18c324000, rawbuf=0x7ff18301f010 "ALTER TABLE t1 ENGINE=InnoDB", length=28, parser_state=0x7ff21fbd8e70) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_parse.cc:6245 #22 0x00000000007cc557 in dispatch_command (command=COM_QUERY, thd=0x7ff18c324000, packet=0x7ff18c362001 "ALTER TABLE t1 ENGINE=InnoDB", packet_length=28) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_parse.cc:1332 #23 0x00000000007cb646 in do_command (thd=0x7ff18c324000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_parse.cc:1034 #24 0x0000000000793a61 in do_handle_one_connection (thd_arg=0x7ff18c324000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_connect.cc:982 #25 0x000000000079354a in handle_one_connection (arg=0x7ff18c324000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_connect.cc:898 #26 0x0000000000ad4b5c in pfs_spawn_thread (arg=0x7ff21bbfeb00) at /ssd/ramesh/mysql-server/mysql-5.6/storage/perfschema/pfs.cc:1860 #27 0x00007ff21f5dcdf3 in start_thread () from /lib64/libpthread.so.0 #28 0x00007ff21e4ae01d in clone () from /lib64/libc.so.6
[7 Sep 2015 6:33]
MySQL Verification Team
Bug #78331 marked as duplicate of this.
[7 Sep 2015 6:36]
MySQL Verification Team
-- only debug builds of 5.6.26, 5.6.27, 5.6.28, 5.7.8 and 5.7.9 are affected
[7 Sep 2015 6:36]
MySQL Verification Team
// 5.7.9 (gdb) bt #0 0x00007fedacf61771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000001834689 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-16387417-1441376695.03/mysqlcom-pro-5.7.9/mysys/stacktrace.c:247 #2 0x0000000000e74a84 in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-16387417-1441376695.03/mysqlcom-pro-5.7.9/sql/signal_handler.cc:220 #3 <signal handler called> #4 0x00007fedabb675c9 in raise () from /lib64/libc.so.6 #5 0x00007fedabb68cd8 in abort () from /lib64/libc.so.6 #6 0x0000000001a9387b in ut_dbg_assertion_failed (expr=0x2279bf8 "os_file_status(newpath, &exists, &type)", file=0x2278a88 "/export/home/pb2/build/sb_0-16387417-1441376695.03/mysqlcom-pro-5.7.9/storage/innobase/os/os0file.cc", line=3603) at /export/home/pb2/build/sb_0-16387417-1441376695.03/mysqlcom-pro-5.7.9/storage/innobase/ut/ut0dbg.cc:67 #7 0x0000000001928282 in os_file_rename_func (oldpath=0x7fed2c01f568 "./test/t1#P#p1#SP#p1spFirst.ibd", newpath=0x7fed2c04c098 "./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"...) at /export/home/pb2/build/sb_0-16387417-1441376695.03/mysqlcom-pro-5.7.9/storage/innobase/os/os0file.cc:3603 #8 0x0000000001b70324 in pfs_os_file_rename_func (key=33, oldpath=0x7fed2c01f568 "./test/t1#P#p1#SP#p1spFirst.ibd", newpath=0x7fed2c04c098 "./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"..., src_file=0x2300ad0 "/export/home/pb2/build/sb_0-16387417-1441376695.03/mysqlcom-pro-5.7.9/storage/innobase/fil/fil0fil.cc", src_line=3333) at /export/home/pb2/build/sb_0-16387417-1441376695.03/mysqlcom-pro-5.7.9/storage/innobase/include/os0file.ic:436 #9 0x0000000001b7975e in fil_rename_tablespace (id=28, old_path=0x7fed2c01f568 "./test/t1#P#p1#SP#p1spFirst.ibd", new_name=0x7fed7f988a60 "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@0"..., new_path_in=0x0) at /export/home/pb2/build/sb_0-16387417-1441376695.03/mysqlcom-pro-5.7.9/storage/innobase/fil/fil0fil.cc:3333 #10 0x0000000001b3b6e7 in dict_table_rename_in_cache (table=0x7fed2c01c220, new_name=0x7fed7f988a60 "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@0"..., rename_also_foreigns=1) at /export/home/pb2/build/sb_0-16387417-1441376695.03/mysqlcom-pro-5.7.9/storage/innobase/dict/dict0dict.cc:1790 #11 0x00000000019c10f3 in row_rename_table_for_mysql (old_name=0x7fed2c045858 "test/t1#P#p1#SP#p1spFirst", new_name=0x7fed7f988a60 "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@0"..., trx=0x7feda2aa2d08, commit=false) at /export/home/pb2/build/sb_0-16387417-1441376695.03/mysqlcom-pro-5.7.9/storage/innobase/row/row0mysql.cc:5446 #12 0x00000000019c1849 in row_rename_partitions_for_mysql (old_name=0x7fed7f9890f0 "test/t1", new_name=0x7fed7f9892f0 "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@0"..., trx=0x7feda2aa2d08) at /export/home/pb2/build/sb_0-16387417-1441376695.03/mysqlcom-pro-5.7.9/storage/innobase/row/row0mysql.cc:5583 #13 0x0000000001889b1c in innobase_rename_table (trx=0x7feda2aa2d08, from=0x7fed7f98a680 "./test/t1", to=0x7fed7f98a470 "./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"...) at /export/home/pb2/build/sb_0-16387417-1441376695.03/mysqlcom-pro-5.7.9/storage/innobase/handler/ha_innodb.cc:12477 #14 0x0000000001879719 in ha_innobase::rename_table (this=0x7fed2c006ce8, from=0x7fed7f98a680 "./test/t1", to=0x7fed7f98a470 "./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"...) at /export/home/pb2/build/sb_0-16387417-1441376695.03/mysqlcom-pro-5.7.9/storage/innobase/handler/ha_innodb.cc:12583 #15 0x0000000000ef12ed in handler::ha_rename_table (this=0x7fed2c006ce8, from=0x7fed7f98a680 "./test/t1", to=0x7fed7f98a470 "./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"...) at /export/home/pb2/build/sb_0-16387417-1441376695.03/mysqlcom-pro-5.7.9/sql/handler.cc:4709 #16 0x00000000015aa111 in mysql_rename_table (base=0x3010a00, old_db=0x7fed2c006558 "test", old_name=0x7fed2c005f38 "t1", new_db=0x7fed2c006b20 "test", new_name=0x7fed2c005f68 "new", '.' <repeats 46 times>, "end", flags=0) at /export/home/pb2/build/sb_0-16387417-1441376695.03/mysqlcom-pro-5.7.9/sql/sql_table.cc:5522 #17 0x000000000155eb78 in do_rename (thd=0x7fed2c000bc0, ren_table=0x7fed2c005fd0, new_db=0x7fed2c006b20 "test", new_table_name=0x7fed2c005f68 "new", '.' <repeats 46 times>, "end", new_table_alias=0x7fed2c006560 "new", '.' <repeats 46 times>, "end", skip_error=false) at /export/home/pb2/build/sb_0-16387417-1441376695.03/mysqlcom-pro-5.7.9/sql/sql_rename.cc:280 #18 0x000000000155ee1b in rename_tables (thd=0x7fed2c000bc0, table_list=0x7fed2c005fd0, skip_error=false) at /export/home/pb2/build/sb_0-16387417-1441376695.03/mysqlcom-pro-5.7.9/sql/sql_rename.cc:366 #19 0x000000000155e779 in mysql_rename_tables (thd=0x7fed2c000bc0, table_list=0x7fed2c005fd0, silent=false) at /export/home/pb2/build/sb_0-16387417-1441376695.03/mysqlcom-pro-5.7.9/sql/sql_rename.cc:151 #20 0x000000000151bdfe in mysql_execute_command (thd=0x7fed2c000bc0, first_level=true) at /export/home/pb2/build/sb_0-16387417-1441376695.03/mysqlcom-pro-5.7.9/sql/sql_parse.cc:3223 #21 0x0000000001522512 in mysql_parse (thd=0x7fed2c000bc0, parser_state=0x7fed7f98c6a0) at /export/home/pb2/build/sb_0-16387417-1441376695.03/mysqlcom-pro-5.7.9/sql/sql_parse.cc:5350 #22 0x0000000001517148 in dispatch_command (thd=0x7fed2c000bc0, com_data=0x7fed7f98ce10, command=COM_QUERY) at /export/home/pb2/build/sb_0-16387417-1441376695.03/mysqlcom-pro-5.7.9/sql/sql_parse.cc:1284 #23 0x0000000001516002 in do_command (thd=0x7fed2c000bc0) at /export/home/pb2/build/sb_0-16387417-1441376695.03/mysqlcom-pro-5.7.9/sql/sql_parse.cc:852 #24 0x00000000016463b3 in handle_connection (arg=0x3a7f7b0) at /export/home/pb2/build/sb_0-16387417-1441376695.03/mysqlcom-pro-5.7.9/sql/conn_handler/connection_handler_per_thread.cc:294 #25 0x0000000001c0a093 in pfs_spawn_thread (arg=0x3b8ba00) at /export/home/pb2/build/sb_0-16387417-1441376695.03/mysqlcom-pro-5.7.9/storage/perfschema/pfs.cc:2191 #26 0x00007fedacf5cdf3 in start_thread () from /lib64/libpthread.so.0 #27 0x00007fedabc2847d in clone () from /lib64/libc.so.6 (gdb)
[7 Sep 2015 7:01]
Ramesh Sivaraman
Bug#78331