Bug #73926 Failing assertion: fsp_flags_is_valid(fsp_flags) in file dict0dict.ic line 786
Submitted: 16 Sep 2014 10:03 Modified: 21 Jan 2017 1:15
Reporter: Roel Van de Paar Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:5.6.20 to 5.6.34, 5.7.16 OS:Any
Assigned to: CPU Architecture:Any

[16 Sep 2014 10:03] Roel Van de Paar
Description:
2014-09-17 05:58:04 6054 [Note] /sda/mysql-5.6.20-linux-glibc2.5-x86_64/bin/mysqld: ready for connections.
Version: '5.6.20-debug'  socket: '/sda/mysql-5.6.20-linux-glibc2.5-x86_64/socket.sock'  port: 10920  MySQL Community Server - Debug (GPL)
2014-09-17 05:58:20 7f0d570d3700  InnoDB: Assertion failure in thread 139695271786240 in file dict0dict.ic line 786

How to repeat:
DROP DATABASE test;CREATE DATABASE test;USE test;
SET SESSION debug="+d,fsp_flags_is_valid_failure";
create table t0(id INT,x INT)engine=INNODB;
[16 Sep 2014 10:22] MySQL Verification Team
Hello Roel,

Thank you for the bug report and test case.
5.6.20 debug builds seems to be affected, this is
reproducible with debug builds only.

Thanks,
Umesh
[16 Sep 2014 10:23] MySQL Verification Team
// Only debug builds asserting

[root@cluster-repo mysql-advanced-5.6.20]# /data/ushastry/server/mysql-advanced-5.6.22/bin/mysql -u root -p -S /tmp/73913/socket.sock
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.20-enterprise-commercial-advanced-debug MySQL Enterprise Server - Advanced Edition Debug (Commercial)

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, 1 row affected (0.05 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
mysql> SET SESSION debug="+d,fsp_flags_is_valid_failure";
Query OK, 0 rows affected (0.00 sec)

mysql> create table t0(id INT,x INT)engine=INNODB;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> \q

2014-09-18 06:40:38 7f74980c8700  InnoDB: Assertion failure in thread 140138743891712 in file dict0dict.ic line 786
InnoDB: Failing assertion: fsp_flags_is_valid(fsp_flags)
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
01:10:38 UTC - mysqld got signal 6 ;

(gdb) bt
#0  0x0000003b3ba0c8ac in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000000af33ce in my_write_core (sig=6) at /pb2/build/sb_0-12284633-1401293889.47/mysqlcom-pro-5.6.20/mysys/stacktrace.c:422
#2  0x0000000000776863 in handle_fatal_signal (sig=6) at /pb2/build/sb_0-12284633-1401293889.47/mysqlcom-pro-5.6.20/sql/signal_handler.cc:248
#3  <signal handler called>
#4  0x0000003b3b632925 in raise () from /lib64/libc.so.6
#5  0x0000003b3b634105 in abort () from /lib64/libc.so.6
#6  0x0000000000dc3268 in dict_tf_to_fsp_flags (table_flags=1) at /pb2/build/sb_0-12284633-1401293889.47/mysqlcom-pro-5.6.20/storage/innobase/include/dict0dict.ic:786
#7  0x0000000000dc56b6 in dict_build_table_def_step (thr=0x7f73c4061a60, node=0x7f73c4061398)
    at /pb2/build/sb_0-12284633-1401293889.47/mysqlcom-pro-5.6.20/storage/innobase/dict/dict0crea.cc:312
#8  0x0000000000dc6df3 in dict_create_table_step (thr=0x7f73c4061a60) at /pb2/build/sb_0-12284633-1401293889.47/mysqlcom-pro-5.6.20/storage/innobase/dict/dict0crea.cc:1044
#9  0x0000000000c7fbce in que_thr_step (thr=0x7f73c4061a60) at /pb2/build/sb_0-12284633-1401293889.47/mysqlcom-pro-5.6.20/storage/innobase/que/que0que.cc:1113
#10 0x0000000000c7fd89 in que_run_threads_low (thr=0x7f73c4061a60) at /pb2/build/sb_0-12284633-1401293889.47/mysqlcom-pro-5.6.20/storage/innobase/que/que0que.cc:1167
#11 0x0000000000c7ff53 in que_run_threads (thr=0x7f73c4061a60) at /pb2/build/sb_0-12284633-1401293889.47/mysqlcom-pro-5.6.20/storage/innobase/que/que0que.cc:1208
#12 0x0000000000cc3f75 in row_create_table_for_mysql (table=0x7f73c40606c8, trx=0x7f73c40116b8, commit=false)
    at /pb2/build/sb_0-12284633-1401293889.47/mysqlcom-pro-5.6.20/storage/innobase/row/row0mysql.cc:2252
#13 0x0000000000bd3d7f in create_table_def (trx=0x7f73c40116b8, form=0x7f74980c3d20, table_name=0x7f74980c39e0 "test/t0", temp_path=0x7f74980c37e0 "", remote_path=0x7f74980c35e0 "", flags=1,
    flags2=80) at /pb2/build/sb_0-12284633-1401293889.47/mysqlcom-pro-5.6.20/storage/innobase/handler/ha_innodb.cc:8653
#14 0x0000000000bd5774 in ha_innobase::create (this=0x7f73c405eb40, name=0x7f74980c5dc0 "./test/t0", form=0x7f74980c3d20, create_info=0x7f74980c6670)
    at /pb2/build/sb_0-12284633-1401293889.47/mysqlcom-pro-5.6.20/storage/innobase/handler/ha_innodb.cc:9561
#15 0x000000000068c09c in handler::ha_create (this=0x7f73c405eb40, name=0x7f74980c5dc0 "./test/t0", form=0x7f74980c3d20, info=0x7f74980c6670)
    at /pb2/build/sb_0-12284633-1401293889.47/mysqlcom-pro-5.6.20/sql/handler.cc:4524
#16 0x000000000068c981 in ha_create_table (thd=0x9500f80, path=0x7f74980c5dc0 "./test/t0", db=0x7f73c4005638 "test", table_name=0x7f73c40050a0 "t0", create_info=0x7f74980c6670,
    update_create_info=false, is_temp_table=false) at /pb2/build/sb_0-12284633-1401293889.47/mysqlcom-pro-5.6.20/sql/handler.cc:4762
#17 0x00000000008fbff8 in rea_create_table (thd=0x9500f80, path=0x7f74980c5dc0 "./test/t0", db=0x7f73c4005638 "test", table_name=0x7f73c40050a0 "t0", create_info=0x7f74980c6670,
    create_fields=..., keys=0, key_info=0x7f73c4005ae0, file=0x7f73c400f270, no_ha_table=false) at /pb2/build/sb_0-12284633-1401293889.47/mysqlcom-pro-5.6.20/sql/unireg.cc:526
#18 0x0000000000891cfb in create_table_impl (thd=0x9500f80, db=0x7f73c4005638 "test", table_name=0x7f73c40050a0 "t0", path=0x7f74980c5dc0 "./test/t0", create_info=0x7f74980c6670,
    alter_info=0x7f74980c60c0, internal_tmp_table=false, select_field_count=0, no_ha_table=false, is_trans=0x7f74980c605e, key_info=0x7f74980c5fc8, key_count=0x7f74980c5fc4)
    at /pb2/build/sb_0-12284633-1401293889.47/mysqlcom-pro-5.6.20/sql/sql_table.cc:4841
#19 0x00000000008921c2 in mysql_create_table_no_lock (thd=0x9500f80, db=0x7f73c4005638 "test", table_name=0x7f73c40050a0 "t0", create_info=0x7f74980c6670, alter_info=0x7f74980c60c0,
    select_field_count=0, is_trans=0x7f74980c605e) at /pb2/build/sb_0-12284633-1401293889.47/mysqlcom-pro-5.6.20/sql/sql_table.cc:4953
#20 0x00000000008922d0 in mysql_create_table (thd=0x9500f80, create_table=0x7f73c40050d8, create_info=0x7f74980c6670, alter_info=0x7f74980c60c0)
    at /pb2/build/sb_0-12284633-1401293889.47/mysqlcom-pro-5.6.20/sql/sql_table.cc:5002
#21 0x0000000000825fb7 in mysql_execute_command (thd=0x9500f80) at /pb2/build/sb_0-12284633-1401293889.47/mysqlcom-pro-5.6.20/sql/sql_parse.cc:3061
#22 0x000000000082ee42 in mysql_parse (thd=0x9500f80, rawbuf=0x7f73c4004fd0 "create table t0(id INT,x INT)engine=INNODB", length=42, parser_state=0x7f74980c7680)
    at /pb2/build/sb_0-12284633-1401293889.47/mysqlcom-pro-5.6.20/sql/sql_parse.cc:6245
