Bug #76430 InnoDB: Failing assertion: (&dict_sys->mutex)->is_owned() | file dict0priv.ic 44
Submitted: 22 Mar 2015 22:26 Modified: 1 Apr 2015 4:21
Reporter: Roel Van de Paar Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: DML Severity:S6 (Debug Builds)
Version:5.7.6-m16, 5.7.6, 5.7.8, 8.0.0 OS:Any
Assigned to: CPU Architecture:Any

[22 Mar 2015 22:26] Roel Van de Paar
Description:
2015-03-22T22:23:10.708540Z 0 [Note] /sda/MS-mysql-5.7.6-m16-linux-x86_64-debug/bin/mysqld: ready for connections.
Version: '5.7.6-m16-debug'  socket: '/sda/MS-mysql-5.7.6-m16-linux-x86_64-debug/socket.sock'  port: 10430  MySQL Community Server (GPL)
2015-03-23 09:23:13 0x7f074d027700  InnoDB: Assertion failure in thread 139669333505792 in file dict0priv.ic line 44
InnoDB: Failing assertion: (&dict_sys->mutex)->is_owned()

+bt
#0  0x00007f074ca2e771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x00000000013a521c in my_write_core (sig=6) at /bzr/mysql-5.7.6-m16_dbg/mysys/stacktrace.c:247
#2  0x0000000000bb713c in handle_fatal_signal (sig=6) at /bzr/mysql-5.7.6-m16_dbg/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x00007f074b6325c9 in raise () from /lib64/libc.so.6
#5  0x00007f074b633cd8 in abort () from /lib64/libc.so.6
#6  0x00000000016c790b in ut_dbg_assertion_failed (expr=0x1c84858 "(&dict_sys->mutex)->is_owned()", file=0x1c84a30 "/bzr/mysql-5.7.6-m16_dbg/storage/innobase/include/dict0priv.ic", line=44) at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/ut/ut0dbg.cc:67
#7  0x00000000017640a6 in dict_table_get_low (table_name=0x7f06a84930a8 "data/t") at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/include/dict0priv.ic:44
#8  0x000000000176e3c5 in dict_get_referenced_table (name=0x7f074d0239f0 "data/#sql_6f56_0", database_name=0x0, database_name_len=4, table_name=0x7f06a84930a0 "t", table_name_len=1, table=0x7f074d023490, heap=0x7f06a8493010) at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/dict/dict0dict.cc:4109
#9  0x000000000176e548 in dict_scan_table_name (cs=0x2626ca0 <my_charset_utf8_general_ci>, ptr=0x7f06a84504dd " TRUNCATE PARTITION a", table=0x7f074d023490, name=0x7f074d0239f0 "data/#sql_6f56_0", success=0x7f074d023470, heap=0x7f06a8493010, ref_name=0x7f074d023468) at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/dict/dict0dict.cc:4183
#10 0x000000000176eeb7 in dict_create_foreign_constraints_low (trx=0x7f073ec00d50, heap=0x7f06a8493010, cs=0x2626ca0 <my_charset_utf8_general_ci>, sql_string=0x7f06a84504d0 "ALTER TABLE t TRUNCATE PARTITION a", name=0x7f074d0239f0 "data/#sql_6f56_0", handler=0x7f06a849c318, reject_fks=1) at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/dict/dict0dict.cc:4503
#11 0x000000000177063b in dict_create_foreign_constraints (trx=0x7f073ec00d50, sql_string=0x7f06a842c020 "ALTER TABLE t TRUNCATE PARTITION a", sql_length=34, name=0x7f074d0239f0 "data/#sql_6f56_0", handler=0x7f06a849c318, reject_fks=1) at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/dict/dict0dict.cc:5086
#12 0x000000000160ab90 in row_table_add_foreign_constraints (trx=0x7f073ec00d50, sql_string=0x7f06a842c020 "ALTER TABLE t TRUNCATE PARTITION a", sql_length=34, name=0x7f074d0239f0 "data/#sql_6f56_0", is_temp_table=true, handler=0x7f06a849c318, reject_fks=1) at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/row/row0mysql.cc:3269
#13 0x00000000014ddb38 in create_table_info_t::create_table (this=0x7f074d0238d0) at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/handler/ha_innodb.cc:10472
#14 0x00000000014de1e4 in ha_innobase::create (this=0x7f06a84af820, name=0x7f06a8499350 "/sda/MS-mysql-5.7.6-m16-linux-x86_64-debug/data/#sql_6f56_0", form=0x7f06a8498020, create_info=0x7f074d024070) at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/handler/ha_innodb.cc:10682
#15 0x00000000011480d7 in create_innodb_tmp_table (table=0x7f06a8498020, keyinfo=0x7f06a8498e30) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_tmp_table.cc:2174
#16 0x000000000114851b in instantiate_tmp_table (table=0x7f06a8498020, keyinfo=0x7f06a8498e30, start_recinfo=0x7f06a8498ed0, recinfo=0x7f06a8497a48, options=4096, big_tables=0 '\000', trace=0x7f06a841c048) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_tmp_table.cc:2269
#17 0x0000000001145fc7 in create_tmp_table (thd=0x7f06a841a000, param=0x7f06a8497a08, fields=..., group=0x0, distinct=false, save_sum_fields=false, select_options=4096, rows_limit=18446744073709551615, table_alias=0x7f06a8496ac0 "VIEWS") at /bzr/mysql-5.7.6-m16_dbg/sql/sql_tmp_table.cc:1438
#18 0x00000000011199c3 in create_schema_table (thd=0x7f06a841a000, table_list=0x7f06a8496ac8) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_show.cc:7352
#19 0x000000000111a75a in mysql_schema_table (thd=0x7f06a841a000, lex=0x7f06a841c068, table_list=0x7f06a8496ac8) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_show.cc:7581
#20 0x0000000001026cfe in open_and_process_table (thd=0x7f06a841a000, lex=0x7f06a841c068, tables=0x7f06a8496ac8, counter=0x7f074d024bcc, flags=0, prelocking_strategy=0x7f074d024b50, has_prelocking_list=false, ot_ctx=0x7f074d024a80) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_base.cc:4840
#21 0x0000000001028223 in open_tables (thd=0x7f06a841a000, start=0x7f074d024bd0, counter=0x7f074d024bcc, flags=0, prelocking_strategy=0x7f074d024b50) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_base.cc:5539
#22 0x0000000001032d50 in open_tables (thd=0x7f06a841a000, tables=0x7f074d024bd0, counter=0x7f074d024bcc, flags=0) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_base.h:458
#23 0x00000000012b4a73 in Sql_cmd_alter_table_truncate_partition::execute (this=0x7f06a842cf70, thd=0x7f06a841a000) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_partition_admin.cc:754
#24 0x00000000010a917e in mysql_execute_command (thd=0x7f06a841a000) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_parse.cc:4452
#25 0x00000000010aae7a in mysql_parse (thd=0x7f06a841a000, parser_state=0x7f074d025e00) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_parse.cc:5129
#26 0x00000000010a0bd4 in dispatch_command (command=COM_QUERY, thd=0x7f06a841a000, packet=0x7f06a8446011 "ALTER TABLE t TRUNCATE PARTITION a", packet_length=34) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_parse.cc:1249
#27 0x000000000109f925 in do_command (thd=0x7f06a841a000) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_parse.cc:835
#28 0x00000000011c2fd9 in handle_connection (arg=0x7f07437f78c0) at /bzr/mysql-5.7.6-m16_dbg/sql/conn_handler/connection_handler_per_thread.cc:298
#29 0x00000000013d2299 in pfs_spawn_thread (arg=0x7f07447b2d50) at /bzr/mysql-5.7.6-m16_dbg/storage/perfschema/pfs.cc:2147
#30 0x00007f074ca29df3 in start_thread () from /lib64/libpthread.so.0
#31 0x00007f074b6f31ad in clone () from /lib64/libc.so.6

