Bug #74641 my_seek.c:57: my_seek: Assertion `fd != -1' failed. Table corruption on opt
| Submitted: | 31 Oct 2014 1:31 | Modified: | 31 Oct 2014 14:41 |
|---|---|---|---|
| Reporter: | Roel Van de Paar | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: DML | Severity: | S1 (Critical) |
| Version: | 5.6.20, 5.6.21 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | debug crash, opt | ||
[31 Oct 2014 1:31]
Roel Van de Paar
[31 Oct 2014 14:41]
MySQL Verification Team
Hello Roel, Thank you for the report and test case. Confirmed the issue on 5.6.21 debug build. Thanks, Umesh
[31 Oct 2014 14:41]
MySQL Verification Team
// 5.6.21 debug build
[root@cluster-repo mysql-5.6.21]# valgrind --track-origins=yes --track-fds=yes -v --show-reachable=yes --leak-check=full --num-callers=50 --db-attach=yes --tool=memcheck /data/ushastry/server/mysql-5.6.21/bin/mysqld-debug --no-defaults --basedir=/data/ushastry/server/mysql-5.6.21 --datadir=/tmp/bug --core-file --socket=/tmp/mysql.sock --port=3306 --log-error=/tmp/bug/log.err --user=root
[root@cluster-repo mysql-5.6.21]# bin/mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.21-debug MySQL Community Server - Debug (GPL)
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> DROP DATABASE test;CREATE DATABASE test;USE test;
Query OK, 0 rows affected (0.35 sec)
Query OK, 1 row affected (0.04 sec)
Database changed
mysql> SET storage_engine=archive;
Query OK, 0 rows affected, 1 warning (0.08 sec)
mysql> create table t1(a int)partition by hash (a) partitions 2;
Query OK, 0 rows affected (0.69 sec)
mysql> ALTER TABLE t1 ADD PARTITION PARTITIONS 600;
Query OK, 0 rows affected (10.40 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> alter table t1 ENGINE=INNODB;
ERROR 2013 (HY000): Lost connection to MySQL server during query
(gdb) bt
#0 0x0000000004e3b8ac in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000aaa203 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-13191046-1410443906.78/mysql-5.6.21/mysys/stacktrace.c:422
#2 0x00000000007140ea in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-13191046-1410443906.78/mysql-5.6.21/sql/signal_handler.cc:230
#3 <signal handler called>
#4 0x0000000005945625 in raise () from /lib64/libc.so.6
#5 0x0000000005946e05 in abort () from /lib64/libc.so.6
#6 0x000000000593e74e in __assert_fail_base () from /lib64/libc.so.6
#7 0x000000000593e810 in __assert_fail () from /lib64/libc.so.6
#8 0x0000000000aa6336 in my_seek (fd=-1, pos=0, whence=0, MyFlags=0) at /export/home/pb2/build/sb_0-13191046-1410443906.78/mysql-5.6.21/mysys/my_seek.c:57
#9 0x0000000000ac322f in azrewind (s=0x243dfb58) at /export/home/pb2/build/sb_0-13191046-1410443906.78/mysql-5.6.21/storage/archive/azio.c:673
#10 0x0000000000abf2e5 in ha_archive::read_data_header (this=0x243df910, file_to_read=0x243dfb58)
at /export/home/pb2/build/sb_0-13191046-1410443906.78/mysql-5.6.21/storage/archive/ha_archive.cc:403
#11 0x0000000000abf8b5 in ha_archive::rnd_init (this=0x243df910, scan=true) at /export/home/pb2/build/sb_0-13191046-1410443906.78/mysql-5.6.21/storage/archive/ha_archive.cc:1176
#12 0x0000000000618fd6 in handler::ha_rnd_init (this=0x243df910, scan=true) at /export/home/pb2/build/sb_0-13191046-1410443906.78/mysql-5.6.21/sql/handler.cc:2641
#13 0x0000000000e0ffde in ha_partition::rnd_next (this=0x19a0a710, buf=0x228894f0 "\377") at /export/home/pb2/build/sb_0-13191046-1410443906.78/mysql-5.6.21/sql/ha_partition.cc:4742
#14 0x00000000006188dc in handler::ha_rnd_next (this=0x19a0a710, buf=0x228894f0 "\377") at /export/home/pb2/build/sb_0-13191046-1410443906.78/mysql-5.6.21/sql/handler.cc:2687
#15 0x000000000097cf4a in rr_sequential (info=0x40afac0) at /export/home/pb2/build/sb_0-13191046-1410443906.78/mysql-5.6.21/sql/records.cc:478
#16 0x000000000082b048 in copy_data_between_tables (from=0x13ff7990, to=0x204c5eb0, create=..., ignore=false, order_num=0, order=0x0, copied=0x40b1360, deleted=0x40b1358,
keys_onoff=Alter_info::LEAVE_AS_IS, alter_ctx=0x40afd30) at /export/home/pb2/build/sb_0-13191046-1410443906.78/mysql-5.6.21/sql/sql_table.cc:8956
#17 0x0000000000837ded in mysql_alter_table (thd=0x19cade10, new_db=0x19cb66c0 "test", new_name=0x0, create_info=0x40b1bd0, table_list=0x19cb6160, alter_info=0x40b1cb0, order_num=0, order=0x0,
ignore=false) at /export/home/pb2/build/sb_0-13191046-1410443906.78/mysql-5.6.21/sql/sql_table.cc:8512
#18 0x0000000000989611 in Sql_cmd_alter_table::execute (this=0x19cb66d0, thd=0x19cade10) at /export/home/pb2/build/sb_0-13191046-1410443906.78/mysql-5.6.21/sql/sql_alter.cc:313
#19 0x00000000007ce4b7 in mysql_execute_command (thd=0x19cade10) at /export/home/pb2/build/sb_0-13191046-1410443906.78/mysql-5.6.21/sql/sql_parse.cc:4945
#20 0x00000000007cee85 in mysql_parse (thd=0x19cade10, rawbuf=0x19cb6070 "alter table t1 ENGINE=INNODB", length=28, parser_state=0x40b3680)
at /export/home/pb2/build/sb_0-13191046-1410443906.78/mysql-5.6.21/sql/sql_parse.cc:6245
#21 0x00000000007d0a2f in dispatch_command (command=COM_QUERY, thd=0x19cade10, packet=0x19985fd1 "alter table t1 ENGINE=INNODB", packet_length=28)
at /export/home/pb2/build/sb_0-13191046-1410443906.78/mysql-5.6.21/sql/sql_parse.cc:1332
#22 0x00000000007d2269 in do_command (thd=0x19cade10) at /export/home/pb2/build/sb_0-13191046-1410443906.78/mysql-5.6.21/sql/sql_parse.cc:1034
#23 0x0000000000788571 in do_handle_one_connection (thd_arg=0x19cade10) at /export/home/pb2/build/sb_0-13191046-1410443906.78/mysql-5.6.21/sql/sql_connect.cc:982
#24 0x0000000000788637 in handle_one_connection (arg=0x19cade10) at /export/home/pb2/build/sb_0-13191046-1410443906.78/mysql-5.6.21/sql/sql_connect.cc:898
#25 0x0000000000d9bbe2 in pfs_spawn_thread (arg=0x19cb1890) at /export/home/pb2/build/sb_0-13191046-1410443906.78/mysql-5.6.21/storage/perfschema/pfs.cc:1860
#26 0x0000000004e369d1 in start_thread () from /lib64/libpthread.so.0
#27 0x00000000059fb9dd in clone () from /lib64/libc.so.6
[31 Oct 2014 14:41]
MySQL Verification Team
// 5.6.21 optimized build [ushastry@cluster-repo mysql-5.6.21]$ valgrind --track-origins=yes --track-fds=yes -v --show-reachable=yes --leak-check=full --num-callers=50 --db-attach=yes --tool=memcheck /data/ushastry/server/mysql-5.6.21/bin/mysqld --no-defaults --basedir=/data/ushastry/server/mysql-5.6.21 --datadir=/tmp/bug --gdb --socket=/tmp/mysql.sock --port=3306 --log-error=/tmp/bug/log.err --user=root ==11993== Memcheck, a memory error detector [root@cluster-repo mysql-5.6.21]# bin/mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.21 MySQL Community Server (GPL) 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> DROP DATABASE test;CREATE DATABASE test;USE test; Query OK, 0 rows affected (0.20 sec) Query OK, 1 row affected (0.02 sec) Database changed mysql> SET storage_engine=archive; Query OK, 0 rows affected, 1 warning (0.05 sec) mysql> create table t1(a int)partition by hash (a) partitions 2; Query OK, 0 rows affected (0.41 sec) mysql> ALTER TABLE t1 ADD PARTITION PARTITIONS 600; Query OK, 0 rows affected (6.80 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> alter table t1 ENGINE=INNODB; ERROR 1194 (HY000): Table 't1' is marked as crashed and should be repaired mysql>
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.056 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.