[MDEV-31878] Assertion `bit < map->n_bits' failed in bitmap_is_set Created: 2023-08-08  Updated: 2023-11-28

Status: Confirmed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.4, 10.5, 10.6, 10.9, 10.10, 10.11, 11.0, 11.2
Fix Version/s: 10.4, 10.5, 10.6, 10.11, 11.0, 11.1, 11.2

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Sergei Golubchik
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-24283 Assertion `bitmap_is_set(&m_part_info... Closed

 Description   

--source include/have_partition.inc
 
CREATE TABLE t1 (id int, a int, KEY id (id), KEY (a)) partition BY list (id) (PARTITION p1 VALUES IN (1,2,3,4,5,6,7,8,9,10 ));
INSERT INTO t1 VALUES (1,5),(2,3),(3,7),(4,2),(5,7),(6,4),(7,9),(8,7),(9,NULL),(10,NULL);
 
SELECT  * FROM t1 WHERE id IN (255) OR a IN (25,1);

Version: '10.4.31-MariaDB-debug-log'  
mysqld: /10.4/include/my_bitmap.h:133: uint bitmap_is_set(const MY_BITMAP*, uint): Assertion `bit < (map)->n_bits' failed.
230808 15:54:09 [ERROR] mysqld got signal 6 ;
 
 
Server version: 10.4.31-MariaDB-debug-log source revision: 277968aa4cfa46a290af1c44e9d756381005939a
 
stdlib/abort.c:81(__GI_abort)[0x7f6c4ba50535]
intl/loadmsgcat.c:1177(_nl_load_domain)[0x7f6c4ba5040f]
/lib/x86_64-linux-gnu/libc.so.6(+0x301a2)[0x7f6c4ba5e1a2]
include/my_bitmap.h:134(bitmap_is_set)[0x55750729481e]
sql/ha_partition.cc:7687(ha_partition::handle_ordered_index_scan(unsigned char*, bool))[0x5575072d274c]
sql/ha_partition.cc:6649(ha_partition::multi_range_read_next(void**))[0x5575072c871d]
sql/opt_range.cc:12345(QUICK_RANGE_SELECT::get_next())[0x557506e4900d]
sql/opt_range.cc:11894(read_keys_and_merge_scans(THD*, TABLE*, List<QUICK_RANGE_SELECT>, QUICK_RANGE_SELECT*, READ_RECORD*, bool, Bitmap<64u>*, Unique**))[0x557506e44a45]
sql/opt_range.cc:11963(QUICK_INDEX_MERGE_SELECT::read_keys_and_merge())[0x557506e4533d]
sql/opt_range.cc:1389(QUICK_INDEX_SORT_SELECT::reset())[0x557506dfe168]
sql/sql_select.cc:21820(join_init_read_record(st_join_table*))[0x5575063fc8b9]
sql/sql_select.cc:20886(sub_select(JOIN*, st_join_table*, bool))[0x5575063f5e75]
sql/sql_select.cc:20412(do_select(JOIN*, Procedure*))[0x5575063f3ec1]
sql/sql_select.cc:4605(JOIN::exec_inner())[0x557506382f84]
sql/sql_select.cc:4388(JOIN::exec())[0x5575063805d0]
sql/sql_select.cc:4828(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55750638462f]
sql/sql_select.cc:442(handle_select(THD*, LEX*, select_result*, unsigned long))[0x557506355942]
sql/sql_parse.cc:6473(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5575062c4fbd]
sql/sql_parse.cc:3976(mysql_execute_command(THD*))[0x5575062b2716]
sql/sql_parse.cc:8010(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5575062ce12b]
sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5575062a4ba9]
sql/sql_parse.cc:1378(do_command(THD*))[0x5575062a16b5]
sql/sql_connect.cc:1420(do_handle_one_connection(CONNECT*))[0x55750669c7f1]
sql/sql_connect.cc:1325(handle_one_connection)[0x55750669c093]
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x5575073792f1]
nptl/pthread_create.c:487(start_thread)[0x7f6c4bf1bfa3]
x86_64/clone.S:97(clone)[0x7f6c4bb2706f]
 
Query (0x62b000062290): SELECT  * FROM t1 WHERE id IN (255) OR a IN (25,1)


Generated at Thu Feb 08 10:27:09 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.