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

mysqld got signal 11 in sql/opt_range_mrr.cc:100(step_down_to)

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 10.0, 10.1
    • Fix Version/s: 10.0.22, 10.1.8
    • Component/s: Optimizer
    • Labels:
    • Environment:
      DISTRIB_ID=Ubuntu
      DISTRIB_RELEASE=14.04
      DISTRIB_CODENAME=trusty
      DISTRIB_DESCRIPTION="Ubuntu 14.04.2 LTS"
    • Sprint:
      10.1.8-2

      Description

      Config

      histogram_size=255
      optimizer_use_condition_selectivity=5
      use_stat_tables='preferably'
      optimizer_selectivity_sampling_limit=97
      query_cache_type=1
      optimizer_switch='index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=on,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=on,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=off,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on'
      mrr_buffer_size=32M
      join_buffer_space_limit=32M
      join_cache_level=5
      tmp_table_size=448M
      max_heap_table_size=448M
      sort_buffer_size=32M
      join_buffer_size=32M

      Using either tokudb or inndob, I have at query that can reliably trigger:

      stack_bottom = 0x7f91b7f27e10 thread_stack 0x48000
      mysys/stacktrace.c:247(my_print_stacktrace)[0x7f91b7997efb]
      sql/signal_handler.cc:153(handle_fatal_signal)[0x7f91b752ff05]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x10340)[0x7f91b60c1340]
      sql/opt_range_mrr.cc:100(step_down_to)[0x7f91b731fb49]
      sql/opt_range_mrr.cc:196(sel_arg_range_seq_next(void*, st_key_multi_range*))[0x7f91b732303b]
      sql/opt_range.cc:3426(records_in_column_ranges)[0x7f91b732405d]

      I have rebuilt the table several times, including rounds of optimize & analyze table, anayzle table persistent for all, etc.

      CREATE TABLE `f` (
        `i` int(10) unsigned NOT NULL AUTO_INCREMENT,
        `u` varchar(2048) NOT NULL,
        `n` varchar(2048) NOT NULL,
        `e` tinyint(1) unsigned NOT NULL DEFAULT '1',
        `d` tinyint(1) unsigned NOT NULL,
        `c` datetime DEFAULT NULL,
        `p` int(10) unsigned NOT NULL,
        `g` tinyint(1) unsigned NOT NULL DEFAULT '0',
        `ur` varchar(2048) NOT NULL,
        `r` bigint(20) unsigned DEFAULT NULL,
        `cl` tinyint(1) unsigned NOT NULL DEFAULT '0',
        PRIMARY KEY (`i`),
        UNIQUE KEY (`i`,`d`,`p`),
        KEY (`p`),
        KEY (`d`,`p`),
        KEY (`e`,`d`,`p`),
        KEY (`r`)
      ) ENGINE=tokudb DEFAULT CHARSET=utf8 /* `compression`=tokudb_quicklz */;
       
      MariaDB [test]> SELECT   f.i,   f.u,   f.n,   f.e,   f.d,   f.c,   f.p,   f.g,   f.ur,   f.r,   f.cl FROM   f WHERE   (f.d = 0 AND     f.p = '1' AND     f.i != '-1' AND     f.n = 'some text' );
      ERROR 2013 (HY000): Lost connection to MySQL server during query

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                psergey Sergei Petrunia
                Reporter:
                fimbulvetr Dan Vande More
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: