Bug #74873 Failing assertion: fsp_flags_is_valid(flags) in file fil0fil.cc line 3380
Submitted: 15 Nov 2014 0:08 Modified: 21 Jan 2017 1:14
Reporter: Roel Van de Paar Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DDL Severity:S6 (Debug Builds)
Version:5.6.20, 5.6.23, 5.7.6, 5.6.34 OS:Any
Assigned to: CPU Architecture:Any
Tags: debug

[15 Nov 2014 0:08] Roel Van de Paar
Description:
Version: '5.6.20-debug'  socket: '/sda/mysql-5.6.20-linux-x86_64-debug/socket.sock'  port: 11214  MySQL Community Server (GPL)
2014-11-15 11:02:39 7f5ef7e3e700  InnoDB: Assertion failure in thread 140045862561536 in file fil0fil.cc line 3380
InnoDB: Failing assertion: fsp_flags_is_valid(flags)

(gdb) bt
#0  0x00007f5ef7845771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000000a9035e in my_write_core (sig=6) at /bzr/mysql-5.6/mysys/stacktrace.c:422
#2  0x0000000000723688 in handle_fatal_signal (sig=6) at /bzr/mysql-5.6/sql/signal_handler.cc:230
#3  <signal handler called>
#4  0x00007f5ef66515c9 in raise () from /lib64/libc.so.6
#5  0x00007f5ef6652cd8 in abort () from /lib64/libc.so.6
#6  0x0000000000d9d5b8 in fil_create_new_single_table_tablespace (space_id=6, tablename=0x7f5e5a41a370 "test/@003f@003f@003f@003f@003f@003f@003f", dir_path=0x0, flags=18446744073709551615, flags2=80, size=4) at /bzr/mysql-5.6/storage/innobase/fil/fil0fil.cc:3380
#7  0x0000000000d5e013 in dict_build_table_def_step (thr=0x7f5e5a4c8740, node=0x7f5e5a46c5f8) at /bzr/mysql-5.6/storage/innobase/dict/dict0crea.cc:312
#8  0x0000000000d5f723 in dict_create_table_step (thr=0x7f5e5a4c8740) at /bzr/mysql-5.6/storage/innobase/dict/dict0crea.cc:1044
#9  0x0000000000c188ca in que_thr_step (thr=0x7f5e5a4c8740) at /bzr/mysql-5.6/storage/innobase/que/que0que.cc:1113
#10 0x0000000000c18a85 in que_run_threads_low (thr=0x7f5e5a4c8740) at /bzr/mysql-5.6/storage/innobase/que/que0que.cc:1167
#11 0x0000000000c18c54 in que_run_threads (thr=0x7f5e5a4c8740) at /bzr/mysql-5.6/storage/innobase/que/que0que.cc:1208
#12 0x0000000000c5cdba in row_create_table_for_mysql (table=0x7f5e5a481378, trx=0x7f5e5a4c7a78, commit=false) at /bzr/mysql-5.6/storage/innobase/row/row0mysql.cc:2259
#13 0x0000000000b6c4b0 in create_table_def (trx=0x7f5e5a4c7a78, form=0x7f5ef7e39b10, table_name=0x7f5ef7e38ee0 "test/@003f@003f@003f@003f@003f@003f@003f", temp_path=0x7f5ef7e390e0 "", remote_path=0x7f5ef7e392e0 "", flags=1, flags2=80) at /bzr/mysql-5.6/storage/innobase/handler/ha_innodb.cc:8653
#14 0x0000000000b6de21 in ha_innobase::create (this=0x7f5e5a47f010, name=0x7f5ef7e3bac0 "./test/@003f@003f@003f@003f@003f@003f@003f", form=0x7f5ef7e39b10, create_info=0x7f5ef7e3c3d0) at /bzr/mysql-5.6/storage/innobase/handler/ha_innodb.cc:9561
#15 0x000000000063c426 in handler::ha_create (this=0x7f5e5a47f010, name=0x7f5ef7e3bac0 "./test/@003f@003f@003f@003f@003f@003f@003f", form=0x7f5ef7e39b10, info=0x7f5ef7e3c3d0) at /bzr/mysql-5.6/sql/handler.cc:4524
#16 0x000000000063ccdd in ha_create_table (thd=0x7f5e64324000, path=0x7f5ef7e3bac0 "./test/@003f@003f@003f@003f@003f@003f@003f", db=0x7f5e5a41f6b8 "test", table_name=0x7f5e5a41f120 "???????", create_info=0x7f5ef7e3c3d0, update_create_info=false, is_temp_table=false) at /bzr/mysql-5.6/sql/handler.cc:4762
#17 0x00000000008a3b36 in rea_create_table (thd=0x7f5e64324000, path=0x7f5ef7e3bac0 "./test/@003f@003f@003f@003f@003f@003f@003f", db=0x7f5e5a41f6b8 "test", table_name=0x7f5e5a41f120 "???????", create_info=0x7f5ef7e3c3d0, create_fields=..., keys=0, key_info=0x7f5e5a41f9f8, file=0x7f5e5a479010, no_ha_table=false) at /bzr/mysql-5.6/sql/unireg.cc:527
#18 0x000000000083a7ce in create_table_impl (thd=0x7f5e64324000, db=0x7f5e5a41f6b8 "test", table_name=0x7f5e5a41f120 "???????", path=0x7f5ef7e3bac0 "./test/@003f@003f@003f@003f@003f@003f@003f", create_info=0x7f5ef7e3c3d0, alter_info=0x7f5ef7e3be70, internal_tmp_table=false, select_field_count=0, no_ha_table=false, is_trans=0x7f5ef7e3bd4e, key_info=0x7f5ef7e3bcc8, key_count=0x7f5ef7e3bcc4) at /bzr/mysql-5.6/sql/sql_table.cc:4919
#19 0x000000000083ac99 in mysql_create_table_no_lock (thd=0x7f5e64324000, db=0x7f5e5a41f6b8 "test", table_name=0x7f5e5a41f120 "???????", create_info=0x7f5ef7e3c3d0, alter_info=0x7f5ef7e3be70, select_field_count=0, is_trans=0x7f5ef7e3bd4e) at /bzr/mysql-5.6/sql/sql_table.cc:5029
#20 0x000000000083ada2 in mysql_create_table (thd=0x7f5e64324000, create_table=0x7f5e5a41f158, create_info=0x7f5ef7e3c3d0, alter_info=0x7f5ef7e3be70) at /bzr/mysql-5.6/sql/sql_table.cc:5078
#21 0x00000000007d04b6 in mysql_execute_command (thd=0x7f5e64324000) at /bzr/mysql-5.6/sql/sql_parse.cc:3061
#22 0x00000000007d8fa4 in mysql_parse (thd=0x7f5e64324000, rawbuf=0x7f5e5a41f010 "CREATE TABLE `???????`(`?????????` char)DEFAULT CHARSET=ujis engine=INNODB", length=74, parser_state=0x7f5ef7e3ce70) at /bzr/mysql-5.6/sql/sql_parse.cc:6245
#23 0x00000000007cc557 in dispatch_command (command=COM_QUERY, thd=0x7f5e64324000, packet=0x7f5e64362001 "CREATE TABLE `???????`(`?????????` char)DEFAULT CHARSET=ujis engine=INNODB", packet_length=74) at /bzr/mysql-5.6/sql/sql_parse.cc:1332
#24 0x00000000007cb646 in do_command (thd=0x7f5e64324000) at /bzr/mysql-5.6/sql/sql_parse.cc:1034
#25 0x0000000000793a61 in do_handle_one_connection (thd_arg=0x7f5e64324000) at /bzr/mysql-5.6/sql/sql_connect.cc:982
#26 0x000000000079354a in handle_one_connection (arg=0x7f5e64324000) at /bzr/mysql-5.6/sql/sql_connect.cc:898
#27 0x0000000000ade888 in pfs_spawn_thread (arg=0x7f5ef0f49b00) at /bzr/mysql-5.6/storage/perfschema/pfs.cc:1860
#28 0x00007f5ef7840df3 in start_thread () from /lib64/libpthread.so.0
#29 0x00007f5ef671201d in clone () from /lib64/libc.so.6

