[MDEV-695] LP:958934 - Assertion `bit < (map)->n_bits' failed in bitmap_is_set on EXPLAIN PARTITIONS Created: 2012-03-19  Updated: 2013-03-30  Resolved: 2013-03-30

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: Launchpad, upstream

Attachments: XML File LPexportBug958934.xml    

 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;



 Comments   
Comment by Rasmus Johansson (Inactive) [ 2012-03-29 ]

Launchpad bug id: 958934

Comment by Elena Stepanova [ 2013-03-30 ]

The upstream bug was fixed in 5.5.22, revision-id: mattias.jonsson@oracle.com-20120202114717-byvn9wawr3nin8ho.

The patch includes the test case.

Generated at Thu Feb 08 06:30:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.