handle_fatal_signal (sig=11) in filesort | sql/filesort.cc:208
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
||||
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.1 |
Invalid
|
Undecided
|
Unassigned | |||
5.5 |
Invalid
|
Undecided
|
Unassigned | |||
5.6 |
Fix Released
|
High
|
Unassigned | |||
5.7 |
Invalid
|
Undecided
|
Unassigned |
Bug Description
** GDB info
#0 0x00007f1e0bc43771 in pthread_kill () from /lib64/
#1 0x0000000000ab7586 in my_write_core (sig=11) at /mnt/workspace/
#2 0x000000000072f9ff in handle_fatal_signal (sig=11) at /mnt/workspace/
#3 <signal handler called>
#4 0x0000000000936796 in filesort (thd=0x2ce65b0, table=0x7f1db09
#5 0x00000000009accfe in mysql_delete (thd=0x2ce65b0, table_list=
#6 0x00000000007e58c6 in mysql_execute_
#7 0x00000000007ed193 in mysql_parse (thd=0x2ce65b0, rawbuf=
#8 0x00000000007df5fc in dispatch_command (command=COM_QUERY, thd=0x2ce65b0, packet=0x34e3491 "DELETE FROM t2 WHERE c1 IN(-2,0) ORDER BY c1 DESC;", packet_length=50) at /mnt/workspace/
#9 0x00000000007de528 in do_command (thd=0x2ce65b0) at /mnt/workspace/
#10 0x00000000007a64e5 in do_handle_
#11 0x00000000007a5fed in handle_
#12 0x0000000000dc5bac in pfs_spawn_thread (arg=0x3456d40) at /mnt/workspace/
#13 0x00007f1e0bc3edf3 in start_thread () from /lib64/
#14 0x00007f1e0a90801d in clone () from /lib64/libc.so.6
*** Crashing query
DELETE FROM t2 WHERE c1 IN(-2,0) ORDER BY c1 DESC
Core, GDB, error log etc
There was no master (single threaded, single mysqld run)