How to repeat:
DROP DATABASE test;CREATE DATABASE test;USE test;
SET SESSION debug="+d,dict_tf_to_fsp_flags_failure";
CREATE TABLE `???????`(`?????????` char)DEFAULT CHARSET=ujis engine=INNODB;
[15 Nov 2014 0:09] Roel Van de Paar
Please confirm bug severity
[15 Nov 2014 6:31] MySQL Verification Team
Hello Roel,

Thank you for the report.
Confirmed that only debug builds(5.6.23, 5.7.6) are affected.

Thanks,
Umesh
[15 Nov 2014 6:31] MySQL Verification Team
// 5.6.23

scripts/mysql_install_db --basedir=/data/ushastry/server/mysql-advanced-5.6.23 --datadir=/tmp/bug --user=root
bin/mysqld-debug --basedir=/data/ushastry/server/mysql-advanced-5.6.23 --datadir=/tmp/bug --core --socket=/tmp/mysql.sock  --port=3306 --log-error=/tmp/bug/log.err --user=root 2>&1 &

(gdb) bt
#0  __pthread_kill (threadid=<value optimized out>, signo=<value optimized out>) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:63
#1  0x0000000000affdab in my_write_core (sig=6) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/mysys/stacktrace.c:422
#2  0x000000000077ebbc in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/signal_handler.cc:230
#3  <signal handler called>
#4  0x0000003deac32625 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64
#5  0x0000003deac33e05 in abort () at abort.c:92
#6  0x0000000000dd393e in fil_create_new_single_table_tablespace (space_id=7, tablename=0x7f560c03d3e0 "test/@003f@003f@003f@003f@003f@003f@003f", dir_path=0x0, flags=18446744073709551615,
    flags2=80, size=4) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/fil/fil0fil.cc:3383
#7  0x0000000000d93671 in dict_build_table_def_step (thr=0x7f560c03e5d0, node=0x7f560c03df08)
    at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/dict/dict0crea.cc:312
#8  0x0000000000d94d87 in dict_create_table_step (thr=0x7f560c03e5d0) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/dict/dict0crea.cc:1044
#9  0x0000000000c4be76 in que_thr_step (thr=0x7f560c03e5d0) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/que/que0que.cc:1113
#10 0x0000000000c4c031 in que_run_threads_low (thr=0x7f560c03e5d0) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/que/que0que.cc:1167
#11 0x0000000000c4c1fb in que_run_threads (thr=0x7f560c03e5d0) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/que/que0que.cc:1208
#12 0x0000000000c907e8 in row_create_table_for_mysql (table=0x7f560c03d188, trx=0x7f560c00d1a8, commit=false)
    at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/row/row0mysql.cc:2310
#13 0x0000000000b9f2d9 in create_table_def (trx=0x7f560c00d1a8, form=0x7f5630867d10, table_name=0x7f56308679d0 "test/@003f@003f@003f@003f@003f@003f@003f", temp_path=0x7f56308677d0 "",
    remote_path=0x7f56308675d0 "", flags=1, flags2=80) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/handler/ha_innodb.cc:8695
#14 0x0000000000ba0cce in ha_innobase::create (this=0x7f560c0425b0, name=0x7f5630869db0 "./test/@003f@003f@003f@003f@003f@003f@003f", form=0x7f5630867d10, create_info=0x7f563086a660)
    at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/handler/ha_innodb.cc:9603
#15 0x0000000000693c90 in handler::ha_create (this=0x7f560c0425b0, name=0x7f5630869db0 "./test/@003f@003f@003f@003f@003f@003f@003f", form=0x7f5630867d10, info=0x7f563086a660)
    at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/handler.cc:4524
#16 0x0000000000694575 in ha_create_table (thd=0x3df4310, path=0x7f5630869db0 "./test/@003f@003f@003f@003f@003f@003f@003f", db=0x7f560c007428 "test", table_name=0x7f560c006e90 "???????",
    create_info=0x7f563086a660, update_create_info=false, is_temp_table=false) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/handler.cc:4762
#17 0x0000000000905a3c in rea_create_table (thd=0x3df4310, path=0x7f5630869db0 "./test/@003f@003f@003f@003f@003f@003f@003f", db=0x7f560c007428 "test", table_name=0x7f560c006e90 "???????",
    create_info=0x7f563086a660, create_fields=..., keys=0, key_info=0x7f560c007a30, file=0x7f560c007768, no_ha_table=false)
    at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/unireg.cc:526
#18 0x000000000089b38f in create_table_impl (thd=0x3df4310, db=0x7f560c007428 "test", table_name=0x7f560c006e90 "???????", path=0x7f5630869db0 "./test/@003f@003f@003f@003f@003f@003f@003f",
    create_info=0x7f563086a660, alter_info=0x7f563086a0b0, internal_tmp_table=false, select_field_count=0, no_ha_table=false, is_trans=0x7f563086a04e, key_info=0x7f5630869fb8,
    key_count=0x7f5630869fb4) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_table.cc:4917
#19 0x000000000089b856 in mysql_create_table_no_lock (thd=0x3df4310, db=0x7f560c007428 "test", table_name=0x7f560c006e90 "???????", create_info=0x7f563086a660, alter_info=0x7f563086a0b0,
    select_field_count=0, is_trans=0x7f563086a04e) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_table.cc:5029
#20 0x000000000089b964 in mysql_create_table (thd=0x3df4310, create_table=0x7f560c006ec8, create_info=0x7f563086a660, alter_info=0x7f563086a0b0)
    at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_table.cc:5078
#21 0x000000000082ea9c in mysql_execute_command (thd=0x3df4310) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_parse.cc:3061
#22 0x0000000000837fa9 in mysql_parse (thd=0x3df4310, rawbuf=0x7f560c006d80 "CREATE TABLE `???????`(`?????????` char)DEFAULT CHARSET=ujis engine=INNODB", length=74, parser_state=0x7f563086b680)
    at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_parse.cc:6357
#23 0x000000000082a92b in dispatch_command (command=COM_QUERY, thd=0x3df4310, packet=0x3f21b21 "CREATE TABLE `???????`(`?????????` char)DEFAULT CHARSET=ujis engine=INNODB", packet_length=74)
    at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_parse.cc:1332
#24 0x0000000000829990 in do_command (thd=0x3df4310) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_parse.cc:1034
#25 0x00000000007f0d8f in do_handle_one_connection (thd_arg=0x3df4310) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_connect.cc:982
#26 0x00000000007f0860 in handle_one_connection (arg=0x3df4310) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_connect.cc:898
#27 0x0000000000e5f509 in pfs_spawn_thread (arg=0x3f036a0) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/perfschema/pfs.cc:1860
#28 0x0000003deb0079d1 in start_thread (arg=0x7f563086c700) at pthread_create.c:301
#29 0x0000003deace89dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115
[15 Nov 2014 6:32] MySQL Verification Team
// 5.7.6

bin/mysql_install_db --basedir=/data/ushastry/server/mysql-advanced-5.7.6 --datadir=/tmp/bug --user=root -v
bin/mysqld-debug --basedir=/data/ushastry/server/mysql-advanced-5.7.6 --datadir=/tmp/bug --core-file --socket=/tmp/mysql.sock --port=3306 --log-error=/tmp/bug/log.err --user=root 2>&1 &

(gdb) bt
#0  __pthread_kill (threadid=<value optimized out>, signo=<value optimized out>) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:63
#1  0x0000000000f990a1 in my_write_core (sig=6) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/mysys/stacktrace.c:247
#2  0x000000000092d7cc in handle_fatal_signal (sig=6) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/signal_handler.cc:219
#3  <signal handler called>
#4  0x0000003deac32625 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64
#5  0x0000003deac33e05 in abort () at abort.c:92
#6  0x000000000121b81b in ut_dbg_assertion_failed (expr=0x177ef42 "fsp_flags_is_valid(flags)",
    file=0x177f108 "/pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/fil/fil0fil.cc", line=3322)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/ut/ut0dbg.cc:67
#7  0x00000000012f39a6 in fil_create_ibd_tablespace (space_id=22, name=0x7f33b0045dd0 "test/@003f@003f@003f@003f@003f@003f@003f",
    path=0x7f33b004c000 "./test/@003f@003f@003f@003f@003f@003f@003f.ibd", flags=18446744073709551615, is_temp=false, size=4)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/fil/fil0fil.cc:3322