#23 0x0000000000821f35 in dispatch_command (command=COM_QUERY, thd=0x9500f80, packet=0x9630181 "create table t0(id INT,x INT)engine=INNODB", packet_length=42)
    at /pb2/build/sb_0-12284633-1401293889.47/mysqlcom-pro-5.6.20/sql/sql_parse.cc:1332
#24 0x000000000082106b in do_command (thd=0x9500f80) at /pb2/build/sb_0-12284633-1401293889.47/mysqlcom-pro-5.6.20/sql/sql_parse.cc:1034
#25 0x00000000007e8328 in do_handle_one_connection (thd_arg=0x9500f80) at /pb2/build/sb_0-12284633-1401293889.47/mysqlcom-pro-5.6.20/sql/sql_connect.cc:982
#26 0x00000000007e7e30 in handle_one_connection (arg=0x9500f80) at /pb2/build/sb_0-12284633-1401293889.47/mysqlcom-pro-5.6.20/sql/sql_connect.cc:898
#27 0x0000000000ba5c95 in pfs_spawn_thread (arg=0x9611dc0) at /pb2/build/sb_0-12284633-1401293889.47/mysqlcom-pro-5.6.20/storage/perfschema/pfs.cc:1860
#28 0x0000003b3ba079d1 in start_thread () from /lib64/libpthread.so.0
#29 0x0000003b3b6e8b5d in clone () from /lib64/libc.so.6
[16 Sep 2014 10:30] MySQL Verification Team
// 5.6.22 release build

[root@cluster-repo mysql-advanced-5.6.22]# /data/ushastry/server/mysql-advanced-5.6.22/bin/mysql -u root -p -S /tmp/73926/socket.sock
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.22-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)

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.00 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
mysql> SET SESSION debug="+d,fsp_flags_is_valid_failure";
ERROR 1193 (HY000): Unknown system variable 'debug'
mysql> create table t0(id INT,x INT)engine=INNODB;
Query OK, 0 rows affected (0.03 sec)

// Debug build

[root@cluster-repo mysql-advanced-5.6.22]# /data/ushastry/server/mysql-advanced-5.6.22/bin/mysql -u root -p -S /tmp/73926/socket.sock
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.22-enterprise-commercial-advanced-debug MySQL Enterprise Server - Advanced Edition Debug (Commercial)

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, 1 row affected (0.06 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
mysql> SET SESSION debug="+d,fsp_flags_is_valid_failure";
Query OK, 0 rows affected (0.00 sec)

mysql> create table t0(id INT,x INT)engine=INNODB;
ERROR 2013 (HY000): Lost connection to MySQL server during query
[16 Sep 2014 10:31] MySQL Verification Team
// 5.6.22

Version: '5.6.22-enterprise-commercial-advanced-debug'  socket: '/tmp/73926/socket.sock'  port: 73926  MySQL Enterprise Server - Advanced Edition Debug (Commercial)
2014-09-18 06:57:14 7fa96f7aa700  InnoDB: Assertion failure in thread 140365696509696 in file dict0dict.ic line 786
InnoDB: Failing assertion: fsp_flags_is_valid(fsp_flags)
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
01:27:14 UTC - mysqld got signal 6 ;

(gdb) bt
#0  0x0000003b3ba0c8ac in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000000afe982 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/mysys/stacktrace.c:422
#2  0x000000000077e6cc in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/signal_handler.cc:230
#3  <signal handler called>
#4  0x0000003b3b632925 in raise () from /lib64/libc.so.6
#5  0x0000003b3b634105 in abort () from /lib64/libc.so.6
#6  0x0000000000d8fcb0 in dict_tf_to_fsp_flags (table_flags=1) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/include/dict0dict.ic:786
#7  0x0000000000d91efe in dict_build_table_def_step (thr=0x7fa94405d680, node=0x7fa944011658)
    at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/dict/dict0crea.cc:312
#8  0x0000000000d9363b in dict_create_table_step (thr=0x7fa94405d680) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/dict/dict0crea.cc:1044
#9  0x0000000000c4a726 in que_thr_step (thr=0x7fa94405d680) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/que/que0que.cc:1113
#10 0x0000000000c4a8e1 in que_run_threads_low (thr=0x7fa94405d680) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/que/que0que.cc:1167
#11 0x0000000000c4aaab in que_run_threads (thr=0x7fa94405d680) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/que/que0que.cc:1208
#12 0x0000000000c8efd4 in row_create_table_for_mysql (table=0x7fa944010918, trx=0x7fa94400fed8, commit=false)
    at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/row/row0mysql.cc:2310
#13 0x0000000000b9df3f in create_table_def (trx=0x7fa94400fed8, form=0x7fa96f7a5d10, table_name=0x7fa96f7a59d0 "test/t0", temp_path=0x7fa96f7a57d0 "", remote_path=0x7fa96f7a55d0 "", flags=1,
    flags2=80) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/handler/ha_innodb.cc:8664
