handle_fatal_signal (sig=11) in convert_charset_partition_constant | sql/sql_partition.cc:202

[Ramesh Sivaraman]

*** GDB info

#0 0x00007f23daf96771 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 0x00000000009db776 in convert_charset_partition_constant (item=0x7f23540060d0, cs=0x16d48b8 <compiled_charsets+9752>) 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:202
#5 0x00000000009961ff in partition_info::get_column_item (this=0x7f23540040a8, item=0x7f23540060d0, field=0x7f2354003210) 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:2603
#6 0x0000000000996373 in partition_info::fix_column_value_functions (this=0x7f23540040a8, thd=0x7f23801ab940, val=0x7f2354004328, part_id=0) 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:2660
#7 0x0000000000992e22 in partition_info::check_range_constants (this=0x7f23540040a8, thd=0x7f23801ab940) 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:1210
#8 0x00000000009de21b in fix_partition_func (thd=0x7f23801ab940, table=0x7f2354000b30, is_create_table_ind=false) 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:1781
#9 0x00000000008ab2d8 in open_table_from_share (thd=0x7f23801ab940, share=0x7f23803557c0, alias=0x7f238031d690 "t1", db_stat=39, prgflag=44, ha_open_flags=0, outparam=0x7f2354000b30, is_create_table=false) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/table.cc:2320
#10 0x00000000007710e9 in open_table (thd=0x7f23801ab940, table_list=0x7f23801af5c0, ot_ctx=0x7f23be30cc50) 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:3205
#11 0x000000000077389e in open_and_process_table (thd=0x7f23801ab940, lex=0x7f23801ade88, tables=0x7f23801af5c0, counter=0x7f23be30cd54, flags=1, prelocking_strategy=0x7f23be30ce00, has_prelocking_list=false, ot_ctx=0x7f23be30cc50) 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
#12 0x00000000007747a3 in open_tables (thd=0x7f23801ab940, start=0x7f23be30cd10, counter=0x7f23be30cd54, flags=1, prelocking_strategy=0x7f23be30ce00) 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
#13 0x000000000077577d in open_and_lock_tables (thd=0x7f23801ab940, tables=0x7f23801af5c0, derived=false, flags=1, prelocking_strategy=0x7f23be30ce00) 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:5860
#14 0x000000000077526e in open_n_lock_single_table (thd=0x7f23801ab940, table_l=0x7f23801af5c0, lock_type=TL_WRITE_DELAYED, flags=1, prelocking_strategy=0x7f23be30ce00) 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:5712
#15 0x00000000007c5e7a in Delayed_insert::open_and_lock_table (this=0x7f23801ab920) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_insert.cc:2874
#16 0x00000000007c61e4 in handle_delayed_insert (arg=0x7f23801ab920) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_insert.cc:2972
#17 0x0000000000dc5bac in pfs_spawn_thread (arg=0x7f238031c7d0) 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
#18 0x00007f23daf91df3 in start_thread () from /lib64/libpthread.so.0
#19 0x00007f23d9c5b01d in clone () from /lib64/libc.so.6

[Ramesh Sivaraman (rameshvs02)]

Core, GDB, error log etc

There was no master (single threaded, single mysqld run)

[Ramesh Sivaraman (rameshvs02)]

s/There was no master (single threaded, single mysqld run)/Single threaded run, single mysqld involved/

[Ramesh Sivaraman (rameshvs02)]

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

[Ramesh Sivaraman (rameshvs02)]

**** Testcase

SET @@collation_server=99;
SET @@global.table_open_cache=0;
create table t1(a CHAR (1)) engine=innodb partition by range columns(a) (partition p0 values less than (''),partition p1 values less than ('za'));
INSERT DELAYED INTO t1 VALUES(1,0),(1,0),(1,0);

[Valerii Kravchuk (valerii-kravchuk)]

For non-debug build I do not see the crash:

[openxs@chief p5.6]$ bin/mysql --no-defaults -uroot test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.6.21-69.0 MySQL Community Server (GPL)

Copyright (c) 2009-2014 Percona LLC and/or its affiliates
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SET @@collation_server=99;
Query OK, 0 rows affected (0.00 sec)

mysql> SET @@global.table_open_cache=0;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> create table t1(a CHAR (1)) engine=innodb partition by range columns(a) (partition p0 values less than (''),partition p1 values less than ('za'));
Query OK, 0 rows affected (0.48 sec)

mysql> INSERT DELAYED INTO t1 VALUES(1,0),(1,0),(1,0);
ERROR 1616 (HY000): DELAYED option not supported for table 't1'

[Shahriyar Rzayev (rzayev-sehriyar)]

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