#8  0x00000000012ad304 in dict_build_tablespace_for_table (table=0x7f33b001a108) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/dict/dict0crea.cc:361
#9  0x00000000012acf0f in dict_build_table_def_step (thr=0x7f33b001b790, node=0x7f33b001b088)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/dict/dict0crea.cc:269
#10 0x00000000012af5b5 in dict_create_table_step (thr=0x7f33b001b790) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/dict/dict0crea.cc:1256
#11 0x000000000110ceff in que_thr_step (thr=0x7f33b001b790) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/que/que0que.cc:1049
#12 0x000000000110d095 in que_run_threads_low (thr=0x7f33b001b790) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/que/que0que.cc:1103
#13 0x000000000110d254 in que_run_threads (thr=0x7f33b001b790) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/que/que0que.cc:1143
#14 0x000000000115e2a8 in row_create_table_for_mysql (table=0x7f33b001a108, trx=0x7f33ec639d60, commit=false)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0mysql.cc:2839
#15 0x0000000001052f94 in create_table_info_t::create_table_def (this=0x7f33ec04b7f0) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/handler/ha_innodb.cc:8978
#16 0x00000000010436a8 in create_table_info_t::create_table (this=0x7f33ec04b7f0) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/handler/ha_innodb.cc:9922
#17 0x000000000104417c in ha_innobase::create (this=0x7f33b004ba70, name=0x7f33ec04dbd0 "./test/@003f@003f@003f@003f@003f@003f@003f", form=0x7f33ec04b930, create_info=0x7f33ec04e4a0)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/handler/ha_innodb.cc:10237
#18 0x0000000000998d80 in handler::ha_create (this=0x7f33b004ba70, name=0x7f33ec04dbd0 "./test/@003f@003f@003f@003f@003f@003f@003f", form=0x7f33ec04b930, info=0x7f33ec04e4a0)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/handler.cc:4624
#19 0x000000000099967e in ha_create_table (thd=0x7f33b0000d30, path=0x7f33ec04dbd0 "./test/@003f@003f@003f@003f@003f@003f@003f", db=0x7f33b00063a0 "test", table_name=0x7f33b0005df0 "???????",
    create_info=0x7f33ec04e4a0, update_create_info=false, is_temp_table=false) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/handler.cc:4865
#20 0x0000000000da31ad in rea_create_table (thd=0x7f33b0000d30, path=0x7f33ec04dbd0 "./test/@003f@003f@003f@003f@003f@003f@003f", db=0x7f33b00063a0 "test", table_name=0x7f33b0005df0 "???????",
    create_info=0x7f33ec04e4a0, create_fields=..., keys=0, key_info=0x7f33b00069e0, file=0x7f33b0006710, no_ha_table=false)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/unireg.cc:508
#21 0x0000000000d2e2a4 in create_table_impl (thd=0x7f33b0000d30, db=0x7f33b00063a0 "test", table_name=0x7f33b0005df0 "???????",
    path=0x7f33ec04dbd0 "./test/@003f@003f@003f@003f@003f@003f@003f", create_info=0x7f33ec04e4a0, alter_info=0x7f33ec04ded0, internal_tmp_table=false, select_field_count=0, no_ha_table=false,
    is_trans=0x7f33ec04de6e, key_info=0x7f33ec04dde0, key_count=0x7f33ec04dddc) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_table.cc:4936
#22 0x0000000000d2e763 in mysql_create_table_no_lock (thd=0x7f33b0000d30, db=0x7f33b00063a0 "test", table_name=0x7f33b0005df0 "???????", create_info=0x7f33ec04e4a0, alter_info=0x7f33ec04ded0,
    select_field_count=0, is_trans=0x7f33ec04de6e) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_table.cc:5047
