mysqld got signal 11 ; on update query | handle_fatal_signal (sig=11) in open_table

[Roel Van de Paar]

Version: '5.6.21-69.0-debug' socket: '/dev/shm/235746/4490/socket.sock' port: 51168 Percona Server (GPL), Release 69.0, Revision 681, DEBUG BINARY
2014-10-19 03:20:06 7fc28affd700 InnoDB: FTS Optimize Removing table test/t1
2014-10-19 03:20:06 1489 [Warning] Did not write failed 'revoke all on mysqltest_2.t2 from mysqltest_3@localhost' into binary log while storing table level and column level grants in the privilege tables.
InnoDB: user stopword table does not exist.
2014-10-19 03:20:08 1489 [ERROR] Column count of mysql.event is wrong. Expected 22, found 23. The table is probably corrupted
InnoDB: user stopword table Salmon does not exist.
InnoDB: user stopword table not_defined does not exist.
2014-10-19 03:20:08 1489 [Note] Event Scheduler: scheduler thread started with id 9
2014-10-19 03:20:08 1489 [Note] Event Scheduler: Last execution of test.test_ev_1. Dropping.
16:20:08 UTC - mysqld got signal 11 ;
[...]
Query (7fc25c004e90): update t2 set name='U+306A HIRAGANA LETTER NA' where ujis=0xA4CA
Connection ID (thread ID): 4
Status: NOT_KILLED

Single threaded run, single mysqld involved

Thread 1 (Thread 0x7fc2c0047700 (LWP 1683)):
+bt
#0 0x00007fc2c7f49771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000ab7586 in my_write_core (sig=11) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/mysys/stacktrace.c:422
#2 0x000000000072f9ff in handle_fatal_signal (sig=11) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x0000000000771336 in open_table (thd=0x208d4b0, table_list=0x7fc25c004fc8, ot_ctx=0x7fc2c0044510) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_base.cc:3260
#5 0x000000000077389e in open_and_process_table (thd=0x208d4b0, lex=0x208f9f8, tables=0x7fc25c004fc8, counter=0x208fab8, flags=0, prelocking_strategy=0x7fc2c0044610, has_prelocking_list=false, ot_ctx=0x7fc2c0044510) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_base.cc:4699
#6 0x00000000007747a3 in open_tables (thd=0x208d4b0, start=0x7fc2c00445d0, counter=0x208fab8, flags=0, prelocking_strategy=0x7fc2c0044610) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_base.cc:5213
#7 0x0000000000775932 in open_normal_and_derived_tables (thd=0x208d4b0, tables=0x7fc25c004fc8, flags=0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_base.cc:5913
#8 0x0000000000877597 in mysql_update (thd=0x208d4b0, table_list=0x7fc25c004fc8, fields=..., values=..., conds=0x7fc25c005a50, order_num=0, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7fc2c0045830, updated_return=0x7fc2c0045828) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_update.cc:251
#9 0x00000000007e4d76 in mysql_execute_command (thd=0x208d4b0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:3715
#10 0x00000000007ed193 in mysql_parse (thd=0x208d4b0, rawbuf=0x7fc25c004e90 "update t2 set name='U+306A HIRAGANA LETTER NA' where ujis=0xA4CA", length=64, parser_state=0x7fc2c0045d50) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:6773
#11 0x00000000007df5fc in dispatch_command (command=COM_QUERY, thd=0x208d4b0, packet=0x287cfb1 "update t2 set name='U+306A HIRAGANA LETTER NA' where ujis=0xA4CA;", packet_length=65) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1432
#12 0x00000000007de528 in do_command (thd=0x208d4b0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1049
#13 0x00000000008c2c30 in threadpool_process_request (thd=0x208d4b0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/threadpool_common.cc:311
#14 0x00000000008c5572 in handle_event (connection=0x282c900) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/threadpool_unix.cc:1553
#15 0x00000000008c57a2 in worker_main (param=0x1898400 <all_groups+2048>) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/threadpool_unix.cc:1606
#16 0x0000000000dc5bac in pfs_spawn_thread (arg=0x7fc25c004ba0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/perfschema/pfs.cc:1860
#17 0x00007fc2c7f44df3 in start_thread () from /lib64/libpthread.so.0
#18 0x00007fc2c6c0e01d in clone () from /lib64/libc.so.6

[Ramesh Sivaraman (rameshvs02)]

*** Testcase.

DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(a INT,b INT,c BINARY(1),d CHAR (1),e BINARY (1),f VARCHAR(1),g BLOB,h BLOB,id INT,KEY(b),KEY(e)) ENGINE=myisam;
CREATE TABLE t(id INT KEY,k INT,c CHAR(1),UNIQUE KEY(k)) ENGINE=InnoDB;
HANDLER t OPEN;
INSERT INTO t1 VALUES(-355435672,0,'1D','6glE6UNnLDGhpc8oVY6T16YMr9O2DFICFj8XZuHgm1NxknnjkArQUmFWvAqfmdRTaIashbuISgxxdnaGSgwntt3lNb3hOhhE2vswfhQ9OaQwhfgQY6tOvdqciHyU',0,'VusxTxKhgOZ06VOnHTNeyLv51pyY6NezDPnYoj0HDOBEcm8WIC75mO87Z8Ake3qph7kBTLEFQtXsM1eAGH4b',0,0,0);
LOCK TABLES FOR BACKUP;
SET @@global.table_open_cache=FALSE;
INSERT INTO t1 VALUES(0,0,'o5YgWlJbjUg71bf3k32wdkF','RJks5IXb0rGhoO4J2s6vKuuVrNCqCR2mKJva7AJrfb4FffsEhvkQwQ86nZxeqsOzAm5E0FAHl4J8RWm7eg2gVoj5MyEqQ9soorumAE65vsO42Ou6YbW6nnfpiu0L5cQV8QNja8553GTBsL',0,'WVic0XIphr0mezlGZRKD84fxyneaTUqfD9snyxGUazbdwG4Rg7IiAQnnGdr6vrL8rXtess8XETzwEmBy4rxTlcWKi',0,0,0);

[Shahriyar Rzayev (rzayev-sehriyar)]

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