Percona Server moved to https://jira.percona.com/projects/PS

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

Bug #1384573 reported by Ramesh Sivaraman
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL Server
Unknown
Unknown
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.1
Won't Fix
Undecided
Unassigned
5.5
Fix Released
Medium
Unassigned
Percona Server moved to https://jira.percona.com/projects/PS 5.5.47-37.7
5.6
Fix Released
Medium
Unassigned
Percona Server moved to https://jira.percona.com/projects/PS 5.6.28-76.1
5.7
Fix Released
Medium
Unassigned
Percona Server moved to https://jira.percona.com/projects/PS 5.7.10-1rc1

Bug Description

*** 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

See original description
Tags: qa upstream
Ramesh Sivaraman (rameshvs02)
tags: added: qa
Revision history for this message
Ramesh Sivaraman (rameshvs02) wrote :

Core, GDB, error log etc

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

Revision history for this message
Ramesh Sivaraman (rameshvs02) wrote :

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

Ramesh Sivaraman (rameshvs02)
description: updated
Revision history for this message
Ramesh Sivaraman (rameshvs02) wrote :

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

tags: added: upstream
Revision history for this message
Ramesh Sivaraman (rameshvs02) wrote :

**** 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);

Revision history for this message
Valerii Kravchuk (valerii-kravchuk) wrote :

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'

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.