#23 0x0000000000d2e86a in mysql_create_table (thd=0x7f33b0000d30, create_table=0x7f33b0005e28, create_info=0x7f33ec04e4a0, alter_info=0x7f33ec04ded0)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_table.cc:5093
#24 0x0000000000cb515e in mysql_execute_command (thd=0x7f33b0000d30) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:2915
#25 0x0000000000cbce6a in mysql_parse (thd=0x7f33b0000d30, parser_state=0x7f33ec04f660) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:5397
#26 0x0000000000cb0f2c in dispatch_command (command=COM_QUERY, thd=0x7f33b0000d30, packet=0x7f33b0009a61 "CREATE TABLE `???????`(`?????????` char)DEFAULT CHARSET=ujis engine=INNODB",
    packet_length=74) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:1249
#27 0x0000000000cafbd4 in do_command (thd=0x7f33b0000d30) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:833
#28 0x0000000000dbe89c in handle_connection (arg=0x3da0060) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/conn_handler/connection_handler_per_thread.cc:298
#29 0x000000000138347f in pfs_spawn_thread (arg=0x3bf64a0) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/perfschema/pfs.cc:2137
#30 0x0000003deb0079d1 in start_thread (arg=0x7f33ec050700) at pthread_create.c:301
#31 0x0000003deace89dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115
[18 Feb 2016 23:11] Kevin Lewis
Posted by developer:
 
Works in 5.7

mysql> CREATE TABLE `???????`(`?????????` char)DEFAULT CHARSET=ujis engine=INNODB;
Query OK, 0 rows affected (0.07 sec)
[25 Feb 2016 8:52] Erlend Dahl
Not reproducible on latest 5.7.
[14 Nov 2016 1:22] Roel Van de Paar
DROP DATABASE test;CREATE DATABASE test;USE test;
SET SESSION debug="+d,dict_tf_to_fsp_flags_failure";
create temporary table tm_temp_temp(i int)ENGINE=InnoDB;

Crashes 5.6.34. Please re-open this bug.
[14 Nov 2016 4:47] MySQL Verification Team
MySQL 5.6.34 debug build is still affected:

rm -rf 83661
scripts/mysql_install_db --basedir=/export/umesh/server/binaries/GABuilds/mysql-5.6.34 --datadir=/export/umesh/server/binaries/GABuilds/mysql-5.6.34/83661 -v
bin/mysqld-debug --no-defaults --basedir=/export/umesh/server/binaries/GABuilds/mysql-5.6.34 --datadir=/export/umesh/server/binaries/GABuilds/mysql-5.6.34/83661 --core-file --socket=/tmp/mysql_ushastry.sock   --port=3306 --log-error=/export/umesh/server/binaries/GABuilds/mysql-5.6.34/83661/log.err  2>&1 &

(gdb) bt
#0  0x00007f38ea2c7771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000000ae5e5f in my_write_core (sig=6) at /export/home/pb2/build/sb_0-20604842-1475238842.11/mysqlcom-pro-5.6.34/mysys/stacktrace.c:422
#2  0x0000000000747ef2 in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-20604842-1475238842.11/mysqlcom-pro-5.6.34/sql/signal_handler.cc:230
#3  <signal handler called>
#4  0x00007f38e8ecd5d7 in raise () from /lib64/libc.so.6
#5  0x00007f38e8ececc8 in abort () from /lib64/libc.so.6
#6  0x0000000000d0f21b in fil_create_new_single_table_tablespace (space_id=7, tablename=0x7f388c0123b0 "tmp/#sql2323_1_0", dir_path=0x7f388c019630 "/tmp/#sql2323_1_0",
    flags=18446744073709551615, flags2=81, size=4) at /export/home/pb2/build/sb_0-20604842-1475238842.11/mysqlcom-pro-5.6.34/storage/innobase/fil/fil0fil.cc:3438
#7  0x0000000000cd03f4 in dict_build_table_def_step (thr=0x7f388c01a610, node=0x7f388c019f48)
    at /export/home/pb2/build/sb_0-20604842-1475238842.11/mysqlcom-pro-5.6.34/storage/innobase/dict/dict0crea.cc:312
