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 on 2013-07-27
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

Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :

100% upstream.

tags: added: upstream
tags: added: 56qual
tags: removed: 56qual

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  Edit
Everyone can see this information.

Other bug subscribers