Comment 9 for bug 1441139

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

This testcase:

INSTALL PLUGIN scalability_metrics SONAME 'scalability_metrics.so';
DROP DATABASE transforms;CREATE DATABASE transforms;DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(c1 SMALLINT ZEROFILL NULL);
CREATE TABLE t5(c1 REAL NOT NULL);
SET GLOBAL scalability_metrics_control = OFF;
SET GLOBAL scalability_metrics_control = ON;
CREATE TABLE t577 (c1 VARCHAR(10));
Connection ID (thread ID): 6; ;

Can crash the server. It can also produce a GLIBC crash. But it is very sporadic, and hard to trigger. Here are the mysqld options used;

--log-output=none --sql_mode=ONLY_FULL_GROUP_BY --plugin-load-add=audit_log=audit_log.so --plugin-load-add=tokudb=ha_tokudb.so --init-file=/home/roel/percona-qa/plugins.sql --tokudb-check-jemalloc=0 --performance-schema-max-rwlock-instances=0 --innodb-max-dirty-pages-pct-lwm=1 --log-slow-filter=filesort_on_disk --innodb-ft-sort-pll-degree=-1125899906842624 --tokudb_fanout=32 --tokudb-read-status-frequency=0 --tokudb-fs-reserve-percent=24 --tokudb_fanout=64 --tokudb_block_size=56732 --tokudb-cleaner-iterations=2"

Though likely many (especially the TokuDB ones) are not required. Sorry to not be more specific then this, it was not straightforward to get this far.