#8  0x0000000000cd087f in dict_create_table_step (thr=0x7f388c01a610) at /export/home/pb2/build/sb_0-20604842-1475238842.11/mysqlcom-pro-5.6.34/storage/innobase/dict/dict0crea.cc:1044
#9  0x0000000000ba65aa in que_thr_step (thr=0x7f388c01a610) at /export/home/pb2/build/sb_0-20604842-1475238842.11/mysqlcom-pro-5.6.34/storage/innobase/que/que0que.cc:1087
#10 0x0000000000ba6729 in que_run_threads_low (thr=0x7f388c01a610) at /export/home/pb2/build/sb_0-20604842-1475238842.11/mysqlcom-pro-5.6.34/storage/innobase/que/que0que.cc:1141
#11 0x0000000000ba689a in que_run_threads (thr=0x7f388c01a610) at /export/home/pb2/build/sb_0-20604842-1475238842.11/mysqlcom-pro-5.6.34/storage/innobase/que/que0que.cc:1182
#12 0x0000000000be8b21 in row_create_table_for_mysql (table=0x7f388c019358, trx=0x7f388c018258, commit=false)
    at /export/home/pb2/build/sb_0-20604842-1475238842.11/mysqlcom-pro-5.6.34/storage/innobase/row/row0mysql.cc:2304
#13 0x0000000000b0394a in create_table_def (trx=0x7f388c018258, form=0x7f38bfbbaa80, table_name=0x7f38bfbba730 "tmp/#sql2323_1_0", temp_path=0x7f38bfbba530 "/tmp/#sql2323_1_0",
    remote_path=0x7f38bfbba330 "", flags=1, flags2=81) at /export/home/pb2/build/sb_0-20604842-1475238842.11/mysqlcom-pro-5.6.34/storage/innobase/handler/ha_innodb.cc:8824
#14 0x0000000000b0c083 in ha_innobase::create (this=0x7f388c017e00, name=0x7f38bfbbcb30 "/tmp/#sql2323_1_0", form=0x7f38bfbbaa80, create_info=0x7f38bfbbd610)
    at /export/home/pb2/build/sb_0-20604842-1475238842.11/mysqlcom-pro-5.6.34/storage/innobase/handler/ha_innodb.cc:9732
#15 0x000000000064ea0f in handler::ha_create (this=0x7f388c017e00, name=0x7f38bfbbcb30 "/tmp/#sql2323_1_0", form=0x7f38bfbbaa80, info=0x7f38bfbbd610)
    at /export/home/pb2/build/sb_0-20604842-1475238842.11/mysqlcom-pro-5.6.34/sql/handler.cc:4525
#16 0x00000000006548fe in ha_create_table (thd=0x3a4fca0, path=0x7f38bfbbcb30 "/tmp/#sql2323_1_0", db=0x7f388c005660 "test", table_name=0x7f388c0050b8 "tm_temp_temp",
    create_info=0x7f38bfbbd610, update_create_info=false, is_temp_table=false) at /export/home/pb2/build/sb_0-20604842-1475238842.11/mysqlcom-pro-5.6.34/sql/handler.cc:4769
#17 0x00000000008d7f93 in rea_create_table (thd=0x3a4fca0, path=0x7f38bfbbcb30 "/tmp/#sql2323_1_0", db=0x7f388c005660 "test", table_name=0x7f388c0050b8 "tm_temp_temp",
    create_info=0x7f38bfbbd610, create_fields=..., keys=0, key_info=0x7f388c005ab0, file=0x7f388c0057e8, no_ha_table=false)
    at /export/home/pb2/build/sb_0-20604842-1475238842.11/mysqlcom-pro-5.6.34/sql/unireg.cc:526
#18 0x00000000008684b2 in create_table_impl (thd=0x3a4fca0, db=0x7f388c005660 "test", table_name=0x7f388c0050b8 "tm_temp_temp", path=0x7f38bfbbcb30 "/tmp/#sql2323_1_0",
    create_info=0x7f38bfbbd610, alter_info=0x7f38bfbbd060, internal_tmp_table=false, select_field_count=0, no_ha_table=false, is_trans=0x7f38bfbbcdce, key_info=0x7f38bfbbcd38,
    key_count=0x7f38bfbbcd34) at /export/home/pb2/build/sb_0-20604842-1475238842.11/mysqlcom-pro-5.6.34/sql/sql_table.cc:4967
