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 (OCA) Email Updates:
Status: Verified Impact on me:
None 
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
Description:
2014-11-25 17:12:22 3534 [Note] /ssd/ramesh/mysql-server/mysql-5.6.21-linux-x86_64-debug/bin/mysqld: ready for connections.
Version: '5.6.21-debug'  socket: '/ssd/ramesh/mysql-server/mysql-5.6.21-linux-x86_64-debug/socket.sock'  port: 10195  MySQL Community Server (GPL)
2014-11-25 17:12:22 3534 [Note] Event Scheduler: scheduler thread started with id 1
mysqld: /ssd/ramesh/mysql-server/mysql-5.6/sql/handler.cc:7241: int handler::ha_reset(): Assertion `bitmap_is_set_all(&table->s->all_set)' failed.
17:12:26 UTC - mysqld got signal 6 ;

** GDB info

#0  0x00007f8bb6a35771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000000a954ea in my_write_core (sig=6) at /ssd/ramesh/mysql-server/mysql-5.6/mysys/stacktrace.c:422
#2  0x0000000000726494 in handle_fatal_signal (sig=6) at /ssd/ramesh/mysql-server/mysql-5.6/sql/signal_handler.cc:230
#3  <signal handler called>
#4  0x00007f8bb58415c9 in raise () from /lib64/libc.so.6
#5  0x00007f8bb5842cd8 in abort () from /lib64/libc.so.6
#6  0x00007f8bb583a536 in __assert_fail_base () from /lib64/libc.so.6
#7  0x00007f8bb583a5e2 in __assert_fail () from /lib64/libc.so.6
#8  0x0000000000644789 in handler::ha_reset (this=0x7f8b12098c10) at /ssd/ramesh/mysql-server/mysql-5.6/sql/handler.cc:7241
#9  0x00000000007637ea in close_thread_table (thd=0x7f8b2375d000, table_ptr=0x7f8b2375d0b0) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_base.cc:1502
#10 0x00000000007630b7 in close_open_tables (thd=0x7f8b2375d000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_base.cc:1241
#11 0x000000000076361e in close_thread_tables (thd=0x7f8b2375d000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_base.cc:1467
#12 0x00000000007d8fd0 in mysql_execute_command (thd=0x7f8b2375d000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_parse.cc:5014
#13 0x00000000007dbdbc in mysql_parse (thd=0x7f8b2375d000, rawbuf=0x7f8b1201f010 "CREATE TABLE t1(a DATE)PARTITION BY HASH (EXTRACT(HOUR FROM a))", length=63, parser_state=0x7f8bb6feae70) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_parse.cc:6245
#14 0x00000000007cf36f in dispatch_command (command=COM_QUERY, thd=0x7f8b2375d000, packet=0x7f8b18266001 "CREATE TABLE t1(a DATE)PARTITION BY HASH (EXTRACT(HOUR FROM a))", packet_length=63) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_parse.cc:1332
#15 0x00000000007ce45e in do_command (thd=0x7f8b2375d000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_parse.cc:1034
#16 0x0000000000796879 in do_handle_one_connection (thd_arg=0x7f8b2375d000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_connect.cc:982
#17 0x0000000000796362 in handle_one_connection (arg=0x7f8b2375d000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_connect.cc:898
#18 0x0000000000d71288 in pfs_spawn_thread (arg=0x7f8bb2ffea60) at /ssd/ramesh/mysql-server/mysql-5.6/storage/perfschema/pfs.cc:1860
#19 0x00007f8bb6a30df3 in start_thread () from /lib64/libpthread.so.0
#20 0x00007f8bb590201d in clone () from /lib64/libc.so.6

How to repeat:
DROP DATABASE test;CREATE DATABASE test;USE test;
SET storage_engine=MyISAM;
CREATE TABLE t1(c1 DECIMAL KEY,c2 CHAR (1),c3 TIME);
INSERT INTO t1 VALUES(0,0,0),(2,2,2);
replace delayed INTO t1(c1,c2)values ("text1","12");
replace delayed INTO t1(c1,c2)values ("text1","11");
CREATE TABLE t1(a DATE)PARTITION BY HASH (EXTRACT(HOUR FROM a));
[26 Nov 2014 9:42] Umesh Shastry
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] Umesh Shastry
// 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] Umesh Shastry
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