How to repeat:
DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE VIEW t AS SELECT table_name FROM INFORMATION_SCHEMA.VIEWS;
ALTER TABLE t TRUNCATE PARTITION a;
[23 Mar 2015 7:15] MySQL Verification Team
Hello Roel,

Thank you for the report and test case.
Confirmed that 5.7.6, 5.7.8 debug builds are affected.

Thanks,
Umesh
[23 Mar 2015 7:15] MySQL Verification Team
// 5.7.6 - only debug build affected

bin/mysql_install_db --basedir=/export/umesh/mysql-5.7.6 --datadir=/export/umesh/mysql-5.7.6/76430 -v
bin/mysqld-debug --basedir=/export/umesh/mysql-5.7.6 --datadir=/export/umesh/mysql-5.7.6/76430 --sql_mode=ONLY_FULL_GROUP_BY --core-file --socket=/tmp/mysql_ushastry.sock  --port=15000 --log-error=/export/umesh/mysql-5.7.6/76430/log.err 2>&1 &

- build

commit: e1298eb6a8e2247361533811930a07fde7aff618
date: 2015-02-26 15:29:31 +0100
build-date: 2015-02-26 15:35:58 +0100
short: e1298eb
branch: mysql-5.7.6-m16-release

MySQL source 5.7.6

(gdb) bt
#0  0x00007fdc69311771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x00000000013ee069 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/mysys/stacktrace.c:247
#2  0x0000000000bdeba0 in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x00007fdc67f175c9 in raise () from /lib64/libc.so.6
#5  0x00007fdc67f18cd8 in abort () from /lib64/libc.so.6
#6  0x000000000160d6bb in ut_dbg_assertion_failed (expr=0x1cb6758 "(&dict_sys->mutex)->is_owned()",
    file=0x1cb69b0 "/export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/include/dict0priv.ic", line=44)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/ut/ut0dbg.cc:67
#7  0x00000000016ab2f0 in dict_table_get_low (table_name=0x7fdbec027018 "tmp/t") at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/include/dict0priv.ic:44
#8  0x00000000016b574b in dict_get_referenced_table (name=0x7fdc5db37dd0 "tmp/#sql_6432_0", database_name=0x0, database_name_len=3, table_name=0x7fdbec027010 "t", table_name_len=1,
    table=0x7fdc5db37570, heap=0x7fdbec026f80) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/dict/dict0dict.cc:4109
#9  0x00000000016b58e3 in dict_scan_table_name (cs=0x26d5900 <my_charset_utf8_general_ci>, ptr=0x7fdbec026e5d " TRUNCATE PARTITION a", table=0x7fdc5db37570,
    name=0x7fdc5db37dd0 "tmp/#sql_6432_0", success=0x7fdc5db37550, heap=0x7fdbec026f80, ref_name=0x7fdc5db37548)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/dict/dict0dict.cc:4183
#10 0x00000000016b624a in dict_create_foreign_constraints_low (trx=0x7fdc5eefdd60, heap=0x7fdbec026f80, cs=0x26d5900 <my_charset_utf8_general_ci>,
    sql_string=0x7fdbec026e50 "ALTER TABLE t TRUNCATE PARTITION a", name=0x7fdc5db37dd0 "tmp/#sql_6432_0", handler=0x7fdbec00ffa8, reject_fks=1)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/dict/dict0dict.cc:4503
#11 0x00000000016b7a93 in dict_create_foreign_constraints (trx=0x7fdc5eefdd60, sql_string=0x7fdbec005220 "ALTER TABLE t TRUNCATE PARTITION a", sql_length=34,
    name=0x7fdc5db37dd0 "tmp/#sql_6432_0", handler=0x7fdbec00ffa8, reject_fks=1) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/dict/dict0dict.cc:5086
#12 0x0000000001550245 in row_table_add_foreign_constraints (trx=0x7fdc5eefdd60, sql_string=0x7fdbec005220 "ALTER TABLE t TRUNCATE PARTITION a", sql_length=34,
    name=0x7fdc5db37dd0 "tmp/#sql_6432_0", is_temp_table=true, handler=0x7fdbec00ffa8, reject_fks=1)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/row/row0mysql.cc:3269
