MySQL Bugs: #84593: InnoDB: Failing assertion: fsp_flags_is

Bug #84593	InnoDB: Failing assertion: fsp_flags_is_valid(flags)
Submitted:	21 Jan 2017 1:11	Modified:	27 Jan 2017 5:33
Reporter:	Roel Van de Paar	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: DDL	Severity:	S3 (Non-critical)
Version:	5.7.17	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
Though it asserts in debug, this may or may not be a bug. Please check.

2017-01-21T00:49:48.499227Z 0 [Note] /sda/MS151116-mysql-5.7.16-linux-x86_64-debug/bin/mysqld: ready for connections.
Version: '5.7.16-debug'  socket: '/sda/MS151116-mysql-5.7.16-linux-x86_64-debug/socket.sock'  port: 19199  MySQL Community Server (GPL)
2017-01-21 11:49:50 0x7f2f6ea72700  InnoDB: Assertion failure in thread 139841696638720 in file fil0fil.cc line 3499
InnoDB: Failing assertion: fsp_flags_is_valid(flags)

61        val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid),
(gdb) bt
#0  0x00007f2f6e47f741 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  0x00007f2f6c8131d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5  0x00007f2f6c8148c8 in __GI_abort () at abort.c:90
#6  0x0000000001b8980f in ut_dbg_assertion_failed (expr=0x214351a "fsp_flags_is_valid(flags)", file=0x21436a0 "/git/mysql-server_dbg/storage/innobase/fil/fil0fil.cc", line=3499)
    at /git/mysql-server_dbg/storage/innobase/ut/ut0dbg.cc:67
#7  0x0000000001c701ec in fil_ibd_create (space_id=25, name=0x7f2f42031178 "test/t0", path=0x7f2f4202e3b8 "./test/t0.ibd", flags=18446744073709551615, size=4)
    at /git/mysql-server_dbg/storage/innobase/fil/fil0fil.cc:3499
#8  0x0000000001c2190c in dict_build_tablespace_for_table (table=0x7f2f42093320) at /git/mysql-server_dbg/storage/innobase/dict/dict0crea.cc:532
#9  0x0000000001c211fe in dict_build_table_def_step (thr=0x7f2f4210c318, node=0x7f2f42079ca0) at /git/mysql-server_dbg/storage/innobase/dict/dict0crea.cc:367
#10 0x0000000001c23cd9 in dict_create_table_step (thr=0x7f2f4210c318) at /git/mysql-server_dbg/storage/innobase/dict/dict0crea.cc:1453
#11 0x0000000001a5a23a in que_thr_step (thr=0x7f2f4210c318) at /git/mysql-server_dbg/storage/innobase/que/que0que.cc:1064
#12 0x0000000001a5a3cf in que_run_threads_low (thr=0x7f2f4210c318) at /git/mysql-server_dbg/storage/innobase/que/que0que.cc:1118
#13 0x0000000001a5a585 in que_run_threads (thr=0x7f2f4210c318) at /git/mysql-server_dbg/storage/innobase/que/que0que.cc:1158
#14 0x0000000001ab195d in row_create_table_for_mysql (table=0x7f2f42093320, compression=0x0, trx=0x7f2f5e400cf8, commit=false)
    at /git/mysql-server_dbg/storage/innobase/row/row0mysql.cc:3047
#15 0x0000000001975dbc in create_table_info_t::create_table_def (this=0x7f2f6ea6d610) at /git/mysql-server_dbg/storage/innobase/handler/ha_innodb.cc:10211
#16 0x0000000001962a74 in create_table_info_t::create_table (this=0x7f2f6ea6d610) at /git/mysql-server_dbg/storage/innobase/handler/ha_innodb.cc:11735
#17 0x0000000001963647 in ha_innobase::create (this=0x7f2f420ab430, name=0x7f2f6ea70120 "./test/t0", form=0x7f2f6ea6e3d0, create_info=0x7f2f6ea70a50)
    at /git/mysql-server_dbg/storage/innobase/handler/ha_innodb.cc:12083
#18 0x0000000000ef5888 in handler::ha_create (this=0x7f2f420ab430, name=0x7f2f6ea70120 "./test/t0", form=0x7f2f6ea6e3d0, info=0x7f2f6ea70a50)
    at /git/mysql-server_dbg/sql/handler.cc:4916
