** Testcase
DROP DATABASE test;CREATE DATABASE test;USE test;
UPDATE performance_schema.threads SET INSTRUMENTED='';
set tokudb_optimize_index_name='';
CREATE TABLE t1(c1 INT UNSIGNED UNIQUE KEY);
CREATE TEMPORARY TABLE t1 AS SELECT 1 AS f1;
SET GLOBAL SERVER_ID=2;
SET default_storage_engine=MyISAM;
DROP TABLE t1;
SET @@global.server_id=DEFAULT;
CREATE TABLE t1(c1 BIT);
DROP TABLE t1;
SELECT 1 FROM t1 AS a1,t1 AS a2,t1 AS a3,t1 AS a4 FOR UPDATE;
SET STATEMENT myisam_sort_buffer_size=400000,myisam_repair_threads=2,sort_buffer_size=200000,binlog_format=row,keep_files_on_create=OFF,max_join_size=4444440000000 FOR CALL p4();
rename TABLE t1 to t4,t1 to t3,t1 to t2,t1 to t1;
INSERT INTO mysql.innodb_index_stats SELECT * FROM t1 _c2_stats;
set tokudb_optimize_index_name='';
select partition_method,partition_expression,partition_description from information_schema.partitions;
The attached tarball gives the testcase as an exact match of our system, including some handy utilities
$ vi {epoch}_mybase # Update base path in this file (the only change
required!). For non-binary distribution please update SOURCE_DIR location also.
$ ./{epoch}_init # Initializes the data dir
$ ./{epoch}_start # Starts mysqld
$ ./{epoch}_cl # To check mysqld is up
$ ./{epoch}_run # Run the testcase with pquery binary(produces
output)
$ vi /dev/shm/{epoch}/error.log.out # Verify the error log
$ ./{epoch}_gdb # Brings you to a gdb prompt attached to correct
mysqld
& generated core
$ ./{epoch}_parse_core # Create {epoch}_STD.gdb and {epoch}_FULL.gdb;
standard and full var gdb stack traces
etc.
** Extra Startup info
--plugin-load=audit_log=audit_log.so\;tokudb=ha_tokudb.so --maximum-transaction_prealloc_size=1M
** GDB info
#0 0x00007fa0cafed771 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x0000000000abb47a in my_write_core (sig=11) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/m
ysys/stacktrace.c:422
#2 0x00000000007312c3 in handle_fatal_signal (sig=11) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-
72.1/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x0000000000e7dda2 in my_hash_sort_bin (cs=0x15cf160 <my_charset_bin>, key=0x7fa0508b09e0 "", len=140326522784224, nr1=0x7fa0cb59b7e8, nr2=0x7fa0cb59b7e
0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/strings/ctype-bin.c:309
#5 0x0000000000a9b004 in cset_hash_sort_adapter (hash=0x189f070 <table_cache_manager+48>, key=0x0, length=140326522784224) at /mnt/workspace/percona-server
-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/mysys/hash.c:59
#6 0x0000000000a9afb1 in calc_hash (hash=0x189f070 <table_cache_manager+48>, key=0x0, length=140326522784224) at /mnt/workspace/percona-server-5.6-binaries
-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/mysys/hash.c:45
#7 0x0000000000a9b407 in my_hash_rec_mask (hash=0x189f070 <table_cache_manager+48>, pos=0x7fa0c4788360, buffmax=128, maxlength=81) at /mnt/workspace/percon
a-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/mysys/hash.c:214
#8 0x0000000000a9b6ba in my_hash_first_from_hash_value (hash=0x189f070 <table_cache_manager+48>, hash_value=1096967734, key=0x7fa050a42dfd "test", length=8
, current_record=0x7fa0cb59b90c) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/mysys/hash.c:303
#9 0x0000000000a9b4c4 in my_hash_search_using_hash_value (hash=0x189f070 <table_cache_manager+48>, hash_value=1096967734, key=0x7fa050a42dfd "test", length
=8) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/mysys/hash.c:244
#10 0x00000000007824e5 in Table_cache::get_table (this=0x189f040 <table_cache_manager>, thd=0x7fa0b877a000, hash_value=1096967734, key=0x7fa050a42dfd "test"
, key_length=8, share=0x7fa0cb59bdd8) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/table_ca
che.h:472
#11 0x00000000007721e0 in open_table (thd=0x7fa0b877a000, table_list=0x7fa050a42a38, ot_ctx=0x7fa0cb59bfb0) at /mnt/workspace/percona-server-5.6-binaries-de
bug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_base.cc:2975
#12 0x00000000007750c0 in open_and_process_table (thd=0x7fa0b877a000, lex=0x7fa0cb59c170, tables=0x7fa050a42a38, counter=0x7fa0cb59c230, flags=1026, prelock
ing_strategy=0x7fa0cb59c0b0, has_prelocking_list=false, ot_ctx=0x7fa0cb59bfb0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-6
4/percona-server-5.6.23-72.1/sql/sql_base.cc:4719
#13 0x0000000000775f54 in open_tables (thd=0x7fa0b877a000, start=0x7fa0cb59c070, counter=0x7fa0cb59c230, flags=1026, prelocking_strategy=0x7fa0cb59c0b0) at
/mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_base.cc:5226
#14 0x000000000077713e in open_normal_and_derived_tables (thd=0x7fa0b877a000, tables=0x7fa050a42a38, flags=1026) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_base.cc:5935
#15 0x0000000000832e16 in fill_schema_table_by_open (thd=0x7fa0b877a000, is_show_fields_or_keys=false, table=0x7fa0508c0010, schema_table=0x159b300 <schema_tables+1088>, orig_db_name=0x7fa050822f60, orig_table_name=0x7fa050a429c0, open_tables_state_backup=0x7fa0cb59d530, can_deadlock=false) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_show.cc:3837
#16 0x0000000000835322 in get_all_tables (thd=0x7fa0b877a000, tables=0x7fa050821548, cond=0x0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_show.cc:4771
#17 0x0000000000842c0b in do_fill_table (thd=0x7fa0b877a000, table_list=0x7fa050821548, join_table=0x7fa0508cd960) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_show.cc:7904
#18 0x0000000000842fda in get_schema_tables_result (join=0x7fa0508ccbd0, executed_place=PROCESSED_BY_JOIN_EXEC) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_show.cc:8005
#19 0x0000000000815482 in JOIN::prepare_result (this=0x7fa0508ccbd0, columns_list=0x7fa0cb59d980) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_select.cc:823
#20 0x00000000007b1d33 in JOIN::exec (this=0x7fa0508ccbd0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_executor.cc:116
#21 0x0000000000815f7b in mysql_execute_select (thd=0x7fa0b877a000, select_lex=0x7fa0b877cc60, free_join=true) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_select.cc:1100
#22 0x0000000000816277 in mysql_select (thd=0x7fa0b877a000, tables=0x7fa050821548, wild_num=0, fields=..., conds=0x0, order=0x7fa0b877ce28, group=0x7fa0b877cd60, having=0x0, select_options=2684619520, result=0x7fa050822e90, unit=0x7fa0b877c618, select_lex=0x7fa0b877cc60) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_select.cc:1221
#23 0x0000000000814306 in handle_select (thd=0x7fa0b877a000, result=0x7fa050822e90, setup_tables_done_option=0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_select.cc:110
#24 0x00000000007ec317 in execute_sqlcom_select (thd=0x7fa0b877a000, all_tables=0x7fa050821548) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_parse.cc:5634
#25 0x00000000007e480e in mysql_execute_command (thd=0x7fa0b877a000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_parse.cc:2989
#26 0x00000000007ef059 in mysql_parse (thd=0x7fa0b877a000, rawbuf=0x7fa050821010 "select partition_method,partition_expression,partition_description from information_schema.partitions", length=101, parser_state=0x7fa0cb59edf0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_parse.cc:6922
#27 0x00000000007e0ecf in dispatch_command (command=COM_QUERY, thd=0x7fa0b877a000, packet=0x7fa0b1be6001 "select partition_method,partition_expression,partition_description from information_schema.partitions", packet_length=101) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_parse.cc:1434
#28 0x00000000007dfded in do_command (thd=0x7fa0b877a000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_parse.cc:1051
#29 0x00000000007a7d0d in do_handle_one_connection (thd_arg=0x7fa0b877a000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_connect.cc:1532
#30 0x00000000007a7815 in handle_one_connection (arg=0x7fa0b877a000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_connect.cc:1443
#31 0x0000000000dcc8ac in pfs_spawn_thread (arg=0x7fa0c73ff740) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/storage/perfschema/pfs.cc:1860
#32 0x00007fa0cafe8df5 in start_thread (arg=0x7fa0cb5a0700) at pthread_create.c:308
#33 0x00007fa0c9cb21ad in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PS-889