#13 0x00000000014220d0 in create_table_info_t::create_table (this=0x7fdc5db38090)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/handler/ha_innodb.cc:10472
#14 0x0000000001422785 in ha_innobase::create (this=0x7fdbec00fa20, name=0x7fdbec01d1c0 "/tmp/#sql_6432_0", form=0x7fdbec01bed0, create_info=0x7fdc5db38170)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/handler/ha_innodb.cc:10682
#15 0x0000000001188c4c in create_innodb_tmp_table (table=0x7fdbec01bed0, keyinfo=0x7fdbec01cca0) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_tmp_table.cc:2174
#16 0x000000000118909c in instantiate_tmp_table (table=0x7fdbec01bed0, keyinfo=0x7fdbec01cca0, start_recinfo=0x7fdbec01cd40, recinfo=0x7fdbec01b8f8, options=4096, big_tables=0 '\000',
    trace=0x7fdbec002a70) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_tmp_table.cc:2269
#17 0x0000000001186a97 in create_tmp_table (thd=0x7fdbec000bb0, param=0x7fdbec01b8b8, fields=..., group=0x0, distinct=false, save_sum_fields=false, select_options=4096,
    rows_limit=18446744073709551615, table_alias=0x7fdbec01a970 "VIEWS") at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_tmp_table.cc:1438
#18 0x0000000001159b7c in create_schema_table (thd=0x7fdbec000bb0, table_list=0x7fdbec01a978) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_show.cc:7352
#19 0x000000000115a8ae in mysql_schema_table (thd=0x7fdbec000bb0, lex=0x7fdbec002a90, table_list=0x7fdbec01a978)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_show.cc:7581
#20 0x0000000001062d82 in open_and_process_table (thd=0x7fdbec000bb0, lex=0x7fdbec002a90, tables=0x7fdbec01a978, counter=0x7fdc5db38d3c, flags=0, prelocking_strategy=0x7fdc5db38cc0,
    has_prelocking_list=false, ot_ctx=0x7fdc5db38bd0) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_base.cc:4840
#21 0x00000000010642f7 in open_tables (thd=0x7fdbec000bb0, start=0x7fdc5db38d40, counter=0x7fdc5db38d3c, flags=0, prelocking_strategy=0x7fdc5db38cc0)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_base.cc:5539
#22 0x000000000106f21b in open_tables (thd=0x7fdbec000bb0, tables=0x7fdc5db38d40, counter=0x7fdc5db38d3c, flags=0)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_base.h:458
#23 0x00000000012fd357 in Sql_cmd_alter_table_truncate_partition::execute (this=0x7fdbec006170, thd=0x7fdbec000bb0)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_partition_admin.cc:754
#24 0x00000000010e7cff in mysql_execute_command (thd=0x7fdbec000bb0) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_parse.cc:4452
#25 0x00000000010e9a6f in mysql_parse (thd=0x7fdbec000bb0, parser_state=0x7fdc5db3a5d0) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_parse.cc:5129
#26 0x00000000010debc8 in dispatch_command (command=COM_QUERY, thd=0x7fdbec000bb0, packet=0x7fdbec009ce1 "ALTER TABLE t TRUNCATE PARTITION a", packet_length=34)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_parse.cc:1249
#27 0x00000000010dd693 in do_command (thd=0x7fdbec000bb0) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_parse.cc:835
#28 0x000000000120444f in handle_connection (arg=0x3be6c90) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/conn_handler/connection_handler_per_thread.cc:298
#29 0x00000000017770f1 in pfs_spawn_thread (arg=0x3c11b60) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/perfschema/pfs.cc:2147
#30 0x00007fdc6930cdf3 in start_thread () from /lib64/libpthread.so.0
#31 0x00007fdc67fd847d in clone () from /lib64/libc.so.6
[23 Mar 2015 7:16] MySQL Verification Team
// 5.7.8 - only debug build affected

bin/mysql_install_db --basedir=/export/umesh/mysql-5.7.8 --datadir=/export/umesh/mysql-5.7.8/76430 -v
bin/mysqld-debug --basedir=/export/umesh/mysql-5.7.8 --datadir=/export/umesh/mysql-5.7.8/76430 --sql_mode=ONLY_FULL_GROUP_BY --core-file --socket=/tmp/mysql_ushastry.sock  --port=15000 --log-error=/export/umesh/mysql-5.7.8/76430/log.err 2>&1 &

- build

commit: 91153f3385c4917a215aa4c7818b3f6265608286
date: 2015-03-20 14:48:27 +0100
build-date: 2015-03-20 18:03:24 +0100
short: 91153f3
branch: mysql-5.7

MySQL source 5.7.8

(gdb) bt
#0  0x00007f7466bd2771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x00000000018c6688 in my_write_core (sig=6) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/mysys/stacktrace.c:247
#2  0x0000000000f4b39e in handle_fatal_signal (sig=6) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x00007f74657d85c9 in raise () from /lib64/libc.so.6
#5  0x00007f74657d9cd8 in abort () from /lib64/libc.so.6
#6  0x0000000001ae4b43 in ut_dbg_assertion_failed (expr=0x22b80f0 "(&dict_sys->mutex)->is_owned()",
    file=0x22b8358 "/export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/include/dict0priv.ic", line=44)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/ut/ut0dbg.cc:67
#7  0x0000000001b81726 in dict_table_get_low (table_name=0x7f73e0037198 "tmp/t")
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/include/dict0priv.ic:44
#8  0x0000000001b8ba45 in dict_get_referenced_table (name=0x7f745c3f9a20 "tmp/#sql_6499_0", database_name=0x0, database_name_len=3, table_name=0x7f73e0037190 "t", table_name_len=1,
    table=0x7f745c3f94c0, heap=0x7f73e0037100) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/dict/dict0dict.cc:4109
#9  0x0000000001b8bbc8 in dict_scan_table_name (cs=0x2d8b2e0 <my_charset_utf8_general_ci>, ptr=0x7f73e0010e2d " TRUNCATE PARTITION a", table=0x7f745c3f94c0,
    name=0x7f745c3f9a20 "tmp/#sql_6499_0", success=0x7f745c3f94a0, heap=0x7f73e0037100, ref_name=0x7f745c3f9498)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/dict/dict0dict.cc:4183
#10 0x0000000001b8c537 in dict_create_foreign_constraints_low (trx=0x7f745c7bed60, heap=0x7f73e0037100, cs=0x2d8b2e0 <my_charset_utf8_general_ci>,
    sql_string=0x7f73e0010e20 "ALTER TABLE t TRUNCATE PARTITION a", name=0x7f745c3f9a20 "tmp/#sql_6499_0", handler=0x7f73e0021fd8, reject_fks=1)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/dict/dict0dict.cc:4503
#11 0x0000000001b8dcbb in dict_create_foreign_constraints (trx=0x7f745c7bed60, sql_string=0x7f73e00052f0 "ALTER TABLE t TRUNCATE PARTITION a", sql_length=34,
    name=0x7f745c3f9a20 "tmp/#sql_6499_0", handler=0x7f73e0021fd8, reject_fks=1)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/dict/dict0dict.cc:5086
#12 0x0000000001a27862 in row_table_add_foreign_constraints (trx=0x7f745c7bed60, sql_string=0x7f73e00052f0 "ALTER TABLE t TRUNCATE PARTITION a", sql_length=34,
    name=0x7f745c3f9a20 "tmp/#sql_6499_0", is_temp_table=true, handler=0x7f73e0021fd8, reject_fks=1)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/row/row0mysql.cc:3284
#13 0x00000000018f9804 in create_table_info_t::create_table (this=0x7f745c3f9900)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/handler/ha_innodb.cc:10559
#14 0x00000000018f9eb0 in ha_innobase::create (this=0x7f73e0021b60, name=0x7f73e0021b10 "/tmp/#sql_6499_0", form=0x7f73e0020820, create_info=0x7f745c3fa0a0)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/handler/ha_innodb.cc:10769
#15 0x0000000001664ba9 in create_innodb_tmp_table (table=0x7f73e0020820, keyinfo=0x7f73e00215f0)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_tmp_table.cc:2226
#16 0x0000000001664fed in instantiate_tmp_table (table=0x7f73e0020820, keyinfo=0x7f73e00215f0, start_recinfo=0x7f73e0021690, recinfo=0x7f73e002bd28, options=4096, big_tables=0 '\000',
    trace=0x7f73e0002b40) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_tmp_table.cc:2321
#17 0x0000000001662ae4 in create_tmp_table (thd=0x7f73e0000bb0, param=0x7f73e002bce8, fields=..., group=0x0, distinct=false, save_sum_fields=false, select_options=4096,
    rows_limit=18446744073709551615, table_alias=0x7f73e002ad90 "VIEWS") at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_tmp_table.cc:1493
#18 0x00000000016363e9 in create_schema_table (thd=0x7f73e0000bb0, table_list=0x7f73e002ad98) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_show.cc:7355
#19 0x0000000001637180 in mysql_schema_table (thd=0x7f73e0000bb0, lex=0x7f73e0002b60, table_list=0x7f73e002ad98)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_show.cc:7584
#20 0x0000000001541fb3 in open_and_process_table (thd=0x7f73e0000bb0, lex=0x7f73e0002b60, tables=0x7f73e002ad98, counter=0x7f745c3fabfc, flags=0, prelocking_strategy=0x7f745c3fab80,
    has_prelocking_list=false, ot_ctx=0x7f745c3faab0) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_base.cc:4829
#21 0x00000000015434d8 in open_tables (thd=0x7f73e0000bb0, start=0x7f745c3fac00, counter=0x7f745c3fabfc, flags=0, prelocking_strategy=0x7f745c3fab80)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_base.cc:5528
#22 0x000000000154e0bc in open_tables (thd=0x7f73e0000bb0, tables=0x7f745c3fac00, counter=0x7f745c3fabfc, flags=0)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_base.h:457
#23 0x00000000017d64eb in Sql_cmd_alter_table_truncate_partition::execute (this=0x7f73e0006268, thd=0x7f73e0000bb0)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_partition_admin.cc:754
#24 0x00000000015c5a14 in mysql_execute_command (thd=0x7f73e0000bb0) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:4495
#25 0x00000000015c78b1 in mysql_parse (thd=0x7f73e0000bb0, parser_state=0x7f745c3fbe50) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:5201
#26 0x00000000015bd46c in dispatch_command (thd=0x7f73e0000bb0, com_data=0x7f745c3fce00, command=COM_QUERY)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:1280
#27 0x00000000015bc0bf in do_command (thd=0x7f73e0000bb0) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:851
#28 0x00000000016e052e in handle_connection (arg=0x3f1aa30) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/conn_handler/connection_handler_per_thread.cc:299
#29 0x0000000001ce1375 in pfs_spawn_thread (arg=0x3e04840) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/perfschema/pfs.cc:2147
#30 0x00007f7466bcddf3 in start_thread () from /lib64/libpthread.so.0
#31 0x00007f746589947d in clone () from /lib64/libc.so.6
[23 Mar 2015 7:18] MySQL Verification Team
// 5.8.0 - only debug build affected

bin/mysql_install_db --basedir=/export/umesh/mysql-5.8.0 --datadir=/export/umesh/mysql-5.8.0/76430 -v
bin/mysqld-debug --basedir=/export/umesh/mysql-5.8.0 --datadir=/export/umesh/mysql-5.8.0/76430 --core-file --socket=/tmp/mysql_ushastry.sock  --port=15000 --log-error=/export/umesh/mysql-5.8.0/76430/log.err 2>&1 &

- build

commit: b48798db34fbcaf5dbb5c8ae7ef738afeb60eccc
date: 2015-03-20 14:52:33 +0100
build-date: 2015-03-20 17:03:10 +0100
short: b48798d
branch: mysql-trunk

MySQL source 5.8.0

(gdb) bt
#0  0x00007fde60ddc771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x00000000018b3108 in my_write_core (sig=6) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/mysys/stacktrace.c:247
#2  0x0000000000f3d9fb in handle_fatal_signal (sig=6) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/signal_handler.cc:221
#3  <signal handler called>
#4  0x00007fde5f9e25c9 in raise () from /lib64/libc.so.6
#5  0x00007fde5f9e3cd8 in abort () from /lib64/libc.so.6
#6  0x0000000001af2303 in ut_dbg_assertion_failed (expr=0x22a5880 "(&dict_sys->mutex)->is_owned()",
    file=0x22a5af0 "/export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/storage/innobase/include/dict0priv.ic", line=44)
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/storage/innobase/ut/ut0dbg.cc:67
#7  0x0000000001b8ee1b in dict_table_get_low (table_name=0x7fdddc0370c8 "tmp/t")
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/storage/innobase/include/dict0priv.ic:44
#8  0x0000000001b99130 in dict_get_referenced_table (name=0x7fde55602a20 "tmp/#sql_6652_0", database_name=0x0, database_name_len=3, table_name=0x7fdddc0370c0 "t", table_name_len=1,
    table=0x7fde556024c0, heap=0x7fdddc037030) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/storage/innobase/dict/dict0dict.cc:4101
#9  0x0000000001b992b3 in dict_scan_table_name (cs=0x2d68a00 <my_charset_utf8_general_ci>, ptr=0x7fdddc00ff9d " TRUNCATE PARTITION a", table=0x7fde556024c0,
    name=0x7fde55602a20 "tmp/#sql_6652_0", success=0x7fde556024a0, heap=0x7fdddc037030, ref_name=0x7fde55602498)
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/storage/innobase/dict/dict0dict.cc:4175
#10 0x0000000001b99c22 in dict_create_foreign_constraints_low (trx=0x7fde569c8d60, heap=0x7fdddc037030, cs=0x2d68a00 <my_charset_utf8_general_ci>,
    sql_string=0x7fdddc00ff90 "ALTER TABLE t TRUNCATE PARTITION a", name=0x7fde55602a20 "tmp/#sql_6652_0", handler=0x7fdddc010ea8, reject_fks=1)
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/storage/innobase/dict/dict0dict.cc:4495
#11 0x0000000001b9b3a6 in dict_create_foreign_constraints (trx=0x7fde569c8d60, sql_string=0x7fdddc0052f0 "ALTER TABLE t TRUNCATE PARTITION a", sql_length=34,
    name=0x7fde55602a20 "tmp/#sql_6652_0", handler=0x7fdddc010ea8, reject_fks=1)
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/storage/innobase/dict/dict0dict.cc:5078
#12 0x0000000001a35c14 in row_table_add_foreign_constraints (trx=0x7fde569c8d60, sql_string=0x7fdddc0052f0 "ALTER TABLE t TRUNCATE PARTITION a", sql_length=34,
    name=0x7fde55602a20 "tmp/#sql_6652_0", is_temp_table=true, handler=0x7fdddc010ea8, reject_fks=1)
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/storage/innobase/row/row0mysql.cc:3284
#13 0x000000000190893c in create_table_info_t::create_table (this=0x7fde55602900)
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/storage/innobase/handler/ha_innodb.cc:10374
#14 0x0000000001908fc4 in ha_innobase::create (this=0x7fdddc02b9b0, name=0x7fdddc02b560 "/tmp/#sql_6652_0", form=0x7fdddc02a270, create_info=0x7fde556030a0)
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/storage/innobase/handler/ha_innodb.cc:10575
#15 0x000000000164edc1 in create_innodb_tmp_table (table=0x7fdddc02a270, keyinfo=0x7fdddc02b040)
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/sql_tmp_table.cc:2229
#16 0x000000000164f205 in instantiate_tmp_table (table=0x7fdddc02a270, keyinfo=0x7fdddc02b040, start_recinfo=0x7fdddc02b0e0, recinfo=0x7fdddc0222a8, options=4096, big_tables=0 '\000',
    trace=0x7fdddc002b40) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/sql_tmp_table.cc:2324
#17 0x000000000164ccfc in create_tmp_table (thd=0x7fdddc000bb0, param=0x7fdddc022268, fields=..., group=0x0, distinct=false, save_sum_fields=false, select_options=4096,
    rows_limit=18446744073709551615, table_alias=0x7fdddc021310 "VIEWS") at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/sql_tmp_table.cc:1496
#18 0x000000000161f3af in create_schema_table (thd=0x7fdddc000bb0, table_list=0x7fdddc021318) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/sql_show.cc:7360
#19 0x0000000001620146 in mysql_schema_table (thd=0x7fdddc000bb0, lex=0x7fdddc002b60, table_list=0x7fdddc021318)
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/sql_show.cc:7589
#20 0x000000000152ffbf in open_and_process_table (thd=0x7fdddc000bb0, lex=0x7fdddc002b60, tables=0x7fdddc021318, counter=0x7fde55603bfc, flags=0, prelocking_strategy=0x7fde55603b80,
    has_prelocking_list=false, ot_ctx=0x7fde55603ab0) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/sql_base.cc:4666
#21 0x00000000015314e4 in open_tables (thd=0x7fdddc000bb0, start=0x7fde55603c00, counter=0x7fde55603bfc, flags=0, prelocking_strategy=0x7fde55603b80)
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/sql_base.cc:5365
#22 0x000000000153bc85 in open_tables (thd=0x7fdddc000bb0, tables=0x7fde55603c00, counter=0x7fde55603bfc, flags=0)
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/sql_base.h:463
#23 0x00000000017c33af in Sql_cmd_alter_table_truncate_partition::execute (this=0x7fdddc006268, thd=0x7fdddc000bb0)
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/sql_partition_admin.cc:757
#24 0x00000000015aeb81 in mysql_execute_command (thd=0x7fdddc000bb0) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:4450
#25 0x00000000015b0a1d in mysql_parse (thd=0x7fdddc000bb0, parser_state=0x7fde55604e50) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:5158
#26 0x00000000015a66e6 in dispatch_command (thd=0x7fdddc000bb0, com_data=0x7fde55605e00, command=COM_QUERY)
    at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:1245
#27 0x00000000015a5335 in do_command (thd=0x7fdddc000bb0) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:814
#28 0x00000000016ca436 in handle_connection (arg=0x5257bb0) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/sql/conn_handler/connection_handler_per_thread.cc:300
#29 0x0000000001c59c8d in pfs_spawn_thread (arg=0x515ddc0) at /export/home3/pb2/build/sb_0-14764689-1426868485.86/mysqlcom-pro-5.8.0-m17/storage/perfschema/pfs.cc:2147
#30 0x00007fde60dd7df3 in start_thread () from /lib64/libpthread.so.0
#31 0x00007fde5faa347d in clone () from /lib64/libc.so.6
(gdb)
[23 Mar 2015 7:20] MySQL Verification Team
// 5.6.25 debug/release build not affected
[23 Mar 2015 8:15] Sunny Bains
Duplicate of an internally reported bug.
[1 Apr 2015 4:21] Erlend Dahl
[23 Mar 2015 10:50] Daniel T Price

Fixed as of the upcoming 5.7.8, 5.8.0 releases, and here's the changelog
entry:

An assertion was raised when an "ALTER TABLE" operation invoked obsolete
foreign key code while attempting to create an intrinsic temporary table
as part of an optimizer plan. Temporary tables do not support foreign
keys. Invocation of foreign key code is now blocked for intrinsic
temporary tables.
[18 Jun 2016 21:25] Omer Barnir
Posted by developer:
 
Reported version value updated to reflect release name change from 5.8 to 8.0