#14 0x0000000000b9f934 in ha_innobase::create (this=0x7fa9440627a0, name=0x7fa96f7a7db0 "./test/t0", form=0x7fa96f7a5d10, create_info=0x7fa96f7a8660)
    at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/innobase/handler/ha_innodb.cc:9572
#15 0x000000000069387c in handler::ha_create (this=0x7fa9440627a0, name=0x7fa96f7a7db0 "./test/t0", form=0x7fa96f7a5d10, info=0x7fa96f7a8660)
    at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/handler.cc:4524
#16 0x0000000000694161 in ha_create_table (thd=0x78d5510, path=0x7fa96f7a7db0 "./test/t0", db=0x7fa944005638 "test", table_name=0x7fa9440050a0 "t0", create_info=0x7fa96f7a8660,
    update_create_info=false, is_temp_table=false) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/handler.cc:4762
#17 0x0000000000904ef4 in rea_create_table (thd=0x78d5510, path=0x7fa96f7a7db0 "./test/t0", db=0x7fa944005638 "test", table_name=0x7fa9440050a0 "t0", create_info=0x7fa96f7a8660,
    create_fields=..., keys=0, key_info=0x7fa944005da8, file=0x7fa944005ae0, no_ha_table=false) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/unireg.cc:526
#18 0x000000000089a95f in create_table_impl (thd=0x78d5510, db=0x7fa944005638 "test", table_name=0x7fa9440050a0 "t0", path=0x7fa96f7a7db0 "./test/t0", create_info=0x7fa96f7a8660,
    alter_info=0x7fa96f7a80b0, internal_tmp_table=false, select_field_count=0, no_ha_table=false, is_trans=0x7fa96f7a804e, key_info=0x7fa96f7a7fb8, key_count=0x7fa96f7a7fb4)
    at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/sql_table.cc:4917
#19 0x000000000089ae26 in mysql_create_table_no_lock (thd=0x78d5510, db=0x7fa944005638 "test", table_name=0x7fa9440050a0 "t0", create_info=0x7fa96f7a8660, alter_info=0x7fa96f7a80b0,
    select_field_count=0, is_trans=0x7fa96f7a804e) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/sql_table.cc:5029
#20 0x000000000089af34 in mysql_create_table (thd=0x78d5510, create_table=0x7fa9440050d8, create_info=0x7fa96f7a8660, alter_info=0x7fa96f7a80b0)
    at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/sql_table.cc:5078
#21 0x000000000082e513 in mysql_execute_command (thd=0x78d5510) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/sql_parse.cc:3061
#22 0x00000000008375d1 in mysql_parse (thd=0x78d5510, rawbuf=0x7fa944004fd0 "create table t0(id INT,x INT)engine=INNODB", length=42, parser_state=0x7fa96f7a9680)
    at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/sql_parse.cc:6245
#23 0x000000000082a3a2 in dispatch_command (command=COM_QUERY, thd=0x78d5510, packet=0x7a04ae1 "create table t0(id INT,x INT)engine=INNODB", packet_length=42)
    at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/sql_parse.cc:1332
