** Testcase
DROP DATABASE test;CREATE DATABASE test;USE test;
create table t(id int key,b int,key(b));
CREATE TABLE t1(a INT UNSIGNED,b INT UNSIGNED,c BINARY(1),d CHAR (1),e BINARY (1),f VARBINARY(1),g BLOB,h BLOB,id INT,KEY(b),KEY(e))ENGINE=InnoDB;
XA START'';
ALTER TABLE t CHANGE c c c BINARY(1);
explain select max(1)FROM t1 m join t1m;
set tokudb_optimize_index_name='';
delete FROM t1;
SET STATEMENT max_join_size=1000 FOR SELECT * FROM t1;
INSERT INTO t VALUES(0,0,'gMwddufd9hXVe7FM7VH4gCIJB0Hq2AxOaO','9HR6JjHlqaw8iFAZbnfPXod6vhlGdgZPjxg8VuamlaPbQfm7CjKmxTwddObvpRDbg4WtyGOQpbEDyKwajzFP7abdX9j6HlayPtqSqwjdgrzzDP9Ck4bB7sMr56hBcEUzi9IvYMCo1j1KEp6VYsez9pPi4s6YE1TwJfXyubTNtYMTcgTwZrC6u3H1bqTYK5jARDUoqCZiTjAKjYrcBCskuzBe3AIgici7XLEyZlE5TZe5Lc1a1X',0,'iBY4EKD9XN2wVyk592i3kCFH0iqpEFRXo29RaO2lVcIKp3GgVqSbsMRE',0,0,0);
set tokudb_optimize_index_name='';
INSERT INTO t VALUES(0,0,'aOe2tFQNPYpVxeu4RWmY2DSR57hpX81QtSkYQkuZ7HLorxp','','1Y4gp4C3j8H','y4lPep1eCEEyTMecGDgifHp40e8MdQpQQB2MpHwgq1HaF','','',0);
The attached tarball gives the testcase as an exact match of our system,
including some handy utilities
-- Use pquery binary ( ./{epoch}_run_pquery) to reproduce the issue.
$ 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_pquery # 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=tokudb=ha_tokudb.so
** GDB info
#0 0x00007ffc80311771 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x0000000000abe4d2 in my_write_core (sig=11) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.24-72.2/mysys/stacktrace.c:422
#2 0x0000000000731fa3 in handle_fatal_signal (sig=11) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.24-72.2/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x00000000008b29d1 in TABLE::init (this=0x7ffc05d25600, thd=0x7ffc6cb51000, tl=0x7ffc05c211f0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.24-72.2/sql/table.cc:3695
#5 0x0000000000773b4f in open_table (thd=0x7ffc6cb51000, table_list=0x7ffc05c211f0, ot_ctx=0x7ffc808c1720) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.24-72.2/sql/sql_base.cc:3298
#6 0x0000000000775f9c in open_and_process_table (thd=0x7ffc6cb51000, lex=0x7ffc6cb53190, tables=0x7ffc05c211f0, counter=0x7ffc6cb53250, flags=0, prelocking_strategy=0x7ffc808c1820, has_prelocking_list=false, ot_ctx=0x7ffc808c1720) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.24-72.2/sql/sql_base.cc:4725
#7 0x0000000000776e30 in open_tables (thd=0x7ffc6cb51000, start=0x7ffc808c17e0, counter=0x7ffc6cb53250, flags=0, prelocking_strategy=0x7ffc808c1820) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.24-72.2/sql/sql_base.cc:5232
#8 0x000000000077801a in open_normal_and_derived_tables (thd=0x7ffc6cb51000, tables=0x7ffc05c211f0, flags=0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.24-72.2/sql/sql_base.cc:5941
#9 0x00000000007c3baa in mysql_insert (thd=0x7ffc6cb51000, table_list=0x7ffc05c211f0, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.24-72.2/sql/sql_insert.cc:750
#10 0x00000000007e7de1 in mysql_execute_command (thd=0x7ffc6cb51000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.24-72.2/sql/sql_parse.cc:3897
#11 0x00000000007f01aa in mysql_parse (thd=0x7ffc6cb51000, rawbuf=0x7ffc05c21010 "INSERT INTO t VALUES(0,0,'aOe2tFQNPYpVxeu4RWmY2DSR57hpX81QtSkYQkuZ7HLorxp','','1Y4gp4C3j8H','y4lPep1eCEEyTMecGDgifHp40e8MdQpQQB2MpHwgq1HaF','','',0)", length=148, parser_state=0x7ffc808c2f50) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.24-72.2/sql/sql_parse.cc:6955
#12 0x00000000007e1fba in dispatch_command (command=COM_QUERY, thd=0x7ffc6cb51000, packet=0x7ffc6cb55001 "INSERT INTO t VALUES(0,0,'aOe2tFQNPYpVxeu4RWmY2DSR57hpX81QtSkYQkuZ7HLorxp','','1Y4gp4C3j8H','y4lPep1eCEEyTMecGDgifHp40e8MdQpQQB2MpHwgq1HaF','','',0);", packet_length=149) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.24-72.2/sql/sql_parse.cc:1442
#13 0x00000000007e0e28 in do_command (thd=0x7ffc6cb51000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.24-72.2/sql/sql_parse.cc:1054
#14 0x00000000007a8dad in do_handle_one_connection (thd_arg=0x7ffc66eee000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.24-72.2/sql/sql_connect.cc:1532
#15 0x00000000007a88b5 in handle_one_connection (arg=0x7ffc66eee000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.24-72.2/sql/sql_connect.cc:1443
#16 0x0000000000dcfb11 in pfs_spawn_thread (arg=0x7ffc7d3fe740) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.24-72.2/storage/perfschema/pfs.cc:1860
#17 0x00007ffc8030cdf5 in start_thread (arg=0x7ffc808c4700) at pthread_create.c:308
#18 0x00007ffc7efd61ad 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-907