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