[MDEV-28299] Server crashes in XINDXS::Range/CntIndexRange (Connect engine) Created: 2022-04-12  Updated: 2022-11-29  Resolved: 2022-11-29

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Connect
Affects Version/s: 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9
Fix Version/s: 10.3.39

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Andrew Hutchings
Resolution: Fixed Votes: 0
Labels: None


 Description   

 
CREATE TABLE t1 (a int, b int, pk int, PRIMARY KEY (pk)) engine=CONNECT;
 
SELECT x.a 
FROM t1 AS x JOIN t1 AS y ON (x.a = y.b)
WHERE x.pk > 3;

10.2 27b5d814e2c851569a0d75e

Version: '10.2.44-MariaDB-debug-log' 
220412 11:42:53 [ERROR] mysqld got signal 11 ;
 
Server version: 10.2.44-MariaDB-debug-log
 
sql/signal_handler.cc:221(handle_fatal_signal)[0x5596d9811c7d]
sigaction.c:0(__restore_rt)[0x7f52317773c0]
connect/xindex.cpp:2042(XINDXS::Range(_global*, int, bool))[0x7f5228df1bb1]
connect/connect.cc:953(CntIndexRange(_global*, TDB*, unsigned char const**, unsigned int*, bool*, unsigned long*))[0x7f5228c54519]
connect/ha_connect.cc:5346(ha_connect::records_in_range(unsigned int, st_key_range*, st_key_range*))[0x7f5228c3be47]
sql/multi_range_read.cc:107(handler::multi_range_read_info_const(unsigned int, st_range_seq_if*, void*, unsigned int, unsigned int*, unsigned int*, Cost_estimate*))[0x5596d9600f0f]
sql/multi_range_read.cc:1466(DsMrr_impl::dsmrr_info_const(unsigned int, st_range_seq_if*, void*, unsigned int, unsigned int*, unsigned int*, Cost_estimate*))[0x5596d960bdf2]
connect/ha_connect.cc:7385(ha_connect::multi_range_read_info_const(unsigned int, st_range_seq_if*, void*, unsigned int, unsigned int*, unsigned int*, Cost_estimate*))[0x7f5228c47df9]
sql/opt_range.cc:10447(check_quick_select(PARAM*, unsigned int, bool, SEL_ARG*, bool, unsigned int*, unsigned int*, Cost_estimate*))[0x5596d9b99858]
sql/opt_range.cc:6830(get_key_scans_params(PARAM*, SEL_TREE*, bool, bool, double))[0x5596d9b82835]
sql/opt_range.cc:2597(SQL_SELECT::test_quick_select(THD*, Bitmap<64u>, unsigned long long, unsigned long long, bool, bool, bool))[0x5596d9b6946b]
sql/sql_select.cc:3886(get_quick_record_count(THD*, SQL_SELECT*, TABLE*, Bitmap<64u> const*, unsigned long long))[0x5596d9291dcc]
sql/sql_select.cc:4501(make_join_statistics(JOIN*, List<TABLE_LIST>&, st_dynamic_array*))[0x5596d9297be0]
sql/sql_select.cc:1597(JOIN::optimize_inner())[0x5596d927ab63]
sql/sql_select.cc:1127(JOIN::optimize())[0x5596d9275e8a]
sql/sql_select.cc:3835(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*))[0x5596d92915c9]
sql/sql_select.cc:361(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5596d926e158]
sql/sql_parse.cc:6271(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5596d91e47c3]
sql/sql_parse.cc:3582(mysql_execute_command(THD*))[0x5596d91d1b4c]
sql/sql_parse.cc:7793(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5596d91edcd8]
sql/sql_parse.cc:1830(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5596d91c6edd]
sql/sql_parse.cc:1381(do_command(THD*))[0x5596d91c3ca8]
sql/sql_connect.cc:1336(do_handle_one_connection(CONNECT*))[0x5596d9550504]
sql/sql_connect.cc:1242(handle_one_connection)[0x5596d954fdc7]
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x5596da8f0894]
nptl/pthread_create.c:478(start_thread)[0x7f523176b609]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7f5230ed9163]
 
Query (0x62b000000290): SELECT x.a 
FROM t1 AS x JOIN t1 AS y ON (x.a = y.b)
WHERE x.pk > 3



 Comments   
Comment by Alice Sherepa [ 2022-07-12 ]

CREATE TABLE t1 ( a int not null, KEY (a))engine=CONNECT;
SELECT * FROM t1 WHERE a=1;

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