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

SIGFPE and/or huge memory allocation in maria_create with distinct/group by/ rollup

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.2.1
    • Fix Version/s: 10.2.4
    • Component/s: Optimizer
    • Labels:
    • Environment:
      windows x64, linux x64
    • Sprint:
      10.2.4-3, 10.2.4-1, 10.2.4-2

      Description

      Version: '10.2.1-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
      [ERROR] mysqld got exception 0xc0000005 ;
      mysqld.exe!maria_create()[ma_create.c:163]
      mysqld.exe!create_internal_tmp_table()[sql_select.cc:17280]
      mysqld.exe!create_internal_tmp_table_from_heap()[sql_select.cc:17511]
      mysqld.exe!JOIN::rollup_write_data()[sql_select.cc:23765]
      mysqld.exe!end_write_group()[sql_select.cc:19930]
      mysqld.exe!AGGR_OP::end_send()[sql_select.cc:26133]
      mysqld.exe!sub_select_postjoin_aggr()[sql_select.cc:18016]
      mysqld.exe!do_select()[sql_select.cc:17845]
      mysqld.exe!JOIN::exec_inner()[sql_select.cc:3343]
      mysqld.exe!JOIN::exec()[sql_select.cc:3154]
      mysqld.exe!mysql_select()[sql_select.cc:3539]
      mysqld.exe!handle_select()[sql_select.cc:377]
      mysqld.exe!execute_sqlcom_select()[sql_parse.cc:6309]
      mysqld.exe!mysql_execute_command()[sql_parse.cc:3352]
      mysqld.exe!mysql_parse()[sql_parse.cc:7746]
      mysqld.exe!dispatch_command()[sql_parse.cc:1793]
      mysqld.exe!do_command()[sql_parse.cc:1353]
      mysqld.exe!threadpool_process_request()[threadpool_common.cc:252]
      mysqld.exe!io_completion_callback()[threadpool_win.cc:462]
      

      How to repeat
      ------------------

      drop table if exists t;
      create table t (a int,b int) engine=innodb;
      insert into t values(-126,7),(1,1),(0,0),(-1,1),(351,65534);
      select distinct 1 from t group by a,b with rollup limit 1;
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              psergei Sergei Petrunia
              Reporter:
              sbester1 sbester1
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.