Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-28299

Server crashes in XINDXS::Range/CntIndexRange (Connect engine)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL)
    • 10.3.39
    • 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
      

      Attachments

        Activity

          People

            TheLinuxJedi Andrew Hutchings (Inactive)
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.