Note that any clause, and any mysqld option may be "too much", but it would take more time to debug. Hope this is enough to go on. Note that even the full testcase may be "too much" - i.e. some race always present caused by server options, sql independent, for example
Sporadic testcase reduced to:
DROP DATABASE test;CREATE DATABASE test;USE test; innodb_ log_checkpoint_ now = TRUE; SCHEMA. INNODB_ CHANGED_ PAGES;
CREATE TABLE t2 (c1 BLOB, c4 VARBINARY ( 32 ) , KEY (c1(1))) ENGINE = InnoDB ROW_FORMAT = FIXED KEY_BLOCK_SIZE = 4;
SET @@global.
SELECT COUNT(*) FROM INFORMATION_
With these mysqld options:
MYEXTRA= "--log- output= none --sql_mode= ONLY_FULL_ GROUP_BY --utility- user-password= test --innodb_ change_ buffering= all --innodb_ fast_shutdown= 2 --innodb_ flush_method= O_DSYNC --innodb_ log_buffer_ size=1048576 --innodb_ log_files_ in_group= 3 --innodb_ max_changed_ pages=0 --innodb_ track_changed_ pages=1 --query_ cache_type= 1 --readonly- key-cache- block-size= 0 --readonly- loose-max- connect- errors= 0 --secure- file-priv= /tmp --skip- innodb_ doublewrite --slow_query_log --thread_ handling= pool-of- threads --transaction- isolation= REPEATABLE- READ --userstat --utility- user-password= test --utility- user-schema- access= mysqlinformatio n_schema --hidden- key-buffer- size=1 --innodb_ purge_threads= 4 --innodb_ adaptive_ hash_index_ partitions= 8 --innodb_ buffer_ pool_instances= 1 " "/ssd/Percona- Server- 5.6.13- rc60.5- 443-debug. Linux.x86_ 64"
MYBASE=
Note that any clause, and any mysqld option may be "too much", but it would take more time to debug. Hope this is enough to go on. Note that even the full testcase may be "too much" - i.e. some race always present caused by server options, sql independent, for example