Comment 15 for bug 1193332

Revision history for this message
Roel Van de Paar (roel11) wrote :

Sporadic testcase reduced to:

DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t2 (c1 BLOB, c4 VARBINARY ( 32 ) , KEY (c1(1))) ENGINE = InnoDB ROW_FORMAT = FIXED KEY_BLOCK_SIZE = 4;
SET @@global.innodb_log_checkpoint_now = TRUE;
SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_CHANGED_PAGES;

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=mysqlinformation_schema --hidden-key-buffer-size=1 --innodb_purge_threads=4 --innodb_adaptive_hash_index_partitions=8 --innodb_buffer_pool_instances=1 "
MYBASE="/ssd/Percona-Server-5.6.13-rc60.5-443-debug.Linux.x86_64"

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