Description:
171207 8:55:39 [Note] /sda/MS091117-mysql-5.5.58-linux-x86_64-debug/bin/mysqld: ready for connections.
Version: '5.5.58-debug' socket: '/sda/MS091117-mysql-5.5.58-linux-x86_64-debug/socket.sock' port: 18611 MySQL Community Server (GPL)
innodb_change_buffering_debug flush 0 54
innodb_change_buffering_debug evict 0 54
171207 8:56:08 InnoDB: Assertion failure in thread 140667592140544 in file ibuf0ibuf.c line 3701
InnoDB: Failing assertion: trx_sys_multiple_tablespace_format
InnoDB: We intentionally generate a memory trap.
Core was generated by `/sda/MS091117-mysql-5.5.58-linux-x86_64-debug/bin/mysqld --no-defaults --innodb'.
Program terminated with signal 6, Aborted.
#0 0x00007fefb97d19b1 in __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
61 val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid),
(gdb) bt
#0 0x00007fefb97d19b1 in __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x00000000007dffb8 in my_write_core (sig=6) at /git/mysql-server_dbg/mysys/stacktrace.c:433
#2 0x00000000006a2f16 in handle_fatal_signal (sig=6) at /git/mysql-server_dbg/sql/signal_handler.cc:247
#3 <signal handler called>
#4 0x00007fefb7f071f7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5 0x00007fefb7f088e8 in __GI_abort () at abort.c:90
#6 0x0000000000976c31 in ibuf_insert (op=op@entry=IBUF_OP_INSERT, entry=entry@entry=0x7fef970269a0,
index=index@entry=0x7fefb5c121f8, space=space@entry=0, zip_size=zip_size@entry=0, page_no=page_no@entry=54, thr=0x7fef97047d80)
at /git/mysql-server_dbg/storage/innobase/ibuf/ibuf0ibuf.c:3701
#7 0x00000000008eaf78 in btr_cur_search_to_nth_level (index=index@entry=0x7fefb5c121f8, level=level@entry=0,
tuple=tuple@entry=0x7fef970269a0, mode=mode@entry=4, latch_mode=2, latch_mode@entry=2562, cursor=cursor@entry=0x7fefb9dc1e50,
has_search_latch=has_search_latch@entry=0, file=file@entry=0xb37a88 "/git/mysql-server_dbg/storage/innobase/row/row0ins.c",
line=line@entry=2017, mtr=mtr@entry=0x7fefb9dc1960) at /git/mysql-server_dbg/storage/innobase/btr/btr0cur.c:615
#8 0x00000000009ddeed in row_ins_index_entry_low (mode=mode@entry=2, index=index@entry=0x7fefb5c121f8,
entry=entry@entry=0x7fef970269a0, n_ext=n_ext@entry=0, thr=thr@entry=0x7fef97047d80)
at /git/mysql-server_dbg/storage/innobase/row/row0ins.c:2015
#9 0x00000000009e2d72 in row_ins_index_entry (index=0x7fefb5c121f8, entry=<optimized out>, n_ext=n_ext@entry=0,
foreign=foreign@entry=1, thr=thr@entry=0x7fef97047d80) at /git/mysql-server_dbg/storage/innobase/row/row0ins.c:2261
#10 0x00000000009e3b0f in row_ins_index_entry_step (thr=0x7fef97047d80, node=0x7fef97026b68)
at /git/mysql-server_dbg/storage/innobase/row/row0ins.c:2349
#11 row_ins (thr=<optimized out>, node=<optimized out>) at /git/mysql-server_dbg/storage/innobase/row/row0ins.c:2481
#12 row_ins_step (thr=thr@entry=0x7fef97047d80) at /git/mysql-server_dbg/storage/innobase/row/row0ins.c:2598
#13 0x00000000009ce632 in que_thr_step (thr=0x7fef97047d80) at /git/mysql-server_dbg/storage/innobase/que/que0que.c:1224
#14 que_run_threads_low (thr=0x7fef97047d80) at /git/mysql-server_dbg/storage/innobase/que/que0que.c:1305
#15 que_run_threads (thr=thr@entry=0x7fef97047d80) at /git/mysql-server_dbg/storage/innobase/que/que0que.c:1342
#16 0x000000000087a0d5 in row_create_table_for_mysql (table=0x7fef970260f8, trx=0x7fef97046a78)
at /git/mysql-server_dbg/storage/innobase/row/row0mysql.c:1971
#17 0x000000000085d8dd in create_table_def (flags=65, path_of_temp_table=<optimized out>,
table_name=0x7fefb9dc24c0 "data/#sql31cb_2_0", form=<optimized out>, trx=0x7fef97046a78)
at /git/mysql-server_dbg/storage/innobase/handler/ha_innodb.cc:6659
#18 ha_innobase::create (this=<optimized out>, name=<optimized out>, form=<optimized out>, create_info=0x7fefb9dc4db0)
at /git/mysql-server_dbg/storage/innobase/handler/ha_innodb.cc:7262
#19 0x00000000006a9ba7 in handler::ha_create (this=0x7fef97044010,
name=0x7fefb9dc3920 "/sda/MS091117-mysql-5.5.58-linux-x86_64-debug/data/#sql31cb_2_0", form=form@entry=0x7fefb9dc2cb0,
info=info@entry=0x7fefb9dc4db0) at /git/mysql-server_dbg/sql/handler.cc:3616
#20 0x00000000006a9fe0 in ha_create_table (thd=thd@entry=0x7fefaa770000,
path=path@entry=0x7fefb9dc3920 "/sda/MS091117-mysql-5.5.58-linux-x86_64-debug/data/#sql31cb_2_0",
db=db@entry=0x7fef9701f690 "test", table_name=table_name@entry=0x7fef9701f110 "tmptbl504451f4258$1",
create_info=create_info@entry=0x7fefb9dc4db0, update_create_info=update_create_info@entry=false)
at /git/mysql-server_dbg/sql/handler.cc:3823
#21 0x000000000062596f in rea_create_table (thd=thd@entry=0x7fefaa770000,
path=path@entry=0x7fefb9dc3920 "/sda/MS091117-mysql-5.5.58-linux-x86_64-debug/data/#sql31cb_2_0",
db=db@entry=0x7fef9701f690 "test", table_name=table_name@entry=0x7fef9701f110 "tmptbl504451f4258$1",
create_info=create_info@entry=0x7fefb9dc4db0, create_fields=..., keys=0, key_info=0x7fef9701f860,
file=file@entry=0x7fef9702e010) at /git/mysql-server_dbg/sql/unireg.cc:531
#22 0x00000000005f72de in mysql_create_table_no_lock (thd=thd@entry=0x7fefaa770000, db=0x7fef9701f690 "test",
table_name=0x7fef9701f110 "tmptbl504451f4258$1", create_info=create_info@entry=0x7fefb9dc4db0,
alter_info=alter_info@entry=0x7fefb9dc4880, internal_tmp_table=internal_tmp_table@entry=false,
select_field_count=select_field_count@entry=0, is_trans=is_trans@entry=0x7fefb9dc478f)
at /git/mysql-server_dbg/sql/sql_table.cc:4377
#23 0x00000000005f7809 in mysql_create_table (thd=thd@entry=0x7fefaa770000, create_table=create_table@entry=0x7fef9701f168,
create_info=create_info@entry=0x7fefb9dc4db0, alter_info=alter_info@entry=0x7fefb9dc4880)
at /git/mysql-server_dbg/sql/sql_table.cc:4471
#24 0x000000000058d80b in mysql_execute_command (thd=thd@entry=0x7fefaa770000) at /git/mysql-server_dbg/sql/sql_parse.cc:2635
#25 0x00000000005940f6 in mysql_parse (thd=thd@entry=0x7fefaa770000, rawbuf=<optimized out>, length=64,
parser_state=parser_state@entry=0x7fefb9dc5580) at /git/mysql-server_dbg/sql/sql_parse.cc:5831
#26 0x00000000005959f5 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fefaa770000,
packet=packet@entry=0x7fefaa7c8001 "CREATE TEMPORARY TABLE tmptbl504451f4258$1(id INT)ENGINE=RocksDB",
packet_length=packet_length@entry=64) at /git/mysql-server_dbg/sql/sql_parse.cc:1075
#27 0x0000000000597836 in do_command (thd=0x7fefaa770000) at /git/mysql-server_dbg/sql/sql_parse.cc:776
#28 0x000000000063fd82 in do_handle_one_connection (thd_arg=thd_arg@entry=0x7fefaa770000)
at /git/mysql-server_dbg/sql/sql_connect.cc:870
#29 0x000000000063fe3f in handle_one_connection (arg=0x7fefaa770000) at /git/mysql-server_dbg/sql/sql_connect.cc:789
#30 0x00007fefb97cce25 in start_thread (arg=0x7fefb9dc6700) at pthread_create.c:308
#31 0x00007fefb7fca34d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113
How to repeat:
# mysqld options required for replay: --innodb-force-recovery=24
USE test;
SET GLOBAL innodb_limit_optimistic_insert_debug=2;
SET GLOBAL innodb_change_buffering_debug=1;
CREATE TABLE t1(a INT)ENGINE=InnoDB;
SET UNIQUE_CHECKS=0;
CREATE TEMPORARY TABLE tmptbl504451f4258$1(id INT)ENGINE=RocksDB;
Description: 171207 8:55:39 [Note] /sda/MS091117-mysql-5.5.58-linux-x86_64-debug/bin/mysqld: ready for connections. Version: '5.5.58-debug' socket: '/sda/MS091117-mysql-5.5.58-linux-x86_64-debug/socket.sock' port: 18611 MySQL Community Server (GPL) innodb_change_buffering_debug flush 0 54 innodb_change_buffering_debug evict 0 54 171207 8:56:08 InnoDB: Assertion failure in thread 140667592140544 in file ibuf0ibuf.c line 3701 InnoDB: Failing assertion: trx_sys_multiple_tablespace_format InnoDB: We intentionally generate a memory trap. Core was generated by `/sda/MS091117-mysql-5.5.58-linux-x86_64-debug/bin/mysqld --no-defaults --innodb'. Program terminated with signal 6, Aborted. #0 0x00007fefb97d19b1 in __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61 61 val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid), (gdb) bt #0 0x00007fefb97d19b1 in __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61 #1 0x00000000007dffb8 in my_write_core (sig=6) at /git/mysql-server_dbg/mysys/stacktrace.c:433 #2 0x00000000006a2f16 in handle_fatal_signal (sig=6) at /git/mysql-server_dbg/sql/signal_handler.cc:247 #3 <signal handler called> #4 0x00007fefb7f071f7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56 #5 0x00007fefb7f088e8 in __GI_abort () at abort.c:90 #6 0x0000000000976c31 in ibuf_insert (op=op@entry=IBUF_OP_INSERT, entry=entry@entry=0x7fef970269a0, index=index@entry=0x7fefb5c121f8, space=space@entry=0, zip_size=zip_size@entry=0, page_no=page_no@entry=54, thr=0x7fef97047d80) at /git/mysql-server_dbg/storage/innobase/ibuf/ibuf0ibuf.c:3701 #7 0x00000000008eaf78 in btr_cur_search_to_nth_level (index=index@entry=0x7fefb5c121f8, level=level@entry=0, tuple=tuple@entry=0x7fef970269a0, mode=mode@entry=4, latch_mode=2, latch_mode@entry=2562, cursor=cursor@entry=0x7fefb9dc1e50, has_search_latch=has_search_latch@entry=0, file=file@entry=0xb37a88 "/git/mysql-server_dbg/storage/innobase/row/row0ins.c", line=line@entry=2017, mtr=mtr@entry=0x7fefb9dc1960) at /git/mysql-server_dbg/storage/innobase/btr/btr0cur.c:615 #8 0x00000000009ddeed in row_ins_index_entry_low (mode=mode@entry=2, index=index@entry=0x7fefb5c121f8, entry=entry@entry=0x7fef970269a0, n_ext=n_ext@entry=0, thr=thr@entry=0x7fef97047d80) at /git/mysql-server_dbg/storage/innobase/row/row0ins.c:2015 #9 0x00000000009e2d72 in row_ins_index_entry (index=0x7fefb5c121f8, entry=<optimized out>, n_ext=n_ext@entry=0, foreign=foreign@entry=1, thr=thr@entry=0x7fef97047d80) at /git/mysql-server_dbg/storage/innobase/row/row0ins.c:2261 #10 0x00000000009e3b0f in row_ins_index_entry_step (thr=0x7fef97047d80, node=0x7fef97026b68) at /git/mysql-server_dbg/storage/innobase/row/row0ins.c:2349 #11 row_ins (thr=<optimized out>, node=<optimized out>) at /git/mysql-server_dbg/storage/innobase/row/row0ins.c:2481 #12 row_ins_step (thr=thr@entry=0x7fef97047d80) at /git/mysql-server_dbg/storage/innobase/row/row0ins.c:2598 #13 0x00000000009ce632 in que_thr_step (thr=0x7fef97047d80) at /git/mysql-server_dbg/storage/innobase/que/que0que.c:1224 #14 que_run_threads_low (thr=0x7fef97047d80) at /git/mysql-server_dbg/storage/innobase/que/que0que.c:1305 #15 que_run_threads (thr=thr@entry=0x7fef97047d80) at /git/mysql-server_dbg/storage/innobase/que/que0que.c:1342 #16 0x000000000087a0d5 in row_create_table_for_mysql (table=0x7fef970260f8, trx=0x7fef97046a78) at /git/mysql-server_dbg/storage/innobase/row/row0mysql.c:1971 #17 0x000000000085d8dd in create_table_def (flags=65, path_of_temp_table=<optimized out>, table_name=0x7fefb9dc24c0 "data/#sql31cb_2_0", form=<optimized out>, trx=0x7fef97046a78) at /git/mysql-server_dbg/storage/innobase/handler/ha_innodb.cc:6659 #18 ha_innobase::create (this=<optimized out>, name=<optimized out>, form=<optimized out>, create_info=0x7fefb9dc4db0) at /git/mysql-server_dbg/storage/innobase/handler/ha_innodb.cc:7262 #19 0x00000000006a9ba7 in handler::ha_create (this=0x7fef97044010, name=0x7fefb9dc3920 "/sda/MS091117-mysql-5.5.58-linux-x86_64-debug/data/#sql31cb_2_0", form=form@entry=0x7fefb9dc2cb0, info=info@entry=0x7fefb9dc4db0) at /git/mysql-server_dbg/sql/handler.cc:3616 #20 0x00000000006a9fe0 in ha_create_table (thd=thd@entry=0x7fefaa770000, path=path@entry=0x7fefb9dc3920 "/sda/MS091117-mysql-5.5.58-linux-x86_64-debug/data/#sql31cb_2_0", db=db@entry=0x7fef9701f690 "test", table_name=table_name@entry=0x7fef9701f110 "tmptbl504451f4258$1", create_info=create_info@entry=0x7fefb9dc4db0, update_create_info=update_create_info@entry=false) at /git/mysql-server_dbg/sql/handler.cc:3823 #21 0x000000000062596f in rea_create_table (thd=thd@entry=0x7fefaa770000, path=path@entry=0x7fefb9dc3920 "/sda/MS091117-mysql-5.5.58-linux-x86_64-debug/data/#sql31cb_2_0", db=db@entry=0x7fef9701f690 "test", table_name=table_name@entry=0x7fef9701f110 "tmptbl504451f4258$1", create_info=create_info@entry=0x7fefb9dc4db0, create_fields=..., keys=0, key_info=0x7fef9701f860, file=file@entry=0x7fef9702e010) at /git/mysql-server_dbg/sql/unireg.cc:531 #22 0x00000000005f72de in mysql_create_table_no_lock (thd=thd@entry=0x7fefaa770000, db=0x7fef9701f690 "test", table_name=0x7fef9701f110 "tmptbl504451f4258$1", create_info=create_info@entry=0x7fefb9dc4db0, alter_info=alter_info@entry=0x7fefb9dc4880, internal_tmp_table=internal_tmp_table@entry=false, select_field_count=select_field_count@entry=0, is_trans=is_trans@entry=0x7fefb9dc478f) at /git/mysql-server_dbg/sql/sql_table.cc:4377 #23 0x00000000005f7809 in mysql_create_table (thd=thd@entry=0x7fefaa770000, create_table=create_table@entry=0x7fef9701f168, create_info=create_info@entry=0x7fefb9dc4db0, alter_info=alter_info@entry=0x7fefb9dc4880) at /git/mysql-server_dbg/sql/sql_table.cc:4471 #24 0x000000000058d80b in mysql_execute_command (thd=thd@entry=0x7fefaa770000) at /git/mysql-server_dbg/sql/sql_parse.cc:2635 #25 0x00000000005940f6 in mysql_parse (thd=thd@entry=0x7fefaa770000, rawbuf=<optimized out>, length=64, parser_state=parser_state@entry=0x7fefb9dc5580) at /git/mysql-server_dbg/sql/sql_parse.cc:5831 #26 0x00000000005959f5 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fefaa770000, packet=packet@entry=0x7fefaa7c8001 "CREATE TEMPORARY TABLE tmptbl504451f4258$1(id INT)ENGINE=RocksDB", packet_length=packet_length@entry=64) at /git/mysql-server_dbg/sql/sql_parse.cc:1075 #27 0x0000000000597836 in do_command (thd=0x7fefaa770000) at /git/mysql-server_dbg/sql/sql_parse.cc:776 #28 0x000000000063fd82 in do_handle_one_connection (thd_arg=thd_arg@entry=0x7fefaa770000) at /git/mysql-server_dbg/sql/sql_connect.cc:870 #29 0x000000000063fe3f in handle_one_connection (arg=0x7fefaa770000) at /git/mysql-server_dbg/sql/sql_connect.cc:789 #30 0x00007fefb97cce25 in start_thread (arg=0x7fefb9dc6700) at pthread_create.c:308 #31 0x00007fefb7fca34d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113 How to repeat: # mysqld options required for replay: --innodb-force-recovery=24 USE test; SET GLOBAL innodb_limit_optimistic_insert_debug=2; SET GLOBAL innodb_change_buffering_debug=1; CREATE TABLE t1(a INT)ENGINE=InnoDB; SET UNIQUE_CHECKS=0; CREATE TEMPORARY TABLE tmptbl504451f4258$1(id INT)ENGINE=RocksDB;