Details
Minor
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;
Gliffy Diagrams
Attachments
Issue Links
- links to
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
The upstream bug was fixed in 5.5.22, revision-id: mattias.jonsson@oracle.com-20120202114717-byvn9wawr3nin8ho.
The patch includes the test case.
Launchpad bug id: 958934