handle_fatal_signal (sig=11) in mysql_execute_command at sql/sql_parse.cc:3773 on DELETE query

Bug #1205576 reported by Roel Van de Paar
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.1
Won't Fix
Undecided
Unassigned
5.5
New
Undecided
Unassigned
5.6
Incomplete
High
Unassigned
5.7
Incomplete
High
Unassigned

Bug Description

Thread 13 (LWP 1589):
+bt
#0 0x000000340cc0c69c in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000006ecc9d in handle_fatal_signal (sig=11) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/signal_handler.cc:251
#2 <signal handler called>
#3 mysql_delete (thd=0x203ed8c0, table_list=0x207d4610, conds=0x0, order_list=<optimized out>, limit=1, options=0) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_delete.cc:209
#4 0x0000000000776f98 in mysql_execute_command (thd=0x203ed9a8) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3773
#5 0x000000000077bc88 in mysql_parse (thd=0x203ed8c0, rawbuf=0x203ed8c8 "\340cA\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#6 0x000000000077c81f in dispatch_command (command=<optimized out>, thd=0x203ed8c0, packet=<optimized out>, packet_length=545080353) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#7 0x000000000077d4f5 in do_command (thd=0x203ed8c0) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#8 0x0000000000746ecf in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#9 0x0000000000746f90 in handle_one_connection (arg=<optimized out>) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#10 0x00000000009e4ce9 in pfs_spawn_thread (arg=0x2033bed0) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#11 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#12 0x000000340c4e890d in clone () from /lib64/libc.so.6

2013-07-16T18:54:48 [1603] Query: /*any*/ /* QUERY_IS_REPLICATION_SAFE */ ROLLBACK
==1531== Thread 36:
==1531== Invalid read of size 8
==1531== at 0x8C8FC0: mysql_delete(THD*, TABLE_LIST*, Item*, SQL_I_List<st_order>*, unsigned long long, unsigned long long) (sql_delete.cc:209)
==1531== by 0x776F97: mysql_execute_command(THD*) (sql_parse.cc:3773)
==1531== by 0x77BC87: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6477)
==1531== by 0x77C81E: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1374)
==1531== by 0x77D4F4: do_command(THD*) (sql_parse.cc:1049)
==1531== by 0x746ECE: do_handle_one_connection(THD*) (sql_connect.cc:1615)
==1531== by 0x746F8F: handle_one_connection (sql_connect.cc:1526)
==1531== by 0x9E4CE8: pfs_spawn_thread (pfs.cc:1855)
==1531== by 0x340CC07850: start_thread (in /lib64/libpthread-2.12.so)
==1531== by 0x340C4E890C: clone (in /lib64/libc-2.12.so)
==1531== Address 0x0 is not stack'd, malloc'd or (recently) free'd
==1531==
08:54:51 UTC - mysqld got signal 11 ;
[...]
2013-07-16T18:54:51 [1585] Query: UPDATE i SET `col_int_nokey` = 8 WHERE `col_int_nokey` = 0
Query (207d42f0): DELETE FROM `C` WHERE `col_date_key` = ( SELECT `col_varchar_10_utf8_key` FROM `B` WHERE `pk` = 1 ) ORDER BY `col_date`,`col_date_key`,`col_datetime`,`col_datetime_key`,`col_int`,`col_int_key`,`col_varchar_1024_utf8`,`col_varchar_1024_utf8_key`,`col_varchar_10_utf8`,`col_varchar_10_utf8_key`,`pk` LIMIT 1
Connection ID (thread ID): 23
Status: KILL_QUERY

Tags: qa upstream
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

100% upstream.

tags: added: upstream
tags: added: 56qual
tags: removed: 56qual
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-704

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.