** Testcase
DROP DATABASE test;CREATE DATABASE test;USE test;
set storage_engine=tokudb;
set autocommit = 0;
CREATE TABLE t1(c1 REAL NULL, c2 BINARY(25) NOT NULL, c3 INT(4) NULL, c4 BINARY(15) NOT NULL PRIMARY KEY, c5 REAL NOT NULL UNIQUE KEY,c6 FIXED(10,8) NOT NULL DEFAULT 3.141592);
OPTIMIZE TABLE t1;
DROP TABLE t1;
SET default_storage_engine = DEFAULT;
CREATE TABLE t1 (a BIT(1), b INT) engine=tokudb;
ALTER TABLE t1 ADD COLUMN ch2 CHAR(30) DEFAULT "alter table";
SET STATEMENT myisam_repair_threads=0 FOR OPTIMIZE TABLE t1;
optimize TABLE t1;
DROP TABLE t1;
CREATE TABLE t1 (f1 bigint(20) NOT NULL default '0', f2 int(11) NOT NULL default '0', f3 bigint(20) NOT NULL default '0', f4 varchar(255) NOT NULL default '', PRIMARY KEY (f1), KEY key1 (f4), KEY key2 (f2));
** 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.
#0 0x00007f09de395771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000abb47a in my_write_core (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/my
sys/stacktrace.c:422
#2 0x00000000007312c3 in handle_fatal_signal (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-7
2.1/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x00007f09dcf995c9 in raise () from /lib64/libc.so.6
#5 0x00007f09dcf9acd8 in abort () from /lib64/libc.so.6
#6 0x0000000000b692a2 in ut_list_prepend<ut_list_base<os_event>, os_event> (list=..., elem=..., offset=112) at /mnt/workspace/percona-server-5.6-binaries-d
ebug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/storage/innobase/include/ut0lst.h:131
#7 0x0000000000b6884a in os_event_create () at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/stora
ge/innobase/os/os0sync.cc:417
#8 0x0000000000c3b055 in rw_lock_create_func (lock=0x7f09a5572200, level=900, cfile_name=0x10bbed8 "/mnt/workspace/percona-server-5.6-binaries-debug-yassl/
label_exp/centos6-64/percona-server-5.6.23-72.1/storage/innobase/dict/dict0dict.cc", cline=349, cmutex_name=0x10bbf86 "table->stats_latch") at /mnt/workspac
e/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/storage/innobase/sync/sync0rw.cc:268
#9 0x0000000000cf15d9 in pfs_rw_lock_create_func (key=30, lock=0x7f09a5572200, level=900, cfile_name=0x10bbed8 "/mnt/workspace/percona-server-5.6-binaries-
debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/storage/innobase/dict/dict0dict.cc", cline=349, cmutex_name=0x10bbf86 "table->stats_latch") at /
mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/storage/innobase/include/sync0rw.ic:819
#10 0x0000000000cf44d7 in dict_table_stats_latch_alloc (table_void=0x7f09a5473c78) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/cento
s6-64/percona-server-5.6.23-72.1/storage/innobase/dict/dict0dict.cc:349
#11 0x0000000000d02c08 in os_once::do_or_wait_for_done (state=0x7f09a5473d84, do_func=0xcf443d <dict_table_stats_latch_alloc(void*)>, do_func_arg=0x7f09a547
3c78) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/storage/innobase/include/os0once.h:93
#12 0x0000000000cf4643 in dict_table_stats_lock (table=0x7f09a5473c78, latch_mode=2) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/cen
tos6-64/percona-server-5.6.23-72.1/storage/innobase/dict/dict0dict.cc:425
#13 0x0000000000cf382f in dict_stats_deinit (table=0x7f09a5473c78) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-se
rver-5.6.23-72.1/storage/innobase/include/dict0stats.ic:190
#14 0x0000000000cf4b06 in dict_table_close (table=0x7f09a5473c78, dict_locked=1, try_drop=0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/storage/innobase/dict/dict0dict.cc:585
#15 0x0000000000be0a5a in row_create_index_for_mysql (index=0x7f09a54e2378, trx=0x7f09a553fa78, field_lengths=0x7f09a480e068) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/storage/innobase/row/row0mysql.cc:2529
#16 0x0000000000adf422 in create_index (trx=0x7f09a553fa78, form=0x7f09de941970, flags=1, table_name=0x7f09de940d30 "test/t1", key_num=0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/storage/innobase/handler/ha_innodb.cc:9578
#17 0x0000000000ae084d in ha_innobase::create (this=0x7f09a5441f10, name=0x7f09de943930 "./test/t1", form=0x7f09de941970, create_info=0x7f09de944240) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/storage/innobase/handler/ha_innodb.cc:10347
#18 0x0000000000647dee in handler::ha_create (this=0x7f09a5441f10, name=0x7f09de943930 "./test/t1", form=0x7f09de941970, info=0x7f09de944240) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/handler.cc:4722
#19 0x0000000000648c93 in ha_create_table (thd=0x7f09cc37a000, path=0x7f09de943930 "./test/t1", db=0x7f09a54957c0 "test", table_name=0x7f09a5495228 "t1", create_info=0x7f09de944240, update_create_info=false, is_temp_table=false) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/handler.cc:5069
#20 0x00000000008c260e in rea_create_table (thd=0x7f09cc37a000, path=0x7f09de943930 "./test/t1", db=0x7f09a54957c0 "test", table_name=0x7f09a5495228 "t1", create_info=0x7f09de944240, create_fields=..., keys=3, key_info=0x7f09a5496b48, file=0x7f09a5496670, no_ha_table=false) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/unireg.cc:527
#21 0x0000000000855827 in create_table_impl (thd=0x7f09cc37a000, db=0x7f09a54957c0 "test", table_name=0x7f09a5495228 "t1", path=0x7f09de943930 "./test/t1", create_info=0x7f09de944240, alter_info=0x7f09de943ce0, internal_tmp_table=false, select_field_count=0, no_ha_table=false, is_trans=0x7f09de943bbe, key_info=0x7f09de943b38, key_count=0x7f09de943b34) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_table.cc:4977
#22 0x0000000000855cf2 in mysql_create_table_no_lock (thd=0x7f09cc37a000, db=0x7f09a54957c0 "test", table_name=0x7f09a5495228 "t1", create_info=0x7f09de944240, alter_info=0x7f09de943ce0, select_field_count=0, is_trans=0x7f09de943bbe) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_table.cc:5087
#23 0x0000000000855e35 in mysql_create_table (thd=0x7f09cc37a000, create_table=0x7f09a5495260, create_info=0x7f09de944240, alter_info=0x7f09de943ce0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_table.cc:5139
#24 0x00000000007e5c13 in mysql_execute_command (thd=0x7f09cc37a000) 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:3500
#25 0x00000000007ef059 in mysql_parse (thd=0x7f09cc37a000, rawbuf=0x7f09a5495010 "CREATE TABLE t1 (f1 bigint(20) NOT NULL default '0', f2 int(11) NOT NULL default '0', f3 bigint(20) NOT NULL default '0', f4 varchar(255) NOT NULL default '', PRIMARY KEY (f1), KEY key1 (f4), KEY key2 (f2))", length=206, parser_state=0x7f09de944df0) 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
#26 0x00000000007e0ecf in dispatch_command (command=COM_QUERY, thd=0x7f09cc37a000, packet=0x7f09c57db001 "CREATE TABLE t1 (f1 bigint(20) NOT NULL default '0', f2 int(11) NOT NULL default '0', f3 bigint(20) NOT NULL default '0', f4 varchar(255) NOT NULL default '', PRIMARY KEY (f1), KEY key1 (f4), KEY key2 (f2))", packet_length=206) 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
#27 0x00000000007dfded in do_command (thd=0x7f09cc37a000) 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
#28 0x00000000007a7d0d in do_handle_one_connection (thd_arg=0x7f09cc37a000) 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
#29 0x00000000007a7815 in handle_one_connection (arg=0x7f09cc37a000) 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
#30 0x0000000000dcc8ac in pfs_spawn_thread (arg=0x7f09d7b467e0) 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
#31 0x00007f09de390df3 in start_thread () from /lib64/libpthread.so.0
#32 0x00007f09dd05a1ad in clone () from /lib64/libc.so.6
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/