Bug #75003 | Assertion `bitmap_is_set_all(&table->s->all_set)' failed int handler::ha_reset() | ||
---|---|---|---|
Submitted: | 26 Nov 2014 2:45 | Modified: | 26 Nov 2014 9:42 |
Reporter: | Ramesh Sivaraman | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: DDL | Severity: | S3 (Non-critical) |
Version: | 5.6.21, 5.6.23 | OS: | Linux (CentOS 7) |
Assigned to: | CPU Architecture: | Any | |
Tags: | debug |
[26 Nov 2014 2:45]
Ramesh Sivaraman
[26 Nov 2014 9:42]
MySQL Verification Team
Hello Ramesh Sivaraman, Thank you for the bug report and test case. Verified as described with 5.6.23 debug build. Thanks, Umesh
[26 Nov 2014 9:51]
MySQL Verification Team
// 5.6.23 only debug build affected (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 0x0000003deac2b74e in __assert_fail_base (fmt=<value optimized out>, assertion=0xfea678 "bitmap_is_set_all(&table->s->all_set)", file=0xfe8960 "/export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/handler.cc", line=<value optimized out>, function=<value optimized out>) at assert.c:96 #7 0x0000003deac2b810 in __assert_fail (assertion=0xfea678 "bitmap_is_set_all(&table->s->all_set)", file=0xfe8960 "/export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/handler.cc", line=7241, function=0xfeae50 "int handler::ha_reset()") at assert.c:105 #8 0x00000000006997de in handler::ha_reset (this=0x7fc07c023110) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/handler.cc:7241 #9 0x00000000007bd49b in close_thread_table (thd=0x2500da0, table_ptr=0x2500e50) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_base.cc:1502 #10 0x00000000007bcd59 in close_open_tables (thd=0x2500da0) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_base.cc:1241 #11 0x00000000007bd2d6 in close_thread_tables (thd=0x2500da0) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_base.cc:1467 #12 0x0000000000834e25 in mysql_execute_command (thd=0x2500da0) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_parse.cc:5014 #13 0x0000000000837fa9 in mysql_parse (thd=0x2500da0, rawbuf=0x7fc07c004fd0 "CREATE TABLE t1(a DATE)PARTITION BY HASH (EXTRACT(HOUR FROM a))", length=63, parser_state=0x7fc0a9a65680) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_parse.cc:6357 #14 0x000000000082a92b in dispatch_command (command=COM_QUERY, thd=0x2500da0, packet=0x262f601 "CREATE TABLE t1(a DATE)PARTITION BY HASH (EXTRACT(HOUR FROM a))", packet_length=63) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_parse.cc:1332 #15 0x0000000000829990 in do_command (thd=0x2500da0) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_parse.cc:1034 #16 0x00000000007f0d8f in do_handle_one_connection (thd_arg=0x2500da0) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_connect.cc:982 #17 0x00000000007f0860 in handle_one_connection (arg=0x2500da0) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/sql/sql_connect.cc:898 #18 0x0000000000e5f509 in pfs_spawn_thread (arg=0x25f2d30) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/perfschema/pfs.cc:1860 #19 0x0000003deb0079d1 in start_thread (arg=0x7fc0a9a66700) at pthread_create.c:301 #20 0x0000003deace89dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 [root@cluster-repo mysql-advanced-5.6.23]# more docs/INFO_SRC revision-id: michael.izioumtchenko@oracle.com-20141106152508-nntohvuco3v1rjjx date: 2014-11-06 16:25:08 +0100 build-date: 2014-11-06 18:00:43 +0100 revno: 6243 branch-nick: daily-5.6 MySQL source 5.6.23
[26 Nov 2014 9:53]
MySQL Verification Team
DELAYED inserts and replaces were deprecated in MySQL 5.6.6. In MySQL 5.7, DELAYED is not supported. See, http://dev.mysql.com/doc/refman/5.7/en/insert-delayed.html