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

multitable delete with wrongly set sort_buffer_size crashes in merge_buffers

    XMLWordPrintable

Details

    Description

      Version: '10.0.17-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
      [ERROR] mysqld got exception 0xc0000005 ;
       
      mysqld.exe!memcmp()[memcmp.asm:95]
      mysqld.exe!queue_insert()[queues.c:206]
      mysqld.exe!merge_buffers()[filesort.cc:1612]
      mysqld.exe!merge_index()[filesort.cc:1818]
      mysqld.exe!Unique::merge()[uniques.cc:730]
      mysqld.exe!Unique::get()[uniques.cc:781]
      mysqld.exe!multi_delete::do_deletes()[sql_delete.cc:1136]
      mysqld.exe!multi_delete::send_eof()[sql_delete.cc:1252]
      mysqld.exe!do_select()[sql_select.cc:17500]
      mysqld.exe!JOIN::exec_inner()[sql_select.cc:3081]
      mysqld.exe!JOIN::exec()[sql_select.cc:2372]
      mysqld.exe!mysql_select()[sql_select.cc:3312]
      mysqld.exe!mysql_execute_command()[sql_parse.cc:3624]
      mysqld.exe!mysql_parse()[sql_parse.cc:6522]
      mysqld.exe!dispatch_command()[sql_parse.cc:1303]
      mysqld.exe!do_command()[sql_parse.cc:1003]
      mysqld.exe!threadpool_process_request()[threadpool_common.cc:233]
      mysqld.exe!io_completion_callback()[threadpool_win.cc:568]

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

      set sql_mode="";
      drop table if exists t1,t2;
      create table `t1` (`a` datetime not null) engine=innodb;
      create table `t2` (`a` int not null) engine=innodb;
      set session sort_buffer_size = 1024*1024*1024*1024;
      replace into t1 values (),();
      insert into t2 values(0);
      delete d1, d2 from t2 as d1, t1 as d2 where d1.a<=>d2.a;

      Attachments

        Issue Links

          Activity

            People

              cvicentiu Vicențiu Ciorbaru
              sbester1 sbester1
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.