handle_fatal_signal (sig=11) in thr_lock_merge_status | mysys/thr_lock.c:1122

[Ramesh Sivaraman]

** Testcase

DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(c1 INT,c2 CHAR)PARTITION BY HASH(c1) PARTITIONS 10;
lock tables t1 write,t1 as t0 read;
ALTER TABLE t1 REBUILD PARTITION p0;

** GDB info

+bt
#0 0x00007fbac1e15771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000006772cd in handle_fatal_signal (sig=11) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/signal_handler.cc:236
#2 <signal handler called>
#3 thr_lock_merge_status (data=0x7fba8ac0e3b8, count=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/mysys/thr_lock.c:1122
#4 0x00000000007ee84d in mysql_lock_merge (a=0x7fba8ad15300, b=b@entry=0x7fba8ac1a0c0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/lock.cc:630
#5 0x00000000006ac7cb in Locked_tables_list::reopen_tables (this=this@entry=0x7fbaa97ba3b0, thd=thd@entry=0x7fbaa97b8000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_base.cc:3710
#6 0x000000000085b484 in handle_alter_part_error (lpt=lpt@entry=0x7fbac23c1880, action_completed=<optimized out>, drop_partition=drop_partition@entry=false, frm_install=<optimized out>, close_table=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_partition.cc:6845
#7 0x00000000008602b8 in fast_alter_partition_table (thd=thd@entry=0x7fbaa97b8000, table=table@entry=0x7fba8ac8c000, alter_info=alter_info@entry=0x7fbac23c3660, create_info=create_info@entry=0x7fbac23c3720, table_list=0x7fba8ac1f108, db=<optimized out>, table_name=0x7fba8ac1f0d0 "t1") at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_partition.cc:7256
#8 0x000000000074acbd in mysql_alter_table (thd=thd@entry=0x7fbaa97b8000, new_db=<optimized out>, new_name=<optimized out>, create_info=create_info@entry=0x7fbac23c3720, table_list=table_list@entry=0x7fba8ac1f108, alter_info=alter_info@entry=0x7fbac23c3660, order_num=0, order=0x0, ignore=false) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_table.cc:8391
#9 0x000000000082c47d in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x7fbaa97b8000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_alter.cc:317
#10 0x00000000006f8342 in mysql_execute_command (thd=thd@entry=0x7fbaa97b8000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_parse.cc:5445
#11 0x00000000006fd2d8 in mysql_parse (thd=thd@entry=0x7fbaa97b8000, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7fbac23c5270) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_parse.cc:6919
#12 0x00000000006fea49 in dispatch_command (command=<optimized out>, thd=0x7fbaa97b8000, packet=0x7fbaa97bc001 "ALTER TABLE t1 REBUILD PARTITION p0", packet_length=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_parse.cc:1434
#13 0x00000000007007a9 in do_command (thd=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_parse.cc:1051
#14 0x00000000006cc392 in do_handle_one_connection (thd_arg=thd_arg@entry=0x7fbaaff3f000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_connect.cc:1532
#15 0x00000000006cc480 in handle_one_connection (arg=arg@entry=0x7fbaaff3f000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_connect.cc:1443
#16 0x0000000000afd6b3 in pfs_spawn_thread (arg=0x7fbabb33f6a0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/storage/perfschema/pfs.cc:1860
#17 0x00007fbac1e10df3 in start_thread () from /lib64/libpthread.so.0
#18 0x00007fbac0ada1ad in clone () from /lib64/libc.so.6

[Ramesh Sivaraman (rameshvs02)]

PFA testcase info. To reproduce this bug please change 1422516856_mybase to PS base path, then init > start > cl (to verify it's up) > run. But testcase above should work fine.

[Ramesh Sivaraman (rameshvs02)]

Getting different assertion in upstream with same testcase. Need to rerun the testcase after fixing upstream bug.

http://bugs.mysql.com/bug.php?id=75677

[Roel Van de Paar (roel11)]

- No longer crashes PS-03.02-16-percona-server-5.7.10-1rc1-linux-x86_64-debug
- Does not crash MS 5.6.28-76.1-debug MySQL Community Server (GPL)
- Does not crash PS-03.02-16-percona-server-5.7.10-1rc1-linux-x86_64-debug]

[Shahriyar Rzayev (rzayev-sehriyar)]

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