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: | In progress | 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
[28 May 1:12]
MySQL Admin
Posted by developer: Bug status updated to 'In progress'
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.048 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.