# Version 10.5-6a7e646d-asan # perl ./mtr bug.latch1 --mem --mysqld=--innodb --mysqld=--default-storage-engine=InnoDB --mysqld=--partition --mysqld=--loose-innodb-stats-persistent=on --mysqld=--character-set-server=utf8 --mysqld=--max-allowed-packet=128M --mysqld=--innodb-buffer-pool-size=128M --mysqld=--innodb-log-file-size=48M --mysqld=--log_bin_trust_function_creators=OFF --mysqld=--key_buffer_size=128M --mysqld=--performance-schema=OFF --mysqld=--use_stat_tables=PREFERABLY --mysqld=--log_output=FILE --mysqld=--max-statement-time=20 --mysqld=--innodb-lock-wait-timeout=5 --mysqld=--log-bin --mysqld=--log_bin_trust_function_creators=1 --mysqld=--innodb-buffer-pool-size=256M --mysqld=--loose-max-statement-time=10 --mysqld=--innodb-lock-wait-timeout=3 --mysqld=--lock-wait-timeout=5 --sleep=1 --mysqld=--lock-wait-timeout=0 --repeat=200 --disable_abort_on_error CREATE USER rqg@localhost; GRANT ALL ON *.* TO rqg@localhost; --let $con4_id= `SELECT CONNECTION_ID() AS con4` --connect (con6_0,localhost,rqg,,test) SHOW VARIABLES; SHOW SLAVE HOSTS; --disconnect con6_0 --connect (con7_0,localhost,rqg,,test) --enable_reconnect --let $con7_id= `SELECT CONNECTION_ID() AS con7` SHOW VARIABLES; SHOW SLAVE HOSTS; SELECT PLUGIN_NAME, PLUGIN_LIBRARY FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_LIBRARY IS NOT NULL; --disconnect con7_0 --connect (con10_0,localhost,rqg,,test) --enable_reconnect --connect (con12_0,localhost,rqg,,test) --enable_reconnect SELECT DATABASE(); --connect (con13_0,localhost,rqg,,test) --connect (con15_0,localhost,rqg,,test) --enable_reconnect --let $con15_id= `SELECT CONNECTION_ID() AS con15` --connection con10_0 --enable_reconnect SHOW WARNINGS; --connection con12_0 CREATE /* QNO 115 CON_ID 12 */ TABLE IF NOT EXISTS g ( `col_int_nokey` INTEGER, `col_int_key` INTEGER NOT NULL, KEY (`col_int_key`) ) ENGINE = MYISAM PARTITION BY KEY(`col_int_key`) PARTITIONS 4; --connection con15_0 --send CREATE /* QNO 120 CON_ID 15 */ TABLE IF NOT EXISTS p ( `col_int_nokey` INTEGER, `col_int_key` INTEGER NOT NULL, KEY (`col_int_key`) ) ENGINE = MYISAM PARTITION BY KEY(`col_int_key`) PARTITIONS 1; --connection con10_0 --connection con12_0 SHOW WARNINGS; --send CREATE /* QNO 343 CON_ID 12 */ TABLE IF NOT EXISTS app_periods_t7 (`id` INT, `f` MEDIUMTEXT /*!100403 UNIQUE */, `s` DATE, `e` DATE, PERIOD FOR `p`(`s`,`e`) ); --connection con15_0 --reap --connection con10_0 --send SET /* QNO 353 CON_ID 10 */ GLOBAL rpl_semi_sync_slave_kill_conn_timeout= 100, table_open_cache= 10, key_cache_division_limit= 27, innodb_stats_persistent_sample_pages= 2, key_cache_file_hash_size= 15755, innodb_monitor_reset_all= '%'; --connection con12_0 --reap SELECT DISTINCT CASE WHEN table_schema = 'information_schema' THEN 'INFORMATION_SCHEMA' ELSE table_schema END AS table_schema, table_name, CASE WHEN table_type = 'BASE TABLE' THEN 'table' WHEN table_type = 'SYSTEM VERSIONED' THEN 'table' WHEN table_type = 'SEQUENCE' THEN 'table' WHEN table_type = 'VIEW' THEN 'view' WHEN table_type = 'SYSTEM VIEW' then 'view' ELSE 'misc' END AS table_type, column_name, CASE WHEN column_key = 'PRI' THEN 'primary' WHEN column_key IN ('MUL','UNI') THEN 'indexed' ELSE 'ordinary' END AS column_key, CASE WHEN data_type IN ('bit','tinyint','smallint','mediumint','int','bigint') THEN 'int' WHEN data_type IN ('float','double') THEN 'float' WHEN data_type IN ('decimal') THEN 'decimal' WHEN data_type IN ('datetime','timestamp') THEN 'timestamp' WHEN data_type IN ('char','varchar','binary','varbinary') THEN 'char' WHEN data_type IN ('tinyblob','blob','mediumblob','longblob') THEN 'blob' WHEN data_type IN ('tinytext','text','mediumtext','longtext') THEN 'blob' ELSE data_type END AS data_type_normalized, data_type, character_maximum_length, table_rows FROM information_schema.tables INNER JOIN information_schema.columns USING(table_schema,table_name) WHERE table_name <> 'DUMMY' AND table_schema NOT IN ('performance_schema','information_schema','mysql'); --connection con13_0 --connection con12_0