Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5(EOL), 10.0(EOL), 10.1(EOL)
-
Windows x64
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
- causes
-
MDEV-21210 main.uniques_crash-7912 tries to allocate 1TB of memory, and it takes 10 minutes and a lot of swap to do so.
- Closed
- relates to
-
MDEV-8068 64 bit Windows integer casts warnings
- Closed