Bug #83796 Assertion `! is_set()' failed.
Submitted: 14 Nov 2016 1:56 Modified: 14 Nov 2016 6:01
Reporter: Roel Van de Paar Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DDL Severity:S6 (Debug Builds)
Version:5.6.34, 5.7.16 OS:Any
Assigned to: CPU Architecture:Any
Tags: debug

[14 Nov 2016 1:56] Roel Van de Paar
Description:
Version: '5.6.34-debug'  socket: '/sda/MS081116-mysql-5.6.34-linux-x86_64-debug/socket.sock'  port: 11652  MySQL Community Server (GPL)
mysqld: /git/mysql-server_dbg/sql/sql_error.cc:430: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `! is_set()' failed.
01:36:20 UTC - mysqld got signal 6 ;

(gdb) bt
#0  0x00007f1d3a329741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1  0x0000000000a9c852 in my_write_core (sig=6) at /git/mysql-server_dbg/mysys/stacktrace.c:422
#2  0x000000000072c554 in handle_fatal_signal (sig=6) at /git/mysql-server_dbg/sql/signal_handler.cc:230
#3  <signal handler called>
#4  0x00007f1d388c85f7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5  0x00007f1d388c9ce8 in __GI_abort () at abort.c:90
#6  0x00007f1d388c1566 in __assert_fail_base (fmt=0x7f1d38a11ce8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0xe7e85e "! is_set()",
    file=file@entry=0xe7e688 "/git/mysql-server_dbg/sql/sql_error.cc", line=line@entry=430,
    function=function@entry=0xe7ec20 <Diagnostics_area::set_ok_status(unsigned long long, unsigned long long, char const*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:92
#7  0x00007f1d388c1612 in __GI___assert_fail (assertion=0xe7e85e "! is_set()", file=0xe7e688 "/git/mysql-server_dbg/sql/sql_error.cc", line=430,
    function=0xe7ec20 <Diagnostics_area::set_ok_status(unsigned long long, unsigned long long, char const*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:101
#8  0x00000000007a56ce in Diagnostics_area::set_ok_status (this=0x7f1d11b8a030, affected_rows=0, last_insert_id=0, message=0x0) at /git/mysql-server_dbg/sql/sql_error.cc:430
#9  0x00000000007633bc in my_ok (thd=0x7f1d11b87000, affected_rows=0, id=0, message=0x0) at /git/mysql-server_dbg/sql/sql_class.h:4231
#10 0x000000000083d3c6 in mysql_rm_table (thd=0x7f1d11b87000, tables=0x7f1d0541f110, if_exists=1 '\001', drop_temporary=0 '\000') at /git/mysql-server_dbg/sql/sql_table.cc:2212
#11 0x00000000007dba98 in mysql_execute_command (thd=0x7f1d11b87000) at /git/mysql-server_dbg/sql/sql_parse.cc:3647
#12 0x00000000007e2d7e in mysql_parse (thd=0x7f1d11b87000, rawbuf=0x7f1d0541f010 "DROP TABLE IF EXISTS nodbhere.t", length=31, parser_state=0x7f1d3a91d5a0)
    at /git/mysql-server_dbg/sql/sql_parse.cc:6385
#13 0x00000000007d5faf in dispatch_command (command=COM_QUERY, thd=0x7f1d11b87000, packet=0x7f1d11b6b001 "DROP TABLE IF EXISTS nodbhere.t", packet_length=31)
    at /git/mysql-server_dbg/sql/sql_parse.cc:1339
#14 0x00000000007d5016 in do_command (thd=0x7f1d11b87000) at /git/mysql-server_dbg/sql/sql_parse.cc:1036
#15 0x000000000079c9a5 in do_handle_one_connection (thd_arg=0x7f1d11b87000) at /git/mysql-server_dbg/sql/sql_connect.cc:982
#16 0x000000000079c48e in handle_one_connection (arg=0x7f1d11b87000) at /git/mysql-server_dbg/sql/sql_connect.cc:898
#17 0x0000000000ae8ac9 in pfs_spawn_thread (arg=0x7f1d1d7896a0) at /git/mysql-server_dbg/storage/perfschema/pfs.cc:1860
#18 0x00007f1d3a324dc5 in start_thread (arg=0x7f1d3a91e700) at pthread_create.c:308
#19 0x00007f1d38989ced in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

How to repeat:
SET SESSION DEBUG="+d,bug43138";
DROP TABLE IF EXISTS nodbhere.t;
[14 Nov 2016 6:01] MySQL Verification Team
Hello Roel,

Thank you for the report and test case.
Observed that 5.6.34/5.7.16 debug builds are affected.

Thanks,
Umesh