#19 0x0000000000872128 in mysql_create_table_no_lock (thd=0x3a4fca0, db=0x7f388c005660 "test", table_name=0x7f388c0050b8 "tm_temp_temp", create_info=0x7f38bfbbd610, alter_info=0x7f38bfbbd060,
    select_field_count=0, is_trans=0x7f38bfbbcdce) at /export/home/pb2/build/sb_0-20604842-1475238842.11/mysqlcom-pro-5.6.34/sql/sql_table.cc:5085
#20 0x00000000008729d8 in mysql_create_table (thd=0x3a4fca0, create_table=0x7f388c005100, create_info=0x7f38bfbbd610, alter_info=0x7f38bfbbd060)
    at /export/home/pb2/build/sb_0-20604842-1475238842.11/mysqlcom-pro-5.6.34/sql/sql_table.cc:5134
#21 0x00000000007fed2c in mysql_execute_command (thd=0x3a4fca0) at /export/home/pb2/build/sb_0-20604842-1475238842.11/mysqlcom-pro-5.6.34/sql/sql_parse.cc:3067
#22 0x00000000008053c2 in mysql_parse (thd=0x3a4fca0, rawbuf=0x7f388c004fd0 "create temporary table tm_temp_temp(i int)ENGINE=InnoDB", length=55, parser_state=0x7f38bfbbe700)
    at /export/home/pb2/build/sb_0-20604842-1475238842.11/mysqlcom-pro-5.6.34/sql/sql_parse.cc:6385
#23 0x0000000000806fc3 in dispatch_command (command=COM_QUERY, thd=0x3a4fca0, packet=0x3b7e3a1 "create temporary table tm_temp_temp(i int)ENGINE=InnoDB", packet_length=55)
    at /export/home/pb2/build/sb_0-20604842-1475238842.11/mysqlcom-pro-5.6.34/sql/sql_parse.cc:1339
#24 0x000000000080884b in do_command (thd=0x3a4fca0) at /export/home/pb2/build/sb_0-20604842-1475238842.11/mysqlcom-pro-5.6.34/sql/sql_parse.cc:1036
#25 0x00000000007bd46d in do_handle_one_connection (thd_arg=0x3a4fca0) at /export/home/pb2/build/sb_0-20604842-1475238842.11/mysqlcom-pro-5.6.34/sql/sql_connect.cc:982
#26 0x00000000007bd533 in handle_one_connection (arg=0x3a4fca0) at /export/home/pb2/build/sb_0-20604842-1475238842.11/mysqlcom-pro-5.6.34/sql/sql_connect.cc:898
#27 0x0000000000d92aba in pfs_spawn_thread (arg=0x3a70dc0) at /export/home/pb2/build/sb_0-20604842-1475238842.11/mysqlcom-pro-5.6.34/storage/perfschema/pfs.cc:1860
#28 0x00007f38ea2c2df5 in start_thread () from /lib64/libpthread.so.0
#29 0x00007f38e8f8e60d in clone () from /lib64/libc.so.6
(gdb)
[14 Nov 2016 4:48] MySQL Verification Team
-- 5.7.16 debug not affected

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.16: bin/mysqld-debug --no-defaults --basedir=/export/umesh/server/binaries/GABuilds/mysql-5.7.16 --datadir=/export/umesh/server/binaries/GABuilds/mysql-5.7.16/74873 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=/export/umesh/server/binaries/GABuilds/mysql-5.7.16/74873/log.err 2>&1 &
[1] 9437
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.16: bin/mysql -uroot -S /tmp/mysql_ushastry.sock                                                                                 Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.16-debug MySQL Community Server - Debug (GPL)

Copyright (c) 2000, 2016, 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.

root@localhost [(none)]> 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
root@localhost [test]> SET SESSION debug="+d,dict_tf_to_fsp_flags_failure";
Query OK, 0 rows affected (0.00 sec)

root@localhost [test]> create temporary table tm_temp_temp(i int)ENGINE=InnoDB;
Query OK, 0 rows affected (0.00 sec)

root@localhost [test]>
[21 Jan 2017 1:14] Roel Van de Paar
See bug 84593 and bug 73926