#24 0x0000000000829407 in do_command (thd=0x78d5510) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/sql_parse.cc:1034
#25 0x00000000007f0887 in do_handle_one_connection (thd_arg=0x78d5510) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/sql_connect.cc:982
#26 0x00000000007f0358 in handle_one_connection (arg=0x78d5510) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/sql/sql_connect.cc:898
#27 0x0000000000e5c19d in pfs_spawn_thread (arg=0x78f9050) at /export/home/pb2/build/sb_0-13146752-1409933888.09/mysqlcom-pro-5.6.22/storage/perfschema/pfs.cc:1860
#28 0x0000003b3ba079d1 in start_thread () from /lib64/libpthread.so.0
#29 0x0000003b3b6e8b5d in clone () from /lib64/libc.so.6
[16 Sep 2014 10:34] Roel Van de Paar
Umesh, "mysql-5.6.20-linux-glibc2.5-x86_64" from original comment is not debug build, so maybe there is another difference?
[16 Sep 2014 10:56] Roel Van de Paar
Hmm apologies, it does show as debug (not in filename but in description - see first comment). Not sure what is happening here, this is likely mysql-5.6.20-linux-glibc2.5-x86_64.tar.gz from downloads on mysql.com - are the tar downloads there debug?
[25 Sep 2014 21:05] Roel Van de Paar
S3.
[6 Oct 2014 13:47] Todd Farmer
Removing security designation as only debug builds are affected.
[14 Nov 2016 1:15] Roel Van de Paar
SET SESSION debug="+d,fsp_flags_is_valid_failure";
CREATE TEMPORARY TABLE tt_innodb(a INT)ENGINE=InnoDB;
[6 Dec 2016 3:15] Roel Van de Paar
Crash is at a different location in 5.7.16:

2016-12-06T02:35:41.577739Z 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)
2016-12-06 13:46:38 0x7f236b191700  InnoDB: Assertion failure in thread 139790097389312 in file fsp0fsp.ic line 172
InnoDB: Failing assertion: fsp_flags_is_valid(flags)

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  0x00007f236ab9d741 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  0x00007f236ab9d741 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  0x00007f2368f345f7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5  0x00007f2368f35ce8 in __GI_abort () at abort.c:90
#6  0x0000000001b8980f in ut_dbg_assertion_failed (expr=0x213741a "fsp_flags_is_valid(flags)", file=0x21372f0 "/git/mysql-server_dbg/storage/innobase/include/fsp0fsp.ic",
    line=172) at /git/mysql-server_dbg/storage/innobase/ut/ut0dbg.cc:67
#7  0x0000000001c2973f in fsp_flags_set_page_size (flags=0, page_size=...) at /git/mysql-server_dbg/storage/innobase/include/fsp0fsp.ic:172
#8  0x0000000001c29813 in fsp_flags_init (page_size=..., atomic_blobs=true, has_data_dir=false, is_shared=false, is_temporary=false, is_encrypted=false)
    at /git/mysql-server_dbg/storage/innobase/include/fsp0fsp.ic:200
#9  0x0000000001c3c681 in dict_tf_to_fsp_flags (table_flags=33, is_temp=false, is_encrypted=false) at /git/mysql-server_dbg/storage/innobase/dict/dict0dict.cc:6906
#10 0x0000000001c217f6 in dict_build_tablespace_for_table (table=0x7f233e891320) at /git/mysql-server_dbg/storage/innobase/dict/dict0crea.cc:498
#11 0x0000000001c211fe in dict_build_table_def_step (thr=0x7f233e90c318, node=0x7f233e879ca0) at /git/mysql-server_dbg/storage/innobase/dict/dict0crea.cc:367
#12 0x0000000001c23cd9 in dict_create_table_step (thr=0x7f233e90c318) at /git/mysql-server_dbg/storage/innobase/dict/dict0crea.cc:1453
#13 0x0000000001a5a23a in que_thr_step (thr=0x7f233e90c318) at /git/mysql-server_dbg/storage/innobase/que/que0que.cc:1064
#14 0x0000000001a5a3cf in que_run_threads_low (thr=0x7f233e90c318) at /git/mysql-server_dbg/storage/innobase/que/que0que.cc:1118
#15 0x0000000001a5a585 in que_run_threads (thr=0x7f233e90c318) at /git/mysql-server_dbg/storage/innobase/que/que0que.cc:1158
#16 0x0000000001ab195d in row_create_table_for_mysql (table=0x7f233e891320, compression=0x0, trx=0x7f235a800cf8, commit=false)
    at /git/mysql-server_dbg/storage/innobase/row/row0mysql.cc:3047
#17 0x0000000001975dbc in create_table_info_t::create_table_def (this=0x7f236b18c610) at /git/mysql-server_dbg/storage/innobase/handler/ha_innodb.cc:10211
#18 0x0000000001962a74 in create_table_info_t::create_table (this=0x7f236b18c610) at /git/mysql-server_dbg/storage/innobase/handler/ha_innodb.cc:11735
#19 0x0000000001963647 in ha_innobase::create (this=0x7f233e8aa830, name=0x7f236b18f120 "./test/t1", form=0x7f236b18d3d0, create_info=0x7f236b18fa50)
    at /git/mysql-server_dbg/storage/innobase/handler/ha_innodb.cc:12083
#20 0x0000000000ef5888 in handler::ha_create (this=0x7f233e8aa830, name=0x7f236b18f120 "./test/t1", form=0x7f236b18d3d0, info=0x7f236b18fa50)
    at /git/mysql-server_dbg/sql/handler.cc:4916
#21 0x0000000000ef5e86 in ha_create_table (thd=0x7f233e819000, path=0x7f236b18f120 "./test/t1", db=0x7f233e82bf58 "test", table_name=0x7f233e82b998 "t1",
    create_info=0x7f236b18fa50, update_create_info=false, is_temp_table=false) at /git/mysql-server_dbg/sql/handler.cc:5075
#22 0x00000000015ff15a in rea_create_table (thd=0x7f233e819000, path=0x7f236b18f120 "./test/t1", db=0x7f233e82bf58 "test", table_name=0x7f233e82b998 "t1",
    create_info=0x7f236b18fa50, create_fields=..., keys=0, key_info=0x7f233e82c5c8, file=0x7f233e82c2d8, no_ha_table=false) at /git/mysql-server_dbg/sql/unireg.cc:537
#23 0x000000000157f547 in create_table_impl (thd=0x7f233e819000, db=0x7f233e82bf58 "test", table_name=0x7f233e82b998 "t1", path=0x7f236b18f120 "./test/t1",
    create_info=0x7f236b18fa50, alter_info=0x7f236b18f4c0, internal_tmp_table=false, select_field_count=0, no_ha_table=false, is_trans=0x7f236b18f3ae, key_info=0x7f236b18f330,
    key_count=0x7f236b18f32c) at /git/mysql-server_dbg/sql/sql_table.cc:5254
#24 0x000000000157fa9f in mysql_create_table_no_lock (thd=0x7f233e819000, db=0x7f233e82bf58 "test", table_name=0x7f233e82b998 "t1", create_info=0x7f236b18fa50,
    alter_info=0x7f236b18f4c0, select_field_count=0, is_trans=0x7f236b18f3ae) at /git/mysql-server_dbg/sql/sql_table.cc:5382
#25 0x000000000157fb95 in mysql_create_table (thd=0x7f233e819000, create_table=0x7f233e82b9d0, create_info=0x7f236b18fa50, alter_info=0x7f236b18f4c0)
    at /git/mysql-server_dbg/sql/sql_table.cc:5428
#26 0x00000000014f306a in mysql_execute_command (thd=0x7f233e819000, first_level=true) at /git/mysql-server_dbg/sql/sql_parse.cc:3199
#27 0x00000000014f97d5 in mysql_parse (thd=0x7f233e819000, parser_state=0x7f236b190560) at /git/mysql-server_dbg/sql/sql_parse.cc:5559
#28 0x00000000014eef69 in dispatch_command (thd=0x7f233e819000, com_data=0x7f236b190cb0, command=COM_QUERY) at /git/mysql-server_dbg/sql/sql_parse.cc:1427
#29 0x00000000014ede33 in do_command (thd=0x7f233e819000) at /git/mysql-server_dbg/sql/sql_parse.cc:995
#30 0x000000000161d370 in handle_connection (arg=0x7f234f3e9840) at /git/mysql-server_dbg/sql/conn_handler/connection_handler_per_thread.cc:300
#31 0x000000000184f79c in pfs_spawn_thread (arg=0x7f234f276120) at /git/mysql-server_dbg/storage/perfschema/pfs.cc:2188
#32 0x00007f236ab98dc5 in start_thread (arg=0x7f236b191700) at pthread_create.c:308
#33 0x00007f2368ff5ced in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

DROP DATABASE test;CREATE DATABASE test;USE test;
SET SESSION debug="+d,fsp_flags_is_valid_failure";
CREATE TABLE t1(c1 CHAR (1));
[21 Jan 2017 1:15] Roel Van de Paar
See bug 74873 and bug 84593