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: | |
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
[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]>