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

multitable delete with wrongly set sort_buffer_size crashes in merge_buffers

    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

              • Assignee:
                cvicentiu Vicentiu Ciorbaru
                Reporter:
                sbester1 sbester1
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: