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
Status tracked in 5.7
5.1
Undecided
Unassigned
5.5
Undecided
Unassigned
5.6
High
Unassigned
5.7
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
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers