main.show_explain 'innodb_plugin' w1 [ fail ] timeout after 2700 seconds
|
Test ended at 2013-04-10 17:39:24
|
|
Test case timeout after 2700 seconds
|
|
== /dev/shm/var_auto_EmqH/1/log/show_explain.log ==
|
Warnings:
|
Note 1003 select count(*) from t1 A, t1 B where B.key1 < A.col2 and A.col1=3 AND B.col2 + 1 < 100
|
show explain for $thr2;
|
id select_type table type possible_keys key key_len ref rows Extra
|
1 SIMPLE A ALL NULL NULL NULL NULL 100 Using where
|
1 SIMPLE B ALL key1 NULL NULL NULL 100 Range checked for each record (index map: 0x1)
|
Warnings:
|
Note 1003 select count(*) from t1 A, t1 B where B.key1 < A.col2 and A.col1=3 AND B.col2 + 1 < 100
|
show explain for $thr2;
|
id select_type table type possible_keys key key_len ref rows Extra
|
1 SIMPLE A ALL NULL NULL NULL NULL 100 Using where
|
1 SIMPLE B ALL key1 NULL NULL NULL 100 Range checked for each record (index map: 0x1)
|
Warnings:
|
Note 1003 select count(*) from t1 A, t1 B where B.key1 < A.col2 and A.col1=3 AND B.col2 + 1 < 100
|
show explain for $thr2;
|
id select_type table type possible_keys key key_len ref rows Extra
|
1 SIMPLE A ALL NULL NULL NULL NULL 100 Using where
|
1 SIMPLE B ALL key1 NULL NULL NULL 100 Range checked for each record (index map: 0x1)
|
Warnings:
|
Note 1003 select count(*) from t1 A, t1 B where B.key1 < A.col2 and A.col1=3 AND B.col2 + 1 < 100
|
|
== /dev/shm/var_auto_EmqH/1/tmp/analyze-timeout-mysqld.1.err ==
|
mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/dev/shm/var_auto_EmqH/tmp/1/mysqld.1.sock' (111 "Connection refused")
|
|
|
- saving '/dev/shm/var_auto_EmqH/1/log/main.show_explain-innodb_plugin/' to '/dev/shm/var_auto_EmqH/log/main.show_explain-innodb_plugin/'
|
|
Retrying test main.show_explain, attempt(2/3)...
|
|
***Warnings generated in error logs during shutdown after running tests: main.events_trans main.auto_increment_ranges_innodb main.alter_table_trans main.func_rollback main.foreign_key main.func_analyse main.endspace main.parser_bug21114_innodb main.range_vs_index_merge_innodb main.consistent_snapshot main.innodb_ext_key main.cache_innodb main.range main.plugin_innodb main.loaddata_autocom_innodb main.mysqlcheck innodb.innodb_prefix_index_restart_server main.group_min_max_innodb main.information_schema_inno main.row-checksum main.innodb_bug878769 main.index_intersect_innodb main.innodb_icp innodb.innodb_trx_weight main.deadlock_innodb main.flush_block_commit main.read_only_innodb main.function_defaults main.flush-innodb main.innodb_utf8 main.alter_table_online main.multi_update_innodb main.flush_read_lock main.innodb_mrr_cpk main.group_by_innodb main.lowercase_table2 main.innodb_mysql_sync main.flush_read_lock_kill main.merge_innodb main.commit main.range_mrr_icp innodb.mdev-117 main.events_trans_notembedded main.func_group_innodb main.show_explain main.join_outer_innodb main.group_by
|
|
Attempting backtrace. You can use the following information to find out
|
|
main.show_explain 'innodb_plugin' w1 [ retry-pass ] 4999
|
Bug
Major