#19 0x0000000000ef5e86 in ha_create_table (thd=0x7f2f42019000, path=0x7f2f6ea70120 "./test/t0", db=0x7f2f4202c078 "test", table_name=0x7f2f4202bab8 "t0",
    create_info=0x7f2f6ea70a50, update_create_info=false, is_temp_table=false) at /git/mysql-server_dbg/sql/handler.cc:5075
#20 0x00000000015ff15a in rea_create_table (thd=0x7f2f42019000, path=0x7f2f6ea70120 "./test/t0", db=0x7f2f4202c078 "test", table_name=0x7f2f4202bab8 "t0",
    create_info=0x7f2f6ea70a50, create_fields=..., keys=1, key_info=0x7f2f4202cd78, file=0x7f2f42091030, no_ha_table=false) at /git/mysql-server_dbg/sql/unireg.cc:537
#21 0x000000000157f547 in create_table_impl (thd=0x7f2f42019000, db=0x7f2f4202c078 "test", table_name=0x7f2f4202bab8 "t0", path=0x7f2f6ea70120 "./test/t0",
    create_info=0x7f2f6ea70a50, alter_info=0x7f2f6ea704c0, internal_tmp_table=false, select_field_count=0, no_ha_table=false, is_trans=0x7f2f6ea703ae, key_info=0x7f2f6ea70330,
    key_count=0x7f2f6ea7032c) at /git/mysql-server_dbg/sql/sql_table.cc:5254
#22 0x000000000157fa9f in mysql_create_table_no_lock (thd=0x7f2f42019000, db=0x7f2f4202c078 "test", table_name=0x7f2f4202bab8 "t0", create_info=0x7f2f6ea70a50,
    alter_info=0x7f2f6ea704c0, select_field_count=0, is_trans=0x7f2f6ea703ae) at /git/mysql-server_dbg/sql/sql_table.cc:5382
#23 0x000000000157fb95 in mysql_create_table (thd=0x7f2f42019000, create_table=0x7f2f4202baf0, create_info=0x7f2f6ea70a50, alter_info=0x7f2f6ea704c0)
    at /git/mysql-server_dbg/sql/sql_table.cc:5428
#24 0x00000000014f306a in mysql_execute_command (thd=0x7f2f42019000, first_level=true) at /git/mysql-server_dbg/sql/sql_parse.cc:3199
#25 0x00000000014f97d5 in mysql_parse (thd=0x7f2f42019000, parser_state=0x7f2f6ea71560) at /git/mysql-server_dbg/sql/sql_parse.cc:5559
#26 0x00000000014eef69 in dispatch_command (thd=0x7f2f42019000, com_data=0x7f2f6ea71cb0, command=COM_QUERY) at /git/mysql-server_dbg/sql/sql_parse.cc:1427
#27 0x00000000014ede33 in do_command (thd=0x7f2f42019000) at /git/mysql-server_dbg/sql/sql_parse.cc:995
#28 0x000000000161d370 in handle_connection (arg=0x7f2f52fe9840) at /git/mysql-server_dbg/sql/conn_handler/connection_handler_per_thread.cc:300
#29 0x000000000184f79c in pfs_spawn_thread (arg=0x7f2f52e76020) at /git/mysql-server_dbg/storage/perfschema/pfs.cc:2188
#30 0x00007f2f6e47adc5 in start_thread (arg=0x7f2f6ea72700) at pthread_create.c:308
#31 0x00007f2f6c8d573d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

How to repeat:
DROP DATABASE test;CREATE DATABASE test;USE test;
INSTALL PLUGIN QUERY_RESPONSE_TIME SONAME 'query_responset.so';
SET SESSION debug="+d,dict_tf_to_fsp_flags_failure";
CREATE TABLE t0(hmid int unsigned,volid int unsigned,sampletid INT unsigned,sampletime DATE,samplevalue INT unsigned,KEY idx0(hmid,volid,sampletid,sampletime)) ENGINE=InnoDB;

See bug 73926

See bug 74873

Hello Roel,

Thank you for the bug report and test case.
Observed that 5.7.17 debug build is affected.

Thanks,
Umesh

SET SESSION debug="+d,dict_tf_to_fsp_flags_failure";

triggers the assert, and this is by design, according to the InnoDB devs. Closing as 'not a bug'.