** Testcase
DROP DATABASE test;CREATE DATABASE test;USE test;
set tokudb_optimize_index_name='c';
set session log_slow_verbosity=8;
SET STATEMENT sort_buffer_size=150000 FOR SELECT * FROM t1 ;
set @@log_slow_verbosity=default;
set tokudb_optimize_index_name='primary';
select query_id, count(*), sum(duration) from information_schema.profiling group by query_id; ;
select query_id, count(*), sum(duration) from information_schema.profiling group by query_id; ;
** Startup option
--plugin-load=tokudb=ha_tokudb.so
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 (i.e. non-tarball/non-build-binary-distribution) distributions 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.
** GDB info
#0 0x00007fe4cda7a771 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 0x000000000080c270 in Queue<PROF_MEASUREMENT>::iterator_value (this=0x7fe495c1b090, current=0x31300000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_profile.h:156
#5 0x000000000080b264 in PROFILING::fill_statistics_info (this=0x7fe4bbb79be0, thd_arg=0x7fe4bbb78000, tables=0x7fe495c937d0, 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_profile.cc:688
#6 0x00000000008097d3 in fill_query_profile_statistics_info (thd=0x7fe4bbb78000, tables=0x7fe495c937d0, 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_profile.cc:58
#7 0x0000000000842c0b in do_fill_table (thd=0x7fe4bbb78000, table_list=0x7fe495c937d0, join_table=0x7fe495cf3530) 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
#8 0x0000000000842fda in get_schema_tables_result (join=0x7fe495cf2888, 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
#9 0x0000000000815482 in JOIN::prepare_result (this=0x7fe495cf2888, columns_list=0x7fe4ce02a980) 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
#10 0x00000000007b1d33 in JOIN::exec (this=0x7fe495cf2888) 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
#11 0x0000000000815f7b in mysql_execute_select (thd=0x7fe4bbb78000, select_lex=0x7fe4bbb7ac60, 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
#12 0x0000000000816277 in mysql_select (thd=0x7fe4bbb78000, tables=0x7fe495c937d0, wild_num=0, fields=..., conds=0x0, order=0x7fe4bbb7ae28, group=0x7fe4bbb7ad60, having=0x0, select_options=2684619520, result=0x7fe495c94db8, unit=0x7fe4bbb7a618, select_lex=0x7fe4bbb7ac60) 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
#13 0x0000000000814306 in handle_select (thd=0x7fe4bbb78000, result=0x7fe495c94db8, 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
#14 0x00000000007ec317 in execute_sqlcom_select (thd=0x7fe4bbb78000, all_tables=0x7fe495c937d0) 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
#15 0x00000000007e480e in mysql_execute_command (thd=0x7fe4bbb78000) 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
#16 0x00000000007ef059 in mysql_parse (thd=0x7fe4bbb78000, rawbuf=0x7fe495c93010 "select query_id, count(*), sum(duration) from information_schema.profiling group by query_id", length=92, parser_state=0x7fe4ce02bdf0) 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
#17 0x00000000007e0ecf in dispatch_command (command=COM_QUERY, thd=0x7fe4bbb78000, packet=0x7fe4b4fb6001 "select query_id, count(*), sum(duration) from information_schema.profiling group by query_id", packet_length=92) 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
#18 0x00000000007dfded in do_command (thd=0x7fe4bbb78000) 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
#19 0x00000000007a7d0d in do_handle_one_connection (thd_arg=0x7fe4bbb78000) 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
#20 0x00000000007a7815 in handle_one_connection (arg=0x7fe4bbb78000) 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
#21 0x0000000000dcc8ac in pfs_spawn_thread (arg=0x7fe4c73417e0) 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
#22 0x00007fe4cda75df5 in start_thread (arg=0x7fe4ce02d700) at pthread_create.c:308
#23 0x00007fe4cc73f1ad 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-892