Comment 2 for bug 1217354

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

Testcase (sporadic, needs to be run in high concurrency, pasted here to get an idea of queries involved)

DROP DATABASE transforms;CREATE DATABASE transforms;DROP DATABASE test;CREATE DATABASE test;USE test;
SELECT CONNECTION_ID();
SELECT CASE WHEN table_schema = 'information_schema' THEN 'INFORMATION_SCHEMA' ELSE table_schema END, table_name, CASE WHEN table_type = 'BASE TABLE' THEN''WHEN table_type = 'VIEW' THEN''WHEN table_type = 'SYSTEM VIEW' then''ELSE''END, column_name, CASE WHEN column_key = 'PRI' THEN''WHEN column_key = 'MUL' THEN''WHEN column_key = 'UNI' THEN''ELSE''END FROM information_schema.tables INNER JOIN information_schema.columns USING(table_schema, table_name) WHERE table_name <> 'DUMMY';
SELECT collation_name,character_set_name FROM information_schema.collations;

And, server was running with these parameters:

--loose-new --sql-mode=no_engine_substitution --relay-log=slave-relay-bin --loose-innodb --secure-file-priv= --max-allowed-packet=16Mb --loose-innodb-status-file=1 --master-retry-count=65535 --loose-debug-assert-if-crashed-table --loose-debug-assert-on-error --skip-name-resolve --log-output=none --sql_mode=ONLY_FULL_GROUP_BY --innodb_file_per_table=1 --innodb_adaptive_hash_index_partitions=1 --core