Assertion `bit < (map)->n_bits' failed in bitmap_is_set on EXPLAIN PARTITIONS

Bug #958934 reported by Elena Stepanova on 2012-03-19
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MariaDB
Confirmed
Low
Unassigned

Bug Description

Reproducible on MySQL 5.5.21 and filed as a comment to http://bugs.mysql.com/bug.php?id=64037.

mysqld: include/my_bitmap.h:124: uint bitmap_is_set(const MY_BITMAP*, uint): Assertion `bit < (map)->n_bits' failed.
[ERROR] mysqld got signal 6 ;

#8 0xb750e014 in __assert_fail () from /lib/libc.so.6
#9 0x08502bc5 in bitmap_is_set (map=0x9702da8, bit=3)
    at /home/elenst/maria-5.5/include/my_bitmap.h:124
#10 0x0850f993 in make_used_partitions_str (part_info=0x9702d10, parts_str=0x970acc0)
    at /home/elenst/maria-5.5/sql/sql_partition.cc:7012
#11 0x08294b31 in select_describe (join=0x9715460, need_tmp_table=false, need_order=false,
    distinct=false, message=0x0) at /home/elenst/maria-5.5/sql/sql_select.cc:21071
#12 0x08269ab6 in JOIN::exec (this=0x9715460)
    at /home/elenst/maria-5.5/sql/sql_select.cc:2308
#13 0x0826bd3e in mysql_select (thd=0x9659a80, rref_pointer_array=0x965b62c,
    tables=0x9709700, wild_num=0, fields=..., conds=0x9709c28, og_num=0, order=0x0,
    group=0x0, having=0x0, proc_param=0x0, select_options=2147748612, result=0x9709d90,
    unit=0x965b054, select_lex=0x965b4f0) at /home/elenst/maria-5.5/sql/sql_select.cc:3003
#14 0x0829695c in mysql_explain_union (thd=0x9659a80, unit=0x965b054, result=0x9709d90)
    at /home/elenst/maria-5.5/sql/sql_select.cc:21547
#15 0x0823f4c8 in execute_sqlcom_select (thd=0x9659a80, all_tables=0x9709700)
    at /home/elenst/maria-5.5/sql/sql_parse.cc:4588
#16 0x082385f1 in mysql_execute_command (thd=0x9659a80)
    at /home/elenst/maria-5.5/sql/sql_parse.cc:2185
#17 0x08241c4b in mysql_parse (thd=0x9659a80,
    rawbuf=0x9709578 "EXPLAIN PARTITIONS SELECT a FROM t1 WHERE a < 3", length=47,
    parser_state=0xad17ddb8) at /home/elenst/maria-5.5/sql/sql_parse.cc:5732
#18 0x082360bb in dispatch_command (command=COM_QUERY, thd=0x9659a80, packet=0x97038f1 "",
    packet_length=47) at /home/elenst/maria-5.5/sql/sql_parse.cc:1056
#19 0x08235580 in do_command (thd=0x9659a80) at /home/elenst/maria-5.5/sql/sql_parse.cc:795
#20 0x0831fbf5 in do_handle_one_connection (thd_arg=0x9659a80)
    at /home/elenst/maria-5.5/sql/sql_connect.cc:1253
#21 0x0831f740 in handle_one_connection (arg=0x9659a80)
    at /home/elenst/maria-5.5/sql/sql_connect.cc:1168
#22 0x08547c3b in pfs_spawn_thread (arg=0x9735998)
    at /home/elenst/maria-5.5/storage/perfschema/pfs.cc:1015
#23 0xb77edb25 in start_thread () from /lib/libpthread.so.0

Query (9709578): EXPLAIN PARTITIONS SELECT a FROM t1 WHERE a < 3
Connection ID (thread ID): 2
Status: NOT_KILLED

bzr version-info
revision-id: <email address hidden>
date: 2012-03-17 12:16:57 -0700
build-date: 2012-03-19 05:01:04 +0400
revno: 3334

Test case:

--source include/have_partition.inc

CREATE TABLE t1 ( a INT ) ENGINE=MyISAM
  PARTITION BY RANGE (a) (
    PARTITION p0 VALUES LESS THAN (4),
    PARTITION p1 VALUES LESS THAN (191),
    PARTITION p2 VALUES LESS THAN (54850),
    PARTITION p3 VALUES LESS THAN MAXVALUE
);
INSERT INTO t1 VALUES (8),(6),(3),(3);
SET GLOBAL c2.key_buffer_size = 128*1024;
CACHE INDEX t1 PARTITION ( p1, p1 ) IN c2;
ALTER TABLE t1 ORDER BY a;
EXPLAIN PARTITIONS SELECT a FROM t1 WHERE a < 3;

# End of test case

Elena Stepanova (elenst) on 2012-03-29
tags: added: assertion partitions
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers