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

Assertion `thd->is_error() || kill_errno || thd->killed == ABORT_QUERY' failed in SORT_INFO* filesort

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3(EOL), 10.4(EOL)
    • 10.4(EOL)
    • None
    • None

    Description

      --source include/have_partition.inc
      set optimizer_switch="mrr=on,mrr_cost_based=off";
       
      create table t1 ( pk int not null primary key, d1 date) engine=myisam partition by key () partitions 4 ;
      insert into t1 values (1,'1984-12-05'),(5,'1992-05-06'),(9,'2004-04-09'),(13,'1900-01-01');
       
      select 1 from t1 where not (pk < '1') order by d1 ;
      
      

      10.3 8f4de38f65ba89c

      /10.3/sql/filesort.cc:382: SORT_INFO* filesort(THD*, TABLE*, Filesort*, Filesort_tracker*, JOIN*, table_map): Assertion `thd->is_error() || kill_errno || thd->killed == ABORT_QUERY' failed.
       
      sql/filesort.cc:384(filesort(THD*, TABLE*, Filesort*, Filesort_tracker*, JOIN*, unsigned long long))[0x55df496b31fa]
      sql/sql_select.cc:22558(create_sort_index(THD*, JOIN*, st_join_table*, Filesort*))[0x55df4910a9b1]
      sql/sql_select.cc:20371(st_join_table::sort_table())[0x55df490fb8b3]
      sql/sql_select.cc:20312(join_init_read_record(st_join_table*))[0x55df490fadf8]
      sql/sql_select.cc:19393(sub_select(JOIN*, st_join_table*, bool))[0x55df490f4c1f]
      sql/sql_select.cc:18936(do_select(JOIN*, Procedure*))[0x55df490f3277]
      sql/sql_select.cc:4040(JOIN::exec_inner())[0x55df4909225f]
      sql/sql_select.cc:3835(JOIN::exec())[0x55df4908ff04]
      sql/sql_select.cc:4241(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*))[0x55df49093376]
      sql/sql_select.cc:385(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55df4906e721]
      sql/sql_parse.cc:6551(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55df48ff4f00]
      sql/sql_parse.cc:3772(mysql_execute_command(THD*))[0x55df48fe365b]
      sql/sql_parse.cc:8095(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55df48ffd91b]
      sql/sql_parse.cc:1856(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55df48fd83e0]
      sql/sql_parse.cc:1396(do_command(THD*))[0x55df48fd5502]
      sql/sql_connect.cc:1403(do_handle_one_connection(CONNECT*))[0x55df49329d52]
      sql/sql_connect.cc:1310(handle_one_connection)[0x55df4932972f]
      perfschema/pfs.cc:1864(pfs_spawn_thread)[0x55df4a655d6f]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f1612f386ba]
      x86_64/clone.S:111(clone)[0x7f16123cd41d]
       
      Query (0x62b000000288): select 1 from t1 where not (pk < '1') order by d1
      

      Attachments

        Issue Links

          Activity

            People

              psergei Sergei Petrunia
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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