mysqld got signal 11 ; on ALTER TABLE | handle_fatal_signal (sig=11) in partition_info::get_clone

[Roel Van de Paar]

Related to https://bugs.launchpad.net/percona-server/+bug/1385062 ?

2014-10-21 00:52:15 7f37653e8700 InnoDB: Error: Table "mysql"."innodb_index_stats" not found.
2014-10-21 00:52:15 7f37653e8700 InnoDB: Error: Fetch of persistent statistics requested for table "test"."t2" /* Partition "x3" */ but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
13:52:15 UTC - mysqld got signal 11 ;
[...]
Query (7f371c004e90): ALTER TABLE t2 CHANGE COLUMN b b VARCHAR(400)
Connection ID (thread ID): 4

Single threaded run, single mysqld involved

Thread 1 (Thread 0x7f37653a7700 (LWP 15483)):
+bt
#0 0x00007f377e785771 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 0x00007f377d4a1080 in __memmove_ssse3_back () from /lib64/libc.so.6
#5 0x0000000000990553 in partition_info::get_clone (this=0x7f371c1a3d60) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/partition_info.cc:63
#6 0x00000000009e59d2 in prep_alter_part_table (thd=0x30e53f0, table=0x7f371c0d3e70, alter_info=0x7f37653a43f0, create_info=0x7f37653a44b0, alter_ctx=0x7f37653a35f0, partition_changed=0x7f37653a40db, fast_alter_table=0x7f37653a40da) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_partition.cc:5721
#7 0x000000000085b574 in mysql_alter_table (thd=0x30e53f0, new_db=0x7f371c005500 "test", new_name=0x0, create_info=0x7f37653a44b0, table_list=0x7f371c004fa0, alter_info=0x7f37653a43f0, order_num=0, order=0x0, ignore=false) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_table.cc:8297
#8 0x00000000009a3d65 in Sql_cmd_alter_table::execute (this=0x7f371c0055d8, thd=0x30e53f0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_alter.cc:317
#9 0x00000000007e9da3 in mysql_execute_command (thd=0x30e53f0) 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:5411
#10 0x00000000007ed193 in mysql_parse (thd=0x30e53f0, rawbuf=0x7f371c004e90 "ALTER TABLE t2 CHANGE COLUMN b b VARCHAR(400)", length=45, parser_state=0x7f37653a5d50) 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=0x30e53f0, packet=0x38df9b1 "ALTER TABLE t2 CHANGE COLUMN b b VARCHAR(400);", packet_length=46) 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=0x30e53f0) 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=0x30e53f0) 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=0x3767df0) 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=0x7f371c004ba0) 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 0x00007f377e780df3 in start_thread () from /lib64/libpthread.so.0
#18 0x00007f377d44a01d in clone () from /lib64/libc.so.6

[Ramesh Sivaraman (rameshvs02)]

This is upstream bug : http://bugs.mysql.com/bug.php?id=74478

[Valerii Kravchuk (valerii-kravchuk)]

I have reasons to think upstream bug, http://bugs.mysql.com/bug.php?id=74478, is fixed in 5.6.24. Maybe this bug is fined in Percona 5.6.24 as well as a result?

[Laurynas Biveinis (laurynas-biveinis)]

Indeed it has been fixed in 5.6.24, thanks for catching this

[Shahriyar Rzayev (rzayev-sehriyar)]

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