Race condition between ANALYZE TABLE and STATS_AUTO_RECALC

innodb.innodb_stats 'innodb_plugin'      w3 [ fail ]

        Test ended at 2016-06-28 07:48:15

CURRENT_TEST: innodb.innodb_stats

--- /usr/share/mysql/mysql-test/suite/innodb/r/innodb_stats.result	2016-06-28 04:58:03.000000000 +0300

+++ /run/shm/var/3/log/innodb_stats.reject	2016-06-28 07:48:14.987555677 +0300

@@ -174,11 +174,11 @@

 stat_name IN ('n_diff_pfx01', 'n_diff_pfx02', 'n_leaf_pages', 'size')

 ORDER BY stat_name;

 stat_name	n_diff_pfx01

-stat_value	1

+stat_value	0

 sample_size	1

 stat_description	a

 stat_name	n_diff_pfx02

-stat_value	3

+stat_value	0

 sample_size	1

 stat_description	a,DB_ROW_ID

 stat_name	n_leaf_pages

@@ -226,11 +226,11 @@

 stat_name IN ('n_diff_pfx01', 'n_diff_pfx02', 'n_leaf_pages', 'size')

 ORDER BY stat_name;

 stat_name	n_diff_pfx01

-stat_value	1

+stat_value	0

 sample_size	1

 stat_description	a

 stat_name	n_diff_pfx02

-stat_value	10

+stat_value	0

 sample_size	1

 stat_description	a,DB_ROW_ID

 stat_name	n_leaf_pages

@@ -278,11 +278,11 @@

 stat_name IN ('n_diff_pfx01', 'n_diff_pfx02', 'n_leaf_pages', 'size')

 ORDER BY stat_name;

 stat_name	n_diff_pfx01

-stat_value	2

+stat_value	0

 sample_size	1

 stat_description	a

 stat_name	n_diff_pfx02

-stat_value	2

+stat_value	0

 sample_size	1

 stat_description	a,DB_ROW_ID

 stat_name	n_leaf_pages

@@ -330,11 +330,11 @@

 stat_name IN ('n_diff_pfx01', 'n_diff_pfx02', 'n_leaf_pages', 'size')

 ORDER BY stat_name;

 stat_name	n_diff_pfx01

-stat_value	2

+stat_value	0

 sample_size	1

 stat_description	a

 stat_name	n_diff_pfx02

-stat_value	3

+stat_value	0

 sample_size	1

 stat_description	a,DB_ROW_ID

 stat_name	n_leaf_pages

@@ -382,11 +382,11 @@

 stat_name IN ('n_diff_pfx01', 'n_diff_pfx02', 'n_leaf_pages', 'size')

 ORDER BY stat_name;

 stat_name	n_diff_pfx01

-stat_value	3

+stat_value	0

 sample_size	1

 stat_description	a

 stat_name	n_diff_pfx02

-stat_value	3

+stat_value	0

 sample_size	1

 stat_description	a,DB_ROW_ID

 stat_name	n_leaf_pages

@@ -434,11 +434,11 @@

 stat_name IN ('n_diff_pfx01', 'n_diff_pfx02', 'n_leaf_pages', 'size')

 ORDER BY stat_name;

 stat_name	n_diff_pfx01

-stat_value	3

+stat_value	0

 sample_size	1

 stat_description	a

 stat_name	n_diff_pfx02

-stat_value	5

+stat_value	0

 sample_size	1

 stat_description	a,DB_ROW_ID

 stat_name	n_leaf_pages

@@ -461,7 +461,7 @@

 SEQ_IN_INDEX	1

 COLUMN_NAME	a

 COLLATION	A

-CARDINALITY	5

+CARDINALITY	2

 SUB_PART	NULL

 PACKED	NULL

 NULLABLE	YES

@@ -486,11 +486,11 @@

 stat_name IN ('n_diff_pfx01', 'n_diff_pfx02', 'n_leaf_pages', 'size')

 ORDER BY stat_name;

 stat_name	n_diff_pfx01

-stat_value	5

+stat_value	0

 sample_size	1

 stat_description	a

 stat_name	n_diff_pfx02

-stat_value	10

+stat_value	0

 sample_size	1

 stat_description	a,DB_ROW_ID

 stat_name	n_leaf_pages

@@ -513,7 +513,7 @@

 SEQ_IN_INDEX	1

 COLUMN_NAME	a

 COLLATION	A

-CARDINALITY	10

+CARDINALITY	2

 SUB_PART	NULL

 PACKED	NULL

 NULLABLE	YES

mysqltest: Result length mismatch

 - skipping '/run/shm/var/3/log/innodb.innodb_stats-innodb_plugin/'

Retrying test innodb.innodb_stats, attempt(2/3)...