Description:
Version: '5.7.16-debug' socket: '/sda/MS151116-mysql-5.7.16-linux-x86_64-debug/socket.sock' port: 19199 MySQL Community Server (GPL)
2016-12-06 13:23:32 0x7f1c17726700 InnoDB: Assertion failure in thread 139758629185280 in file btr0btr.cc line 1334
InnoDB: Failing assertion: max_trx_id != 0 || recovery
Core was generated by `/sda/MS151116-mysql-5.7.16-linux-x86_64-debug/bin/mysqld --no-defaults --core-f'.
Program terminated with signal 6, Aborted.
#0 0x00007f1c17132741 in __pthread_kill (threadid=<optimized out>, signo=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 0x00007f1c17132741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x0000000001822fb0 in my_write_core (sig=6) at /git/mysql-server_dbg/mysys/stacktrace.c:247
#2 0x0000000000e7457c in handle_fatal_signal (sig=6) at /git/mysql-server_dbg/sql/signal_handler.cc:220
#3 <signal handler called>
#4 0x00007f1c154c95f7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5 0x00007f1c154cace8 in __GI_abort () at abort.c:90
#6 0x0000000001b8980f in ut_dbg_assertion_failed (expr=0x2118e48 "max_trx_id != 0 || recovery", file=0x21184c8 "/git/mysql-server_dbg/storage/innobase/btr/btr0btr.cc",
line=1334) at /git/mysql-server_dbg/storage/innobase/ut/ut0dbg.cc:67
#7 0x0000000001ba089e in btr_page_reorganize_low (recovery=false, z_level=6, cursor=0x7f1c17721f58, index=0x7f1beb07c0a0, mtr=0x7f1c17722310)
at /git/mysql-server_dbg/storage/innobase/btr/btr0btr.cc:1334
#8 0x0000000001ba0f69 in btr_page_reorganize (cursor=0x7f1c17721f58, index=0x7f1beb07c0a0, mtr=0x7f1c17722310) at /git/mysql-server_dbg/storage/innobase/btr/btr0btr.cc:1500
#9 0x0000000001bbac14 in btr_cur_optimistic_insert (flags=0, cursor=0x7f1c17721f50, offsets=0x7f1c17722f90, heap=0x7f1c17721f10, entry=0x7f1beb07d360, rec=0x7f1c17722f88,
big_rec=0x7f1c17722f80, n_ext=0, thr=0x7f1beb14a890, mtr=0x7f1c17722310) at /git/mysql-server_dbg/storage/innobase/btr/btr0cur.cc:3193
#10 0x0000000001a8e41e in row_ins_sec_index_entry_low (flags=0, mode=2, index=0x7f1beb07c0a0, offsets_heap=0x7f1beb037a18, heap=0x7f1beb037f18, entry=0x7f1beb07d360, trx_id=0,
thr=0x7f1beb14a890, dup_chk_only=false) at /git/mysql-server_dbg/storage/innobase/row/row0ins.cc:3138
#11 0x0000000001a8eebf in row_ins_sec_index_entry (index=0x7f1beb07c0a0, entry=0x7f1beb07d360, thr=0x7f1beb14a890, dup_chk_only=false)
at /git/mysql-server_dbg/storage/innobase/row/row0ins.cc:3383
#12 0x0000000001a8f03b in row_ins_index_entry (index=0x7f1beb07c0a0, entry=0x7f1beb07d360, thr=0x7f1beb14a890) at /git/mysql-server_dbg/storage/innobase/row/row0ins.cc:3429
#13 0x0000000001a8f560 in row_ins_index_entry_step (node=0x7f1beb14a620, thr=0x7f1beb14a890) at /git/mysql-server_dbg/storage/innobase/row/row0ins.cc:3577
#14 0x0000000001a8f8ea in row_ins (node=0x7f1beb14a620, thr=0x7f1beb14a890) at /git/mysql-server_dbg/storage/innobase/row/row0ins.cc:3719
#15 0x0000000001a8ff0e in row_ins_step (thr=0x7f1beb14a890) at /git/mysql-server_dbg/storage/innobase/row/row0ins.cc:3904
#16 0x0000000001aae5c3 in row_insert_for_mysql_using_ins_graph (mysql_rec=0x7f1beb0aaf20 "\375\061", '\217' <repeats 14 times>, "@\257\n\353\033\177", prebuilt=0x7f1beb14a0a0)
at /git/mysql-server_dbg/storage/innobase/row/row0mysql.cc:1733
#17 0x0000000001aaeb30 in row_insert_for_mysql (mysql_rec=0x7f1beb0aaf20 "\375\061", '\217' <repeats 14 times>, "@\257\n\353\033\177", prebuilt=0x7f1beb14a0a0)
at /git/mysql-server_dbg/storage/innobase/row/row0mysql.cc:1855
#18 0x000000000195b588 in ha_innobase::write_row (this=0x7f1beb0aac30, record=0x7f1beb0aaf20 "\375\061", '\217' <repeats 14 times>, "@\257\n\353\033\177")
at /git/mysql-server_dbg/storage/innobase/handler/ha_innodb.cc:7489
#19 0x0000000000efbe6a in handler::ha_write_row (this=0x7f1beb0aac30, buf=0x7f1beb0aaf20 "\375\061", '\217' <repeats 14 times>, "@\257\n\353\033\177")
at /git/mysql-server_dbg/sql/handler.cc:7890
#20 0x0000000001715077 in write_record (thd=0x7f1beb019000, table=0x7f1beb05b020, info=0x7f1c177240a0, update=0x7f1c17724120) at /git/mysql-server_dbg/sql/sql_insert.cc:1860
#21 0x0000000001712344 in Sql_cmd_insert::mysql_insert (this=0x7f1beb02c3e0, thd=0x7f1beb019000, table_list=0x7f1beb02bd78) at /git/mysql-server_dbg/sql/sql_insert.cc:780
#22 0x0000000001718aca in Sql_cmd_insert::execute (this=0x7f1beb02c3e0, thd=0x7f1beb019000) at /git/mysql-server_dbg/sql/sql_insert.cc:3092
#23 0x00000000014f3f4a in mysql_execute_command (thd=0x7f1beb019000, first_level=true) at /git/mysql-server_dbg/sql/sql_parse.cc:3554
#24 0x00000000014f97d5 in mysql_parse (thd=0x7f1beb019000, parser_state=0x7f1c17725560) at /git/mysql-server_dbg/sql/sql_parse.cc:5559
#25 0x00000000014eef69 in dispatch_command (thd=0x7f1beb019000, com_data=0x7f1c17725cb0, command=COM_QUERY) at /git/mysql-server_dbg/sql/sql_parse.cc:1427
#26 0x00000000014ede33 in do_command (thd=0x7f1beb019000) at /git/mysql-server_dbg/sql/sql_parse.cc:995
#27 0x000000000161d370 in handle_connection (arg=0x7f1bfbbe9840) at /git/mysql-server_dbg/sql/conn_handler/connection_handler_per_thread.cc:300
#28 0x000000000184f79c in pfs_spawn_thread (arg=0x7f1bfba76020) at /git/mysql-server_dbg/storage/perfschema/pfs.cc:2188
#29 0x00007f1c1712ddc5 in start_thread (arg=0x7f1c17726700) at pthread_create.c:308
#30 0x00007f1c1558aced in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113
How to repeat:
DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t(a CHAR,FULLTEXT KEY(a)) ENGINE=INNODB;
SET DEBUG='+d,do_page_reorganize,do_lock_reverse_page_reorganize';
INSERT INTO t VALUES(COALESCE(1,UUID()));
Description: Version: '5.7.16-debug' socket: '/sda/MS151116-mysql-5.7.16-linux-x86_64-debug/socket.sock' port: 19199 MySQL Community Server (GPL) 2016-12-06 13:23:32 0x7f1c17726700 InnoDB: Assertion failure in thread 139758629185280 in file btr0btr.cc line 1334 InnoDB: Failing assertion: max_trx_id != 0 || recovery Core was generated by `/sda/MS151116-mysql-5.7.16-linux-x86_64-debug/bin/mysqld --no-defaults --core-f'. Program terminated with signal 6, Aborted. #0 0x00007f1c17132741 in __pthread_kill (threadid=<optimized out>, signo=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 0x00007f1c17132741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61 #1 0x0000000001822fb0 in my_write_core (sig=6) at /git/mysql-server_dbg/mysys/stacktrace.c:247 #2 0x0000000000e7457c in handle_fatal_signal (sig=6) at /git/mysql-server_dbg/sql/signal_handler.cc:220 #3 <signal handler called> #4 0x00007f1c154c95f7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56 #5 0x00007f1c154cace8 in __GI_abort () at abort.c:90 #6 0x0000000001b8980f in ut_dbg_assertion_failed (expr=0x2118e48 "max_trx_id != 0 || recovery", file=0x21184c8 "/git/mysql-server_dbg/storage/innobase/btr/btr0btr.cc", line=1334) at /git/mysql-server_dbg/storage/innobase/ut/ut0dbg.cc:67 #7 0x0000000001ba089e in btr_page_reorganize_low (recovery=false, z_level=6, cursor=0x7f1c17721f58, index=0x7f1beb07c0a0, mtr=0x7f1c17722310) at /git/mysql-server_dbg/storage/innobase/btr/btr0btr.cc:1334 #8 0x0000000001ba0f69 in btr_page_reorganize (cursor=0x7f1c17721f58, index=0x7f1beb07c0a0, mtr=0x7f1c17722310) at /git/mysql-server_dbg/storage/innobase/btr/btr0btr.cc:1500 #9 0x0000000001bbac14 in btr_cur_optimistic_insert (flags=0, cursor=0x7f1c17721f50, offsets=0x7f1c17722f90, heap=0x7f1c17721f10, entry=0x7f1beb07d360, rec=0x7f1c17722f88, big_rec=0x7f1c17722f80, n_ext=0, thr=0x7f1beb14a890, mtr=0x7f1c17722310) at /git/mysql-server_dbg/storage/innobase/btr/btr0cur.cc:3193 #10 0x0000000001a8e41e in row_ins_sec_index_entry_low (flags=0, mode=2, index=0x7f1beb07c0a0, offsets_heap=0x7f1beb037a18, heap=0x7f1beb037f18, entry=0x7f1beb07d360, trx_id=0, thr=0x7f1beb14a890, dup_chk_only=false) at /git/mysql-server_dbg/storage/innobase/row/row0ins.cc:3138 #11 0x0000000001a8eebf in row_ins_sec_index_entry (index=0x7f1beb07c0a0, entry=0x7f1beb07d360, thr=0x7f1beb14a890, dup_chk_only=false) at /git/mysql-server_dbg/storage/innobase/row/row0ins.cc:3383 #12 0x0000000001a8f03b in row_ins_index_entry (index=0x7f1beb07c0a0, entry=0x7f1beb07d360, thr=0x7f1beb14a890) at /git/mysql-server_dbg/storage/innobase/row/row0ins.cc:3429 #13 0x0000000001a8f560 in row_ins_index_entry_step (node=0x7f1beb14a620, thr=0x7f1beb14a890) at /git/mysql-server_dbg/storage/innobase/row/row0ins.cc:3577 #14 0x0000000001a8f8ea in row_ins (node=0x7f1beb14a620, thr=0x7f1beb14a890) at /git/mysql-server_dbg/storage/innobase/row/row0ins.cc:3719 #15 0x0000000001a8ff0e in row_ins_step (thr=0x7f1beb14a890) at /git/mysql-server_dbg/storage/innobase/row/row0ins.cc:3904 #16 0x0000000001aae5c3 in row_insert_for_mysql_using_ins_graph (mysql_rec=0x7f1beb0aaf20 "\375\061", '\217' <repeats 14 times>, "@\257\n\353\033\177", prebuilt=0x7f1beb14a0a0) at /git/mysql-server_dbg/storage/innobase/row/row0mysql.cc:1733 #17 0x0000000001aaeb30 in row_insert_for_mysql (mysql_rec=0x7f1beb0aaf20 "\375\061", '\217' <repeats 14 times>, "@\257\n\353\033\177", prebuilt=0x7f1beb14a0a0) at /git/mysql-server_dbg/storage/innobase/row/row0mysql.cc:1855 #18 0x000000000195b588 in ha_innobase::write_row (this=0x7f1beb0aac30, record=0x7f1beb0aaf20 "\375\061", '\217' <repeats 14 times>, "@\257\n\353\033\177") at /git/mysql-server_dbg/storage/innobase/handler/ha_innodb.cc:7489 #19 0x0000000000efbe6a in handler::ha_write_row (this=0x7f1beb0aac30, buf=0x7f1beb0aaf20 "\375\061", '\217' <repeats 14 times>, "@\257\n\353\033\177") at /git/mysql-server_dbg/sql/handler.cc:7890 #20 0x0000000001715077 in write_record (thd=0x7f1beb019000, table=0x7f1beb05b020, info=0x7f1c177240a0, update=0x7f1c17724120) at /git/mysql-server_dbg/sql/sql_insert.cc:1860 #21 0x0000000001712344 in Sql_cmd_insert::mysql_insert (this=0x7f1beb02c3e0, thd=0x7f1beb019000, table_list=0x7f1beb02bd78) at /git/mysql-server_dbg/sql/sql_insert.cc:780 #22 0x0000000001718aca in Sql_cmd_insert::execute (this=0x7f1beb02c3e0, thd=0x7f1beb019000) at /git/mysql-server_dbg/sql/sql_insert.cc:3092 #23 0x00000000014f3f4a in mysql_execute_command (thd=0x7f1beb019000, first_level=true) at /git/mysql-server_dbg/sql/sql_parse.cc:3554 #24 0x00000000014f97d5 in mysql_parse (thd=0x7f1beb019000, parser_state=0x7f1c17725560) at /git/mysql-server_dbg/sql/sql_parse.cc:5559 #25 0x00000000014eef69 in dispatch_command (thd=0x7f1beb019000, com_data=0x7f1c17725cb0, command=COM_QUERY) at /git/mysql-server_dbg/sql/sql_parse.cc:1427 #26 0x00000000014ede33 in do_command (thd=0x7f1beb019000) at /git/mysql-server_dbg/sql/sql_parse.cc:995 #27 0x000000000161d370 in handle_connection (arg=0x7f1bfbbe9840) at /git/mysql-server_dbg/sql/conn_handler/connection_handler_per_thread.cc:300 #28 0x000000000184f79c in pfs_spawn_thread (arg=0x7f1bfba76020) at /git/mysql-server_dbg/storage/perfschema/pfs.cc:2188 #29 0x00007f1c1712ddc5 in start_thread (arg=0x7f1c17726700) at pthread_create.c:308 #30 0x00007f1c1558aced in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113 How to repeat: DROP DATABASE test;CREATE DATABASE test;USE test; CREATE TABLE t(a CHAR,FULLTEXT KEY(a)) ENGINE=INNODB; SET DEBUG='+d,do_page_reorganize,do_lock_reverse_page_reorganize'; INSERT INTO t VALUES(COALESCE(1,UUID()));