** Testcase
DROP DATABASE test;CREATE DATABASE test;USE test;
set storage_engine=tokudb;
CREATE TABLE t1(c1 VARCHAR(1)NOT NULL);
ALTER TABLE t1 ROW_FORMAT=FIXED KEY_BLOCK_SIZE=0;
INSERT INTO t1 VALUES();
ALTER TABLE t1 FORCE;
SELECT AVG(c1)AS value FROM t1;
** Startup
--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 0x00007f4e77031771 in pthread_kill () from /lib64/libpthread.so.0
#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 0x0000000000672e45 in Field::is_null (this=0x7f4e3ec9c840, row_offset=0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/
percona-server-5.6.23-72.1/sql/field.h:894
#5 0x000000000065d7c1 in Item_field::val_real (this=0x7f4e3ec210d0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-
server-5.6.23-72.1/sql/item.cc:2699
#6 0x00000000006ed605 in Aggregator_simple::arg_val_real (this=0x7f4e3ec22c68) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-
64/percona-server-5.6.23-72.1/sql/item_sum.cc:1543
#7 0x00000000006ed02d in Item_sum_sum::add (this=0x7f4e3ec211d8) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-ser
ver-5.6.23-72.1/sql/item_sum.cc:1436
#8 0x00000000006edf5e in Item_sum_avg::add (this=0x7f4e3ec211d8) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-ser
ver-5.6.23-72.1/sql/item_sum.cc:1702
#9 0x00000000006f57cd in Aggregator_simple::add (this=0x7f4e3ec22c68) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/item_sum.h:656
#10 0x00000000006f5659 in Item_sum::aggregator_add (this=0x7f4e3ec211d8) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/item_sum.h:500
#11 0x00000000006f54a4 in Item_sum::reset_and_add (this=0x7f4e3ec211d8) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/item_sum.h:408
#12 0x00000000007b329c in init_sum_functions (func_ptr=0x7f4e3ec21f60, end_ptr=0x7f4e3ec21f68) 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:508
#13 0x00000000007b882f in end_send_group (join=0x7f4e3ec21a58, join_tab=0x7f4e3ec22a68, end_of_records=false) 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:2971
#14 0x00000000007b53e6 in evaluate_join_record (join=0x7f4e3ec21a58, join_tab=0x7f4e3ec22768) 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:1601
#15 0x00000000007b49c8 in sub_select (join=0x7f4e3ec21a58, join_tab=0x7f4e3ec22768, end_of_records=false) 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:1276
#16 0x00000000007b4295 in do_select (join=0x7f4e3ec21a58) 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:933
#17 0x00000000007b21f1 in JOIN::exec (this=0x7f4e3ec21a58) 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:194
#18 0x0000000000815f7b in mysql_execute_select (thd=0x7f4e64f7a000, select_lex=0x7f4e64f7cc60, 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
#19 0x0000000000816277 in mysql_select (thd=0x7f4e64f7a000, tables=0x7f4e3ec21418, wild_num=0, fields=..., conds=0x0, order=0x7f4e64f7ce28, group=0x7f4e64f7cd60, having=0x0, select_options=2147748608, result=0x7f4e3ec21a30, unit=0x7f4e64f7c618, select_lex=0x7f4e64f7cc60) 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
#20 0x0000000000814306 in handle_select (thd=0x7f4e64f7a000, result=0x7f4e3ec21a30, 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
#21 0x00000000007ec317 in execute_sqlcom_select (thd=0x7f4e64f7a000, all_tables=0x7f4e3ec21418) 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
#22 0x00000000007e480e in mysql_execute_command (thd=0x7f4e64f7a000) 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
#23 0x00000000007ef059 in mysql_parse (thd=0x7f4e64f7a000, rawbuf=0x7f4e3ec21010 "SELECT AVG(c1)AS value FROM t1", length=30, parser_state=0x7f4e775e0df0) 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
#24 0x00000000007e0ecf in dispatch_command (command=COM_QUERY, thd=0x7f4e64f7a000, packet=0x7f4e5e3b9001 "", packet_length=30) 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
#25 0x00000000007dfded in do_command (thd=0x7f4e64f7a000) 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
#26 0x00000000007a7d0d in do_handle_one_connection (thd_arg=0x7f4e64f7a000) 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
#27 0x00000000007a7815 in handle_one_connection (arg=0x7f4e64f7a000) 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
#28 0x0000000000dcc8ac in pfs_spawn_thread (arg=0x7f4e7503c740) 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
#29 0x00007f4e7702cdf3 in start_thread () from /lib64/libpthread.so.0
#30 0x00007f4e75cf61ad in clone () from /lib64/libc.so.6
Please report on the TokuDB JIRA